.jpg&w=1200&q=75)
Course overview
19 sections • 117 topics • 8 hrs 28 mins
1. Introduction
10 mins
2. SQL Foundation
25 mins
Introduction to database
Start Learning
Types of database
Start Learning
SQL vs MYSQL
Start Learning
Spreadsheet vs Database
Start Learning
Understanding relational database
Start Learning
3. Numberic Data Types in SQL
21 mins
Project introduction
Start Learning
Integer
Start Learning
Big Integer
Start Learning
Tiny Integer
Start Learning
Decimal
Start Learning
Float and double
Start Learning
Bit and boolean
Start Learning
4. String Data Types in SQL
8 mins
Character
Start Learning
Variable character
Start Learning
Text
Start Learning
Enum
Start Learning
5. Date and Time Data Types in SQL
6 mins
Date and Time
Start Learning
Datetime
Start Learning
Time stamp
Start Learning
Year
Start Learning
6. Other Data Types in SQL
4 mins
BLOB
Start Learning
JSON
Start Learning
7. Understanding and Creating Schema
25 mins
Why we need database schema
Start Learning
Types of schema
Start Learning
Star Schema
Start Learning
Installing server and workbench
Start Learning
Creating first database schema
Start Learning
Snowflake schema
Start Learning
Creating snowflake schema database
Start Learning
8. Keys and Relationships
19 mins
Primary key
Start Learning
Foreign key
Start Learning
Unique composite and candidate key
Start Learning
One to one relationships
Start Learning
One to many relationships
Start Learning
Many to many relationships
Start Learning
9. CRUD Operations
28 mins
Creating a sample database
Start Learning
Creating a sample table
Start Learning
Creating data for table
Start Learning
Selecting data Crud operations
Start Learning
Altering and updating the table
Start Learning
Deleting in SQL
Start Learning
10. Project and Select Statements
1 hr
Importing data to MYSQL workbench
Start Learning
Select everything
Start Learning
Selecting multiple columns
Start Learning
Select distinct values for a column
Start Learning
Selecting info with Where clause
Start Learning
Using less than or equal to with Where clause
Start Learning
Using greater than or equal to with Where clause
Start Learning
Where with And and Multiple criteria
Start Learning
Where and Or
Start Learning
Where and In
Start Learning
Understanding Wild cards in MYSQL
Start Learning
Wild card situation practice in workbench
Start Learning
Shortcomings and operations of Where clause
Start Learning
11. Aggregations in MYSQL
39 mins
Introduction
Start Learning
Basic sum
Start Learning
Aggregations with complex situations
Start Learning
Basic count
Start Learning
Complex count
Start Learning
Average
Start Learning
Max and min
Start Learning
12. Assignment
5 mins
Assignment - I
Start Learning
Solution
Start Learning
13. Group By, Order By and Having
34 mins
Group By statement
Start Learning
Group By in MYSQL workbench
Start Learning
Order by statement
Start Learning
Having
Start Learning
14. Joins
54 mins
What are joins
Start Learning
Exploring dataset and cross joins
Start Learning
Understanding left join
Start Learning
Practising left join with aggregations
Start Learning
Right join
Start Learning
Right join example
Start Learning
Practising right join with aggregations
Start Learning
Inner join
Start Learning
Practicing inner join
Start Learning
Union
Start Learning
Union all
Start Learning
15. More Operators and Null Management
14 mins
Between and And
Start Learning
Limit
Start Learning
Not between
Start Learning
Is not null
Start Learning
Is null
Start Learning
16. Case statements
25 mins
Understanding case statement updates
Start Learning
Practicing case statement - I
Start Learning
Practicing case statement - II
Start Learning
Practicing case statement - III
Start Learning
17. Subqueries
26 mins
Introduction to subqueries
Start Learning
Scalar subquery
Start Learning
Practicing scalar subquery
Start Learning
Scalar subquery Q2
Start Learning
Complex subquery using joins and multiple tables
Start Learning
18. Window Functions
5 mins
Introduction to windows function
Start Learning
19. Capstone Project
1 hr
Find the active branch list
Start Learning
Fetching the basic product details from the table
Start Learning
Recent costumer signups
Start Learning
Orders overview
Start Learning
Unresolved customer support tickets
Start Learning
Fetching customer support info using Joins
Start Learning
Total revenue made
Start Learning
Average response time to customers
Start Learning
Active employee count for department
Start Learning
Expired products from inventory
Start Learning
Campaigns by channels
Start Learning
Active assets deployed in branches
Start Learning
Top 5 products by their revenue
Start Learning
Asset depreciation calculation
Start Learning
High cost employees by department
Start Learning
Return of investment on branches
Start Learning
Delivery type performance
Start Learning
Customer order frequency
Start Learning
Top 3 products per category
Start Learning
Inventory expiry tracker
Start Learning
Campaign spend efficiency
Start Learning
About the course
Meet your instructor
988
Learners
Beginner
Level
English
Language
1 Year
Access
1
Certificate
8 hrs 28 mins
Duration
₹---
Certificate of completion
