OCP 11g
Pre-registration for this coursePlease pre-register without obligation!
Next classesCheck out our schedule and sign up now!
Course provides the participant a complete Oracle 11g DBA training in preparation for the exams required for certification OCA (Oracle Certified Associate) and OCP (Oracle Certified Professional).
Include the concepts of data modeling, the data manipulation language SQL (used for the restoration, creation, updating and deleting data contained in the database), the concepts of the architecture of Oracle Database 11g, the procedures for installation of a server Oracle Database 11g, the procedures for monitoring and tuning (tuning) the performance of the database, resource management and user management, data security, procedures and tools for backup, recovery and migration of the database , configuration database for multilingual applications, use of tools such as Oracle Recovery Manager (RMAN) and the Scheduler and the deployment of new technologies, such as FlashBack and Automatic Storage Management (English Automatic Storage Management - ASM).
Professionals already working with other database or who want to get the OCP (Oracle Certified Professional), support analysts, university students in the areas of computer science and engineering.
Familiarity with concepts and techniques of data processing.
Introduction to SQL:
-Introduction to Data Modeling (MER, Normal Forms)
-Introduction to Oracle Database 11g
Recovering, restricting and sorting data using SQL
-Use of functions of single-line and batch conversion
-Display data from multiple tables
-Use of subqueries
-Use the SET operators
-Data manipulation (insert, edit and delete) using the SQL language
-Use of DDL statements for creating and managing tables
-Create and manage other schema objects (views, sequences, indexes, and procedures)
-Control of user access
-Management of objects through the dictionary views
-Handling of large data sets
-Management of data in different time zones
Recovering data using subqueries
Recovering data using regular expressions
Module - 1 Administration:
Concepts of the architecture of Oracle Database 11g
-Installation of the Oracle server software
Creation of database
-Managing the Oracle instance
-Setting the Oracle network environment
-Management of the storage structures of the database
-Management of user security
-Management of schema objects
-Data management and competition data
-Data Management undo
Implementation of safety-Oracle database
-Proactive Maintenance Database
-Check and Performance Tuning
-Backup and Recovery Concepts
-Backup the database
Recovering the database
Moving data-
-Correction of problems and applying corrections
Module - 2 Administration:
-Database Architecture and ASM (Automatic storage management)
-Preparation of the database for fast retrieval
-Use the RMAN recovery catalog
Setting-up specifications
Creation of backups
-Implementation of backup and recovery managed by the user
-Use RMAN to perform recoveries
-Use RMAN to duplicate a database
Recovery-point-in-time tablespace
-Monitoring and Tuning RMAN
Use of technology-flashback
-Use of flashback database
Diagnosis of the database
-Memory Management
-Performance management
-Use the segment advisor
-Resource Management
-Automating tasks with the scheduler
Administration-scheduler
Use of field-unicode
-Configuration database for multilingual support
• Training: 56 (fifty six) hours.
• Experienced Instructors: Professionals who have worked with projects of high complexity in Unified Communications, both in a Pre-sale and post-sale. Having already implemented some projects either using Asterisk, the Asterisk platform.
• Certified Instructors: OCA (Oracle Certified Associate), OCP (Oracle Certified Professional) and RHCE (RedHat Certified Engineer).
• Environment ideal: A desktop per student, complete laboratory, virtual environment, air conditioned space and excellent coffee break's.
• Methodology facilitated: Instructors with great teaching, covering practical examples and theoretical techniques of memorization.
• Material: Each student gets a book OCP Database 11g Database Administrator.
• Opportunities to Work: Statement of participants to the labor market.
· Period Night: Monday to Friday 18:30 to 22:30 min.
· At weekends: Saturdays and Sundays from 08h to 17h.
· Period Integral: Monday to Friday from 08:00 to 17h.
· At Saturdays: Saturdays from 08h to 17h.
· Payment facilitated: Up to 10x the credit card VISA or Mastercard or 3x in the post-dated check or by bank transfer (companies). We also offer discounts for cash payments.
· Value of Investment: R$ 1,990.00 (one thousand nine hundred and ninety reals).
· Offer special discounts for business groups.
© 2010-2011 Integreat | Integrator Solutions, all rights reserved.
