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

Course Summary

Structured Query Language (SQL) is a special purpose language for interacting with relational databases. This course is a gentle introduction to SQL and will lead you through the basics you need for querying, updating, and creating items in a database.


  • +

    Course Syllabus

    ● SQL Basics
        ◦ Introduction
        ◦ What is A Database
        ◦ What Does Relational Mean
        ◦ An Example
        ◦ SQL Statement
        ◦ Naming Things
        ◦ Creating Things
        ◦ RDMS
        ◦ SQL in This Course
        ◦ Summary
    ● The SELECT Statement
        ◦ Introduction
        ◦ The FROM clause
        ◦ Limiting The Result Set
        ◦ WHERE clause
        ◦ AND and OR
        ◦ Demo: AND and OR
        ◦ More Operators
        ◦ Demo: Between
        ◦ LIKE
        ◦ Demo: LIKE
        ◦ IN
        ◦ Demo: IN
        ◦ IS and IS NOT
        ◦ Demo: IS and IS NOT
        ◦ Summary
    ● JOINS
        ◦ Introduction
        ◦ Demo: OrderBY
        ◦ Set Functions
        ◦ Demo: Set Functions
        ◦ Qualifiers and Set Functions
        ◦ Demo: Qualifiers and Set Functions
        ◦ GROUP BY
        ◦ Demo: GROUP BY
        ◦ HAVING
        ◦ Demo: HAVING
        ◦ JOINS
        ◦ Demo: JOINS
        ◦ Summary
    ● Adding, Changing, and Removing Data.
        ◦ Introduction
        ◦ INSERT
        ◦ Demo: INSERT
        ◦ Inserting Multiple Rows
        ◦ UPDATE
        ◦ Demo: UPDATE
        ◦ DELETE
        ◦ Demo: DELETE
        ◦ Summary
    ● Creating Tables
        ◦ Introduction
        ◦ CREATE TABLE Example
        ◦ NULL or NOT NULL
        ◦ PRIMARY KEY & CONSTRAINT
        ◦ ALTER TABLE
        ◦ DROP TABLE
        ◦ DEMO: CREATE TABLE
        ◦ Summary

     


Course Fee:
USD 29

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
REDHERRING
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