SQL Level 2

SQL Level 2

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.

 

Please call 800-851-9237 to schedule this training course.

Contact AGI to request course dates.

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. 

Available Delivery Methods For This Class

CLASSROOM
LIVE ONLINE
PRIVATE
MY LOCATION