Sql–Mysql Complete Master Bootcamp | Beginner-Expert (2023)

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: Course Walkthrough, Case Study Demos & Introduction

Lecture 1 Course Syllabus Walkthrough

Lecture 2 For Absolute Beginner: SQL vs MySQL vs DBMS and Database vs Data

Lecture 3 For Absolute Beginner: Why Choosing MySQL?

Section 2: SQL - Installation & Fixing "Cannot Connect to MySQL Server"

Lecture 4 Installation of MySQL on MacOS

Lecture 5 RESOURCES: Installation of MySQL on MacOS

Lecture 6 How to fix Cannot Connect to MySQL Server - MacOS

Lecture 7 Installation of MySQL Server and Workbench on Windows

Lecture 8 How to fix Cannot Connect to MySQL Server - Windows

Section 3: SQL - Course Resources

Lecture 9 Database Resources for this Course

Lecture 10 How to use/run the resources

Section 4: SQL - Select Statement

Lecture 11 SELECT (Understanding Select for Absolute beginners)

Section 5: SQL - Database

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

Lecture 13 Creating A Database - Challenge & Solution 1

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

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

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

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

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

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

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

Lecture 21 Using A Database - Challenge & Solution 5

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

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

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

Section 6: SQL - Create Table - Understanding the Syntax

Lecture 25 First Things First - TABLES

Lecture 26 IF NOT EXISTS with CREATE TABLE in SQL - MySQL

Lecture 27 CODE: IF NOT EXIST with CREATE TABLE in SQL-MySQL

Lecture 28 Purpose of ( ); In CREATE TABLE In SQL-MySQL

Lecture 29 Backticks In CREATE TABLE In SQL-MySQL

Lecture 30 CREATE TABLE In SQL-MySQl - First Time

Lecture 31 CODE: CREATE TABLE In SQL-MySQl - First Time

Section 7: SQL - Data Types

Lecture 32 Type of Data in MySQL

Lecture 33 MySQL Numeric Types

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

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

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

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

Lecture 38 CHAR vs VARCHAR - String Data Types in MySQL

Lecture 39 BINARY & VARBINARY - String Data Types in MySQL

Lecture 40 BLOB & TEXT - String Data Types in MySQL

Lecture 41 ENUM - String Data Types in MySQL

Lecture 42 SET - String Data Types in MySQL

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

Section 8: SQL - Insert Query

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

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

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

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

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

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

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

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

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

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

Lecture 54 Inserting Null Value and Empty White Space Into Table

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

Section 9: SQL - Candidate, Surrogate, Primary, Alternative & Foreign Key

Lecture 56 Candidate Key In SQL

Lecture 57 Surrogate Key In SQL

Lecture 58 Primary Key & Alternative Key In SQL

Lecture 59 Foreign Key In SQL

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

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

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

Lecture 62 Deleting A PRIMARY KEY - Challenge & Solution 2

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

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

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

Lecture 66 Assigning A FOREIGN KEY - Challenge & Solution 4

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

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

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

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

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

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

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

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

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

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

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

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

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

Section 11: SQL - Revisiting Select Statement

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

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

Lecture 82 Select Specific Columns - Challenge & Solution 2

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

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

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

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

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

Section 12: SQL - Alias - AS

Lecture 88 ALIAS (AS) Introduction

Lecture 89 CODE: ALIAS (AS) Introduction

Lecture 90 Alias - Challenge & Solution

Lecture 91 CODE: Alias - Challenge & Solution

Section 13: SQL - Concat Function

Lecture 92 CONCAT() Introduction

Lecture 93 CODE: CONCAT() Introduction

Lecture 94 CONCAT() - Challenge & Solution 1

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

Lecture 96 CONCAT() - Challenge & Solution 2

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

Section 14: SQL - Order By Keyword

Lecture 98 ORDER BY Introduction

Lecture 99 ORDER BY ASC - Challenge & Solution 1

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

Lecture 101 ORDER BY DESC - Challenge & Solution 2

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

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

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

Lecture 105 ORDER BY ASC - Challenge & Solution 4

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

Section 15: SQL - Limit Clause

Lecture 107 LIMIT - Challenge & Solution 1

Lecture 108 CODE: LIMIT - Challenge & Solution 1

Lecture 109 LIMIT - Challenge & Solution 2

Lecture 110 CODE: LIMIT - Challenge & Solution 2

Lecture 111 LIMIT - Challenge & Solution 3

Lecture 112 CODE: LIMIT - Challenge & Solution 3

Section 16: SQL - Order By & Rand Function

Lecture 113 ORDER BY with RAND - Challenge & Solution

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

Section 17: SQL - Comments

Lecture 115 SINGLE & MULTILINE COMMENTS in SQL-MySQL

Section 18: SQL - Where Clause

Lecture 116 Introduction to WHERE

Lecture 117 Northwind Data Set | Should run to work along

Lecture 118 UK Customers filter - Challenge & Solution 1

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

Lecture 120 Specific Customer filter - Challenge & Solution 2

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

Lecture 122 Specific Employee filter - Challenge & Solution 3

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

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

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

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

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

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

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

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

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

Lecture 132 All Suppliers Except… using NOT, <>, ! - Challenge & Solution 8

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Lecture 160 NOT BETWEEN - Challenge & Solution 22

Lecture 161 CODE: NOT BETWEEN - Challenge & Solution 22

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

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

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

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

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

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

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

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

Lecture 170 IN and WHERE - Challenge & Solution 27

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

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

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

Section 19: SQL - Index

Lecture 174 Introduction to MySQL Index

Lecture 175 Creating Index Along a Table

Lecture 176 Code: Creating Index Along a Table

Lecture 177 Creating Index on Existing Column

Lecture 178 CODE: Creating Index on Existing Column

Lecture 179 Understanding Primary or Clustered Index

Lecture 180 Unique Key vs Index

Lecture 181 Key vs Index

Lecture 182 Verifying Index

Lecture 183 CODE: Verifying Index

Lecture 184 Confirming the "Power" of Index

Lecture 185 CODE: Confirming the "Power" of Index

Lecture 186 Deleting Index

Lecture 187 CODE: Deleting Index

Section 20: SQL - Wildcards

Lecture 188 Introduction to MySQL Wildcards

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

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

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

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

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

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

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

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

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

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

Section 21: SQL - Update Statement & Replace Function

Lecture 199 Updating a Single Value in a Table

Lecture 200 CODE: Updating a Single Value in a Table

Lecture 201 Updating Multiple Values in a Table

Lecture 202 CODE: Updating Multiple Values in a Table

Lecture 203 Using UPDATE with REPLACE

Lecture 204 CODE: Using UPDATE with REPLACE

Lecture 205 What is Storage Engine - Let's Digress a little :)

Section 22: SQL - Select Distinct Statement

Lecture 206 DISTINCT - How it works

Lecture 207 CODE: DISTINCT - How it works

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

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

Section 23: SQL - Format Function

Lecture 210 How Format() Function Works

Lecture 211 CODE: How Format() Function Works

Lecture 212 Data Cleaning | Format - Challenge & Solution

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

Section 24: SQL - Group By Statement | Aggregate

Lecture 214 GROUP BY - True Meaning

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

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

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

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

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

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

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

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

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

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

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

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

Lecture 227 Most Hardworking Employee - Challenge & Solution 7

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

Section 25: SQL - Joins (Made Easy)

Lecture 229 Resource for JOIN

Lecture 230 Purpose of JOIN in SQL

Lecture 231 Type of JOIN in SQL

Lecture 232 Understanding INNER JOIN

Lecture 233 Understanding LEFT JOIN

Lecture 234 Understanding RIGHT JOIN

Lecture 235 Understanding FULL JOIN

Section 26: SQL - Joins (Deep Dive)

Lecture 236 Overview of Tables & Code for JOIN Demonstration

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

Lecture 238 INNER JOIN - DEEP DIVE

Lecture 239 CODE: INNER JOIN - DEEP DIVE

Lecture 240 LEFT JOIN - DEEP DIVE

Lecture 241 CODE: LEFT JOIN - DEEP DIVE

Lecture 242 RIGHT JOIN - DEEP DIVE

Lecture 243 CODE: RIGHT JOIN - DEEP DIVE

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

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

Lecture 246 Table.Column vs Column only?

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

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

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

Section 28: SQL - Joins Challenges & Solutions

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

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

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

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

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

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

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

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

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

Lecture 257 Please Read Me!

Lecture 258 Schema

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

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

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

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

Section 31: SQL - Two Tables Join

Lecture 262 Two Tables Join - Challenge and Solution 2

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

Lecture 264 Two Tables Join - Challenge and Solution 3

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

Lecture 266 Two Tables Join - Challenge and Solution 4

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

Lecture 268 Two Tables Join - Challenge and Solution 5

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

Section 32: SQL - Three Tables Join

Lecture 270 Three Table Joins - Challenge and Solution 6

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

Lecture 272 Three Tables Join - Challenge and Solution 7

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

Section 33: SQL - Four Tables Joins

Lecture 274 Four Tables Join - Challenge and Solution 8

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

Section 34: SQL - Five Tables Join

Lecture 276 Five Tables Join - Challenge and Solution 9

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

Lecture 278 Five Tables Join - Challenge and Solution 10

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

Section 35: SQL - Six Tables Join

Lecture 280 Six Tables Join - Challenge and Solution 11

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

Section 36: SQL - Seven Tables Join

Lecture 282 Seven Tables Join - Challenge and Solution 12

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

Section 37: SQL - Eight Tables Join

Lecture 284 Eight Tables Join - Challenge and Solution 13

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

Section 38: SQL - Nine Tables Join

Lecture 286 Nine Tables Join - Challenge and Solution 14

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

Section 39: SQL - Ten Tables Join

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

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

Section 40: SQL - Offset & Limit

Lecture 290 Offset & Limit - Challenge & Solution 1

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

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

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

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

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

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

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

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

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

Section 41: SQL - Case Function

Lecture 300 Understanding MySQL CASE

Lecture 301 CODE: Understanding MySQL CASE

Lecture 302 CASE with IS NULL

Lecture 303 CODE: CASE with IS NULL

Lecture 304 CASE FOR TYPE OF CUSTOMERS

Lecture 305 CODE: CASE FOR TYPE OF CUSTOMERS

Section 42: SQL - Cast Function

Lecture 306 CAST - FROM STRING to DATE

Lecture 307 CODE: CAST - FROM STRING to DATE

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

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

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

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

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

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

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

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

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

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

Section 43: SQL - Nested & Correlated Subqueries

Lecture 318 Introduction to subqueries

Lecture 319 Aggregate Function with Subqueries

Lecture 320 Nested Subquery - Challenge & Solution 1

Lecture 321 Many Subqueries - Challenges & Solution 2

Section 44: SQL - Subqueries & Exists Operator

Lecture 322 Exists Operator

Lecture 323 Subquery & Exists - Challenge & Solution 1

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

Lecture 325 Subquery & Exists - Challenge & Solution 2

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

Section 45: Difference Between Nested and Correlated Subqueries

Lecture 327 Difference Between Nested and Correlated Subqueries

Section 46: SQL - String Functions

Lecture 328 SPACE FUNCTION | Challenge & Solution 1

Lecture 329 SPACE FUNCTION | Challenge & Solution 2

Lecture 330 REPEAT FUNCTION | Challenge & Solution 3

Lecture 331 REPEAT FUNCTION | Challenge & Solution 4

Lecture 332 REPLACE FUNCTION | Challenge & Solution 5

Lecture 333 REPLACE FUNCTION | Challenge & Solution 6

Lecture 334 REPLACE FUNCTION | Challenge & Solution 7

Lecture 335 REVERSE FUNCTION | Challenge & Solution 8

Lecture 336 REVERSE FUNCTION | Challenge & Solution 9

Lecture 337 LEFT FUNCTION | Challenge & Solution 10

Lecture 338 LEFT FUNCTION | Challenge & Solution 11

Lecture 339 RIGHT FUNCTION | Challenge & Solution 12

Lecture 340 RIGHT FUNCTION | Challenge & Solution 13

Lecture 341 RPAD FUNCTION | Challenge & Solution 14

Lecture 342 RPAD FUNCTION | Challenge & Solution 15

Lecture 343 LPAD FUNCTION | Challenge & Solution 16

Lecture 344 LPAD FUNCTION | Challenge & Solution 17

Lecture 345 LPAD FUNCTION | Challenge & Solution 18

Lecture 346 POSITION & LOCATION FUNCTIONS | Challenge & Solution 19

Lecture 347 POSITION & LOCATION FUNCTIONS | Challenge & Solution 20

Lecture 348 SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 21

Lecture 349 SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 22

Lecture 350 SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 23

Lecture 351 SUBSTRING_SUBSTR FUNCTION | Challenge & Solution 24

Lecture 352 SUBSTRING_INDEX FUNCTION | Challenge & Solution 25

Lecture 353 SUBSTRING_INDEX FUNCTION | Challenge & Solution 26

Lecture 354 SUBSTRING_INDEX FUNCTION | Challenge & Solution 27

Lecture 355 SUBSTRING_INDEX FUNCTION | Challenge & Solution 28

Lecture 356 SUBSTRING_INDEX FUNCTION | Challenge & Solution 29

Lecture 357 MID FUNCTION | Challenge & Solution 30

Lecture 358 MID FUNCTION | Challenge & Solution 31

Lecture 359 INSERT FUNCTION | Challenge & Solution 32

Lecture 360 INSERT FUNCTION | Challenge & Solution 33

Lecture 361 INSTR FUNCTION | Challenge & Solution 34

Lecture 362 INSTR FUNCTION | Challenge & Solution 35

Lecture 363 LCASE & LOWER FUNCTION | Challenge & Solution 35

Lecture 364 LCASE & LOWER FUNCTION | Challenge & Solution 36

Lecture 365 UCASE & UPPER FUNCTION | Challenge & Solution 37

Lecture 366 UCASE & UPPER FUNCTION | Challenge & Solution 38

Lecture 367 UCASE & UPPER FUNCTION | Challenge & Solution 39

Lecture 368 LENGTH FUNCTION | Challenge & Solution 40

Lecture 369 LENGTH FUNCTION | Challenge & Solution 41

Lecture 370 LTRIM FUNCTION | Challenge & Solution 42

Lecture 371 LTRIM FUNCTION | Challenge & Solution 43

Lecture 372 RTRIM FUNCTION | Challenge & Solution 44

Lecture 373 RTRIM FUNCTION | Challenge & Solution 45

Lecture 374 TRIM FUNCTION | Challenge & Solution 45

Lecture 375 TRIM FUNCTION | Challenge & Solution 46

Section 47: SQL - Session

Lecture 376 Understanding MySQL Session

Lecture 377 CODE: Understanding MySQL Session

Section 48: SQL - Table Locking

Lecture 378 Table Locking Intro

Lecture 379 Table Locking Demonstration

Lecture 380 CODE: Table Locking Demonstration

Section 49: SQL - Transaction

Lecture 381 Brief Introduction to SQL Transaction

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

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

Lecture 384 TRANSACTION By Example

Lecture 385 CODE: TRANSACTION By Example

Lecture 386 NOT USING TRANSACTION

Lecture 387 CODE: NOT USING TRANSACTION

Lecture 388 ROLLBACK

Lecture 389 CODE: ROLLBACK

Section 50: SQL - View

Lecture 390 Meaning of VIEW

Lecture 391 CODE: Meaning of VIEW

Lecture 392 VIEW for Sales Manager | Challenge & Solution 1

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

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

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

Lecture 396 Updating VIEW | Challenge & Solution 3

Lecture 397 CODE: Updating VIEW | Challenge & Solution 3

Lecture 398 A Mistake In VIEW | Challenge & Solution 4

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

Lecture 400 Deleting a VIEW - Challenge & Solution 5

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

Lecture 402 VIEW for Japan Suppliers - Challenge & Solution 6

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

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

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

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

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

Section 51: SQL - Stored Procedures (Stored Routines)

Lecture 408 What is the meaning and purpose of Stored Procedure

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

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

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

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

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

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

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

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

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

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

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

Lecture 420 Deleting a STORED PROCEDURE - Challenge & Solution 7

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

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

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

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

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

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

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

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

Lecture 428 What is FUNCTION in SQL

Lecture 429 CODE: What is FUNCTION in SQL

Lecture 430 Creating Addition FUNCTION - Challenge & Solution 2

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

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

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

Lecture 434 Creating Pythagoras Theorem FUNCTION - Challenge & Solution 4

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

Lecture 436 Altering or Updating FUNCTION - Challenge & Solution 5

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

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

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

Lecture 440 Deleting a FUNCTION - Challenge & Solution 7

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

Section 53: SQL - Triggers

Lecture 442 The Purpose, The How and Types of TRIGGER

Lecture 443 TRIGGER - More Explanation With Diagram

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Lecture 465 Setting up database for challenges with attached downloadable resource

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

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

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

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

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

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

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

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

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

Lecture 474 Intro

Lecture 475 CarShop Resource Details

Lecture 476 Fetching Names of Cars - Challenge & Solution 1

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

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

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

Lecture 480 Counting Cars - Challenge & Solution 5

Lecture 481 Price List of Cars - Challenge & Solution 6

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

Lecture 483 Car Average Price - Challenge & Solution 8

Lecture 484 The most expensive car - Challenge & Solution 9

Lecture 485 Most Expensive Cars - Challenge & Solution 10

Lecture 486 Honda & Toyota - Challenge & Solution 11

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

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

Lecture 489 Counting Cars Per Manufacturer - Challenge & Solution 14

Lecture 490 Average Price Per Manufacturer - Challenge & Solution 15

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

Lecture 492 The Cheapest Car - Challenge & Solution 17

Lecture 493 The Most Expensive Car - Challenge & Solution 18

Lecture 494 Data Insert - Challenge & Solution 19

Lecture 495 Correcting Wrong Data - Challenge & Solution 20

Lecture 496 Discounted Prices I - Challenge & Solution 21

Lecture 497 Discounted Price II - Challenge & Solution 22

Lecture 498 VIEW for price list - Challenge & Solution 23

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

Lecture 499 Read Me First!

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

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

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

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

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

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

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

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

Lecture 508 Using Alias - Assignment 5

Lecture 509 Using Alias - Solution to Assignment 5

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

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

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

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

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

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

Lecture 516 GROUP BY & Average - Assignment 9

Lecture 517 GROUP BY & Average - Solution to Assignment 9

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

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

Lecture 520 VIEW for three tables JOIN - Assignment 11

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

Lecture 522 INNER JOIN, Subquery & EXISTS - Assignment 12

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

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

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

Lecture 526 INNER JOIN and SubQuery - Assignment 14

Lecture 527 INNER JOIN and SubQuery - Solution Assignment 14

Lecture 528 INNER JOIN & AND - Assignment 15

Lecture 529 INNER JOIN & AND - Solution Assignment 15

Lecture 530 INNER JOIN & SubQuery - Assignment 16

Lecture 531 INNER JOIN & SubQuery - Solution to Assignment 16

Lecture 532 SUBQUERY & LIMIT - Assignment 17

Lecture 533 SUBQUERY & LIMIT - Solution to Assignment 17

Lecture 534 UCASE - Assignment 18

Lecture 535 UCASE - Solution to Assignment 18

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

Lecture 536 More Tasks

Section 58: SQL - More Task 1

Lecture 537 Employees With Same Salary - Task 1

Lecture 538 Solution: Employees With Same Salary - Task 1

Lecture 539 CODE: Employees With Same Salary - Task 1

Section 59: SQL - More Task 2

Lecture 540 Duplicate Title - Task 2

Lecture 541 Solution: Duplicate Title - Task 2

Lecture 542 CODE: Duplicate Title - Task 2

Section 60: SQL - More Task 3

Lecture 543 Excluding Titles - Task 3

Lecture 544 Solution - Excluding Titles - Task 3

Lecture 545 CODE: Excluding Titles - Task 3

Section 61: SQL - More Task 4

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

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

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

Section 62: SQL - More Task 5

Lecture 549 Even Rows - Task 5

Lecture 550 Solution: Even Rows - Task 5

Lecture 551 CODE: Even Rows - Task 5

Section 63: SQL - More Task 6

Lecture 552 Odd Rows - Task 6

Lecture 553 Solution: Odd Rows - Task 6

Lecture 554 CODE: Odd Rows - Task 6

Section 64: SQL - More Task 7

Lecture 555 Second to Fourth - Task 7

Lecture 556 Solution: Second to Fourth - Task 7

Lecture 557 CODE: Second to Fourth - Task 7

Section 65: SQL - More Task 8

Lecture 558 Counting Employee with "SALES" - Task 8

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

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

Section 66: SQL - More Task 9

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

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

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

Section 67: SQL - More Task 10

Lecture 564 Tricky Exercise - Task 10

Lecture 565 Solution: Tricky Exercise - Task 10

Lecture 566 CODE: Tricky Exercise - Task 10

Section 68: SQL - More Task 11

Lecture 567 Tricky Exercise - Task 11

Lecture 568 Solution: Tricky Exercise - Task 11

Lecture 569 CODE: Tricky Exercise - Task 11

Section 69: SQL - More Task 12

Lecture 570 Tricky Exercise - Task 12

Lecture 571 Solution: Tricky Exercise - Task 12

Lecture 572 CODE: Tricky Exercise - Task 12

Lecture 573 Tricky Exercise - Task 12b

Lecture 574 Solution: Tricky Exercise - Task 12b

Lecture 575 CODE: Tricky Exercise - Task 12b

Section 70: SQL - More Task 13

Lecture 576 Tricky Exercise - Task 13

Lecture 577 Solution: Tricky Exercise - Task 13

Lecture 578 CODE: Tricky Exercise - Task 13

Section 71: SQL - More Task 14

Lecture 579 Tricky Exercise - Task 14

Lecture 580 Solution: Tricky Exercise - Task 14

Lecture 581 CODE: Tricky Exercise - Task 14

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

Lecture 582 Using Fewer Columns From SUBQUERY With JOIN

Lecture 583 CODE: Using Fewer Columns From SUBQUERY With JOIN

Lecture 584 Using WITH, SUBQUERY & INNER JOIN

Lecture 585 CODE: Using WITH, SUBQUERY & INNER JOIN

Section 73: SQL - More Task 15

Lecture 586 Tricky Exercise - Task 15

Lecture 587 Solution: Tricky Exercise - Task 15

Lecture 588 CODE: Tricky Exercise - Task 15

Section 74: SQL - More Task 16

Lecture 589 Tricky Exercise - task 16

Lecture 590 Solution: Tricky Exercise - task 16

Lecture 591 CODE: Tricky Exercise - task 16

Section 75: SQL - More Task 17

Lecture 592 Tricky Exercise - Task 17

Lecture 593 Solution: Tricky Exercise - Task 17

Lecture 594 CODE: Tricky Exercise - Task 17

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

Lecture 595 Introduction

Lecture 596 Day of the Week

Lecture 597 Day of the Month

Lecture 598 Day of the Year

Lecture 599 Week of the Year

Lecture 600 Month of the Year

Lecture 601 Year from given DateTime

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

Section 77: SQL - More Task 18

Lecture 603 Tricky Exercise - Task 18

Lecture 604 Solution: Tricky Exercise - Task 18

Lecture 605 CODE: Tricky Exercise - Task 18

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

Lecture 606 Introduction to Combining SQL and Python

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

Lecture 607 Installation of MySQL Connector for Python

Lecture 608 CODE: Installation of MySQL Connector for Python

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

Lecture 609 Creating Database & Show Databases From Python

Lecture 610 CODE: Creating Database & Show Databases From Python

Lecture 611 Creating a Table, Show Table & Describe Table

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

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

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

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

Lecture 615 Insert Multiple Rows of Data Into A Table

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

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

Lecture 617 Counting the numbers of rows

Lecture 618 CODE: Counting the numbers of rows

Lecture 619 FetchOne vs FetchAll

Lecture 620 CODE: FetchOne vs FetchAll

Section 83: Combining SQL and Python - Filter, Wildcard

Lecture 621 Select Filter with Python

Lecture 622 CODE: Select Filter with Python

Lecture 623 SQL Wildcard with Python

Lecture 624 CODE: SQL Wildcard with Python

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

Lecture 625 Introduction to this section

Section 85: Combining SQL and Tableau - Business Intelligence Introduction

Lecture 626 Business Intelligence - Introduction & Definition

Lecture 627 Business Intelligence Process

Section 86: Combining SQL and Tableau - Tableau Installation

Lecture 628 How to Download and Install Tableau

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

Lecture 629 Tableau - What-Is-What In Tableau - I

Lecture 630 Tableau - What-Is-What In Tableau - II

Lecture 631 Tableau - What-Is-What In Tableau - III

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

Lecture 632 Connecting MySQL to Tableau

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

Lecture 633 Tableau & MySQL: Querying SQL Database from Tableau

Lecture 634 Tableau & MySQL: Visualising CarShop Dataset

Section 90: Combining SQL and Tableau - Challenge & Solution

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

Section 91: Bonus Section

Lecture 636 Check out my other courses

All Levels - Beginners, Intermediate & Experts