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 was in the legal field for over 20 years (Secretary promoted to Paralegal). After being laid off from my last position, I decided I needed a change. I had used databases as a front end user during my legal field and was really interested in learning more. My passion for computers and database interest [...] Read more
Donna Zarzycki
Global Information Technology is a fantastic place where I was able to learn & grow my skills and further my professional development. Despite the circumstances of 2020 and the classes being virtual, I was able to learn so much as the instructors were accommodating with everyone’s learning styles. I am grateful to Michigan Works! for [...] Read more
Snigdha Suvarna
After suffering through unemployment for over a year with a bleak outlook for future employment opportunities in the Criminal Justice field that offered no upward mobility, I made the decision to return to school for some needed updated IT skills and current certifications. I selected Global Information Technology for my updated training. I started my [...] Read more
Randy Schales
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
In December 2008, I found myself parting ways with my employer of the last 22 years. I had become rather specialized in the Lotus Notes field and found that computer skill no longer in high demand and the entire IT job market rather depressed. Several months later, I became aware of Global Information Technology and [...] Read more
William Kolis
866-GO-GIT-GO