APPLIED DATABASE: ADMINISTRATION AND RECOVERY (4 SCU)

Learning Outcomes:

On successful completion of this course, students will be able to: LO1 – Identify Database Basics; LO2 – Identify Developing Database Applications; LO3 – Identify Data Integration; LO4 – Identify Database Resiliency and Security; LO5 – Relate Machine Learning; LO6 – Relate Data Management.

Topics:

1. Introduction to Machine Learning;
2. Database Basics – Part 1 – What are databases, What do they do, What are the basic components;
3. Data Modeling Fundamentals;
4. Database Availability;
5. Low Code Database Application Development;
6. Database Basics – Part 2 – Tables, Keys, SQL Basics;
7. Review 2;
8. Review 1;
9. Data Integration – The Key to Data Centric Data Management;
10. Developing Database Applications – Beyond Tables and SQL;
11. Introduction to Graph Database and Analytics;
12. Database Security;
13. Introduction to Spatial Database on Oracle.