The Complete MySQL For Beginners

In this lecture you are going to create your first MySQL database also will learn how to drop databases.

Now you will learn how to create users in MySQL and give them privileges.

Exercise on creating users in MySQL 

​Summary of the section to remind you of the points we discussed in brief​.

Introduction to section three

In this lecture you are going to work with the most important database object which is the tables, think of tables as the heart of relational databases.

Explore more SQL Server datatypes and see some of the differences between the similar ones.

Now it's time to discuss one of the most important concepts in relational database which is primary keys, you are going to learn how to create them in different ways.

Let's dive deeper in creating tables with applying constraints to the columns.

In this lecture we are going to see how to create foreign keys and make relationships between tables.

In this exercise you will be asked to create a new called contains the previous experience of employees in case some employees had experience.

This is an interesting lecture we are going to fill our tables with data using Import wizard feature in MySQL workbench.

We can use the Import wizard to create tables from scratch and fill with data without typing any SQL script.

In this exercise you will be asked to create both primary and foreign keys for status table. 

In this video we are going see how to export data from MySQL.

We have an interesting lecture, we are going to see how to generate ERD and visually view database objects and track relationships 

Summary of the section to remind you of the points we discussed in brief

Introduction to section four.

​Select statement is the most common used statement in MySQL, it's used to retrieve data from database, let's figure out how to use it efficiently.​ 

Small exercise to practice what you have learned about the select statement. 

Where clause is usually used with select statement to filter data based on conditions as we are going to see​.

In this exercise you are going to select some data based on some conditions.

Order by statement is used to order the records based on one or multiple columns 

Exercise about order by

Let's see how to work with operators like and, or, not and is null and how can you combine them in one where clause.

Like is very powerful keyword in MySQL it enable you to search for text patterns in your data as we are going to see.

In this exercise you will be asked to create a pattern to display set of records in database

Summary of the section to remind you of the points we discussed in brief

Introduction to section five

Distinct is another powerful keyword used to select only the distinct values only in a table, let's see how to use it

In is a small word but it a save effort saver when typing queries as we are going to see in this lecture

Between also is a very powerful keyword it is used to perform a range condition between two values, let's see how to use it

Time for an exercise about in and between

Union is used to combine two different queries into one, sounds interesting...let's see how to use it

Exercise to test your knowledge of the union operators 

Another powerful statement we are going to learn in this lecture which is ....case statement

Exercise testing your case statement skills.

Exists is a very unique keyword we can use in MySQL

Subquery, one of the very powerful features of MySQL, learn how to make dynamic conditions using subquery 

Time for an exercise about the subquery 

Summary of the section to remind you of the points we discussed in brief

Introduction to section six

In this lecture we are going to see the powerful aggregate functions, starting withe minimum and maximum functions, let's see how to use them 

Continue our lectures about the aggregate functions, this lecture we will learn how to use a new function...count 

Yet with another aggregate functions, we have two more, average and summation.

​Group by is a statement used with aggregate functions, which will take your querying skills to another level​. 

having also is used with group by and aggregate functions, it's used like the where clause, but there is a difference, let's see what is the difference 

Exercise about the aggregate functions to help you practice.

Summary of the section to remind you of the points we discussed in brief

Introduction to section seven 

In this lecture we are going to learn what is meant by DML and DDL 

Finally let's see how to write the insert statement in MySQL

Exercise about the Insert Statement 

Cloning a table with MySQL is very easy task and very powerful let us see how to do that

Delete statement used to delete one or more records from a tables but with some rules, let's see how to do it 

Update statement also is used to update one or multiple columns based on conditions, let's see how to write it 

Another exercise about the update statement to make sure you understand it correctly 

Summary of the section to remind you of the points we discussed in brief