In this course, you will learn about security and maintenance concerns in an Oracle database with an introductory focus on Oracle SQL and PL/SQL for newer IT employees.
Oracle 12c Security Administration
5 Day | Instructor Led
Ideal Candidates for Oracle 12c Security Administration Class
Database administratorsSupport engineersTechnical consultantsSystems administratorsNetwork managersTechnical support personnel
Oracle 12c Security Administration Prerequisites
There Are No PreRequisites Defined for this Course
What You'll Get in Oracle 12c Security Administration
What You'll Learn in Oracle 12c Security Administration
Create and administer user accounts in the Oracle 11g databaseBackup and recover the databaseMonitor, troubleshoot, and maintain the databaseNo Certification Test Available For This Course
No Certification Test Available For This Course
Oracle 12c Security Administration Outline
1. SQL and PL/SQL
- Basic SQL Syntax
- SQL Functions
- Advanced SQL Queries
- PL/SQL Program Structure
- Accessing the Database
2. Create an Oracle Database
- Describe Oracle Database Architecture
- Understand the Instance Architecture
- Use the Management Framework and the Database Creation Assistant
3. Controlling the Database
- Start and Stop the Agent and the Listener
- Startup and Shutdown the Database
4. Administering Users
- Create and Manage Database User Accounts, and Manage Roles
- Grant and Revoke Privileges
- Control Resource Usage by Users
5. Managing Schema Objects
- Create and Modify Tables, Indexes, and Views
- Define Constraints
- View the Attributes and the Contents of a Table
6. Oracle Database Security
- Apply the Principal of Least Privilege
- Manage Default User Accounts
- Implement Standard Password Security Features
- Audit database activity
7. Proactive Maintenance: Objectives
- Set Warning and Critical Alert Thresholds
- Collect and Use Baseline Metrics
- Use Tuning/Diagnostic Advisors/ADDM/ADR
8. Recovery Manager Configuration
- Parameters Affecting RMAN
- Use of a Flashback Recovery Area
- The CONFIGURE Command
- Persistent Settings
- NOCATALOG / CATALOG Mode
- Channel Allocation
- Controlfile Autobackup
- Retention Policies
9. Recovery Manager Operations
- Using the BACKUP Command
- Creating Backup Sets / Image Copies
- Compressed Backups
- Incremental Backups
- Block Change Tracking
- RMAN Backup Monitoring
- REPORT and LIST Commands
10. Non-Critical Loss Recovery
- Password and Network Files
- Read-Only Tablespaces
- Temporary Tablespaces
- Index Tablespaces
- Redo Log Members / Control Files
11. Database Recovery
- Complete Recovery
- Incomplete Recovery
12. Flashback Database
- When in Use
- Configuration and Use
- Monitoring Flashback Database
- Flash Recovery Area Maintenance
- Flash Recovery Area Monitoring
13. User Error Recovery
- The New Recycle Bin
- Querying Dropped Tables
- Flashback Versions Table
- Flashback Transaction Query
14. Automatic Database Management
- Management and Advisory Framework
- Automatic Statistics Collection
- The Automated Workload Repository
- Database Advisors
- Automatic Statistics Collection
15. Virtual Private Database
- Row Level Control
- Column Level Control
16. Oracle Auditing
- Full Security Monitoring
Testimonials
This course is definitely an eye opener. With how much social media has taken over, it is important to be fully aware of the capabilities along with all the risks it brings. It is important to get this course because social media is the new norm.
The Social Media and Security Training course offered by UKI is a great and beneficial course combining technical training to fully understand TCP IP networking, DNS, and the harms of malware and cross-site scripting; as well as practical training that allowed attendees to play with open source social intelligence gathering solutions. This is the perfect class for those involved in IT security and interested in social media and identity theft.
Top Related Courses
In this course, you will acquire the skills needed to customize and administer the implementation and support of Avaya Aura Messaging (AAM). The course provides you with the opportunity to practice configuring Avaya Aura Messaging.
In this course, you will acquire the skills needed to customize and administer the implementation and support of Avaya Aura Messaging (AAM). The course provides you with the opportunity to practice configuring Avaya Aura Messaging.
This course combines the Avaya Aura Communication Manager Administration and the Avaya Aura Call Center Elite Implementation and Configuration courses. It is offered as a condensed, five-day fast track version of those two courses.
This course combines the Avaya Aura Communication Manager Administration and the Avaya Aura Call Center Elite Implementation and Configuration courses. It is offered as a condensed, five-day fast track version of those two courses.
In this course, you will learn how to install, configure, and manage Exchange Server 2016, as well how to manage mail recipients and public folders, including how to perform bulk operations using Exchange Management Shell. You will also learn how to manage client connectivity, message transport and hygiene, implement and manage highly available Exchange Server deployments, as well as implement back up and disaster recovery solutions. The course also teaches students how to maintain and monitor an Exchange Server 2016 deployment. In addition, students will learn how to administer Exchange Online in an Office 365 deployment.
In this course, you will learn how to install, configure, and manage Exchange Server 2016, as well how to manage mail recipients and public folders, including how to perform bulk operations using Exchange Management Shell. You will also learn how to manage client connectivity, message transport and hygiene, implement and manage highly available Exchange Server deployments, as well as implement back up and disaster recovery solutions. The course also teaches students how to maintain and monitor an Exchange Server 2016 deployment. In addition, students will learn how to administer Exchange Online in an Office 365 deployment.
Vendor Details
Oracle
In our Oracle 10g, Oracle 11g and Oracle 12c training courses, you'll gain the hands-on experience you need to improve productivity and efficiency in your organization. With our comprehensive curriculum, including Desktop Discoverer, PL/SQL, Solaris, Clusterware and Java, we can meet your Oracle training needs from start to finish.
A. Erlich
RITSC, N6CI just wanted to say your presentation on Social Media Technology and Security was the finest I have ever attended.