course-premium

Course not currently available

Oracle Database 12c OCA + OCP Certification Course

Training Square
4.0
1 review
  • I was given the best possible service, I couldn't have hoped for a better quality of training. I'll never forget the care and kindness shown to me in what was one of my darkest hours, thanks to Training square my future is starting to look a little brighter.
    ← | →

Training

In City Of London ()

£ 1,000 + VAT

The best Oracle courses

See all

See all

Be ready to pursue a career in the Oracle DBA track!

  • Type

    Training

  • Duration

    6 Weeks

Immerse yourself in Oracle Database with this Oracle Database 12c OCA + OCP Certification Course, offered by Training Square, that Emagister.co.uk has added to its educational catalogue.

Oracle Database 12c provides high capabilities solution to small to larger organizations offering most comprehensive set of capabilities such as Real Application Clusters(RAC), Data Guard, Flashback, Recovery Manager(RMAN), Secure backup and Automatic Storage Management(ASM) which makes it most demanding database platform leader in the industry.

Database is the most critical assets of a business and it needs reliable and robust data platform and has to be secured. If platform is not reliable and robust then businesses may lose millions of pounds as a result of downtime, in this perspective Oracle plays a greater role in the IT industry and it has taken major share in the market which has created resulted in creating jobs opportunities in the database arena.

Learning Oracle 12c Database management and achieving the OCA and OCP certification is a goal to everyone who is pursuing their career in the Oracle DBA track.

So, if you want more information about this programme contact Training Square through Emagister.co.uk without hesitation. You won’t regret it!

About this course

Hands-on Training, Lab Exercises, Project work, Unlimited Lab Access, Free Re-training. Learning Oracle 12c Database management and achieving the OCP certification is a goal to everyone who is pursuing their career in the Oracle DBA track. Training Square is an authorized Oracle Partner and we deliver a class-room based tutor led hands-on training in a very professional environment by certified experienced Oracle Trainers to enable you achieve your set goals at the completion of the course.

If you are looking for job after the course we can certainly send your CV to prospective employers and the recruitment consultants or even assist you to analyse and update your CV to make it look professional.

Novice/Mediocre/Expert.

Computer Illiterate.

Diploma/Corporate Training/Hands-On Practical Training/Exam Preparation.

Expert, Industry Experienced and Certified Trainers.
State of the Art Facilities.

Maximum 5-6 Delegates Per Class. Quality that matters.
100% Practical Hands-on Training, Classroom Based and
Instructor Led.

Flexible Starting Dates: Weekdays, Weekends and Evenings
Location: Central London.

Our Course Advicer will contact him/her and explain further about the Course.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.0
  • I was given the best possible service, I couldn't have hoped for a better quality of training. I'll never forget the care and kindness shown to me in what was one of my darkest hours, thanks to Training square my future is starting to look a little brighter.
    ← | →
100%
4.5
excellent

Course rating

Recommended

Centre rating

Ton Smith

4.0
20/04/2019
About the course: I was given the best possible service, I couldn't have hoped for a better quality of training. I'll never forget the care and kindness shown to me in what was one of my darkest hours, thanks to Training square my future is starting to look a little brighter.
Would you recommend this course?: Yes
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2019

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 10 years

Subjects

  • Database training
  • Professional environment
  • Oracle Database
  • Cloud storage
  • Recovery Manager
  • Secure backup
  • IT industry
  • Ocp certification
  • Data platform
  • Large organizations
  • Database
  • SQL
  • Industry

Course programme

  • Execute SELECT statements
  • Restricting and Sorting Data with clauses
  • Limit the rows using Select Statement
  • Sort the rows retrieved by a query
  • Use ampersand substitution to restrict and sort output at runtime
  • Using Single-Row Functions to Customize Output
  • Types of functions available in SQL
  • Use character, number, and date functions in SELECT statements
  • Using Conversion Functions and Conditional Expressions
  • 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
  • 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
  • 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
  • Subqueries with SQL Statement
  • Types of subqueries
  • Single-row and multiple-row subqueries
  • Set Operators
  • Set operators
  • Set operator to combine multiple queries into a single query
  • Control the order of rows returned
  • Manipulating Data
  • Data manipulation language (DML) statement
  • Insert rows, Update rows, Delete rows into a table
  • Control transactions
  • Using DDL Statements to Create and Manage Tables
  • Categorize database objects
  • 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
  • Schema objects
  • 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
  • OCP Exam: 1Z0-052 - Oracle Database 11g: Administration I
  • Oracle Database Architecture
  • Oracle 11g Database Memory Structures
  • Oracle Database Process Structures
  • Overview of Storage Structures
  • Oracle Database Environment
  • Tools for Administering an Oracle Database
  • Oracle Database installation
  • Install the Oracle software by using Oracle Universal Installer (OUI)
  • Creating an Oracle Database
  • Create a database by using the Database Configuration Assistant (DBCA)
  • Managing the Oracle Instance
  • Setting database initialization parameters
  • Stages of database startup and shutdown
  • Alert log and trace files
  • Using data dictionary and dynamic performance views
  • Configuring the Oracle Network Environment
  • Configure and Manage the Oracle Network
  • Oracle Shared Server architecture
  • Managing Database Storage Structures
  • Tablespace and datafiles
  • Create and manage tablespaces
  • Space management in tablespaces
  • Administering User Security
  • Create and manage database user accounts
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles
  • Managing Data and Concurrency
  • Monitor and resolve locking conflicts
  • Managing Undo Data
  • Overview of Undo Data and Transaction
  • Transactions and undo data
  • Managing undo
  • Implementing Oracle Database Security
  • Database Security and Principle of Least Privilege
  • Work with Standard Database Auditing
  • Database Maintenance
  • Use and manage optimizer statistics
  • Automatic Workload Repository (AWR)
  • Use advisory framework
  • Manage Alerts and Thresholds
  • Performance Management
  • Automatic Memory Management
  • Use Memory Advisors
  • Troubleshoot invalid and unusable objects
  • Intelligent Infrastructure Enhancements
  • Enterprise Manager Support Workbench
  • Managing Patches
  • Backup and Recovery Concepts
  • Failure that can occur in an Oracle database
  • Tune instance recovery
  • Checkpoints, redo log files, and archived log files
  • Flash recovery area
  • Configure ARCHIVELOG mode
  • Performing Database Backups
  • Create consistent database backups
  • Back up your database without shutting it down
  • Create incremental backups
  • Automate database backups
  • Manage backups, view backup reports and monitor the flash recovery area
  • Performing Database Recovery
  • Data Recovery Advisor
  • Use Data Recovery Advisor to Perform recovery (Control file, Redo log file and Data file)
  • Moving Data
  • Move data (Directory objects, SQL*Loader, External Tables)
  • General architecture of Oracle Data Pump
  • Use Data Pump Export and Import to move data between Oracle databases

Additional information

There are two different options to take this course

 6 Weeks or Fast Track 5 Days

See related categories

Oracle Database 12c OCA + OCP Certification Course

£ 1,000 + VAT

The best Oracle courses

See all

See all