What you'll learn
Be able to write simple and complex SQL queries
Be able to create a real working DB
Be able to answer exam questions regarding SQL
Course content
9 sections * 32 lectures * 3h 29m total length
Requirements
Be able to work with computer
Basic understanding of programming
Description
SQL stands for Structured Query Language. It is used to retrieve data that is located in tables in a relational data-base.
SQL abilities are enormous, and the better you know it, the better your abilities to gain data and insights about it would be.
In this course I'll teach you all the elements of SQL, and I'll do it by writing queries. A lot of queries. I believe that the best way to learn SQL is to practice it with all kind of possible queries and manipulations, and that's what I'll do in this course.
Every lesson in this course contains example queries, exercise and all of them are available for you as source code to download.
In addition, I supply to you a full and functioning DB, with a lot of data, so you can try by your own your SQL skills.
Who should take this course?
If you learn an academic course on data bases, you probably have SQL part. This course can give you all the needed knowledge for answering SQL questions in University and colleges exams on SQL.
If you are a developer who wants to integrate data base in your application - this course is for you.
If you plane to design a system and you uncertain of how would you access the data and make use of it - this course is for you.
What you get from this course?
After completing the course you'll be able to write any SQL query in order to retrieve any data you want from a data base.
This course contains dozens of queries, from all levels and all topics.
This course also contains a real DB to make trials on.
This course contains a quiz for each section, quiz that would help you asses your advancement.
An important note
The course is still under construction so I'll add the next sections in the next two weeks. You'll get an announcement whenever a new section is added.
Who this course is for
Students in DBMS Courses
People who are curious about querying a data base
Programmers who want to incorporate DB in their systems