|
|
|
Apr 21, 2026
|
|
2026-2027_College Catalog
|
CIS 236 - Enterprise database and SQL
Credits: 4
Lecture: 4
Lab: 0
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:
- List terms related to database design and management;
- Explain the objectives of data and information management;
- Apply the database development process;
- Explain 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;
- Demonstrate the retrieval of data using SQL;
- Apply techniques to identify and mitigate database performance issues;
- Demonstrate the basics of data management and administration;
- Explain the basics of data warehousing;
- Work as a valuable member of a database design and implementation team.
|
|
|
