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
Download this SQL Template and stick it on the Wall so that it will help you in forming the SQL statement....
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.