Home
Courses
About Us
Contact
Register
Login
Back
Home
Courses
About Us
Contact
10 Sections
45 Lessons
10 Weeks
Expand all sections
Collapse all sections
Introduction to SQL & Data Analytics
4
1.1
Course Introduction
1.2
What is Database
1.3
SQL vs Excel vs Python
1.4
Install Database Software
SQL Basics
5
2.1
SQL Syntax Basics
2.2
SELECT Statement
2.3
WHERE Clause
2.4
ORDER BY
2.5
LIMIT
Filtering Data
5
3.1
AND / OR / NOT
3.2
BETWEEN
3.3
IN Operator
3.4
LIKE Operator
3.5
Wildcards
Aggregate Functions
6
4.1
COUNT()
4.2
SUM()
4.3
AVG()
4.4
MIN & MAX
4.5
GROUP BY
4.6
HAVING
Joins
5
5.1
INNER JOIN
5.2
LEFT JOIN
5.3
RIGHT JOIN
5.4
FULL JOIN
5.5
Self Join
Advanced SQL
4
6.1
Subqueries
6.2
Nested Queries
6.3
EXISTS
6.4
CASE Statement
Data Cleaning for Analytics
4
7.1
Remove Duplicates
7.2
Handling NULL Values
7.3
Data Formatting
7.4
Data Transformation
SQL for Data Analytics
4
8.1
Business Questions
8.2
Sales Analysis
8.3
Customer Analysis
8.4
Product Analysis
Window Functions (Advanced)
4
9.1
ROW_NUMBER()
9.2
RANK()
9.3
DENSE_RANK()
9.4
PARTITION BY
Real Projects
4
10.1
Sales Dashboard
10.2
Customer Analysis
10.3
Marketing Campaign Analysis
10.4
E-commerce Data Analysis
This content is protected, please
login
and
enroll
in the course to view this content!
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content
