logo

Introduction to Database Management (DBMS) (CSTP 1201)

In this course students will learn how to manage SQL database systems, including performing basic database administration. Students will learn how to configure a database to support different applications and to perform tasks such as creating users and database schema, applying constraints, setting up access control, assigning memory, defining storage structures and manipulating data. Since database administration does not end after the database is created, students will learn the importance of backup and recovery strategy. Students will become familiar with fundamental concepts in the field such as transnational operations, ACID property, backup and redundancy, data integrity, various database roles (database admin, database programmer, database designer), database normal forms, join operations, and how to perform queries.

course outline


* Note: The CRNs listed below could be restricted to specific program areas.

CRN Fee Campus - Room Day(s) Time Date Instructor
45375
DTN  - TBATo Be Assigned
MM-Monday, T-Tuesday,
W-Wednesday, R-Thursday,
F-Friday, S-Saturday,
U-Sunday

0830 - 1550
06-Jan-2020
to 06-Apr-2020
Nezami, Reza

To register for this course, check the information for your program: