OCA 11g
Pre-registration for this coursePlease pre-register without obligation!
Next classesCheck out our schedule and sign up now!
Course provides the participant with an Oracle 11g DBA training in preparation for the exams required for certification OCA (Oracle Certified Associate).
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 .
Professionals already working with other database or who want to get the OCA (Oracle Certified Associate), 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
- Recovery, restricting and sorting data using SQL
- Use of single-line functions, 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 user access
- Management of objects through the dictionary views
- Handling of large data sets
- Data management in different time zones
- Recovering data using subqueries
- Data retrieval using regular expressions
Module - Administration I:
- Concepts of the architecture of Oracle Database 11g
- Installation of Oracle server software
- Creation of database
- Managing the Oracle instance
- Configuration of the Oracle network environment
- Management of storage structures in the database
- Management of user security
- Management of schema objects
- Data management and competition data
- Managing undo data
- Implementation of security Oracle database
- Proactive Maintenance Database
- Check and Performance Tuning
- Backup and Recovery Concepts
- Backup the database
- Recovery of database
- Moving data
- Fix problems, and applying patches
• Training: 40 (forty) 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: RHCE (RedHat Certified Engineer), CCVP (Cisco Certified Voice Professional); LPI3 (Linux Professional Institute Senior Level).
• 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 OCA 11g Database Admin I.
• 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,590.00 (one thousand five hundred ninety reals).
· Offer special discounts for business groups.
© 2010-2011 Integreat | Integrator Solutions, all rights reserved.
