« 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: SQL-LVL2 (21FEB19)
Dates: Feb 21, 2019 - Feb 22, 2019 Time: 9:00 AM
Tuition: $725.00 Instructor: Sajean Page Register

Course Outline

01. Working with SQL and the IDE

02. Relational Databases and Diagrams

03. Multiple Tables and Join Types

04. Join Data Sets with Sub-queries

05. Join Data Sets with Set Operators

06. Summarizing Sets with GROUP BY

07. Building Complex SELECT Statements

08. Window Functions with the OVER Clause

09. Table Objects and the FROM Clause

10. Table Objects and the WITH Statement

11. Building Complex WHERE Clauses

12. Complex Ordering Using ORDER BY

Class Schedule

Date Times Meeting Type Location
02/21/2019 9:00 AM - 4:30 PM Classroom Executive Park
02/22/2019 9:00 AM - 4:30 PM Classroom Executive Park

Additional Information

Final Enrollment: Feb 21, 2019
Clock Hours: 13.0