Filename Size 1 - Simple But Powerful SQL Statements/1 - Join Our Community.html 318 B 1 - Simple But Powerful SQL Statements/10 - Calculating Phone Revenue English.srt 1.6 KB 1 - Simple But Powerful SQL Statements/10 - Calculating Phone Revenue.mp4 37.3 MB 1 - Simple But Powerful SQL Statements/11 - Exercise Solution English.srt 1.6 KB 1 - Simple But Powerful SQL Statements/11 - Exercise Solution.mp4 27.9 MB 1 - Simple But Powerful SQL Statements/12 - 012-sql.sql 404 B 1 - Simple But Powerful SQL Statements/12 - String Operators and Functions English.srt 9.9 KB 1 - Simple But Powerful SQL Statements/12 - String Operators and Functions.mp4 65.1 MB 1 - Simple But Powerful SQL Statements/2 - Course Resources.html 1.3 KB 1 - Simple But Powerful SQL Statements/2 - diagrams.zip 7.7 MB 1 - Simple But Powerful SQL Statements/3 - What is PostgreSQL All About English.srt 7.4 KB 1 - Simple But Powerful SQL Statements/3 - What is PostgreSQL All About.mp4 21.7 MB 1 - Simple But Powerful SQL Statements/4 - Database Design English.srt 8.2 KB 1 - Simple But Powerful SQL Statements/4 - Database Design.mp4 35.4 MB 1 - Simple But Powerful SQL Statements/5 - 003-sql.sql 104 B 1 - Simple But Powerful SQL Statements/5 - Creating Tables English.srt 7.7 KB 1 - Simple But Powerful SQL Statements/5 - Creating Tables.mp4 18.6 MB 1 - Simple But Powerful SQL Statements/6 - Analyzing CREATE TABLE English.srt 5.5 KB 1 - Simple But Powerful SQL Statements/6 - Analyzing CREATE TABLE.mp4 17.7 MB 1 - Simple But Powerful SQL Statements/7 - 005-sql-cumulative.sql 384 B 1 - Simple But Powerful SQL Statements/7 - 005-sql.sql 278 B 1 - Simple But Powerful SQL Statements/7 - Inserting Data Into a Table English.srt 7.6 KB 1 - Simple But Powerful SQL Statements/7 - Inserting Data Into a Table.mp4 18.1 MB 1 - Simple But Powerful SQL Statements/8 - Retrieving Data with Select English.srt 3.3 KB 1 - Simple But Powerful SQL Statements/8 - Retrieving Data with Select.mp4 6 MB 1 - Simple But Powerful SQL Statements/9 - Calculated Columns English.srt 7.3 KB 1 - Simple But Powerful SQL Statements/9 - Calculated Columns.mp4 15.2 MB 10 - Selecting Distinct Records/118 - Selecting Distinct Values English.srt 6.5 KB 10 - Selecting Distinct Records/118 - Selecting Distinct Values.mp4 12.5 MB 10 - Selecting Distinct Records/119 - Exercise Overview English.srt 906 B 10 - Selecting Distinct Records/119 - Exercise Overview.mp4 1.3 MB 10 - Selecting Distinct Records/120 - A Distinct Solution English.srt 964 B 10 - Selecting Distinct Records/120 - A Distinct Solution.mp4 1.9 MB 11 - Utility Operators Keywords and Functions/121 - The Greatest Value in a List English.srt 5.1 KB 11 - Utility Operators Keywords and Functions/121 - The Greatest Value in a List.mp4 11.8 MB 11 - Utility Operators Keywords and Functions/122 - And the Least Value in a List English.srt 3 KB 11 - Utility Operators Keywords and Functions/122 - And the Least Value in a List.mp4 5.5 MB 11 - Utility Operators Keywords and Functions/123 - The Case Keyword English.srt 6.7 KB 11 - Utility Operators Keywords and Functions/123 - The Case Keyword.mp4 19 MB 12 - Local PostgreSQL Installation/124 - PostgreSQL Installation on macOS English.srt 10 KB 12 - Local PostgreSQL Installation/124 - PostgreSQL Installation on macOS.mp4 21.1 MB 12 - Local PostgreSQL Installation/125 - PGAdmin Setup on macOS English.srt 7.8 KB 12 - Local PostgreSQL Installation/125 - PGAdmin Setup on macOS.mp4 36.9 MB 12 - Local PostgreSQL Installation/126 - Postgres installation on Windows English.srt 6.6 KB 12 - Local PostgreSQL Installation/126 - Postgres installation on Windows.mp4 23.3 MB 13 - PostgreSQL Complex Datatypes/127 - Whatd We Just Do English.srt 6.5 KB 13 - PostgreSQL Complex Datatypes/127 - Whatd We Just Do.mp4 19.3 MB 13 - PostgreSQL Complex Datatypes/128 - Data Types English.srt 7.2 KB 13 - PostgreSQL Complex Datatypes/128 - Data Types.mp4 30.5 MB 13 - PostgreSQL Complex Datatypes/129 - Fast Rules on Numeric Data Types English.srt 3.6 KB 13 - PostgreSQL Complex Datatypes/129 - Fast Rules on Numeric Data Types.mp4 18.9 MB 13 - PostgreSQL Complex Datatypes/130 - More on Number Data Types English.srt 14.8 KB 13 - PostgreSQL Complex Datatypes/130 - More on Number Data Types.mp4 48.1 MB 13 - PostgreSQL Complex Datatypes/131 - Reminder on Character Types English.srt 7.5 KB 13 - PostgreSQL Complex Datatypes/131 - Reminder on Character Types.mp4 29.9 MB 13 - PostgreSQL Complex Datatypes/132 - Boolean Data Types English.srt 3.9 KB 13 - PostgreSQL Complex Datatypes/132 - Boolean Data Types.mp4 8.2 MB 13 - PostgreSQL Complex Datatypes/133 - Times Dates and Timestamps English.srt 8.4 KB 13 - PostgreSQL Complex Datatypes/133 - Times Dates and Timestamps.mp4 21.3 MB 13 - PostgreSQL Complex Datatypes/134 - Really Awesome Intervals English.srt 9.1 KB 13 - PostgreSQL Complex Datatypes/134 - Really Awesome Intervals.mp4 19.5 MB 14 - DatabaseSide Validation and Constraints/135 - Thinking About Validation English.srt 6.9 KB 14 - DatabaseSide Validation and Constraints/135 - Thinking About Validation.mp4 34.6 MB 14 - DatabaseSide Validation and Constraints/136 - Creating and Viewing Tables in PGAdmin English.srt 11.6 KB 14 - DatabaseSide Validation and Constraints/136 - Creating and Viewing Tables in PGAdmin.mp4 28.1 MB 14 - DatabaseSide Validation and Constraints/137 - Applying a Null Constraint English.srt 10.3 KB 14 - DatabaseSide Validation and Constraints/137 - Applying a Null Constraint.mp4 21.1 MB 14 - DatabaseSide Validation and Constraints/138 - Solving a Gotcha with Null Constraints English.srt 6.5 KB 14 - DatabaseSide Validation and Constraints/138 - Solving a Gotcha with Null Constraints.mp4 13.7 MB 14 - DatabaseSide Validation and Constraints/139 - Default Column Values English.srt 5.3 KB 14 - DatabaseSide Validation and Constraints/139 - Default Column Values.mp4 22.5 MB 14 - DatabaseSide Validation and Constraints/140 - Applying a Unique Constraint to One column English.srt 8.9 KB 14 - DatabaseSide Validation and Constraints/140 - Applying a Unique Constraint to One column.mp4 43.1 MB 14 - DatabaseSide Validation and Constraints/141 - MultiColumn Uniqueness English.srt 5.2 KB 14 - DatabaseSide Validation and Constraints/141 - MultiColumn Uniqueness.mp4 30.1 MB 14 - DatabaseSide Validation and Constraints/142 - Adding a Validation Check English.srt 6.1 KB 14 - DatabaseSide Validation and Constraints/142 - Adding a Validation Check.mp4 18.2 MB 14 - DatabaseSide Validation and Constraints/143 - Checks Over Multiple Columns English.srt 7.6 KB 14 - DatabaseSide Validation and Constraints/143 - Checks Over Multiple Columns.mp4 17.2 MB 14 - DatabaseSide Validation and Constraints/144 - So Where Are We Applying Validation English.srt 9.9 KB 14 - DatabaseSide Validation and Constraints/144 - So Where Are We Applying Validation.mp4 22 MB 15 - Database Structure Design Patterns/145 - Approaching More Complicated Designs English.srt 5.5 KB 15 - Database Structure Design Patterns/145 - Approaching More Complicated Designs.mp4 11.2 MB 15 - Database Structure Design Patterns/146 - Using a SQL Design Tool English.srt 9.9 KB 15 - Database Structure Design Patterns/146 - Using a SQL Design Tool.mp4 47.3 MB 15 - Database Structure Design Patterns/147 - A Configbased Schema Designer English.srt 11.8 KB 15 - Database Structure Design Patterns/147 - A Configbased Schema Designer.mp4 28.7 MB 15 - Database Structure Design Patterns/148 - Heres the Plan English.srt 4.3 KB 15 - Database Structure Design Patterns/148 - Heres the Plan.mp4 9.6 MB 15 - Database Structure Design Patterns/149 - 005-design.dbml 455 B 15 - Database Structure Design Patterns/149 - Rebuilding Some Schema English.srt 10.6 KB 15 - Database Structure Design Patterns/149 - Rebuilding Some Schema.mp4 20.9 MB 16 - How to Build a Like System/150 - Requirements of a Like System English.srt 7.7 KB 16 - How to Build a Like System/150 - Requirements of a Like System.mp4 26.1 MB 16 - How to Build a Like System/151 - How Not to Design a Like System English.srt 4.8 KB 16 - How to Build a Like System/151 - How Not to Design a Like System.mp4 16.2 MB 16 - How to Build a Like System/152 - Designing a Like System English.srt 8.3 KB