Get Bonus Downloads Here.url
0.18 KB
~Get Your Files Here !
1 - Introduction
1 -Welcome to Hands-on High Performance SQL.mp4
30.49 MB
2 -Things You Should Know to Take this Course.mp4
6.14 MB
2 - Creating Your PostgreSQL Database for Hands-On SQL
1 -Installing PostgreSQL.mp4
28.58 MB
2 -Working with pgAdmin.mp4
22.54 MB
3 -Creating a Database and Tables with pgAdmin.mp4
67.85 MB
4 -Hands-On Exercise 1.mp4
5.50 MB
5 -Hands-On Exercise 1 Solution.mp4
24.67 MB
3 - Analyzing Query Performance
1 -Basics of EXPLAIN and EXPLAIN ANALYZE.mp4
65.74 MB
2 -Analyzing Aggregate, GROUP BY, and HAVING clauses.mp4
63.17 MB
3 -Hands-On Exercise 2.mp4
2.35 MB
4 -Hands-On Exercise 2 Solution.mp4
14.10 MB
5 -Hands-On Exercise 3.mp4
1.92 MB
6 -Hands-On Exercise 3 Solution.mp4
19.26 MB
4 - Improving Query Performance with Indexing
1 -PostgreSQL Index Types.mp4
11.66 MB
2 -Creating Sales Indexes.mp4
22.63 MB
5 - Joins, Subqueries, and Common Table Expressions (CTEs)
1 -Types of Joins.mp4
11.66 MB
10 -Hands-on Exercise 6.mp4
1.85 MB
11 -Hands-on Exercise 6 Solution.mp4
14.29 MB
12 -Basic Common Table Expressions.mp4
33.89 MB
13 -Common Table Expressions for Sales Region Analysis.mp4
58.59 MB
14 -Hands-on Exercise 7.mp4
1.89 MB
15 -Hands-on Exercise 7 Solution.mp4
25.63 MB
16 -Comparing Joins, Subqueries, and Common Table Exrpessions.mp4
15.10 MB
17 -Multiple Implementationf of the Same Business Logic.mp4
16.35 MB
18 -Using AI to Transform Queries.mp4
48.62 MB
2 -EXPLAIN Basic Joins.mp4
19.37 MB
3 -Executing Basic Join.mp4
8.99 MB
4 -Hash, Merge, and Nested Loop Joins.mp4
42.87 MB
5 -Hands-on Exercise 5.mp4
1.71 MB
6 -Hands-on Exercise 5 Solution.mp4
16.45 MB
7 -Overview of Subqueries.mp4
27.33 MB
8 -Subquery for Basic Filtering.mp4
26.06 MB
9 -Subquery for Filtering Aggregate.mp4
18.27 MB
6 - Efficient Text Pattern Matching and Searching
1 -Efficient Use of the LIKE Operator.mp4
32.89 MB
2 -PostgreSQL Text Search Methods.mp4
24.26 MB
3 -Hands-on Exercise 8.mp4
2.54 MB
4 -Hands-on Exercise 8 Solution.mp4
10.86 MB
7 - Partitioning Large Tables
1 -Overview of Partitioned Tables.mp4
27.32 MB
2 -Creating Partitioned Tables.mp4
58.69 MB
3 -Querying a Partitioned and Non-Partitioned Tables.mp4
62.23 MB
4 -Hands-on Exercise 9.mp4
2.44 MB
5 -Hands-on Exercise 9 Solution.mp4
8.36 MB
8 - Database Statistics and Query Performance
1 -Data Statistics and Query Plan Execution.mp4
17.48 MB
2 -Statistics and Query Optimization.mp4
12.71 MB
3 -Analyzing Schema Level Performance.mp4
26.47 MB
4 -ANALYZE and VACUUM.mp4
17.53 MB
5 -Updating Statistics and Reclaiming Dead Tuples.mp4
34.29 MB
6 -Hands-on Exercise 10.mp4
1.29 MB
7 -Hands-on Exercise 10 Solution.mp4
9.84 MB
9 - Conclusion
1 -Learning More about High Performance SQL.mp4
30.35 MB
Bonus Resources.txt
0.07 KB
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ WebToolTip com ] Udemy - Hands-On High Performance SQL Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.