Oracle 11g DBA Training in Helena
We offer private customized training for groups of 3 or more attendees.
|
||
Course Description |
||
This class will develop the key fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management and tuning by the end of this class.
Course Length: 5 Days
Course Tuition: $2090 (US) |
Prerequisites |
|
Introduction to Oracle 11g, or at least six months working in an Oracle technical environment. An understanding of relational database concepts, SQL, and PL/SQL programming skills are required. A solid understanding of Oracle schema is recommended. |
Course Outline |
Overview of Oracle Database
Starting and Shutting Down an Oracle Database
Using The Oracle Data Dictionary
Oracle Database Users and Schemas
Oracle System Privileges
Parameter Files
Creating an SPFILE from a PFILE and Back Again
Datafiles and Tablespaces
Control Files
Oracle Physical Structures — Online Redo Logs
Oracle Physical Structures — Undo Segments
Segment Space Management
Tables
Indexes
Index Key Compression
Constraints
Views
Object Privileges
Synonyms
The Optimizer and Statistics
Oracle Net Services
Data Pump
SQL*Loader and External Tables
Back Up Your Database
Recover Your Database
Oracle Enterprise Manager
Using OEM — Using Metrics, Alerts, and Thresholds
Appendix A – Installing Oracle Software
Appendix B – Creating a Database Using the DBCA
Appendix C – Manual Database Creation
Appendix D – Auditing the Database |
Course Directory [training on all levels]
- .NET Classes
- Agile/Scrum Classes
- Ajax Classes
- Android and iPhone Programming Classes
- Blaze Advisor Classes
- C Programming Classes
- C# Programming Classes
- C++ Programming Classes
- Cisco Classes
- Cloud Classes
- CompTIA Classes
- Crystal Reports Classes
- Design Patterns Classes
- DevOps Classes
- Foundations of Web Design & Web Authoring Classes
- Git, Jira, Wicket, Gradle, Tableau Classes
- IBM Classes
- Java Programming Classes
- JBoss Administration Classes
- JUnit, TDD, CPTC, Web Penetration Classes
- Linux Unix Classes
- Machine Learning Classes
- Microsoft Classes
- Microsoft Development Classes
- Microsoft SQL Server Classes
- Microsoft Team Foundation Server Classes
- Microsoft Windows Server Classes
- Oracle, MySQL, Cassandra, Hadoop Database Classes
- Perl Programming Classes
- Python Programming Classes
- Ruby Programming Classes
- Security Classes
- SharePoint Classes
- SOA Classes
- Tcl, Awk, Bash, Shell Classes
- UML Classes
- VMWare Classes
- Web Development Classes
- Web Services Classes
- Weblogic Administration Classes
- XML Classes
- Enterprise Linux System Administration
10 June, 2024 - 14 June, 2024 - RED HAT SATELLITE V6 (FOREMAN/KATELLO) ADMINISTRATION
24 June, 2024 - 27 June, 2024 - RED HAT ENTERPRISE LINUX V7 DIFFERENCES
13 May, 2024 - 15 May, 2024 - DOCKER WITH KUBERNETES ADMINISTRATION
6 May, 2024 - 10 May, 2024 - Go Language Essentials
29 July, 2024 - 1 August, 2024 - See our complete public course listing