Why class-room training?Primary audiences for this course may include: Database administrators Web server administrators System administrators Implementation specialists Data center support engineers Senior application designers and developers. Audience may include all Oracle professionals, both business and systems professionals, who wish to achieve various Oracle certification exams and need a “how to” guide to acquire the knowledge of SQL. For non-Oracle professionals already experienced in the SQL but who wish to become acquainted with the unique and advanced features of Oracle SQL. The audience includes specific groups for whom this course will be helpful are application developers and database administrators.
Certifications Exams for Oracle (click to see details):
The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course.
1 – Volume 1
- Relational Databases & SQL
- Choosing a SQL & PL/SQL Interface
- Building a Select Statement
- Restricting Data with the Where Clause
- Sorting Data with the Order by Clause
- Using the Set Operators
- Summary Functions
- Using Sub-Queries
- Aggregating Data within Groups
- Build Simple SQL Plus Reports
- Use Data Definition Language to Create and Manage Tables
- Use Data Manipulation Language to Manipulate Data
- Appendix A
2 – Volume 2
- SQL99 Join Techniques
- Enhancing Groups with Rollup and Cube
- Using the Case Expression SQL Functions: Character
- SQL Functions: Numeric
- SQL Functions: Date
- Database Objects: Relational Views
- Database Objects: Data Dictionary Storage
- Database Objects: Indexes
- Database Objects: Other Objects
- Database Objects: Security
- Data Integrity Using Constraints
- Managing Constraint Definitions
- Advanced SQL Plus Reports
- Optional – Advanced SQL Plus Reports
- Optional – Building SQL Plus Scrips
- Optional – SQL Plus Session Control
Primary objectives for this course include:
- Configuration of the Linux and MS Windows operating systems in anticipation of a database installation
- Server Class installation of the Oracle 11g R2 Enterprise Edition database
- Verification of a valid database installation
- Database administrator interface options, including the use of Enterprise Manager, command-line SQL*Plus, and terminal console SSH
- Database un-installation
- Online software patching
- Startup and shutdown of database services and related software components
- Super administrator authentication options
- An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
- Management of database files.
- Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the Result Cache, the database buffer cache, and other similar components.
- Management of security policies and procedures, including administration of user accounts, roles, privileges and profiles.
- Utilization of advanced self-tuning and self-management capabilities, including the use of Oracle-Managed Files, database Advisors and other components of the Management Framework.
- Performance monitoring, problem troubleshooting, and resolving lock and conflict issues.
- Using the Oracle Enterprise Manager and SQL interfaces for administration tasks.
- Control over database support services, including the Database Control, Oracle Net and others.
- A primer on backup and recovery structures and strategies.
- Operating system-specific considerations for various platforms, especially Linux and MS Windows Server.
1 – Installation and Upgrade Volume
- Configuring the Server for Installation
- Enterprise Edition Installation
- Verify the Installation
- Upgrade, Deinstallation and Patching
2 – Volume A
- Manually Starting & Stopping Database Services
- Exploring the Oracle Database Architecture: General
- Exploring the Oracle Database Architecture: Instance Memory
- Exploring the Oracle Database Architecture: Instance Processes
- Creating an Oracle Database
- Enabling Transparent Data Encryption
- Manage Databases Storage Structures: TableSpaces
- Manage Database Storage Structures: Advanced TableSpaces
- Manage Database Storage Structures: Data Files & Temp Files
- Managing Undo Data
3 – Volume B
- Network Environment: Oracle Net Services
- Network Environment: Oracle Shared Servers
- Security: Implementing Database Security
- Security: Administering User Security
- Moving Data: SQL Loader
- Moving Data: Export & Import
- Database Maintenance & Performance Monitoring
- Managing Concurrency & Locks
- Backup and Recovery Concepts and Configuration
This course brings database administrators beyond a basic understanding of their duties and to transfer advanced skills needed to effectively administer an Oracle database installation within a large-scale enterprise.
- Automatic database management, monitoring and tuning facilities. Included are automatic management of storage space and memory resources within the database and the role of the Segment Advisor and Memory Advisors.
- Automatic resumption of database operations even in the face of storage space allocation failures and errors.
- Setting metric and alert thresholds for proactive database monitoring.
- Using deferred segment creation to improve performance and establish efficient use of space.
- Globalization features within the database to support applications in multiple languages, currencies, time zones and countries.
- Utilizing diagnostic sources in troubleshooting database problems and employing the Fault Diagnosability Infrastructure, the Database Instance Health monitor and the Support Workbench to capture and process fault data.
- Configuring the database to recover from a wide variety of failures. This includes configuring redo log files and the Flash or Fast Recovery Area.
- Using Oracle flashback technology to recover from user errors and from database failures, including Flashback Data Archive and Flashback Transaction Backout as part of the Oracle Total Recall technology.
1 – Volume A: Advanced Database Administration
- Managing Memory
- Managing Storage & The Segment Advisor
- Diagnosing Database Problems
- Recovery Concepts
- Oracle Flashback Technology
- Flashback Database & Flashback Data Archive
2 – Volume B: Resource Manager & Scheduler
- Managing Resources
- Automating Tasks with the Scheduler (Basic)
- Automating Tasks with the Scheduler (Advanced)
- Managing Database Performance
3 – Volume C: RMAN Backup & Recovery
- Instance Recovery
- Configuring RMAN
- Backup with RMAN
- RMAN Management with EM
- User-Managed Recovery Operations
- Recovery with RMAN
- Using the RMAN Recovery Catalog
- Database Duplication & Cloning
- Advanced RMAN Capabilities
- Transporting TableSpaces
- Recovering From Corruption with Data Recovery Advisor
Other Details regarding above courses:
Perform Root Cause analysis under guidelines of supervisor.
Training contents have been developed by Industry professionals
Project based hands-on approach
Tips and tricks from experts
Lab Exercises, self assessments and Assignments
Interactive sessions, promoting inquisitive audience
CHROMEIS Certified Oracle Programmer (subject to passing our testing)
Discount depends upon several factors depending size of group, cost of trainer and duration etc. Generally, we offer:
10% discount on a group of at least 2 participants
50% discount for Candidates seeking revision
Public Material: Download of slides is unavailable