Loading...

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. 

Prerequisites

Intermediate Applications of SQL or equivalent experience.

Applies Towards the Following Certificates

Loading...
Enroll Now - Select a section to enroll in
Section Title
Advanced Applications of SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Feb 27, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Feb 25, 2024
Transfer Request Deadline
Feb 25, 2024
Section Title
Advanced Applications of SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Feb 27, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Feb 25, 2024
Transfer Request Deadline
Feb 25, 2024
Section Title
Advanced Applications of SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Apr 09, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Apr 07, 2024
Transfer Request Deadline
Apr 07, 2024
Section Title
Advanced Applications of SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
Apr 09, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
Apr 07, 2024
Transfer Request Deadline
Apr 07, 2024
Section Title
Advanced Applications of SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
May 28, 2024
Schedule and Location
Contact Hours
6.5
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
May 26, 2024
Transfer Request Deadline
May 26, 2024
Section Title
Advanced Applications of SQL
Type
Discussion
Days
T
Time
8:30AM to 4:00PM
Dates
May 28, 2024
Schedule and Location
Contact Hours
6.5
Location
Delivery Options
Course Fee(s)
Fee non-credit $279.00
Drop Request Deadline
May 26, 2024
Transfer Request Deadline
May 26, 2024
Required fields are indicated by .