Complete Mysql tutorial + Learning 16 complex queries
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1 student enrolled

Complete Mysql tutorial + Learning 16 complex queries

Learn Mysql by creating an e-commerce project database and creating 16 complex queries
New
0.0 (0 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
1 student enrolled
Last updated 5/2020
English
English [Auto]
Current price: $11.99 Original price: $19.99 Discount: 40% off
1 day left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Course content
Expand all 38 lectures 03:40:36
+ Fundamentals
11 lectures 01:34:54
Analyse users table
13:02
Add unique key and more columns to users table
12:43
Retrieve data from users table with select command
21:40
Learn how to delete users
02:41
Learn simple and advanced ways of updating tables
07:58
Learn foreign key and how to connect tables
10:19
Learn how to join tables and get more complex data
09:34
Learn how to use views for more complex queries
05:35
+ Creating ecommerce database tables and relationships
10 lectures 56:59
Create ecommerce database and countries table
04:26
Create users table
02:57
Learn one to many relationship
05:26
Create categories table
06:33
Create products table
03:53
Create product_categories table
06:15
Learn many to many relationship
08:51
Create ratings table
04:27
Create orders and order_items tables
07:25
Create profiles table and learn one to one relationship
06:46
+ Complex queries
17 lectures 01:08:43
Prepare database with massive data
04:18
Get total number of users for each country
02:43
Get total number of users and total amount of orders for each country
05:16
Get total number and total amount of orders for each user
03:23
Get total quantity of ordered products for each user
02:32

Since Udemy does not allow more than 80 characters for title of each lecture, the real title is as follows:

Get each user with ordered products along with total sold quantity and total amount of purchases for each product

Get each user ordered products with total sold count and total amount of pur...
04:44

Since Udemy does not allow more than 80 characters for title of each lecture, the real title is as follows:

Get each user with ordered categories along with total sold quantity and total amount of purchases from products of each category

Get each user with ordered categories along with total sold count and total a...
04:37
Get total number of products for each category
01:45
Get total number and total amount of orders for each country
02:18
Get each user's ratings count, ratings total and ratings average
04:30
Get ratings count, ratings total and ratings average given to each product
02:43
Get total number and total amount of orders for each month
01:53
Get ten most popular products
01:44
Get most popular product for each month
11:15
Get ten best seller products
02:43
Get best seller product for each month
10:39
Get best order of each user
01:40
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 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

Who this course is for:
  • 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
  • Beginner and intermidiate developers