Oracle PL/SQL OCP-Admin

Oracle SQL Developer Course

78%

Alumni Career Transitions

5200+

Hiring Partners

60%

Avg Salary Hike

22

Years of R & D in Syllabus

Oracle Database Admin Courses

Oracle database is the number one database in the world. More than 90% of companies use Oracle software. It is very crucial to get a trained person to manage the Oracle database. Therefore, Oracle provides a certification program to widen the knowledge in managing this software. Oracle certification also validates the skills which use real-world scenarios and assess the ability to think and perform.

Oracle Certified Associate (OCA) includes the basic concepts and DBA skills required for daily performance. SMEClabs helps you to build a strong base in the field of Oracle database management and development. The classes are given by our industry experts who have proven work experience in the field

  • Identify the connection between an ERD and a Relational Database
  • Explain the relationship between a database and SQL
  • Describe the purpose of DDL 
  • Describe the purpose of DML 
  • Build a SELECT statement to retrieve data from an Oracle Database table
  •  
  • Use the ORDER BY clause to sort SQL query results
  • Limit the rows that are retrieved by a query
  • Use ampersand substitution to restrict and sort output at runtime
  • Use SQL row limiting clause
  • Use various types of functions available in SQL
  • Use character, number, and date and analytical (PERCENTILE_CONT, STDDEV, LAG, LEAD) functions in SELECT statements
  • Describe various types of conversion functions that are available in SQL
  • Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
  • Apply general functions and conditional expressions in a SELECT statement
  • Describe the use of group functions
  • Group data by using the GROUP BY clause
  • Include or exclude grouped rows by using the HAVING clause
  • Describe the different types of joins and their features
  • Use 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
  • Define subqueries
  • Describe the types of problems subqueries can solve
  • Describe the types of subqueries
  • Query data using correlated subqueries
  • Update and delete rows using correlated subqueries
  • Use the EXISTS and NOT EXISTS operators
  • Use the WITH clause
  • Use single-row and multiple-row subqueries
  • Describe set operators
  • Use a set operator to combine multiple queries into a single query
  • Control the order of rows returned
  • Truncate data
  • Insert rows into a table
  • Update rows in a table
  • Delete rows from a table
  • Control transactions
  • Describe data types that are available for columns
  • Create a simple table
  • Create constraints for tables
  • Drop columns and set column UNUSED
  • Create and use external tables
  • Query various data dictionary views
  • Differentiate system privileges from object privileges
  • Grant privileges on tables and on a user
  • Distinguish between privileges and roles
  • Describe how schema objects work
  • Create simple and complex views with visible/invisible columns
  • Create, maintain and use sequences
  • Create and maintain indexes including invisible indexes and multiple indexes on the same columns
  • Perform flashback operations
  • Describe the features of multitable INSERTs
  • Merge rows in a table

 

Oracle Database 12C SQL: Installation and Administration

  • List the architectural components of Oracle Database
  • Explain the memory structures
  • Describe the background processes
  • Explain the relationship between logical and physical storage structures
  • Plan for an Oracle Database software installation
  • Install the Oracle Database software
  • Create a database by using the Database Configuration Assistant (DBCA)
  • Generate database creation scripts by using DBCA
  • Manage database design templates by using DBCA
  • Configure database options by using DBCA
  • Use database management tools
  • Understand initialization parameter files
  • Start up and shut down an Oracle database instance
  • View the alert log and access dynamic performance views
  • Configure Oracle Net Services
  • Use tools for configuring and managing the Oracle network
  • Configure client-side network
  • Configure communication between databases
  • Describe the storage of table row data in blocks
  • Create and manage tablespaces
  • Create and manage database user accounts
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles
  • Explain how Oracle database server automatically manages space
  • Save space by using compression
  • Proactively monitor and manage tablespace space usage
  • Use the Segment Advisor
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality
  • Manage resumable space allocation
  • Explain DML and undo data generation
  • Monitor and administer undo data
  • Describe the difference between undo data and redo data
  • Configure undo retention
  • Describe the locking mechanism and how Oracle manages data concurrency
  • Monitor and resolve locking conflicts
  • Explain DBA responsibilities for security and auditing
  • Enable standard database auditing and unified auditing
  • Identify the importance of checkpoints, redo log files, and archive log files
  • Configure the fast recovery area
  • Configure ARCHIVELOG mode
  • Create consistent database backups
  • Back up your database without shutting it down
  • Create incremental backups
  • Automate database backups
  • Manage backups
  • Determine the need for performing recovery
  • Use Recovery Manager (RMAN) and the Data Recovery Advisor to perform recovery of the control file, redo log file and data file
  • Describe ways to move data
  • Use SQL*Loader to load data from a non-Oracle database
  • Use external tables to move data via platform-independent files
  • Explain the general architecture of Oracle Data Pump
  • Use Data Pump Export and Import to move data between Oracle databases
  • Manage the Automatic Workload Repository (AWR)
  • Use the Automatic Database Diagnostic Monitor (ADDM)
  • Describe and use the advisory framework
  • Set alert thresholds
  • User server-generated alerts
  • Use automated tasks
  • Use Automatic Memory Management
  • Use the Memory Advisor to size memory buffers
  • Manage optimizer statistics
  • Use the SQL Tuning advisor
  • Use the SQL Access Advisor to tune a workload
  • Configure the Database Resource Manager
  • Access and create resource plans
  • Monitor the Resource Manager
  • Use Oracle Scheduler to simplify management tasks
  • Use job chains to perform a series of related tasks
  • Use Scheduler jobs on remote systems
  • Use advanced Scheduler features to prioritize jobs

Oracle Database 12C: Advanced Administration

  • Describe types of database failures
  • Describe the tools available for backup and recovery tasks
  • Describe RMAN and maximum availability architecture
  • Use RMAN stand-alone and job commands
  • Back up and recover a NOARCHIVELOG database
    • Perform backup and recovery in NOARCHIVELOG mode
    • Use SQL in RMAN
  • Configure and manage RMAN settings
    • Configure persistent settings for RMAN
    • View persistent settings
    • Specify a retention policy
  • Configure the Fast Recovery Area
    • Explain the Fast Recovery Area
    • Configure the Fast Recovery Area
  • Configure control files and redo log files for recoverability
    • Multiplex control files
    • Multiplex redo log files
  • Create and use an RMAN recovery catalog
    • Configure a recovery catalog
    • Register target databases in a recovery catalog
    • Catalog additional backup files
    • Resynchronize a recovery catalog
    • Use and maintain RMAN stored scripts
    • Upgrade and drop a recovery catalog
  • Protect the RMAN recovery catalog
    • Back up the recovery catalog
    • Re-create an unrecoverable recovery catalog
    • Export and import the recovery catalog
  • Use various RMAN backup types and strategies
    • Enable ARCHIVELOG mode
    • Create tape and disk based backups
    • Create whole database backups
    • Create consistent and inconsistent backups
    • Create backup sets and image copies
    • Create backups of read-only tablespaces
    • Employ best practices for data warehouse backups
  • Perform full and incremental backups
    • Create full and incremental backups
    • Use the Oracle-suggested backup strategy
  • Manage backups
    • Configure and monitor block change tracking
    • Report on backups using LIST, REPORT commands
    • Manage backups using CROSSCHECK, DELETE commands
  • Use techniques to improve backups
    • Create compressed backups
    • Create multi-section backups of very large files
    • Create proxy copies
    • Create duplexed backup sets
    • Create backups of backup sets
  • Perform backup of non-database files
    • Back up a control file to trace
    • Back up archived redo log files
  • Describe the Automatic Diagnostic Repository
  • Use the Data Recovery Advisor
  • Handle block corruption
  • Describe and tune instance recovery
  • Perform complete and incomplete recovery
    • Use RMAN RESTORE and RECOVER commands
    • Restore ASM disk groups
    • Recover from media failures
    • Perform complete and incomplete or “point-in-time” recoveries using RMAN
  • Perform recovery for spfile, control file, redo log files
  • Perform table recovery from backups
  • Perform recovery of index and read-only tablespaces, temp file
  • Restore a database to a new host

 

  • Configure and use Oracle Secure Backup
  • Describe the Flashback technologies
    • Configure a database to use Flashback technologies
    • Guarantee undo retention
  • Use Flashback to query data
    • Use Flashback Query
    • Use Flashback Version Query
    • Use Flashback Transaction Query
    • Flash back a transaction
  • Perform Flashback Table operations
    • Perform Flashback Table
    • Restore tables from the recycle bin
  • Describe and use Flashback Data Archive
    • Use Flashback Data Archive
    • Use DBMS_FLASHBACK_ARCHIVE package
  • Perform Flashback Database
    • Configure Flashback Database
    • Perform Flashback Database

 

Transporting Data

  • Describe and use transportable tablespaces and databases
    • Transport tablespaces between databases using image copies or backup sets
    • Transport databases using data files or backup sets
    • Transport data across platforms

Monitoring and Tuning of RMAN Operations

  • Tune RMAN performance
    • Interpret RMAN error stacks
    • Diagnose performance bottlenecks
    • Tune RMAN backup performance
  • Describe the multitenant container database architecture
  • Configure and create a CDB
  • Create a PDB using different methods
  • Unplug and drop a PDB

 

** The above is the lite syllabus and doesn’t cover the full syllabus. To get full syllabus  Book a Free Demo Now

WhatsApp
Facebook
Telegram
Email
smeclabs 1 - Oracle PL/SQL OCP-Admin

Certifications & Accreditations

NSDC 2 - Oracle PL/SQL OCP-Admin
iisc 1 - Oracle PL/SQL OCP-Admin
IASC 1 - Oracle PL/SQL OCP-Admin
TUV 1 - Oracle PL/SQL OCP-Admin
ESSI - Oracle PL/SQL OCP-Admin
CGSC - Oracle PL/SQL OCP-Admin

Benefits of learning from us

Program Fees

Live Instructor Led Training Fee

 112,500.00

5% off Coupon Code:  UPGRADE

Mode of Training

OnDemand

Live Instructor Led

Virtual Lab

Classroom

Comprehensive Curriculum

135+ hours

Learning Content + Practicals

Regular Batch

Date

04-Jul-2022

Time

10:30 AM IST

Fast Track Batch

Date

06-Jul-2022

Time

10:30 AM IST

Extra 5% off on Courses

Coupon Code: UPGRADE

FAQ For Quantity Surveying Courses

As a fresher you need to develop different skills. SMEClabs helps you to develop the required skill set and will make you eligible for the job.

Yes, SMEClabs provides placement you can visit this website Placementshala to get more details regarding the placements.

To learn you don’t need any prior experience in coding. This is similar to SQL server and other databases. It operates by using SQL with PL/SQL extensions. It is easy to learn if you have a basic knowledge in SQL and Linux.

There is a high priority in the job market. As per the current strategies, DBA OCA is increased by 11% which is higher than the other available jobs.

A basic knowledge in programming languages like C#Java is a plus point. Most of the time, the job doesn’t require coding.

Several tasks includes installing Oracle software, creating Oracle Databases toi new release, starting up and shutting down the Oracle database.

SMEC, one of India’s first worldwide EPC contractor company globally recognized for its distinctive services specifically in Marine & Industrial Automation, Instrumentation, Electrical, Pneumatics, Hydraulics and Mechanical sectors which started its journey in 2001. It has a R&D and training division SMEClabs which caters job-oriented training in various domains which helps an aspiring engineer /fresher or professionals to get a jump start to their career.

Oracle Database Admin Courses | #1 SMEClabs
oracle 1 - Oracle PL/SQL OCP-Admin

Learn Oracle Database Admin Courses online or offline. Start today and improve your skills. Sale of the Season. Stock Up On Learning

Course Provider: Organization

Course Provider Name: SMEClabs

Course Provider URL: https://courses.smeclabs.com/database-management/oracle-pl-sql-ocp-admin/

Editor's Rating:
5

Download Now