Brochure
Enquire
- Course Structure & Outline - MySQL Database for Beginners
- READ ME: Important Notes for New Students
- DOWNLOAD: Course Resources
- Introducing the Course Project - Play the Role of Business Analyst
- Setting Expectations - Focus on Business Analysis, NOT MySQL Administration
SQL for Data Analysis: Beginner MySQL Business Intelligence
Quick Facts
| particular | details | |||
|---|---|---|---|---|
|
Medium of instructions
English
|
Mode of learning
Self study
|
Mode of Delivery
Video and Text Based
|
Course and certificate fees
Fees information
₹ 599 ₹4,099
certificate availability
Yes
certificate providing authority
Udemy
The syllabus
Getting Started
MySQL Intro & Setup
- Introduction to Installing MySQL and MySQL Workbench for Beginners
- Why Learn SQL From Scratch? The Ultimate MySQL Bootcamp is Worth It!
- History & SQL "Flavors" (MySQL, MS SQL Server, SQL Lite, T SQL, Microsoft SQL)
- MySQL Installation Overview
- Mac Download - Community Server
- Mac Download - MySQL Workbench
- PC Download - Community Server + Workbench
- Connecting Workbench to the Server
- MySQL Workbench Interface
- Creating the Maven Movies Database
- QUIZ: MySQL Intro & Setup
Single Table Analysis (PART 1)
- Introduction to Databases and SQL Querying
- Getting to Know the Database
- The "Big 6" Statements and Clauses of SQL Queries
- The SELECT Statement - Your SQL Querying Starts Here
- The FROM Clause - Tell the Server Which Table Your SQL Query Will Pull Data From
- SELECT * FROM
- The USE Statement
- Selecting Specific Columns
- ASSIGNMENT: SELECT & FROM
- SOLUTION: SELECT & FROM
- SELECT DISTINCT
- ASSIGNMENT: SELECT DISTINCT
- SOLUTION: SELECT DISTINCT
- The WHERE Clause
- Common WHERE Operators
- ASSIGNMENT: The WHERE Clause
- SOLUTION: The WHERE Clause
- Combining WHERE & AND
- ASSIGNMENT: WHERE & AND
- SOLUTION: WHERE & AND
- Combining WHERE & OR
- ASSIGNMENT: WHERE & OR
- SOLUTION: WHERE & OR
- Combining WHERE & IN
- The LIKE Operator
- LIKE Wildcard Examples
- ASSIGNMENT: The LIKE Operator
- SOLUTION: The LIKE Operator
- The GROUP BY Clause
- GROUP BY Example
- PRO TIP: Using Comments & Aliases
- ASSIGNMENT: GROUP BY
- SOLUTION: GROUP BY
- Multiple Dimension GROUP BY Clauses
- Grouping with Aggregate Functions
- ASSIGNMENT: Aggregate Functions
- SOLUTION: Aggregate Functions
- The HAVING Clause
- HAVING Example
- ASSIGNMENT: The HAVING Clause
- SOLUTION: The HAVING Clause
- The ORDER BY Clause
- ORDER BY Example
- ASSIGNMENT: The ORDER BY Clause
- SOLUTION: The ORDER BY Clause
- RECAP: The "Big 6"
- QUIZ: Single Table Analysis (PART 1)
Single Table Analysis (PART 2)
- The CASE Statement
- CASE Example
- Common CASE Operators
- ASSIGNMENT: The CASE Statement
- SOLUTION: The CASE Statement
- PRO TIP: "Pivoting" with COUNT & CASE
- COUNT & CASE Demo
- ASSIGNMENT: COUNT & CASE
- SOLUTION: COUNT & CASE
- QUIZ: Single Table Analysis (PART 2)
Mid-course project
- Mid-Course Project Intro
- SOLUTION: Mid-Course Project
Analyzing Multiple Tables with Joins
- Introduction to SQL JOINs and Querying Multiple Tables
- Normalization & Cardinality
- Relationship Diagrams
- Multi-Table Querying
- Reviewing the Maven Movies Database
- Common JOIN Types
- INNER JOIN
- INNER JOIN Example
- ASSIGNMENT: INNER JOIN
- SOLUTION: INNER JOIN
- LEFT JOIN
- LEFT JOIN Example
- ASSIGNMENT: LEFT JOIN
- SOLUTION: LEFT JOIN
- RIGHT JOIN
- LEFT vs. INNER vs. RIGHT JOIN
- FULL OUTER JOIN
- PRO TIP: "Bridging" Unrelated Tables
- ASSIGNMENT: "Bridging" Tables
- SOLUTION: "Bridging" Tables
- Multi-Condition Joins
- ASSIGNMENT: Multi-Condition Joins
- SOLUTION: Multi-Condition Joins
- The UNION Operator
- UNION Example
- ASSIGNMENT: The UNION Operator
- SOLUTION: The UNION Operator
- QUIZ: Multi-Table Analysis
Final Project
- Final Project Intro
- SOLUTION: Final Project
Wrapping Up
- Resources & Next Steps - After this SQL for Beginners Course
- BONUS LECTURE: More from Maven
Articles
Popular Articles
prev
next
