Oracle DBA 11g
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 6 - stored pl/sql procedures/functions/packages/triggers since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7). Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database.
Course Content
Pre requisites : Basic SQL*plus script knowledge is needed
1. Introduction
- Different types of oracle products and features.
- New features in oracle 11g
- Differences among oracle9i, oracle 10g and oracle 11g features along with its importance.
2. Installing oracle database 10g software
- System requirements.
- Redhat Linux Installation
- Install software with the Oracle Universal Installer on Linux Platform
3. Creation of an oracle database
- Oracle Database 11g Architecture
- Oracle instance architecture
- Oracle Read Consistency and Concurrency
4. Controlling the database
- Start and stop the enterprise manager database console
- Start and stop the listener
- Startup and shutdown the database
5. Database Creation
- Manual
- Database Configuration Assistant(DBCA)
6. Storage Structures and architecture of Oracle 11g DBA
- Logical structure Vs Physical structure
- Defining the tablespaces and data files
- Create tablespaces
- Manage tablespaces
- Obtain tablespace information
- Managing Undo Data
7. File Management
- Control File Management
- Redo Log File Management
- Parameter File Management
- Obtain tablespace information
8. User Management
- Create and manage database user accounts
- Roles
- Privileges
- Control resource usage by using Profiles
9. Oracle Net Services
- Understand Oracle Net concepts
- Use Oracle Net Manager to create and configure listeners
- Use the listener control utility to control the Oracle Net Listener
- Testing Oracle Net connectivity
- Shared Server: Connection pooling
10. Managing schema objects
- Create and modify tables
- Define constraints
- View the attributes of a table
- View the contents of a table
- Create indexes and views
11. Oracle Backup & Recovery (User Managed)
- Introduction
- Design, Testing, Implementation Strategies
- Offline(cold)/Online(hot) backups
- Performing Complete Recovery
- Performing Incomplete Recovery
12. Oracle Backup & Recovery (System Managed: RMAN)
- Introduction
- RMAN Architecture
- Configuration
- Setting up Catalog
- Online/Offline Backup using RMAN
- Backups Options
- Incremental Backups
- Complete Recovery
- Incomplete Recovery
- Table Space Point in Time Recovery (TSPITR)
- Disaster Recovery
13. Cloning
- RMAN
- Manual
14. Logical Backup & Transporting data between databases
- Introduction Data pump (expdp, impdp) Utilities
- Exporting/Importing Tables
- Exporting/Importing Schemas
- Exporting/Importing Table space
- Exporting/Importing Database
- Transportable Table space within & across the database and platforms
15. High Availability (HA)
- Database Patch Management Introduction
- Applying Interim and Patch set Patches
- Patch History & Documentation
16. Oracle Enterprise Manager and Performance tuning
- New features and its analysis of statistics on performance Tuning
17. Proactive Maintenance
- Contents
- Optimizer statistics
- Automatic Workload Repository
18. Flashback
- Introduction
- Configuration
- Flashback Query/Table/Drop/Database
- Flashback Version Query
- Creating Restore Points
19. Automatic Storage Management
- New features and implementation
20. Oracle Grid Control
- Introduction
- Architecture
- Managing the multiple database nodes using OEM grid control
Our distinct services include :
- Material and Documents: We provide real time working documents and materials to our students.
- Free System Access : We have the latest and most up to date platforms deployed on high-end servers that are available remotely and in-class on a 24/7 basis.
- Interview Preparation: We will prepare you for interviews in your specialized area by providing some real time interview questions. We also conduct mock interviews and assist you in preparing a professional resume.
- Placement Assistance: Our placement service division provides job placement support by submitting your resumes to prospective clients and emails you any new job opportunities in the market. However, we do not provide false guarantees on securing any jobs for you. We have a history of several ex-students who have secured excellent jobs based on our WORLD class training approach, implementation of case study projects and post training support.
- Initial Job Stabilization Support: We support our students to get stabilized in their job in the first TWO months. If our students come across any issues, we are there to help them. Students can send an email to us with their issues, our experts will reply back with possible solutions within 24 hours.
- Free Class Room sessions recording: In addition to the e-class training, we will give you authorization to record all of your e-class room training sessions, so that you can go back and review.
Other Courses related
Course registration
Instructor Led Hands-on eClassroom Training.
Key Points of Training Program :
Oracle DBA 11g, Learn with Online Practice, in-class Seminars, Training and Certification from the list of world-class education trainers. Macropus provides Class Material, Tutorial Curriculum, Demo Videos, Sample Questions, Recommended Books, Tips and Tricks. Get lectures and practical lessons on development and programming to improve technical skills and Students will benefit with Job Placements.
-
What is Oracle Database 11g
Oracle Database 11g course gives a complete overview of the power and flexibility of Oracle 11g database applications. It teaches how to design, build and maintain complex database applications using Oracle database tools. Oracle Database 11g course also help to understand Oracle architecture and how its components work and interact with one another. You’ll be able to retrieve and manipulate data efficiently using SQL developer. Oracle Database 11g classes also give hands-on experience on creating and managing database tables, sequences and synonyms as well as ensuring data integrity, enforcing security and enhancing performance. Participants learn to write structured PL/SQL code to develop stored procedures, triggers and packages. You’ll gain extensive knowledge and practical insights into building Oracle 11g databases that can be easily applied to your job. You can opt for instructor-led online, in-class or on-demand Oracle Database 11g courses.
-
What is a database?
Database is a single point of mechanism for storing and retrieving information with the help of tables that stores specific attributes and a corresponding value. Popular Database Management Systems are Oracle, ibm db2, Microsoft sql server, Microsoft access, MySQL and SQLite.
-
What are the different types of storage systems available?
• Relational Database Management System (RDBMS)
• Hierarchical Storage Management System (HSM)
• Information Management System (IMS) from IBM
• Integrated Database Management System (IDMS) from CA.