SQL The Complete Developer Guide MySQL PostgreSQL | 4B97E5898F7AC625D7DA5BD5879EF8C2DC78ED44

SQL The Complete Developer Guide MySQL PostgreSQL

Name	SQL - The Complete Developer's Guide (MySQL, PostgreSQL)	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	8.7 GB
Total Files	432
Last Seen
Hash	4B97E5898F7AC625D7DA5BD5879EF8C2DC78ED44

/01 - Getting Started/
001 Welcome To The Course_.mp4	56.3 MB
01 - Getting Started/
001 Welcome To The Course__en.srt	3.9 KB
002 What Is SQL_.mp4	90.9 MB
002 What Is SQL__en.srt	9.5 KB
003 A Closer Look At SQL & Databases.mp4	94.1 MB
003 A Closer Look At SQL & Databases_en.srt	10.4 KB
004 Join Our Learning Community_.pdf	18.2 KB
005 Course Content.mp4	70.4 MB
005 Course Content_en.srt	5.5 KB
006 There Are Two Ways Of Taking This Course_.mp4	37.3 MB
006 There Are Two Ways Of Taking This Course__en.srt	4.3 KB
007 How To Get The Most Out Of This Course.mp4	57.9 MB
007 How To Get The Most Out Of This Course_en.srt	5.4 KB
008 Course Code & Resources.pdf	59.8 KB
02 - SQL Basics_ Syntax & Core Features/
001 Module Introduction.mp4	3.4 MB
001 Module Introduction_en.srt	1.3 KB
002 Understanding The Core SQL Syntax.mp4	35.0 MB
002 Understanding The Core SQL Syntax_en.srt	10.5 KB
003 SQL in Action.mp4	9.8 MB
003 SQL in Action_en.srt	5.7 KB
004 The Core SQL Rules.mp4	24.7 MB
004 The Core SQL Rules_en.srt	6.1 KB
005 Data Definition vs Data Manipulation.mp4	22.4 MB
005 Data Definition vs Data Manipulation_en.srt	5.4 KB
03 - Course Setup_ Installing MySQL & Postgresql/
001 Module Introduction.mp4	12.6 MB
001 Module Introduction_en.srt	4.3 KB
002 Installing Different Database Management Systems.mp4	16.7 MB
002 Installing Different Database Management Systems_en.srt	4.1 KB
003 What We Need To Install.mp4	13.2 MB
003 What We Need To Install_en.srt	11.1 KB
004-You-Can-Skip-The-Next-Lectures_.pdf	10.9 KB
005 MySQL Setup Overview & macOS Setup.mp4	109.3 MB
005 MySQL Setup Overview & macOS Setup_en.srt	17.0 KB
006 MySQL Windows Setup.mp4	61.5 MB
006 MySQL Windows Setup_en.srt	13.7 KB
007 Postgresql Setup Overview & macOS Setup.mp4	61.5 MB
007 Postgresql Setup Overview & macOS Setup_en.srt	10.2 KB
008 Postgresql Windows Setup.mp4	29.9 MB
008 Postgresql Windows Setup_en.srt	7.3 KB
009-Starting-_-Stopping-Servers-Uninstalling-Database-Systems.pdf	12.9 KB
010 Connecting To Database Servers (MySQL & Postgresql) With Various Clients.mp4	90.9 MB
010 Connecting To Database Servers (MySQL & Postgresql) With Various Clients_en.srt	26.8 KB
011 Setting Up Visual Studio Code With The SQLTools Extension (Course Environment).mp4	70.8 MB
011 Setting Up Visual Studio Code With The SQLTools Extension (Course Environment)_en.srt	17.3 KB
012 Configuring VS Code & Exploring SQLTools.mp4	58.9 MB
012 Configuring VS Code & Exploring SQLTools_en.srt	20.5 KB
013-More-On-VS-Code-_-SQLTools.pdf	16.8 KB
external-assets-links.txt	0.4 KB
04 - Data Definition_ Managing Tables & Working With Data Types/
001 Module Introduction.mp4	36.3 MB
001 Module Introduction_en.srt	3.3 KB
002 Key Terms When Working With Data Definition Statements & Commands.mp4	48.0 MB
002 Key Terms When Working With Data Definition Statements & Commands_en.srt	4.8 KB
003 Introducing The Course Section Example.mp4	42.4 MB
003 Introducing The Course Section Example_en.srt	3.9 KB
004 Introducing Key Data Definition Clauses.mp4	47.1 MB
004 Introducing Key Data Definition Clauses_en.srt	5.4 KB
005 Creating a new Database (CREATE DATABASE).mp4	55.6 MB
005 Creating a new Database (CREATE DATABASE)_en.srt	16.8 KB
006-Deleting-Databases-_-IF-NOT-EXISTS.pdf	21.9 KB
007 The Importance Of Data Types (Value Types).mp4	93.5 MB
007 The Importance Of Data Types (Value Types)_en.srt	9.7 KB
008 Introducing Key Text Value Types.mp4	111.8 MB
008 Introducing Key Text Value Types_en.srt	10.7 KB
009 Introducing Numeric Values, Date Types & More.mp4	93.7 MB
009 Introducing Numeric Values, Date Types & More_en.srt	9.5 KB
010-An-Overview-Of-Numeric-Value-Types.pdf	25.0 KB
011 How Do You Store Files_.mp4	20.7 MB
011 How Do You Store Files__en.srt	5.4 KB
012 Getting Started With The CREATE TABLE Statement & Syntax.mp4	32.2 MB
012 Getting Started With The CREATE TABLE Statement & Syntax_en.srt	8.5 KB
013 Creating a First Text Column.mp4	18.8 MB
013 Creating a First Text Column_en.srt	6.1 KB
014 Creating a Numeric Value Column.mp4	61.3 MB
014 Creating a Numeric Value Column_en.srt	14.5 KB
015 Working with Enums & Finishing Table Creation.mp4	50.1 MB
015 Working with Enums & Finishing Table Creation_en.srt	11.5 KB
016 Inserting Data Into The Created Table (INSERT INTO).mp4	31.7 MB
016 Inserting Data Into The Created Table (INSERT INTO)_en.srt	9.9 KB
017 Inserting & Querying More Data.mp4	32.6 MB
017 Inserting & Querying More Data_en.srt	6.1 KB
018 Working With Fixed Point & Floating Point Numbers.mp4	59.0 MB
018 Working With Fixed Point & Floating Point Numbers_en.srt	13.3 KB
019 Adding Boolean Value Types.mp4	13.2 MB
019 Adding Boolean Value Types_en.srt	3.0 KB
020 Creating a new Table with Text & Timestamp Data.mp4	30.2 MB
020 Creating a new Table with Text & Timestamp Data_en.srt	8.5 KB
021 Inserting Data Into The New Tables.mp4	64.4 MB
021 Inserting Data Into The New Tables_en.srt	10.6 KB
022-What-About-Time-Zones_.pdf	12.5 KB
023 Introducing Default Column Values.mp4	22.6 MB
023 Introducing Default Column Values_en.srt	5.0 KB
024 Deleting (Dropping) Tables & Inserting Data With Default Values.mp4	46.2 MB
024 Deleting (Dropping) Tables & Inserting Data With Default Values_en.srt	7.9 KB
025 Updating Tables & Columns.mp4	70.9 MB
025 Updating Tables & Columns_en.srt	13.5 KB
026 Dealing With _No Data_ (NULL) vs _0_.mp4	67.5 MB
026 Dealing With _No Data_ (NULL) vs _0__en.srt	10.7 KB
027-NULL-Values_-Inserting-_No_-Data-_-Default-Values.pdf	15.5 KB
028 Exploring the NOT NULL Constraint.mp4	86.9 MB
028 Exploring the NOT NULL Constraint_en.srt	15.6 KB
029 Exploring the CHECK Constraint.mp4	74.4 MB
029 Exploring the CHECK Constraint_en.srt	20.5 KB
030 We Need Unique Values & Identifiers_.mp4	65.0 MB
030 We Need Unique Values & Identifiers__en.srt	18.7 KB
031-SERIAL-in-MySQL-vs-SERIAL-in-Postgresql.pdf	8.4 KB
032 Working With Auto Incrementing IDs & Primary Keys.mp4	92.1 MB
032 Working With Auto Incrementing IDs & Primary Keys_en.srt	15.9 KB
033-Auto-IDs_-Primary-Keys-_-Inserting-Data.pdf	19.5 KB
034 Constraints - Summary.mp4	15.2 MB
034 Constraints - Summary_en.srt	4.8 KB
035 Understanding Text Encoding & Collation.mp4	68.2 MB
035 Understanding Text Encoding & Collation_en.srt	16.4 KB
036 Temporary Tables & Tables From Other Tables.mp4	19.4 MB
036 Temporary Tables & Tables From Other Tables_en.srt	4.5 KB
037 Creating Generated Columns.mp4	73.3 MB
037 Creating Generated Columns_en.srt	12.1 KB
038 Module Summary.mp4	22.7 MB
038 Module Summary_en.srt	5.4 KB
039 Time To Practice_ Problem.mp4	21.0 MB
039 Time To Practice_ Problem_en.srt	7.3 KB
040 Time To Practice_ Solution (1_2).mp4	87.6 MB
040 Time To Practice_ Solution (1_2)_en.srt	20.5 KB
041 Time To Practice_ Solution (2_2).mp4	79.1 MB
041 Time To Practice_ Solution (2_2)_en.srt	13.4 KB
external-assets-links.txt	0.4 KB
05 - Data Manipulation & Querying_ CRUD Operations With SQL/
001 Module Introduction.mp4	5.8 MB
001 Module Introduction_en.srt	2.1 KB
002 What Are CRUD Operations_.mp4	12.5 MB
002 What Are CRUD Operations__en.srt	3.8 KB
003 Inserting Data_ Theory.mp4	4.4 MB
003 Inserting Data_ Theory_en.srt	4.4 KB
004 Selecting Data_ Theory.mp4	7.9 MB
004 Selecting Data_ Theory_en.srt	2.1 KB
005 Updating Data_ Theory.mp4	7.4 MB
005 Updating Data_ Theory_en.srt	2.4 KB
006 Deleting Data_ Theory.mp4	6.0 MB
006 Deleting Data_ Theory_en.srt	2.2 KB
007 Introducing The Section Example.mp4	20.1 MB
007 Introducing The Section Example_en.srt	6.2 KB
008 Setting Up An Example Database & Table.mp4	51.9 MB
008 Setting Up An Example Database & Table_en.srt	12.2 KB
009 Example_ Inserting Data.mp4	50.1 MB
009 Example_ Inserting Data_en.srt	11.2 KB
010 Inserting More (Dummy) Data.mp4	12.4 MB
010 Inserting More (Dummy) Data_en.srt	1.7 KB
011 Updating In Action.mp4	31.7 MB
011 Updating In Action_en.srt	8.7 KB
012 Deleting In Action.mp4	11.8 MB
012 Deleting In Action_en.srt	3.5 KB
013 Selecting Data - The Basics.mp4	28.4 MB
013 Selecting Data - The Basics_en.srt	7.5 KB
014 SELECT, Column Names & Data Expressions.mp4	28.1 MB
014 SELECT, Column Names & Data Expressions_en.srt	7.5 KB
015 Filtering with WHERE_ Available Comparison Operators & Variations.mp4	22.3 MB
015 Filtering with WHERE_ Available Comparison Operators & Variations_en.srt	7.2 KB
016 Filtering In Action (WHERE In Action).mp4	23.8 MB
016 Filtering In Action (WHERE In Action)_en.srt	5.9 KB
017 Combining Comparisons With AND & OR.mp4	25.0 MB
017 Combining Comparisons With AND & OR_en.srt	5.6 KB
018 Greater, Smaller & Ranges.mp4	52.8 MB
018 Greater, Smaller & Ranges_en.srt	11.6 KB
019 Filtering Text Values.mp4	31.0 MB
019 Filtering Text Values_en.srt	7.0 KB
020 Working With Dates & Date Differences.mp4	42.2 MB
020 Working With Dates & Date Differences_en.srt	8.0 KB
021 Filtering Conditions Without Hard-Coded Values.pdf	61.0 KB
022 Introducing ORDER BY & LIMIT.mp4	13.0 MB
022 Introducing ORDER BY & LIMIT_en.srt	3.2 KB
023 Ordering & Limiting Results In Action.mp4	53.8 MB
023 Ordering & Limiting Results In Action_en.srt	11.0 KB
024 Looking For DISTINCT Values.mp4	11.4 MB
024 Looking For DISTINCT Values_en.srt	2.4 KB
025 Subqueries & Views.mp4	44.8 MB
025 Subqueries & Views_en.srt	11.0 KB
026 Module Summary.mp4	17.0 MB
026 Module Summary_en.srt	4.1 KB
external-assets-links.txt	0.3 KB
06 - Data Normalization & Relationships_ Splitting & JOINing Data/
001 Module Introduction.mp4	8.4 MB
001 Module Introduction_en.srt	2.7 KB
002 A First Look At Related Data.mp4	28.9 MB
002 A First Look At Related Data_en.srt	6.9 KB
003 Data Normalization - First Steps.mp4	23.6 MB
003 Data Normalization - First Steps_en.srt	6.6 KB
004 Splitting Data Into Tables.mp4	67.0 MB
004 Splitting Data Into Tables_en.srt	15.7 KB
005 Forms Of Data Normalization.mp4	20.9 MB
005 Forms Of Data Normalization_en.srt	5.0 KB
006 Our First Section Example.mp4	21.0 MB
006 Our First Section Example_en.srt	6.2 KB
007 Creating Tables With Relations.mp4	80.3 MB
007 Creating Tables With Relations_en.srt	16.6 KB
008 Inserting Related Data.mp4	66.3 MB
008 Inserting Related Data_en.srt	12.6 KB
009 Joining Data & Introducing INNER JOIN.mp4	27.4 MB
009 Joining Data & Introducing INNER JOIN_en.srt	6.3 KB
010 Using INNER JOIN.mp4	46.7 MB
010 Using INNER JOIN_en.srt	12.5 KB
011 Combining Multiple JOINs.mp4	27.3 MB
011 Combining Multiple JOINs_en.srt	6.9 KB
012 Data Joining & Filtering.mp4	28.8 MB
012 Data Joining & Filtering_en.srt	6.0 KB
013 Introducing LEFT JOIN.mp4	14.6 MB
013 Introducing LEFT JOIN_en.srt	3.5 KB
014 Using LEFT JOIN.mp4	23.8 MB
014 Using LEFT JOIN_en.srt	6.0 KB
015 Combining Multiple LEFT JOINs.mp4	16.9 MB
015 Combining Multiple LEFT JOINs_en.srt	4.5 KB
016 What About RIGHT JOIN_.mp4	9.2 MB
016 What About RIGHT JOIN__en.srt	2.2 KB
017 Example Time & INNER JOIN vs LEFT JOIN.mp4	80.2 MB
017 Example Time & INNER JOIN vs LEFT JOIN_en.srt	20.2 KB
018 Introducing CROSS JOIN.mp4	11.4 MB
018 Introducing CROSS JOIN_en.srt	2.8 KB
019 UNION & Why It's Different.mp4	53.4 MB
019 UNION & Why It's Different_en.srt	14.6 KB
020 What's Wrong With Our Foreign Keys_.mp4	47.1 MB
020 What's Wrong With Our Foreign Keys__en.srt	8.1 KB
021 Introducing Foreign Key Constraints.mp4	22.9 MB
021 Introducing Foreign Key Constraints_en.srt	6.3 KB
022 Diving Deeper Into Foreign Key Constraints.mp4	46.5 MB
022 Diving Deeper Into Foreign Key Constraints_en.srt	8.7 KB
023 Updating & Removing Foreign Key Constraints.pdf	77.0 KB
024 Foreign Key Constraints In Action.mp4	102.5 MB
024 Foreign Key Constraints In Action_en.srt	20.8 KB
025 Data Relationship Types_ One-to-Many, Many-to-Many, One-to-ONe.mp4	28.3 MB
025 Data Relationship Types_ One-to-Many, Many-to-Many, One-to-ONe_en.srt	6.9 KB
026 A Bigger Example.mp4	31.9 MB
026 A Bigger Example_en.srt	9.6 KB
027 Example_ Adding First Tables & Relations.mp4	138.8 MB
027 Example_ Adding First Tables & Relations_en.srt	26.9 KB
028 Example_ Adding More Tables & Data.mp4	114.6 MB
028 Example_ Adding More Tables & Data_en.srt	18.0 KB
029 Many-to-Many Relationships & Intermediate Tables (_Linking Tables_).mp4	66.3 MB
029 Many-to-Many Relationships & Intermediate Tables (_Linking Tables_)_en.srt	11.0 KB
030 Querying The Example Data.mp4	59.1 MB
030 Querying The Example Data_en.srt	14.1 KB
031 Practicing JOINs With Filtering.mp4	76.0 MB
031 Practicing JOINs With Filtering_en.srt	15.0 KB
032 Experimenting With Referential Integrity.mp4	51.9 MB
032 Experimenting With Referential Integrity_en.srt	9.0 KB
external-assets-links.txt	0.5 KB
07 - More On Primary & Foreign Keys/
001 Module Introduction.mp4	6.7 MB
001 Module Introduction_en.srt	2.6 KB
002 Remember_ Primary Keys Don't Have To Be Auto-Incrementing IDs_.mp4	22.4 MB
002 Remember_ Primary Keys Don't Have To Be Auto-Incrementing IDs__en.srt	4.5 KB
003 Primary Keys_ When To Use Which Column.pdf	39.0 KB
004 Introducing Composite Primary Keys.mp4	16.4 MB
004 Introducing Composite Primary Keys_en.srt	12.9 KB
005 Defining Composite Primary Keys (Composite Keys In Action).mp4	20.6 MB
005 Defining Composite Primary Keys (Composite Keys In Action)_en.srt	3.8 KB
006 Composite Foreign Keys.mp4	39.9 MB
006 Composite Foreign Keys_en.srt	7.8 KB
007 Composite Keys In Action.mp4	23.2 MB
007 Composite Keys In Action_en.srt	4.1 KB
008 Self-Referencing Relationships (Self-Referential Relationships).mp4	54.9 MB
008 Self-Referencing Relationships (Self-Referential Relationships)_en.srt	13.2 KB
009 Self-Referencing Many To Many Relationships.mp4	48.9 MB
009 Self-Referencing Many To Many Relationships_en.srt	11.5 KB
08 - Grouping & Aggregate Functions/
001 Module Introduction.mp4	6.8 MB
001 Module Introduction_en.srt	2.2 KB
002 The Module Project.mp4	21.6 MB
002 The Module Project_en.srt	7.0 KB
003 What are Aggregate Functions - Theory.mp4	24.3 MB
003 What are Aggregate Functions - Theory_en.srt	6.9 KB
004 Understanding COUNT().mp4	62.2 MB
004 Understanding COUNT()_en.srt	16.3 KB
005 Working with MIN() & MAX() and Adding Aliases to Aggregate Functions.mp4	44.8 MB
005 Working with MIN() & MAX() and Adding Aliases to Aggregate Functions_en.srt	10.9 KB
006 Using SUM(), AVG() & ROUND().mp4	34.0 MB
006 Using SUM(), AVG() & ROUND()_en.srt	9.7 KB
007 Working with Filters & Joining Tables.mp4	75.0 MB
007 Working with Filters & Joining Tables_en.srt	16.0 KB
008 Theory Time - Understanding GROUP BY.mp4	27.2 MB
008 Theory Time - Understanding GROUP BY_en.srt	7.8 KB
009 Applying GROUP BY in Practice.mp4	27.8 MB
009 Applying GROUP BY in Practice_en.srt	6.7 KB
010 GROUP BY & Joined Queries.mp4	47.1 MB
010 GROUP BY & Joined Queries_en.srt	8.2 KB
011 Understanding WHERE vs HAVING.mp4	56.4 MB
011 Understanding WHERE vs HAVING_en.srt	15.2 KB
012 Applying HAVING in Practice.mp4	50.9 MB
012 Applying HAVING in Practice_en.srt	10.8 KB
013 Working with Nested Subqueries.mp4	57.1 MB
013 Working with Nested Subqueries_en.srt	15.8 KB
014 Introducing Window Functions.mp4	41.8 MB
014 Introducing Window Functions_en.srt	13.3 KB
015 Understanding ORDER BY and RANK().mp4	53.0 MB
015 Understanding ORDER BY and RANK()_en.srt	10.5 KB
external-assets-links.txt	0.5 KB
09 - Built-in Query Functions & Operators/
001 Module Introduction.mp4	9.4 MB
001 Module Introduction_en.srt	2.9 KB
002 The Module Project.mp4	14.8 MB
002 The Module Project_en.srt	5.2 KB
003 Working with Mathematical Functions & Arithmetic Operators.mp4	103.0 MB
003 Working with Mathematical Functions & Arithmetic Operators_en.srt	22.8 KB
004 Understanding String Functions with SELECT.mp4	47.1 MB
004 Understanding String Functions with SELECT_en.srt	10.3 KB
005 Using String Functions with INSERT.mp4	68.6 MB
005 Using String Functions with INSERT_en.srt	12.7 KB
006 Understanding Date _ Time Functions.mp4	25.2 MB
006 Understanding Date _ Time Functions_en.srt	6.3 KB
007 Working with Weekdays.mp4	45.5 MB
007 Working with Weekdays_en.srt	11.0 KB
008 Calculating INTERVALS.mp4	49.4 MB
008 Calculating INTERVALS_en.srt	14.1 KB
009 Adding INTERVALS to Dates.mp4	38.9 MB
009 Adding INTERVALS to Dates_en.srt	10.6 KB
010 Understanding LIKE & Pattern Matching.mp4	43.5 MB
010 Understanding LIKE & Pattern Matching_en.srt	14.0 KB
011 Understanding EXISTS.mp4	39.9 MB
011 Understanding EXISTS_en.srt	10.2 KB
012 Working with Subquery Expressions and EXISTS.mp4	32.2 MB
012 Working with Subquery Expressions and EXISTS_en.srt	6.3 KB
013 Working with Subquery Expressions and IN.mp4	62.7 MB
013 Working with Subquery Expressions and IN_en.srt	12.4 KB
014 Introducing Conditional Expressions.mp4	47.0 MB
014 Introducing Conditional Expressions_en.srt	11.1 KB
015 Challenge Solution.mp4	38.9 MB
015 Challenge Solution_en.srt	6.1 KB
016 Database (SQL) vs Application Level.mp4	18.1 MB
016 Database (SQL) vs Application Level_en.srt	5.4 KB
external-assets-links.txt	1.7 KB
10 - Database Transactions/
001 Module Introduction.mp4	3.9 MB
001 Module Introduction_en.srt	1.3 KB
002 Understanding Transactions.mp4	11.4 MB
002 Understanding Transactions_en.srt	3.7 KB
003 A Note About This Module's Project.pdf	9.9 KB
004 Applying Transactions & ROLLBACK.mp4	65.1 MB
004 Applying Transactions & ROLLBACK_en.srt	14.0 KB
005 Committing Changes.mp4	66.5 MB
005 Committing Changes_en.srt	12.4 KB
006 Working with Savepoints.mp4	36.1 MB
006 Working with Savepoints_en.srt	6.8 KB
007 Transactions in PostgreSQL.mp4	36.0 MB
007 Transactions in PostgreSQL_en.srt	7.1 KB
external-assets-links.txt	0.4 KB
11 - Using Indexes/
001 Module Introduction.mp4	5.7 MB
001 Module Introduction_en.srt	1.6 KB
002 What Are Indexes_ And Why Would You Need Them_.mp4	40.4 MB
002 What Are Indexes_ And Why Would You Need Them__en.srt	9.8 KB
003 Don't Use Too Many Indexes_.mp4	7.9 MB
003 Don't Use Too Many Indexes__en.srt	7.2 KB
004 Index Types_ An Overview.mp4	34.3 MB
004 Index Types_ An Overview_en.srt	8.6 KB
005 Setting Up Some Example Data.mp4	35.2 MB
005 Setting Up Some Example Data_en.srt	5.2 KB
006 EXPLAINing Queries & Query Planning.mp4	28.9 MB
006 EXPLAINing Queries & Query Planning_en.srt	8.8 KB
007 Creating & Using Single-Column Indexes.mp4	25.7 MB
007 Creating & Using Single-Column Indexes_en.srt	10.2 KB
008 More on Creating & Dropping Indexes.pdf	24.8 KB
009 Unique Indexes.mp4	16.1 MB
009 Unique Indexes_en.srt	3.5 KB
010 Working With Multi-Column Indexes (Composite Indexes).mp4	50.3 MB
010 Working With Multi-Column Indexes (Composite Indexes)_en.srt	15.4 KB
011 Partial Indexes.mp4	16.7 MB
011 Partial Indexes_en.srt	4.5 KB
external-assets-links.txt	0.3 KB
12 - Summary & Practice_ A Complete Example/
001 Module Introduction.mp4	26.6 MB
001 Module Introduction_en.srt	3.1 KB
002 What Is SQL_.mp4	90.9 MB
002 What Is SQL__en.srt	9.7 KB
003 A Closer Look At Databases In General.mp4	94.1 MB
003 A Closer Look At Databases In General_en.srt	10.5 KB
004 The Core SQL Syntax.mp4	100.6 MB
004 The Core SQL Syntax_en.srt	11.0 KB
005 Course Setup (For Following Along).mp4	74.8 MB
005 Course Setup (For Following Along)_en.srt	8.4 KB
006 Analyzing The Section Example Project.mp4	39.1 MB
006 Analyzing The Section Example Project_en.srt	10.2 KB
007 Introducing _Data Normalization_.mp4	22.0 MB
007 Introducing _Data Normalization__en.srt	5.5 KB
008 Planning Tables & Relationships.mp4	59.0 MB
008 Planning Tables & Relationships_en.srt	16.2 KB
009 Creating A New Database.mp4	20.5 MB
009 Creating A New Database_en.srt	6.9 KB
010 Choosing Identifier Names.mp4	11.7 MB
010 Choosing Identifier Names_en.srt	5.3 KB
011 Defining Columns.mp4	14.2 MB
011 Defining Columns_en.srt	6.0 KB
012 Exploring Important Data Types.mp4	38.9 MB
012 Exploring Important Data Types_en.srt	9.1 KB
013 How To Store Files & Adding More Data Types.mp4	24.3 MB
013 How To Store Files & Adding More Data Types_en.srt	6.8 KB
014 Constraints_ An Introduction.mp4	38.2 MB
014 Constraints_ An Introduction_en.srt	8.4 KB
015 Introducing Database Functions.mp4	23.6 MB
015 Introducing Database Functions_en.srt	4.1 KB
016 Understanding Primary Keys & Unique IDs.mp4	50.6 MB
016 Understanding Primary Keys & Unique IDs_en.srt	9.8 KB
017 INSERTing Data.mp4	58.0 MB
017 INSERTing Data_en.srt	12.5 KB
018 Basic Data Querying (via SELECT).mp4	12.2 MB
018 Basic Data Querying (via SELECT)_en.srt	4.0 KB
019 UPDATE & DELETE In Action.mp4	37.6 MB
019 UPDATE & DELETE In Action_en.srt	9.0 KB
020 Filtering (WHERE) & Sorting (ORDER BY).mp4	23.8 MB
020 Filtering (WHERE) & Sorting (ORDER BY)_en.srt	7.4 KB
021 Adding More Tables.mp4	54.0 MB
021 Adding More Tables_en.srt	13.5 KB
022 Relations & Foreign Keys.mp4	87.1 MB
022 Relations & Foreign Keys_en.srt	15.8 KB
023 Understanding ON DELETE & ON UPDATE.mp4	34.6 MB
023 Understanding ON DELETE & ON UPDATE_en.srt	5.5 KB
024 Adding More Tables & Relationships.mp4	71.0 MB
024 Adding More Tables & Relationships_en.srt	12.1 KB
025 Many To Many Relationships & Linking (Intermediate) Tables.mp4	80.3 MB
025 Many To Many Relationships & Linking (Intermediate) Tables_en.srt	13.9 KB
026 Inserting Related Data.mp4	138.6 MB
026 Inserting Related Data_en.srt	21.4 KB
027 Connecting Data With INNER JOIN.mp4	64.0 MB
027 Connecting Data With INNER JOIN_en.srt	18.2 KB
028 Combining Multiple Joins.mp4	43.6 MB
028 Combining Multiple Joins_en.srt	8.7 KB
029 Introducing LEFT JOIN.mp4	88.7 MB
029 Introducing LEFT JOIN_en.srt	18.0 KB
030 Joining Data & Filtering.mp4	31.5 MB
030 Joining Data & Filtering_en.srt	6.7 KB
031 Filtering Text With LIKE.mp4	35.4 MB
031 Filtering Text With LIKE_en.srt	9.3 KB
032 Introducing Aggregate Functions.mp4	21.4 MB
032 Introducing Aggregate Functions_en.srt	6.4 KB
033 Grouping Aggregate Results (GROUP BY).mp4	39.3 MB
033 Grouping Aggregate Results (GROUP BY)_en.srt	9.5 KB
034 The HAVING Clause (vs WHERE).mp4	34.2 MB
034 The HAVING Clause (vs WHERE)_en.srt	5.5 KB
035 Module Summary.mp4	20.1 MB
035 Module Summary_en.srt	2.8 KB
external-assets-links.txt	0.1 KB
13 - Course Roundup/
001 Congratulations + Bonus Content.mp4	20.9 MB
001 Congratulations + Bonus Content_en.srt	1.6 KB
external-assets-links.txt	0.1 KB
Total files 432