MySQL Complete Course

This course will start with you from zero level experience in SQL databases, starting to level up as we are going through the course.

This course will guide you how to install MySQL on a local machine step by step and how to workwith MySQL Workbench (The main GUI that we will be using to work with MySQL Database engine) then you will learn how to create your own cloud databases on the most required cloud services providers in the market…AWS (Amazon Web Services) and Microsoft Azure.

You will learn what is meant by concepts like DBaaS and Amazon Relational Database Service (RDS)

MySQL Complete Course

Section : Introduction to MySQL and Cloud Databases

 

. Introduction

 

 

. What is Relational Databases and MySQL?

 

 

. Relational Databases (Article)

 

 

. Install MySQL Database

 

 

. MySQL Workbench

 

 

. MySQL Database on Microsoft Azure

 

 

. MySQL MySQL Database on AWS

 

 

. Summary

 

Section : Schema, Users and Privileges in MySQL

 

. Create and Drop Databases

 

 

. Create Users

 

 

. Exercise : Create Database and User

 

 

. Summary

 

Section : Database Tables, Primary Keys and Foreign Keys in MySQL

 

. Introduction to The Chapter

 

 

. Database Tables

 

 

. Data Types in MySQL

 

 

. Primary Keys

 

 

. Constraints

 

 

. Exercise : Create Tables : Employees and Jobs

 

 

. Foreign Keys

 

 

. Exercise : Create Tables : Previous Experience

 

 

. Exercise : Import Data (Employees and Cities)

 

 

. Create table using Table Data Import Wizard

 

 

. Exercise : Primary and Foreign Keys For Status Table

 

 

. Export Data out of Database

 

 

. Entity Relationship Diagram (ERD)

 

 

. Summary

 

Section : Basic Select Statements in MySQL

 

. Introduction to The Chapter

 

 

. Select

 

 

. Exercise : Select

 

 

. Where

 

 

. Exercise : Where

 

 

. Order by

 

 

. Exercise : Order By

 

 

. And, Or, Not, Is Null

 

 

. Like and Wildcards

 

 

. Exercise : Like and Wildcards

 

 

. Summary

 

Section : Advanced Select Statements Techniques in MySQL

 

. Introduction to The Chapter

 

 

. Distinct

 

 

. In

 

 

. Between

 

 

. Exercise : Between and in

 

 

. Union Operator

 

 

. Exercise : Union Operator

 

 

. Case Statement

 

 

. Exercise : Case Statement

 

 

. Exists

 

 

. Subquery

 

 

. Exercise : Subquery

 

 

. Summary

 

Section : Aggregate Functions in MySQL

 

. Introduction to The Chapter

 

 

. Aggregate Functions –  and Max

 

 

. Aggregate Functions – Count

 

 

. Exercise : Create Table Budget with Some Queries

 

 

. Aggregate Functions – Avg and Sum

 

 

. Group By

 

 

. Having

 

 

. Exercise : Aggregate Functions

 

 

. Summary

 

Section : Data Manipulation in MySQL

 

 

. Introduction to The Chapter

 

 

. DML and DDL

 

 

. Insert Into Statement

 

 

. Exercise : Insert Into Statement

 

 

. Cloning a Table

 

 

. Delete Statement

 

 

. Update Statement

 

 

. Exercise : Update Statement

 

 

. Exercise : Update Status of Employees

 

 

. Summary

 

 

. The Final Lecture

More than 20000 students on Udemy

  • 4.1 Instructor Rating
  • Best Seller Course
  • Highest Rated Course
  • Courses used by udemy for business clients.

210K students on our platform

  • Unlimited access to all courses.
  • Top Courses for every trending technologies.
  • 4.5 Average ratings for all the courses.
  • Certificate Internationally accepted.

Learn at your pace

Courses Made By Industry Experts

Enhance your career

Enroll NowContact us