Online Class: Introduction to SQL

$50.00
no certificate

- OR -

$75.00
with CEU Certificate*

Start Right Now!

Taking multiple courses? Save with our platinum program.

16

Lessons
17

Exams &
Assignments
4,046

Students
have taken this course
17

Hours
average time
1.7

CEUs

Course Description

This comprehensive course teaches and demonstrates all aspects of SQL. While you'll learn everything there is to do with SQL, this course assumes you have no prior SQL experience and is for the complete beginner.

Structured Query Language (SQL) is the language of databases. Whether you run reports or provide a dynamic website, you need to know SQL to add, delete, edit and view records. Databases organize and collect your data, and the SQL language is the liaison between you and the data. The role of database administrator includes several functions that you should know. You should know how to create and design tables, manipulate your data and run reports, create small programs (stored procedures) and use more advanced concepts such as transactional support and cursors.

This course provides a step-by-step overview and instructions that help you get started with the SQL language. We'll first get started with understanding data structures and techniques for all SQL engines including Access, Oracle and MySQL. We show you how to create SQL statements including SELECT, DELETE, UPDATE and INSERT. Then, we show you how to create and design tables. We show you how to create stored procedures, which allow you to run the same SQL statement multiple times without reprogramming your database. Finally, we show you how to use cursors, use transactions to preserve data integrity, and creating views for larger data sets.

Whether you're new to database administration or want to create customized, personal reports for your online business, this course shows you how to get started and helps you understand the SQL language from the ground up using very easy language, script examples, and HD Video demonstrations.

Completely Online
Self-Paced
Printable Lessons
Full HD Video
6 Months to Complete
24/7 Availability
Start Anytime
PC & Mac Compatible
Android & iOS Friendly
Accredited CEUs

Universal Class is an IACET Accredited Provider

Course Lessons

Average Lesson Rating:

"Extraordinarily Helpful"

(1,724 votes)

Lesson 1: Introduction to SQL

This class assumes that you know nothing about the SQL language and gives you an introduction to the way databases work and how you can manage your data. This first lesson therefore begins this introduction. 9 Total Points

Lesson 1 Video
Take Survey: Reasons for Taking this Course
Complete: Lesson 1 Exam

Lesson 2: Retrieving Data

Storing data is just one part of database functionality. You need to have the ability to retrieve your data, which you do using the SQL language. 10 Total Points

Lesson 2 Video
Review 2 Articles: SQL Fundamentals; Retrieving Data with SQL Queries
Complete: Lesson 2 Exam

Lesson 3: Updating Data

After you know how to store your data, at some point you'll need to update or edit it. SQL uses the "UPDATE" statement to edit data in your tables. 8 Total Points

Lesson 3 Video
Review 2 Articles: SQL UPDATE Statement; SQL - UPDATE Query
Complete: Lesson 3 Exam

Lesson 4: Inserting Data

INSERT adds new records to your tables. You can add static values, values from a stored procedure, or even values from another table. 9 Total Points

Lesson 4 Video
Review Article: SQL: INSERT Statement
Complete: Lesson 4 Exam

Lesson 5: Deleting Data

Deleting is a sensitive task, because you remove data from your tables. Deleting data can cause a number of issues, so it should be used with caution. 10 Total Points

Lesson 5 Video
Review 2 Articles: Deleting Data from an SQL Table; Deleting Rows by Using DELETE
Complete: Lesson 5 Exam

Lesson 6: Sorting and Filtering Data

SQL uses the ORDER BY statement to sort records. You can sort records in ascending or descending order, and you can sort records based on multiple columns. 10 Total Points

Lesson 6 Video
Review 2 Articles: 10 tips for sorting, grouping, and summarizing SQL data; How to do sorting on irregular Alphanumeric data in postgres sql
Complete: Lesson 6 Exam

Lesson 7: Advanced Filtering

SQL gets complex when you have multiple business rules that run how you return record sets. As a coder, you gather business rules that then decide how to structure your SQL statements to ensure that returned results are accurate for reports and applicatio 10 Total Points

Lesson 7 Video
Review 2 Articles: Filtering and Selecting Data for Analyses; Filtering Rows by Using WHERE and HAVING
Complete: Lesson 7 Exam

Lesson 8: Summarizing Data

In most reporting requirements, you need to use aggregate functions. Aggregate functions are premade SQL functions that you can use instead of building your own code. 10 Total Points

Lesson 8 Video
Review 2 Articles: Summarizing Data; Summarizing Data Results from a SQL Query
Complete: Lesson 8 Exam

Lesson 9: Grouping Data

The SQL language incorporates the GROUP BY operator to group data into sections or parts. 8 Total Points

Lesson 9 Video
Review 2 Articles: Having Sums, Averages, and Other Grouped Data; Summarizing and Grouping Data in SQL
Complete: Lesson 9 Exam

Lesson 10: Using Subqueries

Subqueries let you return records from another table or database and use the subquery data set to then manipulate records in other parts of your database. 8 Total Points

Lesson 10 Video
Review 3 Articles: Subquery Fundamentals; SQL Subquery Example; The Power of Subqueries
Complete: Lesson 10 Exam

Lesson 11: Joining Tables

With the JOIN statement, you can link one or several tables and consolidate SELECT queries into one returned data set. 9 Total Points

Lesson 11 Video
Review 2 Articles: Join data from two tables using SQL; SQL Tutorial - Learn SQL
Complete: Lesson 11 Exam

Lesson 12: Managing Tables

Design and management of your tables include creating, editing and deleting (dropping) tables. 9 Total Points

Lesson 12 Video
Review 2 Articles: Guide to SQL Server data management and data quality; Managing Tables
Complete: Lesson 12 Exam

Lesson 13: Using Views

Views are preset data sets that you can use to query data you commonly query in your stored procedures or SQL statements. 10 Total Points

Lesson 13 Video
Review 2 Articles: SQL: VIEWS; SQL VIEW Basics
Complete: Lesson 13 Exam

Lesson 14: Stored Procedures

Stored procedures are one or more SQL statements that perform some action on the database. The action can be anything from creating a table, deleting data or retrieving data from your tables. 10 Total Points

Lesson 14 Video
Review 2 Articles: Create a Stored Procedure; SQL Server Stored Procedure tutorial and example
Complete: Lesson 14 Exam

Lesson 15: Using Cursors

Cursors let you create loops in your stored procedures, so you can evaluate data record-by-record. 10 Total Points

Lesson 15 Video
Review 2 Articles: SQL Server Cursor Example; Cursors: An Overview
Complete: Lesson 15 Exam

Lesson 16: Using Transactions

Transactions are a solution for this phenomenon. Transaction statements let you roll back changes and avoid data integrity when one statement relies on a previous statement and the previous statement fails. 83 Total Points

Lesson 16 Video
Review 2 Articles: SQL - Transactions; Introduction to Transactions
Take Poll: What is your opinion of this course?
Take Survey: Program Evaluation Follow-up Survey (End of Course)
Complete: Lesson 16 Exam
Complete: Final Exam

223

Total Course Points

Learning Outcomes

By successfully completing this course, students will be able to:

Demonstrate retrieving data.
Demonstrate updating data.
Demonstrate inserting data.
Demonstrate deleting data.
Demonstrate sorting and filtering data.
Demonstrate summarizing data.
Demonstrate grouping data.
Demonstrate using sub-queries.
Demonstrate joining tables.
Demonstrate using views.
Demonstrate using stored procedures, cursors, and transactions, and
Demonstrate mastery of lesson content at levels of 70% or higher.

Additional Course Information

Document Your Lifelong Learning Achievements
Earn an Official Certificate Documenting Course Hours and CEUs
Verify Your Certificate with a Unique Serial Number Online

View and Share Your Certificate Online or Download/Print as PDF
Display Your Certificate on Your Resume and Promote Your Achievements Using Social Media

Course Title: Introduction to SQL

Course Number: 8900320

Course Requirements: View Course Requirements

Lessons Rating: 4.6 / 5 Stars (1,724 votes)

Languages: English - United States, Canada and other English speaking countries

Category:

UniversalClass.com > Computers & Technology > Computer Programming

Course Type: Professional Development (Self-Paced, Online Class)

CEU Value: 1.7 IACET CEUs (Continuing Education Units)

CE Accreditation: Universal Class, Inc. has been accredited as an Authorized Provider by the International Association for Continuing Education and Training (IACET).

Grading Policy: Earn a final grade of 70% or higher to receive an online/downloadable CEU Certification documenting CEUs earned.

Assessment Method: Lesson assignments and review exams

Instructor: UniversalClass Staff Instructors

Syllabus: View Syllabus

Duration: Continuous: Enroll anytime!

Course Fee: $50.00 (no CEU Certification) || with Online CEU Certification: $75.00

Choose Your Subscription Plan

Course Only

One Course
No Certificate / No CEUs

$50

for 6 months

Add to Cart

Billed once
This course only

Includes certificate	X
Includes CEUs	X
Self-paced
Instructor support
Time to complete	6 months
No. of courses	1 course

Certificate Course

One Course
Certificate & CEUs

$75

for 6 months

Add to Cart

Billed once
This course only

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	6 months
No. of courses	1 course

Platinum Yearly

ALL COURSES
Certificates & CEUs

$189

per year

Start Now

Billed once
Includes all 500+ courses

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	12 Months
No. of courses	500+

Platinum Monthly

ALL COURSES
Certificates & CEUs

$69 first month

$29.00 / each consecutive month thereafter

Start Now

Billed monthly
Includes all 500+ courses

Includes certificate
Includes CEUs
Self-paced
Instructor support
Time to complete	Monthly
No. of courses	500+

Student Testimonials

"The tutorials were very good. It was easy to zero in to the section you wanted to study on." -- Stanley O.
"I provide support for a software program that uses SQL Server as the backend database and this class answered so many questions I have had ! Many of our customers use select statements and stored procedures and I have never been able to understand how they are put together and how the syntax should be structured. The course started with an overview and then moved on one step at a time building on what I already knew at a pace I could keep up with." -- Elaine A.