Skip Navigation

Intermediate SQL Programming

A course in the Database Management Certificate Program and an elective course in the Full Stack Web Development 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.

  • Details
  • $820
  • September 26, 2022 to November 20, 2022
  • Delivery Mode: Online
  • Reg#: 00238
  • ID/Units: I&C SCI X450.79  (2.50)
    ( Section 1 )
  • Quarter: Fall 2022

Instructor


Eric Williamson, B.A., MCP, is the data manager for the UCSD Health Strategy Office. He has worked more than 20 years with database technologies and specializes in Microsoft SQL Server, T-SQL, Analysis Services, and SharePoint. He has taught SQL and SharePoint courses since 2013.

Textbook Information

Textbooks for your course may be purchased from any vendor or bookseller of your choice.

No textbook information is available for this course.

Meeting Schedule

EventDateDayStart TimeEnd TimeLocationRoom
START09/26/2022Monday------Online (Access Begins)---
END11/20/2022Sunday------Online (Access Ends)---