Become Job-Ready in MySQL Data Analyst
- In Just 2 Weeks, Not Years

Kick off your journey with an introduction to the course structure, objectives, and what you can expect to achieve by the end of the masterclass. Meet your instructors and fellow participants, and get ready to dive into the world of MySQL.

• Role of SQL in Data Analytics
• Overview of RDBMS and MySQL
• Installation and configuration of MySQL Workbench
• Database concepts: schema, tables, rows, and columns
• Basic SQL queries: SELECT, FROM
• LIMIT and basic ORDER BY
• Hands-on: Exploring and previewing a sample dataset

• WHERE clause and logical operators (AND, OR, NOT)
• BETWEEN, IN, LIKE, IS NULL
• Column aliases and output formatting
• DISTINCT keyword
• Numeric and string functions:
• ROUND(), CONCAT(), UPPER(), LOWER()
• Hands-on: Filtering and formatting customer or sales data

• Aggregate functions:
  COUNT(), SUM(), AVG(), MIN(), MAX()
• GROUP BY clause
• HAVING vs WHERE
• Derived metrics and calculated fields
• Translating business questions into SQL queries
• Hands-on: Sales trends and customer behavior analysis

• Overview of database normalization
• Types of joins:
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
• Table aliases and join best practices
• Hands-on: Joining orders, customers, and products tables

• Conditional logic using CASE statements
• Scalar and IN subqueries
• EXISTS and correlated subqueries (introductory level)
• Data quality checks:
  • Handling NULL values
  • Identifying duplicates
• Creating views for reusable analysis
• Hands-on: Analytical query scenarios and data validation

• Introduction to window functions:
  • ROW_NUMBER()
  • RANK()
• Analytical use cases:
  • Ranking
  • Top-N analysis
  • Trend evaluation
• Exporting query results for reporting

• Capstone Mini-Project:
  • Exploratory Data Analysis on a business dataset
  • KPI computation
  • Interpretation of results