Udemy - PostgreSQL Database Administration Complete Course
File List
| File | Size |
|---|---|
| Get Bonus Downloads Here.url | 180 B |
| ~Get Your Files Here !/1 - Introduction to PostgreSQL/1. Installing and Setting Up PostgreSQL.mp4 | 82.04 MB |
| ~Get Your Files Here !/1 - Introduction to PostgreSQL/2. PostgreSQL Tools pgAdmin psql and DBeaver.mp4 | 49.4 MB |
| ~Get Your Files Here !/2 - PostgreSQL Fundamentals/3. Understanding Databases Tables and Schemas.mp4 | 51.36 MB |
| ~Get Your Files Here !/2 - PostgreSQL Fundamentals/4. Data Types in PostgreSQL (Numeric Text Date Boolean JSON).mp4 | 103.17 MB |
| ~Get Your Files Here !/2 - PostgreSQL Fundamentals/5. Creating Updating and Deleting Tables.mp4 | 66.35 MB |
| ~Get Your Files Here !/2 - PostgreSQL Fundamentals/6. Primary Keys Foreign Keys and Constraints.mp4 | 76.2 MB |
| ~Get Your Files Here !/2 - PostgreSQL Fundamentals/7. Working with NULL Values and Default Values.mp4 | 65.86 MB |
| ~Get Your Files Here !/3 - SQL Queries & CRUD Operations/10. Using DISTINCT GROUP BY and HAVING.mp4 | 102.44 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 | 62.86 MB |
| ~Get Your Files Here !/3 - SQL Queries & CRUD Operations/9. Filtering Data with WHERE ORDER BY and LIMIT.mp4 | 93.33 MB |
| ~Get Your Files Here !/4 - Data Modeling & Normalization/12. Designing Efficient Data Models.mp4 | 116.17 MB |
| ~Get Your Files Here !/4 - Data Modeling & Normalization/13. One to One One to Many and Many to Many Relationships.mp4 | 151.03 MB |
| ~Get Your Files Here !/4 - Data Modeling & Normalization/14. Using Views for Data Abstraction.mp4 | 82.62 MB |
| ~Get Your Files Here !/4 - Data Modeling & Normalization/15. Working with Composite Keys and Foreign Key Constraints.mp4 | 147.9 MB |
| ~Get Your Files Here !/5 - Advanced SQL Features/16. Window Functions (ROW_NUMBER RANK DENSE_RANK).mp4 | 74.75 MB |
| ~Get Your Files Here !/5 - Advanced SQL Features/17. Recursive Queries with CTEs.mp4 | 9.76 MB |
| ~Get Your Files Here !/5 - Advanced SQL Features/18. JSON and JSONB Data Types in PostgreSQL.mp4 | 4.21 MB |
| ~Get Your Files Here !/5 - Advanced SQL Features/19. Full Text Search in PostgreSQL.mp4 | 121.61 MB |
| ~Get Your Files Here !/5 - Advanced SQL Features/20. Working with Arrays and ENUMs.mp4 | 130.92 MB |
| ~Get Your Files Here !/6 - Indexing & Performance Optimization/21. Understanding Indexes in PostgreSQL.mp4 | 79.35 MB |
| ~Get Your Files Here !/6 - Indexing & Performance Optimization/22. Creating and Managing Indexes.mp4 | 98.38 MB |
| ~Get Your Files Here !/6 - Indexing & Performance Optimization/23. Query Performance Analysis with EXPLAIN and ANALYZE.mp4 | 82.3 MB |
| ~Get Your Files Here !/6 - Indexing & Performance Optimization/24. Optimizing Queries for Large Datasets.mp4 | 75.73 MB |
| ~Get Your Files Here !/7 - PostgreSQL Transactions & Concurrency/25. ACID Properties in PostgreSQL.mp4 | 69.05 MB |
| ~Get Your Files Here !/7 - PostgreSQL Transactions & Concurrency/26. Using Transactions and Savepoints.mp4 | 74.07 MB |
| ~Get Your Files Here !/7 - PostgreSQL Transactions & Concurrency/27. Isolation Levels (READ COMMITTED REPEATABLE READ SERIALIZABLE).mp4 | 79.72 MB |
| ~Get Your Files Here !/8 - User Management & Security/28. Creating and Managing Users and Roles.mp4 | 58.27 MB |
| ~Get Your Files Here !/8 - User Management & Security/29. Row Level Security (RLS).mp4 | 70.75 MB |
| ~Get Your Files Here !/8 - User Management & Security/30. Securing Connections with SSL TLS.mp4 | 44.75 MB |
| ~Get Your Files Here !/Bonus Resources.txt | 70 B |
Trackers
No trackers found.