APPLIED DATABASE: DATABASE PROGRAMMING WITH SQL AND PL/SQL (4 SCU)

Learning Outcomes:

On successful completion of this course, students will be able to: identify identify and extract information from a business process; demonstrate Demonstrate Advanced Database Design techniques Relationship, Normalization; apply Apply Advanced Database Design techniques (Arcs, Hierarchies, and Recursive Modeling); identify row and column data from tables with the SELECT statement; express Business need for combining information from multiple data sources; apply Advanced SQL data retrieval techniques to retrieve data from database tables.

Topics:

1. Introduction Database Design;
2. Entities and Attributes;
3. Relationship Basics;
4. Super/Sub Types and Business Rules;
5. Relationship Fundamentals;
6. UIDs and Normalization;
7. Arcs, Hierarchies, and Recursive Modeling;
8. Changes and Historical Modeling;
9. Mapping;
10. Creating Database Projects;
11. Presenting Database Projects;
12. Introduction SQl Express;
13. SELECT and WHERE;
14. WHERE, ORDER BY, and Intro to Functions;
15. Single Row Functions Part I;
16. Single Row Functions Part II;
17. JOINs Part I;
18. JOINs Part II;
19. Group Functions Part I;
20. Group Functions Part II;
21. Subqueries;
22. DML;
23. DDL;
24. Constraints;
25. Views;
26. Sequences and Synonyms;
27. Privileges and Regular Expressions;
28. TCL;
29. Final Project SQL.