I&C SCI X450.79

Intermediate SQL Programming

An elective course in the Database Management Certificate Program.

Expand your SQL toolkit in this Intermediate SQL course. SQL is a language used in programming and designed for managing data held in a relational database management system (RDBMS). This intermediate course will focus on using MS SQL Server and T-SQL. Topics covered in this course include: Data aggregation using aggregate functions, writing sub-queries, recursive queries, and common table expressions. Students will also gain experience creating views, stored procedures, functions, and triggers using different looping and database locking mechanisms. Specific areas in the SQL Server database using data file structures, database schemas, setting properties, snapshots, data space and type usage and identity columns will be covered. SQL tuning and use of execution plans will also be addressed. Prerequisites: I&C SCI X450.72 Introduction to SQL Programming.

Icon
Course
Approximate Cost $820
Format Remote
Duration 8 Weeks
Total Credits 2.5

SPRING 2024

4/8/2024 - 6/2/2024
Weeks 8
Delivery Remote
Fee $820
Status Open