« Back to Class Listing

SQL Level 2: Intermediate

Description

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 need 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:
Dates: - Time: 9:00 AM
Tuition: Instructor:

Class Schedule

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

Additional Information

Final Enrollment:
Clock Hours: