Share Description
In this course, you will:
- Provides a beginner-friendly introduction to Structured Query Language (SQL) and Business Intelligence tools such as Microsoft Excel and Tableau.
- By the end of the course, you will have created an interactive business intelligence dashboard based on a real-world dataset.
Syllabus:
1. Relational Databases and SQL
- Setting up MySQL and creating tables
- Inserting and querying data with SQL
- Keys, references, and aggregations
2. Aggregation and Joins with SQL
- Aggregation functions and grouping
- Combining data with SQL joins
- Improving performance with indexes
3. SQL Querying Practice
- Selection, filtering, and ordering
- Functions, aggregations, and joins
- Adding new tables and records
4. Window Functions in SQL
- Syntax and use cases of window functions
- Aggregation, ranking, and value functions
- Advanced windowing with rows & ranges
5. Advanced Topics in SQL
- Working with dates and strings
- Advanced clauses and functions
- Stored procedures and recursion
6. Advanced SQL Practice
- Window Function Syntax
- Date, Aggregate & Ranking Functions
- CTE, CASE-WHEN-THEN-ELSE
7. Data Analysis and Visualization with Excel
- Working with sheets, cells, formulas & functions
- Analyzing and visualizing a real-world dataset
- Styling, data validation & conditional formatting
8. Tableau for Visualization & Dashboards
- Installing Tableau and importing data
- Answering questions using visualizations
- Creating interactive online dashboards
9. Dashboarding with Power BI
- Installing Power BI and importing data
- Answering questions using visualizations
- Publishing interactive dashboards online
10. Business Intelligence Dashboard
- Data analysis using Microsoft Excel
- Data visualization using Tableau
- Creating and publishing dashboards
11. Solving SQL Challenges
- Finding practice problems online
- 3 Step Approach for solving SQL problems
- Approaching Stratascratch, LeetCode & Hackerrank problems
