SQL for Data Analysis: Beginner MySQL Business Intelligence

BY
Udemy

Mode

Online

Fees

₹ 599 4099

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

  • 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

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

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books