01 - Simple - But Powerful - SQL Statements.zip
159.1 MB
01 - Simple - But Powerful - SQL Statements
02 - Filtering Records.zip
93.8 MB
02 - Filtering Records
03 - Working with Tables.zip
407.6 MB
03 - Working with Tables
04 - Relating Records with Joins.zip
501.6 MB
04 - Relating Records with Joins
05 - Aggregation of Records.zip
174 MB
05 - Aggregation of Records
06 - Working with Large Datasets.zip
30.9 MB
06 - Working with Large Datasets
👍1
07 - Sorting Records.zip
37.7 MB
07 - Sorting Records
08 - Unions and Intersections with Sets.zip
77.3 MB
08 - Unions and Intersections with Sets
09 - Assembling Queries with SubQueries.zip
572.2 MB
09 - Assembling Queries with SubQueries
10 - Selecting Distinct Records.zip
14.7 MB
10 - Selecting Distinct Records
11 - Utility Operators, Keywords, and Functions.zip
28.8 MB
11 - Utility Operators, Keywords, and Functions
12 - Local PostgreSQL Installation.zip
78.6 MB
12 - Local PostgreSQL Installation
13 - PostgreSQL Complex Datatypes.zip
189.5 MB
13 - PostgreSQL Complex Datatypes
14 - Database-Side Validation and Constraints.zip
242.1 MB
14 - Database-Side Validation and Constraints
15 - Database Structure Design Patterns.zip
113.5 MB
15 - Database Structure Design Patterns
16 - How to Build a 'Like' System.zip
229 MB
16 - How to Build a 'Like' System
17 - How to Build a 'Mention' System.zip
264.2 MB
17 - How to Build a 'Mention' System
18 - How to Build a 'Hashtag' System.zip
171.6 MB
18 - How to Build a 'Hashtag' System
19 - How to Design a 'Follower' System.zip
25.5 MB
19 - How to Design a 'Follower' System
20 - Implementing Database Design Patterns.zip
187.5 MB
20 - Implementing Database Design Patterns
21 - Approaching and Writing Complex Queries.zip
94.9 MB
21 - Approaching and Writing Complex Queries
22 - Understanding the Internals of PostgreSQL.zip
676.2 MB
22 - Understanding the Internals of PostgreSQL
23 - A Look at Indexes for Performance.zip
598.3 MB
23 - A Look at Indexes for Performance
24 - Basic Query Tuning.zip
145.3 MB
24 - Basic Query Tuning
25 - Advanced Query Tuning.zip
337.9 MB
25 - Advanced Query Tuning
26 - Simple Common Table Expressions.zip
56.3 MB
26 - Simple Common Table Expressions
27 - Recursive Common Table Expressions.zip
257.7 MB
27 - Recursive Common Table Expressions
28 - Simplifying Queries with Views.zip
123.9 MB
28 - Simplifying Queries with Views
29 - Optimizing Queries with Materialized Views.zip
145 MB
29 - Optimizing Queries with Materialized Views
30_Handling_Concurrency_and_Reversibility_with_Transactions.zip
130.1 MB
30 - Handling Concurrency and Reversibility with Transactions