Current Status
Not Enrolled
Price
Subscribe Now
Get Started
Take this Course
Business Intelligence Analyst Course
Module Content
Expand All
Module Resources
1 Topic
Expand
Lesson Content
0% Complete
0/1 Steps
Download All Resources
Relational Database Theory and Introduction to SQL
10 Topics
Expand
Lesson Content
0% Complete
0/10 Steps
Why use SQL?
Why use MySQL?
Introducing Databases
Relational Database Fundamentals
Comparing Databases and Spreadsheets
Important Database Terminology
The Concept of Relational Schemas: Primary Key
The Concept of Relational Schemas: Foreign Key
The Concept of Relational Schemas: Unique Key and Null Values
The Concept of Relational Schemas: Relationships Between Tables
SQL – Install and get to know MySQL
8 Topics
Expand
Lesson Content
0% Complete
0/8 Steps
Installing MySQL Workbench and Server
Installing Visual C
Installing MySQL on macOS and Unix systems
The Client-Server Model
Linking GUI with the MySQL Server
Read me!!!
Creating a New User and a New Connection to it
Familiarize Yourself with the MySQL Interface
SQL – Best SQL Practices
2 Topics
Expand
Lesson Content
0% Complete
0/2 Steps
Coding Tips and Best Practices – I
Coding Tips and Best Practices – II
SQL – Loading the ’employees’ Database
1 Topic
Expand
Lesson Content
0% Complete
0/1 Steps
Loading the ’employees’ Database
SQL – Pratical Application of the SQL SELECT Statement
58 Topics
Expand
Lesson Content
0% Complete
0/58 Steps
Using SELECT – FROM
Using SELECT – FROM – Exercise
Using SELECT – FROM – Solution
Using WHERE
Using WHERE – Exercise
Using WHERE – Solution
Using AND
Using AND – Exercise
Using AND – Solution
Using OR
Using OR – Exercise
Using OR – Solution
Operator Precedence and Logical Order
Operator Precedence and Logical Order – Exercise
Operator Precedence and Logical Order – Solution
Using IN – NOT IN
Using IN – NOT IN – Exercise 1
Using IN – NOT IN – Solution 1
Using IN – NOT IN – Exercise 2
Using IN – NOT IN – Solution 2
SQL – Expanding on MySQL Aggregate Functions
15 Topics
Expand
Lesson Content
0% Complete
0/15 Steps
Applying COUNT()
Applying COUNT() – Exercise
Applying COUNT() – Solution
Applying SUM()
Applying SUM() – Exercise
Applying SUM() – Solution
MIN() and MAX()
MIN() and MAX() – Exercise
MIN() and MAX() – Solution
Applying AVG()
Applying AVG() – Exercise
Applying AVG() – Solution
Rounding Numbers with ROUND()
Rounding Numbers with ROUND() – Exercise
Rounding Numbers with ROUND() – Solution
SQL – SQL JOINs
36 Topics
Expand
Lesson Content
0% Complete
0/36 Steps
What are JOINs?
What are JOINs? – Exercise 1
What are JOINs? – Exercise 2
The Functionality of INNER JOIN – Part I
The Functionality of INNER JOIN – Part II
The Functionality of INNER JOIN – PART II – Exercise
The Functionality of INNER JOIN – PART II – Solution
Extra Info on Using Joins
Duplicate Rows
The Functionality of LEFT JOIN – Part I
The Functionality of LEFT JOIN – Part II
The Functionality of LEFT JOIN – Part II – Exercise
The Functionality of LEFT JOIN – Part II – Solution
The Functionality of RIGHT JOIN
Differences between the New and the Old Join Syntax
Differences between the New and the Old Join Syntax – Exercise
Differences between the New and the Old Join Syntax – Solution
Using JOIN and WHERE Together
Important – Prevent Error Code: 1055!
Using JOIN and WHERE Together – Exercise
SQL – SQL Subqueries
10 Topics
Expand
Lesson Content
0% Complete
0/10 Steps
SQL Subqueries with IN Embedded Inside WHERE
SQL Subqueries with IN Embedded Inside WHERE – Exercise
SQL Subqueries with IN Embedded Inside WHERE – Solution
SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE
SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE – Exercise
SQL Subqueries with EXISTS-NOT EXISTS Embedded Inside WHERE – Solution
SQL Subqueries Nested in SELECT and FROM
SQL Subqueries Embedded in SELECT and FROM – Exercise 1
SQL Subqueries Embedded in SELECT and FROM – Exercise 2
SQL Subqueries Nested in SELECT and FROM – Solution 2
SQL – Stored Routines
19 Topics
Expand
Lesson Content
0% Complete
0/19 Steps
Defining Stored Routines
Create Stored Procedures with MySQL Syntax
An Example of Stored Procedures Part I
An Example of Stored Procedures Part II
An Example of Stored Procedures Part II – Exercise
An Example of Stored Procedures Part II – Solution
Creating a Procedure in MySQL Another Way
Create Stored Procedures with an Input Parameter
Create Stored Procedures with an Output Parameter
Create Stored Procedures with an Output Parameter – Exercise
Stored Procedures with an Output Parameter – Solution
SQL Variables
SQL Variables – Exercise
SQL Variables – Solution
The Benefit of User-Defined Functions in MySQL
Error Code: 1418.
The Benefit of User-Defined Functions in MySQL – Exercise
The Benefit of User-Defined Functions in MySQL – Solution
Concluding Stored Routines
SQL – The CASE Statement
7 Topics
Expand
Lesson Content
0% Complete
0/7 Steps
The SQL CASE Statement
The SQL CASE Statement – Exercise 1
THE SQL CASE Statement – Solution 1
THE SQL CASE Statement – Exercise 2
THE SQL CASE Statement – Solution 2
THE SQL CASE Statement – Exercise 3
THE SQL CASE Statement – Solution 3
Introduction to Tableau
5 Topics
Expand
Lesson Content
0% Complete
0/5 Steps
Why Use Tableau : Make your Data Make an Impact
Let’s Download Tableau Public
Connecting Data in Tableau
Exploring Tableau’s Interface
Let’s Create our first Chart in Tableau!
Tableau – Tableau functionalities
8 Topics
Expand
Lesson Content
0% Complete
0/8 Steps
Duplicating a Sheet
Creating a Table
Creating Custom Fields
Creating a Custom Field and Adding Calculations to a Table
Adding Totals and Subtotals
Adding a Custom Calculation
Inserting a Filter
Working with Joins in Tableau
Tableau – The Tableau Exercise
12 Topics
Expand
Lesson Content
0% Complete
0/12 Steps
Introduction to the Exercise
Let’s Create a Dashboard – Visualizing the Three Charts We Want to Create
Using Joins in Tableau
Performing a Numbers Check – Attempt #1
Blending Data in Tableau
Performing a Numbers Check – Attempt #2
First Chart
Second Chart
Third Chart
Creating and Formatting a Dashboard
Adding Interactive Filters for Improved Analysis
Interactive Filters – fix
Combining SQL and Tableau – Introduction
3 Topics
Expand
Lesson Content
0% Complete
0/3 Steps
Introduction to Software Integration
Combining SQL and Tableau
Loading the Database
Combining SQL and Tableau – Problem 1
8 Topics
Expand
Lesson Content
0% Complete
0/8 Steps
Problem 1: Task
Problem 1: Task – Text
Important clarification!
Problem 1: Solution in SQL
Problem 1: Solution in SQL – Code
Exporting Your Output from SQL and Loading it in Tableau
Chart 1: Visualizing the Solution in Tableau – Part I
Chart 1: Visualizing the Solution in Tableau – Part II
Combining SQL and Tableau – Problem 2
5 Topics
Expand
Lesson Content
0% Complete
0/5 Steps
Problem 2: Task
Problem 2: Task – Text
Problem 2: Solution in SQL
Problem 2: Solution in SQL – Code
Chart 2: Visualizing the Solution in Tableau
Combining SQL and Tableau – Problem 3
5 Topics
Expand
Lesson Content
0% Complete
0/5 Steps
Problem 3: Task
Problem 3: Task – Text
Problem 3: Solution in SQL
Problem 3: Solution in SQL – Code
Chart 3: Visualizing the Solution in Tableau
Combining SQL and Tableau – Problem 4
5 Topics
Expand
Lesson Content
0% Complete
0/5 Steps
Problem 4: Task
Problem 4: Task – Text
Problem 4: Solution in SQL
Problem 4: Solution in SQL – Code
Chart 4: Visualizing the Solution in Tableau
Combining SQL and Tableau – Problem 5
1 Topic
Expand
Lesson Content
0% Complete
0/1 Steps
Problem 5: Organizing Charts 1-4 into a Beautiful Dashboard
1 of 2
Close
Search
Hit enter to search or ESC to close
Search for:
Your shopping cart
Cart