[ WebToolTip.com ] Udemy - PostgreSQL Database Administration Complete Course

File Name

Size

Get Bonus Downloads Here.url

180 B

~Get Your Files Here !/1 - Introduction to PostgreSQL/1. Installing and Setting Up PostgreSQL.mp4

82 MB

~Get Your Files Here !/1 - Introduction to PostgreSQL/2. PostgreSQL Tools pgAdmin psql and DBeaver.mp4

49 MB

~Get Your Files Here !/2 - PostgreSQL Fundamentals/3. Understanding Databases Tables and Schemas.mp4

51 MB

~Get Your Files Here !/2 - PostgreSQL Fundamentals/4. Data Types in PostgreSQL (Numeric Text Date Boolean JSON).mp4

103 MB

~Get Your Files Here !/2 - PostgreSQL Fundamentals/5. Creating Updating and Deleting Tables.mp4

66 MB

~Get Your Files Here !/2 - PostgreSQL Fundamentals/6. Primary Keys Foreign Keys and Constraints.mp4

76 MB

~Get Your Files Here !/2 - PostgreSQL Fundamentals/7. Working with NULL Values and Default Values.mp4

66 MB

~Get Your Files Here !/3 - SQL Queries & CRUD Operations/10. Using DISTINCT GROUP BY and HAVING.mp4

102 MB

~Get Your Files Here !/3 - SQL Queries & CRUD Operations/11. Joins in PostgreSQL (INNER LEFT RIGHT FULL).mp4

73 MB

~Get Your Files Here !/3 - SQL Queries & CRUD Operations/8. SELECT INSERT UPDATE and DELETE Statements.mp4

63 MB

~Get Your Files Here !/3 - SQL Queries & CRUD Operations/9. Filtering Data with WHERE ORDER BY and LIMIT.mp4

93 MB

~Get Your Files Here !/4 - Data Modeling & Normalization/12. Designing Efficient Data Models.mp4

116 MB

~Get Your Files Here !/4 - Data Modeling & Normalization/13. One to One One to Many and Many to Many Relationships.mp4

151 MB

~Get Your Files Here !/4 - Data Modeling & Normalization/14. Using Views for Data Abstraction.mp4

83 MB

~Get Your Files Here !/4 - Data Modeling & Normalization/15. Working with Composite Keys and Foreign Key Constraints.mp4

148 MB

~Get Your Files Here !/5 - Advanced SQL Features/16. Window Functions (ROW_NUMBER RANK DENSE_RANK).mp4

75 MB

~Get Your Files Here !/5 - Advanced SQL Features/17. Recursive Queries with CTEs.mp4

9.8 MB

~Get Your Files Here !/5 - Advanced SQL Features/18. JSON and JSONB Data Types in PostgreSQL.mp4

4.2 MB

~Get Your Files Here !/5 - Advanced SQL Features/19. Full Text Search in PostgreSQL.mp4

122 MB

~Get Your Files Here !/5 - Advanced SQL Features/20. Working with Arrays and ENUMs.mp4

131 MB

~Get Your Files Here !/6 - Indexing & Performance Optimization/21. Understanding Indexes in PostgreSQL.mp4

79 MB

~Get Your Files Here !/6 - Indexing & Performance Optimization/22. Creating and Managing Indexes.mp4

98 MB

~Get Your Files Here !/6 - Indexing & Performance Optimization/23. Query Performance Analysis with EXPLAIN and ANALYZE.mp4

82 MB

~Get Your Files Here !/6 - Indexing & Performance Optimization/24. Optimizing Queries for Large Datasets.mp4

76 MB

~Get Your Files Here !/7 - PostgreSQL Transactions & Concurrency/25. ACID Properties in PostgreSQL.mp4

69 MB

~Get Your Files Here !/7 - PostgreSQL Transactions & Concurrency/26. Using Transactions and Savepoints.mp4

74 MB

~Get Your Files Here !/7 - PostgreSQL Transactions & Concurrency/27. Isolation Levels (READ COMMITTED REPEATABLE READ SERIALIZABLE).mp4

80 MB

~Get Your Files Here !/8 - User Management & Security/28. Creating and Managing Users and Roles.mp4

58 MB

~Get Your Files Here !/8 - User Management & Security/29. Row Level Security (RLS).mp4

71 MB

~Get Your Files Here !/8 - User Management & Security/30. Securing Connections with SSL TLS.mp4

45 MB

~Get Your Files Here !/Bonus Resources.txt

70 B