CSC 241: SQL Database Development

Download as PDF

Class Program

Computer Science

Credits

Weekly Contact Hours

Course ID

092461

Meets Degree Requirements For

Restricted Elective

Description

Explores the use of SQL to create, populate and maintain databases. Topics include entity relations, normalization, referential integrity, join types, selections, insertions, updates, deletes, constraints, views, indexing, stored procedures, triggers, cursors, ER modeling and database design.

Grading Basis

Graded

Prerequisites

CSC 201 or CSC& 141

Course Learning Outcomes

Create a database, insert tables into the database, and populate the tables with data.

Use normalization rules, and referential integrity constraints to design and implement a database.

Perform most database activities (select, create, insert, delete, update) using SQL command language.

Retrieve accurate information from a database using various selection methods.

Use advanced facilities such as triggers, constraints, stored procedures to protect the database from corruption.

Core Topics

Features of a DBMS.
Selection of data from a pre-populated database. Selection methods include filtering, sorting, aggregation, grouping, joins, and sub-queries.
Database and table creation.
Database design using entity relationships, normalization, primary, alternate, and foreign keys.
Database corruption and prevention using constraints and views.
Database population with insert, delete, and update.
Table indexing.
Creating scripts and stored procedures.
Advanced stored procedure topics such as translations, locks, triggers, and cursors.