Intermediate SQL

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