https://drive.google.com/drive/folders/19dBX3m1Ds4maMcnY5KQFmon4puIq2GZP?usp=sharing
- In-Class Exercises: CHAPTER 10 SELECTED SINGLE-ROW FUNCTIONS
- In-Class Exercises: CHAPTER 6 ADDITIONAL DATABASE OBJECTS, CHAPTER 13 VIEWS
- In-Class Exercises: CHAPTER 12 SUBQUERIES AND MERGE STATEMENTS
- Activity: Activity 1
- Assignment: Assignment #1 – Subqueries
- In-Class Exercises: CHAPTER 1 INTRODUCTION TO PL/SQL, CHAPTER 2 BASIC PL/SQL BLOCK STRUCTURES
- In-Class Exercises: CHAPTER 3 HANDLING DATA
- Activity: Activity 2
- Assignment: Assignment #2 – Handling Data in PL/SQL Blocks
- In-Class Exercises: CHAPTER 4 CURSORS AND EXCEPTION HANDLING
- In-Class Exercises: CHAPTER 5 PROCEDURES, CHAPTER 6 FUNCTIONS
- Assignment: Assignment #3 – Working with Procedures
- In-Class Exercises: CHAPTER 7 PL/SQL PACKAGES
- Test: Test 1
- In-Class Exercises: CHAPTER 8 DEPENDENCIES, PRIVILEGES, AND COMPILATION
- Activity: Activity 3
- In-Class Exercises: CHAPTER 9 DATABASE TRIGGERS
- Activity: Activity 4
- Activity: Activity 5
- Assignment: Assignment #4 – Using Triggers
- Test: Test 2