Course Detail: SQLC - SQL Programming Series (Online Only Offering)

Introduction to SQL (Online Only Offering): Learn how to write SQL code to create and populate database tables and how to write simple SQL queries that are capable of retrieving vast amounts of information from a database. In this course, you will discover the power of the relational database, how to create and manage database tables, and how to use SQL SELECT statements to precisely pinpoint and retrieve data from a database. 


Available Online Only, September 7-October 1 


Intermediate SQL (Online Only Offering): Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously. 


Available Online Only, October 4-29 


Advanced SQL (Online Only Offering): Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution. 


Available Online Only, November 1-26  


SQL Certificate (Online Only Offering): Register for the certificate option and receive all three of the above courses for a discounted package rate. Certificate administered by UGotClass®. If you would like to register for the Certification option, please do so when registering and you will receive access to all courses in the session.

 Session Detail: PDF21-SQLC-01X

Schedule: Every day, starting on 09/07/21 and ending on 11/26/21 (excluding 11/25/21, 11/26/21)
Times: 12:00am - 11:59pm

Bulletin

This course will be offered via UGotClass and is a compete at your own pace online course. The course must be completed by the end date listed above. Please note the end dates of each course within a certificate as the course must be completed by the end date of each session. If you are registered for a certificate, one will be automatically sent to you at the completion of all coursework.

Instructors

Name Additional Resources
UGot Class

Facility Detail

Online
Box 1084
Edwardsville, IL 62026