fbpx

Oracle 12c Database Programming and Administration

Join Now

Online Class

Oracle Database 12c Introduction to SQL

• How to retrieve Data using SQL SELECT Statement
• Limit the Rows and sort data
• Single-row functions
• Conversion functions and Conditional Expressions
• Group Functions
• Join concept
• Sub queries
• Retrieving Data by using Sub queries
• Set Operators
• Data Manipulation Language Commands
• Data definition Language commands
• Database Objects
• Views
• Sequences
• Synonyms
• Indexes
• Data retrieval by using Sub queries
• Multitable INSERTs

Oracle Database 12c R2 Program with PL/SQL

• Introduction to PL/SQL
• Writing Anonymous PLSQL Blocks
• How to Write SQL statements in PLSQL Block
• Control Structures
• Composite Data Types
• Managing Explicit Cursors
• Handling Exceptions
• Managing Subprograms – Procedures and Functions
• Creating Packages
• Triggers
• Create compound Triggers
• Oracle-Supplied Packages in Application Development
• UTL_FILE package to interact with Operating System files
• Dynamic SQL
• Managing Dependencies

Oracle Database 12c Advanced PLSQL

• Overview of Collections
• Working with Large Objects
• Working with JSON Data
• Advanced Interface Methods
• Benefits of External Procedure
• Improving Performance
• Analyzing PLSQL Code
• Tracing and Profiling PLSQL Code
• Secure your code against SQL Injection Attacks
• Fine Grained Access Control

Oracle Database SQL Tuning for Developers

• Introduction to SQL Statement Tuning
• Application Tracing Tools
• Basic Tuning Techniques
• Fundamentals of Optimizer
• Execution Plans generation and Display
• Access paths – Table and index
• Optimizer joins operations
• Optimizer Statistics Concepts
• Bind Variables
• SQL Plan management

Oracle Database 12cR2 Administration

• Oracle Database Architecture
• Database instance
• Creating Pluggable Databases
• Oracle Network Environment
• User Security
• Tablespace Management
• Storage space management
• Undo Data
• Oracle Data Pump overview
• Backup recovery concepts
• Database Performance

Oracle Database 12c Backup and Recovery

• Overview of Recovery Manager
• Configuring Archive log mode and
• Overview of Fast Recovery Area
• RMAN Recovery Catalog
• Backup Concepts and Strategies
• Creating Backups
• Restore and Recovery Concepts
• Performing Recovery
• Flashback Technologies
• Flashback Database
• Restore and Recovery Performance Best Practices
• Scenarios on Backup and Recovery

Join Now

Online Class

Enquire Now

Enquire Now