3 credit/unit hours – Three hours of lecture weekly; one term

This course covers programming in the Structured Query Language. Students are taught to create and maintain database objects and to store, retrieve, and manipulate data. In addition, students learn to create blocks of application code that can be shared by multiple forms, reports, and data management applications. Students also learn how to write and apply triggers, procedures, and packages. Demonstrations and hands-on practice reinforce the fundamental concepts.

Learning Objectives

Upon completion of this course the student will be able to:

  • Use SQL commands to create, maintain, and query a relational database;
  • Write SQL scripts that create, maintain, and query relational databases;
  • Develop, maintain, and use triggers, procedures, and packages within a relational database; and
  • Demonstrate appropriate and ethical behavior and good work habits

Main Topics

1.0 Query commands
2.0 Joining multiple tables
3.0 Single row and group functions
4.0 Subqueries
5.0 Creating and managing tables
6.0 Constraints
7.0 Data manipulation
9.0 Other objects: sequences, indexes, and synonyms
10.0 Creating and managing users
11.0 Formatting output
12.0 PL/SQL blocks
13.0 Procedures
14.0 Functions packages
15.0 Triggers
16.0 Performance tuning