Installation Introduction

Installation How to fix Cannot Connect to MySQL Server MacOS

Installation Installation of MySQL on MacOS

Installation How to fix Cannot Connect to MySQL Server Windows

Installation Installation of MySQL Server and Workbench on Windows

Database Creating a Database

Database Database as a house Introduction

Database Creating a Database with IF NOT EXISTS

Database How to use a Database

Database Finding Out the Currently Selected Database

Database Checking If a Database Exists

Database Deleting a Database

Database Deleting a Database If It Exists

Resources How to Run the Resources

CRUD Understanding CRUD

Data Types Introduction

Introduction to SQL

Select Understanding Select Statement

Table Introduction and Creating Basic Table in MySQL

Database vs Table In SQL Laymans Explanation Challenge Solution

Creating A Database Challenge Solution 1

IF NOT EXISTS with CREATE DATABASE Challenge Solution 2

How To Check For Existing Databases Challenge Solution 3

How To Delete A Database Challenges Solution 4

Using A Database Challenge Solution 5

How To Check For The Selected Database in Use Challenge Solution 6

SELECT Understanding Select for Absolute beginners

Integer Types INTEGER or INT SMALLINT TINYINT MEDIUMINT BIGINT

Clients Integer Data Types Requirement Scenario

Boolean Type tinyint1

FixedPoint Types DECIMAL NUMERIC

Clients FixedPoint Data Types Requirement Scenario

Clients FloatingPoint Data Types Requirement Scenario

Introduction to MySQL Numeric Data Types

FloatingPoint Types FLOAT DOUBLE

BitValue Type BIT

Clients Bit Data Types Requirement Scenario

Introduction to MySQL String Data Types

The CHAR and VARCHAR Types

Clients BINARY and VARBINARY Types Requirement Scenario

The BINARY and VARBINARY Types

Clients BLOB and TEXT Types Requirement Scenario

ENUM Type

The BLOB and TEXT Types

SET Type

Clients SET Types Requirement Scenario

Clients ENUM Types Requirement Scenario

Introduction to MySQL Date Time

Clients Date and Time Types Requirement Scenario

DATE TIME Types

Introduction to MySQL Spatial Types

Spatial Data Types

Clients Spatial Types Requirement Scenario

Type of Data in MySQL

MySQL Numeric Types

DECIMAL NUMERIC Fixed Point Data Types in MySQL Approximate Numeric I

REAL FLOAT DOUBLE Floating Point Data Type in MySQL

DECIMAL NUMERIC Fixed Point Data Types in MySQL Approximate Numeric II

TINYINT SMALLINT MEDIUMINT INTEGER BIGINT Exact Numeric Data Types in MySQL

CHAR vs VARCHAR String Data Types in MySQL

BINARY VARBINARY String Data Types in MySQL

BLOB TEXT String Data Types in MySQL

ENUM String Data Types in MySQL

SET String Data Types in MySQL

DATE TIME DATETIME TIMESTAMP YEAR Date and Time Data Types in MySQL

Understanding JSON Data Type in MySQL

Clients JSON Types Requirement Scenario

MySQL Auto Increment

MySQL Null and NOT Null

WHERE A brief Intro

MySQL Default

SQL Basic Insert

SQL Inserting Multiple Rows at Once

SQL Inserting with a Set Clause

SQL Inserting Data from Another Table

Inserting A Single Line of Data Into Table 1st Method

Inserting A Single Line of Data Into Table 2nd Method

Inserting Multiple Lines of Data Into Table 1st Method

Inserting Multiple Lines of Data Into Table 3rd Method

Inserting Multiple Lines of Data Into Table 2nd Method

Inserting Null Value and Empty White Space Into Table

Introductions to Keys in SQL

Composite Compound Key in SQL

Primary Key in SQL

Candidate and Alternate Keys in SQL

Surrogate Key in SQL

Natural Key in SQL

Super Key in SQL

Unique Key in SQL

Foreign Key in SQL

Candidate Key In SQL

Surrogate Key In SQL

Primary Key Alternative Key In SQL

Foreign Key In SQL

Alter Table Intro Adding a New Column

Alter Table Dropping an Existing Column

Alter Table Modify Column Type and Size

Alter Table Drop Primary Key

Alter Table Add Primary Key

Alter Table Add Unique Constraint

Alter Table Rename Column

Alter Table Rename Table

Alter Table Add Foreign Key

Alter Table Add Default to Column

Alter Table Drop Default from a Column

Alter Table Drop Foreign Key

Introduction to delete Deleting Specific Records

Delete multiple records

Delete all records

Deleting a Table

Truncate Table

Delete Cascade

Assigning A PRIMARY KEY Three Methods Challenge Solution 1

Adding A PRIMARY KEY To Existing Column Challenge Solution 3

Deleting A PRIMARY KEY Challenge Solution 2

Assigning A FOREIGN KEY Challenge Solution 4

Adding A FOREIGN KEY To Existing Table Challenge Solution 6

Assigning A CONSTRAINT NAME To A FOREIGN KEY Challenge Solution 5

Challenge Solution 7 CONSTRAINT NAME FOREIGN KEY To Existing Table

Deleting A REFERENCED Parent Table Challenge Solution 8

Deleting A Column From A Table Challenge Solution 9

Deleting A REFERENCED or CONSTRAINT Column Challenge Solution 10

Manager Demands for All Customers Detail Challenge Solution 3

Select All Rows and Columns Challenge Solution 1

Select Specific Columns Challenge Solution 2

Specific Customers Details Challenge Solution 4

CONCAT Introduction

CONCAT Challenge Solution 1

CONCAT Challenge Solution 2

ALIAS AS Introduction

Alias Challenge Solution

ORDER BY Introduction

ORDER BY ASC Challenge Solution 1

ORDER BY DESC Challenge Solution 2

ORDER BY DESC CONCAT Challenge Solution 3

ORDER BY ASC Challenge Solution 4

LIMIT Challenge Solution 1

LIMIT Challenge Solution 2

LIMIT Challenge Solution 3

SINGLE MULTILINE COMMENTS in SQLMySQL

Introduction to WHERE

Specific Customer filter Challenge Solution 2

UK Customers filter Challenge Solution 1

Specific Employee filter Challenge Solution 3

Product with specific Price filter Challenge Solution 4

Getting a list of Sales Representatives Challenge Solution 5

Products Supplied by a Specific Customer Challenge Solution 7

None Spanish Customers using Challenge Solution 6

All Suppliers Except using NOT Challenge Solution 8

Products above certain Price Greater Than Challenge Solution 9

Unit In Stock Less Than Challenge Solution 11

Products Below Certain Price Less Than Challenge Solution 10

Minimum Wages Less Than Challenge Solution 12

Gifts for Customers Greater Than Challenge Solution 13

San Francisco Customers AND Challenge Solution 15

Units In Stock Less Than Challenge Solution 14

Specific Mexico Customers AND Challenge Solution 16

Brazil and Venezuela Customers OR Challenge Solution 18

None USA and UK Customers NOT Challenge Solution 17

Range of Suppliers BETWEEN Challenges Solution 19

Suppliers Combining OR Challenge Solution 20

NOT BETWEEN Challenge Solution 22

Range of Suppliers using BETWEEN Challenge Solution 21

Product List BETWEEN CONCAT FORMAT ORDER BY Challenge Solution 24

Customers in Paris Nantes France Challenge Solution 23

Employees Report to 2 IS NOT NULL Challenge Solution 26

NULL values IS NULL IS NOT NULL Challenge Solution 25

IN and WHERE Challenge Solution 27

NOT IN UK Germany France Customers Challenge Solution 28

ORDER BY with RAND Challenge Solution

Creating Index Along a Table

Introduction to MySQL Index

Creating Index on Existing Column

Understanding Primary or Clustered Index

Unique Key vs Index

Key vs Index

Verifying Index

Deleting Index

Confirming the Power of Index

MySQL Wildcard Customers Start With P Challenges Solution 1

Introduction to MySQL Wildcards

MySQL Wildcard Customers In Restaurant Business Challenges Solution 4

MySQL Wildcard Employees In Sales Challenges Solution 2

MySQL Wildcard Phone Number Pattern Challenges Solution 3

MySQL Wildcard NOT LIKE Challenges Solution 5

Updating a Single Value in a Table

Updating Multiple Values in a Table

Using UPDATE with REPLACE

What is Storage Engine Lets Digress a little

DISTINCT ORDER BY DESC WHERE IS NOT Challenge Solution

DISTINCT How it works

Data Cleaning Format Challenge Solution

How Format Function Works

GROUP BY SUMMINAVG CONCAT FORMAT Challenge Solution 2

MIN MAX AVG SUM GROUP BY Challenge Solution 1

Region Count GROUP BY COUNT Challenge Solution 3

GROUP BY True Meaning

Row Unique Value Count GROUP BY COUNT Challenge Solution 4

Product Sold SUM GROUP BY Challenge Solution 6

Most Hardworking Employee Challenge Solution 7

Product Count COUNT GROUP BY ORDER BY Challenge Solution 5

Type of JOIN in SQL

Purpose of JOIN in SQL

Understanding INNER JOIN

Understanding LEFT JOIN

Understanding RIGHT JOIN

Understanding FULL JOIN

Overview of Tables Code for JOIN Demonstration

LEFT JOIN DEEP DIVE

INNER JOIN DEEP DIVE

RIGHT JOIN DEEP DIVE

More On RIGHT JOIN and LEFT JOIN with Shipper Orders tables

TableColumn vs Column only

ON vs WHERE in INNER LEFT RIGHT JOIN

ON vs USING in SQL JOIN Statement

JOIN for Orders HandledManaged By Employee Challenge Solution 1

JOIN for Customers and Shippers Challenge Solution 3

Using JOIN for Products Their Suppliers Challenge Solution 2

JOIN Many Tables Customers and Names of Shipper Challenge Solution 4

Simplifying the Schema used for JOIN in the following sections

Two Tables Join Challenge and Solution 2

Two Tables Join Challenge and Solution 3

Two Tables Join Challenge and Solution 4

Two Tables Join Challenge and Solution 5

SelfJoin One Table Join Challenge and Solution 1

Three Table Joins Challenge and Solution 6

Three Tables Join Challenge and Solution 7

Four Tables Join Challenge and Solution 8

Five Tables Join Challenge and Solution 9

Five Tables Join Challenge and Solution 10

Six Tables Join Challenge and Solution 11

Seven Tables Join Challenge and Solution 12

Eight Tables Join Challenge and Solution 13

Nine Tables Join Challenge and Solution 14

Ten Tables Join Challenge and Solution For Demonstration Purpose

Offset Limit First Three Highest Salary Challenge Solution 3

Offset Limit Challenge Solution 1

Offset Limit Third Highest Purchase Challenge Solution 2

Offset Limit Fourth to the Lowest Salary Challenge Solution 4

OFFSET LIMIT First and Third Bestselling Products Challenge Solution 5

CASE with IS NULL

CASE FOR TYPE OF CUSTOMERS

Understanding MySQL CASE

CAST FROM STRING to DATE

CAST FROM INTEGER to CHAR Challenge Solution 2

CAST FROM STRING to DATE TIME Challenge Solution 3

CAST FROM STRING to TIME Challenge Solution 4

CAST Order Date Without time Challenge Solution 5

CAST FROM DATE to DATETIME Challenge Solution 6

Aggregate Function with Subqueries

Introduction to subqueries

Nested Subquery Challenge Solution 1

Many Subqueries Challenges Solution 2

Exists Operator

Subquery Exists Challenge Solution 1

Subquery Exists Challenge Solution 2

SPACE FUNCTION Challenge Solution 1

SPACE FUNCTION Challenge Solution 2

REPEAT FUNCTION Challenge Solution 3

REPEAT FUNCTION Challenge Solution 4

REPLACE FUNCTION Challenge Solution 5

REPLACE FUNCTION Challenge Solution 6

REPLACE FUNCTION Challenge Solution 7

REVERSE FUNCTION Challenge Solution 8

REVERSE FUNCTION Challenge Solution 9

LEFT FUNCTION Challenge Solution 10

RIGHT FUNCTION Challenge Solution 12

LEFT FUNCTION Challenge Solution 11

RIGHT FUNCTION Challenge Solution 13

RPAD FUNCTION Challenge Solution 14

LPAD FUNCTION Challenge Solution 16

LPAD FUNCTION Challenge Solution 17

RPAD FUNCTION Challenge Solution 15

LPAD FUNCTION Challenge Solution 18

POSITION LOCATION FUNCTIONS Challenge Solution 19

POSITION LOCATION FUNCTIONS Challenge Solution 20

SUBSTRINGSUBSTR FUNCTION Challenge Solution 21

SUBSTRINGSUBSTR FUNCTION Challenge Solution 22

SUBSTRINGSUBSTR FUNCTION Challenge Solution 23

SUBSTRINGSUBSTR FUNCTION Challenge Solution 24

SUBSTRINGINDEX FUNCTION Challenge Solution 25

SUBSTRINGINDEX FUNCTION Challenge Solution 26

SUBSTRINGINDEX FUNCTION Challenge Solution 27

SUBSTRINGINDEX FUNCTION Challenge Solution 28

SUBSTRINGINDEX FUNCTION Challenge Solution 29

MID FUNCTION Challenge Solution 30

MID FUNCTION Challenge Solution 31

INSERT FUNCTION Challenge Solution 32

INSERT FUNCTION Challenge Solution 33

INSTR FUNCTION Challenge Solution 35

INSTR FUNCTION Challenge Solution 34

LCASE LOWER FUNCTION Challenge Solution 35

LCASE LOWER FUNCTION Challenge Solution 36

UCASE UPPER FUNCTION Challenge Solution 38

UCASE UPPER FUNCTION Challenge Solution 37

UCASE UPPER FUNCTION Challenge Solution 39

LENGTH FUNCTION Challenge Solution 40

LENGTH FUNCTION Challenge Solution 41

LTRIM FUNCTION Challenge Solution 42

LTRIM FUNCTION Challenge Solution 43

RTRIM FUNCTION Challenge Solution 44

TRIM FUNCTION Challenge Solution 45

RTRIM FUNCTION Challenge Solution 45

TRIM FUNCTION Challenge Solution 46

Difference Between Nested and Correlated Subqueries

Understanding MySQL Session

Table Locking Intro

Table Locking Demonstration

Brief Introduction to SQL Transaction

TRANSACTION components START BEGIN BEGIN WORK COMMIT ROLLBACK SET

NOT USING TRANSACTION

ROLLBACK

TRANSACTION By Example

Meaning of VIEW

VIEW for Sales Manager Challenge Solution 1

VIEW for Employees hired in 1994 Challenge Solution 2

Updating VIEW Challenge Solution 3

A Mistake In VIEW Challenge Solution 4

Deleting a VIEW Challenge Solution 5

VIEW for Japan Suppliers Challenge Solution 6

INNER JOIN with Normal Table VIEW Table Challenge Solution 8

WHERE with Normal Table VIEW Table Challenge Solution 7

What is the meaning and purpose of Stored Procedure

How to check for STORED PROCEDURE across databases Challenge Soln 4

How to Modify STORED PROCEDURE Tesla Vehicles Challenge Solution 3

Check for STORED PROCEDURE in the current database Challenge Solution 5

Check for STORED PROCEDURE in a specified database Challenge Soln 6

Deleting a STORED PROCEDURE Challenge Solution 7

How to create STORED PROCEDURE for cars table Challenge Solution 2

STORED PROCEDURE Helping Purchasing Manager Challenge Solution 8

STORED PROCEDURE for Most Expensive Car Challenge Solution 9

STORED PROCEDURE for DATA INSERT to a table Challenge Solution 10

What is FUNCTION in SQL

How to check for FUNCTION Challenge Solution 3

Creating Addition FUNCTION Challenge Solution 2

Altering or Updating FUNCTION Challenge Solution 5

Creating Pythagoras Theorem FUNCTION Challenge Solution 4

Creating FUNCTION for Order details Line Total Challenge Solution 6

Deleting a FUNCTION Challenge Solution 7

TRIGGER More Explanation With Diagram

The Purpose The How and Types of TRIGGER

How to Check and Delete a TRIGGER Challenge Solution 1c

Steps to Creating a TRIGGER Challenge Solution 1a

Creating After Update TRIGGER Another Method Challenge Solution 1d

Creating After Update TRIGGER Challenge Solution 1b

Creating AfterUpdate MySQL TRIGGER Above USD5k Challenge Solution 3

Creating Conditional Update TRIGGER Different Names Challenge Solution 2

After Insert Error Message MySQL TRIGGER Challenge Solution 4

SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER Challenge Solution 7

Multiple lines of TRIGGER Many in One Challenge Solution 6

Fraud Detection After Delete TRIGGER Challenge Solution 8

TRIGGER with SIGNAL SQLSTATE for Null Value Challenge Solution 5

Setting up database for challenges with attached downloadable resource

Nested Subquery Budget above average Challenge Solution 2

Nested Subquery JOIN methods 1million Challenge Solution 1

Nested Subquery INNER JOIN GROUP BY HAVING Challenge Solution 4

Nested Subquery More Query Tweaking Challenge Solution 3

Intro

CarShop Resource Details

Fetching Names of Cars Challenge Solution 1

Cars at a specific price Challenge Solution 3

Names Price of Cars Challenge Solution 2

Between two prices of cars Challenge Solution 4

Counting Cars Challenge Solution 5

Price List of Cars Challenge Solution 6

Car Average Price Challenge Solution 8

Price List For Cambodia Customers Challenge Solution 7

The most expensive car Challenge Solution 9

Most Expensive Cars Challenge Solution 10

Honda Toyota Challenge Solution 11

All details from two tables Challenge Solution 12

Specific fields from two tables Challenge Solution 13

Average Price Per Manufacturer Challenge Solution 15

Counting Cars Per Manufacturer Challenge Solution 14

Manufacturer Average Car Price Above 35000 Challenge Solution 16

The Cheapest Car Challenge Solution 17

Data Insert Challenge Solution 19

The Most Expensive Car Challenge Solution 18

Correcting Wrong Data Challenge Solution 20

Discounted Prices I Challenge Solution 21

Discounted Price II Challenge Solution 22

VIEW for price list Challenge Solution 23

What is the current database selected Assignment 1

What is the current database selected Assignment 1 Solution

What are the available tables in the database Assignment 2

What are the available tables in the database Assignment 2 Solution

Display the details of each of the table in the database Assignment 3

SQL Query to retrieve data from one table Assignment 4

Display the details of each of the table in the database Assignment 3 Solution

SQL Query to retrieve data from one table Solution to Assignment 4

Using Alias Assignment 5

Using Alias Solution to Assignment 5

Retrieving data across two tables using JOIN Assignment 6

Retrieving data across two tables using JOIN Solution to Assignment 6

Retrieving data across three tables using JOIN Assignment 7

Aggregate sum average minimum maximum Assignment 8

Retrieving data across three tables using JOIN Solution to Assignment 7

Aggregate sum average minimum maximum Solution to Assignment 8

GROUP BY Average Assignment 9

GROUP BY Average Solution to Assignment 9

GROUP BY RIGHT LEFT INNER NO JOIN Assignment 10

VIEW for three tables JOIN Assignment 11

GROUP BY RIGHT LEFT INNER NO JOIN Solution to Assignment 10

INNER JOIN Subquery EXISTS Assignment 12

VIEW for three tables JOIN Solution to Assignment 11

Updating Table with 5 Increase in Salary Assignment 13

INNER JOIN Subquery EXISTS Solution to Assignment 12

Updating Table with 5 Increase in Salary Solution Assignment 13

INNER JOIN and SubQuery Assignment 14

INNER JOIN AND Assignment 15

INNER JOIN AND Solution Assignment 15

INNER JOIN and SubQuery Solution Assignment 14

INNER JOIN SubQuery Assignment 16

INNER JOIN SubQuery Solution to Assignment 16

SUBQUERY LIMIT Assignment 17

UCASE Assignment 18

SUBQUERY LIMIT Solution to Assignment 17

UCASE Solution to Assignment 18

Employees With Same Salary Task 1

Solution Employees With Same Salary Task 1

Duplicate Title Task 2

Solution Duplicate Title Task 2

Excluding Titles Task 3

Solution Excluding Titles Task 3

Eight Last Alphabet n Task 4

Solution Eight Last Alphabet n Task 4

Even Rows Task 5

Solution Even Rows Task 5

Odd Rows Task 6

Solution Odd Rows Task 6

Second to Fourth Task 7

Solution Second to Fourth Task 7

Counting Employee with SALES Task 8

Solution Counting Employee with SALES Task 8

Using Sub Query Second to the Highest Salary Task 9

Solution Using Sub Query Second to the Highest Salary Task 9

Tricky Exercise Task 10

Solution Tricky Exercise Task 10

Tricky Exercise Task 11

Solution Tricky Exercise Task 11

Tricky Exercise Task 12

Tricky Exercise Task 12b

Solution Tricky Exercise Task 12

Solution Tricky Exercise Task 12b

Tricky Exercise Task 13

Solution Tricky Exercise Task 13

Tricky Exercise Task 14

Solution Tricky Exercise Task 14

Using WITH SUBQUERY INNER JOIN

Using Fewer Columns From SUBQUERY With JOIN

Tricky Exercise Task 15

Solution Tricky Exercise Task 15

Tricky Exercise task 16

Solution Tricky Exercise task 16

Tricky Exercise Task 17

Solution Tricky Exercise Task 17

Introduction

Day of the Week

Day of the Month

Day of the Year

Week of the Year

Year from given DateTime

Month of the Year

Second Minute Hour AM and PM from DateTime

Tricky Exercise Task 18

Solution Tricky Exercise Task 18

Introduction to Combining SQL and Python

Installation of MySQL Connector for Python

Creating Database Show Databases From Python

Creating a Table Show Table Describe Table

Insert A Row of Data Into A Table Select

Insert Multiple Rows of Data Into A Table

Counting the numbers of rows

FetchOne vs FetchAll

Select Filter with Python

SQL Wildcard with Python

Business Intelligence Introduction Definition

Business Intelligence Process

How to Download and Install Tableau

Tableau WhatIsWhat In Tableau I

Tableau WhatIsWhat In Tableau III

Tableau WhatIsWhat In Tableau II

Tableau MySQL Querying SQL Database from Tableau

Tableau MySQL Visualising CarShop Dataset

Connecting MySQL to Tableau

Tableau SQL Challenge Gross Sales and Net Sales Report