Intermediate SQL


ID : 107380   

« back to classes page
Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously. 

Agenda

Unit 1:  Creating Calculated Fields and using Aggregate Functions
  • Structured Query Language Review
  • Creating calculated fields
  • Concatenating  columns
  • Using aggregate functions
Unit 2:  Using Clauses in Structured Query Language
  • Using the ORDER BY clause
  • Using the GROUP BY clause
  • Using the GROUP BY clause and WHERE clause
  • Using the HAVING clause
Unit 3:  Creating Table Joins
  • Creating Inner joins
  • Creating Outer joins
  • Creating Self joins
Unit 4:  Creating Subqueries
  • Creating subqueries
  • Creating subqueries that contain calculated fields
  • Creating subqueries that contain aggregate functions

Class Details

Session(s)
Online 24/7

Location
NA - Online

 

Notice

Please read:  Courses included in the Certificate
  • Introduction to SQL
  • Intermediate SQL
  • Advanced SQL

Tuition:  $245.00


Schedule Information

Date(s) Class Days Times Location Instructor(s)
12/7/2026 - 1/1/2027 Online 24/7 12:00 AM - 12:00 AM N/A - Online