Complete Mysql Tutorial + Learning 16 Complex Queries

[LeeAndro]

Last updated 5/2020MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHzLanguage: English | Size: 1.24 GB | Duration: 3h 40m

Learn Mysql by creating an e-commerce project database and creating 16 complex queries

What you'll learn
You will how to work with mysql databases from scratch
You will learn how to use structured query language for creating tables, columns and keys
You will learn how to design a medium sized ecommerce database
You will learn how to create different types of relationships
You will learn how to create and execute 16 complex queries for extracting complex data
Requirements
A computer or laptop
Description
Purpose of this course is to teach you how to use Mysql database management system.​

This course is created for complete bner 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 for 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 queriesIn 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 th 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

Overview

Section 1: Fundamentals

Lecture 1 Introduction & Installation

Lecture 2 Create first database

Lecture 3 Create first table

Lecture 4 Analyse users table

Lecture 5 Add unique key and more columns to users table

Lecture 6 Retrieve data from users table with select command

Lecture 7 Learn how to delete users

Lecture 8 Learn simple and advanced ways of updating tables

Lecture 9 Learn for key and how to connect tables

Lecture 10 Learn how to join tables and get more complex data

Lecture 11 Learn how to use views for more complex queries

Section 2: Creating ecommerce database tables and relationships

Lecture 12 Create ecommerce database and countries table

Lecture 13 Create users table

Lecture 14 Learn one to many relationship

Lecture 15 Create categories table

Lecture 16 Create products table

Lecture 17 Create product_categories table

Lecture 18 Learn many to many relationship

Lecture 19 Create ratings table

Lecture 20 Create orders and order_items tables

Lecture 21 Create profiles table and learn one to one relationship

Section 3: Complex queries

Lecture 22 Prepare database with massive data

Lecture 23 Get total number of users for each country

Lecture 24 Get total number of users and total amount of orders for each country

Lecture 25 Get total number and total amount of orders for each user

Lecture 26 Get total quantity of ordered products for each user

Lecture 27 Get each user ordered products with total sold count and total amount of pur...

Lecture 28 Get each user with ordered categories along with total sold count and total a...

Lecture 29 Get total number of products for each category

Lecture 30 Get total number and total amount of orders for each country

Lecture 31 Get each user's ratings count, ratings total and ratings average

Lecture 32 Get ratings count, ratings total and ratings average given to each product

Lecture 33 Get total number and total amount of orders for each month

Lecture 34 Get ten most popular products

Lecture 35 Get most popular product for each month

Lecture 36 Get ten best seller products

Lecture 37 Get best seller product for each month

Lecture 38 Get best order of each user

Those who want learn about databases with no prior experience,Those who want to learn ecommerce based database structure,Those who are familiar with mysql but want to take their knowledge to higher levels,Those who have basic sql experience but want to learn advanced queries,Bner and intermidiate developers

HomePage:

Https://anonymz.com/https://www.udemy.com/course/complete-mysql-tutorial-learning-16-complex-queries/

DOWNLOAD

https://1dl.net/3zv69pyt8i23/JArmV5rj__Complete_M.part1.rar.html
https://1dl.net/a31n5nfxcq5n/JArmV5rj__Complete_M.part2.rar.html