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

SQL Essential Training

Course Summary

Learn how to use SQL to manage your database records in these simple, straightforward tutorials, which include a quick start guide and detailed instructions for creating tables, defining relationships, manipulating strings, and more.     

  • +

    Course Syllabus

       Using the exercise files 
       Course overview 
       Installing the test environment on a Mac 
       Installing the test environment on a PC 
       What is SQL? 
    1. SQL Quick Start
       Quick-start introduction 
       Using the basic SELECT statement 
       Selecting rows 
       Selecting columns 
       Counting rows 
       Inserting data 
       Updating data 
       Deleting data 
    2. Fundamentals
       Databases and tables 
       SQL syntax overview 
       Formatting SQL 
       Creating tables 
       Deleting a table with DROP TABLE 
       Inserting rows into a table 
       Deleting rows from a table 
       Understanding NULL 
       Controlling column behaviors with constraints 
       Changing a schema with ALTER 
       Creating an ID column 
       Filtering data with WHERE, LIKE, and IN 
       Removing duplicates with SELECT DISTINCT 
       Sorting with ORDER BY 
       Conditional expressions with CASE 
    3. Relationships
       Understanding joins 
       Accessing related tables with JOIN 
       Using multiple related tables 
    4. Strings
       About SQL strings 
       Finding the length of a string 
       Selecting part of a string 
       Removing spaces with TRIM 
       Making strings uppercase and lowercase 
    5. Numbers
       About numeric types 
       Finding the type of a value 
       Integer division and remainders 
       Rounding numbers 
    6. Dates
       Dates and times 
       Date- and time-related functions 
    7. Aggregates
       How aggregates work 
       Using aggregate functions 
       Aggregating DISTINCT values 
    8. Transactions
       Why use transactions? 
       Using transactions 
    9. Triggers
       Updating a table with a trigger 
       Preventing automatic updates with a trigger 
       Automating timestamps with a trigger 
    10. Subselects and Views
       Creating a simple subselect 
       Searching within a result set 
       Creating a view 
       Creating a joined view 
    11. A Simple CRUD Application
       Touring the CRUD application 
       The SELECT functions 
       The INSERT, UPDATE, and DELETE functions 

Course Fee:
USD 25

Course Type:


Course Status:



4 - 5 hours / week

This course is listed under Data & Information Management Community

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