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

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. You 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.
Prerequisites
COM SCI X 414.61 Introduction to SQL.

Spring 2020 Schedule

Available Format(s):

These courses are fully online and have no regular meeting times.

Available
-
This section has no set meeting times.
Instructor: Erik Kellener
373239
Fee:
$1,050.00
Still accepting enrollments
See Details
Notes

Enrollment limited. Enrollment deadline: April 5, 2020. Internet access required. Materials required.

Refund Deadline
No refunds after April 03, 2020
Course Requirements
Internet access required to retrieve course materials.
Murach's SQL Server 2016 for Developers

Available Format(s):

These courses are fully online and have no regular meeting times.

Future Offering (Opens April 27, 2020 12:00:00 AM)
-
This section has no set meeting times.
Instructor: Erik Kellener
374759
Fee:
$1,050.00
See Details
Notes

Enrollment limited. Enrollment deadline: June 28, 2020. Internet access required. Materials required.

Refund Deadline
No refunds after June 26, 2020
Course Requirements
Internet access required to retrieve course materials.
Murach's SQL Server 2016 for Developers

Available Format(s):

These courses are fully online and have no regular meeting times.

Future Offering (Opens August 03, 2020 12:00:00 AM)
-
This section has no set meeting times.
Instructor: Erik Kellener
374903
Fee:
$1,050.00
See Details
Notes

Enrollment limited. Enrollment deadline: October 4, 2020. Internet access required. Materials required.

Refund Deadline
No refunds after October 02, 2020
Course Requirements
Internet access required to retrieve course materials.
Murach's SQL Server 2016 for Developers

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