SQL–MySQL Complete Master Bootcamp | Beginner-Expert (2024)
Loại khoá học: IT Certifications
MySQL for Data Analytics, Database Management, Business Intelligence & Analysis. Master SQL & Tableau. Create Reports!
Mô tả
Hello and welcome to SQL – MySQL: Complete Master Bootcamp | Beginner-Expert!
Learn and understand the skills you need to become a master of SQL & MySQL using real-world projects. Learn to build real-life data analytic reports with complex queries. Start learning from scratch to advanced topics in SQL with Instructor support: Ask questions and get quick responses.
This course is updated frequently with new lessons, projects, and resources!
Start Learning SQL TODAY!
#Reviews about this course
"This course was very in-depth, it does take a lot of time and focus but was certainly worth it. I would highly recommend it to anyone that is looking to further advance or start a SQL career."
"Thanks for sharing such valuable information."
"It's an interesting well explained course for beginners with enough practice material to get a hold on concepts. I am building more & more knowledge & interest at each micro-step"
"Such a great match! So far he explains it in lamen's terms that are incredibly easy to understand. I am looking forward to more!"
"It is a great opportunity to learn valuable things which can boost you for a perfect job. The Instructor has the talent to transfer knowledge. Watch the videos, and Practice more and more. One of my best courses. Probably the best!"
"I learned a lot of stuff. This course contains a lot of information and is well organized. Really good teacher!"
WHO IS THIS COURSE FOR?
For Beginner, Intermediate & Expert Level (such as SQL fundamentals, SQL essential, intermediary SQL & advanced SQL).
This course is for you if you are tired of SQL courses that are too brief, too simple, or too complicated.
This course is for you if you want to build a real-world database, reports, and projects with SQL & connect to Python.
This course is for you if you want to master the in-and-out of SQL queries including complex and advanced queries.
This course is for you if you want to learn MySQL by doing exciting real-life challenges that will distinguish you from the crowd.
This course is for you if you want to learn Advanced SQL for Business Analysis, Marketing, and Data Management.
This course is for you if you've discovered without SQL you can't do much with data analytics, data science, machine learning, AI, or become a better developer.
This course is for you if you want to master SQL which you can also use for Oracle SQL, Microsoft SQL Server, SQL Lite, and PostgreSQL.
This MySQL tutorial course is for you if you plan to pass SQL Interview for Data, Business, and Financial Analytics, Data Science, Data Modeller, & Database administration.
This course will teach you in detail such as stored procedures, view, transactions, functions, nested and correlated subquery, and several other tips you don't in other MySQL courses.
This course covers all the following (and many more) both the theory, practical with hands-on exercises with the solutions:
Introduction to SQL
Installation MySQL
Select Statement
Database
Table
Data Types
Insert Query
Candidate, Surrogate, Primary, Alternative & Foreign Key
Primary and Foreign Key Constraints | Alter Table
Alias (AS)
Concat Function
Order By Keyword
Limit Clause
Order By & Rand Function
Comments
Where Clause
Index
Wildcards
Update Statement & Replace Function
Select Distinct Statement
Format Function
Group By Statement | Aggregate
Inner Join
Left Join
Right Join
Self Join
Two Tables Join
Three Tables Join
Four Tables Join
Five Tables Join
Six Tables Join
Seven Tables Join
Eight Tables Join
Nine Tables Join
Ten Tables Join
Offset & Limit
Case Function
Cast Function
Nested & Correlated Subqueries
Subqueries & Exits Operator
String Function
Session
Table Locking
Transaction
View
Stored Procedures (Stored Routines)
User-Defined Functions (Stored Routine)
Triggers
Combining SQL and Python
Combining SQL and Tableau
Research Data Set - Real-World Datasets
CAR SHOP DATA SET - Real-World Datasets
CAMERA SUPPLIERS - Real-World Datasets
With all of the above and many more plus the support, assistance, and guidance of the instructor throughout this complete high-quality guide you will gain numerous skills that will boost your career.
Your understanding of SQL through MySQL is highly valuable.
Whether you are a beginner or a professional desiring to gain more knowledge in SQL, this course is for you. You will be learning from experts with over two decades of experience.
What are you waiting for? Enroll now and let's get started!
Bạn sẽ học được gì
Write complex queries with View, Stored Procedure, Trigger, Transaction, User-defined Function, Session, Table Locking and many more
Start from beginner level to expert level and build real-world report with SQL
Use Python to create databases, tables and write queries. Use tableau to report your data
Write complex queries to retrieve information from single and across multiple tables by using Nested & Correlated Subqueries
Write complex queries to retrieve data across multiple tables by using Left, Right, Inner and Full Outer joins queries
Learn by doing tons of real-world SQL projects, challenges & assignment with solutions
Learn to use complex sorting, filtering, extracting and aggregating queries to analyse data
Pass your next BI , Data Analysts and Data Science Interviews and Vivas
This SQL MySQL tutorial cover SQL Foundations, SQL beginners, SQL intermediate and SQL expert levels training
Join and retrieve data from One, Two, Three, Four, Five, Six, Seven, Eight, Nine and Ten tables
Yêu cầu
- No programming experience is needed - I'll teach you everything you need to know
- No paid software required - everything will be done with MySQL Workbench (which is free)
- A Mac laptop/iMac or a Windows PC
- I'll walk you through, step-by-step on how to get MySQL Workbence installed and set up
- This SQL MySQL tutorial will move you from zero to hero
- I'll walk you through on how to get MySQL Connector to run with Python
Nội dung khoá học
101 sections
What is SQL?
24:56
Understanding MySQL Installation
03:07
MySQL Installation on MacOS
05:43
CODE: MySQL Installation on MacOS
00:12
How to fix Connection to MySQL Server Error - MacOS
02:35
MySQL and Workbench Instation on Windows
03:22
How to fix Connection to MySQL Server Error - Windows
02:29
Sample Database Resources for this Course
00:49
Understanding Database
04:51
How to Create a Database
02:13
CODE: How to Create a Database
00:00
How to Create Database - IF NOT EXISTS
03:23
CODE: How to Create Database - IF NOT EXISTS
00:01
How to Select a Database
01:13
CODE: How to Select a Database
00:00
How to Find Out the Currently Selected Database
01:51
CODE: How to Find Out the Currently Selected Database
00:00
How to Check If a Database Exists
02:28
CODE: How to Check If a Database Exists
00:02
How to Delete a Database
01:24
CODE: How to Delete a Database
00:00
How to Delete a Database if Exists
02:35
CODE: How to Delete a Database if Exists
00:01
18 Multiple Choice Questions on Database
02:48
18 Multiple Choice Answers on Database
03:16
CRUD - Understanding CRUD
02:53
Table - Introduction and Creating Basic Table in MySQL
20:19
What is Select Statement?
15:16
Data Types - Introduction
03:00
Introduction to MySQL Numeric Data Types
05:52
Integer Types - INTEGER or INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT
05:07
Client's Integer Data Types Requirement Scenario
07:50
CODE: Client's Integer Data Types Requirement Scenario
00:13
Boolean Type (tinyint(1))
04:28
CODE: Boolean Type (tinyint(1))
00:21
20 Multiple-Choice Questions on Integer Data Types
02:03
Answers - 20 Multiple-Choice Questions on Integer Data Types
02:21
Fixed-Point Types - DECIMAL & NUMERIC
03:10
Client's Fixed-Point Data Types Requirement Scenario
03:37
CODE: Client's Fixed-Point Data Types Requirement Scenario
00:10
10 Multiple-Choice Questions on Fixed-Point Data Types
01:24
Answers - 10 Multiple-Choice Questions on Fixed-Point Data Types
01:40
Floating-Point Types - FLOAT, DOUBLE
02:53
Client's Floating-Point Data Types Requirement Scenario
01:10
CODE: Client's Floating-Point Data Types Requirement Scenario
00:10
10 Multiple-Choice Questions on Floating-Point Data Types
01:18
Answers - 10 Multiple-Choice Questions on Floating-Point Data Types
01:23
Bit-Value Type - BIT
01:18
Client's Bit Data Types Requirement Scenario
02:17
CODE: Client's Bit Data Types Requirement Scenario
00:05
5 Multiple-Choice Questions on Bit Data Types
00:43
Answers - 5 Multiple-Choice Questions on Bit Data Types
00:45
Introduction to MySQL String Data Types
01:48
The CHAR and VARCHAR Types
03:04
Client's CHAR and VARCHAR Types Requirement Scenario
02:04
CODE: Client's CHAR and VARCHAR Types Requirement Scenario
00:12
10 Multiple-Choice Questions on CHAR and VARCHAR Data Types
01:23
Answers - 10 Multiple-Choice Questions on CHAR and VARCHAR Data Types
01:28
The BINARY and VARBINARY Types
02:35
Client's BINARY and VARBINARY Types Requirement Scenario
01:37
CODE: Client's BINARY and VARBINARY Types Requirement Scenario
00:07
10 Multiple-Choice Questions on BINARY and VARBINARY Data Types
01:31
Answers - 10 Multiple-Choice Questions on BINARY and VARBINARY Data Types
01:36
The BLOB and TEXT Types
03:46
Client's BLOB and TEXT Types Requirement Scenario
03:50
CODE: Client's BLOB and TEXT Types Requirement Scenario
01:00
30 Multiple-Choice Questions on BLOB and TEXT Data Types
04:13
Answers - 30 Multiple-Choice Questions on BLOB and TEXT Data Types
05:05
ENUM Type
03:08
Client's ENUM Types Requirement Scenario
02:59
CODE: Client's ENUM Types Requirement Scenario
00:09
10 Multiple-Choice Questions on ENUM Data Types
01:51
Answers - 10 Multiple-Choice Questions on ENUM Data Types
02:15
SET Type
03:30
Client's SET Types Requirement Scenario
02:11
CODE: Client's SET Types Requirement Scenario
00:17
10 Multiple-Choice Questions on SET Data Types
01:58
Answers - 10 Multiple-Choice Questions on SET Data Types
02:03
Introduction to MySQL Date & Time
01:03
DATE & TIME Types
03:48
Client's Date and Time Types Requirement Scenario
02:22
CODE: Client's Date and Time Types Requirement Scenario
00:12
20 Multiple-Choice Questions on Date and Time Data Types
02:21
Answers -20 Multiple-Choice Questions on Date and Time Data Types
02:34
Introduction to MySQL Spatial Types
01:59
Spatial Data Types
02:31
Client's Spatial Types Requirement Scenario
03:17
CODE: Client's Spatial Types Requirement Scenario
00:39
20 Multiple-Choice Questions on Spatial Data Types
02:34
Answers - 20 Multiple-Choice Questions on Spatial Data Types
03:06
Understanding JSON Data Type in MySQL
01:59
Client's JSON Types Requirement Scenario
03:17
CODE: Client's JSON Types Requirement Scenario
00:17
10 Multiple-Choice Questions on JSON Data Types
01:01
Answers - 10 Multiple-Choice Questions on JSON Data Types
01:16
MySQL Auto Increment
04:19
MySQL Default
06:38
MySQL Null and NOT Null
09:03
WHERE - A brief Intro
05:02
SQL Basic Insert
01:37
SQL Inserting Multiple Rows at Once
00:38
SQL Inserting Data from Another Table
02:56
SQL Inserting with a Set Clause
01:02
Introductions to Keys in SQL
06:30
Unique Key in SQL
11:17
Primary Key in SQL
06:37
Candidate and Alternate Keys in SQL
05:54
Composite - Compound - Key in SQL
01:11
Natural Key in SQL
02:02
Surrogate Key in SQL
03:43
Super Key in SQL
01:55
Foreign Key in SQL
07:57
41 Multiple-Choice Questions on different types of SQL Keys
04:24
Answers - 41 Multiple-Choice Questions on different types of SQL Keys
05:05
Alter Table - Intro & Adding a New Column
04:03
Alter Table - Dropping an Existing Column
01:11
Alter Table - Modify Column Type and Size
01:21
Alter Table - Drop Primary Key
00:48
Alter Table - Add Primary Key
00:30
Alter Table - Add Unique Constraint
00:51
Alter Table - Rename Column
00:58
Alter Table - Add Foreign Key
03:50
Alter Table - Rename Table
00:53
Alter Table - Add Default to Column
01:59
Alter Table - Drop Default from a Column
00:50
Alter Table - Drop Foreign Key
05:49
Introduction to delete & Deleting Specific Records
02:45
Delete multiple records
01:14
Delete all records
00:39
Truncate Table
00:37
Deleting a Table
00:44
Delete Cascade
07:40
Understanding the MySQL Where Clause
04:41
List of Comparison Operators and EQUAL TO (=) By Example
02:44
Comparison Operators NOT EQUAL TO (!=, <>) By Example
04:20
Comparison Operator GREATER THAN (>) By Example
02:06
Comparison Operator LESS THAN (<) By Example
01:46
Comparison Operator LESS THAN OR EQUAL TO (<=) By Example
01:18
Comparison Operator GREATER THAN OR EQUAL TO (>=) By Example
02:02
Understanding Logical Operator and AND operator by Example
04:03
Logical Operator OR By Example
02:47
Logical Operator NOT By Example
02:18
Comparison and Logical Operators Combine By Example
04:45
Comparison and Logical Operators Combine By Example
03:08
Between Operator By Example
02:20
Like Operator (Pattern Matching) with Examples
04:51
Not Like Operator (Pattern Matching) Example
01:38
IN Operator by Example
03:21
NOT IN Operator by Example
01:41
IS NULL Operator by Example
01:46
IS NOT NULL Operator by Example
01:20
ANY Operator by Example
14:30
ALL Operator by Example
03:16
Introduction to Order By
03:07
Order By by Example - ASC
02:43
Order By by Example - DESC
01:21
Order By by Example - ASC & DESC
03:12
Introduction to LIMIT
01:52
LIMIT by Example 1
03:01
LIMIT by Example 2
02:11
LIMIT by Example 3
01:25
LIMIT by Example 4
01:02
LIMIT by Example 5
01:19
Understanding Offset
03:33
Offset by Example 1
03:48
Offset by Example 2
02:31
Offset by Example 3
02:18
Offset by Example 4
01:46
Understanding RAND() function
03:26
CODE: Understanding RAND() function
00:02
RAND() Function by Example 1
04:21
CODE: RAND() Function by Example 1
00:02
RAND() Function by Example 2
01:44
CODE: RAND() Function by Example 2
00:04
RAND() Function by Example 3
00:41
CODE: RAND() Function by Example 3
00:02
RAND() Function by Example 4
00:42
CODE: RAND() Function by Example 4
00:02
RAND() Function by Example 5
00:37
CODE: RAND() Function by Example 5
00:02
Understanding MySQL Comments
02:08
MySQL Comment by Example 1
01:17
CODE: MySQL Comment by Example 1
00:03
MySQL Comment by Example 2
01:01
CODE: MySQL Comment by Example 2
00:03
MySQL Comment by Example 3
01:30
CODE: MySQL Comment by Example 3
00:04
Understanding MySQL Alias
04:23
MySQL Alias by Example 1
01:46
CODE: MySQL Alias by Example 1
00:02
MySQL Alias by Example 2
01:50
CODE: MySQL Alias by Example 2
00:02
MySQL Alias by Example 3
01:20
CODE: MySQL Alias by Example 3
00:01
Understanding Concat
05:37
CODE: Understanding Concat
00:02
Concat By Example 1
02:53
CODE: Concat By Example 1
00:01
Concat By Example 2
02:31
CODE: Concat By Example 2
00:02
Concat By Example 3
01:55
CODE: Concat By Example 3
00:01
Concat By Example 4
01:30
CODE: Concat By Example 4
00:02
Understanding Format() Function
01:55
Format() Function By Example 1
02:15
CODE: Format() Function By Example 1
00:02
Format() Function By Example 2
01:22
CODE: Format() Function By Example 2
00:02
Understanding Aggregate Functions
02:29
Aggregate Functions By Examples
02:25
CODE: Aggregate Functions By Examples
00:14
Understanding Group By
04:52
Group By by Example 1
04:00
CODE: Group By by Example 1
00:02
Group By by Example 2
02:51
CODE: Group By by Example 2
00:02
Group By by Example 3
01:05
CODE: Group By by Example 3
00:02
Group By by Example 4
01:26
CODE: Group By by Example 4
00:02
Understanding Having
01:07
Having Clause by Example 1
02:49
CODE: Having Clause by Example 1
00:03
Having Clause by Example 2
01:46
CODE: Having Clause by Example 2
00:03
Understand MySQL Index
04:16
Types of Indexing
03:38
Primary Key Index
04:11
Unique Index
07:26
Full_Text Index
04:08
Column Index
01:39
Spatial and Secondary Indexes
01:46
Deleting an Index
01:38
What is Wildcard
01:07
Wildcard by Example 1
01:55
Wildcard by Example 2
02:45
Wildcard by Example 3
01:28
Wildcard by Example 4
02:53
Wildcard by Example 5
01:33
Wildcard by Example 6
00:58
Wildcard by Example 7
01:20
Wildcard by Example 8
01:44
Wildcard by Example 9
01:43
Wildcard by Example 10
02:06
Understanding the Update Statement
02:49
Update Statement by Example 1
03:22
Update Statement by Example 2
01:36
Update Statement by Example 3
02:36
Update Statement by Example 4
03:37
Update Statement by Example 5
02:08
Update Statement by Example 6
01:12
Update Statement by Example 7
01:37
Replace Function by Example 1
03:49
Replace Function by Example 2
01:55
Replace Function by Example 3
02:15
Resource for JOIN
00:02
Purpose of JOIN in SQL
03:11
Type of JOIN in SQL
01:02
Understanding INNER JOIN
04:34
Understanding LEFT JOIN
04:42
Understanding RIGHT JOIN
03:53
Understanding FULL JOIN
03:11
Overview of Tables & Code for JOIN Demonstration
01:43
CODE: Overview of Tables & Code for JOIN Demonstration
00:07
INNER JOIN - DEEP DIVE
21:03
CODE: INNER JOIN - DEEP DIVE
00:04
LEFT JOIN - DEEP DIVE
15:07
CODE: LEFT JOIN - DEEP DIVE
00:03
RIGHT JOIN - DEEP DIVE
06:02
CODE: RIGHT JOIN - DEEP DIVE
00:02
More On RIGHT JOIN and LEFT JOIN | with Shipper & Orders tables
07:45
CODE:More On RIGHT JOIN and LEFT JOIN | with Shipper & Orders tables
00:04
Table.Column vs Column only?
14:16
ON vs WHERE in INNER, LEFT & RIGHT JOIN
06:42
"ON" vs "USING" in SQL JOIN Statement
03:37
JOIN for Orders Handled/Managed By Employee - Challenge & Solution 1
04:30
CODE: JOIN for Orders Handled/Managed By Employee - Challenge & Solution 1
00:06
Using JOIN for Products & Their Suppliers - Challenge & Solution 2
03:22
CODE: Using JOIN for Products & Their Suppliers - Challenge & Solution 2
00:02
JOIN for Customers and Shippers - Challenge & Solution 3
01:56
CODE: JOIN for Customers and Shippers - Challenge & Solution 3
00:02
JOIN Many Tables - Customers and Names of Shipper - Challenge & Solution 4
04:54
CODE: JOIN Many Tables - Customers and Names of Shipper -Challenge & Solution 4
00:03
Please Read Me!
00:05
Schema
00:00
Simplifying the Schema used for JOIN in the following sections.
05:26
Self-Join | One Table Join - Challenge and Solution 1
06:25
CODE: Self-Join | One Table Join - Challenge and Solution 1
00:06
Two Tables Join - Challenge and Solution 2
01:20
CODE: Two Tables Join - Challenge and Solution 2
00:02
Two Tables Join - Challenge and Solution 3
02:04
CODE: Two Tables Join - Challenge and Solution 3
00:03
Two Tables Join - Challenge and Solution 4
01:05
CODE: Two Tables Join - Challenge and Solution 4
00:04
Two Tables Join - Challenge and Solution 5
02:39
CODE: Two Tables Join - Challenge and Solution 5
00:04
Three Table Joins - Challenge and Solution 6
02:16
CODE: Three Tables Join - Challenge and Solution 6
00:03
Three Tables Join - Challenge and Solution 7
01:20
CODE: Three Tables Join - Challenge and Solution 7
00:04
Four Tables Join - Challenge and Solution 8
03:41
CODE: Four Tables Join - Challenge and Solution 8
00:07
Five Tables Join - Challenge and Solution 9
05:34
CODE: Five Tables Join - Challenge and Solution 9
00:08
Five Tables Join - Challenge and Solution 10
02:46
CODE: Five Tables Join - Challenge and Solution 10
00:07
Six Tables Join - Challenge and Solution 11
01:29
CODE: Six Tables Join - Challenge and Solution 11
00:09
Seven Tables Join - Challenge and Solution 12
01:40
CODE: Seven Tables Join - Challenge and Solution 12
00:09
Eight Tables Join - Challenge and Solution 13
01:30
CODE: Eight Tables Join - Challenge and Solution 13
00:07
Nine Tables Join - Challenge and Solution 14
03:02
CODE: Nine Tables Join - Challenge and Solution 14
00:13
Ten Tables Join - Challenge and Solution | For Demonstration Purpose
01:11
CODE: Ten Tables Join - Challenge and Solution 15
00:12
Understanding MySQL CASE
06:31
CODE: Understanding MySQL CASE
00:15
CASE with IS NULL
02:23
CODE: CASE with IS NULL
00:03
CASE FOR TYPE OF CUSTOMERS
06:52
CODE: CASE FOR TYPE OF CUSTOMERS
00:13
CAST - FROM STRING to DATE
01:02
CODE: CAST - FROM STRING to DATE
00:01
CAST - FROM INTEGER to CHAR - Challenge & Solution 2
00:21
CODE: CAST - FROM INTEGER to CHAR - Challenge & Solution 2
00:01
CAST | FROM STRING to DATE & TIME - Challenge & Solution 3
00:56
CODE: CAST | FROM STRING to DATE & TIME - Challenge & Solution 3
00:02
CAST | FROM STRING to TIME - Challenge & Solution 4
00:31
CODE: CAST | FROM STRING to TIME - Challenge & Solution 4
00:01
CAST | Order Date Without time - Challenge & Solution 5
01:07
CODE: CAST | Order Date Without time - Challenge & Solution 5
00:01
CAST | FROM DATE to DATETIME - Challenge & Solution 6
01:44
CODE: CAST | FROM DATE to DATETIME - Challenge & Solution 6
00:01
Introduction to subqueries
04:08
Aggregate Function with Subqueries
04:18
Nested Subquery - Challenge & Solution 1
04:05
Many Subqueries - Challenges & Solution 2
06:00
Exists Operator
01:10
Subquery & Exists - Challenge & Solution 1
04:34
CODE: Subquery & Exists - Challenge & Solution 1
00:03
Subquery & Exists - Challenge & Solution 2
05:44
CODE: Subquery & Exists - Challenge & Solution 2
00:06
Difference Between Nested and Correlated Subqueries
09:40
SPACE FUNCTION | Challenge & Solution 1
00:56
SPACE FUNCTION | Challenge & Solution 2
01:01
REPEAT FUNCTION | Challenge & Solution 3
00:36
REPEAT FUNCTION | Challenge & Solution 4
02:09
REPLACE FUNCTION | Challenge & Solution 5
01:05
REPLACE FUNCTION | Challenge & Solution 6
00:52
REPLACE FUNCTION | Challenge & Solution 7
02:22
REVERSE FUNCTION | Challenge & Solution 8
00:55
REVERSE FUNCTION | Challenge & Solution 9
02:18
LEFT FUNCTION | Challenge & Solution 10
01:53
LEFT FUNCTION | Challenge & Solution 11
01:43
RIGHT FUNCTION | Challenge & Solution 12
00:51
RIGHT FUNCTION | Challenge & Solution 13
02:04
RPAD FUNCTION | Challenge & Solution 14
01:31
RPAD FUNCTION | Challenge & Solution 15
03:34
LPAD FUNCTION | Challenge & Solution 16
02:34
LPAD FUNCTION | Challenge & Solution 17
01:51
LPAD FUNCTION | Challenge & Solution 18
04:58
POSITION & LOCATION FUNCTIONS | Challenge & Solution 19
01:55
POSITION & LOCATION FUNCTIONS | Challenge & Solution 20
01:23
SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 21
03:18
SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 22
02:53
SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 23
04:17
SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 24
01:30
SUBSTRING_INDEX FUNCTION | Challenge & Solution 25
01:43
SUBSTRING_INDEX FUNCTION | Challenge & Solution 26
01:02
SUBSTRING_INDEX FUNCTION | Challenge & Solution 27
01:22
SUBSTRING_INDEX FUNCTION | Challenge & Solution 28
01:11
SUBSTRING_INDEX FUNCTION | Challenge & Solution 29
03:07
MID FUNCTION | Challenge & Solution 30
01:09
MID FUNCTION | Challenge & Solution 31
01:14
INSERT FUNCTION | Challenge & Solution 32
03:25
INSERT FUNCTION | Challenge & Solution 33
01:32
INSTR FUNCTION | Challenge & Solution 34
01:31
INSTR FUNCTION | Challenge & Solution 35
01:11
LCASE & LOWER FUNCTION | Challenge & Solution 35
00:55
LCASE & LOWER FUNCTION | Challenge & Solution 36
00:35
UCASE & UPPER FUNCTION | Challenge & Solution 37
00:36
UCASE & UPPER FUNCTION | Challenge & Solution 38
00:56
UCASE & UPPER FUNCTION | Challenge & Solution 39
00:55
LENGTH FUNCTION | Challenge & Solution 40
01:02
LENGTH FUNCTION | Challenge & Solution 41
01:01
LTRIM FUNCTION | Challenge & Solution 42
02:04
LTRIM FUNCTION | Challenge & Solution 43
01:34
RTRIM FUNCTION | Challenge & Solution 44
01:08
RTRIM FUNCTION | Challenge & Solution 45
01:17
TRIM FUNCTION | Challenge & Solution 45
01:46
TRIM FUNCTION | Challenge & Solution 46
00:49
Understanding MySQL Session
03:24
CODE: Understanding MySQL Session
00:02
Table Locking Intro
01:51
Table Locking Demonstration
04:40
CODE: Table Locking Demonstration
00:10
Brief Introduction to SQL Transaction
03:02
TRANSACTION components - START, BEGIN, BEGIN WORK, COMMIT, ROLLBACK, SET
01:53
CODE: TRANSACTION components - START, BEGIN, BEGIN WORK, COMMIT, ROLLBACK, SET
00:02
TRANSACTION By Example
06:10
CODE: TRANSACTION By Example
00:18
NOT USING TRANSACTION
01:26
CODE: NOT USING TRANSACTION
00:19
ROLLBACK
05:15
CODE: ROLLBACK
00:00
Meaning of VIEW
04:34
CODE: Meaning of VIEW
00:16
VIEW for Sales Manager | Challenge & Solution 1
02:03
CODE: VIEW for Sales Manager | Challenge & Solution 1
00:02
VIEW for Employees hired in 1994 | Challenge & Solution 2
02:26
CODE: VIEW for Employees hired in 1994 | Challenge & Solution 2
00:02
Updating VIEW | Challenge & Solution 3
02:48
CODE: Updating VIEW | Challenge & Solution 3
00:03
A Mistake In VIEW | Challenge & Solution 4
02:21
CODE: A Mistake In VIEW | Challenge & Solution 4
00:03
Deleting a VIEW - Challenge & Solution 5
01:31
CODE: Deleting a VIEW - Challenge & Solution 5
00:00
VIEW for Japan Suppliers - Challenge & Solution 6
01:14
CODE: VIEW for Japan Suppliers - Challenge & Solution 6
00:02
WHERE with Normal Table & VIEW Table - Challenge & Solution 7
05:03
CODE: WHERE with Normal Table & VIEW Table - Challenge & Solution 7
00:03
INNER JOIN with Normal Table & VIEW Table - Challenge & Solution 8
01:40
CODE: INNER JOIN with Normal Table & VIEW Table - Challenge & Solution 8
00:08
What is the meaning and purpose of Stored Procedure
06:59
CODE: What is the meaning and purpose of Stored Procedure
00:05
How to create STORED PROCEDURE for cars table - Challenge & Solution 2
10:52
CODE: How to create STORED PROCEDURE for cars table - Challenge & Solution 2
00:02
How to Modify STORED PROCEDURE | Tesla Vehicles - Challenge & Solution 3
07:12
CODE: How to Modify STORED PROCEDURE | Tesla Vehicles - Challenge & Solution 3
00:04
How to check for STORED PROCEDURE across databases - Challenge & Soln 4
00:46
CODE: How to check for STORED PROCEDURE across databases - Challenge & Soln 4
00:00
Check for STORED PROCEDURE in the current database - Challenge & Solution 5
01:25
CODE: Check for STORED PROCEDURE in the current database - Challenge & Soln 5
00:02
Check for STORED PROCEDURE in a specified database - Challenge & Soln 6
01:53
CODE: Check for STORED PROCEDURE in a specified database - Challenge & Soln 6
00:01
Deleting a STORED PROCEDURE - Challenge & Solution 7
01:28
CODE: Deleting a STORED PROCEDURE - Challenge & Solution 7
00:01
STORED PROCEDURE - Helping Purchasing Manager - Challenge & Solution 8
13:08
CODE: STORED PROCEDURE - Helping Purchasing Manager - Challenge & Solution 8
00:06
STORED PROCEDURE for Most Expensive Car - Challenge & Solution 9
08:39
CODE: STORED PROCEDURE for Most Expensive Car - Challenge & Solution 9
00:04
STORED PROCEDURE for DATA INSERT to a table - Challenge & Solution 10
06:12
CODE: STORED PROCEDURE for DATA INSERT to a table - Challenge & Solution 10
00:04
What is FUNCTION in SQL
02:01
CODE: What is FUNCTION in SQL
00:01
Creating Addition FUNCTION - Challenge & Solution 2
06:56
CODE: Creating Addition FUNCTION - Challenge & Solution 2
00:05
How to check for FUNCTION - Challenge & Solution 3
01:33
CODE: How to check for FUNCTION - Challenge & Solution 3
00:03
Creating Pythagoras Theorem FUNCTION - Challenge & Solution 4
03:18
CODE: Creating Pythagoras Theorem FUNCTION - Challenge & Solution 4
00:04
Altering or Updating FUNCTION - Challenge & Solution 5
04:36
CODE: Altering or Updating FUNCTION - Challenge & Solution 5
00:05
Creating FUNCTION for Order details Line Total - Challenge & Solution 6
05:33
CODE: Creating FUNCTION for Order details Line Total - Challenge & Solution 6
00:05
Deleting a FUNCTION - Challenge & Solution 7
01:41
CODE: Deleting a FUNCTION - Challenge & Solution 7
00:02
The Purpose, The How and Types of TRIGGER
05:31
TRIGGER - More Explanation With Diagram
03:31
Steps to Creating a TRIGGER - Challenge & Solution 1a
08:15
Creating After Update TRIGGER - Challenge & Solution 1b
09:28
CODE: Creating After Update TRIGGER - Challenge & Solution 1b
00:13
How to Check and Delete a TRIGGER - Challenge & Solution 1c
00:36
CODE: How to Check and Delete a TRIGGER - Challenge & Solution 1c
00:02
Creating After Update TRIGGER - Another Method - Challenge & Solution 1d
06:31
CODE: Creating After Update TRIGGER - Another Method - Challenge & Solution 1d
00:12
Creating Conditional Update TRIGGER | Different Names - Challenge & Solution 2
09:10
CODE: Creating Conditional Update TRIGGER | Different Names - Challenge & Soln 2
00:15
Creating AfterUpdate MySQL TRIGGER | Above USD$5k - Challenge & Solution 3
07:23
CODE: Creating AfterUpdate MySQL TRIGGER | Above USD$5k - Challenge & Solution 3
00:51
After Insert Error Message MySQL TRIGGER - Challenge & Solution 4
04:08
CODE: After Insert Error Message MySQL TRIGGER - Challenge & Solution 4
00:40
TRIGGER with SIGNAL SQLSTATE for Null Value - Challenge & Solution 5
07:14
CODE: TRIGGER with SIGNAL SQLSTATE for Null Value - Challenge & Solution 5
00:24
Multiple lines of TRIGGER - Many in One - Challenge & Solution 6
06:50
CODE: Multiple lines of triggers - Many in One - Challenge & Solution 6
01:20
SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER - Challenge & Solution 7
03:04
CODE: SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER - Challenge & Solution 7
00:14
Fraud Detection - After Delete TRIGGER - Challenge & Solution 8
04:03
CODE: Fraud Detection - After Delete TRIGGER - Challenge & Solution 8
00:11
Setting up database for challenges with attached downloadable resource
01:14
Nested Subquery & JOIN methods | < 1million - Challenge & Solution 1
03:57
CODE:Nested Subquery & JOIN methods | < 1million - Challenge & Solution 1
00:07
Nested Subquery | Budget above average - Challenge & Solution 2
01:46
CODE: Nested Subquery | Budget above average - Challenge & Solution 2
00:01
Nested Subquery & More Query Tweaking - Challenge & Solution 3
13:12
CODE: Nested Subquery & More Query Tweaking - Challenge & Solution 3
00:23
Nested Subquery, INNER JOIN, GROUP BY, HAVING - Challenge & Solution 4
09:27
CODE: Nested Subquery, INNER JOIN, GROUP BY, HAVING - Challenge & Solution 4
00:12
Intro
00:17
CarShop Resource Details
03:02
Fetching Names of Cars - Challenge & Solution 1
00:33
Names & Price of Cars - Challenge & Solution 2
00:20
Cars at a specific price - Challenge & Solution 3
00:31
Between two prices of cars - Challenge & Solution 4
01:31
Counting Cars - Challenge & Solution 5
00:41
Price List of Cars - Challenge & Solution 6
01:13
Price List For Cambodia Customers - Challenge & Solution 7
08:26
Car Average Price - Challenge & Solution 8
00:31
The most expensive car - Challenge & Solution 9
01:01
Most Expensive Cars - Challenge & Solution 10
06:17
Honda & Toyota - Challenge & Solution 11
02:07
All details from two tables - Challenge & Solution 12
01:18
Specific fields from two tables - Challenge & Solution 13
01:31
Counting Cars Per Manufacturer - Challenge & Solution 14
04:34
Average Price Per Manufacturer - Challenge & Solution 15
01:37
Manufacturer Average Car Price Above $35,000 - Challenge & Solution 16
01:07
The Cheapest Car - Challenge & Solution 17
01:58
The Most Expensive Car - Challenge & Solution 18
05:21
Data Insert - Challenge & Solution 19
02:00
Correcting Wrong Data - Challenge & Solution 20
00:49
Discounted Prices I - Challenge & Solution 21
02:33
Discounted Price II - Challenge & Solution 22
01:07
VIEW for price list - Challenge & Solution 23
04:50
Read Me First!
00:02
What is the current database selected? - Assignment 1
00:04
What is the current database selected? - Assignment 1 Solution
00:40
What are the available tables in the database? - Assignment 2
00:04
What are the available tables in the database? - Assignment 2 Solution
00:17
Display the details of each of the table in the database - Assignment 3
00:08
Display the details of each of the table in the database -Assignment 3 Solution
01:50
SQL Query to retrieve data from one table - Assignment 4
00:05
SQL Query to retrieve data from one table - Solution to Assignment 4
00:24
Using Alias - Assignment 5
00:07
Using Alias - Solution to Assignment 5
00:58
Retrieving data across two tables using JOIN - Assignment 6
00:56
Retrieving data across two tables using JOIN - Solution to Assignment 6
03:08
Retrieving data across three tables using JOIN - Assignment 7
00:33
Retrieving data across three tables using JOIN - Solution to Assignment 7
02:39
Aggregate - sum, average, minimum, maximum - Assignment 8
00:11
Aggregate - sum, average, minimum, maximum - Solution to Assignment 8
02:07
GROUP BY & Average - Assignment 9
00:13
GROUP BY & Average - Solution to Assignment 9
03:56
GROUP BY; RIGHT, LEFT, INNER & NO JOIN - Assignment 10
00:52
GROUP BY; RIGHT, LEFT, INNER & NO JOIN - Solution to Assignment 10
08:12
VIEW for three tables JOIN - Assignment 11
00:20
VIEW for three tables JOIN - Solution to Assignment 11
02:54
INNER JOIN, Subquery & EXISTS - Assignment 12
00:06
INNER JOIN, Subquery & EXISTS - Solution to Assignment 12
02:54
Updating Table with 5% Increase in Salary - Assignment 13
00:13
Updating Table with 5% Increase in Salary - Solution Assignment 13
00:52
INNER JOIN and SubQuery - Assignment 14
02:33
INNER JOIN and SubQuery - Solution Assignment 14
05:08
INNER JOIN & AND - Assignment 15
00:10
INNER JOIN & AND - Solution Assignment 15
02:51
INNER JOIN & SubQuery - Assignment 16
00:10
INNER JOIN & SubQuery - Solution to Assignment 16
02:17
SUBQUERY & LIMIT - Assignment 17
00:11
SUBQUERY & LIMIT - Solution to Assignment 17
02:54
UCASE - Assignment 18
00:10
UCASE - Solution to Assignment 18
00:17
More Tasks
00:09
Employees With Same Salary - Task 1
00:09
Solution: Employees With Same Salary - Task 1
07:07
CODE: Employees With Same Salary - Task 1
00:17
Duplicate Title - Task 2
00:09
Solution: Duplicate Title - Task 2
01:08
CODE: Duplicate Title - Task 2
00:02
Excluding Titles - Task 3
00:09
Solution - Excluding Titles - Task 3
00:29
CODE: Excluding Titles - Task 3
00:02
Eight & Last Alphabet 'n' - Task 4
00:12
Solution: Eight & Last Alphabet 'n' - Task 4
00:35
CODE: Eight & Last Alphabet 'n' - Task 4
00:01
Even Rows - Task 5
00:06
Solution: Even Rows - Task 5
00:55
CODE: Even Rows - Task 5
00:01
Odd Rows - Task 6
00:06
Solution: Odd Rows - Task 6
00:46
CODE: Odd Rows - Task 6
00:03
Second to Fourth - Task 7
00:10
Solution: Second to Fourth - Task 7
00:32
CODE: Second to Fourth - Task 7
00:01
Counting Employee with "SALES" - Task 8
00:07
Solution: Counting Employee with "SALES" - Task 8
00:17
CODE: Counting Employee with "SALES" - Task 8
00:02
Using Sub Query - Second to the Highest Salary - Task 9
00:10
Solution: Using Sub Query - Second to the Highest Salary - Task 9
01:59
CODE: Using Sub Query - Second to the Highest Salary - Task 9
00:08
Tricky Exercise - Task 10
00:09
Solution: Tricky Exercise - Task 10
01:01
CODE: Tricky Exercise - Task 10
00:01
Tricky Exercise - Task 11
00:37
Solution: Tricky Exercise - Task 11
02:59
CODE: Tricky Exercise - Task 11
00:03
Tricky Exercise - Task 12
00:15
Solution: Tricky Exercise - Task 12
08:39
CODE: Tricky Exercise - Task 12
00:10
Tricky Exercise - Task 12b
00:19
Solution: Tricky Exercise - Task 12b
00:35
CODE: Tricky Exercise - Task 12b
00:03
Tricky Exercise - Task 13
00:15
Solution: Tricky Exercise - Task 13
06:22
CODE: Tricky Exercise - Task 13
00:05
Tricky Exercise - Task 14
00:15
Solution: Tricky Exercise - Task 14
02:56
CODE: Tricky Exercise - Task 14
00:10
Using Fewer Columns From SUBQUERY With JOIN
05:39
CODE: Using Fewer Columns From SUBQUERY With JOIN
00:19
Using WITH, SUBQUERY & INNER JOIN
02:36
CODE: Using WITH, SUBQUERY & INNER JOIN
00:07
Tricky Exercise - Task 15
00:35
Solution: Tricky Exercise - Task 15
06:49
CODE: Tricky Exercise - Task 15
00:42
Tricky Exercise - task 16
00:09
Solution: Tricky Exercise - task 16
00:28
CODE: Tricky Exercise - task 16
00:01
Tricky Exercise - Task 17
00:16
Solution: Tricky Exercise - Task 17
07:09
CODE: Tricky Exercise - Task 17
00:18
Introduction
01:16
Day of the Week
02:16
Day of the Month
01:30
Day of the Year
00:59
Week of the Year
01:57
Month of the Year
01:07
Year from given DateTime
00:18
Second, Minute, Hour. AM and PM from DateTime
02:17
Tricky Exercise - Task 18
00:45
Solution: Tricky Exercise - Task 18
05:44
CODE: Tricky Exercise - Task 18
00:06
Introduction to Combining SQL and Python
01:38
Installation of MySQL Connector for Python
02:34
CODE: Installation of MySQL Connector for Python
00:01
Creating Database & Show Databases From Python
06:01
CODE: Creating Database & Show Databases From Python
00:08
Creating a Table, Show Table & Describe Table
01:24
CODE: Creating a Table, Show Table & Describe Table
00:10
Insert A Row of Data Into A Table & Select
02:30
CODE: Insert A Row of Data Into A Table & Select
00:03
Insert Multiple Rows of Data Into A Table
03:27
CODE: Insert Multiple Rows of Data Into A Table
00:08
Counting the numbers of rows
00:40
CODE: Counting the numbers of rows
00:01
FetchOne vs FetchAll
01:17
CODE: FetchOne vs FetchAll
00:03
Select Filter with Python
01:06
CODE: Select Filter with Python
00:05
SQL Wildcard with Python
03:08
CODE: SQL Wildcard with Python
00:08
Introduction to this section
00:15
Business Intelligence - Introduction & Definition
01:51
Business Intelligence Process
03:14
How to Download and Install Tableau
01:03
Tableau - What-Is-What In Tableau - I
02:21
Tableau - What-Is-What In Tableau - II
08:12
Tableau - What-Is-What In Tableau - III
01:23
Connecting MySQL to Tableau
04:29
Tableau & MySQL: Querying SQL Database from Tableau
01:24
Tableau & MySQL: Visualising CarShop Dataset
03:50
Tableau & SQL Challenge - Gross Sales and Net Sales Report
06:13
Type of Data in MySQL
01:38
MySQL Numeric Types
02:47
TINYINT, SMALLINT, MEDIUMINT, INTEGER, BIGINT -Exact Numeric Data Types in MySQL
14:50
DECIMAL & NUMERIC - Fixed Point Data Types in MySQL | Approximate Numeric I
08:46
DECIMAL & NUMERIC - Fixed Point Data Types in MySQL | Approximate Numeric II
11:10
REAL, FLOAT, DOUBLE - Floating Point Data Type in MySQL
07:26
CHAR vs VARCHAR - String Data Types in MySQL
05:23
BINARY & VARBINARY - String Data Types in MySQL
03:45
BLOB & TEXT - String Data Types in MySQL
01:07
ENUM - String Data Types in MySQL
03:44
SET - String Data Types in MySQL
03:00
DATE, TIME, DATETIME, TIMESTAMP & YEAR - Date and Time Data Types in MySQL
03:48
Inserting A Single Line of Data Into Table - 1st Method
01:25
CODE: Inserting A Single Line of Data Into Table - 1st Method
00:06
Inserting A Single Line of Data Into Table - 2nd Method
00:42
CODE: Inserting A Single Line of Data Into Table - 2nd Method
00:05
Inserting Multiple Lines of Data Into Table - 1st Method
00:46
CODE: Inserting Multiple Lines of Data Into Table - 1st Method
00:08
Inserting Multiple Lines of Data Into Table - 2nd Method
01:42
CODE: Inserting Multiple Lines of Data Into Table - 2nd Method
00:07
Inserting Multiple Lines of Data Into Table - 3rd Method
00:53
CODE: Inserting Multiple Lines of Data Into Table - 3rd Method
00:07
Inserting Null Value and Empty White Space Into Table
03:49
CODE: Inserting Null Value and Empty White Space Into Table
00:15
Candidate Key In SQL
03:08
Surrogate Key In SQL
01:51
Primary Key & Alternative Key In SQL
03:58
Foreign Key In SQL
04:29
Assigning A PRIMARY KEY (Three Methods) - Challenge & Solution 1
03:39
CODE: Assigning A PRIMARY KEY (Three Methods) - Challenge & Solution
00:09
Deleting A PRIMARY KEY - Challenge & Solution 2
02:18
CODE: Deleting A PRIMARY KEY - Challenge & Solution 2
00:13
Adding A PRIMARY KEY To Existing Column - Challenge & Solution 3
01:44
CODE: Adding A PRIMARY KEY To Existing Column - Challenge & Solution 3
00:04
Assigning A FOREIGN KEY - Challenge & Solution 4
06:42
CODE: Assigning A FOREIGN KEY - Challenge & Solution 4
00:13
Assigning A CONSTRAINT NAME To A FOREIGN KEY - Challenge & Solution 5
02:49
CODE: Assigning A CONSTRAINT NAME To A FOREIGN KEY - Challenge & Solution 5
00:15
Adding A FOREIGN KEY To Existing Table - Challenge & Solution 6
02:46
CODE: Challenge & Solution 6 | Adding A FOREIGN KEY To Existing Table
00:10
Challenge & Solution 7 | CONSTRAINT NAME & FOREIGN KEY To Existing Table
02:34
CODE:CONSTRAINT NAME & FOREIGN KEY To Existing Table - Challenge & Solution 7
00:10
Deleting A REFERENCED Parent Table - Challenge & Solution 8
02:19
CODE: Deleting A REFERENCED Parent Table - Challenge & Solution 8
00:09
Deleting A Column From A Table - Challenge & Solution 9
01:07
CODE: Deleting A Column From A Table - Challenge & Solution 9
00:05
Deleting A REFERENCED or CONSTRAINT Column - Challenge & Solution 10
03:02
CODE: Deleting A REFERENCED or CONSTRAINT Column - Challenge & Solution 10
00:12
Select All Rows and Columns - Challenge & Solution 1
02:25
CODE: Select All Rows and Columns - Challenge & Solution 1
00:00
Select Specific Columns - Challenge & Solution 2
01:28
CODE: Select Specific Columns - Challenge & Solution 2
00:01
Manager Demands for All Customers' Detail - Challenge & Solution 3
00:43
CODE: Manager Demands for All Customers' Detail - Challenge & Solution 3
00:00
Specific Customer's Details - Challenge & Solution 4
00:31
CODE: Specific Customer's Details - Challenge & Solution 4
00:01
ORDER BY Introduction
03:47
ORDER BY ASC - Challenge & Solution 1
02:02
CODE: ORDER BY ASC - Challenge & Solution 1
00:02
ORDER BY DESC - Challenge & Solution 2
01:50
CODE: ORDER BY DESC - Challenge & Solution 2
00:01
ORDER BY DESC & CONCAT - Challenge & Solution 3
02:57
CODE: ORDER BY DESC & CONCAT - Challenge & Solution 3
00:02
ORDER BY ASC - Challenge & Solution 4
01:18
CODE: ORDER BY ASC - Challenge & Solution 4
00:01
LIMIT - Challenge & Solution 1
01:03
CODE: LIMIT - Challenge & Solution 1
00:01
LIMIT - Challenge & Solution 2
01:20
CODE: LIMIT - Challenge & Solution 2
00:01
LIMIT - Challenge & Solution 3
00:53
CODE: LIMIT - Challenge & Solution 3
00:02
Introduction to WHERE
03:19
Northwind Data Set | Should run to work along
00:05
UK Customers filter - Challenge & Solution 1
02:58
CODE: UK Customers filter - Challenge & Solution 1
00:03
Specific Customer filter - Challenge & Solution 2
00:30
CODE: Specific Customer filter - Challenge & Solution 2
00:01
Specific Employee filter - Challenge & Solution 3
00:34
CODE: Specific Employee filter - Challenge & Solution 3
00:01
Product with specific Price filter - Challenge & Solution 4
00:48
CODE: Product with specific Price filter - Challenge & Solution 4
00:01
Getting a list of Sales Representatives - Challenge & Solution 5
00:52
CODE: Getting a list of Sales Representatives - Challenge & Solution 5
00:01
None Spanish Customers using != , <> - Challenge & Solution 6
02:38
CODE: None Spanish Customers using != , <> - Challenge & Solution 6
00:03
Products Supplied by a Specific Customer - Challenge & Solution 7
00:38
CODE: Products Supplied by a Specific Customer - Challenge & Solution 7
00:01
All Suppliers Except... using NOT, <>, ! - Challenge & Solution 8
01:42
CODE: All Suppliers Except... using NOT, <>, ! - Challenge & Solution 8
00:05
Products above certain Price | Greater Than > - Challenge & Solution 9
00:52
CODE: Products above certain Price | Greater Than > - Challenge & Solution 9
00:02
Products Below Certain Price| Less Than < - Challenge & Solution 10
00:39
CODE: Products Below Certain Price| Less Than < - Challenge & Solution 10
00:01
Unit In Stock | Less Than < - Challenge & Solution 11
01:00
CODE:Unit In Stock | Less Than < - Challenge & Solution 11
00:01
Minimum Wages | Less Than < - Challenge & Solution 12
00:40
CODE: Minimum Wages | Less Than < - Challenge & Solution 12
00:01
Gifts for Customers | Greater Than - Challenge & Solution 13
02:10
CODE: Gifts for Customers | Greater Than - Challenge & Solution 13
00:03
Units In Stock | Less Than - Challenge & Solution 14
01:26
CODE: Units In Stock | Less Than - Challenge & Solution 14
00:02
San Francisco Customers | AND - Challenge & Solution 15
02:25
CODE: San Francisco Customers | AND - Challenge & Solution 15
00:02
Specific Mexico Customers | AND - Challenge & Solution 16
01:37
CODE: Specific Mexico Customers | AND - Challenge & Solution 16
00:01
None USA and UK Customers | NOT, !=, <> - Challenge & Solution 17
02:33
CODE: None USA and UK Customers | NOT, !=, <> - Challenge & Solution 17
00:06
Brazil and Venezuela Customers | OR - Challenge & Solution 18
01:52
CODE: Brazil and Venezuela Customers | OR - Challenge & Solution 18
00:02
Range of Suppliers | BETWEEN - Challenges & Solution 19
01:09
CODE: Range of Suppliers | BETWEEN - Challenges & Solution 19
00:02
Suppliers | Combining <, > & OR - Challenge & Solution 20
00:32
CODE: Suppliers | Combining <, > & OR - Challenge & Solution 20
00:02
Range of Suppliers using BETWEEN - Challenge & Solution 21
01:14
CODE: Range of Suppliers using BETWEEN - Challenge & Solution 21
00:03
NOT BETWEEN - Challenge & Solution 22
00:35
CODE: NOT BETWEEN - Challenge & Solution 22
00:02
Customers in Paris & Nantes, France - Challenge & Solution 23
02:27
CODE: Customers in Paris & Nantes, France - Challenge & Solution 23
00:02
Product List | BETWEEN, CONCAT, FORMAT, ORDER BY - Challenge & Solution 24
01:28
CODE: Product List | BETWEEN, CONCAT, FORMAT, ORDER BY - Challenge & Solution 24
00:03
NULL values | IS NULL, IS NOT NULL - Challenge & Solution 25
01:09
CODE: NULL values | IS NULL, IS NOT NULL - Challenge & Solution 25
00:01
Employees Report to #2 | IS NOT NULL - Challenge & Solution 26
02:24
CODE: Employees Report to #2 | IS NOT NULL - Challenge & Solution 26
00:03
IN and WHERE - Challenge & Solution 27
01:47
CODE: IN and WHERE - Challenge & Solution 27
00:04
NOT IN - UK, Germany & France Customers - Challenge & Solution 28
01:55
CODE: NOT IN - UK, Germany & France Customers - Challenge & Solution 28
00:04
GROUP BY - True Meaning
10:02
MIN(), MAX(), AVG(), SUM() & GROUP BY - Challenge & Solution 1
03:24
GROUP BY / SUM,MIN,AVG / CONCAT / FORMAT - Challenge & Solution 2
02:03
Region Count | GROUP BY, COUNT - Challenge & Solution 3
01:54
Row / Unique Value Count | GROUP BY, COUNT - Challenge & Solution 4
02:39
Product Count | COUNT, GROUP BY, ORDER BY - Challenge & Solution 5
05:02
Product Sold | SUM, GROUP BY - Challenge & Solution 6
02:27
Most Hardworking Employee - Challenge & Solution 7
03:10
Check out my other courses
01:02
Viết Bình Luận
Khoá học liên quan
Đăng ký get khoá học Udemy - Unica - Gitiho giá chỉ 50k!
Get khoá học giá rẻ ngay trước khi bị fix.
Đánh giá của học viên
Bình luận khách hàng