PostgreSQL
Fundamentals
Fundamentals
За курса
Умения, които ще придобиеш
-
Използване на процедури и функции
-
Работа с бази данни
-
Манипулиране и съхраняване на данни
-
Агрегиране на данни в PostgreSQL
-
Работа с релации между таблици
-
Управление на transactions
Теми
- 1. Resources
- 2. Course Introduction
- 3. PostgreSQL Introduction. Data Types. Working with Tables
- 4. Exercise: Data Types. Working with Tables
- 5. Basic CRUD
- 6. Exercise: Basic CRUD
- 7. Built-in Functions
- 8. Exercise: Built-in Functions
- 9. Data Aggregation
- 10. Exercise: Data Aggregation
- 11. Table Relations
- 12. Exercise: Table Relations
- 13. Subqueries and JOINs
- 14. Exercise: Subqueries and JOINs
- 15. Database Programmability and Transactions
- 16. Exercise: Database Programmability and Transactions
- 17. Exam Preparation
- 18. Exam Preparation
- 19. Regular Exam
- 20. Retake Exam