SQL - MySQL for Data Analytics and Business Intelligence
All LevelsBusinessSQL

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

Created by 365 Careers, 365 Team
11.5 hours
Video Content
334
Lectures
263,193
Students
4.6
Rating
4.6
(263,193 students enrolled)

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

Course Content

30 sections • 334 lectures • 12:04:57 total length

Introduction to databases, SQL, and MySQL

4 lectures • 14:12

What does the course cover?04:14
Why SQL?03:17
Why SQL?2 questions
Why MySQL?01:57
Why MySQL?1 question
+2 more lectures

SQL theory

6 lectures • 20:34

SQL as a declarative language02:10
SQL as a declarative language2 questions
Data definition language (DDL)04:12
Data definition language (DDL)1 question
SQL keywords01:12
+7 more lectures

Basic database terminology

7 lectures • 34:54

Relational database essentials04:51
Relational database essentials2 questions
Databases vs spreadsheets08:06
Databases vs spreadsheets2 questions
Database terminology04:16
+9 more lectures

Installing MySQL and getting acquainted with the interface

8 lectures • 27:14

Installing MySQL10:42
Additional note – Installing – Visual C00:21
Installing MySQL on macOS and Unix systems01:24
The Client-Server Model00:00
Setting up a connection02:34
+3 more lectures

First steps in SQL

22 lectures • 50:43

Creating a Database - Part I05:12
SQL files00:47
Creating a Database - Part I - exercise00:06
Creating a Database - Part I - solution00:03
Creating a Database - Part II02:21
+29 more lectures

MySQL constraints

16 lectures • 36:03

PRIMARY KEY constraint05:23
PRIMARY KEY Constraint1 question
PRIMARY KEY constraint - exercise00:17
PRIMARY KEY constraint - solution00:11
PRIMARY KEY constraint - Exercise #11 question
+20 more lectures

SQL best practices

2 lectures • 09:45

Coding techniques and best practices - Part I05:34
Coding techniques and best practices – Part I1 question
Coding techniques and best practices - Part II04:11
Coding techniques and best practices – Part II2 questions

Loading the 'employees' database

2 lectures • 02:56

Loading the 'employees' database02:19
Loading the 'employees' database00:37

SQL SELECT statement

59 lectures • 01:12:29

SELECT - FROM04:57
SELECT - FROM - exercise00:04
SELECT - FROM - solution00:01
CODING EXERCISES - the 'employees_10' Database00:23
SELECT - FROM - Exercise #11 question
+83 more lectures

SQL INSERT statement

9 lectures • 13:26

The INSERT statement - Part I06:04
The INSERT statement - Part II02:19
The INSERT statement - Exercise #11 question
The INSERT statement - Exercise #21 question
The INSERT statement - Exercise #31 question
+12 more lectures

SQL UPDATE Statement

6 lectures • 09:38

TCL's COMMIT and ROLLBACK02:41
The UPDATE Statement - Part I03:17
ROLLBACK; ARTICLE00:38
The UPDATE Statement - Part II02:55
The UPDATE Statement – Part II - exercise00:04
+3 more lectures

SQL DELETE Statement

5 lectures • 09:10

The DELETE Statement - Part I04:14
The DELETE Statement - Part II01:29
The DELETE Statement – Part II - exercise00:02
The DELETE Statement – Part II - solution00:01
The DELETE statement - Exercise #11 question
+3 more lectures

MySQL - Aggregate functions

22 lectures • 20:07

COUNT()04:14
COUNT() - exercise00:04
COUNT() - solution00:01
COUNT() - Exercise #11 question
SUM()01:30
+26 more lectures

SQL Joins

37 lectures • 01:17:27

Introduction to JOINs04:23
Intro to JOINs - exercise 100:32
Intro to JOINs - solution 100:20
Intro to JOINs - exercise 200:14
INNER JOIN - Part I06:02
+42 more lectures

SQL Subqueries

11 lectures • 17:18

SQL Subqueries with IN nested inside WHERE04:31
SQL Subqueries with IN nested inside WHERE - exercise00:05
SQL Subqueries with IN nested inside WHERE - solution00:04
SQL Subqueries with IN nested inside WHERE - Exercise #11 question
SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE03:42
+9 more lectures

SQL Self Join

1 lectures • 07:44

Self Join07:44
Self Join1 question
Self Join - Exercise #11 question
Self Join - Exercise #21 question
Self Join - Exercise #31 question

SQL Views

3 lectures • 07:27

Views07:12
Views - exercise00:11
Views - solution00:04
Views - Exercise #11 question

Stored routines

19 lectures • 48:32

Introduction to stored routines03:25
Introduction to Stored Routines1 question
The MySQL syntax for stored procedures04:32
Stored procedures - Example - Part I02:45
Stored procedures - Example - Part II04:48
+16 more lectures

Advanced SQL Topics

20 lectures • 45:07

Types of MySQL Variables - Local Variables04:56
Types of MySQL Variables - Local Variables1 question
Session Variables05:21
Session Variables1 question
Global Variables02:18
+26 more lectures

SQL Window Functions

28 lectures • 01:11:37

Introduction to MySQL Window Functions01:58
The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax09:11
The ROW_NUMBER() Ranking Window Function - Exercises00:24
The ROW_NUMBER() Ranking Window Function - Solution00:06
The ROW_NUMBER() Ranking Window Function - Exercise #11 question
+40 more lectures

SQL Common Table Expressions (CTEs)

9 lectures • 26:30

MySQL Common Table Expressions - Introduction06:59
An Alternative Solution to the Same Task01:53
An Alternative Solution to the Same Task-Exercise00:54
An Alternative Solution to the Same Task-Solution00:46
An Alternative Solution to the Same Task - Exercise #11 question
+9 more lectures

SQL Temporary Tables

7 lectures • 16:59

MySQL Temporary Tables - Introduction03:08
MySQL Temporary Tables in Action05:12
MySQL Temporary Tables in Action-Exercise00:10
MySQL Temporary Tables in Action-Solution00:07
MySQL Temporary Tables - Exercise #11 question
+8 more lectures

Combining SQL and Tableau - Introduction

5 lectures • 15:50

The Advantages of Software Integration05:20
Why Combining SQL and Tableau is useful04:54
Installing Tableau Public01:51
Loading the 'employees_mod' Database03:22
Loading the 'employees_mod' Database00:23

Combining SQL and Tableau - Task 1

8 lectures • 27:11

Task 105:33
Task 1 - Text00:05
Important clarification!00:50
Task 1: SQL Solution04:41
Task 1: SQL Solution - Code00:06
+4 more lectures

Combining SQL and Tableau - Task 2

5 lectures • 13:58

Task 203:50
Task 2 - Text00:05
Task 2: SQL Solution03:43
Task 2: SQL Solution - Code00:12
Chart 2: Visualizing and Analyzing the Solution in Tableau06:08
+1 more lectures

Combining SQL and Tableau - Task 3

5 lectures • 10:47

Task 302:21
Task 3 - Text00:07
Task 3: SQL Solution03:14
Task 3: SQL Solution - Code00:09
Chart 3: Visualizing and Analyzing the Solution in Tableau04:56
+1 more lectures

Combining SQL and Tableau - Task 4

5 lectures • 09:20

Task 402:45
Task 4 - Text00:13
Task 4: Solution in SQL02:47
Task 4: Solution in SQL - Code00:13
Chart 4: Visualizing and Analyzing the Solution in Tableau03:22

Combining SQL and Tableau - Task 5

1 lectures • 06:04

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

Practice SQL – 10 Final Query Questions

1 lectures • 00:40

Practice SQL – 10 Final Query Questions00:40
Practice - Exercise #11 question
Practice - Exercise #21 question
Practice - Exercise #31 question
Practice - Exercise #41 question
+1 more lectures

BONUS LECTURE

1 lectures • 01:02

Bonus Lecture: Next Steps01:02

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?  

  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 “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

This course includes:

  • 11.5 hours on-demand video
  • 182 articles
  • 99 downloadable resources
  • Access on mobile and TV
  • Full lifetime access
  • Certificate of completion

Instructors

365 Careers

365 Team

Students also download

Explore related courses to expand your learning journey.