Databases and Data Management

What this subject covers

Lesson topics

1. Why Data and Databases Matter to Modern Organisations
2. Data, Information, and Knowledge: Related but Distinct Concepts
3. Types of Databases: Relational and Beyond
4. Tables, Rows, and Columns: The Structure of Relational Data
5. Primary Keys and Uniquely Identifying Records
6. Foreign Keys and Relationships Between Tables
7. Database Normalisation: Reducing Redundancy
8. SQL: The Language of Relational Databases
9. Querying Data: Filtering, Sorting, and Joining
10. Data Types: Choosing the Right Format for Each Column
11. Data Integrity: Keeping Data Accurate and Trustworthy
12. Database Design: Planning Before Building
13. Indexes: Improving Query Performance
14. Data Backups and Recovery for Databases
15. Database Security: Protecting Sensitive Data
16. Data Quality: Beyond Just Having Data
17. Data Governance: Rules and Responsibility for Organisational Data
18. Data Privacy: Protecting Personal Information
19. Data Warehousing and Business Intelligence
20. Big Data: Volume, Velocity, and Variety
21. Master Data Management: A Single Source of Truth
22. Cloud Databases and Database-as-a-Service
23. Working With Data Responsibly and Ethically
24. Careers and Roles in Databases and Data Management
25. Bringing It Together: Databases as an Organisational Asset