Master SQL For Data Science

4.6 (6081)
MOOC
Payment
Learning paid
Language
English
Duration
9.5 hours course
Course by Udemy
$ 129.99
$ 129.99
What will you learn?
Write complex SQL statements to query the database and gain critical insight on data
Practice Every Step of the Way by Working Through 100+ Puzzles (with solutions)
Transition from the Very Basics to a Point Where You can Effortlessly Work with Large SQL Queries
Learn Advanced Querying Techniques
Become a Master SQL Developer
About the course

LAST UPDATED: JAN 2020

This course will turn you into a SQL query wizard. You'll learn the skills you need to extract critical insight from data sitting in a database. There are over 100 puzzles scattered throughout the course with in-depth solutions providing plenty of opportunity for you to practice. After completing the course and all of it's assignments, I promise you, you'll never be afraid to look at a large SQL query again. 

Just like my other courses, I follow the no-student-left behind principle; which means that I start from the very basics. You do not need any prerequisites to take this course. We move step by step into more advanced topics as we delve into the world of advanced querying techniques using subqueries, aggregations, joins, rollups and cubes, window functions, transposing & ranking data and using conditional expressions in very interesting ways. 

With over 17,000 students and a 4.6 rating, you won't find a better source to learn SQL for Data Science elsewhere.

Don’t just take it from me, take it from other students that have taken this course.

Here’s reviews from real students that took this course

You really can't beat this course for the value. The instructor is excellent (clear explanations, easy to understand, extremely knowledgeable), and his style of constantly requiring the student to apply what they've just learned with practice queries proves to be a very effective method of learning. He covers an amazing amount of ground in just 9 hours. It was just the refresher course I needed after not having done much SQL in the past year.

Just one word - Exceptional!! Don't give a second thought, just go for it. Thanks a lot Mr.Imtiaz Ahmad. The way concepts are explained in the lectures are quite good. The assignments gave me so much confidence and I feel so happy that I am quite well versed in SQL now. Watch the videos, try out the assignments on your own and practice as much as you can with different problems.

It's a brilliant course that can help to understand SQL from easy concepts to difficult tasks. Besides, the explanations are always clear, so they let me learn a lot without searching for additional information in Internet. The course contains lots of practical tasks that allowed me not only to understand queries, but to also use them correctly.


Great! I really like the exercises that are included. They are essential to learning the course content.

After attending the course and doing most of the exercises, I feel very confident in SQL world. The course is designed well and every lesson gives you good amount of knowledge. Explanation and exercises are worth learning and practicing.

Topics covered in this course:

  • What is a Database
  • Installing Postgres
  • Creating Tables
  • SELECT Statement
  • WHERE Clause
  • AND & OR
  • Filtering Operators
  • ORDER BY
  • LIMIT
  • DISTINCT
  • Renaming Columns
  • Functions
  • GROUP BY & HAVING Clauses
  • Aggregation Queries
  • Subqueries
  • CASE Clause
  • Correlated Subqueries
  • Table Joins
  • INNER and OUTER Joins
  • UNION, UNION ALL and EXCEPT Clauses
  • Window Functions for Analytics
  • + over 100 puzzles distributed throughout the course

Enroll today to become a Master SQL Data Science Developer. As always, I offer a 30 day money back guarantee if you're not satisfied, but you won't need it.

Program
Course Overview
Database Basics
What is a Database
Install Postgres Database on Mac
Troubleshoot Connection
Install Postgres on Windows
Create Table and Insert Statements
Data file that will be used in the course (IMPORTANT)
Prepare the Database
Create More Tables and Populate Data
SQL Query Basics
Introducing the SELECT Statement
Requirements
  • No prerequisites needed for this course
Lecturers
Imtiaz Ahmad
Imtiaz Ahmad
Senior Software Engineer & Trainer @ Job Ready Programmer
Platform
/storage/img/providers/udemy.svg
Udemy courses are suited to professional development. The platform is organized in such a way that it is experts themselves that decide the topic and when the course will start. All supporting documents are made available to you for lifetime access. On this platform, you can find a course on about any subject, and that is no exaggeration – from a tutorial on how to ride a motorcycle, to managing the financial markets. The language and the course format are established by the teacher. This is why it is important to read the information about the course carefully before parting with any money.
Rating
4.6
(3590)
(2108)
(425)
(61)
(21)
Comments (6081)
Like any other website, konevy uses «cookies». These cookies are used to store information including visitor's preferences, and the pages on the website that the visitor accessed or visited. The information is used to optimize the users' experience by customizing our web page content based on visitors' browser type and/or other information. For more general information on cookies, please read the «What Are Cookies» article on Cookie Consent website.