Udemy

Platform

English

Language

Data & Analytics

Category

SQL - MySQL for Data Analytics and Business Intelligence

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

4.59 (24661 reviews)

92059

Students

10 hours

Content

Oct 2020

Last Update
$94.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
SQL - MySQL for Data Analytics and Business Intelligence
SQL - MySQL for Data Analytics and Business Intelligence
SQL - MySQL for Data Analytics and Business Intelligence

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

S
Somdev9 October 2020

Yes, it's a good match for me and one of the best courses available online for SQL. Easy to understand and easy to follow even if you are not from an IT or CS background. I will definitely recommend this course for anyone who wants to learn SQL. The instructor did a great job. Thank you.

A
Abhishek8 October 2020

Thank you for the course. I have really liked it. Being new to SQL, this course has really helped me to understand the basics of SQL. I would definitely like to apply my SQL skills in my professional life and keep learning to advance my SQL skills.

S
Suman7 October 2020

its a good course, first some courses are little boring. But when I have been doing the practical its actually interesting. Thank you for your contribution.

S
Sarvesh6 October 2020

Excellent content and perfect pace!!. Also loved the way the topics are arranged. Only thing that could make this course even better is more practice questions (more sophisticated queries)

H
Hyung6 October 2020

Everything is good - easy to follow and understand except for the quiz part. It would have been better if there were explanations for both correct and wrong answers.

N
Nikki27 February 2020

It was a great course. However, there is a steep learning curve towards the end and the examples were very advanced. Maybe have more guidance before we look at the solution? It makes sense once you look at the solution but getting there felt impossible. Really enjoyed the sql/tableau section. First 100 lectures mainly for database administrators. The analytics side only came in right at the end.

C
Clay26 February 2020

so far I'm looking forward to seeing advanced queries, and learning how I can set up a relational database for the company I work for

J
Joseph26 February 2020

I haven't gotten into the complexities of SQL statement creation yet - but I will say that the first few sections of the course have been very insightful and easy to slip into the concepts.

L
Latrina25 February 2020

I appreciate the course is presented in small chunks of information which helps to maintains my attention and not be overwelmed.

A
Akash23 February 2020

Some of the most used functions not explained. Also the course didn't offers the promised other two course

D
Dixit22 February 2020

Its like a stupid presentation. Too fast to go into details. It lacks the teacher component. A mechanical voice with some animations going at a certain speed. No human component. At best it's informative. Learning a logical concept this way is not possible. Also, They ask for ratings in between the topics which shows lack of attention. Please don't waste your time.

B
Brian21 February 2020

Engaging speaker. Clear and concise illustrations and transitions. Enjoy the short segments to break down concepts into "bite size" chunks.

T
Twan20 February 2020

Wrapping up the introductory part (about 25% before starting actual data manipulation), I can already say that I recommend the course so far. I'm already familiar with SQL basics and decided to take this course as previous data analytics classes focused a lot more on Python modules used in DS without really touching about SQL or databases in general. The English is flawless and the instructions are very clear. The course starts with a very solid explanation of databases and why to use them, instead of directly jumping into the queries used to manipulate data as many other courses do. Having taken previous courses I never felt confident about working with SQL on my own device, but this course makes it so much easier to understand. I'm not yet sure how deep this course will go eventually, but so far the price I've paid was well worth it! Thanks!

R
Rahul20 February 2020

This course is very detailed and provides one with good and enough insights required to understand concepts.

C
Chika19 February 2020

Amazing!!! Absolutely a good match. The instructor knows just how to make this lessons sink. Good Job The quiz is quite short.



1405632

Udemy ID

10/23/2017

Course created date

8/6/2019

Course Indexed date
Bot
Course Submitted by

Twitter
Telegram
Android PlayStore
Apple Appstore