Udemy - PostgreSQL Database Administration Complete Course

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction to PostgreSQL
• 1. Installing and Setting Up PostgreSQL.mp4 (82.0 MB)
• 2. PostgreSQL Tools pgAdmin psql and DBeaver.mp4 (49.4 MB)
2 - PostgreSQL Fundamentals
• 3. Understanding Databases Tables and Schemas.mp4 (51.4 MB)
• 4. Data Types in PostgreSQL (Numeric Text Date Boolean JSON).mp4 (103.2 MB)
• 5. Creating Updating and Deleting Tables.mp4 (66.3 MB)
• 6. Primary Keys Foreign Keys and Constraints.mp4 (76.2 MB)
• 7. Working with NULL Values and Default Values.mp4 (65.9 MB)
3 - SQL Queries & CRUD Operations
• 10. Using DISTINCT GROUP BY and HAVING.mp4 (102.4 MB)
• 11. Joins in PostgreSQL (INNER LEFT RIGHT FULL).mp4 (73.0 MB)
• 8. SELECT INSERT UPDATE and DELETE Statements.mp4 (62.9 MB)
• 9. Filtering Data with WHERE ORDER BY and LIMIT.mp4 (93.3 MB)
4 - Data Modeling & Normalization
• 12. Designing Efficient Data Models.mp4 (116.2 MB)
• 13. One to One One to Many and Many to Many Relationships.mp4 (151.0 MB)
• 14. Using Views for Data Abstraction.mp4 (82.6 MB)
• 15. Working with Composite Keys and Foreign Key Constraints.mp4 (147.9 MB)
5 - Advanced SQL Features
• 16. Window Functions (ROW_NUMBER RANK DENSE_RANK).mp4 (74.7 MB)
• 17. Recursive Queries with CTEs.mp4 (9.8 MB)
• 18. JSON and JSONB Data Types in PostgreSQL.mp4 (4.2 MB)
• 19. Full Text Search in PostgreSQL.mp4 (121.6 MB)
• 20. Working with Arrays and ENUMs.mp4 (130.9 MB)
6 - Indexing & Performance Optimization
• 21. Understanding Indexes in PostgreSQL.mp4 (79.4 MB)
• 22. Creating and Managing Indexes.mp4 (98.4 MB)
• 23. Query Performance Analysis with EXPLAIN and ANALYZE.mp4 (82.3 MB)
• 24. Optimizing Queries for Large Datasets.mp4 (75.7 MB)
7 - PostgreSQL Transactions & Concurrency
• 25. ACID Properties in PostgreSQL.mp4 (69.1 MB)
• 26. Using Transactions and Savepoints.mp4 (74.1 MB)
• 27. Isolation Levels (READ COMMITTED REPEATABLE READ SERIALIZABLE).mp4 (79.7 MB)
8 - User Management & Security
• 28. Creating and Managing Users and Roles.mp4 (58.3 MB)
• 29. Row Level Security (RLS).mp4 (70.7 MB)
• 30. Securing Connections with SSL TLS.mp4 (44.7 MB)
• Bonus Resources.txt (0.1 KB)