Skip to main content

Intermediate SQL

ID : 61662   
« 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: 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

Sessions
Online 24/7

Location
NA - Online

Price: 

$595.00


Schedule Information

Date(s) Class Days Times Location Instructor(s)
7/5/2022 - 7/29/2022 Online 24/7 12:00 AM - 12:00 AM N/A - Online

Other Class Offerings

Intermediate SQL
ID: 61663

08/01/22 - 08/26/22
Online 24/7

Location
 

Instructor
Cecelia Allison

Intermediate SQL
ID: 62188

09/06/22 - 09/30/22
Online 24/7

Location
 

Instructor
Cecelia Allison

Intermediate SQL
ID: 62189

10/03/22 - 10/28/22
Online 24/7

Location
 

Instructor
Cecelia Allison

Intermediate SQL
ID: 62190

11/07/22 - 12/02/22
Online 24/7

Location
 

Instructor
Cecelia Allison