A collection of documents and scripts for an Oracle SQL database using Oracle SQL Developer. EX 1 & 2 were setting up and importing the data, thus they are excluded from the GitHub Repo.
They are structured by exercise. Both the AP schema and the IT Asset Management DB Diagram are used in the database.
-
EX 3: Queries for a Business Purpose
-
EX 4: Migrate ITAM to the Cloud and Create and Enable Users
-
EX 5: Constraints to Support Data Integrity
-
EX 6: User-Defined Functions, Stored Procedures, and Triggers to Automate Processes
-
EX 7: Database and Query Performance
- Murach's Oracle SQL and PL/SQL for Developers (2nd Edition) by Joel Murach