Log in
Log inBook a demo

SQL for Business Intelligence (MySQL)

COURSE
365 Careers
10 hrs

SQL for Business Intelligence (MySQL)

COURSE
365 Careers
10 hrs
Included in GO1 PremiumStarting from $12 per user for teamsLearn moreTry for free
Included in GO1 PremiumStarting from $12 per user for teamsLearn moreTry for free

 Course Overview

When you can work with SQL, it means you don’t have to rely on others sending you data and executing queries for you. You can do that on your own. This allows you to be independent and dig deeper into the data to obtain the answers to questions that might improve the way your company does its business. For instance, Database management is the foundation for data analysis and intelligent decision making. 

Target Audience

  • People interested in SQL developer
  • Database administrator, Business Analyst
  • Business Intelligence job opportunities
  • Beginners to programming
  • Everyone who wants to learn how to code and apply their skills in practice

Learning Objectives

  • Become an expert in SQL
  • Learn how to code in SQL
  • Boost your resume by learning an in-demand skill
  • Create, design, and operate with SQL databases
  • Start using MySQL – the #1 Database Management System
  • Prepare for SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
  • Adopt professionally tested SQL best practices
  • Gain theoretical insights about relational databases
  • Work with a sophisticated real-life database throughout the course
  • Get maximum preparation for real-life database management
  • Add data analytical tools to your skillset
  • Develop business intuition while solving tasks with big data
  • Study relational database management theory that you will need in your workplace every day
  • Learn how to create a database from scratch
  • The ability to take control of your dataset – insert, update, and delete records from your database
  • Be confident while working with constraints and relating data tables
  • Become a proficient MySQL Workbench user
  • Acquire top-notch coding techniques and best practices
  • Know how to answer specific business questions by using SQL’s aggregate functions
  • Handle complex SQL joins with ease
  • Approach more advanced topics in programming like SQL’s triggers, sequences, local and global variables, indexes, and more
  • Merge coding skills and business acumen to solve complex analytical problems
  • Become a proficient SQL user by writing flawless and efficient queries
  • Tons of exercises that will solidify your knowledge

Business Outcomes

Employees able to work with SQL in a proficient way.

Learning
Module 1
Objectives of the Course - SQL for Business Intelligence (MySQL)video • 4 mins
Why SQL - SQL for Business Intelligence (MySQL)video • 3 mins
Why MySQL - SQL for Business Intelligence (MySQL)video • 2 mins
Introduction to Databases - SQL for Business Intelligence (MySQL)video • 5 mins
Module 2
SQL as a declarative language - SQL for Business Intelligence (MySQL)video • 2 mins
DDL - SQL for Business Intelligence (MySQL)video • 4 mins
Keywords - SQL for Business Intelligence (MySQL)video • 1 min
DML - SQL for Business Intelligence (MySQL)video • 5 mins
DCL - SQL for Business Intelligence (MySQL)video • 5 mins
TCL - SQL for Business Intelligence (MySQL)video • 3 mins
Module 3
Relational Database Essentials - SQL for Business Intelligence (MySQL)video • 5 mins
Databases vs. Spreadsheets - SQL for Business Intelligence (MySQL)video • 8 mins
Database Terminology - SQL for Business Intelligence (MySQL)video • 4 mins
Rel Schemas - Primary Key - SQL for Business Intelligence (MySQL)video • 5 mins
Rel Schemas Foreign Key - SQL for Business Intelligence (MySQL)video • 5 mins
Rel Schemas Unique Keys Null Values - SQL for Business Intelligence (MySQL)video • 3 mins
Relationships - SQL for Business Intelligence (MySQL)video • 5 mins
Module 4
Installing MySQL - SQL for Business Intelligence (MySQL)video • 11 mins
Setting Up a Connection - SQL for Business Intelligence (MySQL)video • 3 mins
Create New User - SQL for Business Intelligence (MySQL)video • 6 mins
Introduction to the MySQL Interface - SQL for Business Intelligence (MySQL)video • 5 mins
Module 5
Creating a Database - Part I - SQL for Business Intelligence (MySQL)video • 5 mins
Creating a Database - Part II - SQL for Business Intelligence (MySQL)video • 2 mins
Introduction to Data Types - SQL for Business Intelligence (MySQL)video • 2 mins
String Data Types - SQL for Business Intelligence (MySQL)video • 5 mins
Integers - SQL for Business Intelligence (MySQL)video • 4 mins
Fixed Floating Data Types - SQL for Business Intelligence (MySQL)video • 6 mins
Other Useful Data Types - SQL for Business Intelligence (MySQL)video • 6 mins
Creating a Table - SQL for Business Intelligence (MySQL)video • 5 mins
Using Databases and Tables - SQL for Business Intelligence (MySQL)video • 3 mins
Additional Notes on Using Tables - SQL for Business Intelligence (MySQL)video • 2 mins
Module 6
PRIMARY KEY Constraint - SQL for Business Intelligence (MySQL)video • 5 mins
FOREIGN KEY Constraint - Part I - SQL for Business Intelligence (MySQL)video • 5 mins
FOREIGN KEY Constraint - Part II - SQL for Business Intelligence (MySQL)video • 5 mins
UNIQUE Constraint - SQL for Business Intelligence (MySQL)video • 5 mins
DEFAULT Constraint - SQL for Business Intelligence (MySQL)video • 5 mins
NOT NULL Constraint - Part I - SQL for Business Intelligence (MySQL)video • 6 mins
NOT NULL Constraint - Part II - SQL for Business Intelligence (MySQL)video • 2 mins
Module 7
Coding Techniques and Best Practices - Part I - SQL for Business Intelligence (MySQL)video • 6 mins
Coding Techniques and Best Practices - Part II - SQL for Business Intelligence (MySQL)video • 4 mins
Module 8
Loading the 'employees' Database - SQL for Business Intelligence (MySQL)video • 2 mins
SELECT FROM - SQL for Business Intelligence (MySQL)video • 5 mins
WHERE - SQL for Business Intelligence (MySQL)video • 3 mins
AND - SQL for Business Intelligence (MySQL)video • 2 mins
OR - SQL for Business Intelligence (MySQL)video • 4 mins
Operator Precedence - SQL for Business Intelligence (MySQL)video • 4 mins
IN - NOT IN - SQL for Business Intelligence (MySQL)video • 3 mins
LIKE - NOT LIKE - SQL for Business Intelligence (MySQL)video • 4 mins
Wildcard Characters - SQL for Business Intelligence (MySQL)video • 2 mins
BETWEEN AND - SQL for Business Intelligence (MySQL)video • 2 mins
IS NOT NULL - IS NULL - SQL for Business Intelligence (MySQL)video • 2 mins
Other Comparison Operators - SQL for Business Intelligence (MySQL)video • 5 mins
SELECT DISTINCT - SQL for Business Intelligence (MySQL)video • 2 mins
Introduction to Aggregate Functions - SQL for Business Intelligence (MySQL)video • 5 mins
ORDER BY - SQL for Business Intelligence (MySQL)video • 4 mins
GROUP BY - SQL for Business Intelligence (MySQL)video • 6 mins
Using Aliases (AS) - SQL for Business Intelligence (MySQL)video • 2 mins
HAVING - SQL for Business Intelligence (MySQL)video • 4 mins
WHERE vs HAVING - Part I - SQL for Business Intelligence (MySQL)video • 4 mins
WHERE vs HAVING - Part II - SQL for Business Intelligence (MySQL)video • 3 mins
LIMIT - SQL for Business Intelligence (MySQL)video • 5 mins
Module 9
The INSERT Statement - Part I - SQL for Business Intelligence (MySQL)video • 6 mins
The INSERT Statement - Part II - SQL for Business Intelligence (MySQL)video • 2 mins
Inserting Data INTO a New Table - SQL for Business Intelligence (MySQL)video • 4 mins
Module 10
TCL's COMMIT and ROLLBACK - SQL for Business Intelligence (MySQL)video • 3 mins
The UPDATE Statement - Part I - SQL for Business Intelligence (MySQL)video • 3 mins
The UPDATE Statement - Part II - SQL for Business Intelligence (MySQL)video • 3 mins
Module 11
The DELETE Statement - Part I - SQL for Business Intelligence (MySQL)video • 4 mins
The DELETE Statement - Part II - SQL for Business Intelligence (MySQL)video • 1 min
DROP vs TRUNCATE vs DELETE - SQL for Business Intelligence (MySQL)video • 3 mins
Module 12
COUNT() - SQL for Business Intelligence (MySQL)video • 4 mins
SUM() - SQL for Business Intelligence (MySQL)video • 2 mins
MIN() and MAX() - SQL for Business Intelligence (MySQL)video • 1 min
AVG() - SQL for Business Intelligence (MySQL)video • 2 mins
ROUND() - SQL for Business Intelligence (MySQL)video • 2 mins
IFNULL() and COALESCE() - SQL for Business Intelligence (MySQL)video • 6 mins
Another Example of Using COALESCE() - SQL for Business Intelligence (MySQL)video • 2 mins
Module 13
Introduction to Joins - SQL for Business Intelligence (MySQL)video • 4 mins
INNER JOINs - Part I - SQL for Business Intelligence (MySQL)video • 6 mins
INNER JOIN - Part II - SQL for Business Intelligence (MySQL)video • 6 mins
A Note on Using Joins - SQL for Business Intelligence (MySQL)video • 4 mins
Duplicate Records - SQL for Business Intelligence (MySQL)video • 4 mins
LEFT JOIN - Part I - SQL for Business Intelligence (MySQL)video • 5 mins
LEFT JOIN - Part II - SQL for Business Intelligence (MySQL)video • 6 mins
RIGHT JOIN - SQL for Business Intelligence (MySQL)video • 5 mins
The New and the Old Join Syntax - SQL for Business Intelligence (MySQL)video • 4 mins
JOIN and WHERE Used Together - SQL for Business Intelligence (MySQL)video • 3 mins
SQL - CROSS JOIN - SQL for Business Intelligence (MySQL)video • 8 mins
Using Aggr Fcts and Joins - SQL for Business Intelligence (MySQL)video • 2 mins
JOIN More Than Two Tables in SQL - SQL for Business Intelligence (MySQL)video • 4 mins
Tips and Tricks for Joins - SQL for Business Intelligence (MySQL)video • 6 mins
UNION vs UNION ALL - SQL for Business Intelligence (MySQL)video • 6 mins
Subqueries - IN - WHERE - SQL for Business Intelligence (MySQL)video • 5 mins
Subqueries - EXISTS - WHERE - SQL for Business Intelligence (MySQL)video • 4 mins
Subqueries SELECT FROM - SQL for Business Intelligence (MySQL)video • 8 mins
SQL Self Join - SQL for Business Intelligence (MySQL)video • 8 mins
Using SQL Views - SQL for Business Intelligence (MySQL)video • 7 mins
Module 14
Introduction to Stored Routines - SQL for Business Intelligence (MySQL)video • 3 mins
Syntax St Procedures - SQL for Business Intelligence (MySQL)video • 5 mins
St Procedures - Example - Part I - SQL for Business Intelligence (MySQL)video • 3 mins
St Procedures - Example - Part II - SQL for Business Intelligence (MySQL)video • 5 mins
Another Way to Create a Procedure - SQL for Business Intelligence (MySQL)video • 3 mins
St Procedures with an Input Parameter - SQL for Business Intelligence (MySQL)video • 6 mins
St Procedures with an Output Parameter - SQL for Business Intelligence (MySQL)video • 3 mins
Variables - SQL for Business Intelligence (MySQL)video • 7 mins
User-Defined Functions in MySQL - SQL for Business Intelligence (MySQL)video • 5 mins
Stored Routines - Conclusion - SQL for Business Intelligence (MySQL)video • 4 mins
Module 15
MySQL Variables - Local Variables - SQL for Business Intelligence (MySQL)video • 5 mins
Session Variables - SQL for Business Intelligence (MySQL)video • 5 mins
Global Variables - SQL for Business Intelligence (MySQL)video • 2 mins
User-Defined vs System Variables - SQL for Business Intelligence (MySQL)video • 4 mins
MySQL Indexes - SQL for Business Intelligence (MySQL)video • 7 mins
SQL - The CASE Statement - SQL for Business Intelligence (MySQL)video • 6 mins
Module 16
Introduction to software integration - SQL for Business Intelligence (MySQL)video • 5 mins
Combining SQL and Tableau - SQL for Business Intelligence (MySQL)video • 5 mins
Installing Tableau Public - SQL for Business Intelligence (MySQL)video • 2 mins
SQL Load employees mod - SQL for Business Intelligence (MySQL)video • 3 mins
Module 17
SQL-Tableau Task 1 - SQL for Business Intelligence (MySQL)video • 6 mins
SQL-Tableau Task 1 SQL Solution - SQL for Business Intelligence (MySQL)video • 5 mins
SQL-Tableau Transferring a Dataset from SQL to Tableau - SQL for Business Intelligence (MySQL)video • 4 mins
SQL-Tableau Chart 1 Part I - SQL for Business Intelligence (MySQL)video • 6 mins
SQL-Tableau Chart 1 Part II - SQL for Business Intelligence (MySQL)video • 5 mins
Module 18
SQL-Tableau Task 2 - SQL for Business Intelligence (MySQL)video • 4 mins
SQL-Tableau Task 2 SQL Solution - SQL for Business Intelligence (MySQL)video • 4 mins
SQL-Tableau Chart 2 - SQL for Business Intelligence (MySQL)video • 6 mins
Module 19
SQL-Tableau Task 3 - SQL for Business Intelligence (MySQL)video • 2 mins
SQL-Tableau Task 3 SQL Solution - SQL for Business Intelligence (MySQL)video • 3 mins
SQL-Tableau Chart 3 - SQL for Business Intelligence (MySQL)video • 5 mins
Module 20
SQL-Tableau Task 4 - SQL for Business Intelligence (MySQL)video • 3 mins
SQL-Tableau Task 4 SQL Solution - SQL for Business Intelligence (MySQL)video • 3 mins
SQL-Tableau Chart 4 - SQL for Business Intelligence (MySQL)video • 3 mins
Module 21
SQL-Tableau Organizing a Dashboard - SQL for Business Intelligence (MySQL)video • 6 mins
Additional Resources
Downloadable filestext