Oracle Certified Associate 12c (OCA 12c)

- Kun 7 dage

Your accelerated OCA bootcamp course will teach you the knowledge needed to administer an Oracle Database 12c.

Using Firebrand's unique Lecture | Lab | Review technique, you'll combine theory with practical labs allowing you to get hands-on with the technology. You'll learn faster and leave with the practical skills to carry out day to day administration tasks in a real-world work environment, covering topics including:

  • SQL Fundamentals
  • Oracle Database Architecture
  • Data migration
  • Database backups and recovery

Re-engineered for the cloud

On Firebrand's OCA bootcamp, you'll master the Oracle Database 12c re-engineered for the cloud. Learning to utilise its multitenant architecture, new software efficiencies, manageability benefits and efficient cloud provisioning.

Læs mere...

You'll also sit exams 1Z0-071: Oracle Database 12c SQL and 1Z0-062: Oracle Database 12c Administration on-site during the course. This is covered by your Certification Guarantee.

97% of Global Fortune 500 companies use Oracle software. Become an Oracle Certified Associate and you’ll prove you can manage this critical technology.

Se Benefits...

Det tager kun et øjeblik at se hvor billigt dit kursus er...

Her er 4 gode grunde til at du skal tage OCA 12c hos Firebrand:

  1. Du bliver OCA 12c uddannet og certificeret hurtigere. Du lærer mere på vores 6 dages accelererede kursus og får mindst 12 timers daglig uddannelse i et distraktionsfrit miljø.
  2. Dit OCA 12c kursus er alt-inklusiv. Du får en gennemskuelig pris, der dækker alle kursusmaterialer, eksamen, overnatning og forplejning. Du skal ikke tænke på andet end at lære.
  3. Bestå OCA 12c den første gang eller kom tilbage, gratis. Din instruktør er ekspert, og træner dig ud fra accelererede metoder, så du lærer hurtigere og har de bedste muligheder for at bestå eksamen første gang. Men hvis du mod forventning ikke består, er du dækket af vores Certificeringsgaranti.
  4. Tag OCA 12c hos en prisvindende uddannelsesleverandør. Vi har vundet adskillige udmærkelser heriblandt Microsofts "Årets Learning Partner" hele fem gange og to Børsen Gazelle priser. Firebrand er din hurtigste vej til uddannelse, og vi har sparet 70,000 deltagere for mere end en million spildte timer siden 2001.

Det tager kun et øjeblik at se hvor billigt dit kursus er...

Oracle Database 12c SQL

Oracle and Structured Query Language (SQL)

  • 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

Restricting and Sorting Data

  • 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

Using Single-Row Functions to Customise Output

  • Use various types of functions available in SQL
  • Use character, number, and date and analytical (PERCENTILE_CONT, STDDEV, LAG, LEAD) 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 general functions and conditional expressions in a SELECT statement

Reporting Aggregated Data Using the 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

  • 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

Using Subqueries to Solve Queries

  • 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

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

  • Truncate data
  • 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

  • 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

Managing Objects with Data Dictionary Views

  • Query various data dictionary views

Controlling User Access

  • Differentiate system privileges from object privileges
  • Grant privileges on tables and on a user
  • Distinguish between privileges and roles

Managing Schema Objects

  • 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

Manipulating Large Data Sets

  • Describe the features of multitable INSERTs
  • Merge rows in a table

Oracle Database 12c Administration

Exploring the Oracle Database Architecture

  • List the architectural components of Oracle Database
  • Explain the memory structures
  • Describe the background processes

Oracle Database Management Tools

  • Use database management tools

Oracle Database Instance

  • Understand initialisation parameter files
  • Start up and shut down an Oracle database instance
  • View the alert log and access dynamic performance views

Configuring the Oracle Network Environment

  • Configure Oracle Net Services
  • Use tools for configuring and managing the Oracle network
  • Configure client-side network
  • Configure communication between databases

Administering User Security

  • Create and manage database user accounts
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles

Managing Database Storage Structures

  • Describe the storage of table row data in blocks
  • Create and manage tablespaces

Create and manage tablespaces

  • Explain how Oracle database server automatically manages space
  • Save space by using compression
  • Use the Segment Advisor
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality

Managing Undo Data

  • Explain DML and undo data generation
  • Monitor and administer undo data
  • Describe the difference between undo data and redo data
  • Configure undo retention

Managing Data Concurrency

  • Describe the locking mechanism and how Oracle manages data concurrency
  • Monitor and resolve locking conflicts

Implementing Oracle Database Auditing

  • Enable standard database auditing and unified auditing

Backup and Recovery Concepts

  • Identify the importance of checkpoints, redo log files, and archive log files

Backup and Recovery Configuration

  • Configure the fast 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

Performing Database Recovery

  • 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

Moving Data

  • 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

Performing Database Maintenance

  • Use server-generated alerts

Managing Performance: SQL Tuning

  • Use the SQL Tuning advisor

Automating Tasks by Using Oracle Scheduler

  • 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 prioritise jobs

Creating an Oracle Database Using DBCA

  • Generate database creation scripts by using DBCA
  • Manage database design templates by using DBCA

Upgrading Oracle Database Software  

  • Describe data migration methods
  • Describe the upgrade process

Introduction to DBAAS

  • Recognise the difference between a DBaaS Instance and a Database Instance
  • Navigate with My Services Dashboard
  • User authentication and roles
  • Generate a Secure Shell (SSH) Public/Private Key Pair

Se Exam Track...

You'll sit the following exams at the Firebrand Training Centre, covered by your Certification Guarantee:

1Z0-071: Oracle Database 12c SQL

  • Duration: 100 minutes
  • Questions: 73
  • Passing Score: 63%
  • Format: Multiple Choice

1Z0-072: Oracle Database 12c Administration

  • Duration: 90 minutes
  • Questions: 70
  • Passing Score: 60%
  • Format: Multiple Choice

Se What's Included...

Included on the course:

  • Firebrand course materials

Det hele er inkluderet! Du får en alt-inklusiv kursuspakke, som er målrettet til dine behov. Vi tager os af enhver detalje, så det eneste du skal fokusere på er dine lærings- og certificeringsmål.

  • Transport til/fra specifikke afhentningssteder
  • Overnatninger, samtlige måltider samt adgang til forfriskninger, snacks, kaffe og the.
  • Intensiv Hands-on uddannelse med vores unikke (Lecture | Lab | Review)TM metode
  • Omfattende kursusmaterialer og labmanualer
  • Et helt igennem instruktørstyret program
  • 24 timers adgang til både undervisningslokale og instruktøren
  • Samtlige måltider samt adgang til forfriskninger, snacks, kaffe og the.
  • Certificeringsgaranti

Se Prerequisites...

It is recommended that you should have at least 9 months of practical experience of working in a database administration role. This includes a good working knowledge of Oracle SQL and be familiar with Oracle PL/SQL supplied packages.

Additionally, you should have a basic understanding - and preferably some practical experience - of using the following technologies:

  • Oracle Database architecture and OFA
  • SQL statements that query the Oracle Data Dictionary views
  • Oracle Net configuration
  • Database security
  • Diagnostics and troubleshooting
  • Database performance tuning
  • Database space management
  • Datapump and sqlldr
  • Oracle Resource Manager
  • Oracle Scheduler
  • Database maintenance
  • Database backup and in particular RMAN

Er du klar til dit Firebrand Kursus?

Vi interviewer alle potentielle deltagere angående deres baggrund, uddannelser, certificeringer og personlig indstilling. Hvis du kommer igennem denne screeningsprocedure, betyder det, at du har rigtig gode chancer for at bestå.

Firebrand Training tilbyder et ambitiøst uddannelsesmiljø, som forudsætter at du dedikerer dig til kurset. Ovenstående forkundskaber er vejledende; mange deltagere med mindre erfaring, men med en anden baggrund eller færdigheder, har haft succes med accelereret uddannelse hos Firebrand Training.

Hvis du funderer på hvorvidt du opfylder de anbefalede forkundskaber, er du meget velkommen til at ringe til os på 78 79 16 53 og tale med en af vores uddannelsesrådgivere, som kan hjælpe dig.

Se Hvornår...

Oracle OCA 12c Kursusdatoer

Oracle - Certified Associate 12c (OCA 12c)

Starter

Slutter

Tilgængelighed

Tilmelding

18/11/2019 (Mandag)

24/11/2019 (Søndag)

Afsluttet

 

16/3/2020 (Mandag)

22/3/2020 (Søndag)

Tilgængelige pladser

Tilmelding

Vi har uddannet over 72.589 personer i løbet af 12 år. Vi har bedt dem alle om at bedømme vores accelererede kurser. Aktuelt har 96,77% sagt, at Firebrand oversteg deres forventninger:

""
Anonym (18/11/2019 til 20/11/2019)

"Really enjoyed the experience and learned a lot of new skills. So thank you Firebrand."
M.A.. (18/11/2019 til 20/11/2019)

"Good food, good training, could improve by using less disposable cups and offer mugs instead."
Liam Coleman, IBM. (4/11/2019 til 6/11/2019)

"I found the course interesting and the content was delivered well."
R.B.. (4/11/2019 til 6/11/2019)

"Enjoyed my time at Firebrand. The training facilities are good. Plenty of free refreshments and close to your room for relation. Nice surroundings. Clean hotel."
Anonymous. (8/7/2019 til 10/7/2019)

Seneste OCA 12c anmeldelser fra vores studerende

Er du klar til kurset? Tag en GRATIS test som hjælper dig med at bedømme din nuværende viden.