|
|
|
Dec 27, 2024
|
|
2024-2025 College Catalog
|
CIS 236 - Enterprise database and SQL
Credits: 3
Lab/Lecture: Three lecture.
This course covers a broad overview of the multi-user, enterprise relational database paradigm. Topics covered include Structured Query Language (SQL) instruction for data definition, data manipulation, and data retrieval. Develops knowledge and skills required to install commercial and/or opensource enterprise databases, model and create new databases, manage users, authentication, and stored procedures, and develop backup/restore strategies. New paradigms in database management will also be covered including NoSQL and cloud database types.
Course Outcomes:
Students will be able to:
- understand terms related to database design and management;
- understand the objectives of data and information management;
- understand the database development process;
- understand the relational model and relational database management system;
- assess data and information requirements;
- construct conceptual data models;
- develop physical data models for relational database management systems;
- implement relational databases using a RDBMS;
- retrieve data using SQL;
- understand database performance issues;
- understand the basics of data management and administration;
- understand the basics of data warehousing;
- work as a valuable member of a database design and implementation team.
|
|
|
