Skip to main content

Intermediate SQL

ID : 16869   
« back to classes page
CourseGraphic 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: The Relational Database and Structured Query Language The relational database structure Structured Query Language Table creation and data insertion Defining datatypes and constraints Creating Indexes Unit 2: Table Management Table management Adding columns to a table Deleting columns from a table Deleting a table Unit 3: Selecting and Retrieving Data Creating a SELECT statement to retrieve data Using DISTINCT to display unique values in a column Using the AS keyword to create an alternate name for a column Merging columns Unit 4: Filtering Data Creating a WHERE clause Using comparison, character, and logical operators to match conditions Using the IN operator to match a condition Using the BETWEEN operator to match a condition

Class Details

Session(s)
Online 24/7

Location
NA - Online

Fee: 

$329.00


Schedule Information

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

Other Class Offerings

ID: 15135

11/04/24 - 11/29/24
Online 24/7

Intermediate SQL

Location
 

Instructor
Cecelia Allison

ID: 15136

12/02/24 - 12/27/24
Online 24/7

Intermediate SQL

Location
 

Instructor
Cecelia Allison

ID: 16864

01/06/25 - 01/31/25
Online 24/7

Intermediate SQL

Location
 

Instructor
Cecelia Allison

ID: 16865

02/03/25 - 02/28/25
Online 24/7

Intermediate SQL

Location
 

Instructor
Cecelia Allison