OCP: Oracle Certification Expert is the certification course of Oracle Database DBA (Database Administrator) of Oracle Company. Passing this exam shows that this person can manage large databases or develop powerful applications that can be deployed throughout the enterprise. OCP requires OCA (Oracle Certified Associate) certification. At present, it is mainly Oracle 1 1g version certification.
training class
Oracle database 1 1g: SQL basic I (SQL basic I exam code 1Z0-05 1).
Oracle database 1 1g: management seminar I (management course exercise I exam code 1Z0-052)
Oracle database 1 1g: management seminar II (management course exercise ii exam code 1Z0-053)
The study period is 2-3 months; Theory class 120 hours, you can listen to it again for free; The experiment time is not limited.
Note: If you have passed the OCP exam, you must obtain the original OCP training records of authorized training institutions in Oracle Bone Inscriptions before you can obtain the OCP certificate.
Additional: 9iOCP- 1 1g OCP: you need to pass the exam of 1Z0-055;
10 OCP-110 OCP: you need to pass the exam of 1Z0-050;
course syllabus
The first course, Oracle database 1 1g: SQL basics I learning content:
1. Master the relational database data model;
2. Clever deployment of database system on Linux platform;
3. Customize various databases according to business requirements;
4. Master the storage principle of data structure and data type in the database.
5. Skillfully use SQL statements to retrieve, operate and manage data in the database;
6.6 and other advanced methods. MEGER, USING, ROLLUP, CUBE, set operators and hierarchical extraction are used to extract data;
7. Write SQL script files to generate output results similar to reports;
8. Use development tools to write procedures, functions, packages, triggers and other program blocks;
9. Learn to look up the data dictionary
The second course, Oracle database 1 1g: administrator I learning content:
Understand the structure of ORACLE core component instance and master the logical and physical storage structure of Oracle database 3. Manage Oracle instances, log files, control files, tablespaces, users, permissions, roles, tables, indexes, and rollback segments.
4 Oracle Net Services network configuration, which realizes database failover and load balancing.
4 Configure the application database
5 Use the basic monitoring process
6 Implement backup and recovery strategies
7 Move data between databases and files.
The third course, Oracle database 1 1g: administrator II learning content:
1 Create a database that can run normally, and how to manage various structures effectively and efficiently, so as to construct a well-designed and efficient database.
2 How to achieve database security
3 using resource manager to manage resources, job scheduling, security and globalization issues
4. According to the business requirements, formulate and improve the backup, recovery and recovery strategy of the database.
5. Implement the planning and implementation of database backup and recovery strategy, and how to verify the correctness.
According to more than a dozen different causes of actual database damage, different recovery methods are adopted.
7. Be familiar with the Recovery Manager tools to perform backup, recovery and block repair.
Use scripts to monitor the memory, performance and storage of the database.
9 Operating system-level tuning
10 is used for SQL statement tuning.
1 1 Use a variety of different tools to identify, analyze and solve the bottlenecks in the operation of Oracle database.