Complete MySQL For Beginners

Welcome to the Complete MySQL For Beginners Course, The ultimate practical guide to master MySQL Server for developers.

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 even 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)

After you learn the basic concepts of the MySQL and relational databases and how to install it on a machine and on the cloud, now it will be about time to dive deeper into the world of SQL databases and learn :

• How create databases and schemas.

• How create tables and views.

• Understand all the big concepts like DML, DDL, T-SQL and DBaaS.

• You will learn how to create users to access your database based on specific permissions you gave them.

• How to create different constraints.

• Create primary keys, foreign keys and composite keys.

• How to export and import a bulk of data in and out of your database.

• How to retrieve data from your database using select statement.

•  How to filter data using where clause.

• How to use aggregate functions (Sum, Min, Max..etc).

• Learn how to use group by and having with aggregate functions.

• How to use case statement.

• How to use the keywords like between, in, distinct and percent.

• Understand how to create subqueries.

• How to manipulate data using Insert, update, delete statements.

• How to use joins to link two tables or more together.

• How to design complex database relations.

You will be designing a small human resources database from scratch, and we will also work with the  Sakila database.

You will have the chances to create joins in two different ways, first using SQL script and you will learn how to do this step by step, and visually using the management studio features which allows you to create joins much faster and easier.

Give your CV a huge boost by mastering the MySQL with the Complete MySQL for Beginners course, do not hesitate joining this class.

• Introduction to The Course
• What is Relational Databases and MySQL
• Install MySQL
• MySQL Workbench
• MySQL Database on Microsoft Azure
• MySQL MySQL Database on AWS
• Create and Drop Databases
• Create Users
• Exercise Create Database and User
• Database Tables
• Data Types
• Primary Keys
• Constraints
• Exercise Create Tables Employees and Jobs
• Foreign Keys
• Exercise Create Tables Previous Experience
• Create table using Table Data Import Wizard
• Import Data Into Database
• Exercise Import Data (Employees and Cities)
• Exercise Primary and Foreign Keys For Status Table
• Export Data out of Database
• Entity Relationship Diagram (ERD)
• Select Statement
• Exercise Select Statement
• Where
• Exercise Where
• Order by
• Exercise Order By
• Exercise And or
• Like and Wildcards
• Exercise Like and Wildcards
• Distinct
• In
• Between
• Exercise Between and In
• Union
• Case Statement
• Exercise CASE Statement
• Exercise Union Operator
• EXISTS
• Subquery
• Exercise Subquery
• Aggregate Functions Min and Max
• Aggregate Functions Count
• Exercise Create Table Budget with Some Queries
• Aggregate Functions Avg and Sum
• Group By
• Having
• Exercise Aggregate Functions
• 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
• Final Lecture