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?  

  1. 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  

  2. 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  

  3. 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_01SQL - MySQL for Data Analytics and Business Intelligence - Screenshot_02SQL - MySQL for Data Analytics and Business Intelligence - Screenshot_03SQL - 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
1405632
udemy ID
10/23/2017
course created date
8/6/2019
course indexed date
Bot
course submited by
Twitter LogoFacebookInstagram LogoYoutube LogoTelegram LogoEmail