Last updated 8/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 13.55 GB | Duration: 25h 36m
MySQL for Data Analytics, Database Management, Business Intelligence & Analysis. Master SQL & Tableau. Create Reports!

What you'll learn
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

Requirements
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

Description
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 SQLInstallation MySQLSelect StatementDatabaseTableData TypesInsert QueryCandidate, Surrogate, Primary, Alternative & Foreign KeyPrimary and Foreign Key Constraints | Alter TableAlias (AS)Concat FunctionOrder By KeywordLimit ClauseOrder By & Rand FunctionCommentsWhere ClauseIndexWildcardsUpdate Statement & Replace Functionselect Distinct StatementFormat FunctionGroup By Statement | AggregateInner JoinLeft JoinRight JoinSelf JoinTwo Tables JoinThree Tables JoinFour Tables JoinFive Tables JoinSix Tables JoinSeven Tables JoinEight Tables JoinNine Tables JoinTen Tables JoinOffset & LimitCase FunctionCast FunctionNested & Correlated SubqueriesSubqueries & Exits OperatorString FunctionSessionTable LockingTransactionViewStored Procedures (Stored Routines)User-Defined Functions (Stored Routine)TriggersCombining SQL and PythonCombining SQL and TableauResearch Data Set - Real-World DatasetsCAR SHOP DATA SET - Real-World DatasetsCAMERA SUPPLIERS - Real-World DatasetsWith 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!

Overview
Section 1: Introduction, Installation, Resources, Database, Select and CRUD (Updated)

Lecture 1 Your SQL Success Starts Here: Master Complete SQL Course

Lecture 2 Introduction to SQL

Lecture 3 Installation - Introduction

Lecture 4 8 Multiple Choice on Basic SQL - MySQL - Questions

Lecture 5 8 Multiple Choice on Basic SQL - MySQL - Answers

Lecture 6 Installation - Installation of MySQL on MacOS

Lecture 7 Installation - RESOURCES: Installation of MySQL on MacOS

Lecture 8 Installation - How to fix Cannot Connect to MySQL Server - MacOS

Lecture 9 Installation - Installation of MySQL Server and Workbench on Windows

Lecture 10 Installation - How to fix Cannot Connect to MySQL Server - Windows

Lecture 11 Database - Database as a house - Introduction

Lecture 12 Database - Creating a Database

Lecture 13 Database - Creating a Database with IF NOT EXISTS

Lecture 14 Database - How to use a Database

Lecture 15 Database - Finding Out the Currently Selected Database

Lecture 16 Database - Checking If a Database Exists

Lecture 17 Database - Deleting a Database

Lecture 18 Database - Deleting a Database If It Exists

Lecture 19 18 Multiple Choice on Database - Question

Lecture 20 18 Multiple Choice on Database - Answers

Lecture 21 Select - Understanding Select Statement

Lecture 22 Resources - Databases You'll Need for this Course

Lecture 23 Resources - How to Run the Resources

Lecture 24 CRUD - Understanding CRUD

Lecture 25 5 Multiple Choice on CRUD - Questions

Lecture 26 5 Multiple Choice on CRUD - Answers

Lecture 27 Table - Introduction and Creating Basic Table in MySQL

Lecture 28 Data Types - Introduction

Section 2: ARCHIVED - SQL - Select Statement

Lecture 29 SELECT (Understanding Select for Absolute beginners)

Section 3: ARCHIVED - SQL - Database

Lecture 30 Database vs Table In SQL- Layman's Explanation - (Challenge & Solution)

Lecture 31 Creating A Database - Challenge & Solution 1

Lecture 32 CODE: Creating A Database - Challenge & Solution 1

Lecture 33 "IF NOT EXISTS" with CREATE DATABASE - Challenge & Solution 2

Lecture 34 CODE: "IF NOT EXISTS" with CREATE DATABASE - Challenge & Solution 2

Lecture 35 How To Check For Existing Databases - Challenge & Solution 3

Lecture 36 CODE: How To Check For Existing Databases - Challenge & Solution

Lecture 37 How To Delete A Database - Challenges & Solution 4

Lecture 38 CODE: How To Delete A Database - Challenges & Solution 4

Lecture 39 Using A Database - Challenge & Solution 5

Lecture 40 CODE: Using A Database - Challenge & Solution 5

Lecture 41 How To Check For The Selected Database in Use - Challenge & Solution 6

Lecture 42 CODE: How To Check For The Selected Database in Use - Challenge & Solution 6

Section 4: MySQL - Numeric Data Types (Updated)

Lecture 43 Introduction to MySQL Numeric Data Types

Lecture 44 Integer Types - INTEGER or INT, SMALLINT, TINYINT, MEDIUMINT, BIGINT

Lecture 45 Client's Integer Data Types Requirement Scenario

Lecture 46 CODE: Client's Integer Data Types Requirement Scenario

Lecture 47 Boolean Type (tinyint(1))

Lecture 48 CODE: Boolean Type (tinyint(1))

Lecture 49 20 Multiple-Choice Questions on Integer Data Types

Lecture 50 Answers - 20 Multiple-Choice Questions on Integer Data Types

Lecture 51 Fixed-Point Types - DECIMAL & NUMERIC

Lecture 52 Client's Fixed-Point Data Types Requirement Scenario

Lecture 53 CODE: Client's Fixed-Point Data Types Requirement Scenario

Lecture 54 10 Multiple-Choice Questions on Fixed-Point Data Types

Lecture 55 Answers - 10 Multiple-Choice Questions on Fixed-Point Data Types

Lecture 56 Floating-Point Types - FLOAT, DOUBLE

Lecture 57 Client's Floating-Point Data Types Requirement Scenario

Lecture 58 CODE: Client's Floating-Point Data Types Requirement Scenario

Lecture 59 10 Multiple-Choice Questions on Floating-Point Data Types

Lecture 60 Answers - 10 Multiple-Choice Questions on Floating-Point Data Types

Lecture 61 Bit-Value Type - BIT

Lecture 62 Client's Bit Data Types Requirement Scenario

Lecture 63 CODE: Client's Bit Data Types Requirement Scenario

Lecture 64 5 Multiple-Choice Questions on Bit Data Types

Lecture 65 Answers - 5 Multiple-Choice Questions on Bit Data Types

Section 5: MySQL - String Data Types (Updated)

Lecture 66 Introduction to MySQL String Data Types

Lecture 67 The CHAR and VARCHAR Types

Lecture 68 Client's CHAR and VARCHAR Types Requirement Scenario

Lecture 69 CODE: Client's CHAR and VARCHAR Types Requirement Scenario

Lecture 70 10 Multiple-Choice Questions on CHAR and VARCHAR Data Types

Lecture 71 Answers - 10 Multiple-Choice Questions on CHAR and VARCHAR Data Types

Lecture 72 The BINARY and VARBINARY Types

Lecture 73 Client's BINARY and VARBINARY Types Requirement Scenario

Lecture 74 CODE: Client's BINARY and VARBINARY Types Requirement Scenario

Lecture 75 10 Multiple-Choice Questions on BINARY and VARBINARY Data Types

Lecture 76 Answers - 10 Multiple-Choice Questions on BINARY and VARBINARY Data Types

Lecture 77 The BLOB and TEXT Types

Lecture 78 Client's BLOB and TEXT Types Requirement Scenario

Lecture 79 CODE: Client's BLOB and TEXT Types Requirement Scenario

Lecture 80 30 Multiple-Choice Questions on BLOB and TEXT Data Types

Lecture 81 Answers - 30 Multiple-Choice Questions on BLOB and TEXT Data Types

Lecture 82 ENUM Type

Lecture 83 Client's ENUM Types Requirement Scenario

Lecture 84 CODE: Client's ENUM Types Requirement Scenario

Lecture 85 10 Multiple-Choice Questions on ENUM Data Types

Lecture 86 Answers - 10 Multiple-Choice Questions on ENUM Data Types

Lecture 87 SET Type

Lecture 88 Client's SET Types Requirement Scenario

Lecture 89 CODE: Client's SET Types Requirement Scenario

Lecture 90 10 Multiple-Choice Questions on SET Data Types

Lecture 91 Answers - 10 Multiple-Choice Questions on SET Data Types

Section 6: MySQL - Date and Time Data Types (Updated)

Lecture 92 Introduction to MySQL Date & Time

Lecture 93 DATE & TIME Types

Lecture 94 Client's Date and Time Types Requirement Scenario

Lecture 95 CODE: Client's Date and Time Types Requirement Scenario

Lecture 96 20 Multiple-Choice Questions on Date and Time Data Types

Lecture 97 Answers -20 Multiple-Choice Questions on Date and Time Data Types

Section 7: MySQL - Spatial Data Types (Updated)

Lecture 98 Introduction to MySQL Spatial Types

Lecture 99 Spatial Data Types

Lecture 100 Client's Spatial Types Requirement Scenario

Lecture 101 CODE: Client's Spatial Types Requirement Scenario

Lecture 102 20 Multiple-Choice Questions on Spatial Data Types

Lecture 103 Answers - 20 Multiple-Choice Questions on Spatial Data Types

Section 8: MySQL - JSON Data Types (Updated)

Lecture 104 Understanding JSON Data Type in MySQL

Lecture 105 Client's JSON Types Requirement Scenario

Lecture 106 CODE: Client's JSON Types Requirement Scenario

Lecture 107 10 Multiple-Choice Questions on JSON Data Types

Lecture 108 Answers - 10 Multiple-Choice Questions on JSON Data Types

Section 9: ARCHIVED - SQL - Data Types

Lecture 109 Type of Data in MySQL

Lecture 110 MySQL Numeric Types

Lecture 111 TINYINT, SMALLINT, MEDIUMINT, INTEGER, BIGINT -Exact Numeric Data Types in MySQL

Lecture 112 DECIMAL & NUMERIC - Fixed Point Data Types in MySQL | Approximate Numeric I

Lecture 113 DECIMAL & NUMERIC - Fixed Point Data Types in MySQL | Approximate Numeric II

Lecture 114 REAL, FLOAT, DOUBLE - Floating Point Data Type in MySQL

Lecture 115 CHAR vs VARCHAR - String Data Types in MySQL

Lecture 116 BINARY & VARBINARY - String Data Types in MySQL

Lecture 117 BLOB & TEXT - String Data Types in MySQL

Lecture 118 ENUM - String Data Types in MySQL

Lecture 119 SET - String Data Types in MySQL

Lecture 120 DATE, TIME, DATETIME, TIMESTAMP & YEAR - Date and Time Data Types in MySQL

Section 10: MySQl - Auto_Increment & WHERE (In Brief)

Lecture 121 MySQL Auto Increment

Lecture 122 MySQL Default

Lecture 123 MySQL Null and NOT Null

Lecture 124 WHERE - A brief Intro

Section 11: MySQL - Insert Query (Updated)

Lecture 125 SQL Basic Insert

Lecture 126 SQL Inserting Multiple Rows at Once

Lecture 127 SQL Inserting Data from Another Table

Lecture 128 SQL Inserting with a Set Clause

Section 12: ARCHIVED - SQL - Insert Query

Lecture 129 Inserting A Single Line of Data Into Table - 1st Method

Lecture 130 CODE: Inserting A Single Line of Data Into Table - 1st Method

Lecture 131 Inserting A Single Line of Data Into Table - 2nd Method

Lecture 132 CODE: Inserting A Single Line of Data Into Table - 2nd Method

Lecture 133 Inserting Multiple Lines of Data Into Table - 1st Method

Lecture 134 CODE: Inserting Multiple Lines of Data Into Table - 1st Method

Lecture 135 Inserting Multiple Lines of Data Into Table - 2nd Method

Lecture 136 CODE: Inserting Multiple Lines of Data Into Table - 2nd Method

Lecture 137 Inserting Multiple Lines of Data Into Table - 3rd Method

Lecture 138 CODE: Inserting Multiple Lines of Data Into Table - 3rd Method

Lecture 139 Inserting Null Value and Empty White Space Into Table

Lecture 140 CODE: Inserting Null Value and Empty White Space Into Table

Section 13: SQL - Candidate, Surrogate, Primary, Unique, Natural & Foreign Key (Updated)

Lecture 141 Introductions to Keys in SQL

Lecture 142 Unique Key in SQL

Lecture 143 Primary Key in SQL

Lecture 144 Candidate and Alternate Keys in SQL

Lecture 145 Composite - Compound - Key in SQL

Lecture 146 Natural Key in SQL

Lecture 147 Surrogate Key in SQL

Lecture 148 Super Key in SQL

Lecture 149 Foreign Key in SQL

Lecture 150 41 Multiple-Choice Questions on different types of SQL Keys

Lecture 151 Answers - 41 Multiple-Choice Questions on different types of SQL Keys

Section 14: ARCHIVED - SQL - Candidate, Surrogate, Primary, Alternative & Foreign Keys

Lecture 152 Candidate Key In SQL

Lecture 153 Surrogate Key In SQL

Lecture 154 Primary Key & Alternative Key In SQL

Lecture 155 Foreign Key In SQL

Section 15: SQL - Alter Table (UPDATED)

Lecture 156 Alter Table - Intro & Adding a New Column

Lecture 157 Alter Table - Dropping an Existing Column

Lecture 158 Alter Table - Modify Column Type and Size

Lecture 159 Alter Table - Drop Primary Key

Lecture 160 Alter Table - Add Primary Key

Lecture 161 Alter Table - Add Unique Constraint

Lecture 162 Alter Table - Rename Column

Lecture 163 Alter Table - Add Foreign Key

Lecture 164 Alter Table - Rename Table

Lecture 165 Alter Table - Add Default to Column

Lecture 166 Alter Table - Drop Default from a Column

Lecture 167 Alter Table - Drop Foreign Key

Section 16: SQL - Deleting Records

Lecture 168 Introduction to delete & Deleting Specific Records

Lecture 169 Delete multiple records

Lecture 170 Delete all records

Lecture 171 Truncate Table

Lecture 172 Deleting a Table

Lecture 173 Delete Cascade

Section 17: ARCHIVED - SQL - Primary and Foreign Key Constraints | Alter Table

Lecture 174 Assigning A PRIMARY KEY (Three Methods) - Challenge & Solution 1

Lecture 175 CODE: Assigning A PRIMARY KEY (Three Methods) - Challenge & Solution

Lecture 176 Deleting A PRIMARY KEY - Challenge & Solution 2

Lecture 177 CODE: Deleting A PRIMARY KEY - Challenge & Solution 2

Lecture 178 Adding A PRIMARY KEY To Existing Column - Challenge & Solution 3

Lecture 179 CODE: Adding A PRIMARY KEY To Existing Column - Challenge & Solution 3

Lecture 180 Assigning A FOREIGN KEY - Challenge & Solution 4

Lecture 181 CODE: Assigning A FOREIGN KEY - Challenge & Solution 4

Lecture 182 Assigning A CONSTRAINT NAME To A FOREIGN KEY - Challenge & Solution 5

Lecture 183 CODE: Assigning A CONSTRAINT NAME To A FOREIGN KEY - Challenge & Solution 5

Lecture 184 Adding A FOREIGN KEY To Existing Table - Challenge & Solution 6

Lecture 185 CODE: Challenge & Solution 6 | Adding A FOREIGN KEY To Existing Table

Lecture 186 Challenge & Solution 7 | CONSTRAINT NAME & FOREIGN KEY To Existing Table

Lecture 187 CODE:CONSTRAINT NAME & FOREIGN KEY To Existing Table - Challenge & Solution 7

Lecture 188 Deleting A REFERENCED Parent Table - Challenge & Solution 8

Lecture 189 CODE: Deleting A REFERENCED Parent Table - Challenge & Solution 8

Lecture 190 Deleting A Column From A Table - Challenge & Solution 9

Lecture 191 CODE: Deleting A Column From A Table - Challenge & Solution 9

Lecture 192 Deleting A REFERENCED or CONSTRAINT Column - Challenge & Solution 10

Lecture 193 CODE: Deleting A REFERENCED or CONSTRAINT Column - Challenge & Solution 10

Section 18: SQL - Revisiting Select Statement

Lecture 194 Select All Rows and Columns - Challenge & Solution 1

Lecture 195 CODE: Select All Rows and Columns - Challenge & Solution 1

Lecture 196 Select Specific Columns - Challenge & Solution 2

Lecture 197 CODE: Select Specific Columns - Challenge & Solution 2

Lecture 198 Manager Demands for All Customers' Detail - Challenge & Solution 3

Lecture 199 CODE: Manager Demands for All Customers' Detail - Challenge & Solution 3

Lecture 200 Specific Customer's Details - Challenge & Solution 4

Lecture 201 CODE: Specific Customer's Details - Challenge & Solution 4

Section 19: SQL - Alias - AS

Lecture 202 ALIAS (AS) Introduction

Lecture 203 CODE: ALIAS (AS) Introduction

Lecture 204 Alias - Challenge & Solution

Lecture 205 CODE: Alias - Challenge & Solution

Section 20: SQL - Concat Function

Lecture 206 CONCAT() Introduction

Lecture 207 CODE: CONCAT() Introduction

Lecture 208 CONCAT() - Challenge & Solution 1

Lecture 209 CODE: Challenge & Solution 1 | CONCAT()

Lecture 210 CONCAT() - Challenge & Solution 2

Lecture 211 CODE: Challenge & Solution 2 | CONCAT()

Section 21: SQL - Order By Keyword

Lecture 212 ORDER BY Introduction

Lecture 213 ORDER BY ASC - Challenge & Solution 1

Lecture 214 CODE: ORDER BY ASC - Challenge & Solution 1

Lecture 215 ORDER BY DESC - Challenge & Solution 2

Lecture 216 CODE: ORDER BY DESC - Challenge & Solution 2

Lecture 217 ORDER BY DESC & CONCAT - Challenge & Solution 3

Lecture 218 CODE: ORDER BY DESC & CONCAT - Challenge & Solution 3

Lecture 219 ORDER BY ASC - Challenge & Solution 4

Lecture 220 CODE: ORDER BY ASC - Challenge & Solution 4

Section 22: SQL - Limit Clause

Lecture 221 LIMIT - Challenge & Solution 1

Lecture 222 CODE: LIMIT - Challenge & Solution 1

Lecture 223 LIMIT - Challenge & Solution 2

Lecture 224 CODE: LIMIT - Challenge & Solution 2

Lecture 225 LIMIT - Challenge & Solution 3

Lecture 226 CODE: LIMIT - Challenge & Solution 3

Section 23: SQL - Order By & Rand Function

Lecture 227 ORDER BY with RAND - Challenge & Solution

Lecture 228 CODE: ORDER BY with RAND - Challenge & Solution

Section 24: SQL - Comments

Lecture 229 SINGLE & MULTILINE COMMENTS in SQL-MySQL

Section 25: SQL - Where Clause

Lecture 230 Introduction to WHERE

Lecture 231 Northwind Data Set | Should run to work along

Lecture 232 UK Customers filter - Challenge & Solution 1

Lecture 233 CODE: UK Customers filter - Challenge & Solution 1

Lecture 234 Specific Customer filter - Challenge & Solution 2

Lecture 235 CODE: Specific Customer filter - Challenge & Solution 2

Lecture 236 Specific Employee filter - Challenge & Solution 3

Lecture 237 CODE: Specific Employee filter - Challenge & Solution 3

Lecture 238 Product with specific Price filter - Challenge & Solution 4

Lecture 239 CODE: Product with specific Price filter - Challenge & Solution 4

Lecture 240 Getting a list of Sales Representatives - Challenge & Solution 5

Lecture 241 CODE: Getting a list of Sales Representatives - Challenge & Solution 5

Lecture 242 None Spanish Customers using != , <> - Challenge & Solution 6

Lecture 243 CODE: None Spanish Customers using != , <> - Challenge & Solution 6

Lecture 244 Products Supplied by a Specific Customer - Challenge & Solution 7

Lecture 245 CODE: Products Supplied by a Specific Customer - Challenge & Solution 7

Lecture 246 All Suppliers Except... using NOT, <>, ! - Challenge & Solution 8

Lecture 247 CODE: All Suppliers Except... using NOT, <>, ! - Challenge & Solution 8

Lecture 248 Products above certain Price | Greater Than > - Challenge & Solution 9

Lecture 249 CODE: Products above certain Price | Greater Than > - Challenge & Solution 9

Lecture 250 Products Below Certain Price| Less Than < - Challenge & Solution 10

Lecture 251 CODE: Products Below Certain Price| Less Than < - Challenge & Solution 10

Lecture 252 Unit In Stock | Less Than < - Challenge & Solution 11

Lecture 253 CODE:Unit In Stock | Less Than < - Challenge & Solution 11

Lecture 254 Minimum Wages | Less Than < - Challenge & Solution 12

Lecture 255 CODE: Minimum Wages | Less Than < - Challenge & Solution 12

Lecture 256 Gifts for Customers | Greater Than - Challenge & Solution 13

Lecture 257 CODE: Gifts for Customers | Greater Than - Challenge & Solution 13

Lecture 258 Units In Stock | Less Than - Challenge & Solution 14

Lecture 259 CODE: Units In Stock | Less Than - Challenge & Solution 14

Lecture 260 San Francisco Customers | AND - Challenge & Solution 15

Lecture 261 CODE: San Francisco Customers | AND - Challenge & Solution 15

Lecture 262 Specific Mexico Customers | AND - Challenge & Solution 16

Lecture 263 CODE: Specific Mexico Customers | AND - Challenge & Solution 16

Lecture 264 None USA and UK Customers | NOT, !=, <> - Challenge & Solution 17

Lecture 265 CODE: None USA and UK Customers | NOT, !=, <> - Challenge & Solution 17

Lecture 266 Brazil and Venezuela Customers | OR - Challenge & Solution 18

Lecture 267 CODE: Brazil and Venezuela Customers | OR - Challenge & Solution 18

Lecture 268 Range of Suppliers | BETWEEN - Challenges & Solution 19

Lecture 269 CODE: Range of Suppliers | BETWEEN - Challenges & Solution 19

Lecture 270 Suppliers | Combining <, > & OR - Challenge & Solution 20

Lecture 271 CODE: Suppliers | Combining <, > & OR - Challenge & Solution 20

Lecture 272 Range of Suppliers using BETWEEN - Challenge & Solution 21

Lecture 273 CODE: Range of Suppliers using BETWEEN - Challenge & Solution 21

Lecture 274 NOT BETWEEN - Challenge & Solution 22

Lecture 275 CODE: NOT BETWEEN - Challenge & Solution 22

Lecture 276 Customers in Paris & Nantes, France - Challenge & Solution 23

Lecture 277 CODE: Customers in Paris & Nantes, France - Challenge & Solution 23

Lecture 278 Product List | BETWEEN, CONCAT, FORMAT, ORDER BY - Challenge & Solution 24

Lecture 279 CODE: Product List | BETWEEN, CONCAT, FORMAT, ORDER BY - Challenge & Solution 24

Lecture 280 NULL values | IS NULL, IS NOT NULL - Challenge & Solution 25

Lecture 281 CODE: NULL values | IS NULL, IS NOT NULL - Challenge & Solution 25

Lecture 282 Employees Report to #2 | IS NOT NULL - Challenge & Solution 26

Lecture 283 CODE: Employees Report to #2 | IS NOT NULL - Challenge & Solution 26

Lecture 284 IN and WHERE - Challenge & Solution 27

Lecture 285 CODE: IN and WHERE - Challenge & Solution 27

Lecture 286 NOT IN - UK, Germany & France Customers - Challenge & Solution 28

Lecture 287 CODE: NOT IN - UK, Germany & France Customers - Challenge & Solution 28

Section 26: SQL - Index

Lecture 288 Introduction to MySQL Index

Lecture 289 Creating Index Along a Table

Lecture 290 Code: Creating Index Along a Table

Lecture 291 Creating Index on Existing Column

Lecture 292 CODE: Creating Index on Existing Column

Lecture 293 Understanding Primary or Clustered Index

Lecture 294 Unique Key vs Index

Lecture 295 Key vs Index

Lecture 296 Verifying Index

Lecture 297 CODE: Verifying Index

Lecture 298 Confirming the "Power" of Index

Lecture 299 CODE: Confirming the "Power" of Index

Lecture 300 Deleting Index

Lecture 301 CODE: Deleting Index

Section 27: SQL - Wildcards

Lecture 302 Introduction to MySQL Wildcards

Lecture 303 MySQL Wildcard - Customers Start With P - Challenges & Solution 1

Lecture 304 CODE: MySQL Wildcard - Customers Start With P - Challenges & Solution 1

Lecture 305 MySQL Wildcard | Employees In Sales - Challenges & Solution 2

Lecture 306 CODE: MySQL Wildcard | Employees In Sales - Challenges & Solution 2

Lecture 307 MySQL Wildcard | Phone Number Pattern - Challenges & Solution 3

Lecture 308 CODE: MySQL Wildcard | Phone Number Pattern - Challenges & Solution 3

Lecture 309 MySQL Wildcard - Customers In Restaurant Business - Challenges & Solution 4

Lecture 310 CODE: MySQL Wildcard - Customers In Restaurant Business - Challenges & Solution

Lecture 311 MySQL Wildcard - NOT LIKE - -Challenges & Solution 5

Lecture 312 CODE: MySQL Wildcard - NOT LIKE - -Challenges & Solution 5

Section 28: SQL - Update Statement & Replace Function

Lecture 313 Updating a Single Value in a Table

Lecture 314 CODE: Updating a Single Value in a Table

Lecture 315 Updating Multiple Values in a Table

Lecture 316 CODE: Updating Multiple Values in a Table

Lecture 317 Using UPDATE with REPLACE

Lecture 318 CODE: Using UPDATE with REPLACE

Lecture 319 What is Storage Engine - Let's Digress a little 

Section 29: SQL - Select Distinct Statement

Lecture 320 DISTINCT - How it works

Lecture 321 CODE: DISTINCT - How it works

Lecture 322 DISTINCT, ORDER BY DESC, WHERE, IS NOT - Challenge & Solution

Lecture 323 CODE: DISTINCT, ORDER BY DESC, WHERE, IS NOT - Challenge & Solution

Section 30: SQL - Format Function

Lecture 324 How Format() Function Works

Lecture 325 CODE: How Format() Function Works

Lecture 326 Data Cleaning | Format - Challenge & Solution

Lecture 327 CODE: Data Cleaning | Format - Challenge & Solution

Section 31: SQL - Group By Statement | Aggregate

Lecture 328 GROUP BY - True Meaning

Lecture 329 MIN(), MAX(), AVG(), SUM() & GROUP BY - Challenge & Solution 1

Lecture 330 CODE: MIN(), MAX(), AVG(), SUM() & GROUP BY - Challenge & Solution 1

Lecture 331 GROUP BY / SUM,MIN,AVG / CONCAT / FORMAT - Challenge & Solution 2

Lecture 332 CODE: GROUP BY / SUM,MIN,AVG / CONCAT / FORMAT - Challenge & Solution 2

Lecture 333 Region Count | GROUP BY, COUNT - Challenge & Solution 3

Lecture 334 CODE: Region Count | GROUP BY, COUNT - Challenge & Solution 3

Lecture 335 Row / Unique Value Count | GROUP BY, COUNT - Challenge & Solution 4

Lecture 336 CODE: Row / Unique Value Count | GROUP BY, COUNT - Challenge & Solution 4

Lecture 337 Product Count | COUNT, GROUP BY, ORDER BY - Challenge & Solution 5

Lecture 338 CODE: Product Count | COUNT, GROUP BY, ORDER BY - Challenge & Solution 5

Lecture 339 Product Sold | SUM, GROUP BY - Challenge & Solution 6

Lecture 340 CODE: Product Sold | SUM, GROUP BY - Challenge & Solution 6

Lecture 341 Most Hardworking Employee - Challenge & Solution 7

Lecture 342 CODE: Most Hardworking Employee - Challenge & Solution 7

Section 32: SQL - Joins (Made Easy)

Lecture 343 Resource for JOIN

Lecture 344 Purpose of JOIN in SQL

Lecture 345 Type of JOIN in SQL

Lecture 346 Understanding INNER JOIN

Lecture 347 Understanding LEFT JOIN

Lecture 348 Understanding RIGHT JOIN

Lecture 349 Understanding FULL JOIN

Section 33: SQL - Joins (Deep Dive)

Lecture 350 Overview of Tables & Code for JOIN Demonstration

Lecture 351 CODE: Overview of Tables & Code for JOIN Demonstration

Lecture 352 INNER JOIN - DEEP DIVE

Lecture 353 CODE: INNER JOIN - DEEP DIVE

Lecture 354 LEFT JOIN - DEEP DIVE

Lecture 355 CODE: LEFT JOIN - DEEP DIVE

Lecture 356 RIGHT JOIN - DEEP DIVE

Lecture 357 CODE: RIGHT JOIN - DEEP DIVE

Lecture 358 More On RIGHT JOIN and LEFT JOIN | with Shipper & Orders tables

Lecture 359 CODE:More On RIGHT JOIN and LEFT JOIN | with Shipper & Orders tables

Lecture 360 Table.Column vs Column only?

Section 34: SQL - Joins "On" vs "Where" | "On" vs "Using"

Lecture 361 ON vs WHERE in INNER, LEFT & RIGHT JOIN

Lecture 362 "ON" vs "USING" in SQL JOIN Statement

Section 35: SQL - Joins Challenges & Solutions

Lecture 363 JOIN for Orders Handled/Managed By Employee - Challenge & Solution 1

Lecture 364 CODE: JOIN for Orders Handled/Managed By Employee - Challenge & Solution 1

Lecture 365 Using JOIN for Products & Their Suppliers - Challenge & Solution 2

Lecture 366 CODE: Using JOIN for Products & Their Suppliers - Challenge & Solution 2

Lecture 367 JOIN for Customers and Shippers - Challenge & Solution 3

Lecture 368 CODE: JOIN for Customers and Shippers - Challenge & Solution 3

Lecture 369 JOIN Many Tables - Customers and Names of Shipper - Challenge & Solution 4

Lecture 370 CODE: JOIN Many Tables - Customers and Names of Shipper -Challenge & Solution 4

Section 36: SQL - Joining 1, 2, 3, 4, 5, 6, 7, 8, 9 & 10 Tables

Lecture 371 Please Read Me!

Lecture 372 Schema

Lecture 373 Simplifying the Schema used for JOIN in the following sections.

Section 37: SQL - One Table Join (Self Join)

Lecture 374 Self-Join | One Table Join - Challenge and Solution 1

Lecture 375 CODE: Self-Join | One Table Join - Challenge and Solution 1

Section 38: SQL - Two Tables Join

Lecture 376 Two Tables Join - Challenge and Solution 2

Lecture 377 CODE: Two Tables Join - Challenge and Solution 2

Lecture 378 Two Tables Join - Challenge and Solution 3

Lecture 379 CODE: Two Tables Join - Challenge and Solution 3

Lecture 380 Two Tables Join - Challenge and Solution 4

Lecture 381 CODE: Two Tables Join - Challenge and Solution 4

Lecture 382 Two Tables Join - Challenge and Solution 5

Lecture 383 CODE: Two Tables Join - Challenge and Solution 5

Section 39: SQL - Three Tables Join

Lecture 384 Three Table Joins - Challenge and Solution 6

Lecture 385 CODE: Three Tables Join - Challenge and Solution 6

Lecture 386 Three Tables Join - Challenge and Solution 7

Lecture 387 CODE: Three Tables Join - Challenge and Solution 7

Section 40: SQL - Four Tables Joins

Lecture 388 Four Tables Join - Challenge and Solution 8

Lecture 389 CODE: Four Tables Join - Challenge and Solution 8

Section 41: SQL - Five Tables Join

Lecture 390 Five Tables Join - Challenge and Solution 9

Lecture 391 CODE: Five Tables Join - Challenge and Solution 9

Lecture 392 Five Tables Join - Challenge and Solution 10

Lecture 393 CODE: Five Tables Join - Challenge and Solution 10

Section 42: SQL - Six Tables Join

Lecture 394 Six Tables Join - Challenge and Solution 11

Lecture 395 CODE: Six Tables Join - Challenge and Solution 11

Section 43: SQL - Seven Tables Join

Lecture 396 Seven Tables Join - Challenge and Solution 12

Lecture 397 CODE: Seven Tables Join - Challenge and Solution 12

Section 44: SQL - Eight Tables Join

Lecture 398 Eight Tables Join - Challenge and Solution 13

Lecture 399 CODE: Eight Tables Join - Challenge and Solution 13

Section 45: SQL - Nine Tables Join

Lecture 400 Nine Tables Join - Challenge and Solution 14

Lecture 401 CODE: Nine Tables Join - Challenge and Solution 14

Section 46: SQL - Ten Tables Join

Lecture 402 Ten Tables Join - Challenge and Solution | For Demonstration Purpose

Lecture 403 CODE: Ten Tables Join - Challenge and Solution 15

Section 47: SQL - Offset & Limit

Lecture 404 Offset & Limit - Challenge & Solution 1

Lecture 405 CODE: Offset & Limit - Challenge & Solution 1

Lecture 406 Offset & Limit | Third Highest Purchase - Challenge & Solution 2

Lecture 407 CODE: Offset & Limit | Third Highest Purchase - Challenge & Solution 2

Lecture 408 Offset & Limit | First Three Highest Salary - Challenge & Solution 3

Lecture 409 CODE: Offset & Limit | First Three Highest Salary - Challenge & Solution 3

Lecture 410 Offset & Limit - Fourth to the Lowest Salary - Challenge & Solution 4

Lecture 411 CODE: Offset & Limit - Fourth to the Lowest Salary - Challenge & Solution 4

Lecture 412 OFFSET & LIMIT | First and Third Bestselling Products - Challenge & Solution 5

Lecture 413 CODE: OFFSET & LIMIT | First and Third Bestselling Products - Challenge & Soluti

Section 48: SQL - Case Function

Lecture 414 Understanding MySQL CASE

Lecture 415 CODE: Understanding MySQL CASE

Lecture 416 CASE with IS NULL

Lecture 417 CODE: CASE with IS NULL

Lecture 418 CASE FOR TYPE OF CUSTOMERS

Lecture 419 CODE: CASE FOR TYPE OF CUSTOMERS

Section 49: SQL - Cast Function

Lecture 420 CAST - FROM STRING to DATE

Lecture 421 CODE: CAST - FROM STRING to DATE

Lecture 422 CAST - FROM INTEGER to CHAR - Challenge & Solution 2

Lecture 423 CODE: CAST - FROM INTEGER to CHAR - Challenge & Solution 2

Lecture 424 CAST | FROM STRING to DATE & TIME - Challenge & Solution 3

Lecture 425 CODE: CAST | FROM STRING to DATE & TIME - Challenge & Solution 3

Lecture 426 CAST | FROM STRING to TIME - Challenge & Solution 4

Lecture 427 CODE: CAST | FROM STRING to TIME - Challenge & Solution 4

Lecture 428 CAST | Order Date Without time - Challenge & Solution 5

Lecture 429 CODE: CAST | Order Date Without time - Challenge & Solution 5

Lecture 430 CAST | FROM DATE to DATETIME - Challenge & Solution 6

Lecture 431 CODE: CAST | FROM DATE to DATETIME - Challenge & Solution 6

Section 50: SQL - Nested & Correlated Subqueries

Lecture 432 Introduction to subqueries

Lecture 433 Aggregate Function with Subqueries

Lecture 434 Nested Subquery - Challenge & Solution 1

Lecture 435 Many Subqueries - Challenges & Solution 2

Section 51: SQL - Subqueries & Exists Operator

Lecture 436 Exists Operator

Lecture 437 Subquery & Exists - Challenge & Solution 1

Lecture 438 CODE: Subquery & Exists - Challenge & Solution 1

Lecture 439 Subquery & Exists - Challenge & Solution 2

Lecture 440 CODE: Subquery & Exists - Challenge & Solution 2

Section 52: Difference Between Nested and Correlated Subqueries

Lecture 441 Difference Between Nested and Correlated Subqueries

Section 53: SQL - String Functions

Lecture 442 SPACE FUNCTION | Challenge & Solution 1

Lecture 443 SPACE FUNCTION | Challenge & Solution 2

Lecture 444 REPEAT FUNCTION | Challenge & Solution 3

Lecture 445 REPEAT FUNCTION | Challenge & Solution 4

Lecture 446 REPLACE FUNCTION | Challenge & Solution 5

Lecture 447 REPLACE FUNCTION | Challenge & Solution 6

Lecture 448 REPLACE FUNCTION | Challenge & Solution 7

Lecture 449 REVERSE FUNCTION | Challenge & Solution 8

Lecture 450 REVERSE FUNCTION | Challenge & Solution 9

Lecture 451 LEFT FUNCTION | Challenge & Solution 10

Lecture 452 LEFT FUNCTION | Challenge & Solution 11

Lecture 453 RIGHT FUNCTION | Challenge & Solution 12

Lecture 454 RIGHT FUNCTION | Challenge & Solution 13

Lecture 455 RPAD FUNCTION | Challenge & Solution 14

Lecture 456 RPAD FUNCTION | Challenge & Solution 15

Lecture 457 LPAD FUNCTION | Challenge & Solution 16

Lecture 458 LPAD FUNCTION | Challenge & Solution 17

Lecture 459 LPAD FUNCTION | Challenge & Solution 18

Lecture 460 POSITION & LOCATION FUNCTIONS | Challenge & Solution 19

Lecture 461 POSITION & LOCATION FUNCTIONS | Challenge & Solution 20

Lecture 462 SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 21

Lecture 463 SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 22

Lecture 464 SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 23

Lecture 465 SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 24

Lecture 466 SUBSTRING_INDEX FUNCTION | Challenge & Solution 25

Lecture 467 SUBSTRING_INDEX FUNCTION | Challenge & Solution 26

Lecture 468 SUBSTRING_INDEX FUNCTION | Challenge & Solution 27

Lecture 469 SUBSTRING_INDEX FUNCTION | Challenge & Solution 28

Lecture 470 SUBSTRING_INDEX FUNCTION | Challenge & Solution 29

Lecture 471 MID FUNCTION | Challenge & Solution 30

Lecture 472 MID FUNCTION | Challenge & Solution 31

Lecture 473 INSERT FUNCTION | Challenge & Solution 32

Lecture 474 INSERT FUNCTION | Challenge & Solution 33

Lecture 475 INSTR FUNCTION | Challenge & Solution 34

Lecture 476 INSTR FUNCTION | Challenge & Solution 35

Lecture 477 LCASE & LOWER FUNCTION | Challenge & Solution 35

Lecture 478 LCASE & LOWER FUNCTION | Challenge & Solution 36

Lecture 479 UCASE & UPPER FUNCTION | Challenge & Solution 37

Lecture 480 UCASE & UPPER FUNCTION | Challenge & Solution 38

Lecture 481 UCASE & UPPER FUNCTION | Challenge & Solution 39

Lecture 482 LENGTH FUNCTION | Challenge & Solution 40

Lecture 483 LENGTH FUNCTION | Challenge & Solution 41

Lecture 484 LTRIM FUNCTION | Challenge & Solution 42

Lecture 485 LTRIM FUNCTION | Challenge & Solution 43

Lecture 486 RTRIM FUNCTION | Challenge & Solution 44

Lecture 487 RTRIM FUNCTION | Challenge & Solution 45

Lecture 488 TRIM FUNCTION | Challenge & Solution 45

Lecture 489 TRIM FUNCTION | Challenge & Solution 46

Section 54: SQL - Session

Lecture 490 Understanding MySQL Session

Lecture 491 CODE: Understanding MySQL Session

Section 55: SQL - Table Locking

Lecture 492 Table Locking Intro

Lecture 493 Table Locking Demonstration

Lecture 494 CODE: Table Locking Demonstration

Section 56: SQL - Transaction

Lecture 495 Brief Introduction to SQL Transaction

Lecture 496 TRANSACTION components - START, BEGIN, BEGIN WORK, COMMIT, ROLLBACK, SET

Lecture 497 CODE: TRANSACTION components - START, BEGIN, BEGIN WORK, COMMIT, ROLLBACK, SET

Lecture 498 TRANSACTION By Example

Lecture 499 CODE: TRANSACTION By Example

Lecture 500 NOT USING TRANSACTION

Lecture 501 CODE: NOT USING TRANSACTION

Lecture 502 ROLLBACK

Lecture 503 CODE: ROLLBACK

Section 57: SQL - View

Lecture 504 Meaning of VIEW

Lecture 505 CODE: Meaning of VIEW

Lecture 506 VIEW for Sales Manager | Challenge & Solution 1

Lecture 507 CODE: VIEW for Sales Manager | Challenge & Solution 1

Lecture 508 VIEW for Employees hired in 1994 | Challenge & Solution 2

Lecture 509 CODE: VIEW for Employees hired in 1994 | Challenge & Solution 2

Lecture 510 Updating VIEW | Challenge & Solution 3

Lecture 511 CODE: Updating VIEW | Challenge & Solution 3

Lecture 512 A Mistake In VIEW | Challenge & Solution 4

Lecture 513 CODE: A Mistake In VIEW | Challenge & Solution 4

Lecture 514 Deleting a VIEW - Challenge & Solution 5

Lecture 515 CODE: Deleting a VIEW - Challenge & Solution 5

Lecture 516 VIEW for Japan Suppliers - Challenge & Solution 6

Lecture 517 CODE: VIEW for Japan Suppliers - Challenge & Solution 6

Lecture 518 WHERE with Normal Table & VIEW Table - Challenge & Solution 7

Lecture 519 CODE: WHERE with Normal Table & VIEW Table - Challenge & Solution 7

Lecture 520 INNER JOIN with Normal Table & VIEW Table - Challenge & Solution 8

Lecture 521 CODE: INNER JOIN with Normal Table & VIEW Table - Challenge & Solution 8

Section 58: SQL - Stored Procedures (Stored Routines)

Lecture 522 What is the meaning and purpose of Stored Procedure

Lecture 523 CODE: What is the meaning and purpose of Stored Procedure

Lecture 524 How to create STORED PROCEDURE for cars table - Challenge & Solution 2

Lecture 525 CODE: How to create STORED PROCEDURE for cars table - Challenge & Solution 2

Lecture 526 How to Modify STORED PROCEDURE | Tesla Vehicles - Challenge & Solution 3

Lecture 527 CODE: How to Modify STORED PROCEDURE | Tesla Vehicles - Challenge & Solution 3

Lecture 528 How to check for STORED PROCEDURE across databases - Challenge & Soln 4

Lecture 529 CODE: How to check for STORED PROCEDURE across databases - Challenge & Soln 4

Lecture 530 Check for STORED PROCEDURE in the current database - Challenge & Solution 5

Lecture 531 CODE: Check for STORED PROCEDURE in the current database - Challenge & Soln 5

Lecture 532 Check for STORED PROCEDURE in a specified database - Challenge & Soln 6

Lecture 533 CODE: Check for STORED PROCEDURE in a specified database - Challenge & Soln 6

Lecture 534 Deleting a STORED PROCEDURE - Challenge & Solution 7

Lecture 535 CODE: Deleting a STORED PROCEDURE - Challenge & Solution 7

Lecture 536 STORED PROCEDURE - Helping Purchasing Manager - Challenge & Solution 8

Lecture 537 CODE: STORED PROCEDURE - Helping Purchasing Manager - Challenge & Solution 8

Lecture 538 STORED PROCEDURE for Most Expensive Car - Challenge & Solution 9

Lecture 539 CODE: STORED PROCEDURE for Most Expensive Car - Challenge & Solution 9

Lecture 540 STORED PROCEDURE for DATA INSERT to a table - Challenge & Solution 10

Lecture 541 CODE: STORED PROCEDURE for DATA INSERT to a table - Challenge & Solution 10

Section 59: SQL - User-defined Functions (Stored Routine)

Lecture 542 What is FUNCTION in SQL

Lecture 543 CODE: What is FUNCTION in SQL

Lecture 544 Creating Addition FUNCTION - Challenge & Solution 2

Lecture 545 CODE: Creating Addition FUNCTION - Challenge & Solution 2

Lecture 546 How to check for FUNCTION - Challenge & Solution 3

Lecture 547 CODE: How to check for FUNCTION - Challenge & Solution 3

Lecture 548 Creating Pythagoras Theorem FUNCTION - Challenge & Solution 4

Lecture 549 CODE: Creating Pythagoras Theorem FUNCTION - Challenge & Solution 4

Lecture 550 Altering or Updating FUNCTION - Challenge & Solution 5

Lecture 551 CODE: Altering or Updating FUNCTION - Challenge & Solution 5

Lecture 552 Creating FUNCTION for Order details Line Total - Challenge & Solution 6

Lecture 553 CODE: Creating FUNCTION for Order details Line Total - Challenge & Solution 6

Lecture 554 Deleting a FUNCTION - Challenge & Solution 7

Lecture 555 CODE: Deleting a FUNCTION - Challenge & Solution 7

Section 60: SQL - Triggers

Lecture 556 The Purpose, The How and Types of TRIGGER

Lecture 557 TRIGGER - More Explanation With Diagram

Lecture 558 Steps to Creating a TRIGGER - Challenge & Solution 1a

Lecture 559 Creating After Update TRIGGER - Challenge & Solution 1b

Lecture 560 CODE: Creating After Update TRIGGER - Challenge & Solution 1b

Lecture 561 How to Check and Delete a TRIGGER - Challenge & Solution 1c

Lecture 562 CODE: How to Check and Delete a TRIGGER - Challenge & Solution 1c

Lecture 563 Creating After Update TRIGGER - Another Method - Challenge & Solution 1d

Lecture 564 CODE: Creating After Update TRIGGER - Another Method - Challenge & Solution 1d

Lecture 565 Creating Conditional Update TRIGGER | Different Names - Challenge & Solution 2

Lecture 566 CODE: Creating Conditional Update TRIGGER | Different Names - Challenge & Soln 2

Lecture 567 Creating AfterUpdate MySQL TRIGGER | Above USD$5k - Challenge & Solution 3

Lecture 568 CODE: Creating AfterUpdate MySQL TRIGGER | Above USD$5k - Challenge & Solution 3

Lecture 569 After Insert Error Message MySQL TRIGGER - Challenge & Solution 4

Lecture 570 CODE: After Insert Error Message MySQL TRIGGER - Challenge & Solution 4

Lecture 571 TRIGGER with SIGNAL SQLSTATE for Null Value - Challenge & Solution 5

Lecture 572 CODE: TRIGGER with SIGNAL SQLSTATE for Null Value - Challenge & Solution 5

Lecture 573 Multiple lines of TRIGGER - Many in One - Challenge & Solution 6

Lecture 574 CODE: Multiple lines of triggers - Many in One - Challenge & Solution 6

Lecture 575 SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER - Challenge & Solution 7

Lecture 576 CODE: SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER - Challenge & Solution 7

Lecture 577 Fraud Detection - After Delete TRIGGER - Challenge & Solution 8

Lecture 578 CODE: Fraud Detection - After Delete TRIGGER - Challenge & Solution 8

Section 61: RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions

Lecture 579 Setting up database for challenges with attached downloadable resource

Lecture 580 Nested Subquery & JOIN methods | < 1million - Challenge & Solution 1

Lecture 581 CODE:Nested Subquery & JOIN methods | < 1million - Challenge & Solution 1

Lecture 582 Nested Subquery | Budget above average - Challenge & Solution 2

Lecture 583 CODE: Nested Subquery | Budget above average - Challenge & Solution 2

Lecture 584 Nested Subquery & More Query Tweaking - Challenge & Solution 3

Lecture 585 CODE: Nested Subquery & More Query Tweaking - Challenge & Solution 3

Lecture 586 Nested Subquery, INNER JOIN, GROUP BY, HAVING - Challenge & Solution 4

Lecture 587 CODE: Nested Subquery, INNER JOIN, GROUP BY, HAVING - Challenge & Solution 4

Section 62: CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions

Lecture 588 Intro

Lecture 589 CarShop Resource Details

Lecture 590 Fetching Names of Cars - Challenge & Solution 1

Lecture 591 Names & Price of Cars - Challenge & Solution 2

Lecture 592 Cars at a specific price - Challenge & Solution 3

Lecture 593 Between two prices of cars - Challenge & Solution 4

Lecture 594 Counting Cars - Challenge & Solution 5

Lecture 595 Price List of Cars - Challenge & Solution 6

Lecture 596 Price List For Cambodia Customers - Challenge & Solution 7

Lecture 597 Car Average Price - Challenge & Solution 8

Lecture 598 The most expensive car - Challenge & Solution 9

Lecture 599 Most Expensive Cars - Challenge & Solution 10

Lecture 600 Honda & Toyota - Challenge & Solution 11

Lecture 601 All details from two tables - Challenge & Solution 12

Lecture 602 Specific fields from two tables - Challenge & Solution 13

Lecture 603 Counting Cars Per Manufacturer - Challenge & Solution 14

Lecture 604 Average Price Per Manufacturer - Challenge & Solution 15

Lecture 605 Manufacturer Average Car Price Above $35,000 - Challenge & Solution 16

Lecture 606 The Cheapest Car - Challenge & Solution 17

Lecture 607 The Most Expensive Car - Challenge & Solution 18

Lecture 608 Data Insert - Challenge & Solution 19

Lecture 609 Correcting Wrong Data - Challenge & Solution 20

Lecture 610 Discounted Prices I - Challenge & Solution 21

Lecture 611 Discounted Price II - Challenge & Solution 22

Lecture 612 VIEW for price list - Challenge & Solution 23

Section 63: CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions

Lecture 613 Read Me First!

Lecture 614 What is the current database selected? - Assignment 1

Lecture 615 What is the current database selected? - Assignment 1 Solution

Lecture 616 What are the available tables in the database? - Assignment 2

Lecture 617 What are the available tables in the database? - Assignment 2 Solution

Lecture 618 Display the details of each of the table in the database - Assignment 3

Lecture 619 Display the details of each of the table in the database -Assignment 3 Solution

Lecture 620 SQL Query to retrieve data from one table - Assignment 4

Lecture 621 SQL Query to retrieve data from one table - Solution to Assignment 4

Lecture 622 Using Alias - Assignment 5

Lecture 623 Using Alias - Solution to Assignment 5

Lecture 624 Retrieving data across two tables using JOIN - Assignment 6

Lecture 625 Retrieving data across two tables using JOIN - Solution to Assignment 6

Lecture 626 Retrieving data across three tables using JOIN - Assignment 7

Lecture 627 Retrieving data across three tables using JOIN - Solution to Assignment 7

Lecture 628 Aggregate - sum, average, minimum, maximum - Assignment 8

Lecture 629 Aggregate - sum, average, minimum, maximum - Solution to Assignment 8

Lecture 630 GROUP BY & Average - Assignment 9

Lecture 631 GROUP BY & Average - Solution to Assignment 9

Lecture 632 GROUP BY; RIGHT, LEFT, INNER & NO JOIN - Assignment 10

Lecture 633 GROUP BY; RIGHT, LEFT, INNER & NO JOIN - Solution to Assignment 10

Lecture 634 VIEW for three tables JOIN - Assignment 11

Lecture 635 VIEW for three tables JOIN - Solution to Assignment 11

Lecture 636 INNER JOIN, Subquery & EXISTS - Assignment 12

Lecture 637 INNER JOIN, Subquery & EXISTS - Solution to Assignment 12

Lecture 638 Updating Table with 5% Increase in Salary - Assignment 13

Lecture 639 Updating Table with 5% Increase in Salary - Solution Assignment 13

Lecture 640 INNER JOIN and SubQuery - Assignment 14

Lecture 641 INNER JOIN and SubQuery - Solution Assignment 14

Lecture 642 INNER JOIN & AND - Assignment 15

Lecture 643 INNER JOIN & AND - Solution Assignment 15

Lecture 644 INNER JOIN & SubQuery - Assignment 16

Lecture 645 INNER JOIN & SubQuery - Solution to Assignment 16

Lecture 646 SUBQUERY & LIMIT - Assignment 17

Lecture 647 SUBQUERY & LIMIT - Solution to Assignment 17

Lecture 648 UCASE - Assignment 18

Lecture 649 UCASE - Solution to Assignment 18

Section 64: ==>>MORE TASKS (The More You Do, The More You Learn)

Lecture 650 More Tasks

Section 65: SQL - More Task 1

Lecture 651 Employees With Same Salary - Task 1

Lecture 652 Solution: Employees With Same Salary - Task 1

Lecture 653 CODE: Employees With Same Salary - Task 1

Section 66: SQL - More Task 2

Lecture 654 Duplicate Title - Task 2

Lecture 655 Solution: Duplicate Title - Task 2

Lecture 656 CODE: Duplicate Title - Task 2

Section 67: SQL - More Task 3

Lecture 657 Excluding Titles - Task 3

Lecture 658 Solution - Excluding Titles - Task 3

Lecture 659 CODE: Excluding Titles - Task 3

Section 68: SQL - More Task 4

Lecture 660 Eight & Last Alphabet 'n' - Task 4

Lecture 661 Solution: Eight & Last Alphabet 'n' - Task 4

Lecture 662 CODE: Eight & Last Alphabet 'n' - Task 4

Section 69: SQL - More Task 5

Lecture 663 Even Rows - Task 5

Lecture 664 Solution: Even Rows - Task 5

Lecture 665 CODE: Even Rows - Task 5

Section 70: SQL - More Task 6

Lecture 666 Odd Rows - Task 6

Lecture 667 Solution: Odd Rows - Task 6

Lecture 668 CODE: Odd Rows - Task 6

Section 71: SQL - More Task 7

Lecture 669 Second to Fourth - Task 7

Lecture 670 Solution: Second to Fourth - Task 7

Lecture 671 CODE: Second to Fourth - Task 7

Section 72: SQL - More Task 8

Lecture 672 Counting Employee with "SALES" - Task 8

Lecture 673 Solution: Counting Employee with "SALES" - Task 8

Lecture 674 CODE: Counting Employee with "SALES" - Task 8

Section 73: SQL - More Task 9

Lecture 675 Using Sub Query - Second to the Highest Salary - Task 9

Lecture 676 Solution: Using Sub Query - Second to the Highest Salary - Task 9

Lecture 677 CODE: Using Sub Query - Second to the Highest Salary - Task 9

Section 74: SQL - More Task 10

Lecture 678 Tricky Exercise - Task 10

Lecture 679 Solution: Tricky Exercise - Task 10

Lecture 680 CODE: Tricky Exercise - Task 10

Section 75: SQL - More Task 11

Lecture 681 Tricky Exercise - Task 11

Lecture 682 Solution: Tricky Exercise - Task 11

Lecture 683 CODE: Tricky Exercise - Task 11

Section 76: SQL - More Task 12

Lecture 684 Tricky Exercise - Task 12

Lecture 685 Solution: Tricky Exercise - Task 12

Lecture 686 CODE: Tricky Exercise - Task 12

Lecture 687 Tricky Exercise - Task 12b

Lecture 688 Solution: Tricky Exercise - Task 12b

Lecture 689 CODE: Tricky Exercise - Task 12b

Section 77: SQL - More Task 13

Lecture 690 Tricky Exercise - Task 13

Lecture 691 Solution: Tricky Exercise - Task 13

Lecture 692 CODE: Tricky Exercise - Task 13

Section 78: SQL - More Task 14

Lecture 693 Tricky Exercise - Task 14

Lecture 694 Solution: Tricky Exercise - Task 14

Lecture 695 CODE: Tricky Exercise - Task 14

Section 79: SQL - PAUSE and LEARN: Using Fewer Columns & Subquery in JOINS

Lecture 696 Using Fewer Columns From SUBQUERY With JOIN

Lecture 697 CODE: Using Fewer Columns From SUBQUERY With JOIN

Lecture 698 Using WITH, SUBQUERY & INNER JOIN

Lecture 699 CODE: Using WITH, SUBQUERY & INNER JOIN

Section 80: SQL - More Task 15

Lecture 700 Tricky Exercise - Task 15

Lecture 701 Solution: Tricky Exercise - Task 15

Lecture 702 CODE: Tricky Exercise - Task 15

Section 81: SQL - More Task 16

Lecture 703 Tricky Exercise - task 16

Lecture 704 Solution: Tricky Exercise - task 16

Lecture 705 CODE: Tricky Exercise - task 16

Section 82: SQL - More Task 17

Lecture 706 Tricky Exercise - Task 17

Lecture 707 Solution: Tricky Exercise - Task 17

Lecture 708 CODE: Tricky Exercise - Task 17

Section 83: SQL - DATE_FORMAT() <<== Understanding Me First Before Task 18)

Lecture 709 Introduction

Lecture 710 Day of the Week

Lecture 711 Day of the Month

Lecture 712 Day of the Year

Lecture 713 Week of the Year

Lecture 714 Month of the Year

Lecture 715 Year from given DateTime

Lecture 716 Second, Minute, Hour. AM and PM from DateTime

Section 84: SQL - More Task 18

Lecture 717 Tricky Exercise - Task 18

Lecture 718 Solution: Tricky Exercise - Task 18

Lecture 719 CODE: Tricky Exercise - Task 18

Section 85: ==>EXTRA SECTION! Combining SQL: MySQL and Python

Lecture 720 Introduction to Combining SQL and Python

Section 86: Combining SQL and Python - Installation of MySQL Connector

Lecture 721 Installation of MySQL Connector for Python

Lecture 722 CODE: Installation of MySQL Connector for Python

Section 87: Combining SQL and Python -Create Database & Table, Show & Describe Table

Lecture 723 Creating Database & Show Databases From Python

Lecture 724 CODE: Creating Database & Show Databases From Python

Lecture 725 Creating a Table, Show Table & Describe Table

Lecture 726 CODE: Creating a Table, Show Table & Describe Table

Section 88: Combining SQL and Python - Insert a Row, Insert Multiple Rows & Select

Lecture 727 Insert A Row of Data Into A Table & Select

Lecture 728 CODE: Insert A Row of Data Into A Table & Select

Lecture 729 Insert Multiple Rows of Data Into A Table

Lecture 730 CODE: Insert Multiple Rows of Data Into A Table

Section 89: Combining SQL and Python - Row Counting, FetchOne, FetchAll

Lecture 731 Counting the numbers of rows

Lecture 732 CODE: Counting the numbers of rows

Lecture 733 FetchOne vs FetchAll

Lecture 734 CODE: FetchOne vs FetchAll

Section 90: Combining SQL and Python - Filter, Wildcard

Lecture 735 Select Filter with Python

Lecture 736 CODE: Select Filter with Python

Lecture 737 SQL Wildcard with Python

Lecture 738 CODE: SQL Wildcard with Python

Section 91: ==>>EXTRA SECTION! Business Intelligence and Analytics with Tableau & SQL

Lecture 739 Introduction to this section

Section 92: Combining SQL and Tableau - Business Intelligence Introduction

Lecture 740 Business Intelligence - Introduction & Definition

Lecture 741 Business Intelligence Process

Section 93: Combining SQL and Tableau - Tableau Installation

Lecture 742 How to Download and Install Tableau

Section 94: Combining SQL and Tableau - What-Is-What In Tableau

Lecture 743 Tableau - What-Is-What In Tableau - I

Lecture 744 Tableau - What-Is-What In Tableau - II

Lecture 745 Tableau - What-Is-What In Tableau - III

Section 95: Combining SQL and Tableau - Connecting MySQL to Tableau

Lecture 746 Connecting MySQL to Tableau

Section 96: Combining SQL and Tableau - Database Querying & Visualisation

Lecture 747 Tableau & MySQL: Querying SQL Database from Tableau

Lecture 748 Tableau & MySQL: Visualising CarShop Dataset

Section 97: Combining SQL and Tableau - Challenge & Solution

Lecture 749 Tableau & SQL Challenge - Gross Sales and Net Sales Report

Section 98: Congratulation !

Lecture 750 Check out my other courses

All Levels - Beginners, Intermediate & Experts