Oracle Database 10g: Introduction to SQL/PLSQL Accelerated
What you will learn:
This course is designed for developers with basic SQL and PL/SQL language skills. This is a 5 days accelerated course specifically designed to provide students with an end-to-end training on programming with SQL and PL/SQL. This course starts by introducing the students with Oracle Database 10g technology, SQL and PL/SQL and then ends with providing them hands on training on advanced concepts such as develop stored procedures, functions, packages and database triggers.
Oracle Database 10g: SQL Fundamentals I is the first course of the bundle, which provides the essential SQL skills that allow students to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data.
Oracle Database 10g: SQL Fundamentals II is the second course in the bundle in which students learn the advanced querying and reporting techniques. This also discusses schema objects that are useful for data warehousing and other application areas.
The third course of this bundle is Oracle Database 10g: PL/SQL Fundamentals. This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. At this stage, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.
Oracle Database 10g: Develop PL/SQL Program Units is the last course in which students learn to develop, execute and manage PL\SQL stored program units like procedures, functions, packages and database triggers. Students also learn to manage object dependencies and recompilation of invalid objects.
|
Schedule/Purchase
|
Training Formats
|
Price
|
Duration
|
|
View Schedule (Link)
|
Instructor-Led Training
|
SAR 7031.25
|
5 Days
|
Audience:
- Database Administrators
- Application Developers
- Business Intelligence Developer
- Database Designers
- End Users
- Forms Developer
- PL/SQL Developer
- Technical Consultant
Course Objectives:
- Control user access and manage schema objects
- Employ SQL functions to generate and retrieve customized data
- Run data manipulation statements (DML) to update data in the Oracle Database 10g
- Categorize the Oracle supplied PL/SQL packages
- Create overloaded package subprograms for more flexibility
- Create triggers to solve business challenges
- Create & describe stored procedures and functions
- Design PL/SQL code for predefined data types, local subprograms, additional programs and standardized constants and exceptions
- Design PL/SQL packages to group and contain related constructs
- Design PL/SQL program units that execute efficiently
- Handle run-time errors
- Manage dependencies between PL/SQL subprograms
- Manipulate large objects
- Schedule PL/SQL jobs to run independently
- Use PL/SQL programming constructs and conditional control statements
- Write dynamic SQL for more coding flexibility
Course Topics:
No Course Topics
Suggested Next Courses:
|
