SQL Level 2: Course Description
Start creating views, functions, and subqueries in this hands-on SQL class. Learn to work with stored procedures, subqueries, functions, and logic.
Create more repeatable queries with functions, join data from multiple sources with joins, write subqueries, and more.
Finish up with a real-world project in the lab session.
Prerequisites: This class builds off of our SQL Level 1 class which covers the basics of relational databases and querying.
SQL Level 2: Full Overview
The Code
1) Self Joins
2) Union Joins
3) Cross Joins
Saving Queries Programmatically
4) Views
5) Functions
6) Layered Views
7) Create Top Value Views
Sub Queries
8) What is a Sub Query?
9) Clarity and Transparency
10) Single Table Sub Query
11) Multiple Table Sub Query
12) Exists versus In Operators
13) Any versus All Operator
Math, Advanced Functions and Logic Statements
14) Basic Math
15) Advanced Date and Time Functions
16) Advanced Text Functions
17) Case When Then Logic Statements
18) Variables and User Functions
Student Labs
19) Creating Views
20) Sub Queries
21) Advanced Functions
22) Logic and Date Functions
Prerequisites: This class builds off of our SQL Level 1 class which covers the basics of relational databases and querying.
You will receive a training manual created by our experts for course review.
