The Complete MySQL Bootcamp: From SQL Beginner to Expert
4.5 (79 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
948 students enrolled

The Complete MySQL Bootcamp: From SQL Beginner to Expert

Learn SQL From Scratch using MySQL. SQL Database for Beginners. Master SQL Skills and Database Management.
4.5 (79 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
948 students enrolled
Created by Vertex Academy
Last updated 7/2020
English
English [Auto]
Current price: $58.99 Original price: $84.99 Discount: 31% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 8 hours on-demand video
  • 1 article
  • 22 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Create databases and interact with existing databases
  • Write SQL queries and generate reports
  • Use SQL for data analysis
  • Start using MySQL (#1 according to the latest Stack Overflow Survey)
  • Boost your resume with the most in-demand skill
Requirements
  • No prior experience is necessary. All you need a computer!
Description

Welcome to The Complete MySQL Bootcamp: From SQL Beginner to Expert.

According to the Stack Overflow Survey 2019, SQL takes third place (54.4%) among the most popular programming, scripting and markup languages.

Knowing SQL is a MUST for:

  • Web Developers

  • Node.js Developers

  • Python Developers

  • Java Developers

  • Business Analysts

  • Marketing Analysts

  • Data Science Specialists

  • Everyone working with databases and data analysis

Strengthen your resume now by learning SQL and find a better job by mastering the most in-demand skill used by tech giants like Google, YouTube, Amazon, PayPal, Netflix and others.


Do I need prior programming experience?

No prior programming experience is necessary. We will take you step by step through everything there is to know about SQL.


What if I have questions during the course?

In this SQL course you will never be alone. Our support team will be with you every step of the way, ready to answer your questions.


How will my lessons look?

Straight to the point, no time wasted!  Firstly, all theory will be explained on slides and after you get the concept, we show you how it works in practice.


Will I have lots of practice?

This course comes packed with lots of exercises to effectively practice and actually use SQL in order to help you advance quickly.


Will I learn MySQL or PostgreSQL?

SQL-language can be used with different databases such as MySQL, PostgreSQL, SQLite and many others.

According to the Stack Overflow Developer Survey 2019:

  • MySQL is the most commonly used database (54%)

  • PostgreSQL has taken the second spot (34.3%)

In this course you will be working with the MySQL database management system but the knowledge gained here can be applied to virtually every other database management system.


Will I get a certificate?

At the end of this SQL course, you will get a certificate which can be added to LinkedIn, adding a feather to your cap that employers will surely notice.


What’s more, you have a 30-day money-back guarantee. No questions asked.

So, what are you waiting for? Enroll today. We will help you gain the skills to be successful in the market for many years to come. Your future starts now!


Who this course is for:
  • Web Developers
  • Python Developers
  • Java Developers
  • Business Analysts
  • Marketing Analysts
  • Data Science Specialists
  • Anyone working with databases and data analysis
Course content
Expand all 88 lectures 08:03:34
+ Introduction
5 lectures 15:09
Installation - macOS
04:15
Installation - Windows
03:56
Installation - Ubuntu
03:16
+ Basics - Part 1
16 lectures 01:13:55
Video Quality - IMPORTANT!!!
01:19
Create a Table. INSERT INTO
12:40
Inserting Multiple Rows
02:32
NULL
02:47
Assignment 1 - SOLUTION
04:15
SELECT DISTINCT
04:01
WHERE - Part 1
05:15
WHERE - Part 2
08:21
ORDER BY
05:21
Assignment 2 - TASK
02:01
Assignment 2 - SOLUTION
04:51
UPDATE
06:19
DELETE
05:06
+ Basics - Part 2
12 lectures 58:25
Aggregate Functions + ALTER TABLE
08:42
GROUP BY
08:14
Logical Operators: AND, OR, NOT
07:28
HAVING
03:46
ROLLUP
02:16
LIMIT
04:48
Assignment 3 - TASK
01:35
Assignment 3 - SOLUTION
05:49
ALTER TABLE
06:21
DROP
02:47
Assignment 4 - TASK
01:57
Assignment 4 - SOLUTION
04:42
+ Intermediate - Part 1
16 lectures 01:06:14
Primary and Foreign Key
02:47
Relationship Types (1:1, 1:many, many:many)
08:06
What is JOIN
02:40
INNER JOIN
05:04
Assignment 5 - TASK
02:35
Assignment 5 - SOLUTION
04:20
LEFT JOIN
04:22
Assignment 6 - TASK
01:14
Assignment 6 - SOLUTION
01:42
RIGHT JOIN
05:03
Assignment 7 - TASK
01:16
Assignment 7 - SOLUTION
02:12
FULL JOIN
03:32
CROSS JOIN
06:57
Aliases
04:36
UNION
09:48
+ Intermediate - Part 2
19 lectures 02:07:57
What Are Constraints?
03:01
CONSTRAINTS: NOT NULL
06:24
CONSTRAINTS: UNIQUE. DESCRIBE + AUTO_INCREMENT
09:43
CONSTRAINTS: DEFAULT
04:42
CONSTRAINTS: CHECK
03:10
CONSTRAINTS: PRIMARY KEY & FOREIGN KEY
07:33
Assignment 8 - TASK
02:12
Assignment 8 - SOLUTION
06:54
String Functions - Part 1
11:03
String Functions - Part 2
11:35
Assignment 9 - TASK
01:58
Assignment 9 - SOLUTION
08:33
Numeric Functions
10:23
Date Functions - Part 1
13:19
Date Functions - Part 2
10:25
IFNULL
04:10
IF
03:04
CASE
05:07
COALESCE
04:41
+ Advanced - Part 1
5 lectures 34:05
What Is a Subquery?
03:02
Subquery in the SELECT Clause
06:13
Subquery in the FROM Clause
05:19
Subquery in the WHERE Clause
11:16
Correlated Subqueries
08:15
+ Advanced - Part 2
10 lectures 01:28:25
Views
11:15
Stored Procedures
07:34
Variables - Part 1 - System Variables
06:50
Variables - Part 2 - User-Defined Variables
04:58
Variables - Part 3 - Parameters and Local Variables
02:55
Input and Output Parameters
12:19
User-Defined Functions (2 examples)
13:39
Triggers
13:31
What Are Indexes?
03:54
CREATE, UPDATE and DELETE Indexes
11:30
+ Database Normalization
4 lectures 19:08
What Is a Database Normalization?
05:22
1st Normal Form
06:52
2nd Normal Form
04:07
3rd Normal Form
02:47