Complete Mysql tutorial + Learning 16 complex queries

Purpose of this course is to teach you  how to use Mysql database management system. This course is created

for complete beginner developers but as you progress you will become familiar with complicated matters,

increase your experience and automatically enhance your level of expertise and become proficient in using Mysql

and dealing with large databases. This course is made up of three sections.

In section one:

You will become familiar with Mysql database and get a simple and functional definition of database.

You will learn how to set up environment to start work with Mysql

You will create first database and table

You will learn how to analyze structure of created table

You will add unique key and columns to database table

You will learn how to retrieve simple data form database table

You will learn how to delete data from database table

You will learn how to use simple and complex update command to update your tables

You will learn concept of foreign key and how to establish connection between tables

You will learn how to join tables and get more complex data

You will learn about views and how to use them as sub queries in complex queries

In section two:

You will become familiar with a medium sized e-commerce application database

You will learn different relationships which can be created between database tables

You will create e-commerce database tables and execute simple queries on them

In section three:

You will prepare your e-commerce database with massive data

You will learn and execute 16 different and complex queries on database tables