~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/3 -Creating a Database and Tables with pgAdmin.mp4 71.1 MB
~Get Your Files Here !/3 - Analyzing Query Performance/1 -Basics of EXPLAIN and EXPLAIN ANALYZE.mp4 68.9 MB
~Get Your Files Here !/3 - Analyzing Query Performance/2 -Analyzing Aggregate, GROUP BY, and HAVING clauses.mp4 66.2 MB
~Get Your Files Here !/7 - Partitioning Large Tables/3 -Querying a Partitioned and Non-Partitioned Tables.mp4 65.3 MB
~Get Your Files Here !/7 - Partitioning Large Tables/2 -Creating Partitioned Tables.mp4 61.5 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/13 -Common Table Expressions for Sales Region Analysis.mp4 61.4 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/18 -Using AI to Transform Queries.mp4 51.0 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/4 -Hash, Merge, and Nested Loop Joins.mp4 45.0 MB
~Get Your Files Here !/8 - Database Statistics and Query Performance/5 -Updating Statistics and Reclaiming Dead Tuples.mp4 36.0 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/12 -Basic Common Table Expressions.mp4 35.5 MB
~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/1 -Efficient Use of the LIKE Operator.mp4 34.5 MB
~Get Your Files Here !/1 - Introduction/1 -Welcome to Hands-on High Performance SQL.mp4 32.0 MB
~Get Your Files Here !/9 - Conclusion/1 -Learning More about High Performance SQL.mp4 31.8 MB
~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/1 -Installing PostgreSQL.mp4 30.0 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/7 -Overview of Subqueries.mp4 28.7 MB
~Get Your Files Here !/7 - Partitioning Large Tables/1 -Overview of Partitioned Tables.mp4 28.7 MB
~Get Your Files Here !/8 - Database Statistics and Query Performance/3 -Analyzing Schema Level Performance.mp4 27.8 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/8 -Subquery for Basic Filtering.mp4 27.3 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/15 -Hands-on Exercise 7 Solution.mp4 26.9 MB
~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/5 -Hands-On Exercise 1 Solution.mp4 25.9 MB
~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/2 -PostgreSQL Text Search Methods.mp4 25.4 MB
~Get Your Files Here !/4 - Improving Query Performance with Indexing/2 -Creating Sales Indexes.mp4 23.7 MB
~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/2 -Working with pgAdmin.mp4 23.6 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/2 -EXPLAIN Basic Joins.mp4 20.3 MB
~Get Your Files Here !/3 - Analyzing Query Performance/6 -Hands-On Exercise 3 Solution.mp4 20.2 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/9 -Subquery for Filtering Aggregate.mp4 19.2 MB
~Get Your Files Here !/8 - Database Statistics and Query Performance/4 -ANALYZE and VACUUM.mp4 18.4 MB
~Get Your Files Here !/8 - Database Statistics and Query Performance/1 -Data Statistics and Query Plan Execution.mp4 18.3 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/6 -Hands-on Exercise 5 Solution.mp4 17.2 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/17 -Multiple Implementationf of the Same Business Logic.mp4 17.1 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/16 -Comparing Joins, Subqueries, and Common Table Exrpessions.mp4 15.8 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/11 -Hands-on Exercise 6 Solution.mp4 15.0 MB
~Get Your Files Here !/3 - Analyzing Query Performance/4 -Hands-On Exercise 2 Solution.mp4 14.8 MB
~Get Your Files Here !/8 - Database Statistics and Query Performance/2 -Statistics and Query Optimization.mp4 13.3 MB
~Get Your Files Here !/4 - Improving Query Performance with Indexing/1 -PostgreSQL Index Types.mp4 12.2 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/1 -Types of Joins.mp4 12.2 MB
~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/4 -Hands-on Exercise 8 Solution.mp4 11.4 MB
~Get Your Files Here !/8 - Database Statistics and Query Performance/7 -Hands-on Exercise 10 Solution.mp4 10.3 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/3 -Executing Basic Join.mp4 9.4 MB
~Get Your Files Here !/7 - Partitioning Large Tables/5 -Hands-on Exercise 9 Solution.mp4 8.8 MB
~Get Your Files Here !/1 - Introduction/2 -Things You Should Know to Take this Course.mp4 6.4 MB
~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/4 -Hands-On Exercise 1.mp4 5.8 MB
~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/3 -Hands-on Exercise 8.mp4 2.7 MB
~Get Your Files Here !/7 - Partitioning Large Tables/4 -Hands-on Exercise 9.mp4 2.6 MB
~Get Your Files Here !/3 - Analyzing Query Performance/3 -Hands-On Exercise 2.mp4 2.5 MB
~Get Your Files Here !/3 - Analyzing Query Performance/5 -Hands-On Exercise 3.mp4 2.0 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/14 -Hands-on Exercise 7.mp4 2.0 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/10 -Hands-on Exercise 6.mp4 1.9 MB
~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/5 -Hands-on Exercise 5.mp4 1.8 MB
~Get Your Files Here !/8 - Database Statistics and Query Performance/6 -Hands-on Exercise 10.mp4 1.4 MB
Get Bonus Downloads Here.url 180 Bytes
~Get Your Files Here !/Bonus Resources.txt 70 Bytes