Skip to main content

Introduction to SQL

Course number : NTC-L29   ID : 10145   
« 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 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: 

$245.00

Registration Closes On
Friday, March 28, 2025 @ 11:59 PM


Schedule Information

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

Other Class Offerings

ID: 10143

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

Introduction to SQL

Location
 

Instructor
Cecelia Allison

ID: 10144

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

Introduction to SQL

Location
 

Instructor
Cecelia Allison

ID: 10146

04/07/25 - 05/02/25
Online 24/7

Introduction to SQL

Location
 

Instructor
Cecelia Allison

ID: 10734

05/05/25 - 05/30/25
Online 24/7

Introduction to SQL

Location
 

Instructor
Cecelia Allison