SQL - MySQL for Data Analytics and Business Intelligence

9h 22m 55s
English
Paid

Mastering SQL allows you to independently manage and analyze data without relying on others. This skill is crucial for effective database management, which forms the foundation of data analysis and drives intelligent business decisions. By learning SQL, you can uncover insights that enhance business operations and contribute to success.

Why Database Management is Essential

In the era of big data, effective database management is critical.

It underpins business intelligence and is a skill highly sought after by employers. Yet, not everyone has these skills, which makes it an opportune time to learn SQL and gain a competitive edge in the job market. The average salary of a SQL developer is $92,000, reflecting how lucrative this career path can be.

Concerned about lacking prior experience?

No worries. This course starts from the basics and builds your understanding step by step, ensuring no details are overlooked.

Why Choose This Course?

This course is designed to be:

  • Easy to understand

  • Time-efficient and concise

  • Demonstrative of SQL's role in data analytics and business intelligence

  • Comprehensive, covering unique topics

  • Practical, with real-life database project work

  • Aligned with professional best practices

  • Taught in MySQL, the leading SQL database management system

  • Rich in downloadable exercises, course notes, and quizzes

Combining these elements makes this course a unique and enriching learning experience, preparing you for real-world challenges.

Our Commitment to Excellence

We pride ourselves in delivering quality education

With over 210,000 students enrolled, our courses offer an engaging learning journey bridging the gap between theory and practical application.

Top Reasons to Enroll

  1. Potential Income: SQL skills open lucrative career opportunities with high demand in database management and analysis.

  2. Future-Proof Profession: As data grows in significance, SQL expertise will remain vital.

  3. Enhanced Analytical Reasoning: Learning programming languages sharpens logical thinking and problem-solving skills.

Certification and Recognition

Upon course completion, you will receive a certificate showcasing your proficiency, enhancing your resume and visibility to potential employers.

Ready to start your SQL journey? Click “Take this course” and dive into an exciting learning adventure!

Course Requirements

  • No prior experience is needed. We begin from the very basics.

Who Should Enroll?

  • Aspiring SQL developers, database administrators, and business analysts
  • Programming beginners
  • Anyone eager to learn coding and apply skills in practical scenarios

What You'll Learn

  • Expertise in SQL
  • SQL coding skills
  • Enhanced resume with an in-demand skill
  • Database creation, design, and management
  • Utilization of MySQL, the leading Database Management System
  • Preparation for various job opportunities
  • Adoption of SQL best practices
  • Insights into relational databases
  • Hands-on experience with a sophisticated database
  • Comprehensive preparation for database management
  • Development of data analytical tools
  • Business insight through big data tasks
  • Daily applicable relational database management theory
  • Database creation from scratch
  • Control over dataset operations
  • Mastery of relational data tables and constraints
  • Proficiency in MySQL Workbench
  • Advanced coding techniques and best practices
  • Capability to answer business questions using SQL's aggregate functions
  • Ease in handling complex SQL joins
  • Advanced topics like triggers, sequences, and indexing
  • Combining coding skills with business acumen
  • Efficient and flawless SQL query writing
  • Comprehensive exercises to reinforce knowledge
  • Freedom to query any database

About the Author: udemy

udemy thumbnail
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams. Udemy is the leading global marketplace for teaching and learning, connecting millions of students to the skills they need to succeed. Udemy helps organizations of all kinds prepare for the ever-evolving future of work. Our curated collection of top-rated business and technical courses gives companies, governments, and nonprofits the power to develop in-house expertise and satisfy employees’ hunger for learning and development.

Watch Online 132 lessons

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