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

Online 24/7

NA - Online



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

ID: 61657

02/07/22 - 03/04/22
Online 24/7

ID: 61658

03/07/22 - 04/01/22
Online 24/7

ID: 61659

04/04/22 - 04/29/22
Online 24/7

ID: 61660

05/02/22 - 05/27/22
Online 24/7