icon

Oracle PL/SQL/DBA

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. A database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery.

Oracle Database is the first database designed for enterprise grid computing, the most flexible and cost effective way to manage information and applications. Enterprise grid computing creates large pools of industry-standard, modular storage and servers. With this architecture, each new system can be rapidly provisioned from the pool of components. There is no need for peak workloads, because capacity can be easily added or reallocated from the resource pools as needed.

Oracle Certified Associate (OCA) - This lower-level certification is offered by Oracle for those candidates who successfully passed only two of the four OCP exams. OCA: Oracle Database 11g Administrator Certified Associate (Exams1Z0-051 and 1Z0-052)

Course Contents

  • Basic SQL SELECT Statements.
  • Single-Row Functions.
  • Group Functions.
  • Joins and Sub-queries.
  • Modifying Data.
  • Creating Tables.
  • Creating Schema Objects.
  • Oracle Database 11g: Administration.
  • Oracle Database 11g Components and Architecture.
  • Create an Oracle11g Database.
  • Database Storage and Schema Objects.
  • Oracle Network Architecture.
  • Security and Auditing.
  • Managing Data and Undo.
  • Proactive Maintenance and Performance Monitoring.
  • Implementing Database Backups.
  • Recovering Database.
  • EM Tools and Data Utilities

Oracle Certified Professional (OCP) : The Oracle certified professional is required to pass four challenging exams and demonstrate proficiency in all technical areas of Oracle database administration.

OCP : Oracle Database 11g Administrator Certified Professional Certification Exams: (1Z0-051, 1Z0-052, and 1Z0-053)

Oracle Certified Masters (OCM) : The premier Oracle certification, requiring an OCP plus a challenging on-site practicum.