None
Course Number:
CSCI 5020
Approved Starting Semester:
Fall 2022
Course Title:
Data Management Applications
Course Description (Bulletin Description):
An introductions to database features and administrator operations including components, instances, tables, indexes, and profiles SQL Server and Oracle. Students will learn database management tools including database deployment, user support, change-control procedures, planning for growth, and technology evaluation.
Prerequisite:
CSCI 5010
Co-requisite:
None
Pre/Co-requisite::
None
Dual-Listed:
None
Course Objectives (Course-level Student Learning Outcomes):
1. The learner will describe the basic database management environment (CO 1) 2. The learner will practice using SQL Server Management Studio (CO 2) 3. The learner will practice using SQL Developer (CO 3) 4. The learner will develop queries with Structured Query Language (SQL) (CO 4) 5. The learner will practice management of transactions and security (CO5)
Topics Covered (In Outline/Calendar):
Database management tools including database deployment, user support, change control procedures, planning for growth, and technology evaluation
Student Learning Outcomes:
Not applicable for this course
Course Coordinator:
Dr. Jiang Li
Instructor-in-charge:
Dr. Yingbing Yu (Spring), Dr. Jiang Li (Fall, Summer)
Previous Professors:
Dr. Yingbing Yu, Dr. Jiang Li
Technologies / Skills:
Database design, Microsoft SQL Database
Textbook(s):
Spring 2025
---------------------------------
Title: MURACH'S SQL SERVER 2022 FOR DEVELOPERS
Edition: 1st
Author: Bryan Syverson, Joel Murach
Publisher: Mike Murach & Associates
ISBN: 9781943873067
---------------------------------
Title: MURACH'S ORACLE SQL AND PL/SQL
Edition: 3RD
Author: Joel Murach
Publisher: Mike Murach & Associates
ISBN: 9781943873197
========================================
Go back to choose another course