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
Classroom
Online
Starting at $1,050.00
As few as 10 weeks
4.0 Credits
3.6 CEUs

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 such database programs 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. You'll also learn how to stream text into a field, retrieve and send results in email as text or attachment, error trapping, create audit system, dynamic SQL, and create pivot tables with hyperlinks. 
Suggested Prerequisites

It is advisable that you complete the following (or equivalent) since they are prerequisites for Advanced Structured Query Language (SQL) Syntax.

COM SCI X414.61 Introduction to SQL

Fall 2018 Schedule

These courses meet in person and make use of an online presence to varying degrees.

Available
-
Tuesday 6:30PM - 10:00PM
Instructor: Ray Han
363167
Fee:
$1,050.00
4 days left. Enroll by Sep 25, 2018
See Details
Notes
Enrollment limited. Enrollment deadline: October 1, 2018. Internet access required. Materials required.
Refund Deadline
No refunds after October 8, 2018
Course Requirements
Internet access required to retrieve course materials.
Schedule
Type
Date
Time
Location
Discussion
Tue Sep 25, 2018
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B05
Discussion
Tue Oct 2, 2018
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B05
Discussion
Tue Oct 9, 2018
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B05
Discussion
Tue Oct 16, 2018
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B05
Discussion
Tue Oct 23, 2018
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B05
Discussion
Tue Oct 30, 2018
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B05
Discussion
Tue Nov 6, 2018
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B05
Discussion
Tue Nov 13, 2018
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B05
Discussion
Tue Nov 20, 2018
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B05
Discussion
Tue Nov 27, 2018
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B05

These courses are fully online, and there are no in-person classroom meetings.

Future Offering (Opens 05 Nov 2018 12:00:00 AM)
-
Instructor: Erik Kellener
364934
Fee:
$1,050.00
See Details
Notes

Enrollment limited. Enrollment deadline: January 13, 2019. Internet access required. Materials required.

Refund Deadline
No refunds after January 20, 2019
Course Requirements
Internet access required to retrieve course materials.

These courses meet in person and make use of an online presence to varying degrees.

Future Offering (Opens 05 Nov 2018 12:00:00 AM)
-
Tuesday 6:30PM - 10:00PM
Instructor: Ray Han
364922
Fee:
$1,050.00
See Details
Notes
Enrollment limited. Enrollment deadline: January 14, 2019. Internet access required. Materials required.
Refund Deadline
No refunds after January 21, 2019
Course Requirements
Internet access required to retrieve course materials.
Schedule
Type
Date
Time
Location
Discussion
Tue Jan 8, 2019
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B04
Discussion
Tue Jan 15, 2019
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B04
Discussion
Tue Jan 22, 2019
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B04
Discussion
Tue Jan 29, 2019
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B04
Discussion
Tue Feb 5, 2019
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B04
Discussion
Tue Feb 12, 2019
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B04
Discussion
Tue Feb 19, 2019
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B04
Discussion
Tue Feb 26, 2019
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B04
Discussion
Tue Mar 5, 2019
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B04
Discussion
Tue Mar 12, 2019
6:30PM - 10:00PM
UCLA Extension 1010 Westwood
UCLA Extension 1010 Westwood B04

Contact Us

Our team members are here to help. Hours: Mon-Fri, 8am-5pm.

This course applies towards the following certificates & specializations…

Keep up to date on the latest news and offerings in Data Analytics & Management

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

Coding Boot Camp

Lifelong Learning