Home

All courses

SQL - MySQL for Data Analytics and Business Intelligence

Business

Business Analytics & Intelligence

SQL

SQL - MySQL for Data Analytics and Business Intelligence

SQL that will get you hired – SQL for Data Science, Data Engineering, Business Analysis, Marketing, and Data Management

4.6

(63800)

267556 enrolled on this course

Last updated 11/2021

365 Careers

₹ 3999.0

₹ 5499.0

Buy Now

30-Day Money-Back Guarantee

Lessons

Quizzes

Duration

13 Hours

Skill level

Beginner

Language

English

Certificate

Yes

Full lifetime access

Yes

Description

How important is database management in the age of big data and analytics?
It is really important.
How many employers would be happy to hire employees who can use data for the purposes of business intelligence?
All of them.
How many people have these skills?
Not enough.
This is why now is the time to learn SQL and gain a competitive advantage in the job market. Remember, the average salary of a SQL developer is $123,400! That’s a lucrative career.
How come?
Well, 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.
Worried that you have no previous experience?

Not an issue. We will start from the very basics and gradually teach you everything you need to know. Step by step. With no steps skipped.
Why take this course in particular? Isn’t it like the rest of the SQL courses out there?

We would like to think it isn’t. Our team worked hard to create a course that is:

Easy to understand

Time efficient and concise

Shows how SQL can be crucial for data analytics and business intelligence
Comprehensive – it covers several topics not shown in other SQL courses
Practical – it teaches you how to work with a real-life database
Corresponds to professional best practices

Taught in MySQL – The most popular SQL database management system

Contains plenty of downloadable exercises, course notes, and quiz questions
Some of these aspects have been covered in other courses. Others haven’t. However, no one provides such a variety of topics in one place.
We firmly believe this course is the best training material out there. It is a truly interactive experience preparing you for a real-life working environment.
We love teaching

So far, over 3,000,000 students have taken our courses here on Udemy. Teaching is what we do best, and we take pride in going the extra mile to create the most engaging content for you, our students. Our mission is to help you bridge the gap between theoretical knowledge taught at school and in universities and the practical application required at the workplace.
So, why do you need to enroll in this course and learn SQL?

Salary/Income.
As we pointed out earlier, learning SQL is a great opportunity. There is a significant surge in demand for skills revolving around database management, database administration, and business analysis relying on data. Companies will pay top dollars for specialists who have such know-how

Profession of the future.
In the years to come, data will only grow in importance and size. Therefore, it is great to pick up a skill that will likely increase in demand over the years to come

Analytical reasoning.
Programming languages are a great way to train your mind. Furthermore, understanding a business task and looking for its solution through writing code can be really interesting and stimulating once you become familiar with the basics
What about certificates? Do you provide a certificate?
Upon completion of the course, you will be able to download a certificate of completion with your name on it. Then, you can upload this certificate on LinkedIn and show potential employers this is a skill you possess.
Sounds awesome, right?
So, what are you waiting for? Click the “Buy now” button, and let’s begin this journey together!

Who this course is for:
People interested in SQL developer, Database administrator, Business Analyst, and Business Intelligence job opportunities
Beginners to programming
Everyone who wants to learn how to code and apply their skills in practice

What you'll learn

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

The freedom to query anything you like from a database

Requirements

You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
No previous design experience is needed.
No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures

Expand All Sections

1-Introduction to databases, SQL, and MySQL

1.1-What does the course cover?

1.2-Why SQL?

1.3-Why SQL?

1.4-Why MySQL?

1.5-Why MySQL?

1.6-Introduction to databases

1.7-Introduction to databases

2-SQL theory

2.1-SQL as a declarative language

2.2-SQL as a declarative language

2.3-Data definition language (DDL)

2.4-Data definition language (DDL)

2.5-SQL keywords

2.6-SQL keywords

2.7-Data manipulation language (DML)

2.8-Data manipulation language (DML)

2.9-Data control language (DCL)

2.10-Data control language (DCL)

2.11-Transaction control language (TCL)

2.12-Transaction control language (TCL)

3-Basic database terminology

3.1-Relational database essentials

3.2-Relational database essentials

3.3-Databases vs spreadsheets

3.4-Databases vs spreadsheets

3.5-Database terminology

3.6-Database terminology

3.7-Relational schemas - Primary key

3.8-Relational schemas - Primary key

3.9-Relational schemas - Foreign key

3.10-Relational schemas - Foreign key

3.11-Relational schemas - Unique key and null values

3.12-Relational Schemas - Unique key

3.13-Relationships

3.14-Relational Schemas – Relationships

4-Installing MySQL and getting acquainted with the interface

4.1-Installing MySQL

4.2-Additional note – Installing – Visual C

4.3-Installing MySQL on macOS and Unix systems

4.4-The Client-Server Model

4.5-Setting up a connection

4.6-Read me!!!

4.7-New Authentication Plugin - Creating a New User

4.8-Introduction to the MySQL interface

5-First steps in SQL

5.1-Creating a Database - Part I

5.2-SQL files

5.3-Creating a Database - Part I - exercise

5.4-Creating a Database - Part I - solution

5.5-Creating a Database - Part II

5.6-Creating a Database - Part II - exercise

5.7-Creating a Database - Part II - solution

5.8-Introduction to data types

5.9-Introduction to data types

5.10-String data types

5.11-String data types

5.12-Integers

5.13-Integers

5.14-Fixed and floating-point data types

5.15-Fixed and floating-point data types

5.16-Other useful data types

5.17-Other useful data types

5.18-Creating a table

5.19-Creating a table - exercise

5.20-Creating a table - solution

5.21-CODING EXERCISES - Browser-based coding

5.22-Creating a Table - Exercise #1

5.23-Creating a Table - Exercise #2

5.24-Creating a Table - Exercise #3

5.25-Creating a Table - Exercise #4

5.26-Using databases and tables

5.27-Using databases and tables - exercise

5.28-Using databases and tables - solution

5.29-Using Databases and Tables - Exercise #1

5.30-Additional notes on using tables

5.31-Additional notes on using tables

5.32-Additional notes on using tables - exercise

5.33-Additional Notes on Using Tables - Exercise #9

6-MySQL constraints

6.1-PRIMARY KEY constraint

6.2-PRIMARY KEY Constraint

6.3-PRIMARY KEY constraint - exercise

6.4-PRIMARY KEY constraint - solution

6.5-PRIMARY KEY constraint - Exercise #1

6.6-PRIMARY KEY constraint - Exercise #2

6.7-FOREIGN KEY constraint - Part I

6.8-FOREIGN KEY constraint - Part II

6.9-FOREIGN KEY constraint - Part II - exercise

6.10-FOREIGN KEY constraint - Part II - solution

6.11-FOREIGN KEY constraint - Exercise #1

6.12-FOREIGN KEY constraint - Exercise #2

6.13-FOREIGN KEY constraint - Exercise #3

6.14-UNIQUE Constraint

6.15-UNIQUE Constraint - exercise

6.16-UNIQUE constraint - Exercise #1

6.17-DEFAULT Constraint

6.18-DEFAULT Constraint - exercise

6.19-DEFAULT Constraint - solution

6.20-DEFAULT constraint - Exercise #1

6.21-NOT NULL Constraint - Part I

6.22-NOT NULL Constraint - Part I - exercise

6.23-NOT NULL Constraint - Part I - solution

6.24-NOT NULL constraint - Exercise #1

6.25-NOT NULL Constraint - Part II

7-SQL best practices

7.1-Coding techniques and best practices - Part I

7.2-Coding techniques and best practices – Part I

7.3-Coding techniques and best practices - Part II

7.4-Coding techniques and best practices – Part II

8-Loading the 'employees' database

8.1-Loading the 'employees' database

8.2-Loading the 'employees' database

9-SQL SELECT statement

9.1-SELECT - FROM

9.2-SELECT - FROM - exercise

9.3-SELECT - FROM - solution

9.4-CODING EXERCISES - the 'employees_10' Database

9.5-SELECT - FROM - Exercise #1

9.6-SELECT - FROM - Exercise #2

9.7-SELECT - FROM - Exercise #3

9.8-SELECT - FROM - Exercise #4

9.9-WHERE

9.10-WHERE - exercise

9.11-WHERE - solution

9.12-SELECT - WHERE - Exercise #1

9.13-AND

9.14-AND - exercise

9.15-AND - solution

9.16-SELECT - AND - Exercise #1

9.17-OR

9.18-OR - exercise

9.19-OR - solution

9.20-SELECT - OR - Exercise #1

9.21-Operator precedence

9.22-Operator precedence - exercise

9.23-Operator precedence - solution

9.24-SELECT - Operator Precedence - Exercise #1

9.25-IN - NOT IN

9.26-IN - NOT IN - exercise 1

9.27-IN - NOT IN - solution 1

9.28-IN - NOT IN - exercise 2

9.29-IN - NOT IN - solution 2

9.30-SELECT - IN - NOT IN - Exercise #1

9.31-SELECT - IN - NOT IN - Exercise #2

9.32-LIKE - NOT LIKE

9.33-LIKE - NOT LIKE - exercise

9.34-LIKE - NOT LIKE - solution

9.35-SELECT - LIKE - NOT LIKE - Exercise #1

9.36-SELECT - LIKE - NOT LIKE - Exercise #2

9.37-SELECT - LIKE - NOT LIKE - Exercise #3

9.38-Wildcard characters

9.39-Wildcard characters - exercise

9.40-Wildcard characters - solution

9.41-Wildcard characters - Exercise #1

9.42-Wildcard characters - Exercise #2

9.43-BETWEEN - AND

9.44-BETWEEN - AND - exercise

9.45-BETWEEN - AND- solution

9.46-SELECT - BETWEEN - AND - Exercise #1

9.47-SELECT - BETWEEN - AND - Exercise #2

9.48-SELECT - BETWEEN - AND - Exercise #3

9.49-IS NOT NULL - IS NULL

9.50-IS NOT NULL - IS NULL - exercise

9.51-IS NOT NULL - IS NULL - solution

9.52-SELECT - IS NOT NULL - IS NULL - Exercise #1

9.53-Other comparison operators

9.54-Other comparison operators - exercise

9.55-Other comparison operators - solution

9.56-SELECT - Other comparison operators - Exercise #1

9.57-SELECT - Other comparison operators - Exercise #2

9.58-SELECT DISTINCT

9.59-SELECT DISTINCT - exercise

9.60-SELECT DISTINCT - solution

9.61-SELECT DISTINCT - Exercise #1

9.62-Introduction to aggregate functions

9.63-Introduction to aggregate functions - exercise

9.64-Introduction to aggregate functions - solution

9.65-Introduction to aggregate functions - Exercise #1

9.66-Introduction to aggregate functions - Exercise #2

9.67-ORDER BY

9.68-ORDER BY - exercise

9.69-ORDER BY - solution

9.70-SELECT - ORDER BY - Exercise #1

9.71-GROUP BY

9.72-Using Aliases (AS)

9.73-Using Aliases (AS) - exercise

9.74-Using Aliases (AS) - solution

9.75-SELECT - Using Aliases (AS) - Exercise #1

9.76-HAVING

9.77-HAVING - exercise

9.78-HAVING - solution

9.79-SELECT - HAVING - Exercise #1

9.80-WHERE vs HAVING- Part I

9.81-WHERE vs HAVING- Part II

9.82-WHERE vs HAVING - Part II - exercise

9.83-WHERE vs HAVING - Part II - solution

9.84-SELECT - WHERE vs HAVING - Exercise #1

9.85-LIMIT

9.86-LIMIT - exercise

9.87-LIMIT - solution

9.88-SELECT - LIMIT - Exercise #1

10-SQL INSERT statement

10.1-The INSERT statement - Part I

10.2-The INSERT statement - Part II

10.3-The INSERT statement - Exercise #1

10.4-The INSERT statement - Exercise #2

10.5-The INSERT statement - Exercise #3

10.6-The INSERT statement - Exercise #4

10.7-The INSERT statement - Exercise #5

10.8-The INSERT statement - exercise 1

10.9-The INSERT statement - solution 1

10.10-The INSERT statement - Exercise #6

10.11-The INSERT statement - exercise 2

10.12-The INSERT statement - solution 2

10.13-The INSERT statement - Exercise #7

10.14-Inserting data INTO a new table

10.15-Inserting Data INTO a New Table - exercise

10.16-Inserting Data INTO a New Table - solution

10.17-The INSERT statement - Exercise #8

11-SQL UPDATE Statement

11.1-TCL's COMMIT and ROLLBACK

11.2-The UPDATE Statement - Part I

11.3-ROLLBACK

ARTICLE

11.4-The UPDATE Statement - Part II

11.5-The UPDATE Statement – Part II - exercise

11.6-The UPDATE Statement – Part II - solution

11.7-The UPDATE statement - Exercise #1

11.8-The UPDATE statement - Exercise #2

12-SQL DELETE Statement

12.1-The DELETE Statement - Part I

12.2-The DELETE Statement - Part II

12.3-The DELETE Statement – Part II - exercise

12.4-The DELETE Statement – Part II - solution

12.5-The DELETE statement - Exercise #1

12.6-The DELETE statement - Exercise #2

12.7-DROP vs TRUNCATE vs DELETE

12.8-DROP vs TRUNCATE vs DELETE

13-MySQL - Aggregate functions

13.1-COUNT()

13.2-COUNT() - exercise

13.3-COUNT() - solution

13.4-COUNT() - Exercise #1

13.5-SUM()

13.6-SUM() - exercise

13.7-SUM() - solution

13.8-SUM() - Exercise #1

13.9-MIN() and MAX()

13.10-MIN() and MAX() - exercise

13.11-MIN() and MAX() - solution

13.12-MIN() and MAX() - Exercise #1

13.13-MIN() and MAX() - Exercise #2

13.14-AVG()

13.15-AVG() - exercise

13.16-AVG() - solution

13.17-AVG() - Exercise #1

13.18-ROUND()

13.19-ROUND() - exercise

13.20-ROUND() - solution

13.21-ROUND() - Exercise #1

13.22-COALESCE() - Preamble

13.23-IFNULL() and COALESCE()

13.24-Another Example of Using COALESCE()

13.25-Another example of using COALESCE() - exercise 1

13.26-Another example of using COALESCE() - solution 1

13.27-COALESCE() - Exercise #1

13.28-Another example of using COALESCE() - exercise 2

13.29-Another example of using COALESCE() - solution 2

13.30-COALESCE() - Exercise #2

13.31-Another example of using COALESCE()

14-SQL Joins

14.1-Introduction to JOINs

14.2-Intro to JOINs - exercise 1

14.3-Intro to JOINs - solution 1

14.4-Intro to JOINs - exercise 2

14.5-INNER JOIN - Part I

14.6-INNER JOIN - Part II

14.7-INNER JOIN - Part II - exercise

14.8-INNER JOIN - Part II - solution

14.9-INNER JOIN - Exercise #1

14.10-A Note on Using Joins

14.11-Duplicate Records

14.12-LEFT JOIN - Part I

14.13-LEFT JOIN - Part II

14.14-LEFT JOIN - Part II - exercise

14.15-LEFT JOIN - Part II - solution

14.16-LEFT JOIN - Exercise #1

14.17-RIGHT JOIN

14.18-RIGHT JOIN - Exercise #1

14.19-The new and the old join syntax

14.20-The new and the old join syntax - exercise

14.21-The new and the old join syntax - solution

14.22-The new and the old join syntax - Exercise #1

14.23-JOIN and WHERE Used Together

14.24-Important – Prevent Error Code: 1055!

14.25-JOIN and WHERE Used Together - exercise

14.26-JOIN and WHERE Used Together - solution

14.27-JOIN and WHERE Used Together - Exercise #1

14.28-CROSS JOIN

14.29-CROSS JOIN - exercise 1

14.30-CROSS JOIN - solution 1

14.31-CROSS JOIN - exercise 2

14.32-CROSS JOIN - solution 2

14.33-CROSS JOIN - Exercise #1

14.34-CROSS JOIN - Exercise #2

14.35-Using Aggregate Functions with Joins

14.36-JOIN more than two tables in SQL

14.37-Join more than two tables in SQL - exercise

14.38-Join more than two tables in SQL - solution

14.39-JOIN More than Two Tables in SQL - Exercise #1

14.40-Tips and tricks for joins

14.41-Tips and tricks for joins - exercise

14.42-Tips and tricks for joins - solution

14.43-Tips and tricks for joins - Exercise #1

14.44-UNION vs UNION ALL

14.45-UNION vs UNION ALL - exercise

14.46-UNION vs UNION ALL - solution

14.47-UNION vs UNION ALL - Exercise #1

15-SQL Subqueries

15.1-SQL Subqueries with IN nested inside WHERE

15.2-SQL Subqueries with IN nested inside WHERE - exercise

15.3-SQL Subqueries with IN nested inside WHERE - solution

15.4-SQL Subqueries with IN nested inside WHERE - Exercise #1

15.5-SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE

15.6-SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - exercise

15.7-SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution

15.8-SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - Exercise #1

15.9-SQL Subqueries nested in SELECT and FROM

15.10-SQL Subqueries nested in SELECT and FROM - exercise 1

15.11-SQL Subqueries nested in SELECT and FROM - solution 1

15.12-SQL Subqueries nested in SELECT and FROM - exercise 2

15.13-SQL Subqueries nested in SELECT and FROM - solution 2

15.14-SQL Subqueries nested in SELECT and FROM - Exercise #1

16-SQL Self Join

16.1-Self Join

16.2-Self Join

16.3-Self Join - Exercise #1

16.4-Self Join - Exercise #2

16.5-Self Join - Exercise #3

17-SQL Views

17.1-Views

17.2-Views - exercise

17.3-Views - solution

17.4-Views - Exercise #1

18-Stored routines

18.1-Introduction to stored routines

18.2-Introduction to Stored Routines

18.3-The MySQL syntax for stored procedures

18.4-Stored procedures - Example - Part I

18.5-Stored procedures - Example - Part II

18.6-Stored procedures - Example - Part II - exercise

18.7-Stored procedures - Example - Part II - solution

18.8-Another way to create a procedure

18.9-Stored procedures with an input parameter

18.10-Stored procedures with an output parameter

18.11-Stored procedures with an output parameter - exercise

18.12-Stored procedures with an output parameter - solution

18.13-Variables

18.14-Variables - exercise

18.15-Variables - solution

18.16-User-defined functions in MySQL

18.17-Error Code: 1418.

18.18-User-defined functions in MySQL - exercise

18.19-User-defined functions in MySQL - solution

18.20-Stored routines - conclusion

18.21-Stored routines - conclusion

19-Advanced SQL Topics

19.1-Types of MySQL Variables - Local Variables

19.2-Types of MySQL Variables - Local Variables

19.3-Session Variables

19.4-Session Variables

19.5-Global Variables

19.6-Global Variables

19.7-User-Defined vs System Variables

19.8-User-Defined vs System Variables

19.9-SQL Variables - Exercise #1

19.10-SQL Variables - Exercise #2

19.11-MySQL Triggers

19.12-MySQL Triggers

19.13-MySQL Triggers - exercise

19.14-MySQL Triggers - solution

19.15-MySQL Indexes

19.16-MySQL Indexes - exercise 1

19.17-MySQL Indexes - solution 1

19.18-MySQL Indexes - exercise 2

19.19-MySQL Indexes - solution 2

19.20-MySQL Indexes - Exercise #1

19.21-MySQL Indexes - Exercise #2

19.22-The CASE Statement

19.23-The CASE Statement - exercise 1

19.24-The CASE Statement - solution 1

19.25-The CASE Statement - exercise 2

19.26-The CASE Statement - solution 2

19.27-The CASE Statement - exercise 3

19.28-The CASE Statement - solution 3

19.29-The CASE Statement - Exercise #1

19.30-The CASE Statement - Exercise #2

19.31-The CASE Statement - Exercise #3

20-SQL Window Functions

20.1-Introduction to MySQL Window Functions

20.2-The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax

20.3-The ROW_NUMBER() Ranking Window Function - Exercises

20.4-The ROW_NUMBER() Ranking Window Function - Solution

20.5-The ROW_NUMBER() Ranking Window Function - Exercise #1

20.6-The ROW_NUMBER() Ranking Window Function - Exercise #2

20.7-A Note on Using Several Window Functions in a Query

20.8-A Note on Using Several Window Functions - Exercise

20.9-A Note on Using Several Window Functions - Solution

20.10-A Note on Using Several Window Functions - Exercise #1

20.11-A Note on Using Several Window Functions - Exercise #2

20.12-MySQL Window Functions Syntax

20.13-MySQL Window Functions Syntax - Exercise

20.14-MySQL Window Functions Syntax - Solution

20.15-MySQL Window Functions Syntax - Exercise #1

20.16-The PARTITION BY Clause VS the GROUP BY Clause

20.17-The PARTITION BY Clause VS the GROUP BY Clause - Exercise

20.18-The PARTITION BY Clause VS the GROUP BY Clause - Solution

20.19-The PARTITION BY Clause vs the GROUP BY Clause - Exercise #1

20.20-The PARTITION BY Clause vs the GROUP BY Clause - Exercise #2

20.21-The PARTITION BY Clause vs the GROUP BY Clause - Exercise #3

20.22-The MySQL RANK() and DENSE_RANK() Window Functions

20.23-The MySQL RANK() and DENSE_RANK() Window Functions - Exercise

20.24-The MySQL RANK() and DENSE_RANK() Window Functions - Solution

20.25-The MySQL RANK() and DENSE_RANK() Window Functions - Exercise #1

20.26-The MySQL RANK() and DENSE_RANK() Window Functions - Exercise #2

20.27-The MySQL RANK() and DENSE_RANK() Window Functions - Exercise #3

20.28-Working with MySQL Ranking Window Functions and Joins Together

20.29-Working with MySQL Ranking Window Functions and Joins Together - Exercise

20.30-Working with MySQL Ranking Window Functions and Joins Together - Solution

20.31-MySQL Ranking Window Functions and JOINs - Exercise #1

20.32-MySQL Ranking Window Functions and JOINs - Exercise #2

20.33-The LAG() and LEAD() Value Window Functions

20.34-The LAG() and LEAD() Value Window Functions - Exercise

20.35-The LAG() and LEAD() Value Window Functions - Solution

20.36-The LAG() and LEAD() Value Window Functions - Exercise #1

20.37-The LAG() and LEAD() Value Window Functions - Exercise #2

20.38-MySQL Aggregate Functions in the Context of Window Functions - Part I

20.39-MySQL Aggregate Functions in the Context of Window Functions - Part I-Exercise

20.40-MySQL Aggregate Functions in the Context of Window Functions - Part I-Solution

20.41-MySQL Aggregate Functions in the Context of Window Functions - Part II

20.42-MySQL Aggregate Functions in the Context of Window Functions - Part II-Exercise

20.43-MySQL Aggregate Functions in the Context of Window Functions - Part II-Solution

20.44-MySQL Aggregate Functions in the Context of Window Functions - Exercise #1

20.45-MySQL Aggregate Functions in the Context of Window Functions - Exercise #2

21-SQL Common Table Expressions (CTEs)

21.1-MySQL Common Table Expressions - Introduction

21.2-An Alternative Solution to the Same Task

21.3-An Alternative Solution to the Same Task-Exercise

21.4-An Alternative Solution to the Same Task-Solution

21.5-An Alternative Solution to the Same Task - Exercise #1

21.6-An Alternative Solution to the Same Task - Exercise #2

21.7-Using Multiple Subclauses in a WITH Clause - Part I

21.8-Using Multiple Subclauses in a WITH Clause - Part II

21.9-Using Multiple Subclauses in a WITH Clause-Exercise

21.10-Using Multiple Subclauses in a WITH Clause-Solution

21.11-Referring to Common Table Expressions in a WITH Clause

21.12-Using Multiple Subclauses in a WITH Clause - Exercise #1

21.13-Using Multiple Subclauses in a WITH Clause - Exercise #2

21.14-Using Multiple Subclauses in a WITH Clause - Exercise #3

22-SQL Temporary Tables

22.1-MySQL Temporary Tables - Introduction

22.2-MySQL Temporary Tables in Action

22.3-MySQL Temporary Tables in Action-Exercise

22.4-MySQL Temporary Tables in Action-Solution

22.5-MySQL Temporary Tables - Exercise #1

22.6-MySQL Temporary Tables - Exercise #2

22.7-Other Features of MySQL Temporary Tables

22.8-Other Features of MySQL Temporary Tables-Exercise

22.9-Other Features of MySQL Temporary Tables-Solution

22.10-MySQL Temporary Tables - Other Features - Exercise #1

22.11-MySQL Temporary Tables - Other Features - Exercise #2

22.12-MySQL Temporary Tables - Other Features - Exercise #3

22.13-MySQL Temporary Tables - Other Features - Exercise #4

23-Combining SQL and Tableau - Introduction

23.1-The Advantages of Software Integration

23.2-Why Combining SQL and Tableau is useful

23.3-Installing Tableau Public

23.4-Loading the 'employees_mod' Database

23.5-Loading the 'employees_mod' Database

24-Combining SQL and Tableau - Task 1

24.1-Task 1

24.2-Task 1 - Text

24.3-Important clarification!

24.4-Task 1: SQL Solution

24.5-Task 1: SQL Solution - Code

24.6-Transferring a Dataset from SQL to Tableau

24.7-Chart 1: Visualizing and Analyzing the Solution in Tableau - Part I

24.8-Chart 1: Visualizing and Analyzing the Solution in Tableau - Part II

24.9-MySQL and Tableau - Task/Exercise #1

25-Combining SQL and Tableau - Task 2

25.1-Task 2

25.2-Task 2 - Text

25.3-Task 2: SQL Solution

25.4-Task 2: SQL Solution - Code

25.5-Chart 2: Visualizing and Analyzing the Solution in Tableau

25.6-MySQL and Tableau - Task/Exercise #2

26-Combining SQL and Tableau - Task 3

26.1-Task 3

26.2-Task 3 - Text

26.3-Task 3: SQL Solution

26.4-Task 3: SQL Solution - Code

26.5-Chart 3: Visualizing and Analyzing the Solution in Tableau

26.6-MySQL and Tableau - Task/Exercise #3

27-Combining SQL and Tableau - Task 4

27.1-Task 4

27.2-Task 4 - Text

27.3-Task 4: Solution in SQL

27.4-Task 4: Solution in SQL - Code

27.5-Chart 4: Visualizing and Analyzing the Solution in Tableau

28-Combining SQL and Tableau - Task 5

28.1-Task 5: Organizing Charts 1-4 into a Beautiful Dashboard using Tableau

29-Practice SQL – 10 Final Query Questions

29.1-Practice SQL – 10 Final Query Questions

29.2-Practice - Exercise #1

29.3-Practice - Exercise #2

29.4-Practice - Exercise #3

29.5-Practice - Exercise #4

29.6-Practice - Exercise #5

30-BONUS LECTURE

30.1-Bonus Lecture: Next Steps

Course Categories

Popular Courses

SQL - MySQL for Data Analytics and Business Intelligence

Description

What you'll learn

Requirements

Course Content

You May Like