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 |