MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Introduction to SQL Training

Course Summary

This SQL training course is designed for students new to writing SQL queries. Build applications and generate reports.

  • +

    Course Syllabus

      • Class Files
      • Course Introduction
    • Relational Database Basics
      • Brief History of SQL
      • Relational Databases
      • Popular Databases
      • SQL Statements
      • Relational Database Concepts
    • Simple SELECTs
      • Introduction to the Northwind Database
      • Exploring the Tables
      • SELECTing Specific Columns
      • Using SELECT Demo
      • SELECTing Specific Columns (Exercise)
      • Sorting Records
      • Sorting Demo
      • Sorting Results
      • The WHERE Clause and Operator Symbols
      • WHERE Clause Demo
      • Using the WHERE clause to check for equality or inequality
      • Using the WHERE clause to check for greater or less than
      • Checking for NULL
      • Using WHERE and ORDER BY Together
      • The WHERE Clause and Operator Words
      • WHERE Clause Operators Demo
      • More SELECTs with WHERE
      • Checking Multiple Conditions
      • Multiple Conditions Demo
      • Writing SELECTs with Multiple Conditions
    • Advanced SELECTs
      • Calculated Fields
      • Calculated Fields Demo
      • Calculating Fields
      • Aggregate Functions and Grouping
      • Aggregate Functions Demo
      • Working with Aggregate Functions
      • Built-in Data Manipulation Functions
      • Data Manipulation Demo
      • Data Manipulation Functions
    • Subqueries, Joins and Unions
      • Subqueries
      • Subquery Demo
      • Subqueries (Exercise)
      • Joins
      • Using Joins Demo
      • Using Joins
      • Outer Joins
      • Unions
      • Outer Joins and Unions
      • Working with Unions
    • Conditional Processing with CASE
      • Using CASE
      • Using Case Demo
      • Working with CASE
    • Inserting, Updating and Deleting Records
      • INSERT
      • INSERT Demo
      • Inserting Records
      • UPDATE and DELETE
      • UPDATE and DELETE Demo
      • Updating and Deleting Records

Course Fee:
USD 99

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top