« Back

Course Catalog

SQL (Strutured 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

SQL is a ‘must know’ technology for anyone in the IT industry! Use SQL to create queries that extract and manipulate information from relational databases. Learn to create expressions that calculate and summarize information and search, filter and sort your data. SQL can be used with almost all relational databases such as Microsoft Access, Microsoft SQL Server and Oracle, as well as business applications such as Crystal Reports, Business Objects and many more.

In this fun and informative class you will learn how to use over 30 different SQL clauses and functions and leave with a good working knowledge and understanding of the SQL language.

CLICK HERE FOR REQUIRED BOOK

Upon completion of this course, students will be able to:
  1. Understand database and SQL fundamentals
  2. Work with SQL script files and coding standards
  3. Return and organize data from a single table
  4. Code Derived Columns and use built functions
  5. Use basic WHERE Clauses to filter data
  6. Use Advanced WHERE Clauses to filter data
  7. Understand relational database theory and data diagrams
  8. Plan and write simple multi table queries
  9. Understand different join types and what they do
  10. Summarize and filter data with aggregate functions
  11. Understand and use action queries and their best practices
  12. Use and debug sub-queries and know when to use them
Section: SQL-LVL1 (07DEC17) -- Learn More...
Start Date: Dec 7, 2017 End Date: Dec 8, 2017 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register
Section: SQL-LVL1 (01FEB18) -- Learn More...
Start Date: Feb 1, 2018 End Date: Feb 2, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Kirk Canty Register
Section: SQL-LVL1 (08MAR18) -- Learn More...
Start Date: Mar 8, 2018 End Date: Mar 9, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Ali Kazmi Register
Section: SQL-LVL1 (12APR18) -- Learn More...
Start Date: Apr 12, 2018 End Date: Apr 13, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register
Section: SQL-LVL1 (17MAY18) -- Learn More...
Start Date: May 17, 2018 End Date: May 18, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Kirk Canty Register
Section: SQL-LVL1 (13JUN18) -- Learn More...
Start Date: Jun 13, 2018 End Date: Jun 14, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Ali Kazmi Register
Section: SQL-LVL1 (12JUL18) -- Learn More...
Start Date: Jul 12, 2018 End Date: Jul 13, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register
Section: SQL-LVL1 (16AUG18) -- Learn More...
Start Date: Aug 16, 2018 End Date: Aug 17, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Kirk Canty Register

SQL Level 2: Intermediate

Take your SQL skills to the next level by learning how to do more work with SQL inside the database before pushing data across the network to your applications. This class takes a time efficient ‘problem / solution/ discussion’ approach and covers the topics that are important to today’s SQL developers.

This class teaches you how to use window functions, pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set. Also covered is the topic of ‘bucketization’, how to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques.

CLICK HERE FOR REQUIRED BOOK

Upon completion of this course, students will know about:
  • Retrieving Records
  • Conditional SQL & Sample Data
  • Conditional Sorting & Stacking Rows
  • Views and Different Join Types
  • Working with Text Data
  • Working Numerical Data
  • Working with Dates
  • Grouping and Window Functions
  • Pivoting and Pivot Reports
  • Other Ways to Pivot
  • Bucketization and Histograms
  • Analyzing and Presenting Data
Section: SQL-LVL2 (11FEB18) -- Learn More...
Start Date: Feb 11, 2018 End Date: Feb 18, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Kirk Canty Register
Section: SQL-LVL2 (23MAY18) -- Learn More...
Start Date: May 23, 2018 End Date: May 30, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Rashaad Jones Register
Section: SQL-LVL2 (23AUG18) -- Learn More...
Start Date: Aug 23, 2018 End Date: Aug 24, 2018 Tuition: $725.00
Campus: Executive Park Instructor: Sajean Page Register