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 Database with Queries

Course Summary

Step-by-Step Beginner's Training Course in MY SQL . No prior database knowledge is needed.


  • +

    Course Syllabus

    • Basic Theory About Database And SQL .
      • Introduction to SQL
      • What is a database?
      • Purpose of Database in SQL.
      • Advantages of Databases in SQL .
      • Levels of Database implementation in SQL.
      • Data Independence in SQL.
      • Types of Data Models in SQL.
      • Some basic database concepts.
      • Types of Keys in SQL.
      • What is SQL?
    • Queries in SQL.
      • Installation of SQL on windows.
      • Creating Databases and Tables in SQL.
      • Insertion in SQL table.
      • Use of Select command in SQL.
      • Use of Where command in SQL.
      • Use of Distinct command in SQL.
      • Use of All keyword in SQL.
      • Use of OR keyword in SQL.
      • Use of AND keyword in SQL.
      • Use of NOT command in SQL.
      • Use of BETWEEN command in SQL.
      • Use of NOT BETWEEN command in SQL.
      • Use of IN command in SQL.
      • Use of NOT IN command in SQL.
      • Use of NULL command in SQL.
      • Use of ORDER BY command in SQL.
      • Use of SUM command in SQL.
      • Use of average command in SQL.
      • Use of count command in SQL.
      • Use of distinct count command in SQL.
      • Use of all count command in SQL.
      • Use of having command in SQL.
      • Use of group by command in SQL.
      • Use of having and group by command in SQL.
      • Use of update command in SQL.
      • Use of view command in SQL.
      • Use of alter command in SQL.
      • Use of delete command in SQL.
      • Use of drop command in SQL.
    • Revision table on SQL Queries.
      • Bonus Table
    • Outro of SQL
      • Qutro


Course Fee:
USD 199

Course Type:

Self-Study

Course Status:

Active

Workload:

1 - 4 hours / week

This course is listed under Data & Information Management and IT Security & Architecture 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