Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Update 10/06/2016: Added new exercises
Update 01/04/2016: Closed Captions/Sub Titles are added to the Lectures.
Learn to become a fee-earning SQL developer in just seven weeks.
This fast, easy and effective course will take you from zero sql writing skills to being able to make money as a SQL developer.
This one-stop-shot-style SQL course will teach you everything you need to know about SQL, from learning various database concepts to writing SQL to interact with the database.
Throughout this SQL course I will be using the below methodology to make you think and help in forming the SQL statement.
Manager asks you to give you a report containing total sales volume for January month by day and city
Questions in your mind to build your SQL query
Combine the above answers to form the below SQL
SELECT day, city, SUM(volume)
WHERE sales_date BETWEEN ’01-JAN-2015’ AND ’31-JAN-2015’
GROUP BY day, city;
In this course participants will learn
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
Closed Captions/Sub Titles for the course
How to make best use of the programPreview
|Section 1: Software Installation|
Installing Java SDK
Installing SQL Developer
Running scripts necessary for the course
Scripts for our Lab ExercisesPreview
|Section 2: Database Concepts|
What is a Table?
What is a Database?
What is a Relational Database (RDBMS)?
What is a Transaction?
What is ACID??
|Section 3: Enter the Dragon (Database)|
Download this SQL Template and stick it on the Wall so that it will help you in forming the SQL statement....
How do you talk with a Database?
What are the most common commands?
What type of Data can we store?
Data Model for our Course
|Section 4: Lets see the Data...|
What data can I see?
How do I see data (SELECT) ?Preview
How do I see a part of the data (SELECT) ?
Lab 1 (Exercises with Answers)
|Section 5: Lets limit the data we see (Filtering)|
Filtering Data (WHERE command)Preview
Filtering Data (More Examples...)
Filters on Character and Date values...
Filtering based on a column in a table...
Lab 2 (Exercises with Answers)
|Section 6: Logical Operators|
BETWEEN and NOT BETWEENPreview
IN and NOT IN
ALL and ANY
Lets learn about NULL...
IS NULL and IS NOT NULL
AND and OR
Lab 3 (Exercises with Answers)
|Section 7: Arithmetic operators|
They are simple!!! (10 + 20 = 30)Preview
Lab 4 (Exercises with Answers)
|Section 8: Lets sort the data we see (Sorting)|
ORDER BY clause
How are NULL values treated while Sorting Data?
Lab 5 (Exercises with Answers)
|Section 9: How do we combine data from 2 tables?|
UNION ALL operatorPreview
Lab 6 (Exercises with Answers)
|Section 10: Lets group the data...|
GROUP BY clause
GROUP BY with multiple columns
GROUP BY with HAVING clause
Lab 7 (Exercises with Answers)Preview
|Section 11: Joining data from 2 or more tables (JOINS)|
Left Outer Join
Right Outer Join
Full Outer Join
Joining the 3rd table
Joining the 4th table and so on...
Adding filters to Joins
Lab 8 (Exercises with Answers)
|Section 12: Functions available for us to use...|
DUAL (What is this?)
Why do we need functions?
NUMBER related functions
CHARACTER related functions
DATE related functions
Lab 9 (Exercises with Answers)Preview
|Section 13: Interesting THINGS!!!|
IF THEN ELSE (CASE statement)
Alternative Name (ALIAS name)
|Section 14: Data Definition Language (DDL)|
Let's create a table (CREATE)
Let's change the structure of a table (ALTER)
Let's delete the table (DROP)
Create Table AS - CTAS
Lab 11 (Exercises with Answers)
|Section 15: Data Manipulation Language (DML)|
COMMIT and ROLLBACK
Insert data into a table (INSERT)
Delete data from a table (DELETE)
Modify existing data in a table (UPDATE)
Delete all the data from a table (TRUNCATE)
Lab 12 (Exercises with Answers)
Amarnath has a Masters Degree in computer science with around 15 years of experience in the IT industry. He has successfully designed and implemented projects for clients in South Africa, India and USA. Currently his main focus is on Datawarehouse Architecture.
Amarnath is currently working for a fortune 500 company in USA and has pioneered the data architecture discipline. His Innovative and simple architectural designs have won accolades in the company.
Today, he brings leadership and technical expertise to enable customers to optimize and modernize their IT environments leveraging Business Intelligence tools, Big Data, social, mobile, and the Internet of Things.