Introduction to SQL

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.

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

CEUs: 1.6
Length (in hours): 16
Price in USD $245
Price in CAD $329

One Month Course

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
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

Hear from our past students

The course has a very nice pace and fits into one schedule seamlessly I like how it's structured reading material first, then presentation to reinforce the content read and then a quiz to put into practice what you have learned. With this being a new skill I am pursuing I must say I am pleased with how things going so far.
- Keangelo M

I would highly recommend this course as an introduction or even a refresher. Though I use SQL daily, I have taken away new tips and tricks for more effective ways to write queries, making me more efficient and productive. Ms. Cecelia has put together very thoughtful and thought provoking body of lessons to gently move you through each unit. You can tell she thoroughly enjoys SQL and takes great care in the lessons as well as the thoughtful responses to questions. Very impressed and SO glad I took the chance. I'm really looking forward to the Intermediate course!
- Kathy S

I love this course, and I'm looking forward to the next two follow up courses to get my SQL certificate. I love the readings, the presentations, the discussions. This is the best I could have hoped for actually after being out of school for several years.
- Dorothy R

Learning Resources Network