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 and Relational Databases for Analysts

Course Summary

This course teaches the principles of Relational Databases and the SQL language. It is intended for "Analysts". Knowledge of Relational Databases and SQL is one of the most valued technical skills an analyst can have. It will make you a more valued member of any team. For a limited period I am offering this course at 30% of the nor

  • +

    Course Syllabus

    • Section 1: Introductions: The course, databases and the tools
    • Section 2: Structured Query Language (SQL), DML and SELECT
    • Section 3: Introducing Derived Columns and Functions
    • Section 4: Changing data in a table
    • Section 5: More with SELECT
    • Section 6: The Database Manager and the Database Administrator
    • Section 7: Defining the database: Data Definition Language (DDL)
    • Section 8: NULL: a load of fuss over nothing!
    • Section 9: A question of identity?
    • Section 10: Indexes
    • Section 11: Normalization, Data Modelling and JOIN
    • Section 12: Temporary tables and VIEWs
    • Section 13: Securing the database: Data Control Language (DCL)
    • Section 14: Course review 

  • +

    Recommended Background

    •  The primary requirement for this course is an inquisitive, analytical mind. You want to "understand how things work."
    • You do not need to be a programmer or mathematician. What little programming or mathematics is needed, I will explain during the course.
    • If you are going to do the exercises, then you will need a PC capable of running MS SQL Server, and have Administrator authority to install software.
    • You will find the course easier if you have experience using a text editor such as Notepad, or Word, and a spreadsheet such as Excel. You should also know how to create and use subdirectories in the Windows directory structure.

  • +

    Course Format

    This course contains 7 hours of video content in 56 lectures organised into 14 sections.
    Typically, each section will contain lectures and demonstrations. In most sections there are practical exercises and sometimes there are additional reading assignments. As you progress you can test yourself in 13 quizzes.
    You can revisit earlier parts of the course at any time.

Course Fee:
USD 29

Course Type:


Course Status:


This course is listed under Development & Implementations and 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