Course Overview:
In this class, students will learn how to create, retrieve & manipulate objects in Oracle 11g Structure Query Language (SQL). Students will also be introduced to Oracle 11g database features & tools. In addition, students will learn the functions of the PL/SQL programming language. Students will write stored procedures, functions, packages & triggers & implement complex business rules in Oracle. Students will learn programming, management & security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers & stored procedure features.
Attendees to OR-415A: Oracle 11g: SQL & PL/SQL Programming will receive TechNow approved course materials and expert instruction.
Dates/Locations:
No Events
Duration: 5 Days
Course Objectives:
- Relational Database & SQL Overview
- Using Oracle SQL *Plus
- SQL Queries – the SELECT Statement
- Scalar Functions
- SQL Queries – Joins
- Aggregate Functions & Advanced Techniques
- Data Manipulation & Transactions
- Data Definition & Control Statements
- Other Database Objects
- Triggers
- PL/SQL Variables & Datatypes
- L/SQL Syntax & Logic
- Stored Procedures & Functions
- Exception Handling
- Records & Collections
- Cursors
- Using Packages
- Creating Packages
- Working with LOBs
- Maintaining PL/SQL Code
Prerequisites:
- Basic knowledge of relational databases.
Comments
Latest comments from students
User: jlokey56
Instructor comments: Great instructor, he kept the class interesting and the pace lively. Well done! Thanks!
Facilities comments: Nice facilities, and enjoyed the complimentary refreshments.
User: albersb
Instructor comments: Informative, very willing to demonstrate and provide examples for us to understand, and helped alot in diagnosing/preventing common errors.