SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL
4.6 (812 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.
19,039 students enrolled

SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL

SQL skills are in demand. Learn to master SQL using MySQL. Become a SQL Guru today!
4.6 (812 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.
19,039 students enrolled
Created by John Thompson
Last updated 11/2019
English
English
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 11 hours on-demand video
  • 10 articles
  • 114 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
  • Become a SQL Guru! Be that 'go-to' person!
  • Master SQL to create reports from realistic MySQL databases
  • See how to aggregate and analyze data using SQL functions
  • Create your own database through the power of SQL
  • Understand How to Leverage Database Transactions
  • Tune SQL statements for optimum performance
  • Avoid common mistakes with SQL
Course content
Expand all 166 lectures 11:01:00
+ SQL Beginner to Guru MySQL Edition Introduction
4 lectures 15:56

Learn how you can get the most out of your SQL Beginner to Guru course!

Preview 04:04

Learn about the exclusive Slack community for the course where you can interact with other students learning SQL!

Slack Group for SQL Beginner to Guru MySQL Edition
00:49

In this lecture you get to write your first SQL. See how you can create a database table using SQL, then add data to the table & get information back!

Preview 07:46

In this lecture you see a step by step review of the SQL assignment from the previous lecture.

Preview 03:17
+ Introduction to SQL
11 lectures 01:19:09

Introduction lecture to the section of the course to introduce students to the SQL language.

Preview 01:03

SQL is the language we use to work with data stored in a relational database. In this lecture, we look at what a database is and establish common terminology.

Preview 08:35
History of SQL
13:31
What is a Relational Database Management System?
11:19
History of MySQL
10:41
RDBMS Deployment Architectures
09:25
Flashcards
04:52
Conclusion
00:35
+ Installation of MySQL
9 lectures 28:27
Review of MySQL Installation Options
03:26
MySQL Linux Installation Quick Start
01:11
MySQL Linux Installation Ubuntu
03:21
MySQL Linux Installation CentOS
04:51
+ Connecting to MySQL
9 lectures 30:56
Connecting to MySQL Overview
07:45
MySQL Command Line for OSX and Linux
05:06
MySQL Command Line for Docker
07:47
MySQL Workbench OSX Installation
07:14
MySQL Workbench Linux Installation Quick Start
00:50
MySQL Workbench Linux Installation
00:00
+ Selecting Data from a Single Table
28 lectures 02:08:08

Get the Row Counts of Each Table

Quiz - SQL Row Counts
6 questions
Using the LEFT and RIGHT MySQL Functions
04:02
SQL Select Clause Quiz
7 questions
Introduction to the SQL WHERE Clause
08:44
SQL WHERE Clause with Equals and Not Equals
03:19
Using AND and OR with SQL WHERE Clause
03:52
Using IN and NOT IN with with SQL WHERE Clause
05:03
Dealing with NULL Values in SQL WHERE Clause
03:27
Using Greater Than and Less Than with SQL WHERE Clause
04:00
Using LIKE and NOT LIKE with SQL WHERE Clause
03:49
Using BETWEEN and NOT BETWEEN with SQL WHERE Clause
04:30
Ordering Results with SQL ORDER BY
04:30
Limit Results with SQL LIMIT Clause
06:19
Using SQL to Select DISTINCT Values
02:12
Using SQL Sub-selects with IN in SQL Where Clause
03:12
Assignment - Fix SQL Statements
02:05
Assignment Review
08:44
Conclusion
02:18
+ Grouping and Summarizing Data with SQL
10 lectures 28:38
Using the SQL HAVING Clause
04:17
Using the SQL SUM Function
02:00
Using the SQL Min and Max Functions
05:50
Using the SQL AVG Function
03:55
Assignment - Write SQL Report for Salary Information by Year Excluding Managers
01:58

Quiz on results of SQL Report Assignment

Salary Report Quiz
3 questions
Assignment Review
04:12
Conclusion
00:34
+ Using SQL to Select Data from More Than One Table
16 lectures 01:06:13
Using Table Aliases with SQL Inner Joins
03:38
Limiting Columns Displayed with SQL Inner Joins
03:02
Using a WHERE Clause with SQL Inner Joins
04:33
Assignment - Create Department Employee Report
01:44
Assignment Review - Create Department Employee Report
06:52
Using SQL Natural Joins
03:10
Using SQL Equi-Joins
04:48
Using SQL Union Joins
05:04
Other MySQL Functions
08:55
Using SQL LEFT OUTER JOINS
05:09
Assignment - Write SQL LEFT OUTER JOIN
01:32
Assignment Review - Write SQL LEFT OUTER JOIN
06:13
Conclusion
01:31
+ Using SQL to Insert Data
11 lectures 32:42
Specifying Columns in SQL Inserts
04:05
Assignment - Use SQL to create a record in DEPARTMENTS table
00:45
Assignment Review - Use SQL to create a record in DEPARTMENTS table
05:07
Using a SQL Sub-select with SQL Insert Statements
04:02
SQL Core Concept - Foreign Key Constraints
04:24
Assignment Review - Use SQL Inserts to create a new Employee
06:23
Conclusion
00:59
+ Using SQL to Update Data
11 lectures 24:28
Assignment - Use SQL Update Statement to Change Employee Name
00:48
Assignment Review - Use SQL Update Statement to Change Employee Name
02:22
Assignment - Using SQL Update and Insert to Create a New Salary Record
01:40
Assignment Review - Using SQL Update and Insert to Create a New Salary Record
03:35
Using SQL to drop the employee database
02:49
Assignment - Re-import the employee database
00:43
Assignment - Review re-import employee database
03:26
Conclusion
00:40
+ Using SQL to Delete Data
6 lectures 19:16
Overview of the SQL DELETE statement
02:33
Example of the SQL DELETE Statement
09:42
Assignment - Create, Update, and Delete an Employee record
01:20
Assignment Review - Create, Update, and Delete an Employee Record
04:05
Conclusion
00:36
Requirements
  • Just a computer - Any modern PC, Mac or Linux system will work!
  • Fundamental computer skills are helpful (you understand what files and directories are)
Description

SQL is the programming language used to get data in and out of databases. Relational Databases are extremely popular with companies of all sizes.

Employers are searching for people with SQL skills. Go to any popular jobs site, and search for the keyword 'SQL'. You will see 10's of THOUSANDS of job postings.

Right now these positions are going unfilled - because companies cannot find enough people with SQL skills.

In this course, you will learn how to use SQL using the MySQL relational database - the most popular database in the world.

No previous SQL experience is needed. This course is perfect for beginners. 

In this course, you will:

  • Learn how to install MySQL on your computer.

  • Learn how to install MySQL Workbench on your computer.

  • See how to import the famous MySQL employee database into your MySQL database.

  • Get hands on experience generating SQL reports.

  • Master SQL join statements.

  • Create table joins using database tables with MILLIONS of records!

  • See how easy it is to use SQL to update one record or many records in the database.

  • Learn to use SQL Sub-Selects.

  • Write advanced SQL reports against a ecommerce database.

  • Understand what database transactions are, and the tools you have to control them with MySQL.

  • Use SQL to create tables in your MySQL database.

  • Learn the MySQL syntax to alter existing database tables.

  • Tackle challenging real world like assignments for SQL reporting and database maintenance tasks. 

  • Leverage SQL views for common reports.

Course Extras

  • Slack Community - Join the instructor, teacher's assistants, and other students in a Slack Community exclusive to this course!

  • All Source Code in GitHub - Get access to all source code used in course via GitHub (no experience with GitHub necessary)

  • All Lecture Slides Downloadable as PDFs - Download lecture slides for study and future reference!

Other Databases?

This course is focused on using SQL with the MySQL database. 

SQL is a standard, which which is supported by many other databases. The SQL skills you learn in this course can be applied to other databases such as Postgres, Oracle, and MS SQL Server.

There is a ton of demand for people with SQL skills. In the US, there are over 100,000 job openings for people with SQL skills.

Through this course, you will master SQL. 

Open the door to new opportunities and enroll today!

Who this course is for:
  • Anyone wishing to learn how to use SQL!