Course curriculum

    1. Course Overview

    2. Course Slides PDF Download

    3. Databases and SQL

    4. Tables and Keys

    5. Entity Relationship (ER) Diagrams

    6. Installing mySQL for Windows

    7. Installing mySQL for Mac

    8. MySQL Workbench Overview

    1. SQL Data Types

    2. Creating Databases

    3. Creating Tables

    4. Adding Data

    5. Contraints and Defaults

    6. Updating and Deleting Tables

    1. Importing a Database

    2. SELECT statement

    3. SELECT AS

    4. SELECT WHERE

    5. Practice Exercises

    6. DISTINCT & BETWEEN

    7. LIKE Operator

    8. REGEXP

    9. Practice Exercises

    10. Saving Your SQL Scripts

    11. Leave us a review on Google!

    1. Aggregation Functions

    2. GROUP BY

    3. HAVING

    4. Practice Exercises

    5. Window Functions Theory

    6. Window Functions Practice

    7. Rank Functions

    8. Lag and Lead

    9. Practice Exercises

    1. Types of JOIN

    2. INNER JOIN

    3. LEFT & RIGHT JOIN

    4. Multiple Tables

    5. Multiple Databases

    6. Practice Exercises

    7. UNIONS

    1. String Functions

    2. Date & Time Functions

    3. IF Function

    4. CASE Statement

    5. CAST Function

    6. Practice Exercises

    7. Subqueries Part 1

    8. Subqueries Part 2

    9. MySQL Coding Order Cheat Sheet

About this course

  • $189.00
  • 75 lessons
  • 5.5 hours of video content

Discover your potential, starting today

Enroll today