SQL - MySQL for Data Analytics and Business Intelligence

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

4.61 (33198 reviews)

Udemy

platform

English

language

Data & Analytics

category

instructor

129,006

students

10 hours

content

Mar 2021

last update

$189.99

regular price

What you will 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

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 $92,000! 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 210,000 students have enrolled in our courses here on Udemy. Teaching is what we do best, and we take pride in going the extra mile to create the best 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 “Take this course” button, and let’s begin this journey together!

Screenshots

SQL - MySQL for Data Analytics and Business Intelligence - Screenshot_01

SQL - MySQL for Data Analytics and Business Intelligence - Screenshot_02

SQL - MySQL for Data Analytics and Business Intelligence - Screenshot_03

SQL - MySQL for Data Analytics and Business Intelligence - Screenshot_04

Content

Introduction to databases, SQL, and MySQL

What does the course cover?

Why SQL?

Why SQL?

Why MySQL?

Why MySQL?

Introduction to databases

Introduction to databases

SQL theory

SQL as a declarative language

SQL as a declarative language

Data definition language (DDL)

Data definition language (DDL)

SQL keywords

SQL keywords

Data manipulation language (DML)

Data manipulation language (DML)

Data control language (DCL)

Data control language (DCL)

Transaction control language (TCL)

Transaction control language (TCL)

Basic database terminology

Relational database essentials

Relational database essentials

Databases vs spreadsheets

Databases vs spreadsheets

Database terminology

Database terminology

Relational schemas - Primary key

Relational schemas - Primary key

Relational schemas - Foreign key

Relational schemas - Foreign key

Relational schemas - Unique key and null values

Relational Schemas - Unique key

Relationships

Relational Schemas – Relationships

Installing MySQL and getting acquainted with the interface

Installing MySQL

Additional note – Installing – Visual C

Installing MySQL on macOS and Unix systems

The Client-Server Model

Setting up a connection

Read me!!!

New Authentication Plugin - Creating a New User

Introduction to the MySQL interface

First steps in SQL

Creating a Database - Part I

SQL files

Creating a Database - Part I - exercise

Creating a Database - Part I - solution

Creating a Database - Part II

Creating a Database - Part II - exercise

Creating a Database - Part II - solution

Introduction to data types

Introduction to data types

String data types

String data types

Integers

Integers

Fixed and floating-point data types

Fixed and floating-point data types

Other useful data types

Other useful data types

Creating a table

Creating a table - exercise

Creating a table - solution

Using databases and tables

Using databases and tables - exercise

Using databases and tables - solution

Additional notes on using tables

Additional notes on using tables

Additional notes on using tables - exercise

MySQL constraints

PRIMARY KEY constraint

PRIMARY KEY Constraint

PRIMARY KEY constraint - exercise

PRIMARY KEY constraint - solution

FOREIGN KEY constraint - Part I

FOREIGN KEY constraint - Part II

FOREIGN KEY constraint - Part II - exercise

FOREIGN KEY constraint - Part II - solution

UNIQUE Constraint

UNIQUE Constraint - exercise

DEFAULT Constraint

DEFAULT Constraint - exercise

DEFAULT Constraint - solution

NOT NULL Constraint - Part I

NOT NULL Constraint - Part I - exercise

NOT NULL Constraint - Part I - solution

NOT NULL Constraint - Part II

SQL best practices

Coding techniques and best practices - Part I

Coding techniques and best practices – Part I

Coding techniques and best practices - Part II

Coding techniques and best practices – Part II

Loading the 'employees' database

Loading the 'employees' database

Loading the 'employees' database

SQL SELECT statement

SELECT - FROM

SELECT - FROM - exercise

SELECT - FROM - solution

WHERE

WHERE - exercise

WHERE - solution

AND

AND - exercise

AND - solution

OR

OR - exercise

OR - solution

Operator precedence

Operator precedence - exercise

Operator precedence - solution

IN - NOT IN

IN - NOT IN - exercise 1

IN - NOT IN - solution 1

IN - NOT IN - exercise 2

IN - NOT IN - solution 2

LIKE - NOT LIKE

LIKE - NOT LIKE - exercise

LIKE - NOT LIKE - solution

Wildcard characters

Wildcard characters - exercise

Wildcard characters - solution

BETWEEN - AND

BETWEEN - AND - exercise

BETWEEN - AND- solution

IS NOT NULL - IS NULL

IS NOT NULL - IS NULL - exercise

IS NOT NULL - IS NULL - solution

Other comparison operators

Other comparison operators - exercise

Other comparison operators - solution

SELECT DISTINCT

SELECT DISTINCT - exercise

SELECT DISTINCT - solution

Introduction to aggregate functions

Introduction to aggregate functions - exercise

Introduction to aggregate functions - solution

ORDER BY

ORDER BY - exercise

ORDER BY - solution

GROUP BY

Using Aliases (AS)

Using Aliases (AS) - exercise

Using Aliases (AS) - solution

HAVING

HAVING - exercise

HAVING - solution

WHERE vs HAVING- Part I

WHERE vs HAVING- Part II

WHERE vs HAVING - Part II - exercise

WHERE vs HAVING - Part II - solution

LIMIT

LIMIT - exercise

LIMIT - solution

SQL INSERT statement

The INSERT statement - Part I

The INSERT statement - Part II

The INSERT statement - exercise 1

The INSERT statement - solution 1

The INSERT statement - exercise 2

The INSERT statement - solution 2

Inserting data INTO a new table

Inserting Data INTO a New Table - exercise

Inserting Data INTO a New Table - solution

SQL UPDATE Statement

TCL's COMMIT and ROLLBACK

The UPDATE Statement - Part I

ROLLBACK; ARTICLE

The UPDATE Statement - Part II

The UPDATE Statement – Part II - exercise

The UPDATE Statement – Part II - solution

SQL DELETE Statement

The DELETE Statement - Part I

The DELETE Statement - Part II

The DELETE Statement – Part II - exercise

The DELETE Statement – Part II - solution

DROP vs TRUNCATE vs DELETE

DROP vs TRUNCATE vs DELETE

MySQL - Aggregate functions

COUNT()

COUNT() - exercise

COUNT() - solution

SUM()

SUM() - exercise

SUM() - solution

MIN() and MAX()

MIN() and MAX() - exercise

MIN() and MAX() - solution

AVG()

AVG() - exercise

AVG() - solution

ROUND()

ROUND() - exercise

ROUND() - solution

COALESCE() - Preamble

IFNULL() and COALESCE()

Another Example of Using COALESCE()

Another example of using COALESCE() - exercise 1

Another example of using COALESCE() - solution 1

Another example of using COALESCE() - exercise 2

Another example of using COALESCE() - solution 2

Another example of using COALESCE()

SQL Joins

Introduction to JOINs

Intro to JOINs - exercise 1

Intro to JOINs - solution 1

Intro to JOINs - exercise 2

INNER JOIN - Part I

INNER JOIN - Part II

INNER JOIN - Part II - exercise

INNER JOIN - Part II - solution

A Note on Using Joins

Duplicate Records

LEFT JOIN - Part I

LEFT JOIN - Part II

LEFT JOIN - Part II - exercise

LEFT JOIN - Part II - solution

RIGHT JOIN

The new and the old join syntax

The new and the old join syntax - exercise

The new and the old join syntax - solution

JOIN and WHERE Used Together

Important – Prevent Error Code: 1055!

JOIN and WHERE Used Together - exercise

JOIN and WHERE Used Together - solution

CROSS JOIN

CROSS JOIN - exercise 1

CROSS JOIN - solution 1

CROSS JOIN - exercise 2

CROSS JOIN - solution 2

Using Aggregate Functions with Joins

JOIN more than two tables in SQL

Join more than two tables in SQL - exercise

Join more than two tables in SQL - solution

Tips and tricks for joins

Tips and tricks for joins - exercise

Tips and tricks for joins - solution

UNION vs UNION ALL

UNION vs UNION ALL - exercise

UNION vs UNION ALL - solution

SQL Subqueries

SQL Subqueries with IN nested inside WHERE

SQL Subqueries with IN nested inside WHERE - exercise

SQL Subqueries with IN nested inside WHERE - solution

SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE

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

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

SQL Subqueries nested in SELECT and FROM

SQL Subqueries nested in SELECT and FROM - exercise 1

SQL Subqueries nested in SELECT and FROM - solution 1

SQL Subqueries nested in SELECT and FROM - exercise 2

SQL Subqueries nested in SELECT and FROM - solution 2

SQL Self Join

Self Join

Self join

SQL Views

Views

Views - exercise

Views - solution

Stored routines

Introduction to stored routines

Introduction to Stored Routines

The MySQL syntax for stored procedures

Stored procedures - Example - Part I

Stored procedures - Example - Part II

Stored procedures - Example - Part II - exercise

Stored procedures - Example - Part II - solution

Another way to create a procedure

Stored procedures with an input parameter

Stored procedures with an output parameter

Stored procedures with an output parameter - exercise

Stored procedures with an output parameter - solution

Variables

Variables - exercise

Variables - solution

User-defined functions in MySQL

Error Code: 1418.

User-defined functions in MySQL - exercise

User-defined functions in MySQL - solution

Stored routines - conclusion

Stored routines - conclusion

Advanced SQL Topics

Types of MySQL Variables - Local Variables

Types of MySQL Variables - Local Variables

Session Variables

Session Variables

Global Variables

Global Variables

User-Defined vs System Variables

User-Defined vs System Variables

MySQL Triggers

MySQL Triggers - exercise

MySQL Triggers - solution

MySQL Indexes

MySQL Indexes - exercise 1

MySQL Indexes - solution 1

MySQL Indexes - exercise 2

MySQL Indexes - solution 2

The CASE Statement

The CASE Statement - exercise 1

The CASE Statement - solution 1

The CASE Statement - exercise 2

The CASE Statement - solution 2

The CASE Statement - exercise 3

The CASE Statement - solution 3

Combining SQL and Tableau - Introduction

The Advantages of Software Integration

Why Combining SQL and Tableau is useful

Installing Tableau Public

Loading the 'employees_mod' Database

Loading the 'employees_mod' Database

Combining SQL and Tableau - Task 1

Task 1

Task 1 - Text

Important clarification!

Task 1: SQL Solution

Task 1: SQL Solution - Code

Transferring a Dataset from SQL to Tableau

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

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

Combining SQL and Tableau - Task 2

Task 2

Task 2 - Text

Task 2: SQL Solution

Task 2: SQL Solution - Code

Chart 2: Visualizing and Analyzing the Solution in Tableau

Combining SQL and Tableau - Task 3

Task 3

Task 3 - Text

Task 3: SQL Solution

Task 3: SQL Solution - Code

Chart 3: Visualizing and Analyzing the Solution in Tableau

Combining SQL and Tableau - Task 4

Task 4

Task 4 - Text

Task 4: Solution in SQL

Task 4: Solution in SQL - Code

Chart 4: Visualizing and Analyzing the Solution in Tableau

Combining SQL and Tableau - Task 5

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

Practice SQL – 10 Final Query Questions

Practice SQL – 10 Final Query Questions

BONUS LECTURE

Bonus Lecture: Next Steps

Reviews

Tyler

23 November 2021

Very good course. My skills improved quite a bit. I think it stops short of truly advanced features, and at times the pacing felt a bit strange. I feel like Tableau could have been introduced far sooner, as well as possibly an interaction with Python. All in all though, worth the money and a solid course.

P.

20 November 2021

The course was taught in a structured manner such that even a novice would understand it. The integration of MySQL to Tableau is amazing.

Heng

19 November 2021

Very well explained concepts, well organized course content and a great integration of the SQL and Tableau at the latest section. Very useful exercises to put in practice what we learned.

Michael

18 November 2021

Plenty of examples and clear instructions. Also loved the practical lessons on combining SQL and Tableau.

Marianne

18 November 2021

very disappointed, this exercise expects learner to know AVG aggregate function however, was briefly mentioned as option during extremely short aggregate function lesson, only count was discussed

Pawel

17 November 2021

Very good and broad course. It does cover most important parts of the business intelligence tasks! Definitely it's worth the time!

Lucia

15 November 2021

So far the content and lecturer makes me look forward to completing the course. I currently work as Business Analyst and looking forward in applying this skill

Lukas

14 November 2021

I really enjoyed the instructor's style. He was very consistent through out. Probably the best SQL course I've done. It is thorough in introducing the basics and the more advanced topics are integrated slowly so as not to overwhelm, but are still covered in great detail. The assignments throughout set this course a part. They are well constructed and challenging. The only aspect of the course I did not like were the quizzes. I found them pretty useless and the questions are sometimes phrased oddly (Select the WRONG answer from the following). But the instructor's clear tone and the well organized videos more than make up for this. Five stars!

Dimitrios

10 November 2021

An excellent course! Detailed and step-by-step teaching of SQL. I really loved the Tableau part! I would like better texts about the excercises. They were a bit frustrating sometimes and not so detailed. But in general, I admit it was above expectations

Chetan

9 November 2021

I like the way of presenting and explaining the course. And more importantly it covers all those topics that are necessary to do real time jobs.

Jhonatan

3 November 2021

This is a very complete course including bonus using Tableau for business intelligence, the instructor handles very well the subjects and he explains very clear each topic with neutral English language accent. Thank you!

Bruno

1 November 2021

Finished the course and I can say that it met every expectation I had, it was a hands-on course pretty basic in the beginning but challenging towards the end. The Q&A helped and also the videos predicting errors that often happened. Thank you, 365 Team!

Aaron

28 October 2021

i am beginning to get a grip on sql iam use to having hard time understanding Primary and foreign Key. the best course out here for SQL.

PINGPING

25 October 2021

Overall is great, but the exercises are too easy! It would be beneficial for students if there were more challenges.

Petr

5 October 2021

Good lectures, extra-detailing narrator, best choice to start from zero or refresh and structure knowledges:)

Charts

Price

SQL - MySQL for Data Analytics and Business Intelligence - Price chart

Rating

SQL - MySQL for Data Analytics and Business Intelligence - Ratings chart

Enrollment distribution

SQL - MySQL for Data Analytics and Business Intelligence - Distribution chart

Related Topics

Business Intelligence

1405632

udemy ID

10/23/2017

course created date

8/6/2019

course indexed date

Bot

course submited by