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
June 2, 2020. Before Global Information Technology I found myself in a “great job market” with no callbacks on the dozens of applications I submitted to companies all over metro Detroit. I was in a particular bind because I had work experience AND a graduate degree, but all of the offers I received were well [...] Read more
Stephanie Holley
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 want to thank Global Information Technology for assisting with my job search and training needs. With the help of Michigan Works I was able to attend the Network Engineering Professional training class, consisting of CompTIA A+ and Network+, Microsoft desktop and server operating systems, Linux and Cisco CCNA. I am very impressed with all my teachers, [...] Read more
Weston Tatem
866-GO-GIT-GO