CS303 - Advanced Applications of SQL

Course Description

Learn how to properly design a relational database and structure tables within the database. Learn the purpose of and how to specify primary and foreign keys. Understand the advantages of referential integrity and how it can affect data maintenance and prevent errors. Learn to plan and create tables and view table information. Understand how to create tables with column constraints and the value of column constraints. Topics include using ALTER TABLE to modify table structure, and creating and understanding the different types of indexes. Additional topics include saving updates to the database using COMMIT and ROLLBACK, copying data between tables, and using PIVOT to transform query results.

In this class, you will learn how to: 

• Apply the basic principles of relational database design. 

• Create and modify tables to enhance the functionality of your database. 

• Insert, update and delete table data to maintain your database. 

• Set rules on table fields to enhance data integrity. 

• Create primary keys and foreign keys to establish relationships between tables. 

• Understand the purpose of referential integrity and how to enforce declarative referential integrity in your database. 

• Beyond these topics, the appendixes to this handout include information on the rules for data normalization, as well as an introduction to database programming using Transact-SQL, SQL 

• Server’s proprietary extension to SQL. 

Applies Towards the Following Certificates

• Data Analysis Certificate : Core Courses
• Database Technology Certificate : Core Courses
• Programming Certificate : Required Courses
• Python Data Analysis Certificate : Electives