This course offers you an introduction to Oracle Database 12c database technology. You will learn the concepts of relational databases and the powerful SQL programming language. Discover essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables and create database objects.
Benefits to You:
Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.
Use Single Row Functions:
This Oracle Database course will also teach you how to use single row functions to customize output. Explore using conversion functions and conditional expressions, along with use group functions to report aggregated data.
Reinforce Your Knowledge through Hands-On Exercises:
Demonstrations and hands-on practice reinforce the fundamental concepts you'll delve into in this course. You will discover and use Oracle SQL Developer as the main environment tool for writing SQL. SQL*Plus is also introduced as an optional tool
This course is designed for professionals whose work involves the administration of an Oracle 12c database, as well as anyone involved in working with databases who may be tasked with administering Oracle databases. Experience equivalent to Course 2226, "Oracle Database 12c Introduction," is assumed.
At the end of this course you will be able to:
Those delegates who are attending via either virtual or extended classroom will be required to provide either dual monitors or single monitor plus a tablet device.
Exploring Oracle Database Architecture
Managing Database Instances
Configuring the Oracle Network Environment
Administering User Security
Creating and Managing Tablespaces
Managing Storage Space
Managing UNDO Data
Backup and Recovery Concepts
Monitoring and Tuning Database Performance
Oracle Database Resource Manager
Enterprise Manager Cloud Control
Introduction to Oracle Database Cloud Service
Creating DBCS Database Deployments
Managing DBCS Database Deployments
Backing Up and Restoring DBCS Database Deployments
Patching DBCS Database Deployments
Creating Master Encryption Keys for PDBs
Tablespace Encryption by Default
If you need training for 3 or more people, you should ask us about onsite training. Putting aside the obvious location benefit, content can be customised to better meet your business objectives and more can be covered than in a public classroom. It's a cost effective option.
Submit an enquiry from any page on this site, and let us know you are interested in the requirements box, or simply mention it when we contact you.