[ WebToolTip.com ] Udemy - Hands-On High Performance SQL

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - Introduction/1 -Welcome to Hands-on High Performance SQL.mp4

30 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

29 MB

~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/2 -Working with pgAdmin.mp4

22 MB

~Get Your Files Here !/2 - Creating Your PostgreSQL Database for Hands-On SQL/3 -Creating a Database and Tables with pgAdmin.mp4

68 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

25 MB

~Get Your Files Here !/3 - Analyzing Query Performance/1 -Basics of EXPLAIN and EXPLAIN ANALYZE.mp4

66 MB

~Get Your Files Here !/3 - Analyzing Query Performance/2 -Analyzing Aggregate, GROUP BY, and HAVING clauses.mp4

63 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 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 MB

~Get Your Files Here !/4 - Improving Query Performance with Indexing/1 -PostgreSQL Index Types.mp4

12 MB

~Get Your Files Here !/4 - Improving Query Performance with Indexing/2 -Creating Sales Indexes.mp4

23 MB

~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/1 -Types of Joins.mp4

12 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 MB

~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/12 -Basic Common Table Expressions.mp4

34 MB

~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/13 -Common Table Expressions for Sales Region Analysis.mp4

59 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

26 MB

~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/16 -Comparing Joins, Subqueries, and Common Table Exrpessions.mp4

15 MB

~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/17 -Multiple Implementationf of the Same Business Logic.mp4

16 MB

~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/18 -Using AI to Transform Queries.mp4

49 MB

~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/2 -EXPLAIN Basic Joins.mp4

19 MB

~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/3 -Executing Basic Join.mp4

9.0 MB

~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/4 -Hash, Merge, and Nested Loop Joins.mp4

43 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 MB

~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/7 -Overview of Subqueries.mp4

27 MB

~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/8 -Subquery for Basic Filtering.mp4

26 MB

~Get Your Files Here !/5 - Joins, Subqueries, and Common Table Expressions (CTEs)/9 -Subquery for Filtering Aggregate.mp4

18 MB

~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/1 -Efficient Use of the LIKE Operator.mp4

33 MB

~Get Your Files Here !/6 - Efficient Text Pattern Matching and Searching/2 -PostgreSQL Text Search Methods.mp4

24 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

11 MB

~Get Your Files Here !/7 - Partitioning Large Tables/1 -Overview of Partitioned Tables.mp4

27 MB

~Get Your Files Here !/7 - Partitioning Large Tables/2 -Creating Partitioned Tables.mp4

59 MB

~Get Your Files Here !/7 - Partitioning Large Tables/3 -Querying a Partitioned and Non-Partitioned Tables.mp4

62 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

18 MB

~Get Your Files Here !/8 - Database Statistics and Query Performance/2 -Statistics and Query Optimization.mp4

13 MB

~Get Your Files Here !/8 - Database Statistics and Query Performance/3 -Analyzing Schema Level Performance.mp4

26 MB

~Get Your Files Here !/8 - Database Statistics and Query Performance/4 -ANALYZE and VACUUM.mp4

18 MB

~Get Your Files Here !/8 - Database Statistics and Query Performance/5 -Updating Statistics and Reclaiming Dead Tuples.mp4

34 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 MB

~Get Your Files Here !/Bonus Resources.txt

70 B