Introduction to SQL


ID : 107360   

« back to classes page
Learn how to write SQL code to create and populate database tables and how to write simple SQL queries that are capable of retrieving vast amounts of information from a database. In this course, you will discover the power of the relational database, how to create and manage database tables, and how to use SQL SELECT statements to precisely pinpoint and retrieve data from a database. 

Agenda

Unit 1:  The Relational Database and Structured Query Language
  • The relational database structure
  • Structured Query Language
  • Table creation and data insertion
  • Constraints and referential integrity
  • Creating Indexes
Unit 2:  Table Management
  • Table management
  • Adding columns to a table
  • Deleting columns from a table
Unit 3:  Selecting and Retrieving Data
  • Deleting a table
  • 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
  •  
Unit 4:  Filtering Data
  • Merging columns
  • 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

 

Notice

Please read:  Requirements:
- Windows 10 or later. Macs are not compatible.
- Necessary rights (local administrative rights) to install programs on the computer.

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