CourseFlix

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

Udemy is the largest open marketplace for online courses on the internet. Founded in 2010 by Eren Bali, Oktay Caglar, and Gagan Biyani and headquartered in San Francisco, the company went public on the Nasdaq in 2021 under the ticker UDMY. The platform hosts well over two hundred thousand courses across software development, IT and cloud, data science, design, business, marketing, and creative skills, taught by tens of thousands of independent instructors. Roughly seventy million learners use it worldwide, and the corporate arm — Udemy Business — supplies a curated subset of that catalog to enterprise customers.

Because Udemy is a marketplace rather than a single editorial publisher, the catalog is uneven by design. The strongest material lives in the long-form, project-based courses authored by working engineers — full-stack JavaScript, React, Node.js, Python data science, AWS, Docker and Kubernetes, mobile development with Flutter and React Native, and cloud certification preparation. The CourseFlix listing under this source is the slice of that catalog that has been mirrored here for offline-friendly viewing, organized by topic and updated as new releases land. Pricing on Udemy itself swings dramatically with the site's near-permanent sales, which is why the platform is best treated as a deep reference catalog: pick instructors with strong reviews and a track record of updating their material rather than buying on the headline price alone.

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

Course content

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

Related courses

  • PostgreSQL Fundamentals thumbnail

    PostgreSQL Fundamentals

    Sources: Big Machine
    You will learn the basics of SQL and work with databases using PostgreSQL as an example - and you will truly enjoy it! We will work with a real dataset...
    2 hours 5 minutes 18 seconds 5 / 5
  • 100 Days Of Code: The Complete Web Development Bootcamp 2024 thumbnail

    100 Days Of Code: The Complete Web Development Bootcamp 2024

    Sources: Academind Pro (Maximilian Schwarzmüller)
    100 Days of Code: Complete Web Development Bootcamp 2024 by Colt Steele — updated curriculum with React, modern JS, REST APIs, and deployment.
    78 hours 51 minutes 55 seconds
  • SQL for Data Engineers thumbnail

    SQL for Data Engineers

    Sources: Andreas Kretz
    SQL is the foundation for working with relational databases. And if you are planning to work in the field of Data Engineering, knowing SQL is not just a...
    1 hour 51 minutes

Frequently asked questions

What is SQL - MySQL for Data Analytics and Business Intelligence about?
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…
Who teaches SQL - MySQL for Data Analytics and Business Intelligence?
SQL - MySQL for Data Analytics and Business Intelligence is taught by Udemy. You can find more courses by this instructor on the corresponding source page.
How long is SQL - MySQL for Data Analytics and Business Intelligence?
SQL - MySQL for Data Analytics and Business Intelligence contains 132 lessons with a total runtime of 9 hours 22 minutes. All lessons are available to watch online at your own pace.
Is SQL - MySQL for Data Analytics and Business Intelligence free to watch?
SQL - MySQL for Data Analytics and Business Intelligence is part of CourseFlix's premium catalog. A CourseFlix subscription unlocks the full video player; the course description, table of contents, and preview information are available to everyone.
Where can I watch SQL - MySQL for Data Analytics and Business Intelligence online?
SQL - MySQL for Data Analytics and Business Intelligence is available to watch online on CourseFlix at https://courseflix.net/course/sql-mysql-for-data-analytics-and-business-intelligence. The page hosts every lesson with the integrated video player; no download is required.