« Back to Class Listing

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.


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

Dates: - Time: 9:00 AM
Tuition: Instructor:

Class Schedule

Date Times Meeting Type Location
08/27/2018 9:00 AM - 4:30 PM Classroom Executive Park
08/28/2018 9:00 AM - 4:30 PM Classroom Executive Park

Additional Information

Final Enrollment:
Clock Hours: