Udemy - Hands-On High Performance SQL

seeders: 12
leechers: 8
updated:
Download torrent
Added by freecoursewb in Other > Tutorials
Download Fast Safe Anonymous
movies, software, shows...

Files

[ WebToolTip.com ] Udemy - Hands-On High Performance SQL
  • Get Bonus Downloads Here.url (0.2 KB)
    • ~Get Your Files Here ! 1 - Introduction
    • 1 -Welcome to Hands-on High Performance SQL.mp4 (30.5 MB)
    • 2 -Things You Should Know to Take this Course.mp4 (6.1 MB)
    2 - Creating Your PostgreSQL Database for Hands-On SQL
    • 1 -Installing PostgreSQL.mp4 (28.6 MB)
    • 2 -Working with pgAdmin.mp4 (22.5 MB)
    • 3 -Creating a Database and Tables with pgAdmin.mp4 (67.8 MB)
    • 4 -Hands-On Exercise 1.mp4 (5.5 MB)
    • 5 -Hands-On Exercise 1 Solution.mp4 (24.7 MB)
    3 - Analyzing Query Performance
    • 1 -Basics of EXPLAIN and EXPLAIN ANALYZE.mp4 (65.7 MB)
    • 2 -Analyzing Aggregate, GROUP BY, and HAVING clauses.mp4 (63.2 MB)
    • 3 -Hands-On Exercise 2.mp4 (2.4 MB)
    • 4 -Hands-On Exercise 2 Solution.mp4 (14.1 MB)
    • 5 -Hands-On Exercise 3.mp4 (1.9 MB)
    • 6 -Hands-On Exercise 3 Solution.mp4 (19.3 MB)
    4 - Improving Query Performance with Indexing
    • 1 -PostgreSQL Index Types.mp4 (11.7 MB)
    • 2 -Creating Sales Indexes.mp4 (22.6 MB)
    5 - Joins, Subqueries, and Common Table Expressions (CTEs)
    • 1 -Types of Joins.mp4 (11.7 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 -EXPLAIN Basic Joins.mp4 (19.4 MB)
    • 3 -Executing Basic Join.mp4 (9.0 MB)
    • 4 -Hash, Merge, and Nested Loop Joins.mp4 (42.9 MB)
    • 5 -Hands-on Exercise 5.mp4 (1.7 MB)
    • 6 -Hands-on Exercise 5 Solution.mp4 (16.4 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)
    6 - Efficient Text Pattern Matching and Searching
    • 1 -Efficient Use of the LIKE Operator.mp4 (32.9 MB)
    • 2 -PostgreSQL Text Search Methods.mp4 (24.3 MB)
    • 3 -Hands-on Exercise 8.mp4 (2.5 MB)
    • 4 -Hands-on Exercise 8 Solution.mp4 (10.9 MB)
    7 - Partitioning Large Tables
    • 1 -Overview of Partitioned Tables.mp4 (27.3 MB)
    • 2 -Creating Partitioned Tables.mp4 (58.7 MB)
    • 3 -Querying a Partitioned and Non-Partitioned Tables.mp4 (62.2 MB)
    • 4 -Hands-on Exercise 9.mp4 (2.4 MB)
    • 5 -Hands-on Exercise 9 Solution.mp4 (8.4 MB)
    8 - Database Statistics and Query Performance
    • 1 -Data Statistics and Query Plan Execution.mp4 (17.5 MB)
    • 2 -Statistics and Query Optimization.mp4 (12.7 MB)
    • 3 -Analyzing Schema Level Performance.mp4 (26.5 MB)
    • 4 -ANALYZE and VACUUM.mp4 (17.5 MB)
    • 5 -Updating Statistics and Reclaiming Dead Tuples.mp4 (34.3 MB)
    • 6 -Hands-on Exercise 10.mp4 (1.3 MB)
    • 7 -Hands-on Exercise 10 Solution.mp4 (9.8 MB)
    9 - Conclusion
    • 1 -Learning More about High Performance SQL.mp4 (30.3 MB)
    • Bonus Resources.txt (0.1 KB)

Description

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



Download torrent
1.1 GB
seeders:12
leechers:8
Udemy - Hands-On High Performance SQL

Trackers

tracker name
udp://tracker.torrent.eu.org:451/announce
udp://tracker.tiny-vps.com:6969/announce
http://tracker.foreverpirates.co:80/announce
udp://tracker.cyberia.is:6969/announce
udp://exodus.desync.com:6969/announce
udp://explodie.org:6969/announce
udp://tracker.opentrackr.org:1337/announce
udp://9.rarbg.to:2780/announce
udp://tracker.internetwarriors.net:1337/announce
udp://ipv4.tracker.harry.lu:80/announce
udp://open.stealth.si:80/announce
udp://9.rarbg.to:2900/announce
udp://9.rarbg.me:2720/announce
udp://opentor.org:2710/announce
µTorrent compatible trackers list

Download torrent
1.1 GB
seeders:12
leechers:8
Udemy - Hands-On High Performance SQL

Torrent hash: DD4E653046A5A90930C96E2877047A630281C855