| 001 AND Operator.mp4 | 9.6 MB | ||
| 001 AND Operator_en.srt | 3.3 KB | ||
| 001 Concatenation in MySQL.mp4 | 33.1 MB | ||
| 001 Concatenation in MySQL_en.srt | 11.4 KB | ||
| 001 INNER JOIN.mp4 | 28.5 MB | ||
| 001 INNER JOIN_en.srt | 5.7 KB | ||
| 001 Introduction to Aggregate Functions.mp4 | 22.1 MB | ||
| 001 Introduction to Aggregate Functions_en.srt | 6.7 KB | ||
| 001 Introduction to Data Normalization.mp4 | 62.1 MB | ||
| 001 Introduction to Data Normalization_en.srt | 16.1 KB | ||
| 001 Introduction.mp4 | 17.8 MB | ||
| 001 Introduction_en.srt | 3.4 KB | ||
| 001 Self-contained Subqueries.mp4 | 20.8 MB | ||
| 001 Self-contained Subqueries_en.srt | 5.3 KB | ||
| 001 UNION and UNION ALL.mp4 | 43.7 MB | ||
| 001 UNION and UNION ALL_en.srt | 8.2 KB | ||
| 001 Understanding the Foundations of SQL.mp4 | 27.4 MB | ||
| 001 Understanding the Foundations of SQL_en.srt | 10.5 KB | ||
| 001 Views.mp4 | 38 MB | ||
| 001 Views_en.srt | 11.3 KB | ||
| 001 views-demo.sql | 1.2 KB | ||
| 002 Correlated Subqueries.mp4 | 29.6 MB | ||
| 002 Correlated Subqueries_en.srt | 7.1 KB | ||
| 002 Course-Databases-MySQL.sql | 505.3 KB | ||
| 002 Create Table Statement.mp4 | 87.3 MB | ||
| 002 Create Table Statement_en.srt | 21.2 KB | ||
| 002 Functional Dependencies.mp4 | 23.5 MB | ||
| 002 Functional Dependencies_en.srt | 6.2 KB | ||
| 002 GROUP BY and Aggregate Functions.mp4 | 23.6 MB | ||
| 002 GROUP BY and Aggregate Functions_en.srt | 6.9 KB | ||
| 002 LEFT OUTER JOIN and RIGHT OUTER JOIN.mp4 | 25.2 MB | ||
| 002 LEFT OUTER JOIN and RIGHT OUTER JOIN_en.srt | 4.3 KB | ||
| 002 OR Operator.mp4 | 10.4 MB | ||
| 002 OR Operator_en.srt | 3.5 KB | ||
| 002 SELECT Statement.mp4 | 31.1 MB | ||
| 002 SELECT Statement_en.srt | 12 KB | ||
| 002 Set Operator Challenges.mp4 | 8.3 MB | ||
| 002 Set Operator Challenges_en.srt | 2.4 KB | ||
| 002 Set-Operator-Challenges-including-hints.pdf | 143.9 KB | ||
| 002 Set-Operator-Challenges-without-hints.pdf | 142.1 KB | ||
| 002 String Manipulation Functions.mp4 | 30.5 MB | ||
| 002 String Manipulation Functions_en.srt | 11.8 KB | ||
| 002 Windows Installation and setup of Course Databases.mp4 | 60.9 MB | ||
| 002 Windows Installation and setup of Course Databases_en.srt | 14 KB | ||
| 003 CASE Expression.mp4 | 39 MB | ||
| 003 CASE Expression_en.srt | 7 KB | ||
| 003 EXISTS.mp4 | 21.3 MB | ||
| 003 EXISTS_en.srt | 4.6 KB | ||
| 003 FULL OUTER JOIN.mp4 | 17.6 MB | ||
| 003 FULL OUTER JOIN_en.srt | 4.4 KB | ||
| 003 Functional Dependencies.mp4 | 35 MB | ||
| 003 Functional Dependencies_en.srt | 9.6 KB | ||
| 003 HAVING Clause.mp4 | 18.5 MB | ||
| 003 HAVING Clause_en.srt | 5.8 KB | ||
| 003 INSERT Statement.mp4 | 18.3 MB | ||
| 003 INSERT Statement_en.srt | 6.3 KB | ||
| 003 Operator Precedence.mp4 | 15.6 MB | ||
| 003 Operator Precedence_en.srt | 4.8 KB | ||
| 003 Overview of the Course Challenges.mp4 | 13.7 MB | ||
| 003 Overview of the Course Challenges_en.srt | 4.6 KB | ||
| 003 SELECT Statement Challenges.mp4 | 7.9 MB | ||
| 003 SELECT Statement Challenges_en.srt | 2.5 KB | ||
| 003 Solutions to the Set Operator Challenges.mp4 | 63.7 MB | ||
| 003 Solutions to the Set Operator Challenges_en.srt | 11 KB | ||
| 003 Solutions-to-the-Set-Operator-Challenges.sql | 1.9 KB | ||
| 004 CASE Expression Challenges.mp4 | 25.6 MB | ||
| 004 CASE Expression Challenges_en.srt | 6.2 KB | ||
| 004 CASE-Expression-Challenges-including-hints.pdf | 191.3 KB | ||
| 004 CASE-Expression-Challenges-without-hints.pptx | 57.4 KB | ||
| 004 CREATE-TABLE-Challenges-including-hints.pdf | 175.2 KB | ||
| 004 CREATE-TABLE-Challenges-without-hints.pdf | 157.3 KB | ||
| 004 Candidate Keys and Super Keys.mp4 | 34.4 MB | ||
| 004 Candidate Keys and Super Keys_en.srt | 12.5 KB | ||
| 004 Create Table Challenges.mp4 | 23.3 MB | ||
| 004 Create Table Challenges_en.srt | 6.4 KB | ||
| 004 Entity-Relationship-Diagram.pdf | 45.3 KB | ||
| 004 IN Operator.mp4 | 13.3 MB | ||
| 004 IN Operator_en.srt | 3.8 KB | ||
| 004 Integrity Constraints.mp4 | 63.4 MB | ||
| 004 Integrity Constraints_en.srt | 15.7 KB | ||
| 004 Introduction to Window Functions.mp4 | 33.7 MB | ||
| 004 Introduction to Window Functions_en.srt | 7.7 KB | ||
| 004 Link-to-SQL-Server-Course.txt | 204.8 B | ||
| 004 Logical Query Processing Order.mp4 | 38.2 MB | ||
| 004 Logical Query Processing Order_en.srt | 9 KB | ||
| 004 Overview of Popular Relational Database Management Systems (Optional Lecture).mp4 | 21.9 MB | ||
| 004 Overview of Popular Relational Database Management Systems (Optional Lecture)_en.srt | 10.2 KB | ||
| 004 Solutions to the SELECT Challenges.mp4 | 41.4 MB | ||
| 004 Solutions to the SELECT Challenges_en.srt | 9.8 KB | ||
| 004 Solutions-to-the-SELECT-Challenges.sql | 307.2 B | ||
| 004 integrity-constraints-demo.sql | 819.2 B | ||
| 005 Common Table Expressions.mp4 | 35.7 MB | ||
| 005 Common Table Expressions_en.srt | 8.2 KB | ||
| 005 First Normal Form.mp4 | 47.7 MB | ||
| 005 First Normal Form_en.srt | 12.7 KB | ||
| 005 GROUP BY Challenges.mp4 | 12.2 MB | ||
| 005 GROUP BY Challenges_en.srt | 3.5 KB | ||
| 005 GROUP-BY-Challenges-including-hints.pdf | 135.1 KB | ||
| 005 GROUP-BY-Challenges-without-hints.pdf | 134.8 KB | ||
| 005 Logical Operator Challenges.mp4 | 6.5 MB | ||
| 005 Logical Operator Challenges_en.srt | 2.5 KB | ||
| 005 Logical-Operator-Challenges-including-hints.pdf | 139.2 KB | ||
| 005 Logical-Operator-Challenges-without-hints.pdf | 138.7 KB | ||
| 005 Many-to-many Relationships.mp4 | 33.7 MB | ||
| 005 Many-to-many Relationships_en.srt | 8.1 KB | ||
| 005 SELECT DISTINCT.mp4 | 21.5 MB | ||
| 005 SELECT DISTINCT_en.srt | 6.8 KB | ||
| 005 Solutions to the CASE Expression Challenges.mp4 | 97.6 MB | ||
| 005 Solutions to the CASE Expression Challenges_en.srt | 17.8 KB | ||
| 005 Solutions to the Create Table Challenges.mp4 | 45.5 MB | ||
| 005 Solutions to the Create Table Challenges_en.srt | 9.7 KB | ||
| 005 Solutions-to-the-CASE-Expresion-Challenges.sql | 3 KB | ||
| 005 Solutions-to-the-CREATE-TABLE-Challenges.sql | 1.5 KB | ||
| 006 Avoiding the NOT IN Trap.mp4 | 48 MB | ||
| 006 Avoiding the NOT IN Trap_en.srt | 12.3 KB | ||
| 006 Date and Time Functions in MySQL.mp4 | 90.6 MB | ||
| 006 Date and Time Functions in MySQL_en.srt | 17.8 KB | ||
| 006 Date-and-time-functions.sql | 4.1 KB | ||
| 006 Join Challenges.mp4 | 7.8 MB | ||
| 006 Join Challenges_en.srt | 2.2 KB | ||
| 006 Join-Challenges-including-hints.pdf | 112.7 KB | ||
| 006 Join-Challenges-without-hints.pdf | 110.4 KB | ||
| 006 Restructuring Multi-valued and Multi-Type Fields.mp4 | 21.7 MB | ||
| 006 Restructuring Multi-valued and Multi-Type Fields_en.srt | 6.7 KB | ||
| 006 SELECT DISTINCT Challenges.mp4 | 7.8 MB | ||
| 006 SELECT DISTINCT Challenges_en.srt | 2.5 KB | ||
| 006 Solution-to-the-UPDATE-Challenge.sql | 102.4 B | ||
| 006 Solutions to the GROUP BY Challenges.mp4 | 69.3 MB | ||
| 006 Solutions to the GROUP BY Challenges_en.srt | 14.2 KB | ||
| 006 Solutions to the Logical Operator Challenges.mp4 | 41.5 MB | ||
| 006 Solutions to the Logical Operator Challenges_en.srt | 7 KB | ||
| 006 Solutions-to-the-GROUP-BY-Challenges.sql | 1.6 KB | ||
| 006 Solutions-to-the-Logical-Operator-Challenges.sql | 1.1 KB | ||
| 006 UPDATE Statement.mp4 | 18 MB | ||
| 006 UPDATE Statement_en.srt | 5.9 KB | ||
| 006 create-and-populate-tables-dept-and-emp.sql | 1 KB | ||
| 007 DELETE Statement.mp4 | 12.1 MB | ||
| 007 DELETE Statement_en.srt | 4 KB | ||
| 007 Function Challenges.mp4 | 36.8 MB | ||
| 007 Function Challenges_en.srt | 8.7 KB | ||
| 007 Function-Challenges-including-hints.pdf | 293.7 KB | ||
| 007 Function-Challenges-without-hints.pdf | 262.6 KB | ||
| 007 Second Normal Form.mp4 | 17.1 MB | ||
| 007 Second Normal Form_en.srt | 5.7 KB | ||
| 007 Solution-to-the-DELETE-Challenge.sql | 102.4 B | ||
| 007 Solutions to the Join Challenges.mp4 | 38 MB | ||
| 007 Solutions to the Join Challenges_en.srt | 7.9 KB | ||
| 007 Solutions to the SELECT DISTINCT Challenges.mp4 | 19 MB | ||
| 007 Solutions to the SELECT DISTINCT Challenges_en.srt | 4.1 KB | ||
| 007 Solutions-to-SELECT-DISTINCT-Challenges.sql | 307.2 B | ||
| 007 Solutions-to-the-Join-Challenges.sql | 1.2 KB | ||
| 007 Subquery Challenges.mp4 | 23.4 MB | ||
| 007 Subquery Challenges_en.srt | 6.9 KB | ||
| 007 Subquery-Challenge-including-hints.pdf | 194.4 KB | ||
| 007 Subquery-Challenges-without-hints.pdf | 187.1 KB | ||
| 007 create-and-populate-tables-dept-and-emp.sql | 1 KB | ||
| 008 Composite Joins - joining on multiple columns.mp4 | 39.6 MB | ||
| 008 Composite Joins - joining on multiple columns_en.srt | 7.7 KB | ||
| 008 MySQL-documentation-links.txt | 409.6 B | ||
| 008 Row Ordering - ORDER BY.mp4 | 23.8 MB | ||
| 008 Row Ordering - ORDER BY_en.srt | 10 KB | ||
| 008 Solutions to the Function Challenges.mp4 | 71.4 MB | ||
| 008 Solutions to the Function Challenges_en.srt | 14.9 KB | ||
| 008 Solutions to the Subquery Challenges.mp4 | 76 MB | ||
| 008 Solutions to the Subquery Challenges_en.srt | 16 KB | ||
| 008 Solutions-to-the-Function-Challenges.sql | 2.7 KB | ||
| 008 Solutions-to-the-Subquery-Challenges.sql | 2.8 KB | ||
| 008 TRUNCATE TABLE Statement.mp4 | 38 MB | ||
| 008 TRUNCATE TABLE Statement_en.srt | 5.8 KB | ||
| 008 Third Normal Form.mp4 | 33.1 MB | ||
| 008 Third Normal Form_en.srt | 9.7 KB | ||
| 009 ALTER TABLE Statement.mp4 | 23.8 MB | ||
| 009 ALTER TABLE Statement_en.srt | 8.9 KB | ||
| 009 Boyce-Codd Normal Form.mp4 | 56 MB | ||
| 009 Boyce-Codd Normal Form_en.srt | 12.1 KB | ||
| 009 Joining more than two tables.mp4 | 24.2 MB | ||
| 009 Joining more than two tables_en.srt | 6.1 KB | ||
| 009 LIMIT Clause.mp4 | 17.8 MB | ||
| 009 LIMIT Clause_en.srt | 4.9 KB | ||
| 010 ALTER Table Challenges.mp4 | 5.3 MB | ||
| 010 ALTER Table Challenges_en.srt | 1.8 KB | ||
| 010 ALTER-TABLE-Challenges-including-hints.pdf | 123.2 KB | ||
| 010 ALTER-TABLE-Challenges-without-hints.pdf | 117.4 KB | ||
| 010 ORDER BY Challenges.mp4 | 7.5 MB | ||
| 010 ORDER BY Challenges_en.srt | 2.3 KB | ||
| 010 ORDER-BY-Challenges-including-hints.pdf | 163.9 KB | ||
| 010 ORDER-BY-Challenges-without-hints.pdf | 161.6 KB | ||
| 010 Predicate placement - ON clause vs WHERE clause.mp4 | 35.9 MB | ||
| 010 Predicate placement - ON clause vs WHERE clause_en.srt | 7.4 KB | ||
| 011 Self-referencing Joins.mp4 | 17.9 MB | ||
| 011 Self-referencing Joins_en.srt | 4.1 KB | ||
| 011 Solutions to the ALTER TABLE Challenges.mp4 | 33.7 MB | ||
| 011 Solutions to the ALTER TABLE Challenges_en.srt | 6.3 KB | ||
| 011 Solutions to the ORDER BY Challenges.mp4 | 43.6 MB | ||
| 011 Solutions to the ORDER BY Challenges_en.srt | 6.3 KB | ||
| 011 Solutions-to-the-ALTER-TABLE-Challenges.sql | 614.4 B | ||
| 011 Solutions-to-the-ORDER-BY-Challenges.sql | 1.3 KB | ||
| 012 Cross Joins.mp4 | 8.6 MB | ||
| 012 Cross Joins_en.srt | 2.4 KB | ||
| 012 DROP TABLE Statement.mp4 | 37.8 MB | ||
| 012 DROP TABLE Statement_en.srt | 9.2 KB | ||
| 012 DROP-TABLE-demo.sql | 716.8 B | ||
| 012 WHERE Clause - Three-valued Logic.mp4 | 17.7 MB | ||
| 012 WHERE Clause - Three-valued Logic_en.srt | 5.6 KB | ||
| 012 create-and-populate-tables-dept-and-emp.sql | 921.6 B | ||
| 013 Advanced Join Challenges.mp4 | 30 MB | ||
| 013 Advanced Join Challenges_en.srt | 6.9 KB | ||
| 013 Advanced-Join-Challenges-including-hints.pdf | 167.4 KB | ||
| 013 Advanced-Join-Challenges-without-hints.pdf | 158.9 KB | ||
| 013 Entity-Relationship-Diagram.pdf | 45.3 KB | ||
| 013 Replacing nulls in queries.mp4 | 26.7 MB | ||
| 013 Replacing nulls in queries_en.srt | 6.4 KB | ||
| 013 Transactions.mp4 | 44.7 MB | ||
| 013 Transactions_en.srt | 12.8 KB | ||
| 013 transaction-example.sql | 1.7 KB | ||
| 014 Solutions to the Advanced Join Challenges.mp4 | 142.7 MB | ||
| 014 Solutions to the Advanced Join Challenges_en.srt | 25.9 KB | ||
| 014 Solutions-to-the-Advanced-Join-Challenges.sql | 2.6 KB | ||
| 014 Stored Procedures.mp4 | 71.9 MB | ||
| 014 Stored Procedures_en.srt | 18.2 KB | ||
| 014 Stored-procedure-demo.sql | 1.1 KB | ||
| 014 WHERE Clause - Comparison Operators.mp4 | 13.8 MB | ||
| 014 WHERE Clause - Comparison Operators_en.srt | 4.8 KB | ||
| 015 Solution-to-the-UNIQUE-Constraint-Challenge.sql | 1.1 KB | ||
| 015 Solutions-to-the-WHERE-Clause-Challenges.sql | 614.4 B | ||
| 015 UNIQUE Constraints.mp4 | 40.8 MB | ||
| 015 UNIQUE Constraints_en.srt | 9.3 KB | ||
| 015 WHERE Clause Challenges.mp4 | 7.6 MB | ||
| 015 WHERE Clause Challenges_en.srt | 2.5 KB | ||
| 015 WHERE-Clause-Challenges-including-hints.pdf | 154.9 KB | ||
| 016 CHECK Constraints.mp4 | 17.7 MB | ||
| 016 CHECK Constraints_en.srt | 5.8 KB | ||
| 016 Solution-to-the-CHECK-Constraint-Challenge.sql | 204.8 B | ||
| 016 Solutions to the WHERE Clause Challenges.mp4 | 25.2 MB | ||
| 016 Solutions to the WHERE Clause Challenges_en.srt | 4.6 KB | ||
| 016 WHERE-Clause-Challenges-including-hints.pdf | 154.9 KB | ||
| 016 WHERE-Clause-Challenges-without-hints.pdf | 123.2 KB | ||
| 017 Introduction to Collations and Pattern Matching.mp4 | 45.4 MB | ||
| 017 Introduction to Collations and Pattern Matching_en.srt | 11.6 KB | ||
| 018 Pattern Matching - Part 2 - The LIKE Operator.mp4 | 17.4 MB | ||
| 018 Pattern Matching - Part 2 - The LIKE Operator_en.srt | 5 KB | ||
| 019 Pattern Matching Challenges.mp4 | 3.8 MB | ||
| 019 Pattern Matching Challenges_en.srt | 1.1 KB | ||
| 019 Pattern-Matching-Challenges-including-hints.pdf | 139.9 KB | ||
| 019 Pattern-Matching-Challenges-without-hints.pdf | 117.4 KB | ||
| 020 Solutions to the Pattern Matching Challenges.mp4 | 18.4 MB | ||
| 020 Solutions to the Pattern Matching Challenges_en.srt | 4.2 KB | ||
| 020 Solutions-to-Pattern-Matching-Challenges.sql | 819.2 B | ||
| 021 MySQL Data Types.mp4 | 32.4 MB | ||
| 021 MySQL Data Types_en.srt | 9.6 KB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 252 total files | |||
The Complete SQL Course with MySQL Database - Learn by Doing
https://DevCourseWeb.com
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 95 lectures (10h 5m) | Size: 2.15 GB
Master SQL and Database Design - Learn SQL for Advanced Data Analysis, Data Analytics, Business Intelligence, and more
What you'll learn
How to write MySQL queries for Data Analysis
How to query multiple tables using different types of joins
How to use MySQL Workbench
Actually practice writing SQL by solving challenges throughout the course
Write subqueries and use window functions
Aggregate data using GROUP BY
Learn the different set operators
Obtain a knowledge of SQL, and MySQL, allowing you to apply for jobs in the IT sector.
create and update database objects such as tables
Master unique tips and case studies that you won't find anywhere else
Requirements
No prior experience is required. We will start from the very basics
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 784.3 MB | freecoursewb | 1 week | 18 | 6 | |
| 2.2 GB | freecoursewb | 1 week | 0 | 0 | |
| 3.7 GB | freecoursewb | 1 week | 0 | 0 | |
| 3.3 GB | freecoursewb | 1 week | 24 | 16 | |
| 410.6 MB | freecoursewb | 1 week | 21 | 8 |
All Comments