01 - Course Walkthrough, Case Study Demos & Introduction/001 Course Syllabus Walkthrough.mp4105.67MB

01 - Course Walkthrough, Case Study Demos & Introduction/002 Case Study Demo 1.mp428.17MB

01 - Course Walkthrough, Case Study Demos & Introduction/004 Case Study Demo 2.mp413.05MB

01 - Course Walkthrough, Case Study Demos & Introduction/006 Case Study Demo 3.mp411.59MB

01 - Course Walkthrough, Case Study Demos & Introduction/008 For Absolute Beginner SQL vs MySQL vs DBMS and Database vs Data.mp460.99MB

01 - Course Walkthrough, Case Study Demos & Introduction/009 For Absolute Beginner Why Choosing MySQL.mp429.94MB

02 - SQL - Installation & Fixing Cannot Connect to MySQL Server/001 Installation of MySQL on MacOS.mp489.55MB

02 - SQL - Installation & Fixing Cannot Connect to MySQL Server/003 How to fix Cannot Connect to MySQL Server - MacOS.mp430.58MB

02 - SQL - Installation & Fixing Cannot Connect to MySQL Server/004 Installation of MySQL Server and Workbench on Windows.mp441.51MB

02 - SQL - Installation & Fixing Cannot Connect to MySQL Server/005 How to fix Cannot Connect to MySQL Server - Windows.mp423.64MB

03 - SQL - Course Resources/002 How to userun the resources.mp414.97MB

04 - SQL - Select Statement/001 SELECT (Understanding Select for Absolute beginners).mp472.01MB

05 - SQL - Database/001 Database vs Table In SQL- Layman's Explanation - (Challenge & Solution).mp419.7MB

05 - SQL - Database/002 Creating A Database - Challenge & Solution 1.mp41.62MB

05 - SQL - Database/004 IF NOT EXISTS with CREATE DATABASE - Challenge & Solution 2.mp47.14MB

05 - SQL - Database/006 How To Check For Existing Databases - Challenge & Solution 3.mp43.98MB

05 - SQL - Database/008 How To Delete A Database - Challenges & Solution 4.mp45.86MB

05 - SQL - Database/010 Using A Database - Challenge & Solution 5.mp49.91MB

05 - SQL - Database/012 How To Check For The Selected Database in Use - Challenge & Solution 6.mp42.7MB

06 - SQL - Create Table - Understanding the Syntax/001 First Things First - TABLES.mp4105.89MB

06 - SQL - Create Table - Understanding the Syntax/002 IF NOT EXISTS with CREATE TABLE in SQL - MySQL.mp435.76MB

06 - SQL - Create Table - Understanding the Syntax/004 Purpose of ( ); In CREATE TABLE In SQL-MySQL.mp410.94MB

06 - SQL - Create Table - Understanding the Syntax/005 Backticks In CREATE TABLE In SQL-MySQL.mp442MB

06 - SQL - Create Table - Understanding the Syntax/006 CREATE TABLE In SQL-MySQl - First Time.mp414.07MB

07 - SQL - Data Types/001 Type of Data in MySQL.mp45.58MB

07 - SQL - Data Types/002 MySQL Numeric Types.mp49.18MB

07 - SQL - Data Types/003 TINYINT, SMALLINT, MEDIUMINT, INTEGER, BIGINT -Exact Numeric Data Types in MySQL.mp489.44MB

07 - SQL - Data Types/004 DECIMAL & NUMERIC - Fixed Point Data Types in MySQL Approximate Numeric I.mp426.25MB

07 - SQL - Data Types/005 DECIMAL & NUMERIC - Fixed Point Data Types in MySQL Approximate Numeric II.mp495.51MB

07 - SQL - Data Types/006 REAL, FLOAT, DOUBLE - Floating Point Data Type in MySQL.mp440.95MB

07 - SQL - Data Types/007 CHAR vs VARCHAR - String Data Types in MySQL.mp422.98MB

07 - SQL - Data Types/008 BINARY & VARBINARY - String Data Types in MySQL.mp414.77MB

07 - SQL - Data Types/009 BLOB & TEXT - String Data Types in MySQL.mp44.43MB

07 - SQL - Data Types/010 ENUM - String Data Types in MySQL.mp422.83MB

07 - SQL - Data Types/011 SET - String Data Types in MySQL.mp421.61MB

07 - SQL - Data Types/012 DATE, TIME, DATETIME, TIMESTAMP & YEAR - Date and Time Data Types in MySQL.mp49.14MB

08 - SQL - Insert Query/001 Inserting A Single Line of Data Into Table - 1st Method.mp413.25MB

08 - SQL - Insert Query/003 Inserting A Single Line of Data Into Table - 2nd Method.mp46.9MB

08 - SQL - Insert Query/005 Inserting Multiple Lines of Data Into Table - 1st Method.mp47.94MB

08 - SQL - Insert Query/007 Inserting Multiple Lines of Data Into Table - 2nd Method.mp417.63MB

08 - SQL - Insert Query/009 Inserting Multiple Lines of Data Into Table - 3rd Method.mp49.65MB

08 - SQL - Insert Query/011 Inserting Null Value and Empty White Space Into Table.mp436.17MB

09 - SQL - Candidate, Surrogate, Primary, Alternative & Foreign Key/001 Candidate Key In SQL.mp425.59MB

09 - SQL - Candidate, Surrogate, Primary, Alternative & Foreign Key/002 Surrogate Key In SQL.mp415.94MB

09 - SQL - Candidate, Surrogate, Primary, Alternative & Foreign Key/003 Primary Key & Alternative Key In SQL.mp436.86MB

09 - SQL - Candidate, Surrogate, Primary, Alternative & Foreign Key/004 Foreign Key In SQL.mp447.02MB

10 - SQL - Primary and Foreign Key Constraints Alter Table/001 Assigning A PRIMARY KEY (Three Methods) - Challenge & Solution 1.mp433.8MB

10 - SQL - Primary and Foreign Key Constraints Alter Table/003 Deleting A PRIMARY KEY - Challenge & Solution 2.mp422.59MB

10 - SQL - Primary and Foreign Key Constraints Alter Table/005 Adding A PRIMARY KEY To Existing Column - Challenge & Solution 3.mp412.79MB

10 - SQL - Primary and Foreign Key Constraints Alter Table/007 Assigning A FOREIGN KEY - Challenge & Solution 4.mp454.96MB

10 - SQL - Primary and Foreign Key Constraints Alter Table/009 Assigning A CONSTRAINT NAME To A FOREIGN KEY - Challenge & Solution 5.mp425.07MB

10 - SQL - Primary and Foreign Key Constraints Alter Table/011 Adding A FOREIGN KEY To Existing Table - Challenge & Solution 6.mp424.5MB

10 - SQL - Primary and Foreign Key Constraints Alter Table/013 Challenge & Solution 7 CONSTRAINT NAME & FOREIGN KEY To Existing Table.mp421.57MB

10 - SQL - Primary and Foreign Key Constraints Alter Table/015 Deleting A REFERENCED Parent Table - Challenge & Solution 8.mp419.63MB

10 - SQL - Primary and Foreign Key Constraints Alter Table/017 Deleting A Column From A Table - Challenge & Solution 9.mp49.36MB

10 - SQL - Primary and Foreign Key Constraints Alter Table/019 Deleting A REFERENCED or CONSTRAINT Column - Challenge & Solution 10.mp425.07MB

11 - SQL - Revisiting Select Statement/001 Select All Rows and Columns - Challenge & Solution 1.mp421.01MB

11 - SQL - Revisiting Select Statement/003 Select Specific Columns - Challenge & Solution 2.mp47.63MB

11 - SQL - Revisiting Select Statement/005 Manager Demands for All Customers' Detail - Challenge & Solution 3.mp44.79MB

11 - SQL - Revisiting Select Statement/007 Specific Customer's Details - Challenge & Solution 4.mp43.59MB

12 - SQL - Alias - AS/001 ALIAS (AS) Introduction.mp425.39MB

12 - SQL - Alias - AS/003 Alias - Challenge & Solution.mp49.29MB

13 - SQL - Concat Function/001 CONCAT() Introduction.mp44.59MB

13 - SQL - Concat Function/003 CONCAT() - Challenge & Solution 1.mp42.4MB

13 - SQL - Concat Function/005 CONCAT() - Challenge & Solution 2.mp415.09MB

14 - SQL - Order By Keyword/001 ORDER BY Introduction.mp410.88MB

14 - SQL - Order By Keyword/002 ORDER BY ASC - Challenge & Solution 1.mp415.56MB

14 - SQL - Order By Keyword/004 ORDER BY DESC - Challenge & Solution 2.mp412.84MB

14 - SQL - Order By Keyword/006 ORDER BY DESC & CONCAT - Challenge & Solution 3.mp420.23MB

14 - SQL - Order By Keyword/008 ORDER BY ASC - Challenge & Solution 4.mp49.82MB

15 - SQL - Limit Clause/001 LIMIT - Challenge & Solution 1.mp46.9MB

15 - SQL - Limit Clause/003 LIMIT - Challenge & Solution 2.mp411.36MB

15 - SQL - Limit Clause/005 LIMIT - Challenge & Solution 3.mp44.5MB

16 - SQL - Order By & Rand Function/001 ORDER BY with RAND - Challenge & Solution.mp410.8MB

17 - SQL - Comments/001 SINGLE & MULTILINE COMMENTS in SQL-MySQL.mp420.59MB

18 - SQL - Where Clause/001 Introduction to WHERE.mp49.44MB

18 - SQL - Where Clause/003 UK Customers filter - Challenge & Solution 1.mp428.74MB

18 - SQL - Where Clause/005 Specific Customer filter - Challenge & Solution 2.mp42.38MB

18 - SQL - Where Clause/007 Specific Employee filter - Challenge & Solution 3.mp42.3MB

18 - SQL - Where Clause/009 Product with specific Price filter - Challenge & Solution 4.mp43.31MB

18 - SQL - Where Clause/011 Getting a list of Sales Representatives - Challenge & Solution 5.mp46.39MB

18 - SQL - Where Clause/013 None Spanish Customers using != , - Challenge & Solution 6.mp419.26MB

18 - SQL - Where Clause/015 Products Supplied by a Specific Customer - Challenge & Solution 7.mp43.92MB

18 - SQL - Where Clause/017 All Suppliers Except... using NOT, , ! - Challenge & Solution 8.mp412.33MB

18 - SQL - Where Clause/019 Products above certain Price Greater Than - Challenge & Solution 9.mp45.71MB

18 - SQL - Where Clause/021 Products Below Certain Price Less Than - Challenge & Solution 10.mp45.57MB

18 - SQL - Where Clause/023 Unit In Stock Less Than - Challenge & Solution 11.mp45.59MB

18 - SQL - Where Clause/025 Minimum Wages Less Than - Challenge & Solution 12.mp44.36MB

18 - SQL - Where Clause/027 Gifts for Customers Greater Than - Challenge & Solution 13.mp412.5MB

18 - SQL - Where Clause/029 Units In Stock Less Than - Challenge & Solution 14.mp49.37MB

18 - SQL - Where Clause/031 San Francisco Customers AND - Challenge & Solution 15.mp415.46MB

18 - SQL - Where Clause/033 Specific Mexico Customers AND - Challenge & Solution 16.mp410.78MB

18 - SQL - Where Clause/035 None USA and UK Customers NOT, !=, - Challenge & Solution 17.mp421.8MB

18 - SQL - Where Clause/037 Brazil and Venezuela Customers OR - Challenge & Solution 18.mp410.7MB

18 - SQL - Where Clause/039 Range of Suppliers BETWEEN - Challenges & Solution 19.mp47.8MB

18 - SQL - Where Clause/041 Suppliers Combining , & OR - Challenge & Solution 20.mp44.01MB

18 - SQL - Where Clause/043 Range of Suppliers using BETWEEN - Challenge & Solution 21.mp47.6MB

18 - SQL - Where Clause/045 NOT BETWEEN - Challenge & Solution 22.mp44.41MB

18 - SQL - Where Clause/047 Customers in Paris & Nantes, France - Challenge & Solution 23.mp419.33MB

18 - SQL - Where Clause/049 Product List BETWEEN, CONCAT, FORMAT, ORDER BY - Challenge & Solution 24.mp410.01MB

18 - SQL - Where Clause/051 NULL values IS NULL, IS NOT NULL - Challenge & Solution 25.mp48.54MB

18 - SQL - Where Clause/053 Employees Report to #2 IS NOT NULL - Challenge & Solution 26.mp415.3MB

18 - SQL - Where Clause/055 IN and WHERE - Challenge & Solution 27.mp412.62MB

18 - SQL - Where Clause/057 NOT IN - UK, Germany & France Customers - Challenge & Solution 28.mp413.88MB

19 - SQL - Index/001 Introduction to MySQL Index.mp430.03MB

19 - SQL - Index/002 Creating Index Along a Table.mp49.17MB

19 - SQL - Index/004 Creating Index on Existing Column.mp44.87MB

19 - SQL - Index/006 Understanding Primary or Clustered Index.mp440.34MB

19 - SQL - Index/007 Unique Key vs Index.mp411.71MB

19 - SQL - Index/008 Key vs Index.mp421.8MB

19 - SQL - Index/009 Verifying Index.mp418.95MB

19 - SQL - Index/011 Confirming the Power of Index.mp444.64MB

19 - SQL - Index/013 Deleting Index.mp412.3MB

20 - SQL - Wildcards/001 Introduction to MySQL Wildcards.mp451.43MB

20 - SQL - Wildcards/002 MySQL Wildcard - Customers Start With P - Challenges & Solution 1.mp411.83MB

20 - SQL - Wildcards/004 MySQL Wildcard Employees In Sales - Challenges & Solution 2.mp411.84MB

20 - SQL - Wildcards/006 MySQL Wildcard Phone Number Pattern - Challenges & Solution 3.mp423.03MB

20 - SQL - Wildcards/008 MySQL Wildcard - Customers In Restaurant Business - Challenges & Solution 4.mp43.93MB

20 - SQL - Wildcards/010 MySQL Wildcard - NOT LIKE - -Challenges & Solution 5.mp49.74MB

21 - SQL - Update Statement & Replace Function/001 Updating a Single Value in a Table.mp429.08MB

21 - SQL - Update Statement & Replace Function/003 Updating Multiple Values in a Table.mp411.61MB

21 - SQL - Update Statement & Replace Function/005 Using UPDATE with REPLACE.mp435.63MB

21 - SQL - Update Statement & Replace Function/007 What is Storage Engine - Let's Digress a little ).mp416.68MB

22 - SQL - Select Distinct Statement/001 DISTINCT - How it works.mp418.08MB

22 - SQL - Select Distinct Statement/003 DISTINCT, ORDER BY DESC, WHERE, IS NOT - Challenge & Solution.mp417.35MB

23 - SQL - Format Function/001 How Format() Function Works.mp48.52MB

23 - SQL - Format Function/003 Data Cleaning Format - Challenge & Solution.mp46.59MB

24 - SQL - Group By Statement Aggregate/001 GROUP BY - True Meaning.mp457.8MB

24 - SQL - Group By Statement Aggregate/002 MIN(), MAX(), AVG(), SUM() & GROUP BY - Challenge & Solution 1.mp424.95MB

24 - SQL - Group By Statement Aggregate/004 GROUP BY SUM,MIN,AVG CONCAT FORMAT - Challenge & Solution 2.mp413.36MB

24 - SQL - Group By Statement Aggregate/006 Region Count GROUP BY, COUNT - Challenge & Solution 3.mp410.19MB

24 - SQL - Group By Statement Aggregate/008 Row Unique Value Count GROUP BY, COUNT - Challenge & Solution 4.mp414.09MB

24 - SQL - Group By Statement Aggregate/010 Product Count COUNT, GROUP BY, ORDER BY - Challenge & Solution 5.mp435.55MB

24 - SQL - Group By Statement Aggregate/012 Product Sold SUM, GROUP BY - Challenge & Solution 6.mp412.99MB

24 - SQL - Group By Statement Aggregate/014 Most Hardworking Employee - Challenge & Solution 7.mp423.32MB

25 - SQL - Joins (Made Easy)/002 Purpose of JOIN in SQL.mp417.02MB

25 - SQL - Joins (Made Easy)/003 Type of JOIN in SQL.mp43.66MB

25 - SQL - Joins (Made Easy)/004 Understanding INNER JOIN.mp416.52MB

25 - SQL - Joins (Made Easy)/005 Understanding LEFT JOIN.mp423.96MB

25 - SQL - Joins (Made Easy)/006 Understanding RIGHT JOIN.mp423.3MB

25 - SQL - Joins (Made Easy)/007 Understanding FULL JOIN.mp418.35MB

26 - SQL - Joins (Deep Dive)/001 Overview of Tables & Code for JOIN Demonstration.mp46.97MB

26 - SQL - Joins (Deep Dive)/003 INNER JOIN - DEEP DIVE.mp4103.17MB

26 - SQL - Joins (Deep Dive)/005 LEFT JOIN - DEEP DIVE.mp457.17MB

26 - SQL - Joins (Deep Dive)/007 RIGHT JOIN - DEEP DIVE.mp430.04MB

26 - SQL - Joins (Deep Dive)/009 More On RIGHT JOIN and LEFT JOIN with Shipper & Orders tables.mp453.48MB

26 - SQL - Joins (Deep Dive)/011 Table.Column vs Column only.mp493.05MB

27 - SQL - Joins On vs Where On vs Using/001 ON vs WHERE in INNER, LEFT & RIGHT JOIN.mp453.58MB

27 - SQL - Joins On vs Where On vs Using/002 ON vs USING in SQL JOIN Statement.mp427.04MB

28 - SQL - Joins Challenges & Solutions/001 JOIN for Orders HandledManaged By Employee - Challenge & Solution 1.mp437.86MB

28 - SQL - Joins Challenges & Solutions/003 Using JOIN for Products & Their Suppliers - Challenge & Solution 2.mp426.62MB

28 - SQL - Joins Challenges & Solutions/005 JOIN for Customers and Shippers - Challenge & Solution 3.mp413.09MB

28 - SQL - Joins Challenges & Solutions/007 JOIN Many Tables - Customers and Names of Shipper - Challenge & Solution 4.mp435.9MB

29 - SQL - Joining 1, 2, 3, 4, 5, 6, 7, 8, 9 & 10 Tables/003 Simplifying the Schema used for JOIN in the following sections.mp446.31MB

30 - SQL - One Table Join (Self Join)/001 Self-Join One Table Join - Challenge and Solution 1.mp461.66MB

31 - SQL - Two Tables Join/001 Two Tables Join - Challenge and Solution 2.mp49.35MB

31 - SQL - Two Tables Join/003 Two Tables Join - Challenge and Solution 3.mp415.29MB

31 - SQL - Two Tables Join/005 Two Tables Join - Challenge and Solution 4.mp48.31MB

31 - SQL - Two Tables Join/007 Two Tables Join - Challenge and Solution 5.mp420.71MB

32 - SQL - Three Tables Join/001 Three Table Joins - Challenge and Solution 6.mp417.47MB

32 - SQL - Three Tables Join/003 Three Tables Join - Challenge and Solution 7.mp410.09MB

33 - SQL - Four Tables Joins/001 Four Tables Join - Challenge and Solution 8.mp431.17MB

34 - SQL - Five Tables Join/001 Five Tables Join - Challenge and Solution 9.mp445.72MB

34 - SQL - Five Tables Join/003 Five Tables Join - Challenge and Solution 10.mp422.2MB

35 - SQL - Six Tables Join/001 Six Tables Join - Challenge and Solution 11.mp413.97MB

36 - SQL - Seven Tables Join/001 Seven Tables Join - Challenge and Solution 12.mp413.78MB

37 - SQL - Eight Tables Join/001 Eight Tables Join - Challenge and Solution 13.mp49.25MB

38 - SQL - Nine Tables Join/001 Nine Tables Join - Challenge and Solution 14.mp421.92MB

39 - SQL - Ten Tables Join/001 Ten Tables Join - Challenge and Solution For Demonstration Purpose.mp411.49MB

40 - SQL - Offset & Limit/001 Offset & Limit - Challenge & Solution 1.mp438.19MB

40 - SQL - Offset & Limit/003 Offset & Limit Third Highest Purchase - Challenge & Solution 2.mp418.15MB

40 - SQL - Offset & Limit/005 Offset & Limit First Three Highest Salary - Challenge & Solution 3.mp46.34MB

40 - SQL - Offset & Limit/007 Offset & Limit - Fourth to the Lowest Salary - Challenge & Solution 4.mp46.78MB

40 - SQL - Offset & Limit/009 OFFSET & LIMIT First and Third Bestselling Products - Challenge & Solution 5.mp412.76MB

41 - SQL - Case Function/001 Understanding MySQL CASE.mp457.41MB

41 - SQL - Case Function/003 CASE with IS NULL.mp422.14MB

41 - SQL - Case Function/005 CASE FOR TYPE OF CUSTOMERS.mp457.26MB

42 - SQL - Cast Function/001 CAST - FROM STRING to DATE.mp43.57MB

42 - SQL - Cast Function/003 CAST - FROM INTEGER to CHAR - Challenge & Solution 2.mp41.39MB

42 - SQL - Cast Function/005 CAST FROM STRING to DATE & TIME - Challenge & Solution 3.mp45.07MB

42 - SQL - Cast Function/007 CAST FROM STRING to TIME - Challenge & Solution 4.mp42.02MB

42 - SQL - Cast Function/009 CAST Order Date Without time - Challenge & Solution 5.mp47.58MB

42 - SQL - Cast Function/011 CAST FROM DATE to DATETIME - Challenge & Solution 6.mp415.37MB

43 - SQL - Nested & Correlated Subqueries/001 Introduction to subqueries.mp433.77MB

43 - SQL - Nested & Correlated Subqueries/002 Aggregate Function with Subqueries.mp429.73MB

43 - SQL - Nested & Correlated Subqueries/003 Nested Subquery - Challenge & Solution 1.mp432.65MB

43 - SQL - Nested & Correlated Subqueries/004 Many Subqueries - Challenges & Solution 2.mp445MB

44 - SQL - Subqueries & Exists Operator/001 Exists Operator.mp47.37MB

44 - SQL - Subqueries & Exists Operator/002 Subquery & Exists - Challenge & Solution 1.mp432.68MB

44 - SQL - Subqueries & Exists Operator/004 Subquery & Exists - Challenge & Solution 2.mp445.75MB

45 - Difference Between Nested and Correlated Subqueries/001 Difference Between Nested and Correlated Subqueries.mp474.7MB

46 - SQL - String Functions/001 SPACE FUNCTION Challenge & Solution 1.mp43.46MB

46 - SQL - String Functions/002 SPACE FUNCTION Challenge & Solution 2.mp45.9MB

46 - SQL - String Functions/003 REPEAT FUNCTION Challenge & Solution 3.mp43.05MB

46 - SQL - String Functions/004 REPEAT FUNCTION Challenge & Solution 4.mp417.09MB

46 - SQL - String Functions/005 REPLACE FUNCTION Challenge & Solution 5.mp44.56MB

46 - SQL - String Functions/006 REPLACE FUNCTION Challenge & Solution 6.mp43.98MB

46 - SQL - String Functions/007 REPLACE FUNCTION Challenge & Solution 7.mp414.88MB

46 - SQL - String Functions/008 REVERSE FUNCTION Challenge & Solution 8.mp43.39MB

46 - SQL - String Functions/009 REVERSE FUNCTION Challenge & Solution 9.mp413.87MB

46 - SQL - String Functions/010 LEFT FUNCTION Challenge & Solution 10.mp46.4MB

46 - SQL - String Functions/011 LEFT FUNCTION Challenge & Solution 11.mp48.42MB

46 - SQL - String Functions/012 RIGHT FUNCTION Challenge & Solution 12.mp42.78MB

46 - SQL - String Functions/013 RIGHT FUNCTION Challenge & Solution 13.mp415.4MB

46 - SQL - String Functions/014 RPAD FUNCTION Challenge & Solution 14.mp45.16MB

46 - SQL - String Functions/015 RPAD FUNCTION Challenge & Solution 15.mp420.47MB

46 - SQL - String Functions/016 LPAD FUNCTION Challenge & Solution 16.mp410.79MB

46 - SQL - String Functions/017 LPAD FUNCTION Challenge & Solution 17.mp46.25MB

46 - SQL - String Functions/018 LPAD FUNCTION Challenge & Solution 18.mp441.91MB

46 - SQL - String Functions/019 POSITION & LOCATION FUNCTIONS Challenge & Solution 19.mp47.56MB

46 - SQL - String Functions/020 POSITION & LOCATION FUNCTIONS Challenge & Solution 20.mp47.2MB

46 - SQL - String Functions/021 SUBSTRING_SUBSTR FUNCTION Challenge & Solution 21.mp411.92MB

46 - SQL - String Functions/022 SUBSTRING_SUBSTR FUNCTION Challenge & Solution 22.mp421.37MB

46 - SQL - String Functions/023 SUBSTRING_SUBSTR FUNCTION Challenge & Solution 23.mp421.65MB

46 - SQL - String Functions/024 SUBSTRING_SUBSTR FUNCTION Challenge & Solution 24.mp45.87MB

46 - SQL - String Functions/025 SUBSTRING_INDEX FUNCTION Challenge & Solution 25.mp48.24MB

46 - SQL - String Functions/026 SUBSTRING_INDEX FUNCTION Challenge & Solution 26.mp44.84MB

46 - SQL - String Functions/027 SUBSTRING_INDEX FUNCTION Challenge & Solution 27.mp46.13MB

46 - SQL - String Functions/028 SUBSTRING_INDEX FUNCTION Challenge & Solution 28.mp45.48MB

46 - SQL - String Functions/029 SUBSTRING_INDEX FUNCTION Challenge & Solution 29.mp416.41MB

46 - SQL - String Functions/030 MID FUNCTION Challenge & Solution 30.mp43.96MB

46 - SQL - String Functions/031 MID FUNCTION Challenge & Solution 31.mp46.25MB

46 - SQL - String Functions/032 INSERT FUNCTION Challenge & Solution 32.mp412.92MB

46 - SQL - String Functions/033 INSERT FUNCTION Challenge & Solution 33.mp48.7MB

46 - SQL - String Functions/034 INSTR FUNCTION Challenge & Solution 34.mp46.22MB

46 - SQL - String Functions/035 INSTR FUNCTION Challenge & Solution 35.mp46.18MB

46 - SQL - String Functions/036 LCASE & LOWER FUNCTION Challenge & Solution 35.mp43.9MB

46 - SQL - String Functions/037 LCASE & LOWER FUNCTION Challenge & Solution 36.mp42.55MB

46 - SQL - String Functions/038 UCASE & UPPER FUNCTION Challenge & Solution 37.mp42.37MB

46 - SQL - String Functions/039 UCASE & UPPER FUNCTION Challenge & Solution 38.mp45.89MB

46 - SQL - String Functions/040 UCASE & UPPER FUNCTION Challenge & Solution 39.mp44.72MB

46 - SQL - String Functions/041 LENGTH FUNCTION Challenge & Solution 40.mp44.03MB

46 - SQL - String Functions/042 LENGTH FUNCTION Challenge & Solution 41.mp45.28MB

46 - SQL - String Functions/043 LTRIM FUNCTION Challenge & Solution 42.mp47.67MB

46 - SQL - String Functions/044 LTRIM FUNCTION Challenge & Solution 43.mp46.64MB

46 - SQL - String Functions/045 RTRIM FUNCTION Challenge & Solution 44.mp44.56MB

46 - SQL - String Functions/046 RTRIM FUNCTION Challenge & Solution 45.mp46.43MB

46 - SQL - String Functions/047 TRIM FUNCTION Challenge & Solution 45.mp47.09MB

46 - SQL - String Functions/048 TRIM FUNCTION Challenge & Solution 46.mp43.91MB

47 - SQL - Session/001 Understanding MySQL Session.mp425.36MB

48 - SQL - Table Locking/001 Table Locking Intro.mp49.99MB

48 - SQL - Table Locking/002 Table Locking Demonstration.mp429.33MB

49 - SQL - Transaction/001 Brief Introduction to SQL Transaction.mp423.12MB

49 - SQL - Transaction/002 TRANSACTION components - START, BEGIN, BEGIN WORK, COMMIT, ROLLBACK, SET.mp411.83MB

49 - SQL - Transaction/004 TRANSACTION By Example.mp458.44MB

49 - SQL - Transaction/006 NOT USING TRANSACTION.mp413.98MB

49 - SQL - Transaction/008 ROLLBACK.mp442.16MB

50 - SQL - View/001 Meaning of VIEW.mp431.35MB

50 - SQL - View/003 VIEW for Sales Manager Challenge & Solution 1.mp414.57MB

50 - SQL - View/005 VIEW for Employees hired in 1994 Challenge & Solution 2.mp419.85MB

50 - SQL - View/007 Updating VIEW Challenge & Solution 3.mp418.2MB

50 - SQL - View/009 A Mistake In VIEW Challenge & Solution 4.mp418.08MB

50 - SQL - View/011 Deleting a VIEW - Challenge & Solution 5.mp47.97MB

50 - SQL - View/013 VIEW for Japan Suppliers - Challenge & Solution 6.mp46.47MB

50 - SQL - View/015 WHERE with Normal Table & VIEW Table - Challenge & Solution 7.mp437.87MB

50 - SQL - View/017 INNER JOIN with Normal Table & VIEW Table - Challenge & Solution 8.mp413.58MB

51 - SQL - Stored Procedures (Stored Routines)/001 What is the meaning and purpose of Stored Procedure.mp444.5MB

51 - SQL - Stored Procedures (Stored Routines)/003 How to create STORED PROCEDURE for cars table - Challenge & Solution 2.mp461.8MB

51 - SQL - Stored Procedures (Stored Routines)/005 How to Modify STORED PROCEDURE Tesla Vehicles - Challenge & Solution 3.mp454.61MB

51 - SQL - Stored Procedures (Stored Routines)/007 How to check for STORED PROCEDURE across databases - Challenge & Soln 4.mp46.69MB

51 - SQL - Stored Procedures (Stored Routines)/009 Check for STORED PROCEDURE in the current database - Challenge & Solution 5.mp410.86MB

51 - SQL - Stored Procedures (Stored Routines)/011 Check for STORED PROCEDURE in a specified database - Challenge & Soln 6.mp414.18MB

51 - SQL - Stored Procedures (Stored Routines)/013 Deleting a STORED PROCEDURE - Challenge & Solution 7.mp49.04MB

51 - SQL - Stored Procedures (Stored Routines)/015 STORED PROCEDURE - Helping Purchasing Manager - Challenge & Solution 8.mp496.86MB

51 - SQL - Stored Procedures (Stored Routines)/017 STORED PROCEDURE for Most Expensive Car - Challenge & Solution 9.mp460.95MB

51 - SQL - Stored Procedures (Stored Routines)/019 STORED PROCEDURE for DATA INSERT to a table - Challenge & Solution 10.mp441.25MB

52 - SQL - User-defined Functions (Stored Routine)/001 What is FUNCTION in SQL.mp49.49MB

52 - SQL - User-defined Functions (Stored Routine)/003 Creating Addition FUNCTION - Challenge & Solution 2.mp445.2MB

52 - SQL - User-defined Functions (Stored Routine)/005 How to check for FUNCTION - Challenge & Solution 3.mp411.03MB

52 - SQL - User-defined Functions (Stored Routine)/007 Creating Pythagoras Theorem FUNCTION - Challenge & Solution 4.mp421.32MB

52 - SQL - User-defined Functions (Stored Routine)/009 Altering or Updating FUNCTION - Challenge & Solution 5.mp428.04MB

52 - SQL - User-defined Functions (Stored Routine)/011 Creating FUNCTION for Order details Line Total - Challenge & Solution 6.mp437.35MB

52 - SQL - User-defined Functions (Stored Routine)/013 Deleting a FUNCTION - Challenge & Solution 7.mp412.77MB

53 - SQL - Triggers/001 The Purpose, The How and Types of TRIGGER.mp432.73MB

53 - SQL - Triggers/002 TRIGGER - More Explanation With Diagram.mp416.61MB

53 - SQL - Triggers/003 Steps to Creating a TRIGGER - Challenge & Solution 1a.mp442.86MB

53 - SQL - Triggers/004 Creating After Update TRIGGER - Challenge & Solution 1b.mp470.44MB

53 - SQL - Triggers/006 How to Check and Delete a TRIGGER - Challenge & Solution 1c.mp43.88MB

53 - SQL - Triggers/008 Creating After Update TRIGGER - Another Method - Challenge & Solution 1d.mp461.79MB

53 - SQL - Triggers/010 Creating Conditional Update TRIGGER Different Names - Challenge & Solution 2.mp478.67MB

53 - SQL - Triggers/012 Creating AfterUpdate MySQL TRIGGER Above USD$5k - Challenge & Solution 3.mp471.76MB

53 - SQL - Triggers/014 After Insert Error Message MySQL TRIGGER - Challenge & Solution 4.mp439.9MB

53 - SQL - Triggers/016 TRIGGER with SIGNAL SQLSTATE for Null Value - Challenge & Solution 5.mp466.42MB

53 - SQL - Triggers/018 Multiple lines of TRIGGER - Many in One - Challenge & Solution 6.mp479.23MB

53 - SQL - Triggers/020 SQL SIGNAL SQLSTATE ERROR MESSAGE TRIGGER - Challenge & Solution 7.mp426.13MB

53 - SQL - Triggers/022 Fraud Detection - After Delete TRIGGER - Challenge & Solution 8.mp431.94MB

54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/001 Setting up database for challenges with attached downloadable resource.mp414.62MB

54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/002 Nested Subquery & JOIN methods 1million - Challenge & Solution 1.mp429.76MB

54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/004 Nested Subquery Budget above average - Challenge & Solution 2.mp410.27MB

54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/006 Nested Subquery & More Query Tweaking - Challenge & Solution 3.mp497.44MB

54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/008 Nested Subquery, INNER JOIN, GROUP BY, HAVING - Challenge & Solution 4.mp468.64MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/001 Intro.mp46.15MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/002 CarShop Resource Details.mp418.97MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/003 Fetching Names of Cars - Challenge & Solution 1.mp43.19MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/004 Names & Price of Cars - Challenge & Solution 2.mp41.86MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/005 Cars at a specific price - Challenge & Solution 3.mp42.26MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/006 Between two prices of cars - Challenge & Solution 4.mp49.4MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/007 Counting Cars - Challenge & Solution 5.mp43.05MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/008 Price List of Cars - Challenge & Solution 6.mp48.25MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/009 Price List For Cambodia Customers - Challenge & Solution 7.mp456.2MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/010 Car Average Price - Challenge & Solution 8.mp42.63MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/011 The most expensive car - Challenge & Solution 9.mp45.51MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/012 Most Expensive Cars - Challenge & Solution 10.mp437.56MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/013 Honda & Toyota - Challenge & Solution 11.mp415.96MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/014 All details from two tables - Challenge & Solution 12.mp49.21MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/015 Specific fields from two tables - Challenge & Solution 13.mp49.5MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/016 Counting Cars Per Manufacturer - Challenge & Solution 14.mp428.57MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/017 Average Price Per Manufacturer - Challenge & Solution 15.mp411.05MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/018 Manufacturer Average Car Price Above $35,000 - Challenge & Solution 16.mp48.85MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/019 The Cheapest Car - Challenge & Solution 17.mp410.68MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/020 The Most Expensive Car - Challenge & Solution 18.mp435.97MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/021 Data Insert - Challenge & Solution 19.mp412.19MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/022 Correcting Wrong Data - Challenge & Solution 20.mp44.81MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/023 Discounted Prices I - Challenge & Solution 21.mp412.44MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/024 Discounted Price II - Challenge & Solution 22.mp44.98MB

55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/025 VIEW for price list - Challenge & Solution 23.mp440.47MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/002 What is the current database selected - Assignment 1.mp4254.07KB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/003 What is the current database selected - Assignment 1 Solution.mp43.71MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/004 What are the available tables in the database - Assignment 2.mp4267.79KB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/005 What are the available tables in the database - Assignment 2 Solution.mp41.59MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/006 Display the details of each of the table in the database - Assignment 3.mp4478.97KB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/007 Display the details of each of the table in the database -Assignment 3 Solution.mp411.34MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/008 SQL Query to retrieve data from one table - Assignment 4.mp4350.75KB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/009 SQL Query to retrieve data from one table - Solution to Assignment 4.mp42.28MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/010 Using Alias - Assignment 5.mp4536.16KB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/011 Using Alias - Solution to Assignment 5.mp46.2MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/012 Retrieving data across two tables using JOIN - Assignment 6.mp45.66MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/013 Retrieving data across two tables using JOIN - Solution to Assignment 6.mp420.04MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/014 Retrieving data across three tables using JOIN - Assignment 7.mp43.8MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/015 Retrieving data across three tables using JOIN - Solution to Assignment 7.mp419.39MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/016 Aggregate - sum, average, minimum, maximum - Assignment 8.mp4942.7KB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/017 Aggregate - sum, average, minimum, maximum - Solution to Assignment 8.mp415.89MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/018 GROUP BY & Average - Assignment 9.mp4754.79KB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/019 GROUP BY & Average - Solution to Assignment 9.mp424.75MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/020 GROUP BY; RIGHT, LEFT, INNER & NO JOIN - Assignment 10.mp46.75MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/021 GROUP BY; RIGHT, LEFT, INNER & NO JOIN - Solution to Assignment 10.mp455.07MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/022 VIEW for three tables JOIN - Assignment 11.mp41.9MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/023 VIEW for three tables JOIN - Solution to Assignment 11.mp419.13MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/024 INNER JOIN, Subquery & EXISTS - Assignment 12.mp4435.52KB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/025 INNER JOIN, Subquery & EXISTS - Solution to Assignment 12.mp418.38MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/026 Updating Table with 5% Increase in Salary - Assignment 13.mp4772.48KB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/027 Updating Table with 5% Increase in Salary - Solution Assignment 13.mp44.04MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/028 INNER JOIN and SubQuery - Assignment 14.mp416.17MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/029 INNER JOIN and SubQuery - Solution Assignment 14.mp442MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/030 INNER JOIN & AND - Assignment 15.mp4732.49KB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/031 INNER JOIN & AND - Solution Assignment 15.mp418.17MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/032 INNER JOIN & SubQuery - Assignment 16.mp4618.73KB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/033 INNER JOIN & SubQuery - Solution to Assignment 16.mp416.36MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/034 SUBQUERY & LIMIT - Assignment 17.mp4649.2KB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/035 SUBQUERY & LIMIT - Solution to Assignment 17.mp424.29MB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/036 UCASE - Assignment 18.mp4587.67KB

56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/037 UCASE - Solution to Assignment 18.mp42.09MB

58 - SQL - More Task 1/001 Employees With Same Salary - Task 1.mp4496.83KB

58 - SQL - More Task 1/002 Solution Employees With Same Salary - Task 1.mp466.64MB

59 - SQL - More Task 2/001 Duplicate Title - Task 2.mp4399.49KB

59 - SQL - More Task 2/002 Solution Duplicate Title - Task 2.mp47.43MB

60 - SQL - More Task 3/001 Excluding Titles - Task 3.mp4711.2KB

60 - SQL - More Task 3/002 Solution - Excluding Titles - Task 3.mp44.3MB

61 - SQL - More Task 4/001 Eight & Last Alphabet 'n' - Task 4.mp4666.43KB

61 - SQL - More Task 4/002 Solution Eight & Last Alphabet 'n' - Task 4.mp43.46MB

62 - SQL - More Task 5/001 Even Rows - Task 5.mp4327.29KB

62 - SQL - More Task 5/002 Solution Even Rows - Task 5.mp47.61MB

63 - SQL - More Task 6/001 Odd Rows - Task 6.mp4233.54KB

63 - SQL - More Task 6/002 Solution Odd Rows - Task 6.mp46.11MB

64 - SQL - More Task 7/001 Second to Fourth - Task 7.mp4513.23KB

64 - SQL - More Task 7/002 Solution Second to Fourth - Task 7.mp44MB

65 - SQL - More Task 8/001 Counting Employee with SALES - Task 8.mp4275.67KB

65 - SQL - More Task 8/002 Solution Counting Employee with SALES - Task 8.mp41.43MB

66 - SQL - More Task 9/001 Using Sub Query - Second to the Highest Salary - Task 9.mp4529.39KB

66 - SQL - More Task 9/002 Solution Using Sub Query - Second to the Highest Salary - Task 9.mp413.7MB

67 - SQL - More Task 10/001 Tricky Exercise - Task 10.mp4592.22KB

67 - SQL - More Task 10/002 Solution Tricky Exercise - Task 10.mp47.17MB

68 - SQL - More Task 11/001 Tricky Exercise - Task 11.mp42.52MB

68 - SQL - More Task 11/002 Solution Tricky Exercise - Task 11.mp423.7MB

69 - SQL - More Task 12/001 Tricky Exercise - Task 12.mp4538.3KB

69 - SQL - More Task 12/002 Solution Tricky Exercise - Task 12.mp466.79MB

69 - SQL - More Task 12/004 Tricky Exercise - Task 12b.mp41.3MB

69 - SQL - More Task 12/005 Solution Tricky Exercise - Task 12b.mp44.54MB

70 - SQL - More Task 13/001 Tricky Exercise - Task 13.mp4951.97KB

70 - SQL - More Task 13/002 Solution Tricky Exercise - Task 13.mp451.19MB

71 - SQL - More Task 14/001 Tricky Exercise - Task 14.mp4655.2KB

71 - SQL - More Task 14/002 Solution Tricky Exercise - Task 14.mp427.28MB

72 - SQL - PAUSE and LEARN Using Fewer Columns & Subquery in JOINS/001 Using Fewer Columns From SUBQUERY With JOIN.mp448.1MB

72 - SQL - PAUSE and LEARN Using Fewer Columns & Subquery in JOINS/003 Using WITH, SUBQUERY & INNER JOIN.mp420MB

73 - SQL - More Task 15/001 Tricky Exercise - Task 15.mp43.15MB

73 - SQL - More Task 15/002 Solution Tricky Exercise - Task 15.mp463.81MB

74 - SQL - More Task 16/001 Tricky Exercise - task 16.mp4428.48KB

74 - SQL - More Task 16/002 Solution Tricky Exercise - task 16.mp43.77MB

75 - SQL - More Task 17/001 Tricky Exercise - Task 17.mp4765.07KB

75 - SQL - More Task 17/002 Solution Tricky Exercise - Task 17.mp460.41MB

76 - SQL - DATE_FORMAT() == Understanding Me First Before Task 18)/001 Introduction.mp47.21MB

76 - SQL - DATE_FORMAT() == Understanding Me First Before Task 18)/002 Day of the Week.mp412.93MB

76 - SQL - DATE_FORMAT() == Understanding Me First Before Task 18)/003 Day of the Month.mp48.31MB

76 - SQL - DATE_FORMAT() == Understanding Me First Before Task 18)/004 Day of the Year.mp45.68MB

76 - SQL - DATE_FORMAT() == Understanding Me First Before Task 18)/005 Week of the Year.mp410.1MB

76 - SQL - DATE_FORMAT() == Understanding Me First Before Task 18)/006 Month of the Year.mp46.15MB

76 - SQL - DATE_FORMAT() == Understanding Me First Before Task 18)/007 Year from given DateTime.mp41.87MB

76 - SQL - DATE_FORMAT() == Understanding Me First Before Task 18)/008 Second, Minute, Hour. AM and PM from DateTime.mp412.59MB

77 - SQL - More Task 18/001 Tricky Exercise - Task 18.mp43.22MB

77 - SQL - More Task 18/002 Solution Tricky Exercise - Task 18.mp452.53MB

78 - ==EXTRA SECTION! Combining SQL MySQL and Python/001 Introduction to Combining SQL and Python.mp48.2MB

79 - Combining SQL and Python - Installation of MySQL Connector/001 Installation of MySQL Connector for Python.mp415.79MB

80 - Combining SQL and Python -Create Database & Table, Show & Describe Table/001 Creating Database & Show Databases From Python.mp431.38MB

80 - Combining SQL and Python -Create Database & Table, Show & Describe Table/003 Creating a Table, Show Table & Describe Table.mp48.93MB

81 - Combining SQL and Python - Insert a Row, Insert Multiple Rows & Select/001 Insert A Row of Data Into A Table & Select.mp417.18MB

81 - Combining SQL and Python - Insert a Row, Insert Multiple Rows & Select/003 Insert Multiple Rows of Data Into A Table.mp429.73MB

82 - Combining SQL and Python - Row Counting, FetchOne, FetchAll/001 Counting the numbers of rows.mp43.77MB

82 - Combining SQL and Python - Row Counting, FetchOne, FetchAll/003 FetchOne vs FetchAll.mp49.52MB

83 - Combining SQL and Python - Filter, Wildcard/001 Select Filter with Python.mp46.81MB

83 - Combining SQL and Python - Filter, Wildcard/003 SQL Wildcard with Python.mp428.1MB

85 - Combining SQL and Tableau - Business Intelligence Introduction/001 Business Intelligence - Introduction & Definition.mp412.83MB

85 - Combining SQL and Tableau - Business Intelligence Introduction/002 Business Intelligence Process.mp420.76MB

86 - Combining SQL and Tableau - Tableau Installation/001 How to Download and Install Tableau.mp48.66MB

87 - Combining SQL and Tableau - What-Is-What In Tableau/001 Tableau - What-Is-What In Tableau - I.mp412.69MB

87 - Combining SQL and Tableau - What-Is-What In Tableau/002 Tableau - What-Is-What In Tableau - II.mp440.21MB

87 - Combining SQL and Tableau - What-Is-What In Tableau/003 Tableau - What-Is-What In Tableau - III.mp47.11MB

88 - Combining SQL and Tableau - Connecting MySQL to Tableau/001 Connecting MySQL to Tableau.mp431.69MB

89 - Combining SQL and Tableau - Database Querying & Visualisation/001 Tableau & MySQL Querying SQL Database from Tableau.mp49.86MB

89 - Combining SQL and Tableau - Database Querying & Visualisation/002 Tableau & MySQL Visualising CarShop Dataset.mp428.08MB

90 - Combining SQL and Tableau - Challenge & Solution/001 Tableau & SQL Challenge - Gross Sales and Net Sales Report.mp447.23MB