Great class! Exactly what I was looking for! More Testimonials »

SQL on Windows eLearning Course

  1. Overview
  2.  | 
  3. Catalog
  4.  | 
  5. Packages
  6.  | 
  7. Benefits
  8.  | 
  9. Savings
  10.  | 
  11. FAQs
  12.  | 
  13. Try Free
  14.  | 
  15. Cancellation
  16.  | 
  17. Login
  18.  | 
  19. Support
Save money by buying eLearning courses in packages.

Packages include multiple eLearning courses that are bundled together for a great value.

Of course, you can buy this SQL on Windows eLearning course individually as well. Just click on the "Register Now" button below.

SQL for the Windows Environment eLearning Course Series (21 hours)

SQL is the most widely-used database language. Acquiring a good working knowledge of SQL is an important skill for anyone who interacts with databases. Short, focused lessons start with simple data retrieval and progress to complex topics such as using joins, subqueries, stored procedures, and table constraints.

Self-Paced SQL eLearning Course Benefits

Only $99.95

12-month subscription!

Register Now

  • Learn SQL online with these interactive online SQL courses.
  • Affordable Pricing (Only $99.95 for the complete series)
  • A full year to complete the SQL courses
  • Retake the SQL courses as many times as you like
  • Measure your progress with assessment tests after each course
  • Earn completion certificates after passing each assessment test

1. SQL for the Windows Environment:1 Introduction to Databases and SQL (Time: 2 hours)

This eLearning course explains the basic structure and uses of databases and how to use the SQL SELECT statement to retrieve data.

Course Objectives

  • Describe the basics of database structure
  • Explain how to use SQL to interact with most database applications
  • Use the SELECT statement to retrieve data
  • Explain the sorting options available when using the ORDER BY clause

Course Topics

  • Understanding databases
  • Understanding SQL
  • Retrieving data
  • Sorting data
  • Sorting options

2. SQL for the Windows Environment:2 Filtering Data (Time: 2 hours)

This eLearning course explains how to filter data from a database with the SQL WHERE clause.

Course Objectives

  • Use the WHERE clause in a SELECT statement
  • Use the AND, OR, IN, and NOT operators in a WHERE clause
  • Use the LIKE operator in a WHERE clause
  • Use wildcards to create search patterns

Course Topics

  • Filtering with the WHERE Clause
  • Using the WHERE Clause
  • Combining WHERE Clauses
  • Using the IN and NOT Operators
  • The LIKE Operator and Wildcards
  • Using Wildcards

3. SQL for the Windows Environment:3 Calculations and Functions (Time: 2 hours)

This eLearning course shows you how to manipulate data returned from a query using calculated fields and functions.

Course Objectives

  • Concatenate fields in your queries
  • Perform mathematical calculations in your queries
  • Use text and numeric functions in your queries
  • Use date and time functions in your queries

Course Topics

  • Understanding calculated fields
  • Concatenating fields
  • Performing mathematical calculations
  • Understanding functions
  • Using text and numeric functions
  • Using date and time functions

4. SQL for the Windows Environment:4 Summarizing Data (Time: 1 hours)

This eLearning course explains how to use the SQL aggregate functions to summarize data from database tables.

Course Objectives

  • Explain the purpose of the SQL aggregate functions
  • Use the SUM() and COUNT() functions
  • Use the AVG(), MAX(), and MIN() functions
  • Use aggregate functions for advanced operations

Course Topics

  • Aggregate Functions
  • Using the SUM() and COUNT() Functions
  • The AVG(), MAX(), and MIN() Functions
  • Using Advanced Aggregate Functions

5. SQL for the Windows Environment:5 Groups and Queries (Time: 2 hours)

This eLearning course explains how to use the GROUP BY and ORDER BY clauses to sort and group data. It also explains how to use subqueries and combined queries to add more options to retrievals using the SQL SELECT statement.

Course Objectives

  • Create data groups using the GROUP BY clause
  • Sort and filter grouped data
  • Understand and filter subqueries
  • Use subqueries as calculated fields
  • Create combined queries using UNION

Course Topics

  • Understanding data grouping
  • Creating groups
  • Filtering groups
  • Grouping and sorting
  • Understanding and filtering subqueries
  • Using subqueries as calculated fields
  • Creating combined queries
  • Advanced UNION features

6. SQL for the Windows Environment:6 Joins (Time: 3 hours)

This eLearning course shows you how to access data stored in multiple relational tables by using joins in your queries.

Course Objectives

  • Query multiple tables using a join
  • Use table aliases in your queries
  • Perform inner, outer, self, and natural joins
  • Use aggregate functions with joins

Course Topics

  • Understanding joins
  • Creating a join
  • Joining multiple tables
  • Using table aliases
  • Self joins
  • Natural joins
  • Outer joins
  • Using joins with aggregate functions

7. SQL for the Windows Environment:7 Data and Tables (Time: 3 hours)

This eLearning course explains how to insert data into existing database tables and then modify or delete that data. It also explains how to create new database tables and modify or delete existing tables.

Course Objectives

  • Insert rows of data into a database table
  • Copy data from one table to another
  • Update and delete data from a database table
  • Create database tables
  • Modify and delete database tables

Course Topics

  • Inserting Data
  • Inserting Partial Rows and Retrieved Data
  • Copying from One Table to Another
  • Updating Data
  • Deleting Data
  • Guidelines for Updating and Deleting Data
  • Creating Tables
  • Working with NULL and Default Values
  • Modifying Tables

8. SQL for the Windows Environment:8 Views and Stored Procedures (Time: 2 hours)

This eLearning course teaches the learner the use of views in SQL and how views can be used to simplify complex operations. It also provides an overview on the use and creation of stored procedures.

Course Objectives

  • Explain the makeup of views
  • Use views to simplify joins
  • Use views to reformat retrieved data
  • Use filtering and calculated fields within your views
  • Explain the use of stored procedures
  • Execute stored procedures
  • Describe some of the features involved in creating stored procedures

Course Topics

  • Understanding views
  • Using views to simplify complex joins
  • Using views to reformat retrieved data
  • Unwanted data and calculated fields
  • Understanding stored procedures
  • Executing stored procedures
  • Creating stored procedures

9. SQL for the Windows Environment:9 Transaction Processing and Cursors (Time: 2 hours)

This eLearning course shows you how to use transaction processing to execute SQL operations in batches. This enables you to prevent processing errors from corrupting the database.

Course Objectives

  • Explain how transaction processing works in SQL code
  • Control transactions
  • Explain how cursors are used to save SQL results
  • Declare and use cursors in your SQL code

Course Topics

  • Understanding transaction processing
  • Controlling transactions
  • Setting savepoints
  • Understanding cursors
  • Working with cursors

10. SQL for the Windows Environment:10 Advanced SQL Functions (Time: 2 hours)

This eLearning course explains the use of constraints in databases. The user will learn about primary and foreign keys, and unique and check constraints. The user will also learn about the use of indexes and triggers within databases. Finally, the user will receive an overview of the tools used to manage database security.

Course Objectives

  • Explain the use of database constraints
  • Define primary and foreign keys
  • Describe the use of unique and check constraints
  • Explain the function of database indexes
  • Describe the function of triggers
  • Identify the tools used in database security

Course Topics

  • Understanding constraints
  • Primary and foreign keys
  • Unique and check constraints
  • Understanding indexes
  • Understanding triggers
  • Database security
Quick Links
  1. Watch Presentation
  2. Free Demo
  3. Purchase Vouchers
  4. Partners
  5. Remote Courses
  6. Make Payment
  7. Contact Us
  8. Sitemap
  9. Privacy Policy
Courseware
  1. Purchase Courseware
Client Success
  1. Independent Survey
  2. Client List
  3. Testimonials
Join The Team
  1. Learn how you can become a Webucator Trainer
  2. Career Opportunities
Locations
  1. Where We've Trained
  2. We have trainers all over North America.
Compare Us
Compare Webucator to leading Competitors
Training Options
  1. Live eLearning Public Classes
  2. Private Training
  3. Self-Paced eLearning
Microsoft Partner
  1. Microsoft Certifications
  2. Certified Microsoft Courses
  3. Software Assurance Training Vouchers
Watch 3-minute Demo Video
of Live Online Training: Learn the benefits of online training with Webucator
Webucator is a Registered Education Provider (R.E.P.) approved by PMI to issue professional development units (PDUs) for our training courses.
© Webucator, Inc. All rights reserved. | Toll Free: 1-877-932-8228 | From outside the USA: 315-849-2724| Fax: 315-849-2723