Jan 15, 2021  
2016-2017 Catalog 
    
2016-2017 Catalog [PAST CATALOG]

CTP 147 - PL-SQL Programming

3 credit hours - Two hours of lecture and two hours of laboratory weekly; one term.
(formerly CSI 182 - PL-SQL Programming)

Learn the principles of database programming using PL/SQL language to access and manipulate data in a database. Learn stored procedures, functions, packages and database triggers. Learn key skills required for declaring variables and trapping exceptions. This course is the second in the series of Oracle database administration courses. Lab fee $35.

Prerequisite(s): CTP 145  with a grade of C or better or permission of the CTP department chair.

Course Outcomes
Upon successful completion of this course, students will be able to:
 

  • Introduction to PL/SQL
    • Create PL/SQL program blocks
    • Identify and use appropriate programming constructs to fulfill application logic needs
  • Basic PL/SQL Blocks
    • Create PL/SQL program blocks
    • Identify and use appropriate programming constructs to fulfill application logic needs
  • Handling Data in PL/SQL
    • Create PL/SQL program blocks
    • Identify and use appropriate programming constructs to fulfill application logic needs
    • Manipulate database tables using PL/SQL programming
    • Use Oracle-supplied packages in PL/SQL program units
  • Cursors and Exceptions
    • Create PL/SQL program blocks
    • Identify and use appropriate programming constructs to fulfill application logic needs
    • Manipulate database tables using PL/SQL programming
    • Build error trapping facilities within PL/SQL programs
  • Procedures
    • Create PL/SQL program blocks
    • Identify and use appropriate programming constructs to fulfill application logic needs
    • Manipulate database tables using PL/SQL programming
    • Create PL/SQL program units including: procedures, functions, triggers, and packages
    • Use Oracle-supplied packages in PL/SQL program units
  • Functions
    • Create PL/SQL program blocks
    • Identify and use appropriate programming constructs to fulfill application logic needs
    • Manipulate database tables using PL/SQL programming
    • Create PL/SQL program units including: procedures, functions, triggers, and packages
    • Use Oracle-supplied packages in PL/SQL program units
  • Packages
    • Create PL/SQL program blocks
    • Identify and use appropriate programming constructs to fulfill application logic needs
    • Manipulate database tables using PL/SQL programming
    • Create PL/SQL program units including: procedures, functions, triggers, and packages
    • Use Oracle-supplied packages in PL/SQL program units
  • Dependencies
    • Create PL/SQL program blocks
    • Identify and use appropriate programming constructs to fulfill application logic needs
    • Create PL/SQL program units including: procedures, functions, triggers, and packages
    • Use Oracle-supplied packages in PL/SQL program units
  • Triggers
    • Create PL/SQL program blocks
    • Identify and use appropriate programming constructs to fulfill application logic needs
    • Manipulate database tables using PL/SQL programming
    • Build error trapping facilities within PL/SQL programs
    • Create PL/SQL program units including: procedures, functions, triggers, and packages
    • Use Oracle-supplied packages in PL/SQL program units
  • SQL *Loader
    • Create PL/SQL program blocks
    • Identify and use appropriate programming constructs to fulfill application logic needs
    • Load data into Oracle tables from external files using the SQL*Loader utility
  • Dynamic SQL
    • Create PL/SQL program blocks
    • Identify and use appropriate programming constructs to fulfill application logic needs
    • Manipulate database tables using PL/SQL programming
    • Identify uses of dynamic SQL and object technology
Core Competencies
Core 1 Communication Core 2 Technology Fluency Core 3 Information Literacy Core 5 Self Management Core 9 Global Perspective Core 10 Innovative and Critical Thinking