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

A Beginners Guide To SQL. Master SQL Quickly

Course Summary

SQL is the language of all databases, this course offers an easy way to master the SQL fundamentals


  • +

    Course Syllabus

    • Getting Started With Databases And SQL
      • Important - Download These First - Working Files
      • 0101 Relational Databases And Key Terms Explained
      • 0103 What Are The SQL Commands
      • 0104 Select Syntax And Examples
      • 0105 Where Can I Use SQL?
      • 0106 Installing Sample Databases And Working Files
    • Using SQL To Select And Filter Data
      • 0201 Using Select To View Data
      • 0202 Sorting The Data
      • 0203 Adding A Where Clause To Filter Data
      • 0204 Filtering Date Columns
      • 0205 Working With Null Or Empty Values
      • 0206 Using Comments Within SQL
      • 0207 Use Of Wildcards In Filtering
      • 0208 Multiple Criteria Using And Or In
    • Functions, Grouping And Summarizing
      • 0301 Add A Calculating Column To A SQL Statement
      • 0302 Text Manipulation Functions
      • 0303 Differences In Date Functions Within SQL
      • 0304 Calculating Age
      • 0305 Concatenate Data Columns
    • Joining Tables
      • 0401 Which Tables Can I Join And How?
      • 0402 Joining More Than Two Tables
      • 0403 Using Different Join Types
      • 0404 The Special Cross Or Cartesian Join
      • 0405 Group And Summaries Within Joined Table SQL
    • Data Modification
      • 0501 Amend Data In Tables
      • 0502 Adding Data To Tables With Insert
      • 0503 Removing Data From Tables
    • Creating And Altering Database Objects
      • 0601 Create A New Table
      • 0602 Changing A Tables Structure
      • 0603 What Is A View And How To Create One
      • 0604 Alter Or Delete A View
    • SQL Summary
      • 0701 The Main Variances In SQL Between Databases
      • 0702 The Powerful Subquery
    • Conclusions
      • 0801 Wrap Up


Course Fee:
USD 49

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