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

Video Description

SQL skills are in demand. Learn to master SQL using MySQL. Become a SQL Guru today!

About This Video

  • Learn to aggregate and analyze data using SQL functions
  • Get up to speed with SQL using MySQL

In Detail

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 also constantly searching for people with SQL skills, which is ideal if you’re looking to pursue a career in this domain.

In this course, you will learn how to use SQL using the MySQL relational database - one of the most popular databases in the world. You’ll start by installing MySQL workbench on your computer. Next, you’ll understand how to import the famous MySQL employee database into your MySQL database. Gradually, you’ll get hands-on with generating SQL reports, before going on to exploring all about SQL join statements. In addition to this, you’ll create table joins using database tables with millions of records. You’ll discover how easy it is to use SQL to update one record or multiple records in the database. As you progress, you’ll delve into using SQL sub-selects and writing advanced SQL reports against an e-commerce database.

Later, you’ll focus on what database transactions are, and the tools you have to control them with MySQL. The course will then take you through using SQL to create tables in your MySQL database. You’ll also learn the MySQL syntax to alter existing database tables. Finally, you’ll tackle challenging real-world-style assignments for SQL reporting and database maintenance tasks, along with using SQL views for common reports.

By the end of this course, you will be well-versed with SQL and have the skills to use it effectively for your database management needs.

Publisher Resources

Download Example Code

Table of Contents

  1. Chapter 1 : SQL Beginner to Guru MySQL Edition Introduction
    1. Getting the Most out of Your SQL Course 00:03:07
    2. SQL - Let's write our first SQL! 00:07:47
    3. SQL Fiddle Assignment Review 00:03:18
  2. Chapter 2 : Introduction to SQL
    1. Introduction to SQL 00:01:04
    2. What is a Database? 00:08:36
    3. Relational Database Principles 00:13:05
    4. Assignment: Create Tables and Insert Data 00:02:28
    5. Assignment Review: Create Tables and Insert Data 00:03:28
    6. History of SQL 00:13:27
    7. What is a Relational Database Management System? 00:11:20
    8. History of MySQL 00:10:33
    9. RDBMS Deployment Architectures 00:09:26
    10. Flashcards 00:04:52
    11. Conclusion 00:00:36
  3. Chapter 3 : Installation of MySQL
    1. Introduction 00:01:45
    2. Review of MySQL Installation Options 00:03:26
    3. MySQL Windows 10 Installation 00:06:07
    4. MySQL OSX Installation 00:06:06
    5. MySQL Linux Installation Ubuntu 00:03:22
    6. MySQL Linux Installation CentOS 00:04:52
  4. Chapter 4 : Connecting to MySQL
    1. Introduction 00:01:17
    2. Connecting to MySQL Overview 00:07:46
    3. MySQL Command Line for OSX and Linux 00:05:07
    4. MySQL Command Line for Docker 00:07:48
    5. MySQL Workbench OSX Installation 00:07:14
  5. Chapter 5 : Selecting Data from a Single Table
    1. Introduction 00:02:52
    2. Importing the MySQL Employee Database 00:06:44
    3. Assignment use SQL to get Row Counts 00:00:48
    4. Assignment Review - Use SQL to get Row Counts 00:02:23
    5. Review of the SQL Select Statement 00:05:14
    6. Selecting Specific Columns from Tables 00:01:56
    7. Using Aliases to Name Columns 00:02:54
    8. Using the SQL CONCAT Function to Join Columns 00:02:27
    9. SQL Arithmetic Operators 00:02:27
    10. Using SQL Arithmetic Operators in Selecting Data 00:07:14
    11. SQL Data Types 00:16:25
    12. Formatting Date Values with MySQL 00:06:46
    13. Using the LEFT and RIGHT MySQL Functions 00:04:02
    14. Introduction to the SQL WHERE Clause 00:08:44
    15. SQL WHERE Clause with Equals and Not Equals 00:03:20
    16. Using AND and OR with SQL WHERE Clause 00:03:52
    17. Using IN and NOT IN with with SQL WHERE Clause 00:05:04
    18. Dealing with NULL Values in SQL WHERE Clause 00:03:27
    19. Using Greater Than and Less Than with SQL WHERE Clause 00:04:00
    20. Using LIKE and NOT LIKE with SQL WHERE Clause 00:03:49
    21. Using BETWEEN and NOT BETWEEN with SQL WHERE Clause 00:04:30
    22. Ordering Results with SQL ORDER BY 00:04:30
    23. Limit Results with SQL LIMIT Clause 00:06:19
    24. Using SQL to Select DISTINCT Values 00:02:12
    25. Using SQL Sub-selects with IN in SQL Where Clause 00:03:13
    26. Assignment - Fix SQL Statements 00:02:05
    27. Assignment Review 00:08:44
    28. Conclusion 00:01:15
  6. Chapter 6 : Grouping and Summarizing Data with SQL
    1. Introduction 00:01:01
    2. Using the SQL GROUP By clause 00:02:49
    3. MySQL Aggregate Functions 00:02:04
    4. Using the SQL HAVING Clause 00:04:18
    5. Using the SQL SUM Function 00:02:01
    6. Using the SQL Min and Max Functions 00:05:51
    7. Using the SQL AVG Function 00:03:55
    8. Assignment - Write SQL Report for Salary Information by Year Excluding Managers 00:01:59
    9. Assignment Review 00:04:12
    10. Conclusion 00:00:35
  7. Chapter 7 : Using SQL to Select Data from More Than One Table
    1. Introduction 00:01:16
    2. Overview of SQL Table Joins 00:05:14
    3. Introduction to SQL Inner Joins 00:03:34
    4. Using Table Aliases with SQL Inner Joins 00:03:39
    5. Limiting Columns Displayed with SQL Inner Joins 00:03:03
    6. Using a WHERE Clause with SQL Inner Joins 00:04:34
    7. Assignment - Create Department Employee Report 00:01:45
    8. Assignment Review - Create Department Employee Report 00:06:52
    9. Using SQL Natural Joins 00:03:10
    10. Using SQL Equi-Joins 00:04:49
    11. Using SQL Union Joins 00:05:05
    12. Other MySQL Functions 00:08:55
    13. Using SQL LEFT OUTER JOINS 00:05:10
    14. Assignment - Write SQL LEFT OUTER JOIN 00:01:32
    15. Assignment Review - Write SQL LEFT OUTER JOIN 00:06:13
    16. Conclusion 00:01:31
  8. Chapter 8 : Using SQL to Insert Data
    1. Introduction 00:00:45
    2. Overview of the SQL Insert Statement 00:02:45
    3. Example SQL Insert Statement 00:02:38
    4. Specifying Columns in SQL Inserts 00:04:05
    5. Assignment - Use SQL to create a record in DEPARTMENTS table 00:00:46
    6. Assignment Review - Use SQL to create a record in DEPARTMENTS table 00:05:08
    7. Using a SQL Sub-select with SQL Insert Statements 00:04:03
    8. SQL Core Concept - Foreign Key Constraints 00:04:24
    9. Assignment - Use SQL Inserts to create a new Employee 00:00:51
    10. Assignment Review - Use SQL Inserts to create a new Employee 00:06:23
    11. Conclusion 00:00:59
  9. Chapter 9 : Using SQL to Update Data
    1. Introduction 00:01:23
    2. Overview of the SQL Update Statement 00:03:56
    3. Example SQL Update Statement 00:03:08
    4. Assignment - Use SQL Update Statement to Change Employee Name 00:00:49
    5. Assignment Review - Use SQL Update Statement to Change Employee Name 00:02:22
    6. Assignment - Using SQL Update and Insert to Create a New Salary Record 00:01:41
    7. Assignment Review - Using SQL Update and Insert to Create a New Salary Record 00:03:35
    8. Using SQL to drop the employee database 00:02:50
    9. Assignment - Re-import the employee database 00:00:44
    10. Assignment - Review re-import employee database 00:03:26
    11. Conclusion 00:00:40
  10. Chapter 10 : Using SQL to Delete Data
    1. Introduction 00:01:01
    2. Overview of the SQL DELETE statement 00:02:34
    3. Example of the SQL DELETE Statement 00:09:42
    4. Assignment - Create, Update, and Delete an Employee record 00:01:21
    5. Assignment Review - Create, Update, and Delete an Employee Record 00:04:05
    6. Conclusion 00:00:37
  11. Chapter 11 : Using SQL Transactions
    1. Introduction 00:01:33
    2. Introduction to SQL Transactions 00:10:15
    3. Demonstration of Database Transactions 00:06:10
    4. Assignment - Create Employee Using SQL Transactions 00:01:21
    5. Assignment Review - Create Employee Using SQL Transactions 00:04:41
    6. Demonstration of Database Locks 00:05:16
    7. User Defined Variables in MySQL 00:05:26
    8. Demonstration of Lost SQL Updates 00:05:19
    9. Using SQL Select for Update 00:04:58
    10. Conclusion 00:01:32
  12. Chapter 12 : Advanced SQL Reporting
    1. Introduction 00:02:57
    2. Overview of the Northwind Database 00:03:00
    3. Assignment - Import the Northwind Database 00:03:40
    4. Assignment Review - Import the Northwind Database 00:04:01
    5. Assignment - Create Orders Report 00:02:12
    6. Assignment Review - Create Orders Report 00:10:02
    7. Assignment - Monthly Sales Report by State 00:00:59
    8. Assignment Review - Monthly Sales Report by State 00:07:23
    9. Assignment - Create Monthly Profit Report by Item 00:01:06
    10. Assignment Review - Create Monthly Profit Report by Item 00:10:37
    11. Assignment - Create a Weekly Sales Report by Employee 00:02:07
    12. Assignment Review - Create a Weekly Sales Report by Employee 00:11:09
    13. Weekly Sales Report by Employee Revisited 00:04:15
    14. Conclusion 00:00:48
  13. Chapter 13 : Introduction to DDL Statements - Creating SQL Views
    1. Introduction to Views 00:00:50
    2. Demonstration using SQL DDL Creating a Database View 00:02:54
    3. Assignment - Create Orders View 00:01:53
    4. Assignment Review - Create Orders View 00:04:48
    5. Materialized Views in MySQL 00:02:34
  14. Chapter 14 : Using SQL to Create MySQL Database Tables
    1. Overview of SQL Create Table Syntax 00:04:34
    2. Creating a Table with SQL Select 00:02:36
    3. SQL Truncate Table Command 00:02:51
    4. SQL Drop Table Command 00:03:27
    5. SQL Create Table Example 00:04:48
    6. SQL Create Table Example with Primary Key 00:03:44
    7. SQL Create Table with Auto-Increment Primary Key 00:05:15
    8. SQL Create Table with Foreign Keys 00:04:19
    9. SQL Create Table with Indexes 00:03:58
    10. SQL Create Table with Unique Indexes 00:04:32
    11. Assignment - SQL Create Table 00:02:49
    12. Assignment Review - SQL Create Table 00:09:23
  15. Chapter 15 : Using SQL to Update Tables
    1. Introduction to the SQL Alter Table Command 00:03:48
    2. Using SQL Alter Table Command to Add and Remove a Column 00:02:57
    3. Using SQL Alter Table to Reorder Columns 00:03:31
    4. Using SQL Alter Table Command to Add or Remove an Index 00:04:12
    5. Using SQL Alter Table Command to Add or Remove a Foreign Key Constraint 00:04:05
    6. Assignment - Add ASIN, UPC, and EAN to Book Table using SQL Alter Table Command 00:02:17
    7. Assignment Review - Add ASIN, UPC, EAN to Book Table using SQL Alter Table Cmd 00:03:11
    8. Using SQL Alter Table for MySQL Generated Columns 00:05:25

Product Information

  • Title: SQL Beginner to Guru: MySQL Edition - Master SQL with MySQL
  • Author(s): John Thompson
  • Release date: May 2019
  • Publisher(s): Packt Publishing
  • ISBN: 9781838982829