Universal Class: Over 500 Online Certificate Courses

Online Class: Introduction to SQL

no certificate
- OR -
with CEU Certificate*
Start Right Now!
Taking multiple courses? Save with our platinum program.
  • 16
  • 17
    Exams &
  • 17
    average time
  • 1.7
  • 2,198
    have taken this course

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:
4.5 / 5 Stars (Average Rating) 4.5 / 5 Stars (Average Rating) 4.5 / 5 Stars (Average Rating) 4.5 / 5 Stars (Average Rating) 4.5 / 5 Stars (Average Rating)
"Extraordinarily Helpful"
(1,060 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
  • 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
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

Online CEU Certificate
  • 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
Document Your CEUs on Your Resume
Course Title: Introduction to SQL
Course Number: 8900320
Languages: English - United States, Canada and other English speaking countries
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
for 6 months
Billed once
This course only
Includes certificate X
Includes CEUs X
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Certificate Course
One Course
Certificate & CEUs
for 6 months
Billed once
This course only
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 6 months
No. of courses 1 course
Platinum Yearly
Best Value
Certificates & CEUs
per year
You save 50%!
Billed once
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
Time to complete 12 Months
No. of courses 500+
Platinum Monthly
Certificates & CEUs
$59 first month
$29.00 / each consecutive month thereafter
Billed monthly
Includes all 500+ courses
Includes certificate Yes
Includes CEUs Yes
Self-paced Yes
Instructor support Yes
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.

Related Courses

  • Google+ for Business
    Google+ for Business
    If you've been wondering about how to use Google+ for your business, this comprehensive course is the best way to get started. With simple instructions and ideas regarding social media marketing, businesses of every size soon understand why they nee...
    0.4 CEUs 4h
  • Learn HTML - Create Webpages Using HTML5
    Learn HTML - Create Webpages Using HTML5
    This course teaches you how to create webpages from scratch using the most current standard in HTML -- HTML5. HTML5 is the latest standard in web page coding. Whether you're a new or seasoned web designer, you need to know the latest in HTML archite...
    1.0 CEUs 10h
  • Office 2013: Word, Excel, PowerPoint and Outlook
    Office 2013: Word, Excel, PowerPoint and Outlook
    Word 2013: This course will teach both the new and experienced user alike how to use the many features of MS Word 2013. You'll learn how to create documents, publications and complete tasks that require the use of a word processor. You'll start out...
    4.0 CEUs 40h
  • Introduction to CSS
    Introduction to CSS
    Ever wonder how the latest website designs are made? Cascading Style Sheets (CSS) are the main coding files used to lay out a website and its design. CSS3 is the latest in styling standards, and it brings several new properties and declarations you ...
    1.1 CEUs 11h
  • Office 2016: Word, Excel, PowerPoint and Outlook
    Office 2016: Word, Excel, PowerPoint and Outlook
    Microsoft Word 2016: Microsoft Word 2016 is the latest version of the popular word processing software offered as part of the Microsoft Office suite. This course will teach you all the skills you'll need to successfully use Word 2016. You'll learn ...
    3.2 CEUs 32h
  • Adobe Captivate
    Adobe Captivate
    Adobe Captivate is a responsive authoring tool that allows you to create eLearning content, such as eLearning courses, software demonstrations, branched scenarios, games, quizzes, and screencasts. The files you create in Adobe Captivate 9 can be exp...
    0.6 CEUs 6h
  • Microsoft Access 2016
    Microsoft Access 2016
    Microsoft Access 2016 is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access w...
    1.2 CEUs 12h
  • JQuery Programming
    JQuery Programming
    JQuery is one of the most popular frameworks on the web that deals with client-side scripting for styling web pages and performing asynchronous events. It's built on the JavaScript language, so anyone familiar with the JavaScript language will pick ...
    0.9 CEUs 9h
  • Microsoft Publisher 2016
    Microsoft Publisher 2016
    Publisher 2016 is Microsoft's entry-level desktop publishing program, allowing you to quickly create publications for the web or print. You can easily create professional-looking publications by either creating them yourself from scratch or using o...
    0.7 CEUs 7h
  • Microsoft Visio 2016
    Microsoft Visio 2016
    Microsoft Visio 2016 is a program used to create diagrams and drawings of all types and for all purposes. Unlike the basic diagram functions found in other Office programs, such as Word or Excel, Visio offers advanced drawing and diagram functions t...
    0.7 CEUs 7h
  • Adobe After Effects
    Adobe After Effects
    Adobe After Effects allows you to create videos containing animation and special effects for graphics-related projects. You can use After Effects to animate, alter, and composite media using various tools and optional plug-ins. The program is widely...
    1.0 CEUs 10h
  • MySQL
    If you've decided to build a website or need a database, MySQL is an open-source option that's very cost effective and affordable. Without knowing how to install, configure, design and maintain the database, you risk having a poor performing environ...
    1.0 CEUs 10h
  • Introduction to JavaScript
    Introduction to JavaScript
    JavaScript is the globally used client-side scripting language for the web. Most browsers support the language by default, so you can get started using JavaScript and HTML with a simple text editor and browser for testing. Client-side, programming l...
    1.0 CEUs 10h
  • Adobe Premiere 101
    Adobe Premiere 101
    Adobe Premiere Pro is a video editing program that is part of the Adobe Creative Cloud software collection, as well as Adobe CS6 – or Adobe Creative Suite. Premiere Pro is used to edit videos, including movies, and is quickly becoming the go-t...
    1.0 CEUs 10h
  • Final Cut Pro X
    Final Cut Pro X
    Final Cut Pro X is a video editing and movie making software application created by Apple for OS X. Unlike previously released versions of the video editing program Final Cut, Final Cut Pro X is an all-new application. It has been designed from sc...
    1.0 CEUs 10h
  • Adobe Illustrator 101
    Adobe Illustrator 101
    Course Introduction Adobe Illustrator is a powerful drawing software program offered by Adobe. Anyone, regardless of artistic or computer ability, can use Illustrator to draw shapes and lines, create text, or import graphics and pictures. You can ...
    1.0 CEUs 10h
  • Introduction to SQL
    Introduction to SQL
    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 t...
    1.7 CEUs 17h
  • Adobe InDesign 101
    Adobe InDesign 101
    Adobe InDesign is a software program created by Adobe Systems, the same company that creates Photoshop, Illustrator, and a number of other programs. Whereas Photoshop is used for image editing and Illustrator is used for drawing, InDesign is used to...
    1.0 CEUs 10h
  • C# Programming
    C# Programming
    C# is a powerful backend coding language used for Microsoft web and desktop applications. C# is a C-style language, so you can take C# and learn other languages such as Java, C and C++. This course will get you started with C# and the language style...
    1.7 CEUs 17h
  • Adobe Muse 101
    Adobe Muse 101
    Adobe Muse CC is the newest addition to Adobe's web design programs. Unlike Dreamweaver, which requires knowing a lot of code, Muse CC is a WYSIWYG (or what you see is what you get) design editor. Most tasks that you complete in Muse CC are done wit...
    1.0 CEUs 10h
  • Adobe Photoshop 101
    Adobe Photoshop 101
    This course will teach you everything you need to know to make full use of the world's most popular graphics editing program -- Adobe Photoshop. Adobe Photoshop is a complex graphics and image editing software and paint program. It has become a main...
    1.0 CEUs 10h
  • Adobe Lightroom 101
    Adobe Lightroom 101
    Adobe Photoshop Lightroom is a photo editing and management program offered by Adobe, allowing users to manage and edit multiple images at once using the Adobe Photoshop Lightroom interface. This course will teach you the features in Adobe Photosho...
    1.0 CEUs 10h
  • Adobe Fireworks 101
    Adobe Fireworks 101
    Adobe Fireworks is a program that is part of the Adobe Creative Suite family of products. Formerly known as Macromedia Fireworks, the program is a bitmap and vector graphics editor that is typically used to create interactive graphics and website pr...
    1.0 CEUs 10h
Follow Us Online
  • Follow us on Google Plus Follow us on FaceBook Follow us on Twitter Follow us on YouTube
© Copyright 1999-2018 Universal Class™ All rights reserved.