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

Learn SQL in 6 days

Course Summary

Learn SQL and handle databases confidently


  • +

    Course Syllabus

    • Introduction
      • Introduction
    • DAY 1: Database Basics and Schema
      • Database
      • Tables
      • Set of Tables
      • Primary and Foreign Key
      • Data Types
      • Schema
      • BookOrder Database Script
    • DAY 2 : Managing Database and Tables
      • Database Creation
      • Show Database
      • Drop Database
      • Data Types
      • Create Table
      • Describe Table
      • Alter Table
      • Delete Table
      • Create Primary Key
      • Create Foreign Key
    • DAY 3: Populating Data
      • Setting up Database and Tables
      • Add Data to table
      • WHERE Clause
      • WHERE Clause examples
      • Arithmetic Operators and Expressions
      • Comparison Operators and Simple Condition
      • Logical Operators and Operator Precedence
      • Update Table Data
      • Delete Data from Table
    • DAY 4: Retrieving Data
      • Simple Select
      • Change Column Header
      • Select Specific Columns
      • Select Distinct Columns
      • Sorting the Data
      • Retrieve Data from Multiple Tables
    • DAY 5: Functions and Creating Sub-totals
      • String Functions
      • Mathematical Functions
      • Date Functions
      • Logical Operators
      • NULL Data
      • GROUP BY clause
      • GROUP Functions
      • HAVING clause
    • DAY 6: Sub-Queries
      • Sub-Queries in SELECT
      • Sub-Queries in WHERE
      • Sub-Queries in WHERE - ANY Operator
      • Sub-Queries in WHERE - ALL Operator
      • Sub-Queries using EXISTS Operator
      • Sub-Queries in INSERT
    • Conclusion
      • Conclusion


Course Fee:
USD 35

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