Master SQL For Data Science | Udemy Free Download

Master SQL For Data Science | Udemy
English | Size: 2.65 GB
Genre: eLearning

What you’ll 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

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.

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.

Who this course is for:
Anyone who wants to break into the data analyst or data scientist role
Anyone interested in become a SQL query wizard