SQL Course 2024: SQL for Data Analysis and Data Science.

Master the Art of SQL Querying and PostgreSQL for Data Analysis and Data Science An using Real World SQL Database.

4.02 (950 reviews)
Udemy
platform
English
language
Data & Analytics
category
Temotec Learning Academy
instructor
SQL Course 2024: SQL for Data Analysis and Data Science.
127,939
students
5.5 hours
content
Apr 2024
last update
$49.99
regular price

What you will learn

Using Real World PostgreSQL Database Airlines Database.

Use Python Pandas to Analyze and visualize Postgres Data Output.

SQL Test Your Self, SQL Challenges, SQL Final Exam and more

Use Python to visualize Postgres Data Output and get your Conclusion about Data.

Use SQL to create databases.

Use Python bs4 & Pandas to Scrape a webpage, Analyze and visualize The Scraped Data.

Use SQL to insert data into a table.

Use SQL to Query & retrieve data from databases.

Use SQL to Sort records after retrieving from databases.

Use SQL to Group data by specific conditions.

Use SQL to Filter data by using where clause.

How & when to use Joins types in SQL.

How to create and deal with Sub-queries in SQL.

How to create and deal with common table expression in SQL.

Use SQL to perform data analysis of real world databases

Use SQL to perform advanced techniques to retrieve data from databases.

Use Python with SQL Postgres database.

Use Python to load Postgres Data Output file.

Apply what you will learn in Python & SQL through exercises.

Why take this course?

SQL is a powerful language used to retrieve insightful data from databases. Whether you're new to SQL or an experienced data analyst, this complete SQL bootcamp will teach you everything you need to know to become a SQL query expert.


In this comprehensive course, we'll cover everything from the basics of SQL to more advanced topics in PostgreSQL. With real-world examples and hands-on exercises, you'll learn the skills you need to retrieve and analyze data, and practice with quizzes and challenges distributed throughout the course.


By the end of this course, you'll be comfortable using SQL and PostgreSQL for data analysis and data science, and be able to tackle real-world problems with ease.


What you will learn in this course:


- Understand the basics of SQL and PostgreSQL, including installation and table creation.

- Master SQL queries, including SELECT statements, WHERE clauses, operators, and filtering.

- Explore advanced SQL querying techniques, including ORDER BY, LIMIT, DISTINCT, and GROUP BY.

- Learn how to use subqueries and correlated subqueries for advanced data analysis.

- Discover window functions for analytics in SQL, and master table joins and aggregation queries.

- Practice with quizzes and challenges distributed throughout the course.

- Use Python with SQL and PostgreSQL, including loading Postgres data output files and analyzing data with Pandas.


This comprehensive bootcamp is taught by an experienced data science instructor with years of industry experience. He breaks down complex SQL concepts into clear, easy-to-understand lessons using real-world examples and visualization aids.


The course curriculum was designed to take you from absolute beginner to job-ready SQL expert. Each module builds on the last, introducing new SQL clauses and techniques and allowing you to practice them hands-on.


By the end of the course, you will have queried complex datasets and built full SQL queries using subqueries, aggregations, analytical functions, and more. These are the exact skills top employers are looking for in data professionals.


Learning a new skill requires hands-on practice. This bootcamp provides you with downloadable SQL code exercises, mini-projects, and quizzes to test your understanding along the way. Mastering SQL has never been easier!


If you want to become a data analysis pro, this is the most comprehensive SQL course available online. Enroll now and start querying data like an expert today!

Content

Introduction

Course Introduction

PostgreSQl database Download & Install

PostgreSQl Download & Install
Create Database
Restore Database

Test You Self (1)

Test You Self (1)
Test You Self (1) Solution

Database Airlines Overview

Database Overview 1
Database Overview 2

SQL Basics

SQL Data Types
Select Statement
Select Challenge Solution
Select Statement For all Airlines Database Tables
Distinct
Where Clause
Operators used with Where Clause
Where Clause + AND & Where Clause + OR
Where Clause + LIKE
LIMIT & ORDER BY
FETCH vs LIMIT
(Where Clause + BETWEEN & IN) & AS
NOT IN
ISNULL & IS NOT NULL
CAST

Test You Self (2)

Test You Self (2)
Test You Self (2) Solution

SQL Basics Challenge

SQL Basics Challenge
SQL Basics Challenge Solution

SQL Aggregations

COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE
SUM( ) Function
MIN( ) , MAX( ) & AVG( ) Functions
GROUP BY & HAVING

Test You Self (3)

Test You Self (3)
Test You Self (3) solution

SQL Aggregation Challenge

SQL Aggregation Challenge
SQL Aggregation Challenge Solution

SQL Conditional

CASE
NULLIF()
COALESCE() Function in SQL

Test You Self (4)

Test You Self (4)
Test You Self (4) solution

SQL Conditional Challenge

SQL Conditional Challenge
SQL Conditional Challenge Solution

SQL Time Data management

Overview of Time Functions in PostgreSQL
TIMESTAMP EXTRACT()
DATE_TRUNC() & DATE_PART()
::DATE IN PostgreSQL & CURRENT_DATE & now( )

SQL Joins

INNER JOIN
Joins Types
LEFT OUTER JOIN
Deep understanding of LEFT JOIN
RIGHT OUTER JOIN
FULL OUTER JOIN
CROSS JOIN
UNION, UNION ALL, INTERSECT & EXCEPT
SELF JOIN
USING
NATURAL JOIN

Test You Self (5)

Test You Self (5)
Test You Self (5) solution

SQL JOINS Challenge

SQL JOINS Challenge
SQL JOINS Challenge Solution

Intermediate SQL

Sub-queries
SQL Sub-query + EXISTS OR ANY OR ALL
Common Table Expression

Test You Self (6)

Test You Self (6)
Test You Self (6) solution

SQL Sub-query Challenge

SQL Sub-query CTE Challenge
SQL Sub-query CTE Challenge Solution

Advanced PostgreSQL Functions

Math Functions
Window Functions OVER()
Window Functions RANK() + OVER() & NTILE() + OVER()
Window Functions OVER() + LEAD()
Window Functions OVER() + LAG()

Advanced SQL

GROUPING SETS(), ROLLUP(), CUBE()
SELECT Statement + INTO & SELECT Statement + INTO + IN
VIEW()

Test You Self (7)

Test You Self (7)
Test You Self (7) Solution

PostgreSQL String Functions

PostgreSQL POSITION Function
STRPOS() & REPLACE() in PostgreSQL
PostgreSQL LEFT(), RIGHT(), BTRIM() & SPLIT_PART() Functions
PostgreSQL CONCAT Function
PostgreSQL LOWER(), UPPER() & INITCAP() Functions

Test You Self (8)

Test You Self (8)
Test You Self (8) solution

Python + PostgreSQL introduction

Python Download & Install
Online jupyter lab
Using CMD & Python Pip.PyPi to Install Jupyter Lab & Pandas
Jupyter Commands
Using Python to load and querying PostgreSQL Database
Runnig SQL Query Using Python Panadas Module
Using Python Pandas Package to load PostgreSQL the Data Output file

Using Python in Data Analysis of PostgreSQL Data output

Data Analysis Process Overview
Pandas Methods
Pandas Data Analysis
Pandas data visualization
Sampling Error

Final Exam

Final Exam
Final Exam Solution

Bonus Section -Thank You

Bonus Section -Thank You

Screenshots

SQL Course 2024: SQL for Data Analysis and Data Science. - Screenshot_01SQL Course 2024: SQL for Data Analysis and Data Science. - Screenshot_02SQL Course 2024: SQL for Data Analysis and Data Science. - Screenshot_03SQL Course 2024: SQL for Data Analysis and Data Science. - Screenshot_04

Reviews

Neo
August 10, 2023
Thank you soo much. The language was a small problem but thanx to the transcript I made it through. You are the best and thank you for being so practical throughout.
Anton
July 6, 2023
It is not said that we should download Airlines.sql file and it took some time to investigate this. Not enough exaples where we can use specific join. Which will less impact on performance and etc.
Lautaro
June 24, 2023
The oratory and pronunciation could be better. I find it hard, sometimes, to understand what is he saying.
Farah
February 2, 2023
It was kind of good given the knowledge it provided, but I had to search few things because the instructor's language wasn't clear most of the videos, also the instructor needs to speak up.
Henry
January 19, 2023
The course was excellent. However, consider putting a link to the airlines' database data so that it is easy to follow along.
Sudarshan
August 18, 2022
explanation is excellent,but your pronounsation is little difficult to understand.One more thing i want to say that you have created the airline database which is totally unkonwn for us thats why we are trobulling at the time of joins.but overall your course is better sir.Thanks for giving us great konwlegde over postgresql
Lori
August 17, 2022
While it is rude to comment on someone speaking a second or third language, unfortunately, in this case the skill level in English is not at the level for teaching. There are many words the instructor is not comfortable pronouncing and instead of practicing prior to recording, they chose to rush through the words or cut them out, causing completely unintelligible instructors and explanations.
Leonardo
February 24, 2022
Explica como realizar consultas, pero pasa mas tiempo leyendo lo que escribe que explicando el funcionamiento del mismo
Marco
February 14, 2022
Not taking into consideration his pronunciation (because just the fact to be bilingual is awesome), explanation is not his strength, is very difficult to follow.
Amin
January 23, 2022
Thanks a lot for your amazing course. I enjoyed the course. The course covered almost all important and fundamental parts of SQL. There are many examples and exercises to better understanding the concepts and improve your skills.
Lubin
December 20, 2021
Poor sound quality in some videos. It's really hard to understand english. Instructor skip steps and you easily can waste minutes (even hours) to determine how he got there.
Moussa
October 9, 2021
Super bad english and he does not explain things he just read the instruction. Also, I could not upload the data in order to use it and be in parallel with him. I wasted 5 hours of my life and half an hour learning to not get such a course ever.
Bussa
September 17, 2021
i am learing about the course throughly but the software is not getting installed properly and give the proper guidance of all arterstisks how to use the ``this symbols etc
Nii
September 7, 2021
The accent makes it difficult to understand at certain points but the technical details all check out so far.
Vorrasit
September 4, 2021
It's a bit challenging to listen and try to understand the instructor, and the subtitle is auto-generated and does not help much. But I admit the content is rich and deep in technical aspect. I learn a lot in PsogreSQL. I wish there could be more content talking about Python to interact and analyse data between PostgreSQL. Anyway, thanks for the course.

Coupons

DateDiscountStatus
11/4/202092% OFF
expired
11/26/202092% OFF
expired
1/16/202192% OFF
expired
1/21/2021100% OFF
expired
2/9/2021100% OFF
expired
2/22/202150% OFF
expired
2/25/2021100% OFF
expired
3/18/2021100% OFF
expired
4/13/2021100% OFF
expired
4/28/202150% OFF
expired
5/3/202150% OFF
expired
5/5/2021100% OFF
expired
7/14/2021100% OFF
expired
8/30/202150% OFF
expired
10/22/2021100% OFF
expired
11/7/2021100% OFF
expired
12/10/2021100% OFF
expired
1/18/2022100% OFF
expired
2/14/2022100% OFF
expired
4/17/2022100% OFF
expired
5/15/2022100% OFF
expired
7/30/2022100% OFF
expired
8/23/2022100% OFF
expired
9/4/2022100% OFF
expired
10/14/2022100% OFF
expired
11/20/2022100% OFF
expired
12/21/202250% OFF
expired
12/25/2022100% OFF
expired
3/12/2023100% OFF
expired
4/16/2023100% OFF
expired
6/20/2023100% OFF
expired
7/16/2023100% OFF
expired
8/10/2023100% OFF
expired
8/22/202380% OFF
expired
9/4/2023100% OFF
expired
10/13/2023100% OFF
expired
11/9/2023100% OFF
expired
12/3/2023100% OFF
expired
1/3/2024100% OFF
expired
3/7/2024100% OFF
expired

Charts

Price

SQL Course 2024: SQL for Data Analysis and Data Science. - Price chart

Rating

SQL Course 2024: SQL for Data Analysis and Data Science. - Ratings chart

Enrollment distribution

SQL Course 2024: SQL for Data Analysis and Data Science. - Distribution chart

Related Topics

Python
Data Analysis
PostgreSQL
SQL
3477148
udemy ID
9/5/2020
course created date
11/4/2020
course indexed date
Bot
course submited by