Fall enrollment is open, and closes September 28. Check out the Academic Term Calendar for more information.

Advanced Structured Query Language (SQL) Syntax

COM SCI X 414.65

For those with SQL knowledge, this course covers advanced SQL statements used in inserting, retrieving, and updating a database. Students learn how to use advanced features of SQL commands and other advanced topics.

READ MORE ABOUT THIS COURSE
Live Online
Starting at $1,095.00
As few as 11 weeks
4.0

What you can learn.

  • Learn advanced use of Structures Query Language
  • Learn advanced use Data Manipulation Language
  • Learn advanced use Data Definition Language

About this course:

Structured Query Language (SQL) is an American National Standards Institute (ANSI) computer language for accessing and manipulating database systems. It works with database programs such as MS Access, DB2, Informix, MS SQL Server, Oracle and Sybase. Designed for those with some knowledge of SQL, this hands-on course covers advanced SQL statements used in inserting, retrieving and updating data in a database. Students learn how to use advanced features of SQL commands, including operators such as IN, AND, OR, BETWEEN, LIKE, DISTINCT, AGGREGATE, CONCATENATE, SUBSTRING, HAVING and others. In addition, instruction covers advanced topics using table joins, sub-queries, "if and" case statements, and cast and convert statements, as well as stored procedures, triggers, functions and cursors. Students also learn how to stream text into a field; retrieve and send results in an email as text or attachment; perform error trapping; and create audit systems, dynamic SQL and pivot tables with hyperlinks.
Prerequisites
COM SCI X 414.61 Introduction to SQL.

Fall 2025 Schedule

Date & Time
Details
Format
 
-
Monday 6:00PM - 9:00PM PT
Available
See Details
Instructor: Erik Kellener
405137
Fee:
$1,095.00
Live Onlineformat icon
Location: Remote Classroom
Notes

Enrollment limited; early enrollment advised. Enrollment deadline: September 28th, 2025

Refund Deadline
Refunds only available from September 02, 2025 to October 05, 2025
Course Requirements
Internet access required to retrieve course materials.
Murach's SQL Server 2016 for Developers
Schedule
Type
Date
Time
Location
Lecture
Mon Sep 22, 2025
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Sep 29, 2025
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Oct 6, 2025
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Oct 13, 2025
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Oct 20, 2025
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Oct 27, 2025
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Nov 3, 2025
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Nov 10, 2025
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Nov 17, 2025
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Nov 24, 2025
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Dec 1, 2025
6:00PM PT - 9:00PM PT
Remote Classroom

Winter 2026 Schedule

Date & Time
Details
Format
 
-
Monday 6:00PM - 9:00PM PT
Future Offering (Opens November 03, 2025 12:00:00 AM)
See Details
Instructor: Erik Kellener
405824
Fee:
$1,095.00
Live Onlineformat icon
Location: Remote Classroom
Notes

Enrollment limited; early enrollment advised. Enrollment deadline: January 11th, 2026.

Refund Deadline
Refunds only available from November 03, 2025 to January 18, 2026
Course Requirements
Internet access required to retrieve course materials.
Murach's SQL Server 2016 for Developers
Schedule
Type
Date
Time
Location
Lecture
Mon Jan 5, 2026
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Jan 12, 2026
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Jan 19, 2026
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Jan 26, 2026
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Feb 2, 2026
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Feb 9, 2026
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Feb 16, 2026
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Feb 23, 2026
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Mar 2, 2026
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Mar 9, 2026
6:00PM PT - 9:00PM PT
Remote Classroom
Lecture
Mon Mar 16, 2026
6:00PM PT - 9:00PM PT
Remote Classroom

This course applies towards the following certificates & specializations…

Ready to start 
your future?

Keep up to date on the latest news and offerings.
 

vector icon of building

Corporate Education

Learn how we can help your organization meet its professional development goals and corporate training needs.

Learn More

vector icon of building

Donate to UCLA Extension

Support our many efforts to reach communities in need.

Innovation Programs

Student Scholarships

Lifelong Learning

See More