Topic: Oracle Programming
Download (803) times
Last Download at Saturday 21st of January 2012 09:50:34 PM
Oracle Programming Using PL/SQL-Level 1
Expand your Oracle skills to design sophisticated database applications that combine SQL commands for retrieving and manipulating data with logical programming structures to control your data processing. ...
This course introduces you to PL/SQL , which extends the capabilities of SQL by adding the tools and benefits of a procedural programming language. Specifically, you will learn to:
- Identify the benefits and features of PL/SQL.
- Declare and reference variables in your PL/SQL code.
- Write anonymous PL/SQL blocks to select and manipulate Oracle data.
- Process data conditionally, using IF-THEN and CASE statements.
- Use basic loops, WHILE loops, and FOR loops to control data processing iteratively.
- Declare and manage explicit cursors to process individual rows returned by a multiple- row query.
- Use PL/SQL records to process related data items as a logical unit.
- Identify and handle potential errors by defining exceptions and exception handlers.
Through hands-on examples, you will gain practical programming experience with Oracle data while learning accepted programming techniques, conventions, and logic. Each instructor-led, hands-on lesson culminates in an exercise that allows you to practice what you've learned and test your knowledge independently.
...
Source: www.micros.umsl.edu
Related PDF Files
Comments for Oracle Programming Using PL/SQL-Level 1