Mô tả

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 $103,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 1,750,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!  

Bạn sẽ học được gì

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

Yêu cầu

  • No prior experience is required. We will start from the very basics

Nội dung khoá học

30 sections

Introduction to databases, SQL, and MySQL

7 lectures
What does the course cover?
04:14
Why SQL?
03:17
Why SQL?
2 questions
Why MySQL?
01:57
Why MySQL?
1 question
Introduction to databases
04:44
Introduction to databases
2 questions

SQL theory

12 lectures
SQL as a declarative language
02:10
SQL as a declarative language
2 questions
Data definition language (DDL)
04:12
Data definition language (DDL)
1 question
SQL keywords
01:12
SQL keywords
1 question
Data manipulation language (DML)
04:55
Data manipulation language (DML)
1 question
Data control language (DCL)
05:03
Data control language (DCL)
1 question
Transaction control language (TCL)
03:02
Transaction control language (TCL)
1 question

Basic database terminology

14 lectures
Relational database essentials
04:51
Relational database essentials
2 questions
Databases vs spreadsheets
08:06
Databases vs spreadsheets
2 questions
Database terminology
04:16
Database terminology
1 question
Relational schemas - Primary key
04:55
Relational schemas - Primary key
1 question
Relational schemas - Foreign key
04:58
Relational schemas - Foreign key
3 questions
Relational schemas - Unique key and null values
03:07
Relational Schemas - Unique key
1 question
Relationships
04:39
Relational Schemas – Relationships
1 question

Installing MySQL and getting acquainted with the interface

8 lectures
Installing MySQL
10:48
Additional note – Installing – Visual C
00:21
Installing MySQL on macOS and Unix systems
01:24
The Client-Server Model
00:00
Setting up a connection
02:34
Read me!!!
00:44
New Authentication Plugin - Creating a New User
06:18
Introduction to the MySQL interface
05:09

First steps in SQL

26 lectures
Creating a Database - Part I
05:12
SQL files
00:47
Creating a Database - Part I - exercise
00:06
Creating a Database - Part I - solution
00:03
Creating a Database - Part II
02:21
Creating a Database - Part II - exercise
00:02
Creating a Database - Part II - solution
00:00
Introduction to data types
02:16
Introduction to data types
1 question
String data types
05:01
String data types
2 questions
Integers
04:10
Integers
1 question
Fixed and floating-point data types
05:43
Fixed and floating-point data types
1 question
Other useful data types
06:12
Other useful data types
1 question
Creating a table
05:16
Creating a table - exercise
00:10
Creating a table - solution
00:03
Using databases and tables
03:03
Using databases and tables - exercise
00:10
Using databases and tables - solution
00:01
Additional notes on using tables
02:12
Additional notes on using tables
1 question
Additional notes on using tables - exercise
00:09

MySQL constraints

17 lectures
PRIMARY KEY constraint
05:23
PRIMARY KEY Constraint
1 question
PRIMARY KEY constraint - exercise
00:17
PRIMARY KEY constraint - solution
00:11
FOREIGN KEY constraint - Part I
05:25
FOREIGN KEY constraint - Part II
05:26
FOREIGN KEY constraint - Part II - exercise
00:07
FOREIGN KEY constraint - Part II - solution
00:03
UNIQUE Constraint
05:00
UNIQUE Constraint - exercise
00:29
DEFAULT Constraint
05:24
DEFAULT Constraint - exercise
00:11
DEFAULT Constraint - solution
00:04
NOT NULL Constraint - Part I
05:53
NOT NULL Constraint - Part I - exercise
00:05
NOT NULL Constraint - Part I - solution
00:04
NOT NULL Constraint - Part II
01:59

SQL best practices

4 lectures
Coding techniques and best practices - Part I
05:34
Coding techniques and best practices – Part I
1 question
Coding techniques and best practices - Part II
04:11
Coding techniques and best practices – Part II
2 questions

Loading the 'employees' database

2 lectures
Loading the 'employees' database
02:19
Loading the 'employees' database
00:37

SQL SELECT statement

58 lectures
SELECT - FROM
04:57
SELECT - FROM - exercise
00:04
SELECT - FROM - solution
00:01
WHERE
02:30
WHERE - exercise
00:03
WHERE - solution
00:01
AND
02:14
AND - exercise
00:03
AND - solution
00:02
OR
03:35
OR - exercise
00:03
OR - solution
00:02
Operator precedence
03:34
Operator precedence - exercise
00:03
Operator precedence - solution
00:03
IN - NOT IN
03:12
IN - NOT IN - exercise 1
00:05
IN - NOT IN - solution 1
00:02
IN - NOT IN - exercise 2
00:04
IN - NOT IN - solution 2
00:02
LIKE - NOT LIKE
03:36
LIKE - NOT LIKE - exercise
00:16
LIKE - NOT LIKE - solution
00:05
Wildcard characters
01:44
Wildcard characters - exercise
00:07
Wildcard characters - solution
00:03
BETWEEN - AND
02:19
BETWEEN - AND - exercise
00:11
BETWEEN - AND- solution
00:08
IS NOT NULL - IS NULL
01:37
IS NOT NULL - IS NULL - exercise
00:03
IS NOT NULL - IS NULL - solution
00:02
Other comparison operators
04:30
Other comparison operators - exercise
00:10
Other comparison operators - solution
00:03
SELECT DISTINCT
02:05
SELECT DISTINCT - exercise
00:13
SELECT DISTINCT - solution
00:01
Introduction to aggregate functions
05:24
Introduction to aggregate functions - exercise
00:10
Introduction to aggregate functions - solution
00:02
ORDER BY
03:46
ORDER BY - exercise
00:03
ORDER BY - solution
00:01
GROUP BY
06:00
Using Aliases (AS)
02:08
Using Aliases (AS) - exercise
00:12
Using Aliases (AS) - solution
00:04
HAVING
03:26
HAVING - exercise
00:13
HAVING - solution
00:16
WHERE vs HAVING- Part I
04:03
WHERE vs HAVING- Part II
03:08
WHERE vs HAVING - Part II - exercise
00:07
WHERE vs HAVING - Part II - solution
00:04
LIMIT
04:51
LIMIT - exercise
00:02
LIMIT - solution
00:01

SQL INSERT statement

9 lectures
The INSERT statement - Part I
06:04
The INSERT statement - Part II
02:19
The INSERT statement - exercise 1
00:38
The INSERT statement - solution 1
00:05
The INSERT statement - exercise 2
00:12
The INSERT statement - solution 2
00:05
Inserting data INTO a new table
03:55
Inserting Data INTO a New Table - exercise
00:05
Inserting Data INTO a New Table - solution
00:01

SQL UPDATE Statement

6 lectures
TCL's COMMIT and ROLLBACK
02:41
The UPDATE Statement - Part I
03:17
ROLLBACK; ARTICLE
00:38
The UPDATE Statement - Part II
02:55
The UPDATE Statement – Part II - exercise
00:04
The UPDATE Statement – Part II - solution
00:02

SQL DELETE Statement

6 lectures
The DELETE Statement - Part I
04:14
The DELETE Statement - Part II
01:29
The DELETE Statement – Part II - exercise
00:02
The DELETE Statement – Part II - solution
00:01
DROP vs TRUNCATE vs DELETE
03:23
DROP vs TRUNCATE vs DELETE
2 questions

MySQL - Aggregate functions

23 lectures
COUNT()
04:14
COUNT() - exercise
00:04
COUNT() - solution
00:01
SUM()
01:30
SUM() - exercise
00:05
SUM() - solution
00:01
MIN() and MAX()
01:15
MIN() and MAX() - exercise
00:04
MIN() and MAX() - solution
00:02
AVG()
01:58
AVG() - exercise
00:04
AVG() - solution
00:01
ROUND()
02:06
ROUND() - exercise
00:06
ROUND() - solution
00:02
COALESCE() - Preamble
00:00
IFNULL() and COALESCE()
06:24
Another Example of Using COALESCE()
01:36
Another example of using COALESCE() - exercise 1
00:08
Another example of using COALESCE() - solution 1
00:03
Another example of using COALESCE() - exercise 2
00:12
Another example of using COALESCE() - solution 2
00:05
Another example of using COALESCE()
1 question

SQL Joins

37 lectures
Introduction to JOINs
04:23
Intro to JOINs - exercise 1
00:32
Intro to JOINs - solution 1
00:20
Intro to JOINs - exercise 2
00:14
INNER JOIN - Part I
06:02
INNER JOIN - Part II
05:33
INNER JOIN - Part II - exercise
00:04
INNER JOIN - Part II - solution
00:03
A Note on Using Joins
04:09
Duplicate Records
04:21
LEFT JOIN - Part I
04:31
LEFT JOIN - Part II
05:46
LEFT JOIN - Part II - exercise
00:13
LEFT JOIN - Part II - solution
00:06
RIGHT JOIN
04:30
The new and the old join syntax
04:17
The new and the old join syntax - exercise
00:07
The new and the old join syntax - solution
00:08
JOIN and WHERE Used Together
02:53
Important – Prevent Error Code: 1055!
02:04
JOIN and WHERE Used Together - exercise
00:06
JOIN and WHERE Used Together - solution
00:06
CROSS JOIN
07:42
CROSS JOIN - exercise 1
00:05
CROSS JOIN - solution 1
00:04
CROSS JOIN - exercise 2
00:06
CROSS JOIN - solution 2
00:04
Using Aggregate Functions with Joins
02:17
JOIN more than two tables in SQL
04:26
Join more than two tables in SQL - exercise
00:04
Join more than two tables in SQL - solution
00:17
Tips and tricks for joins
05:39
Tips and tricks for joins - exercise
00:03
Tips and tricks for joins - solution
00:03
UNION vs UNION ALL
05:44
UNION vs UNION ALL - exercise
00:07
UNION vs UNION ALL - solution
00:10

SQL Subqueries

11 lectures
SQL Subqueries with IN nested inside WHERE
04:31
SQL Subqueries with IN nested inside WHERE - exercise
00:05
SQL Subqueries with IN nested inside WHERE - solution
00:04
SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE
03:42
SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - exercise
00:05
SQL Subqueries with EXISTS-NOT EXISTS nested inside WHERE - solution
00:04
SQL Subqueries nested in SELECT and FROM
07:56
SQL Subqueries nested in SELECT and FROM - exercise 1
00:07
SQL Subqueries nested in SELECT and FROM - solution 1
00:04
SQL Subqueries nested in SELECT and FROM - exercise 2
00:38
SQL Subqueries nested in SELECT and FROM - solution 2
00:00

SQL Self Join

2 lectures
Self Join
07:44
Self join
1 question

SQL Views

3 lectures
Views
07:12
Views - exercise
00:11
Views - solution
00:04

Stored routines

21 lectures
Introduction to stored routines
03:25
Introduction to Stored Routines
1 question
The MySQL syntax for stored procedures
04:32
Stored procedures - Example - Part I
02:45
Stored procedures - Example - Part II
04:48
Stored procedures - Example - Part II - exercise
00:04
Stored procedures - Example - Part II - solution
00:04
Another way to create a procedure
03:19
Stored procedures with an input parameter
06:29
Stored procedures with an output parameter
03:19
Stored procedures with an output parameter - exercise
00:05
Stored procedures with an output parameter - solution
00:07
Variables
06:50
Variables - exercise
00:10
Variables - solution
00:02
User-defined functions in MySQL
06:14
Error Code: 1418.
01:50
User-defined functions in MySQL - exercise
00:16
User-defined functions in MySQL - solution
00:15
Stored routines - conclusion
03:55
Stored routines - conclusion
1 question

Advanced SQL Topics

24 lectures
Types of MySQL Variables - Local Variables
04:56
Types of MySQL Variables - Local Variables
1 question
Session Variables
05:21
Session Variables
1 question
Global Variables
02:18
Global Variables
1 question
User-Defined vs System Variables
04:12
User-Defined vs System Variables
1 question
MySQL Triggers
00:28
MySQL Triggers
12:29
MySQL Triggers - exercise
00:08
MySQL Triggers - solution
00:09
MySQL Indexes
07:27
MySQL Indexes - exercise 1
00:01
MySQL Indexes - solution 1
00:01
MySQL Indexes - exercise 2
00:10
MySQL Indexes - solution 2
00:04
The CASE Statement
05:57
The CASE Statement - exercise 1
00:14
The CASE Statement - solution 1
00:07
The CASE Statement - exercise 2
00:14
The CASE Statement - solution 2
00:24
The CASE Statement - exercise 3
00:15
The CASE Statement - solution 3
00:08

SQL Window Functions

28 lectures
Introduction to MySQL Window Functions
01:58
The ROW_NUMBER() Ranking Window Function and the Relevant MySQL Syntax
09:11
The ROW_NUMBER() Ranking Window Function - Exercises
00:24
The ROW_NUMBER() Ranking Window Function - Solution
00:06
A Note on Using Several Window Functions in a Query
02:41
A Note on Using Several Window Functions - Exercise
01:09
A Note on Using Several Window Functions - Solution
00:19
MySQL Window Functions Syntax
03:51
MySQL Window Functions Syntax - Exercise
00:16
MySQL Window Functions Syntax - Solution
00:04
The PARTITION BY Clause VS the GROUP BY Clause
06:28
The PARTITION BY Clause VS the GROUP BY Clause - Exercise
01:17
The PARTITION BY Clause VS the GROUP BY Clause - Solution
00:32
The MySQL RANK() and DENSE_RANK() Window Functions
07:54
The MySQL RANK() and DENSE_RANK() Window Functions - Exercise
00:44
The MySQL RANK() and DENSE_RANK() Window Functions - Solution
00:21
Working with MySQL Ranking Window Functions and Joins Together
08:26
Working with MySQL Ranking Window Functions and Joins Together - Exercise
00:40
Working with MySQL Ranking Window Functions and Joins Together - Solution
00:22
The LAG() and LEAD() Value Window Functions
08:35
The LAG() and LEAD() Value Window Functions - Exercise
00:59
The LAG() and LEAD() Value Window Functions - Solution
00:19
MySQL Aggregate Functions in the Context of Window Functions - Part I
06:13
MySQL Aggregate Functions in the Context of Window Functions - Part I-Exercise
00:12
MySQL Aggregate Functions in the Context of Window Functions - Part I-Solution
00:08
MySQL Aggregate Functions in the Context of Window Functions - Part II
06:47
MySQL Aggregate Functions in the Context of Window Functions - Part II-Exercise
01:03
MySQL Aggregate Functions in the Context of Window Functions - Part II-Solution
00:31

SQL Common Table Expressions (CTEs)

9 lectures
MySQL Common Table Expressions - Introduction
06:59
An Alternative Solution to the Same Task
01:53
An Alternative Solution to the Same Task-Exercise
00:47
An Alternative Solution to the Same Task-Solution
00:46
Using Multiple Subclauses in a WITH Clause - Part I
05:32
Using Multiple Subclauses in a WITH Clause - Part II
05:19
Using Multiple Subclauses in a WITH Clause-Exercise
00:24
Using Multiple Subclauses in a WITH Clause-Solution
00:42
Referring to Common Table Expressions in a WITH Clause
03:59

SQL Temporary Tables

7 lectures
MySQL Temporary Tables - Introduction
03:08
MySQL Temporary Tables in Action
05:12
MySQL Temporary Tables in Action-Exercise
00:10
MySQL Temporary Tables in Action-Solution
00:07
Other Features of MySQL Temporary Tables
07:22
Other Features of MySQL Temporary Tables-Exercise
00:40
Other Features of MySQL Temporary Tables-Solution
00:19

Combining SQL and Tableau - Introduction

5 lectures
The Advantages of Software Integration
05:20
Why Combining SQL and Tableau is useful
04:54
Installing Tableau Public
01:51
Loading the 'employees_mod' Database
03:22
Loading the 'employees_mod' Database
00:23

Combining SQL and Tableau - Task 1

8 lectures
Task 1
05:33
Task 1 - Text
00:05
Important clarification!
00:50
Task 1: SQL Solution
04:41
Task 1: SQL Solution - Code
00:06
Transferring a Dataset from SQL to Tableau
04:13
Chart 1: Visualizing and Analyzing the Solution in Tableau - Part I
06:17
Chart 1: Visualizing and Analyzing the Solution in Tableau - Part II
05:25

Combining SQL and Tableau - Task 2

5 lectures
Task 2
03:50
Task 2 - Text
00:05
Task 2: SQL Solution
03:43
Task 2: SQL Solution - Code
00:12
Chart 2: Visualizing and Analyzing the Solution in Tableau
06:08

Combining SQL and Tableau - Task 3

5 lectures
Task 3
02:21
Task 3 - Text
00:07
Task 3: SQL Solution
03:14
Task 3: SQL Solution - Code
00:09
Chart 3: Visualizing and Analyzing the Solution in Tableau
04:56

Combining SQL and Tableau - Task 4

5 lectures
Task 4
02:45
Task 4 - Text
00:13
Task 4: Solution in SQL
02:47
Task 4: Solution in SQL - Code
00:13
Chart 4: Visualizing and Analyzing the Solution in Tableau
03:22

Combining SQL and Tableau - Task 5

1 lectures
Task 5: Organizing Charts 1-4 into a Beautiful Dashboard using Tableau
06:04

Practice SQL – 10 Final Query Questions

1 lectures
Practice SQL – 10 Final Query Questions
00:40

BONUS LECTURE

1 lectures
Bonus Lecture: Next Steps
01:02

Đánh giá của học viên

Chưa có đánh giá
Course Rating
5
0%
4
0%
3
0%
2
0%
1
0%

Bình luận khách hàng

Viết Bình Luận

Bạn đánh giá khoá học này thế nào?

image

Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!

Get khoá học giá rẻ ngay trước khi bị fix.