SQL Course: SQL for Data Analysis and Data Science
5.0 /5- Offered byUDEMY
SQL Course: SQL for Data Analysis and Data Science at UDEMY Overview
Duration | 6 hours |
Total fee | ₹499 |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
SQL Course: SQL for Data Analysis and Data Science at UDEMY Highlights
- Earn a certificate after completion of course by udemy
- 5 downloadable resources
- Full lifetime access
- Access on mobile and TV
- 30-Day Money-Back Guarantee
SQL Course: SQL for Data Analysis and Data Science at UDEMY Course details
Individuals looking to enter the fields of data analysis and data science who need a solid foundation in SQL to manage, query, and analyze datasets
Professionals who use data to make strategic decisions and need to be proficient in SQL to extract and manipulate data from various databases
Developers who want to enhance their skill set with SQL to build data-driven applications or work more effectively with data
Recently graduated in fields related to data science, statistics, computer science, or similar areas who are looking to build practical skills in data analysis
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
The course is designed to provide a robust foundation in SQL, the essential language for querying and manipulating relational databases
Whether you are aiming to enter the fields of data analysis or data science, or simply looking to enhance your data handling skills, this course will equip you with the tools and knowledge needed to extract actionable insights from complex datasets
You'll learn the skills you need to retrieve and analyze data, and practice with quizzes and challenges distributed throughout the course
SQL Course: SQL for Data Analysis and Data Science at UDEMY Curriculum
Introduction
Course Introduction
Beginner: PostgreSQL Downloading & Installing + Preparing Airlines Database
PostgreSQL Downloading & Installing
Create Database
Restore Database
Test You Self (1)
Test Your Self (1)
Test You Self (1) Solution
Beginner: Database Airlines Overview
Database Overview Part 1
Database Overview Part 2
SQL Data Types
Beginner: SQL Basics Part1
Select Statement
Select Challenge Solution
Select Statement For all Airlines Database Tables
Distinct
Beginner: SQL Basics Part 2
Where Clause
Operators used with Where Clause
Where Clause + AND & Where Clause + OR
Where Clause + LIKE
(Where Clause + BETWEEN & IN) & AS
Beginner: SQL Basics Part 3
LIMIT & ORDER BY
FETCH vs LIMIT
NOT IN
ISNULL & IS NOT NULL
CAST
Test You Self (2)
Test Your Self (2)
Test Your Self (2) Solution
SQL Basics Challenge
SQL Basics Challenge
SQL Basics Challenge Solution
Intermediate: SQL Aggregations
COUNT( ) Function, CREATE TABLE & INSERT INTO TABLE
SUM( ) Function
MIN( ) , MAX( ) & AVG( ) Functions
GROUP BY & HAVING
Test You Self (3)
Test Your Self (3)
Test Your Self (3) solution
SQL Aggregation Challenge
SQL Aggregation Challenge
SQL Aggregation Challenge Solution
Intermediate: SQL Conditional
CASE
NULLIF()
COALESCE() Function in SQL
Test You Self (4)
Test Your Self (4)
Test Your Self (4) solution
SQL Conditional Challenge
SQL Conditional Challenge
SQL Conditional Challenge Solution
Intermediate: SQL Time Data management
Overview of Time Functions in PostgreSQL
TIMESTAMP EXTRACT()
DATE_TRUNC() & DATE_PART()
::DATE IN PostgreSQL & CURRENT_DATE & now( )
Intermediate: 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 Your Self (5)
Test Your Self (5) solution
SQL JOINS Challenge
SQL JOINS Challenge
SQL JOINS Challenge Solution
Intermediate: Sub-queries & Common Table Expression in SQL
Sub-queries
SQL Sub-query + EXISTS OR ANY OR ALL
Common Table Expression
Test You Self (6)
Test Your Self (6)
Test Your 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: Other SQL Functions
GROUPING SETS(), ROLLUP(), CUBE()
SELECT Statement + INTO & SELECT Statement + INTO + IN
VIEW()
Test You Self (7)
Test Your Self (7)
Test Your 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 Your Self (8)
Test Your Self (8) solution
Final Exam
Final Exam Quiz 1
Final Exam Quiz 1 Solution
Final Exam Quiz 2
Final Exam Quiz 2 Solution
Final Exam Quiz 3
Final Exam Quiz 3 Solution
Final Exam Quiz 4
Final Exam Quiz 4 Solution
Final Exam Quiz 5
Final Exam Quiz 5 Solution
Final Exam Quiz 6
Final Exam Quiz 6 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 Pandas in Data Analysis of PostgreSQL Data output
Data Analysis Process Overview
Pandas Methods
Pandas data visualization
Pandas Data Analysis
Sampling Error
Extra1: Scrape the Web & Saving Data to a Database
How to Scrape a website???
Scrape a Table inside a Webpage using Pandas and LXML Python Modules!
Visualization of the Scarped Data.
Save The Scraped Data to a Database.
Bonus Section -Thank You
Bonus Section -Thank You
Other courses offered by UDEMY
SQL Course: SQL for Data Analysis and Data Science at UDEMY Students Ratings & Reviews
1 Rating- 4-51
Student Forum
Anything you would want to ask experts?