| 1 -Basics of EXPLAIN and EXPLAIN ANALYZE.mp4 | 65.7 MB | ||
| 1 -Data Statistics and Query Plan Execution.mp4 | 17.5 MB | ||
| 1 -Efficient Use of the LIKE Operator.mp4 | 32.9 MB | ||
| 1 -Installing PostgreSQL.mp4 | 28.6 MB | ||
| 1 -Learning More about High Performance SQL.mp4 | 30.3 MB | ||
| 1 -Overview of Partitioned Tables.mp4 | 27.3 MB | ||
| 1 -PostgreSQL Index Types.mp4 | 11.7 MB | ||
| 1 -Types of Joins.mp4 | 11.7 MB | ||
| 1 -Welcome to Hands-on High Performance SQL.mp4 | 30.5 MB | ||
| 10 -Hands-on Exercise 6.mp4 | 1.8 MB | ||
| 11 -Hands-on Exercise 6 Solution.mp4 | 14.3 MB | ||
| 12 -Basic Common Table Expressions.mp4 | 33.9 MB | ||
| 13 -Common Table Expressions for Sales Region Analysis.mp4 | 58.6 MB | ||
| 14 -Hands-on Exercise 7.mp4 | 1.9 MB | ||
| 15 -Hands-on Exercise 7 Solution.mp4 | 25.6 MB | ||
| 16 -Comparing Joins, Subqueries, and Common Table Exrpessions.mp4 | 15.1 MB | ||
| 17 -Multiple Implementationf of the Same Business Logic.mp4 | 16.3 MB | ||
| 18 -Using AI to Transform Queries.mp4 | 48.6 MB | ||
| 2 -Analyzing Aggregate, GROUP BY, and HAVING clauses.mp4 | 63.2 MB | ||
| 2 -Creating Partitioned Tables.mp4 | 58.7 MB | ||
| 2 -Creating Sales Indexes.mp4 | 22.6 MB | ||
| 2 -EXPLAIN Basic Joins.mp4 | 19.4 MB | ||
| 2 -PostgreSQL Text Search Methods.mp4 | 24.3 MB | ||
| 2 -Statistics and Query Optimization.mp4 | 12.7 MB | ||
| 2 -Things You Should Know to Take this Course.mp4 | 6.1 MB | ||
| 2 -Working with pgAdmin.mp4 | 22.5 MB | ||
| 3 -Analyzing Schema Level Performance.mp4 | 26.5 MB | ||
| 3 -Creating a Database and Tables with pgAdmin.mp4 | 67.8 MB | ||
| 3 -Executing Basic Join.mp4 | 9 MB | ||
| 3 -Hands-On Exercise 2.mp4 | 2.4 MB | ||
| 3 -Hands-on Exercise 8.mp4 | 2.5 MB | ||
| 3 -Querying a Partitioned and Non-Partitioned Tables.mp4 | 62.2 MB | ||
| 4 -ANALYZE and VACUUM.mp4 | 17.5 MB | ||
| 4 -Hands-On Exercise 1.mp4 | 5.5 MB | ||
| 4 -Hands-On Exercise 2 Solution.mp4 | 14.1 MB | ||
| 4 -Hands-on Exercise 8 Solution.mp4 | 10.9 MB | ||
| 4 -Hands-on Exercise 9.mp4 | 2.4 MB | ||
| 4 -Hash, Merge, and Nested Loop Joins.mp4 | 42.9 MB | ||
| 5 -Hands-On Exercise 1 Solution.mp4 | 24.7 MB | ||
| 5 -Hands-On Exercise 3.mp4 | 1.9 MB | ||
| 5 -Hands-on Exercise 5.mp4 | 1.7 MB | ||
| 5 -Hands-on Exercise 9 Solution.mp4 | 8.4 MB | ||
| 5 -Updating Statistics and Reclaiming Dead Tuples.mp4 | 34.3 MB | ||
| 6 -Hands-On Exercise 3 Solution.mp4 | 19.3 MB | ||
| 6 -Hands-on Exercise 10.mp4 | 1.3 MB | ||
| 6 -Hands-on Exercise 5 Solution.mp4 | 16.4 MB | ||
| 7 -Hands-on Exercise 10 Solution.mp4 | 9.8 MB | ||
| 7 -Overview of Subqueries.mp4 | 27.3 MB | ||
| 8 -Subquery for Basic Filtering.mp4 | 26.1 MB | ||
| 9 -Subquery for Filtering Aggregate.mp4 | 18.3 MB | ||
| Bonus Resources.txt | 102.4 B | ||
| Get Bonus Downloads Here.url | 204.8 B | ||
| ▲ 52 total files | |||
Hands-On High Performance SQL
https://WebToolTip.com
Published 2/2025
Created by Dan Sullivan
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Level: Expert | Genre: eLearning | Language: English | Duration: 50 Lectures ( 3h 37m ) | Size: 1.12 GB
Tuning Queries, Optimizing Indexes, Partitioning Tables, Enabling Text Search & Optimizing Joins, Subqueries, and CTEs
What you'll learn
Generate and understand query execution plans
Define indexes and partitioning strategies to improve query performance
Choose optimal ways to implement business logic using joins, subqueries, and common table expressions (CTEs)
Monitor database statistics to improve query performance
Requirements
Some experience with SQL SELECT statements
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 3 GB | freecoursewb | 1 week | 23 | 3 | |
| 1.3 GB | freecoursewb | 2 weeks | 18 | 2 | |
|
Udemy - Git and Github For Beginners - Complete Hands-On Masterclass Posted by
freecoursewb in Other
|
649.7 MB | freecoursewb | 4 weeks | 28 | 2 |
| 3.1 GB | freecoursewb | 4 weeks | 25 | 24 | |
| 3.8 GB | freecoursewb | 1 month | 4 | 5 |
All Comments