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