You will be assessed a $25 late fee if you are enrolling one day after the course start date. You should work with the instructor to catch up on coursework.
Click OK if you still wish to enroll. Otherwise, click Cancel.
The course you selected is already in progress. You should work with the instructor to catch up on coursework.
Click OK if you still wish to enroll. Otherwise, click Cancel.
Intermediate SQL Programming
An elective course in the Database Management Certificate Program.
Course Description
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.
Prerequisites:I&C SCI X450.72 Introduction to SQL Programming.
Instructor
Textbook Information
Textbooks for your course may be purchased from any vendor or bookseller of your choice.
Optional Textbook(s):
TRAINING KIT: QUERYING MICROSOFT SQL SERVER 2012 9780735666054
T-SQL QUERYING (DEVELOPER REFERENCE) 9780735685048
Meeting Schedule
Event Date Day Start Time End Time Location Room
START 10/18/2021 Monday --- --- Online (Access Begins) ---
END 12/12/2021 Sunday --- --- Online (Access Ends) ---