54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/006 Nested Subquery & More Query Tweaking - Challenge & Solution 3.mp4 102.2 MB
54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/008 Nested Subquery, INNER JOIN, GROUP BY, HAVING - Challenge & Solution 4.mp4 72.0 MB
49 - SQL - Transaction/004 TRANSACTION By Example.mp4 61.3 MB
24 - SQL - Group By Statement Aggregate/001 GROUP BY - True Meaning.mp4 60.6 MB
41 - SQL - Case Function/001 Understanding MySQL CASE.mp4 60.2 MB
41 - SQL - Case Function/005 CASE FOR TYPE OF CUSTOMERS.mp4 60.0 MB
26 - SQL - Joins (Deep Dive)/005 LEFT JOIN - DEEP DIVE.mp4 59.9 MB
55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/009 Price List For Cambodia Customers - Challenge & Solution 7.mp4 58.9 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/021 GROUP BY; RIGHT, LEFT, INNER & NO JOIN - Solution to Assignment 10.mp4 57.7 MB
10 - SQL - Primary and Foreign Key Constraints Alter Table/007 Assigning A FOREIGN KEY - Challenge & Solution 4.mp4 57.6 MB
51 - SQL - Stored Procedures (Stored Routines)/005 How to Modify STORED PROCEDURE Tesla Vehicles - Challenge & Solution 3.mp4 57.3 MB
27 - SQL - Joins On vs Where On vs Using/001 ON vs WHERE in INNER, LEFT & RIGHT JOIN.mp4 56.2 MB
26 - SQL - Joins (Deep Dive)/009 More On RIGHT JOIN and LEFT JOIN with Shipper & Orders tables.mp4 56.1 MB
88 - Combining SQL and Tableau - Connecting MySQL to Tableau/001 Connecting MySQL to Tableau.mp4 33.2 MB
80 - Combining SQL and Python -Create Database & Table, Show & Describe Table/001 Creating Database & Show Databases From Python.mp4 32.9 MB
50 - SQL - View/001 Meaning of VIEW.mp4 32.9 MB
33 - SQL - Four Tables Joins/001 Four Tables Join - Challenge and Solution 8.mp4 32.7 MB
02 - SQL - Installation & Fixing Cannot Connect to MySQL Server/003 How to fix Cannot Connect to MySQL Server - MacOS.mp4 32.1 MB
26 - SQL - Joins (Deep Dive)/007 RIGHT JOIN - DEEP DIVE.mp4 31.5 MB
19 - SQL - Index/001 Introduction to MySQL Index.mp4 31.5 MB
01 - Course Walkthrough, Case Study Demos & Introduction/009 For Absolute Beginner Why Choosing MySQL.mp4 31.4 MB
54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/002 Nested Subquery & JOIN methods 1million - Challenge & Solution 1.mp4 31.2 MB
43 - SQL - Nested & Correlated Subqueries/002 Aggregate Function with Subqueries.mp4 31.2 MB
81 - Combining SQL and Python - Insert a Row, Insert Multiple Rows & Select/003 Insert Multiple Rows of Data Into A Table.mp4 31.2 MB
14 - SQL - Order By Keyword/006 ORDER BY DESC & CONCAT - Challenge & Solution 3.mp4 21.2 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/013 Retrieving data across two tables using JOIN - Solution to Assignment 6.mp4 21.0 MB
72 - SQL - PAUSE and LEARN Using Fewer Columns & Subquery in JOINS/003 Using WITH, SUBQUERY & INNER JOIN.mp4 21.0 MB
50 - SQL - View/005 VIEW for Employees hired in 1994 Challenge & Solution 2.mp4 20.8 MB
05 - SQL - Database/001 Database vs Table In SQL- Layman's Explanation - (Challenge & Solution).mp4 20.7 MB
10 - SQL - Primary and Foreign Key Constraints Alter Table/015 Deleting A REFERENCED Parent Table - Challenge & Solution 8.mp4 20.6 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/015 Retrieving data across three tables using JOIN - Solution to Assignment 7.mp4 20.3 MB
18 - SQL - Where Clause/047 Customers in Paris & Nantes, France - Challenge & Solution 23.mp4 20.3 MB
18 - SQL - Where Clause/013 None Spanish Customers using != , - Challenge & Solution 6.mp4 20.2 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/023 VIEW for three tables JOIN - Solution to Assignment 11.mp4 20.1 MB
55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/002 CarShop Resource Details.mp4 19.9 MB
19 - SQL - Index/009 Verifying Index.mp4 19.9 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/025 INNER JOIN, Subquery & EXISTS - Solution to Assignment 12.mp4 19.3 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/033 INNER JOIN & SubQuery - Solution to Assignment 16.mp4 17.2 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/028 INNER JOIN and SubQuery - Assignment 14.mp4 17.0 MB
55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/013 Honda & Toyota - Challenge & Solution 11.mp4 16.7 MB
09 - SQL - Candidate, Surrogate, Primary, Alternative & Foreign Key/002 Surrogate Key In SQL.mp4 16.7 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/017 Aggregate - sum, average, minimum, maximum - Solution to Assignment 8.mp4 16.7 MB
79 - Combining SQL and Python - Installation of MySQL Connector/001 Installation of MySQL Connector for Python.mp4 16.6 MB
14 - SQL - Order By Keyword/002 ORDER BY ASC - Challenge & Solution 1.mp4 16.3 MB
18 - SQL - Where Clause/031 San Francisco Customers AND - Challenge & Solution 15.mp4 16.2 MB
46 - SQL - String Functions/013 RIGHT FUNCTION Challenge & Solution 13.mp4 16.1 MB
42 - SQL - Cast Function/011 CAST FROM DATE to DATETIME - Challenge & Solution 6.mp4 16.1 MB
18 - SQL - Where Clause/053 Employees Report to #2 IS NOT NULL - Challenge & Solution 26.mp4 16.0 MB
31 - SQL - Two Tables Join/003 Two Tables Join - Challenge and Solution 3.mp4 16.0 MB
07 - SQL - Data Types/008 BINARY & VARBINARY - String Data Types in MySQL.mp4 15.5 MB
54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/001 Setting up database for challenges with attached downloadable resource.mp4 15.3 MB
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.mp4 11.9 MB
55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/017 Average Price Per Manufacturer - Challenge & Solution 15.mp4 11.6 MB
52 - SQL - User-defined Functions (Stored Routine)/005 How to check for FUNCTION - Challenge & Solution 3.mp4 11.6 MB
06 - SQL - Create Table - Understanding the Syntax/004 Purpose of ( ); In CREATE TABLE In SQL-MySQL.mp4 11.5 MB
14 - SQL - Order By Keyword/001 ORDER BY Introduction.mp4 11.4 MB
51 - SQL - Stored Procedures (Stored Routines)/009 Check for STORED PROCEDURE in the current database - Challenge & Solution 5.mp4 11.4 MB
16 - SQL - Order By & Rand Function/001 ORDER BY with RAND - Challenge & Solution.mp4 11.3 MB
18 - SQL - Where Clause/033 Specific Mexico Customers AND - Challenge & Solution 16.mp4 11.3 MB
18 - SQL - Where Clause/037 Brazil and Venezuela Customers OR - Challenge & Solution 18.mp4 11.2 MB
55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/019 The Cheapest Car - Challenge & Solution 17.mp4 11.2 MB
54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/004 Nested Subquery Budget above average - Challenge & Solution 2.mp4 10.8 MB
24 - SQL - Group By Statement Aggregate/006 Region Count GROUP BY, COUNT - Challenge & Solution 3.mp4 10.7 MB
76 - SQL - DATE_FORMAT() == Understanding Me First Before Task 18)/005 Week of the Year.mp4 10.6 MB
32 - SQL - Three Tables Join/003 Three Tables Join - Challenge and Solution 7.mp4 10.6 MB
18 - SQL - Where Clause/049 Product List BETWEEN, CONCAT, FORMAT, ORDER BY - Challenge & Solution 24.mp4 10.5 MB
80 - Combining SQL and Python -Create Database & Table, Show & Describe Table/003 Creating a Table, Show Table & Describe Table.mp4 9.4 MB
55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/018 Manufacturer Average Car Price Above $35,000 - Challenge & Solution 16.mp4 9.3 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/020 GROUP BY; RIGHT, LEFT, INNER & NO JOIN - Assignment 10.mp4 7.1 MB
51 - SQL - Stored Procedures (Stored Routines)/007 How to check for STORED PROCEDURE across databases - Challenge & Soln 4.mp4 7.0 MB
05 - SQL - Database/008 How To Delete A Database - Challenges & Solution 4.mp4 6.1 MB
18 - SQL - Where Clause/019 Products above certain Price Greater Than - Challenge & Solution 9.mp4 6.0 MB
76 - SQL - DATE_FORMAT() == Understanding Me First Before Task 18)/004 Day of the Year.mp4 6.0 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/012 Retrieving data across two tables using JOIN - Assignment 6.mp4 5.9 MB
18 - SQL - Where Clause/023 Unit In Stock Less Than - Challenge & Solution 11.mp4 5.9 MB
07 - SQL - Data Types/001 Type of Data in MySQL.mp4 5.9 MB
18 - SQL - Where Clause/021 Products Below Certain Price Less Than - Challenge & Solution 10.mp4 5.8 MB
55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/011 The most expensive car - Challenge & Solution 9.mp4 5.8 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/027 Updating Table with 5% Increase in Salary - Solution Assignment 13.mp4 4.2 MB
53 - SQL - Triggers/006 How to Check and Delete a TRIGGER - Challenge & Solution 1c.mp4 4.1 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/014 Retrieving data across three tables using JOIN - Assignment 7.mp4 4.0 MB
82 - Combining SQL and Python - Row Counting, FetchOne, FetchAll/001 Counting the numbers of rows.mp4 3.9 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/003 What is the current database selected - Assignment 1 Solution.mp4 3.9 MB
25 - SQL - Joins (Made Easy)/003 Type of JOIN in SQL.mp4 3.8 MB
18 - SQL - Where Clause/007 Specific Employee filter - Challenge & Solution 3.mp4 2.4 MB
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.mp4 2.4 MB
55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/005 Cars at a specific price - Challenge & Solution 3.mp4 2.4 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/037 UCASE - Solution to Assignment 18.mp4 2.2 MB
42 - SQL - Cast Function/007 CAST FROM STRING to TIME - Challenge & Solution 4.mp4 2.1 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/022 VIEW for three tables JOIN - Assignment 11.mp4 2.0 MB
76 - SQL - DATE_FORMAT() == Understanding Me First Before Task 18)/007 Year from given DateTime.mp4 2.0 MB
55 - CAR SHOP DATA SET - A Complete Example - Lots Of Challenges & Solutions/004 Names & Price of Cars - Challenge & Solution 2.mp4 2.0 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/005 What are the available tables in the database - Assignment 2 Solution.mp4 1.7 MB
65 - SQL - More Task 8/002 Solution Counting Employee with SALES - Task 8.mp4 1.5 MB
42 - SQL - Cast Function/003 CAST - FROM INTEGER to CHAR - Challenge & Solution 2.mp4 1.5 MB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/016 Aggregate - sum, average, minimum, maximum - Assignment 8.mp4 965.3 kB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/026 Updating Table with 5% Increase in Salary - Assignment 13.mp4 791.0 kB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/010 Using Alias - Assignment 5.mp4 549.0 kB
66 - SQL - More Task 9/001 Using Sub Query - Second to the Highest Salary - Task 9.mp4 542.1 kB
64 - SQL - More Task 7/001 Second to Fourth - Task 7.mp4 525.5 kB
58 - SQL - More Task 1/001 Employees With Same Salary - Task 1.mp4 508.8 kB
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.mp4 490.5 kB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/024 INNER JOIN, Subquery & EXISTS - Assignment 12.mp4 446.0 kB
59 - SQL - More Task 2/001 Duplicate Title - Task 2.mp4 409.1 kB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/008 SQL Query to retrieve data from one table - Assignment 4.mp4 359.2 kB
62 - SQL - More Task 5/001 Even Rows - Task 5.mp4 335.1 kB
65 - SQL - More Task 8/001 Counting Employee with SALES - Task 8.mp4 282.3 kB
81 - Combining SQL and Python - Insert a Row, Insert Multiple Rows & Select/28717142-Insert-Multipl-Rows.html 279.3 kB
80 - Combining SQL and Python -Create Database & Table, Show & Describe Table/28693768-CreateDatatabase.html 276.7 kB
80 - Combining SQL and Python -Create Database & Table, Show & Describe Table/28705738-CreateTable.html 276.3 kB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/004 What are the available tables in the database - Assignment 2.mp4 274.2 kB
56 - CAMERA SUPPLIERS DATA SET - A Complete Example - Lots Of Challenges & Solutions/002 What is the current database selected - Assignment 1.mp4 260.2 kB
54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/007 CODE Nested Subquery & More Query Tweaking - Challenge & Solution 3.html 997 Bytes
49 - SQL - Transaction/007 CODE NOT USING TRANSACTION.html 939 Bytes
10 - SQL - Primary and Foreign Key Constraints Alter Table/010 CODE Assigning A CONSTRAINT NAME To A FOREIGN KEY - Challenge & Solution 5.html 905 Bytes
54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/009 CODE Nested Subquery, INNER JOIN, GROUP BY, HAVING - Challenge & Solution 4.html 694 Bytes
34 - SQL - Five Tables Join/002 CODE Five Tables Join - Challenge and Solution 9.html 689 Bytes
80 - Combining SQL and Python -Create Database & Table, Show & Describe Table/004 CODE Creating a Table, Show Table & Describe Table.html 687 Bytes
35 - SQL - Six Tables Join/002 CODE Six Tables Join - Challenge and Solution 11.html 666 Bytes
10 - SQL - Primary and Foreign Key Constraints Alter Table/002 CODE Assigning A PRIMARY KEY (Three Methods) - Challenge & Solution.html 662 Bytes
10 - SQL - Primary and Foreign Key Constraints Alter Table/014 CODECONSTRAINT NAME & FOREIGN KEY To Existing Table - Challenge & Solution 7.html 647 Bytes
41 - SQL - Case Function/002 CODE Understanding MySQL CASE.html 643 Bytes
51 - SQL - Stored Procedures (Stored Routines)/018 CODE STORED PROCEDURE for Most Expensive Car - Challenge & Solution 9.html 384 Bytes
08 - SQL - Insert Query/010 CODE Inserting Multiple Lines of Data Into Table - 3rd Method.html 383 Bytes
08 - SQL - Insert Query/002 CODE Inserting A Single Line of Data Into Table - 1st Method.html 375 Bytes
52 - SQL - User-defined Functions (Stored Routine)/012 CODE Creating FUNCTION for Order details Line Total - Challenge & Solution 6.html 369 Bytes
54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/003 CODENested Subquery & JOIN methods 1million - Challenge & Solution 1.html 360 Bytes
51 - SQL - Stored Procedures (Stored Routines)/002 CODE What is the meaning and purpose of Stored Procedure.html 359 Bytes
08 - SQL - Insert Query/004 CODE Inserting A Single Line of Data Into Table - 2nd Method.html 336 Bytes
18 - SQL - Where Clause/050 CODE Product List BETWEEN, CONCAT, FORMAT, ORDER BY - Challenge & Solution 24.html 134 Bytes
0. Websites you may like/[FCS Forum].url 133 Bytes
18 - SQL - Where Clause/004 CODE UK Customers filter - Challenge & Solution 1.html 133 Bytes
62 - SQL - More Task 5/003 CODE Even Rows - Task 5.html 132 Bytes
28 - SQL - Joins Challenges & Solutions/004 CODE Using JOIN for Products & Their Suppliers - Challenge & Solution 2.html 131 Bytes
54 - RESEARCH DATA SET - A Complete Example - Lots Of Challenges & Solutions/005 CODE Nested Subquery Budget above average - Challenge & Solution 2.html 131 Bytes