Oracle OCP 10g Certification Course - Unisoft India

Share this page:
This credential enables IT professionals to successfully install, manage, and troubleshoot all aspects of Oracle database. OCA DBA 10g and Oracle10g OCP or Oracle Certified Professionals are highly valued and highly paid for effectively managing the industry's most advanced information systems.
Oracle continues to dominate the database industry. OCP is the advanced level certification in Oracle.
Several versions of Oracle are being used in the industry. Oracle 12c is the latest. However, most jobs in the market are still for Oracle 9i,Oracle 10g and Oracle 11g and it is better to take one of them.
Oracle training is usually conducted on Microsoft Window Server platform. If you prefer, you can opt for Oracle training on Linux.
We are known Oracle Training and Certification Authorised Center or Institute in Nagpur.

Step 1 - Prior Certification Requirements

Step 2 - Complete one of these courses.

Candidates must complete one instructor-led course.

Step 5 - Complete this form.

Schedule for OCA & OCP DBA 10g  (Oracle Training in Nagpur)
Course Contents Exam # Regular Track (days) Fast Track (days)
Oracle Database 11g: SQL Fundamentals I 1Z0-051 25 5
Oracle Database 10g: Administration Workshop I 1Z0-042 30 5
Oracle Database 10g: Administration Workshop II 1Z0-043 30 5
Balance Days for arrival, exam(s) and practice 15 4
Total duration 100 19

Oracle Database 11g: SQL Fundamentals I (Course Content / SQL Sylabus)

Retrieving Data Using the SQL SELECT Statement 
  • List the capabilities of SQL SELECT statements
  • Execute a basic SELECT statement
Restricting and Sorting Data
  • Limit the rows that are retrieved by a query
  • Sort the rows that are retrieved by a query 
  • Use ampersand substitution to restrict and sort output at runtime
Using Single-Row Functions to Customize Output 
  • Describe various types of functions available in SQL
  • Use character, number, and date functions in SELECT statements
Using Conversion Functions and Conditional Expressions
  • Describe various types of conversion functions that are available in SQL
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions 
  • Apply conditional expressions in a SELECT statement
Reporting Aggregated Data Using the Group Functions 
  • Identify the available group functions
  • Describe the use of group functions 
  • Group data by using the GROUP BY clause 
  • Include or exclude grouped rows by using the HAVING clause
Displaying Data from Multiple Tables 
  • Write SELECT statements to access data from more than one table using equijoins and nonequijoins
  • Join a table to itself by using a self-join 
  • View data that generally does not meet a join condition by using outer joins 
  • Generate a Cartesian product of all rows from two or more tables
Using Subqueries to Solve Queries 
  • Define subqueries
  • Describe the types of problems that the subqueries can solve 
  • List the types of subqueries 
  • Write single-row and multiple-row subqueries
Using the Set Operators 
  • Describe set operators
  • Use a set operator to combine multiple queries into a single query 
  • Control the order of rows returned
Manipulating Data 
  • Describe each data manipulation language (DML) statement
  • Insert rows into a table 
  • Update rows in a table 
  • Delete rows from a table 
  • Control transactions
Using DDL Statements to Create and Manage Tables
  • Categorize the main database objects
  • Review the table structure 
  • List the data types that are available for columns 
  • Create a simple table 
  • Explain how constraints are created at the time of table creation 
  • Describe how schema objects work
Creating Other Schema Objects
  • Create simple and complex views
  • Retrieve data from views 
  • Create, maintain, and use sequences 
  • Create and maintain indexes 
  • Create private and public synonyms

Oracle Database 10g: Administration Workshop I (Course Content)

  • Outline the Oracle Architecture and its main Components 
  • Explain the Oracle instance architecture
Installing the Oracle Database Software
  • Identify common database administrative tools available to a DBA
  • Use optimal flexible architecture  
  • Install software with Oracle Universal Installer  
  • Identify and configure commonly used environment variables  
  • Use Installer Log
Creating an Oracle Database
  • Use DBCA to Create a database  
  • Use DBCA to Delete a database  
  • Use DBCA to manage templates 
 Managing the Oracle Instance
  • Use Enterprise Manager 
  • Use SQL*Plus and iSQL*Plus to access the Oracle Database  
  • Modify database initialization parameters  
  • Describe the stages of database startup  
  • Describe the database shutdown options  
  • View the database alert log  
  • Use dynamic performance views
Managing Database Storage Structures 
  • Describe how table row data is stored in blocks
  • Define the purpose of tablespaces and data files  
  • Explain space management in tablespaces  
  • Create tablespaces  
  • Manage tablespaces: alter, drop, take offline, put online, add data files, make read-only or read-write, generate DDL  
  • Obtain tablespace information  
  • Explain key features and benefits of ASM
 Administering User Security 
  • Create and manage database user accounts
  • Create and manage roles  
  • Grant and revoke privileges  
  • Create and manage profiles
Managing Schema Objects 
  • Create and modify tables 
  • Define constraints and states of constraints 
  • Dropping and truncating tables
  • Create and use B-Tree and Bitmap indexes
  • Create Views  
  • Create sequences  
  • Use data dictionary 
 Managing Data and Concurrency 
  • Manipulate data through the use of SQL 
  • Identify and administer PL/SQL objects  
  • Describe triggers and triggering events  
  • Define levels of locking  
  • List possible causes of lock conflict  
  • Monitor and resolve lock conflicts 
Managing Undo Data
  • Monitor and administer undo 
  • Configure undo retention  
  • Describe the relationship between undo and transactions  
  • Size the undo tablespace 
 Implementing Oracle Database Security 
  • Apply the principle of least privilege 
  • Audit database activity  
  • Implement Fine-Grained Auditing 
Configuring the Oracle Network Environment 
  • Use Database Control to Create additional listeners 
  • Use Database Control to Create Oracle Net service aliases  
  • Control Oracle Net Listeners  
  • Identify when to use shared servers versus dedicated servers
Proactive Maintenance 
  • Gather optimizer statistics
  • Manage the Automatic Workload Repository 
  • Use the Automatic Database Diagnostic Monitor (ADDM)  
  • Set warning and critical alert thresholds  
  • React to performance issues 
Performance Management 
  • Use enterprise manager to view performance
  • Tune SQL by using SQL tuning advisor 
  • Tune SQL by using SQL access advisor  
  • Use automatic shared memory management
  • Use the memory advisor to size memory buffer
Backup and Recovery Concepts 
  • Describe the types of failure that may occur in an Oracle Database 
  • Identify the importance of checkpoints, redo log files, and archived log files  
  • Tuning instance recovery  
  • Configure a database for recoverability  
  • Configure ARCHIVELOG mode 
Performing Database Backup
  • Create consistent database backups 
  • Back up your database without shutting it down 
  • Create incremental backups  
  • Automate database backups  
  • Backup a control file to trace  
  • Monitor flash recovery area
Performing Database Recovery
  • Recover from loss of a Control file  
  • Recover from loss of a Redo log file  
  • Recover from loss of a system-critical data file 
  • Recover from loss of a non system-critical data file 
Performing Flashback 
  • Describe flashback database
  • Resotore the table contents to a specific point in time
  • Recover from a dropped table
  • Use Flashback Query to view the contents of the database as of any single point of time
  • View transaction history or row with flashback transaction query
Moving Data 
  • Describe the general architecture of Data Pump
  • Use Data Pump export and import to move data between Oracle databases 
  • Load data with SQL Loader
  • Use external tables to move data

Oracle Database 10g: Administration Workshop II (Course Content)

Configuring Recovery Manager
  • Configure database parameters that affect RMAN operations
  • Change RMAN default settings with CONFIGURE 
  • Manage RMAN's persistent settings 
  • Start RMAN utility and allocate channels
Recovering from User Errors
  • Recover a dropped table using Flashback technology
  • Perform Flashback table operation 
  • Manage the recycle bin 
  • Recover from user errors using Flashback versions query 
  • Perform transaction level recovery using Flashback Transaction query
Dealing with Database Corruption
  • Define block corruption and list its causes and symptoms
  • Detect database corruptions using the following utilities: ANALYZE DBVERIFY  
  • Detect database corruptions using the dbms_repair package 
  • Implement the DB_BLOCK_CHECKING parameter to detect corruptions 
  • Repair corruptions using RMAN
Automatic Database Management
  • Use the Database Advisors to gather information about your database
  • Use the SQL Tuning Advisor to improve database performance 
  • Use automatic undo retention tuning
Using Recovery Manager
  • Use the RMAN BACKUP command to create backup sets and image copies
  • Enable block change tracking 
  • Manage the backups and image copies taken with RMAN with the LIST and REPORT commands
Recovering from Non-Critical Losses
  • Recover temporary tablespaces
  • Recover a redo log group member 
  • Recover index tablespaces 
  • Recover read-only tablespaces 
  • Recreate the password file
Monitoring and Managing Storage
  • Tune redo writing and archiving operations
  • Issue statements that can be suspended upon encountering space condition errors  
  • Reduce space-related error conditions by proactively managing tablespace usage 
  • Reclaim wasted space from tables and indexes using the segment shrink functionality  
  • Estimate the size of new table and indexes 
  • Use different storage options to improve the performance of queries 
  • Rebuild indexes online
Automatic Storage Management 
  • Set up initialization parameter files for ASM and database instances
  • Execute SQL commands with ASM file names 
  • Start up and shut down ASM instances 
  • Administer ASM disk groups 
  • Use RMAN to migrate your database to ASM
Monitoring and Managing Memory
  • Implement Automatic Shared Memory Management
  • Manually configure SGA parameters for various memory components in the SGA 
  • Use Automatic PGA Memory Management
Database Recovery
  • Recover the control file
  • Explain reasons for incomplete recovery 
  • Perform incomplete recovery using EM 
  • Perform incomplete recovery using RMAN 
  • Perform incomplete recovery using SQL 
  • Perform database recovery following a RESETLOGS operation
Flashback Database  
  • Determine which flashback technology to use for each recovery situation
  • Configure and use Flashback Database 
  • Monitor the Flashback Database 
  • Use the Enterprise Manager Recovery Wizard to flashback database 
  • Manage (or maintain) the Flash Recovery Area
Managing Resources 
  • Configure the Resource Manager
  • Assign users to Resource Manager groups 
  • Create resource plans within groups 
  • Specify directives for allocating resources to consumer groups
Automating Tasks with the Scheduler
  • Simplify management tasks by using the Scheduler
  • Create a job, program, schedule, and window 
  • Reuse Scheduler components for similar tasks 
  • View information about job executions and job instances
Below is an Example of an Oracle Database Release Number
Oracle Database Evolution
Oracle Database Evolution
To Read More about Oracle Evolution Click The Below Link.
The Oracle Database Evolution

© 2024 Unisoft Technologies - Nagpur | Developed By In House Team