 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|||||||
|
|
|
|
|
|||
 |
|||
 |
Course Title:
Introduction to PL/SQL
Course Code: STL-OR2 |
||
| Course Description: | SQL
is great for dealing with Databases, but sometimes you need a finer
level of control that is present in a programming language. Oracle
used to have many interfaces from its database to all sorts of programming
languages, but nowadays it primarily brings such facilities in-house
by providing its own programming language called "PL/SQL". Whether you are a well-seasoned programmer or have never programmed in your life, this course will introduce PL/SQL's capabilities to you. |
||
| What You Will Achieve: | Comfort in the bare bones of PL/SQL such that creating anonymous blocks to achieve processing requirements on a database will not be taxing as far as the language is concerned. | ||
| Who Should Attend: | Delegates already familiar with Oracle SQL and wishing to find out enough about Oracle's PL/SQL language. Familiarity with SQL is required; fluency would enhance the delegate's experience. | ||
| Pre-Requisites: | Introductory knowledge of SQL is required so that this PLSQL course can build upon that. | ||
| Course Content: | This
course will cover the following topics: Introduction to PL/SQL - where it sits inside Oracle Anonymous Blocks Executing a block Visible output from PL/SQL PL/SQL variables Retrieving data from the database Updating the database Flow of control Exceptions Cursors User-defined records User-defined tables Cursor "for" loops Course Material: Each delegate receives their own personal textbook which includes material for the course and may include material beyond the course. The present textbook of choice is "Oracle PL/SQL" by Rosenzweig and Silvestra; the right to substitute better material is reserved if such text becomes available. |
||
| Follow-on Courses: | Advanced PL/SQL | ||
| Course Duration: | 2 Days | ||
| Course Price: | P.O.A. | ||
| Contact: | Sentia Training Limited t: 0141-955-0370 e: courses@sentiatraining.com |
||
