[FreeCourseSite.com] Udemy - SQL - The Complete Developer's Guide (MySQL, PostgreSQL)

File Name

Size

0. Websites you may like/[CourseClub.ME].url

122 B

0. Websites you may like/[FCS Forum].url

133 B

0. Websites you may like/[FreeCourseSite.com].url

127 B

0. Websites you may like/[GigaCourse.Com].url

49 B

01 - Getting Started/001 Welcome To The Course_.mp4

54 MB

01 - Getting Started/001 Welcome To The Course__en.srt

3.8 kB

01 - Getting Started/002 What Is SQL_.mp4

87 MB

01 - Getting Started/002 What Is SQL__en.srt

9.2 kB

01 - Getting Started/003 A Closer Look At SQL & Databases.mp4

90 MB

01 - Getting Started/003 A Closer Look At SQL & Databases_en.srt

10 kB

01 - Getting Started/004 Join Our Learning Community_.html

801 B

01 - Getting Started/005 Course Content.mp4

67 MB

01 - Getting Started/005 Course Content_en.srt

5.4 kB

01 - Getting Started/006 There Are Two Ways Of Taking This Course_.mp4

36 MB

01 - Getting Started/006 There Are Two Ways Of Taking This Course__en.srt

4.2 kB

01 - Getting Started/007 How To Get The Most Out Of This Course.mp4

55 MB

01 - Getting Started/007 How To Get The Most Out Of This Course_en.srt

5.2 kB

01 - Getting Started/008 Course Code & Resources.html

777 B

02 - SQL Basics_ Syntax & Core Features/001 Module Introduction.mp4

3.2 MB

02 - SQL Basics_ Syntax & Core Features/001 Module Introduction_en.srt

1.2 kB

02 - SQL Basics_ Syntax & Core Features/002 Understanding The Core SQL Syntax.mp4

33 MB

02 - SQL Basics_ Syntax & Core Features/002 Understanding The Core SQL Syntax_en.srt

10 kB

02 - SQL Basics_ Syntax & Core Features/003 SQL in Action.mp4

9.3 MB

02 - SQL Basics_ Syntax & Core Features/003 SQL in Action_en.srt

5.6 kB

02 - SQL Basics_ Syntax & Core Features/004 The Core SQL Rules.mp4

24 MB

02 - SQL Basics_ Syntax & Core Features/004 The Core SQL Rules_en.srt

6.0 kB

02 - SQL Basics_ Syntax & Core Features/005 Data Definition vs Data Manipulation.mp4

21 MB

02 - SQL Basics_ Syntax & Core Features/005 Data Definition vs Data Manipulation_en.srt

5.3 kB

03 - Course Setup_ Installing MySQL & Postgresql/001 Module Introduction.mp4

12 MB

03 - Course Setup_ Installing MySQL & Postgresql/001 Module Introduction_en.srt

4.2 kB

03 - Course Setup_ Installing MySQL & Postgresql/002 Installing Different Database Management Systems.mp4

16 MB

03 - Course Setup_ Installing MySQL & Postgresql/002 Installing Different Database Management Systems_en.srt

4.0 kB

03 - Course Setup_ Installing MySQL & Postgresql/003 What We Need To Install.mp4

13 MB

03 - Course Setup_ Installing MySQL & Postgresql/003 What We Need To Install_en.srt

11 kB

03 - Course Setup_ Installing MySQL & Postgresql/004 You Can Skip The Next Lectures_.html

454 B

03 - Course Setup_ Installing MySQL & Postgresql/005 MySQL Setup Overview & macOS Setup.mp4

104 MB

03 - Course Setup_ Installing MySQL & Postgresql/005 MySQL Setup Overview & macOS Setup_en.srt

17 kB

03 - Course Setup_ Installing MySQL & Postgresql/006 MySQL Windows Setup.mp4

59 MB

03 - Course Setup_ Installing MySQL & Postgresql/006 MySQL Windows Setup_en.srt

13 kB

03 - Course Setup_ Installing MySQL & Postgresql/007 Postgresql Setup Overview & macOS Setup.mp4

59 MB

03 - Course Setup_ Installing MySQL & Postgresql/007 Postgresql Setup Overview & macOS Setup_en.srt

9.9 kB

03 - Course Setup_ Installing MySQL & Postgresql/008 Postgresql Windows Setup.mp4

28 MB

03 - Course Setup_ Installing MySQL & Postgresql/008 Postgresql Windows Setup_en.srt

7.1 kB

03 - Course Setup_ Installing MySQL & Postgresql/009 Starting & Stopping Servers + Uninstalling Database Systems.html

1.5 kB

03 - Course Setup_ Installing MySQL & Postgresql/010 Connecting To Database Servers (MySQL & Postgresql) With Various Clients.mp4

87 MB

03 - Course Setup_ Installing MySQL & Postgresql/010 Connecting To Database Servers (MySQL & Postgresql) With Various Clients_en.srt

26 kB

03 - Course Setup_ Installing MySQL & Postgresql/011 Setting Up Visual Studio Code With The SQLTools Extension (Course Environment).mp4

68 MB

03 - Course Setup_ Installing MySQL & Postgresql/011 Setting Up Visual Studio Code With The SQLTools Extension (Course Environment)_en.srt

17 kB

03 - Course Setup_ Installing MySQL & Postgresql/012 Configuring VS Code & Exploring SQLTools.mp4

56 MB

03 - Course Setup_ Installing MySQL & Postgresql/012 Configuring VS Code & Exploring SQLTools_en.srt

20 kB

03 - Course Setup_ Installing MySQL & Postgresql/013 More On VS Code & SQLTools.html

1.3 kB

03 - Course Setup_ Installing MySQL & Postgresql/external-assets-links.txt

350 B

04 - Data Definition_ Managing Tables & Working With Data Types/001 Module Introduction.mp4

35 MB

04 - Data Definition_ Managing Tables & Working With Data Types/001 Module Introduction_en.srt

3.2 kB

04 - Data Definition_ Managing Tables & Working With Data Types/002 Key Terms When Working With Data Definition Statements & Commands.mp4

46 MB

04 - Data Definition_ Managing Tables & Working With Data Types/002 Key Terms When Working With Data Definition Statements & Commands_en.srt

4.7 kB

04 - Data Definition_ Managing Tables & Working With Data Types/003 Introducing The Course Section Example.mp4

40 MB

04 - Data Definition_ Managing Tables & Working With Data Types/003 Introducing The Course Section Example_en.srt

3.8 kB

04 - Data Definition_ Managing Tables & Working With Data Types/004 Introducing Key Data Definition Clauses.mp4

45 MB

04 - Data Definition_ Managing Tables & Working With Data Types/004 Introducing Key Data Definition Clauses_en.srt

5.2 kB

04 - Data Definition_ Managing Tables & Working With Data Types/005 Creating a new Database (CREATE DATABASE).mp4

53 MB

04 - Data Definition_ Managing Tables & Working With Data Types/005 Creating a new Database (CREATE DATABASE)_en.srt

16 kB

04 - Data Definition_ Managing Tables & Working With Data Types/006 Deleting Databases & IF NOT EXISTS.html

1.2 kB

04 - Data Definition_ Managing Tables & Working With Data Types/007 The Importance Of Data Types (Value Types).mp4

89 MB

04 - Data Definition_ Managing Tables & Working With Data Types/007 The Importance Of Data Types (Value Types)_en.srt

9.5 kB

04 - Data Definition_ Managing Tables & Working With Data Types/008 Introducing Key Text Value Types.mp4

107 MB

04 - Data Definition_ Managing Tables & Working With Data Types/008 Introducing Key Text Value Types_en.srt

10 kB

04 - Data Definition_ Managing Tables & Working With Data Types/009 Introducing Numeric Values, Date Types & More.mp4

89 MB

04 - Data Definition_ Managing Tables & Working With Data Types/009 Introducing Numeric Values, Date Types & More_en.srt

9.3 kB

04 - Data Definition_ Managing Tables & Working With Data Types/010 An Overview Of Numeric Value Types.html

4.9 kB

04 - Data Definition_ Managing Tables & Working With Data Types/011 How Do You Store Files_.mp4

20 MB

04 - Data Definition_ Managing Tables & Working With Data Types/011 How Do You Store Files__en.srt

5.2 kB

04 - Data Definition_ Managing Tables & Working With Data Types/012 Getting Started With The CREATE TABLE Statement & Syntax.mp4

31 MB

04 - Data Definition_ Managing Tables & Working With Data Types/012 Getting Started With The CREATE TABLE Statement & Syntax_en.srt

8.3 kB

04 - Data Definition_ Managing Tables & Working With Data Types/013 Creating a First Text Column.mp4

18 MB

04 - Data Definition_ Managing Tables & Working With Data Types/013 Creating a First Text Column_en.srt

5.9 kB

04 - Data Definition_ Managing Tables & Working With Data Types/014 Creating a Numeric Value Column.mp4

58 MB

04 - Data Definition_ Managing Tables & Working With Data Types/014 Creating a Numeric Value Column_en.srt

14 kB

04 - Data Definition_ Managing Tables & Working With Data Types/015 Working with Enums & Finishing Table Creation.mp4

48 MB

04 - Data Definition_ Managing Tables & Working With Data Types/015 Working with Enums & Finishing Table Creation_en.srt

11 kB

04 - Data Definition_ Managing Tables & Working With Data Types/016 Inserting Data Into The Created Table (INSERT INTO).mp4

30 MB

04 - Data Definition_ Managing Tables & Working With Data Types/016 Inserting Data Into The Created Table (INSERT INTO)_en.srt

9.7 kB

04 - Data Definition_ Managing Tables & Working With Data Types/017 Inserting & Querying More Data.mp4

31 MB

04 - Data Definition_ Managing Tables & Working With Data Types/017 Inserting & Querying More Data_en.srt

6.0 kB

04 - Data Definition_ Managing Tables & Working With Data Types/018 Working With Fixed Point & Floating Point Numbers.mp4

56 MB

04 - Data Definition_ Managing Tables & Working With Data Types/018 Working With Fixed Point & Floating Point Numbers_en.srt

13 kB

04 - Data Definition_ Managing Tables & Working With Data Types/019 Adding Boolean Value Types.mp4

13 MB

04 - Data Definition_ Managing Tables & Working With Data Types/019 Adding Boolean Value Types_en.srt

2.9 kB

04 - Data Definition_ Managing Tables & Working With Data Types/020 Creating a new Table with Text & Timestamp Data.mp4

29 MB

04 - Data Definition_ Managing Tables & Working With Data Types/020 Creating a new Table with Text & Timestamp Data_en.srt

8.3 kB

04 - Data Definition_ Managing Tables & Working With Data Types/021 Inserting Data Into The New Tables.mp4

61 MB

04 - Data Definition_ Managing Tables & Working With Data Types/021 Inserting Data Into The New Tables_en.srt

10 kB

04 - Data Definition_ Managing Tables & Working With Data Types/022 What About Time Zones_.html

963 B

04 - Data Definition_ Managing Tables & Working With Data Types/023 Introducing Default Column Values.mp4

22 MB

04 - Data Definition_ Managing Tables & Working With Data Types/023 Introducing Default Column Values_en.srt

4.9 kB

04 - Data Definition_ Managing Tables & Working With Data Types/024 Deleting (Dropping) Tables & Inserting Data With Default Values.mp4

44 MB

04 - Data Definition_ Managing Tables & Working With Data Types/024 Deleting (Dropping) Tables & Inserting Data With Default Values_en.srt

7.7 kB

04 - Data Definition_ Managing Tables & Working With Data Types/025 Updating Tables & Columns.mp4

68 MB

04 - Data Definition_ Managing Tables & Working With Data Types/025 Updating Tables & Columns_en.srt

13 kB

04 - Data Definition_ Managing Tables & Working With Data Types/026 Dealing With _No Data_ (NULL) vs _0_.mp4

64 MB

04 - Data Definition_ Managing Tables & Working With Data Types/026 Dealing With _No Data_ (NULL) vs _0__en.srt

10 kB

04 - Data Definition_ Managing Tables & Working With Data Types/027 NULL Values, Inserting (No) Data & Default Values.html

2.5 kB

04 - Data Definition_ Managing Tables & Working With Data Types/028 Exploring the NOT NULL Constraint.mp4

83 MB

04 - Data Definition_ Managing Tables & Working With Data Types/028 Exploring the NOT NULL Constraint_en.srt

15 kB

04 - Data Definition_ Managing Tables & Working With Data Types/029 Exploring the CHECK Constraint.mp4

71 MB

04 - Data Definition_ Managing Tables & Working With Data Types/029 Exploring the CHECK Constraint_en.srt

20 kB

04 - Data Definition_ Managing Tables & Working With Data Types/030 We Need Unique Values & Identifiers_.mp4

62 MB

04 - Data Definition_ Managing Tables & Working With Data Types/030 We Need Unique Values & Identifiers__en.srt

18 kB

04 - Data Definition_ Managing Tables & Working With Data Types/031 SERIAL in MySQL vs SERIAL in Postgresql.html

783 B

04 - Data Definition_ Managing Tables & Working With Data Types/032 Working With Auto Incrementing IDs & Primary Keys.mp4

88 MB

04 - Data Definition_ Managing Tables & Working With Data Types/032 Working With Auto Incrementing IDs & Primary Keys_en.srt

16 kB

04 - Data Definition_ Managing Tables & Working With Data Types/033 Auto-IDs, Primary Keys & Inserting Data.html

2.3 kB

04 - Data Definition_ Managing Tables & Working With Data Types/034 Constraints - Summary.mp4

14 MB

04 - Data Definition_ Managing Tables & Working With Data Types/034 Constraints - Summary_en.srt

4.7 kB

04 - Data Definition_ Managing Tables & Working With Data Types/035 Understanding Text Encoding & Collation.mp4

65 MB

04 - Data Definition_ Managing Tables & Working With Data Types/035 Understanding Text Encoding & Collation_en.srt

16 kB

04 - Data Definition_ Managing Tables & Working With Data Types/036 Temporary Tables & Tables From Other Tables.mp4

18 MB

04 - Data Definition_ Managing Tables & Working With Data Types/036 Temporary Tables & Tables From Other Tables_en.srt

4.4 kB

04 - Data Definition_ Managing Tables & Working With Data Types/037 Creating Generated Columns.mp4

70 MB

04 - Data Definition_ Managing Tables & Working With Data Types/037 Creating Generated Columns_en.srt

12 kB

04 - Data Definition_ Managing Tables & Working With Data Types/038 Module Summary.mp4

22 MB

04 - Data Definition_ Managing Tables & Working With Data Types/038 Module Summary_en.srt

5.2 kB

04 - Data Definition_ Managing Tables & Working With Data Types/039 Time To Practice_ Problem.mp4

20 MB

04 - Data Definition_ Managing Tables & Working With Data Types/039 Time To Practice_ Problem_en.srt

7.2 kB

04 - Data Definition_ Managing Tables & Working With Data Types/040 Time To Practice_ Solution (1_2).mp4

84 MB

04 - Data Definition_ Managing Tables & Working With Data Types/040 Time To Practice_ Solution (1_2)_en.srt

20 kB

04 - Data Definition_ Managing Tables & Working With Data Types/041 Time To Practice_ Solution (2_2).mp4

75 MB

04 - Data Definition_ Managing Tables & Working With Data Types/041 Time To Practice_ Solution (2_2)_en.srt

13 kB

04 - Data Definition_ Managing Tables & Working With Data Types/external-assets-links.txt

388 B

05 - Data Manipulation & Querying_ CRUD Operations With SQL/001 Module Introduction.mp4

5.5 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/001 Module Introduction_en.srt

2.1 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/002 What Are CRUD Operations_.mp4

12 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/002 What Are CRUD Operations__en.srt

3.7 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/003 Inserting Data_ Theory.mp4

4.2 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/003 Inserting Data_ Theory_en.srt

4.3 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/004 Selecting Data_ Theory.mp4

7.6 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/004 Selecting Data_ Theory_en.srt

2.0 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/005 Updating Data_ Theory.mp4

7.1 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/005 Updating Data_ Theory_en.srt

2.4 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/006 Deleting Data_ Theory.mp4

5.7 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/006 Deleting Data_ Theory_en.srt

2.2 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/007 Introducing The Section Example.mp4

19 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/007 Introducing The Section Example_en.srt

6.0 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/008 Setting Up An Example Database & Table.mp4

50 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/008 Setting Up An Example Database & Table_en.srt

12 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/009 Example_ Inserting Data.mp4

48 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/009 Example_ Inserting Data_en.srt

11 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/010 Inserting More (Dummy) Data.mp4

12 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/010 Inserting More (Dummy) Data_en.srt

1.7 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/011 Updating In Action.mp4

30 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/011 Updating In Action_en.srt

8.5 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/012 Deleting In Action.mp4

11 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/012 Deleting In Action_en.srt

3.4 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/013 Selecting Data - The Basics.mp4

27 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/013 Selecting Data - The Basics_en.srt

7.3 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/014 SELECT, Column Names & Data Expressions.mp4

27 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/014 SELECT, Column Names & Data Expressions_en.srt

7.3 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/015 Filtering with WHERE_ Available Comparison Operators & Variations.mp4

21 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/015 Filtering with WHERE_ Available Comparison Operators & Variations_en.srt

7.0 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/016 Filtering In Action (WHERE In Action).mp4

23 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/016 Filtering In Action (WHERE In Action)_en.srt

5.8 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/017 Combining Comparisons With AND & OR.mp4

24 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/017 Combining Comparisons With AND & OR_en.srt

5.5 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/018 Greater, Smaller & Ranges.mp4

50 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/018 Greater, Smaller & Ranges_en.srt

11 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/019 Filtering Text Values.mp4

30 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/019 Filtering Text Values_en.srt

6.9 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/020 Working With Dates & Date Differences.mp4

40 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/020 Working With Dates & Date Differences_en.srt

7.9 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/021 Filtering Conditions Without Hard-Coded Values.html

611 B

05 - Data Manipulation & Querying_ CRUD Operations With SQL/022 Introducing ORDER BY & LIMIT.mp4

12 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/022 Introducing ORDER BY & LIMIT_en.srt

3.2 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/023 Ordering & Limiting Results In Action.mp4

51 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/023 Ordering & Limiting Results In Action_en.srt

11 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/024 Looking For DISTINCT Values.mp4

11 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/024 Looking For DISTINCT Values_en.srt

2.4 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/025 Subqueries & Views.mp4

43 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/025 Subqueries & Views_en.srt

11 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/026 Module Summary.mp4

16 MB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/026 Module Summary_en.srt

4.0 kB

05 - Data Manipulation & Querying_ CRUD Operations With SQL/external-assets-links.txt

273 B

06 - Data Normalization & Relationships_ Splitting & JOINing Data/001 Module Introduction.mp4

8.0 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/001 Module Introduction_en.srt

2.6 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/002 A First Look At Related Data.mp4

28 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/002 A First Look At Related Data_en.srt

6.7 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/003 Data Normalization - First Steps.mp4

22 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/003 Data Normalization - First Steps_en.srt

6.5 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/004 Splitting Data Into Tables.mp4

64 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/004 Splitting Data Into Tables_en.srt

15 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/005 Forms Of Data Normalization.mp4

20 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/005 Forms Of Data Normalization_en.srt

4.9 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/006 Our First Section Example.mp4

20 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/006 Our First Section Example_en.srt

6.1 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/007 Creating Tables With Relations.mp4

77 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/007 Creating Tables With Relations_en.srt

16 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/008 Inserting Related Data.mp4

63 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/008 Inserting Related Data_en.srt

12 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/009 Joining Data & Introducing INNER JOIN.mp4

26 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/009 Joining Data & Introducing INNER JOIN_en.srt

6.2 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/010 Using INNER JOIN.mp4

44 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/010 Using INNER JOIN_en.srt

12 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/011 Combining Multiple JOINs.mp4

26 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/011 Combining Multiple JOINs_en.srt

6.7 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/012 Data Joining & Filtering.mp4

27 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/012 Data Joining & Filtering_en.srt

5.9 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/013 Introducing LEFT JOIN.mp4

14 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/013 Introducing LEFT JOIN_en.srt

3.4 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/014 Using LEFT JOIN.mp4

23 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/014 Using LEFT JOIN_en.srt

5.9 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/015 Combining Multiple LEFT JOINs.mp4

16 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/015 Combining Multiple LEFT JOINs_en.srt

4.4 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/016 What About RIGHT JOIN_.mp4

8.8 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/016 What About RIGHT JOIN__en.srt

2.1 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/017 Example Time & INNER JOIN vs LEFT JOIN.mp4

76 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/017 Example Time & INNER JOIN vs LEFT JOIN_en.srt

20 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/018 Introducing CROSS JOIN.mp4

11 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/018 Introducing CROSS JOIN_en.srt

2.7 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/019 UNION & Why It's Different.mp4

51 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/019 UNION & Why It's Different_en.srt

14 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/020 What's Wrong With Our Foreign Keys_.mp4

45 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/020 What's Wrong With Our Foreign Keys__en.srt

7.9 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/021 Introducing Foreign Key Constraints.mp4

22 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/021 Introducing Foreign Key Constraints_en.srt

6.1 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/022 Diving Deeper Into Foreign Key Constraints.mp4

44 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/022 Diving Deeper Into Foreign Key Constraints_en.srt

8.5 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/023 Updating & Removing Foreign Key Constraints.html

2.2 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/024 Foreign Key Constraints In Action.mp4

98 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/024 Foreign Key Constraints In Action_en.srt

20 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/025 Data Relationship Types_ One-to-Many, Many-to-Many, One-to-ONe.mp4

27 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/025 Data Relationship Types_ One-to-Many, Many-to-Many, One-to-ONe_en.srt

6.8 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/026 A Bigger Example.mp4

30 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/026 A Bigger Example_en.srt

9.4 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/027 Example_ Adding First Tables & Relations.mp4

132 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/027 Example_ Adding First Tables & Relations_en.srt

26 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/028 Example_ Adding More Tables & Data.mp4

109 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/028 Example_ Adding More Tables & Data_en.srt

18 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/029 Many-to-Many Relationships & Intermediate Tables (_Linking Tables_).mp4

63 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/029 Many-to-Many Relationships & Intermediate Tables (_Linking Tables_)_en.srt

11 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/030 Querying The Example Data.mp4

56 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/030 Querying The Example Data_en.srt

14 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/031 Practicing JOINs With Filtering.mp4

72 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/031 Practicing JOINs With Filtering_en.srt

15 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/032 Experimenting With Referential Integrity.mp4

50 MB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/032 Experimenting With Referential Integrity_en.srt

8.8 kB

06 - Data Normalization & Relationships_ Splitting & JOINing Data/external-assets-links.txt

538 B

07 - More On Primary & Foreign Keys/001 Module Introduction.mp4

6.4 MB

07 - More On Primary & Foreign Keys/001 Module Introduction_en.srt

2.5 kB

07 - More On Primary & Foreign Keys/002 Remember_ Primary Keys Don't Have To Be Auto-Incrementing IDs_.mp4

21 MB

07 - More On Primary & Foreign Keys/002 Remember_ Primary Keys Don't Have To Be Auto-Incrementing IDs__en.srt

4.4 kB

07 - More On Primary & Foreign Keys/003 Primary Keys_ When To Use Which Column.html

2.3 kB

07 - More On Primary & Foreign Keys/004 Introducing Composite Primary Keys.mp4

16 MB

07 - More On Primary & Foreign Keys/004 Introducing Composite Primary Keys_en.srt

13 kB

07 - More On Primary & Foreign Keys/005 Defining Composite Primary Keys (Composite Keys In Action).mp4

20 MB

07 - More On Primary & Foreign Keys/005 Defining Composite Primary Keys (Composite Keys In Action)_en.srt

3.7 kB

07 - More On Primary & Foreign Keys/006 Composite Foreign Keys.mp4

38 MB

07 - More On Primary & Foreign Keys/006 Composite Foreign Keys_en.srt

7.6 kB

07 - More On Primary & Foreign Keys/007 Composite Keys In Action.mp4

22 MB

07 - More On Primary & Foreign Keys/007 Composite Keys In Action_en.srt

4.0 kB

07 - More On Primary & Foreign Keys/008 Self-Referencing Relationships (Self-Referential Relationships).mp4

52 MB

07 - More On Primary & Foreign Keys/008 Self-Referencing Relationships (Self-Referential Relationships)_en.srt

13 kB

07 - More On Primary & Foreign Keys/009 Self-Referencing Many To Many Relationships.mp4

47 MB

07 - More On Primary & Foreign Keys/009 Self-Referencing Many To Many Relationships_en.srt

11 kB

08 - Grouping & Aggregate Functions/001 Module Introduction.mp4

6.5 MB

08 - Grouping & Aggregate Functions/001 Module Introduction_en.srt

2.1 kB

08 - Grouping & Aggregate Functions/002 The Module Project.mp4

21 MB

08 - Grouping & Aggregate Functions/002 The Module Project_en.srt

6.9 kB

08 - Grouping & Aggregate Functions/003 What are Aggregate Functions - Theory.mp4

23 MB

08 - Grouping & Aggregate Functions/003 What are Aggregate Functions - Theory_en.srt

6.8 kB

08 - Grouping & Aggregate Functions/004 Understanding COUNT().mp4

59 MB

08 - Grouping & Aggregate Functions/004 Understanding COUNT()_en.srt

16 kB

08 - Grouping & Aggregate Functions/005 Working with MIN() & MAX() and Adding Aliases to Aggregate Functions.mp4

43 MB

08 - Grouping & Aggregate Functions/005 Working with MIN() & MAX() and Adding Aliases to Aggregate Functions_en.srt

11 kB

08 - Grouping & Aggregate Functions/006 Using SUM(), AVG() & ROUND().mp4

32 MB

08 - Grouping & Aggregate Functions/006 Using SUM(), AVG() & ROUND()_en.srt

9.5 kB

08 - Grouping & Aggregate Functions/007 Working with Filters & Joining Tables.mp4

72 MB

08 - Grouping & Aggregate Functions/007 Working with Filters & Joining Tables_en.srt

16 kB

08 - Grouping & Aggregate Functions/008 Theory Time - Understanding GROUP BY.mp4

26 MB

08 - Grouping & Aggregate Functions/008 Theory Time - Understanding GROUP BY_en.srt

7.6 kB

08 - Grouping & Aggregate Functions/009 Applying GROUP BY in Practice.mp4

26 MB

08 - Grouping & Aggregate Functions/009 Applying GROUP BY in Practice_en.srt

6.6 kB

08 - Grouping & Aggregate Functions/010 GROUP BY & Joined Queries.mp4

45 MB

08 - Grouping & Aggregate Functions/010 GROUP BY & Joined Queries_en.srt

8.0 kB

08 - Grouping & Aggregate Functions/011 Understanding WHERE vs HAVING.mp4

54 MB

08 - Grouping & Aggregate Functions/011 Understanding WHERE vs HAVING_en.srt

15 kB

08 - Grouping & Aggregate Functions/012 Applying HAVING in Practice.mp4

49 MB

08 - Grouping & Aggregate Functions/012 Applying HAVING in Practice_en.srt

11 kB

08 - Grouping & Aggregate Functions/013 Working with Nested Subqueries.mp4

54 MB

08 - Grouping & Aggregate Functions/013 Working with Nested Subqueries_en.srt

16 kB

08 - Grouping & Aggregate Functions/014 Introducing Window Functions.mp4

40 MB

08 - Grouping & Aggregate Functions/014 Introducing Window Functions_en.srt

13 kB

08 - Grouping & Aggregate Functions/015 Understanding ORDER BY and RANK().mp4

50 MB

08 - Grouping & Aggregate Functions/015 Understanding ORDER BY and RANK()_en.srt

10 kB

08 - Grouping & Aggregate Functions/external-assets-links.txt

520 B

09 - Built-in Query Functions & Operators/001 Module Introduction.mp4

9.0 MB

09 - Built-in Query Functions & Operators/001 Module Introduction_en.srt

2.8 kB

09 - Built-in Query Functions & Operators/002 The Module Project.mp4

14 MB

09 - Built-in Query Functions & Operators/002 The Module Project_en.srt

5.1 kB

09 - Built-in Query Functions & Operators/003 Working with Mathematical Functions & Arithmetic Operators.mp4

98 MB

09 - Built-in Query Functions & Operators/003 Working with Mathematical Functions & Arithmetic Operators_en.srt

22 kB

09 - Built-in Query Functions & Operators/004 Understanding String Functions with SELECT.mp4

45 MB

09 - Built-in Query Functions & Operators/004 Understanding String Functions with SELECT_en.srt

10 kB

09 - Built-in Query Functions & Operators/005 Using String Functions with INSERT.mp4

65 MB

09 - Built-in Query Functions & Operators/005 Using String Functions with INSERT_en.srt

12 kB

09 - Built-in Query Functions & Operators/006 Understanding Date _ Time Functions.mp4

24 MB

09 - Built-in Query Functions & Operators/006 Understanding Date _ Time Functions_en.srt

6.1 kB

09 - Built-in Query Functions & Operators/007 Working with Weekdays.mp4

43 MB

09 - Built-in Query Functions & Operators/007 Working with Weekdays_en.srt

11 kB

09 - Built-in Query Functions & Operators/008 Calculating INTERVALS.mp4

47 MB

09 - Built-in Query Functions & Operators/008 Calculating INTERVALS_en.srt

14 kB

09 - Built-in Query Functions & Operators/009 Adding INTERVALS to Dates.mp4

37 MB

09 - Built-in Query Functions & Operators/009 Adding INTERVALS to Dates_en.srt

10 kB

09 - Built-in Query Functions & Operators/010 Understanding LIKE & Pattern Matching.mp4

41 MB

09 - Built-in Query Functions & Operators/010 Understanding LIKE & Pattern Matching_en.srt

14 kB

09 - Built-in Query Functions & Operators/011 Understanding EXISTS.mp4

38 MB

09 - Built-in Query Functions & Operators/011 Understanding EXISTS_en.srt

10 kB

09 - Built-in Query Functions & Operators/012 Working with Subquery Expressions and EXISTS.mp4

31 MB

09 - Built-in Query Functions & Operators/012 Working with Subquery Expressions and EXISTS_en.srt

6.1 kB

09 - Built-in Query Functions & Operators/013 Working with Subquery Expressions and IN.mp4

60 MB

09 - Built-in Query Functions & Operators/013 Working with Subquery Expressions and IN_en.srt

12 kB

09 - Built-in Query Functions & Operators/014 Introducing Conditional Expressions.mp4

45 MB

09 - Built-in Query Functions & Operators/014 Introducing Conditional Expressions_en.srt

11 kB

09 - Built-in Query Functions & Operators/015 Challenge Solution.mp4

37 MB

09 - Built-in Query Functions & Operators/015 Challenge Solution_en.srt

6.0 kB

09 - Built-in Query Functions & Operators/016 Database (SQL) vs Application Level.mp4

17 MB

09 - Built-in Query Functions & Operators/016 Database (SQL) vs Application Level_en.srt

5.2 kB

09 - Built-in Query Functions & Operators/external-assets-links.txt

1.7 kB

10 - Database Transactions/001 Module Introduction.mp4

3.7 MB

10 - Database Transactions/001 Module Introduction_en.srt

1.3 kB

10 - Database Transactions/002 Understanding Transactions.mp4

11 MB

10 - Database Transactions/002 Understanding Transactions_en.srt

3.6 kB

10 - Database Transactions/003 A Note About This Module's Project.html

462 B

10 - Database Transactions/004 Applying Transactions & ROLLBACK.mp4

62 MB

10 - Database Transactions/004 Applying Transactions & ROLLBACK_en.srt

14 kB

10 - Database Transactions/005 Committing Changes.mp4

63 MB

10 - Database Transactions/005 Committing Changes_en.srt

12 kB

10 - Database Transactions/006 Working with Savepoints.mp4

34 MB

10 - Database Transactions/006 Working with Savepoints_en.srt

6.7 kB

10 - Database Transactions/007 Transactions in PostgreSQL.mp4

34 MB

10 - Database Transactions/007 Transactions in PostgreSQL_en.srt

6.9 kB

10 - Database Transactions/external-assets-links.txt

436 B

11 - Using Indexes/001 Module Introduction.mp4

5.4 MB

11 - Using Indexes/001 Module Introduction_en.srt

1.5 kB

11 - Using Indexes/002 What Are Indexes_ And Why Would You Need Them_.mp4

38 MB

11 - Using Indexes/002 What Are Indexes_ And Why Would You Need Them__en.srt

9.6 kB

11 - Using Indexes/003 Don't Use Too Many Indexes_.mp4

7.6 MB

11 - Using Indexes/003 Don't Use Too Many Indexes__en.srt

7.0 kB

11 - Using Indexes/004 Index Types_ An Overview.mp4

33 MB

11 - Using Indexes/004 Index Types_ An Overview_en.srt

8.4 kB

11 - Using Indexes/005 Setting Up Some Example Data.mp4

34 MB

11 - Using Indexes/005 Setting Up Some Example Data_en.srt

5.1 kB

11 - Using Indexes/006 EXPLAINing Queries & Query Planning.mp4

28 MB

11 - Using Indexes/006 EXPLAINing Queries & Query Planning_en.srt

8.6 kB

11 - Using Indexes/007 Creating & Using Single-Column Indexes.mp4

25 MB

11 - Using Indexes/007 Creating & Using Single-Column Indexes_en.srt

10 kB

11 - Using Indexes/008 More on Creating & Dropping Indexes.html

697 B

11 - Using Indexes/009 Unique Indexes.mp4

15 MB

11 - Using Indexes/009 Unique Indexes_en.srt

3.4 kB

11 - Using Indexes/010 Working With Multi-Column Indexes (Composite Indexes).mp4

48 MB

11 - Using Indexes/010 Working With Multi-Column Indexes (Composite Indexes)_en.srt

15 kB

11 - Using Indexes/011 Partial Indexes.mp4

16 MB

11 - Using Indexes/011 Partial Indexes_en.srt

4.4 kB

11 - Using Indexes/external-assets-links.txt

299 B

12 - Summary & Practice_ A Complete Example/001 Module Introduction.mp4

25 MB

12 - Summary & Practice_ A Complete Example/001 Module Introduction_en.srt

3.0 kB

12 - Summary & Practice_ A Complete Example/002 What Is SQL_.mp4

87 MB

12 - Summary & Practice_ A Complete Example/002 What Is SQL__en.srt

9.4 kB

12 - Summary & Practice_ A Complete Example/003 A Closer Look At Databases In General.mp4

90 MB

12 - Summary & Practice_ A Complete Example/003 A Closer Look At Databases In General_en.srt

10 kB

12 - Summary & Practice_ A Complete Example/004 The Core SQL Syntax.mp4

96 MB

12 - Summary & Practice_ A Complete Example/004 The Core SQL Syntax_en.srt

11 kB

12 - Summary & Practice_ A Complete Example/005 Course Setup (For Following Along).mp4

71 MB

12 - Summary & Practice_ A Complete Example/005 Course Setup (For Following Along)_en.srt

8.2 kB

12 - Summary & Practice_ A Complete Example/006 Analyzing The Section Example Project.mp4

37 MB

12 - Summary & Practice_ A Complete Example/006 Analyzing The Section Example Project_en.srt

9.9 kB

12 - Summary & Practice_ A Complete Example/007 Introducing _Data Normalization_.mp4

21 MB

12 - Summary & Practice_ A Complete Example/007 Introducing _Data Normalization__en.srt

5.3 kB

12 - Summary & Practice_ A Complete Example/008 Planning Tables & Relationships.mp4

56 MB

12 - Summary & Practice_ A Complete Example/008 Planning Tables & Relationships_en.srt

16 kB

12 - Summary & Practice_ A Complete Example/009 Creating A New Database.mp4

20 MB

12 - Summary & Practice_ A Complete Example/009 Creating A New Database_en.srt

6.8 kB

12 - Summary & Practice_ A Complete Example/010 Choosing Identifier Names.mp4

11 MB

12 - Summary & Practice_ A Complete Example/010 Choosing Identifier Names_en.srt

5.1 kB

12 - Summary & Practice_ A Complete Example/011 Defining Columns.mp4

14 MB

12 - Summary & Practice_ A Complete Example/011 Defining Columns_en.srt

5.9 kB

12 - Summary & Practice_ A Complete Example/012 Exploring Important Data Types.mp4

37 MB

12 - Summary & Practice_ A Complete Example/012 Exploring Important Data Types_en.srt

8.9 kB

12 - Summary & Practice_ A Complete Example/013 How To Store Files & Adding More Data Types.mp4

23 MB

12 - Summary & Practice_ A Complete Example/013 How To Store Files & Adding More Data Types_en.srt

6.6 kB

12 - Summary & Practice_ A Complete Example/014 Constraints_ An Introduction.mp4

36 MB

12 - Summary & Practice_ A Complete Example/014 Constraints_ An Introduction_en.srt

8.2 kB

12 - Summary & Practice_ A Complete Example/015 Introducing Database Functions.mp4

22 MB

12 - Summary & Practice_ A Complete Example/015 Introducing Database Functions_en.srt

4.0 kB

12 - Summary & Practice_ A Complete Example/016 Understanding Primary Keys & Unique IDs.mp4

48 MB

12 - Summary & Practice_ A Complete Example/016 Understanding Primary Keys & Unique IDs_en.srt

9.6 kB

12 - Summary & Practice_ A Complete Example/017 INSERTing Data.mp4

55 MB

12 - Summary & Practice_ A Complete Example/017 INSERTing Data_en.srt

12 kB

12 - Summary & Practice_ A Complete Example/018 Basic Data Querying (via SELECT).mp4

12 MB

12 - Summary & Practice_ A Complete Example/018 Basic Data Querying (via SELECT)_en.srt

3.9 kB

12 - Summary & Practice_ A Complete Example/019 UPDATE & DELETE In Action.mp4

36 MB

12 - Summary & Practice_ A Complete Example/019 UPDATE & DELETE In Action_en.srt

8.8 kB

12 - Summary & Practice_ A Complete Example/020 Filtering (WHERE) & Sorting (ORDER BY).mp4

23 MB

12 - Summary & Practice_ A Complete Example/020 Filtering (WHERE) & Sorting (ORDER BY)_en.srt

7.2 kB

12 - Summary & Practice_ A Complete Example/021 Adding More Tables.mp4

52 MB

12 - Summary & Practice_ A Complete Example/021 Adding More Tables_en.srt

13 kB

12 - Summary & Practice_ A Complete Example/022 Relations & Foreign Keys.mp4

83 MB

12 - Summary & Practice_ A Complete Example/022 Relations & Foreign Keys_en.srt

16 kB

12 - Summary & Practice_ A Complete Example/023 Understanding ON DELETE & ON UPDATE.mp4

33 MB

12 - Summary & Practice_ A Complete Example/023 Understanding ON DELETE & ON UPDATE_en.srt

5.4 kB

12 - Summary & Practice_ A Complete Example/024 Adding More Tables & Relationships.mp4

68 MB

12 - Summary & Practice_ A Complete Example/024 Adding More Tables & Relationships_en.srt

12 kB

12 - Summary & Practice_ A Complete Example/025 Many To Many Relationships & Linking (Intermediate) Tables.mp4

77 MB

12 - Summary & Practice_ A Complete Example/025 Many To Many Relationships & Linking (Intermediate) Tables_en.srt

14 kB

12 - Summary & Practice_ A Complete Example/026 Inserting Related Data.mp4

132 MB

12 - Summary & Practice_ A Complete Example/026 Inserting Related Data_en.srt

21 kB

12 - Summary & Practice_ A Complete Example/027 Connecting Data With INNER JOIN.mp4

61 MB

12 - Summary & Practice_ A Complete Example/027 Connecting Data With INNER JOIN_en.srt

18 kB

12 - Summary & Practice_ A Complete Example/028 Combining Multiple Joins.mp4

42 MB

12 - Summary & Practice_ A Complete Example/028 Combining Multiple Joins_en.srt

8.5 kB

12 - Summary & Practice_ A Complete Example/029 Introducing LEFT JOIN.mp4

84 MB

12 - Summary & Practice_ A Complete Example/029 Introducing LEFT JOIN_en.srt

18 kB

12 - Summary & Practice_ A Complete Example/030 Joining Data & Filtering.mp4

30 MB

12 - Summary & Practice_ A Complete Example/030 Joining Data & Filtering_en.srt

6.6 kB

12 - Summary & Practice_ A Complete Example/031 Filtering Text With LIKE.mp4

34 MB

12 - Summary & Practice_ A Complete Example/031 Filtering Text With LIKE_en.srt

9.1 kB

12 - Summary & Practice_ A Complete Example/032 Introducing Aggregate Functions.mp4

20 MB

12 - Summary & Practice_ A Complete Example/032 Introducing Aggregate Functions_en.srt

6.3 kB

12 - Summary & Practice_ A Complete Example/033 Grouping Aggregate Results (GROUP BY).mp4

38 MB

12 - Summary & Practice_ A Complete Example/033 Grouping Aggregate Results (GROUP BY)_en.srt

9.3 kB

12 - Summary & Practice_ A Complete Example/034 The HAVING Clause (vs WHERE).mp4

33 MB

12 - Summary & Practice_ A Complete Example/034 The HAVING Clause (vs WHERE)_en.srt

5.3 kB

12 - Summary & Practice_ A Complete Example/035 Module Summary.mp4

19 MB

12 - Summary & Practice_ A Complete Example/035 Module Summary_en.srt

2.8 kB

12 - Summary & Practice_ A Complete Example/external-assets-links.txt

128 B

13 - Course Roundup/001 Congratulations + Bonus Content.mp4

20 MB

13 - Course Roundup/001 Congratulations + Bonus Content_en.srt

1.6 kB

13 - Course Roundup/external-assets-links.txt

58 B