Filename Size ~Get Your Files Here !/1 - Introduction/1 -Welcome to Hands-on High Performance SQL.mp4 30.5 MB ~Get Your Files Here !/1 - Introduction/2 -Things You Should Know to Take this Course.mp4 6.1 MB ~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/1 -Installing PostgreSQL.mp4 28.6 MB ~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/2 -Working with pgAdmin.mp4 22.5 MB ~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/3 -Creating a Database and Tables with pgAdmin.mp4 67.8 MB ~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/4 -Hands-On Exercise 1.mp4 5.5 MB ~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/5 -Hands-On Exercise 1 Solution.mp4 24.7 MB ~Get Your Files Here !/3 - Analyzing Query Performance/1 -Basics of EXPLAIN and EXPLAIN ANALYZE.mp4 65.7 MB ~Get Your Files Here !/3 - Analyzing Query Performance/2 -Analyzing Aggregate, GROUP BY, and HAVING clauses.mp4 63.2 MB ~Get Your Files Here !/3 - Analyzing Query Performance/3 -Hands-On Exercise 2.mp4 2.4 MB ~Get Your Files Here !/3 - Analyzing Query Performance/4 -Hands-On Exercise 2 Solution.mp4 14.1 MB ~Get Your Files Here !/3 - Analyzing Query Performance/5 -Hands-On Exercise 3.mp4 1.9 MB ~Get Your Files Here !/3 - Analyzing Query Performance/6 -Hands-On Exercise 3 Solution.mp4 19.3 MB ~Get Your Files Here !/4 - Improving Query Performance with Indexing/1 -PostgreSQL Index Types.mp4 11.7 MB ~Get Your Files Here !/4 - Improving Query Performance with Indexing/2 -Creating Sales Indexes.mp4 22.6 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/1 -Types of Joins.mp4 11.7 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/10 -Hands-on Exercise 6.mp4 1.8 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/11 -Hands-on Exercise 6 Solution.mp4 14.3 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/12 -Basic Common Table Expressions.mp4 33.9 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/13 -Common Table Expressions for Sales Region Analysis.mp4 58.6 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/14 -Hands-on Exercise 7.mp4 1.9 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/15 -Hands-on Exercise 7 Solution.mp4 25.6 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/16 -Comparing Joins, Subqueries, and Common Table Exrpessions.mp4 15.1 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/17 -Multiple Implementationf of the Same Business Logic.mp4 16.3 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/18 -Using AI to Transform Queries.mp4 48.6 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/2 -EXPLAIN Basic Joins.mp4 19.4 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/3 -Executing Basic Join.mp4 9 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/4 -Hash, Merge, and Nested Loop Joins.mp4 42.9 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/5 -Hands-on Exercise 5.mp4 1.7 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/6 -Hands-on Exercise 5 Solution.mp4 16.4 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/7 -Overview of Subqueries.mp4 27.3 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/8 -Subquery for Basic Filtering.mp4 26.1 MB ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/9 -Subquery for Filtering Aggregate.mp4 18.3 MB ~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/1 -Efficient Use of the LIKE Operator.mp4 32.9 MB ~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/2 -PostgreSQL Text Search Methods.mp4 24.3 MB ~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/3 -Hands-on Exercise 8.mp4 2.5 MB ~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/4 -Hands-on Exercise 8 Solution.mp4 10.9 MB ~Get Your Files Here !/7 - Partitioning Large Tables/1 -Overview of Partitioned Tables.mp4 27.3 MB ~Get Your Files Here !/7 - Partitioning Large Tables/2 -Creating Partitioned Tables.mp4 58.7 MB ~Get Your Files Here !/7 - Partitioning Large Tables/3 -Querying a Partitioned and Non-Partitioned Tables.mp4 62.2 MB ~Get Your Files Here !/7 - Partitioning Large Tables/4 -Hands-on Exercise 9.mp4 2.4 MB ~Get Your Files Here !/7 - Partitioning Large Tables/5 -Hands-on Exercise 9 Solution.mp4 8.4 MB ~Get Your Files Here !/8 - Database Statistics and Query Performance/1 -Data Statistics and Query Plan Execution.mp4 17.5 MB ~Get Your Files Here !/8 - Database Statistics and Query Performance/2 -Statistics and Query Optimization.mp4 12.7 MB ~Get Your Files Here !/8 - Database Statistics and Query Performance/3 -Analyzing Schema Level Performance.mp4 26.5 MB ~Get Your Files Here !/8 - Database Statistics and Query Performance/4 -ANALYZE and VACUUM.mp4 17.5 MB ~Get Your Files Here !/8 - Database Statistics and Query Performance/5 -Updating Statistics and Reclaiming Dead Tuples.mp4 34.3 MB ~Get Your Files Here !/8 - Database Statistics and Query Performance/6 -Hands-on Exercise 10.mp4 1.3 MB ~Get Your Files Here !/8 - Database Statistics and Query Performance/7 -Hands-on Exercise 10 Solution.mp4 9.8 MB ~Get Your Files Here !/9 - Conclusion/1 -Learning More about High Performance SQL.mp4 30.3 MB ~Get Your Files Here !/Bonus Resources.txt 70 B
![[ WebToolTip.com ] Udemy - Hands-On High Performance SQL](https://f.t0r.site/no-cover.webp)
