Pre-Requisites: Introduction to Oracle: SQL
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.
The Oracle Database 18c: Administration Workshop course provides you with a firm foundation in administration of an Oracle database. In this course, you will gain a conceptual understanding of Oracle Database architecture and learn how to manage an Oracle database in an effective and efficient manner
You learn how to create database storage structures appropriate for the business applications supported by your database. In addition, you learn how to create users and administer database security to meet your business requirements. This course provides basic information on backup and recovery techniques. To provide an acceptable response time to users and manage resources effectively, you learn how to monitor your database and manage performance.
This course provides a complete, hands-on introduction to Oracle Database Administration including the use of Enterprise Manager Database Express (EMDE), SQL Developer and SQL*Plus.
Manage an Oracle Database instance.
Configure the Oracle Network environment.
Create and manage storage structures.
Manage and move data.
Create and manage users.
Monitor the database and manage performance.
Create and manage Database Cloud Service database deployments.
Exploring the Oracle Database Architecture
Managing the Database Instance
Configuring the Oracle Network Environment
Managing Database Storage Structures
Administering User Security
Managing Data Concurrency
Managing Undo Data
Implementing Oracle Database Auditing
Performing Database Maintenance
Managing Performance
Managing Memory
Managing Resources by Using Database Resource Manager
Automating Tasks by Using Oracle Scheduler
Managing Space
Backup and Recovery Concepts
Moving Data
Working with Oracle Support
Real testimonials from our Students!
I worked 17 yrs in manufacturing as a Hilo driver, a material processor and 9 yrs as a Quality assurance technician and was let go due to the economy in February 2007. During that time I’d always had a passion for the computing arena so after weighing my options and overcoming the fear that can [...] Read more
Ralph Cook
7/10/2018 I enjoyed working for Global Information Technology on project as well as at the class. The management is very helpful and approachable when needed. I got very good opportunity to learn new tools and technologies and also to implement them. They provide very good support for their students in determining their areas of interest, [...] Read more
Megha Kashinkunti
At college graduation, I thought that a major part of my life was behind me. I would finally get the opportunity to live out life the way I was advised as a child: go to school, get a degree, get a safe and secure job. Unfortunately, I didn’t dare anticipate what was actually ahead of [...] Read more
Steve Johnson
I am writing this letter to inform you of my satisfaction with my son’s ( John Parkinson II) learning experience at Global Information Technology. He enrolled in your A+ , MCSE 2003 and CCNA programs in August 2007. The training provided by Global Information Technology became the foundation for his now growing IT career. After [...] Read more
John Parkinson II
I wish to express my thanks and gratitude for your expert teaching and support that have helped me transition into a career in information technology. When I began taking classes in August of 2009, I had been unemployed for over a year, and job prospects in the insurance industry were slim. Your staff took the [...] Read more
Marcus Thompson
866-GO-GIT-GO