Udemy - Hands-On High Performance SQL
File List
| File | Size |
|---|---|
| Get Bonus Downloads Here.url | 180 B |
| ~Get Your Files Here !/1 - Introduction/1 -Welcome to Hands-on High Performance SQL.mp4 | 30.49 MB |
| ~Get Your Files Here !/1 - Introduction/2 -Things You Should Know to Take this Course.mp4 | 6.14 MB |
| ~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/1 -Installing PostgreSQL.mp4 | 28.58 MB |
| ~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/2 -Working with pgAdmin.mp4 | 22.54 MB |
| ~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/3 -Creating a Database and Tables with pgAdmin.mp4 | 67.85 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.67 MB |
| ~Get Your Files Here !/3 - Analyzing Query Performance/1 -Basics of EXPLAIN and EXPLAIN ANALYZE.mp4 | 65.74 MB |
| ~Get Your Files Here !/3 - Analyzing Query Performance/2 -Analyzing Aggregate, GROUP BY, and HAVING clauses.mp4 | 63.17 MB |
| ~Get Your Files Here !/3 - Analyzing Query Performance/3 -Hands-On Exercise 2.mp4 | 2.35 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.92 MB |
| ~Get Your Files Here !/3 - Analyzing Query Performance/6 -Hands-On Exercise 3 Solution.mp4 | 19.26 MB |
| ~Get Your Files Here !/4 - Improving Query Performance with Indexing/1 -PostgreSQL Index Types.mp4 | 11.66 MB |
| ~Get Your Files Here !/4 - Improving Query Performance with Indexing/2 -Creating Sales Indexes.mp4 | 22.63 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/1 -Types of Joins.mp4 | 11.66 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/10 -Hands-on Exercise 6.mp4 | 1.85 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/11 -Hands-on Exercise 6 Solution.mp4 | 14.29 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/12 -Basic Common Table Expressions.mp4 | 33.89 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/13 -Common Table Expressions for Sales Region Analysis.mp4 | 58.59 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/14 -Hands-on Exercise 7.mp4 | 1.89 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/15 -Hands-on Exercise 7 Solution.mp4 | 25.63 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.35 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/18 -Using AI to Transform Queries.mp4 | 48.62 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/2 -EXPLAIN Basic Joins.mp4 | 19.37 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/3 -Executing Basic Join.mp4 | 8.99 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/4 -Hash, Merge, and Nested Loop Joins.mp4 | 42.87 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/5 -Hands-on Exercise 5.mp4 | 1.71 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/6 -Hands-on Exercise 5 Solution.mp4 | 16.45 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/7 -Overview of Subqueries.mp4 | 27.33 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/8 -Subquery for Basic Filtering.mp4 | 26.06 MB |
| ~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/9 -Subquery for Filtering Aggregate.mp4 | 18.27 MB |
| ~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/1 -Efficient Use of the LIKE Operator.mp4 | 32.89 MB |
| ~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/2 -PostgreSQL Text Search Methods.mp4 | 24.26 MB |
| ~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/3 -Hands-on Exercise 8.mp4 | 2.54 MB |
| ~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/4 -Hands-on Exercise 8 Solution.mp4 | 10.86 MB |
| ~Get Your Files Here !/7 - Partitioning Large Tables/1 -Overview of Partitioned Tables.mp4 | 27.32 MB |
| ~Get Your Files Here !/7 - Partitioning Large Tables/2 -Creating Partitioned Tables.mp4 | 58.69 MB |
| ~Get Your Files Here !/7 - Partitioning Large Tables/3 -Querying a Partitioned and Non-Partitioned Tables.mp4 | 62.23 MB |
| ~Get Your Files Here !/7 - Partitioning Large Tables/4 -Hands-on Exercise 9.mp4 | 2.44 MB |
| ~Get Your Files Here !/7 - Partitioning Large Tables/5 -Hands-on Exercise 9 Solution.mp4 | 8.36 MB |
| ~Get Your Files Here !/8 - Database Statistics and Query Performance/1 -Data Statistics and Query Plan Execution.mp4 | 17.48 MB |
| ~Get Your Files Here !/8 - Database Statistics and Query Performance/2 -Statistics and Query Optimization.mp4 | 12.71 MB |
| ~Get Your Files Here !/8 - Database Statistics and Query Performance/3 -Analyzing Schema Level Performance.mp4 | 26.47 MB |
| ~Get Your Files Here !/8 - Database Statistics and Query Performance/4 -ANALYZE and VACUUM.mp4 | 17.53 MB |
| ~Get Your Files Here !/8 - Database Statistics and Query Performance/5 -Updating Statistics and Reclaiming Dead Tuples.mp4 | 34.29 MB |
| ~Get Your Files Here !/8 - Database Statistics and Query Performance/6 -Hands-on Exercise 10.mp4 | 1.29 MB |
| ~Get Your Files Here !/8 - Database Statistics and Query Performance/7 -Hands-on Exercise 10 Solution.mp4 | 9.84 MB |
| ~Get Your Files Here !/9 - Conclusion/1 -Learning More about High Performance SQL.mp4 | 30.35 MB |
| ~Get Your Files Here !/Bonus Resources.txt | 70 B |
Trackers
No trackers found.