Termékleírás

What you will learn This Oracle Database: Program with PL/SQL training starts with an introduction to PL/SQL and then explores the benefits of this powerful programming language. Through hands-on instruction from expert Oracle instructors, you'll learn to develop stored procedures, functions, packages and more.

Learn To:

Conditionally control code flow (loops, control structures). Create stored procedures and functions. Use PL/SQL packages to group and contain related constructs. Create triggers to solve business challenges. Use some of the Oracle supplied PL/SQL packages to generate screen output and file output. Create custom packages for applications. Write Dynamic SQL code for applications.

Benefits to You:

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds. Use Oracle SQL Developer You will use Oracle SQL Developer to develop these program units. SQL*Plus is introduced in this course as optional tools.

Course Bundle Note: This course is a combination of Oracle Database: PL/SQL Fundamentals and Oracle Database: Develop PL/SQL Program Units courses.

Kinek ajánljuk

• Audience
• Application Developers
• Database Administrators
• Developer
• Forms Developer
• PL/SQL Developer
• Portal Developer
• System Analysts
• Technical Consultant

Tematika

• Grid Infrastructure: Overview
• RAC Databases Overview & Architecture
• Installing and Configuring Oracle RAC
• Oracle RAC Administration
• Upgrading and Patching Oracle RAC
• Managing Backup and Recovery for RAC
• RAC Global Resource Management and Cache Fusion
• RAC Database Monitoring and Tuning
• Managing High Availability of Services in a RAC Environment
• Managing High Availability of Connections
• Application Continuity
• RAC One Node
• Oracle Database In-Memory in RAC
• Multitenant Architecture and RAC
• Quality of Service Management
• Oracle Database Exadata Cloud Service Overview