Udemy - Master PostgreSQL Database - From Beginner to Advanced

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction to Databases & PostgreSQL
• 1. Introduction to Course.mp4 (44.3 MB)
• 2. Introduction to Databases & PostgreSQL.mp4 (64.7 MB)
10 - JSON & Advanced Data Types
• 24. JSON.mp4 (16.8 MB)
• 25. JSONB.mp4 (12.9 MB)
• 26. Array Types.mp4 (12.4 MB)
• 27. UUID (Universally Unique Identifiers).mp4 (11.5 MB)
11 - Subqueries & Views
• 28. Subqueries & Views Introduction.mp4 (20.9 MB)
• 29. Scalar, Row, Table, Correlated Subqueries.mp4 (48.6 MB)
• 30. Database Views.mp4 (20.5 MB)
12 - Indexes & Performance
• 31. Understanding Indexes.mp4 (10.4 MB)
• 32. B-tree Indexes.mp4 (16.1 MB)
• 33. Hash Indexes.mp4 (10.9 MB)
• 34. GIN Indexes.mp4 (14.6 MB)
• 35. GiST Indexes.mp4 (13.2 MB)
13 - Transactions & Concurrency, A.C.I.D
• 36. Atomicity.mp4 (9.7 MB)
• 37. Consistency.mp4 (4.9 MB)
• 38. Isolation.mp4 (5.1 MB)
• 39. Durability.mp4 (4.6 MB)
• 40. Isolation Levels, Locking & MVCC.mp4 (11.2 MB)
14 - Extending PostgreSQL- Functions & Stored Procedures
• 41. Functions.mp4 (41.8 MB)
• 42. Stored Procedures.mp4 (17.8 MB)
15 - Security & User Management
• 43. Protecting Your Database.mp4 (6.0 MB)
• 44. Create Roles, Grant Privileges, Revoke Access.mp4 (9.7 MB)
• 45. Security Best Practices.mp4 (6.2 MB)
16 - Backup & Restore
• 46. Logical Backups.mp4 (8.5 MB)
• 47. Physical Backups.mp4 (7.4 MB)
• 48. Continuous Archiving.mp4 (7.1 MB)
• 49. Restore Strategies.mp4 (10.2 MB)
17 - PostgreSQL with Applications - Connection Pooling
• 50. Connecting Applications & Connection Pooling.mp4 (35.9 MB)
18 - Real-World Usage & Best Practices
• 51. Database Design Principles.mp4 (7.2 MB)
• 52. Optimisation Strategies.mp4 (6.8 MB)
• 53. Professional Best Practices.mp4 (9.2 MB)
2 - PostgreSQL Installation & Setup
• 3. PostgreSQL Installation & Setup.mp4 (122.9 MB)
3 - PostgreSQL Architecture
• 4. PostgreSQL Architecture - Client, Server, Shared Memory, Data Files.mp4 (74.9 MB)
4 - SQL Basics
• 5. Data Definition Language (DDL).mp4 (44.9 MB)
• 6. Data Manipulation Language (DML).mp4 (25.0 MB)
• 7. Data Control Language (DCL).mp4 (45.1 MB)
• 8. PostgreSQL Data Types.mp4 (9.7 MB)
5 - Data Retrieval (SELECT Queries)
• 9. Basic SELECT Structure, Filtering & Sorting.mp4 (59.8 MB)
6 - Data Modification
• 10. UPDATE.mp4 (13.2 MB)
• 11. DELETE.mp4 (10.7 MB)
• 12. TRUNCATE.mp4 (8.5 MB)
• 13. Transaction Fundamentals- BEGIN, COMMIT, ROLLBACK.mp4 (28.2 MB)
7 - Aggregate Functions
• 14. COUNT, SUM, AVG, MIN, MAX.mp4 (50.2 MB)
• 15. Grouping Data.mp4 (24.0 MB)
8 - Joins & Relationships
• 16. INNER JOIN.mp4 (20.1 MB)
• 17. LEFT JOIN.mp4 (21.2 MB)
• 18. RIGHT JOIN.mp4 (9.8 MB)
• 19. FULL JOIN.mp4 (8.4 MB)
• 20. SELF JOIN.mp4 (18.6 MB)
9 - Constraints & Keys
• 21. Primary Key.mp4 (48.1 MB)
• 22. Foreign Key.mp4 (58.2 MB)
• 23. Unique Constraint.mp4 (52.5 MB)
• Bonus Resources.txt (0.1 KB)