MySQL Complete Course
-
Duration – 18 hours

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)
lIFETIME ACCESS
INR 9999
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
300+ Courses
After your course completion, we provide course completion certificate as well.
Lifetime Access
All courses are for lifetime access.
Priority Support
All queries are answered 24/7.
What People Are Saying

Abhilash -
A very good match. i am enjoying every bit.

Sonal-
Experience was quite good and it was very useful and well elaborated course.

Karan-
I FEEL AS IF I AM ATTENDING A WORLD CLASS TRAINING AND THE LECTURER HAS BEEN AWESOME!

Gilbert-
I find that the explanation is good and also understandable.

Seyed-
Really helpful, recommended to everyone to grow up your future skills for next level especially in this competitive market.

Mayur-
I really like this course, it was a good match for me :))

Mahesh-
Standard process and hands on covered nicely.

Emily-
Perfect, with complete hands on. Well structured and nicely covered.

Kevin-
Great Content, nice and up to the mark course.

Mayuresh-
Great courses. Beginner friendly and the explanations are clear and very easy to understand.

Saket-
Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Tushar-
A very detailed explanation and quite handy tips and tricks! loved it

Sourabh-
Excellent lecture, pace of the instructor is very good, easy to understand

Rishi-
Instructor showed multiple ways of using a concept and how to solve the problem. Excellent course and lecture by the instructor.

Mahima-
This Courses is really useful for my career and surely i will recommend other to fulfill their career goals.

 Mauricio Roldan -
A pesar de no dominar perfectamente el idioma, se entiende bien.

Emile-
Yes lessons are very good. Not so fast, well explained

Kishore-
Worth course for the beginner to invest their time to learn this demanding skills.
