« Back

Course Catalog

SQL (Structured Query Language)

Learn how to manage data and create queries that extract and manipulate information from relational databases (RDBMS) with SQL.

SQL Level 1: Introduction

This course introduces you to SQL, the standardized language used by all of the popular business database management systems including Oracle, SQL Server, Access, DB2 and My SQL. The course teaches the fundamentals of relational database theory and the SQL language. The course covers the SQL skills required for practical every day SQL coding that are in demand today.


CLICK HERE FOR REQUIRED BOOK

Upon completion of this course students will be able to:
  • Explain database and SQL fundamentals
  • Work with SQL in a development environment
  • Return data with the SELECT statement
  • Use the FROM clause to return table data
  • Filter data with the WHERE clause
  • Sort data with the ORDER BY clause
  • Describe relational database theory and data diagrams
  • Create multi table queries
  • Explain different join types and what they do
  • Join data sets with sub-queries
  • Join sets of data with set operators
  • Retrieve data about data sets using GROUP BY
Section: SQL-LVL1 (06MAR19) -- Learn More...
Start Date: Mar 6, 2019 End Date: Mar 7, 2019 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register
Section: SQL-LVL1 (09APR19) -- Learn More...
Start Date: Apr 9, 2019 End Date: Apr 10, 2019 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register
Section: SQL-LVL1 (09MAY19) -- Learn More...
Start Date: May 9, 2019 End Date: May 10, 2019 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register
Section: SQL-LVL1 (22JUN19) -- Learn More...
Start Date: Jun 22, 2019 End Date: Jun 29, 2019 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register
Section: SQL-LVL1 (15JUL19) -- Learn More...
Start Date: Jul 15, 2019 End Date: Jul 16, 2019 Tuition: $725.00
Campus: Executive Park Instructor: Kirk Canty Register
Section: SQL-LVL1 (07AUG19) -- Learn More...
Start Date: Aug 7, 2019 End Date: Aug 8, 2019 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register

SQL Level 2: Intermediate

This course expands your SQL knowledge by solidifying your base skills and teaching you: conditional selection, windowing functions, scalar and table variables, common table expressions (CTEs), and conditional sorting and filtering. The course completes the toolbox of SQL skills needed to solve any SQL query request that you may encounter in the workplace.

CLICK HERE FOR REQUIRED BOOK

Upon completion of this course students will be able to:
  • Work with SQL in a development environment
  • Describe relational database theory and data diagrams
  • Return data from multiple tables and join types
  • Join data sets with sub-queries
  • Join sets of data with set operators
  • Retrieve data about data sets using GROUP BY
  • Using Window Functions
  • Building Complex SELECT Statements
  • Table Objects and the FROM Clause
  • Table Objects and the WITH Statement
  • Building Complex WHERE Clauses
  • Complex Ordering Using ORDER BY
Section: SQL-LVL2 (02JUN19) -- Learn More...
Start Date: Jun 2, 2019 End Date: Jun 9, 2019 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register
Section: SQL-LVL2 (22AUG19) -- Learn More...
Start Date: Aug 22, 2019 End Date: Aug 23, 2019 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register