Oracle® PL/SQL Programming: Hands-On Course: 493 Duration: 5 Days You Will Learn How To
- Develop efficient PL/SQL programs to access Oracle databases
- Create stored procedures and functions for maximum reuse and minimum code maintenance
- Design modular applications using packages
- Manage data retrieval for front-end applications
- Bulk bind collections to increase the speed of data movement operations
- Invoke native dynamic SQL to develop high-level abstract code
Course BenefitsThe Oracle PL/SQL language—a flexible procedural extension to SQL—increases productivity, performance, scalability, portability and security. In this course, you gain the practical knowledge to write PL/SQL programs. You learn to build stored procedures, design and execute modular applications, and increase the efficiency of data movement.Who Should AttendProgrammers and others working with PL/SQL. A working knowledge of SQL and PL/SQL at the level of Course 926, "Oracle Database 11g Comprehensive Introduction", or Course 593, "Oracle Database 10g Comprehensive Introduction", is assumed.Hands-On TrainingExtensive hands-on exercises provide experience writing modular PL/SQL code. Exercises include:
- Encapsulating data manipulation statements in stored procedures and packages
- Performing complex data manipulation with cursors
- Leveraging EXCEPTIONs to handle runtime errors
- Creating triggers to handle data integrity and derivation
- Utilising weak and strong cursor variables for dynamic SQL
- Denormalising data with user-written functions
- Creating global variables in bodiless packages for session processing
Related Courses- 492 Oracle Databases: Application Development & Tuning
- 234 Developing SQL Queries for Oracle Databases
- 927 Oracle Database 11g Administration
- 928 Oracle Database 11g: Backup, Recovery and Tuning
- 532 SQL Server Transact-SQL Programming
- 534 SQL Queries for SQL Server
- 139 SQL Server Analysis Services
Oracle is a registered trademark of Oracle Corporation. PL/SQL is a trademark of Oracle Corporation. |
|
Upcoming Dates
| UK Dates | | 12-16 Mar | London | | 13-17 Aug | London | | 10-14 Dec | London | US East Coast Dates | | 26-30 Mar | Washington, DC* | | 16-20 Apr | Washington, DC* | | 30 Apr - 4 May | New York* | *New York and Washington, DC Courses – Available online with a run time of 2pm to 9pm BST. | For AnyWare enrolments, please register at least 10 days prior to the start of the course. |
For complete schedule, please visit www.learningtree.co.uk
|