SQL - MySQL for Data Analytics and Business Intelligence

9h 22m 55s
English
Paid

Course description

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.   

Read more about the course

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.   

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!  

Requirements:
  • No prior experience is required. We will start from the very basics
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

Watch Online

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 132 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing

Watch Online SQL - MySQL for Data Analytics and Business Intelligence

0:00
/
#1: What does the course cover?

All Course Lessons (132)

#Lesson TitleDurationAccess
1
What does the course cover? Demo
04:15
2
Why SQL?
03:18
3
Why MySQL?
01:58
4
Introduction to databases
04:45
5
SQL as a declarative language
02:12
6
Data definition language (DDL)
04:14
7
SQL keywords
01:13
8
Data manipulation language (DML)
04:56
9
Data control language (DCL)
05:04
10
Transaction control language (TCL)
03:03
11
Relational database essentials
04:52
12
Databases vs spreadsheets
08:07
13
Database terminology
04:18
14
Relational schemas - Primary key
04:56
15
Relational schemas - Foreign key
05:00
16
Relational schemas - Unique key and null values
03:08
17
Relationships
04:40
18
Installing MySQL
10:49
19
Setting up a connection
02:35
20
New Authentication Plugin - Creating a New User
06:19
21
Introduction to the MySQL interface
05:10
22
Creating a Database - Part I
05:13
23
Creating a Database - Part II
02:23
24
Introduction to data types
02:17
25
String data types
05:02
26
Integers
04:11
27
Fixed and floating-point data types
05:45
28
Other useful data types
06:13
29
Creating a table
05:18
30
Using databases and tables
03:04
31
Additional notes on using tables
02:13
32
PRIMARY KEY constraint
05:24
33
FOREIGN KEY constraint - Part I
05:26
34
FOREIGN KEY constraint - Part II
05:27
35
UNIQUE Constraint
05:01
36
DEFAULT Constraint
05:25
37
NOT NULL Constraint - Part I
05:54
38
NOT NULL Constraint - Part II
02:00
39
Coding techniques and best practices - Part I
05:35
40
Coding techniques and best practices - Part II
04:12
41
Loading the 'employees' database
02:20
42
SELECT - FROM
04:58
43
WHERE
02:31
44
AND
02:15
45
OR
03:36
46
Operator precedence
03:35
47
IN - NOT IN
03:13
48
LIKE - NOT LIKE
03:37
49
Wildcard characters
01:46
50
BETWEEN - AND
02:21
51
IS NOT NULL - IS NULL
01:38
52
Other comparison operators
04:31
53
SELECT DISTINCT
02:07
54
Introduction to aggregate functions
05:25
55
ORDER BY
03:47
56
GROUP BY
06:01
57
Using Aliases (AS)
02:09
58
HAVING
03:27
59
WHERE vs HAVING- Part I
04:05
60
WHERE vs HAVING- Part II
03:09
61
LIMIT
04:53
62
The INSERT statement - Part I
06:06
63
The INSERT statement - Part II
02:20
64
Inserting data INTO a new table
03:57
65
TCL's COMMIT and ROLLBACK
02:43
66
The UPDATE Statement - Part I
03:19
67
The UPDATE Statement - Part II
02:56
68
The DELETE Statement - Part I
04:15
69
The DELETE Statement - Part II
01:31
70
DROP vs TRUNCATE vs DELETE
03:24
71
COUNT()
04:15
72
SUM()
01:32
73
MIN() and MAX()
01:16
74
AVG()
01:59
75
ROUND()
02:07
76
IFNULL() and COALESCE()
06:26
77
Another Example of Using COALESCE()
01:37
78
Introduction to JOINs
04:24
79
INNER JOIN - Part I
06:04
80
INNER JOIN - Part II
05:34
81
A Note on Using Joins
04:10
82
Duplicate Records
04:22
83
LEFT JOIN - Part I
04:32
84
LEFT JOIN - Part II
05:47
85
RIGHT JOIN
04:31
86
The new and the old join syntax
04:18
87
JOIN and WHERE Used Together
02:54
88
CROSS JOIN
07:43
89
Using Aggregate Functions with Joins
02:18
90
JOIN more than two tables in SQL
04:28
91
Tips and tricks for joins
05:40
92
UNION vs UNION ALL
05:45
93
SQL Subqueries with IN nested inside WHERE
04:32
94
SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE
03:43
95
SQL Subqueries nested in SELECT and FROM
07:58
96
Self Join
07:46
97
Views
07:13
98
Introduction to stored routines
03:27
99
The MySQL syntax for stored procedures
04:33
100
Stored procedures - Example - Part I
02:46
101
Stored procedures - Example - Part II
04:50
102
Another way to create a procedure
03:20
103
Stored procedures with an input parameter
06:30
104
Stored procedures with an output parameter
03:21
105
Variables
06:51
106
User-defined functions in MySQL
06:15
107
Stored routines - conclusion
03:56
108
Types of MySQL Variables - Local Variables
04:57
109
Session Variables
05:22
110
Global Variables
02:19
111
User-Defined vs System Variables
04:13
112
MySQL Indexes
07:28
113
The CASE Statement
05:58
114
The Advantages of Software Integration
05:21
115
Why Combining SQL and Tableau is useful
04:55
116
Installing Tableau Public
01:52
117
Loading the 'employees_mod' Database
03:23
118
Task 1
05:34
119
Task 1: SQL Solution
04:42
120
Transferring a Dataset from SQL to Tableau
04:14
121
Chart 1: Visualizing and Analyzing the Solution in Tableau - Part I
06:18
122
Chart 1: Visualizing and Analyzing the Solution in Tableau - Part II
05:26
123
Task 2
03:51
124
Task 2: SQL Solution
03:44
125
Chart 2: Visualizing and Analyzing the Solution in Tableau
06:09
126
Task 3
02:22
127
Task 3: SQL Solution
03:15
128
Chart 3: Visualizing and Analyzing the Solution in Tableau
04:57
129
Task 4
02:46
130
Task 4: Solution in SQL
02:48
131
Chart 4: Visualizing and Analyzing the Solution in Tableau
03:23
132
Task 5: Organizing Charts 1-4 into a Beautiful Dashboard using Tableau
06:05

Unlock unlimited learning

Get instant access to all 131 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Complete SQL Mastery

Complete SQL Mastery

Sources: codewithmosh (Mosh Hamedani)
Big databases are everywhere these days. Facebook, Netflix, Uber, Airbnb use SQL-driven databases - to name just a few. So, to be a successful developer or data scientist you ne...
10 hours 47 minutes 7 seconds
Complete SQL + Databases Bootcamp: Zero to Mastery

Complete SQL + Databases Bootcamp: Zero to Mastery

Sources: zerotomastery.io
With so many online resources available, it can be paralyzing not only figuring out where to start but more importantly which courses will actually teach you the skills you need...
24 hours 6 minutes 52 seconds
DBMS

DBMS

Sources: takeUforward
This course is dedicated to the study of Database Management Systems (DBMS) - technologies that allow for efficient storage, processing, and protection of data.
21 hours 30 minutes 50 seconds
MySQL High Performance Tuning Guide

MySQL High Performance Tuning Guide

Sources: udemy
Tips for Tuning MySQL like a Pro. Learn how to prevent MySQL performance problems. Understand how MySQL optimizes and executes queries.
2 hours 49 minutes 22 seconds
PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours

PostgreSQL Bootcamp : Go From Beginner to Advanced, 60+hours

Sources: udemy
Subqueries? Yes, Recursive CTEs? Yes, Server programming with SQL and PL/pgSQL, Stored Procedures? Yes, Window Functions? Yes indeed and much more... This compr
67 hours 20 minutes 55 seconds