Overview
Course Description
Thank you for reading this post, don't forget to subscribe!In this course, you will learn how applications interface with the Oracle database and how to help troubleshoot problems arising in the installation and operation of applications. You will learn about the Oracle database architecture and how its components work and interact with one another. You will also learn how to properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management, and backup/recovery techniques. Hands-on exercises reinforce the material covered.
Audience Profile
- Database administrators
- Support engineers
- Technical consultants
- Systems administrators
- Network managers
- Technical support personnel
Prerequisites
- Knowledge of SQL
- Oracle 12c SQL & SQLPLUS Express Introduction
- Oracle 12c PL/SQL Introduction
Learning Objectives
- Install and configure the Oracle 12c database
- Create and administer user accounts in the Oracle 12c database
- Backup and recover the database
- Monitor, troubleshoot, and maintain the database
- Configure Oracle Net services
Course Outline
Course Outline
Module 1: Introduction
Lessons
• Describe the basic concepts of a relational database
• Discuss core database administrator tasks
Lab: Architecture / Advanced Memory Management
Module 2: Architecture
Lessons
• Describe Oracle database architecture
• Understand the instance architecture
• Use the management framework, and the database creation assistant
Lab: Starting and Stopping the Database
Module 3: Controlling the database
Lessons
• Start and stop the agent, the enterprise manager database console, and the listener
• Startup and shutdown the database
Lab: Managing Tablespaces / Datafiles
Module 4: Storage Structures
Lessons
• Define the purpose of tablespaces and data files
• Create and manage tablespaces
• Obtain tablespace information
Lab: Oracle Database Files
Module 5: Administering users
Lessons
• Create and manage database user accounts, and manage roles
• Grant and revoke privileges
• Control resource usage by users
Lab: Users and Security
Module 6: Oracle Database Security
Lessons
• Apply the principal of least privilege
• Manage default user accounts
• Implement standard password security features, and Audit database activity
Lab: Oracle Networking
Module 7: Oracle Net Services
Lessons
• Understand Oracle Net concepts
• Use Oracle Net Manager to create and configure listeners, and configure client and middle-tier connection
• Use the listener control utility to control the Oracle Net Listener
• Use TNSPING to test Oracle Net connectivity
Lab: Configuring the Database for Backup
Module 8: Performance Monitoring
Lessons
• Troubleshoot invalid / unusable objects
• Gather optimizer statistics
• View performance metrics
• Reacting to performance issues
Lab: Basic Database Media Recovery
Module 9: Diagnostic Sources
Lessons
• Alert Logs and Trace Files
• Enterprise Manager and Alerts
• Controlling trace file size
• Alert notification
Lab: Archivelog Setup
Module 10: Backup and Recovery Concepts
Lessons
• Describe the basics of database backup, restore and recovery
• List the types of failure that may occur in an Oracle Database, and Describe ways to tune instance recovery
• Identify the importance of checkpoints, redo log files, and archived log file
• Configure ARCHIVELOG mode
• Flashback Database / Table / Query
Lab: Automation Tools
Module 11: Database backups
Lessons
• Create consistent database backups, incremental backups, and Automate database backups
• Monitor the flash recovery area
• Back your database up without shutting it down
Lab: Performance Tuning Tools
Module 12: Database Recovery
Lessons
• Recover from loss of a control file, a redo log file, or a data file
• A Day in the Life of a DBA
• Periodic and As Needed Tasks
Lab: Oracle Job Scheduling
Module 13: Scheduler
Lessons
• Creating jobs and job classes
• Creating schedules and windows
• Scheduler programs
• Prioritizing jobs
• Scheduler component reuse
• Query Scheduler information
Module 14: SQL Tuning Tools
Lessons
• Optimizer Overview
• Execution Plans
• Rule-Based Optimization (Desupported)
• Cost-Based Optimization
• Table And Index Statistics
• DBMS_STATS
• Execution Plans
• Autotrace
• SQL_TRACE And TKPROF
• Using Hints
• Stored Outlines And Plan Stability
Module 15: Performance Tuning
Lessons
• Application Identification
• Enterprise Manager Tools
• SQL Tuning Advisor
• SQL Access Advisor
• DBMS_SQLTUNE
• DBMS_ADVISIOR
• Quick Tune