Oracle 10g dba
Course Content - Course Duration - 60hrs
1.Introduction
- Identify the oracle product
2.Installing oracle database 10g software
- System requirements.
- Redhat Linux Installation
- Install software with the Oracle Universal Installer on Linux Platform
3.Create an oracle database
- Oracle Database 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
- 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.Administering users
- 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
- Image copies
- Scripts,
- 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.Proactive Maintenance
- Contents
- Optimizer statistics
- Automatic Workload Repository
17.Flashback
- Introduction
- Configuration
- Flashback Query/Table/Drop/Database
- Flashback Version Query
- Creating Restore Points
18.Automatic Storage Management
19.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
Key Points of Training Program :
-
Oracle Database 10g training course allows participants to acquire skills necessary for running day-to-day administration of an Oracle 10g database. Beginner Oracle database administrators can go for this excellent training & certification that sets the foundation for advanced learning. It gives a good boost to the careers of database administration professionals. In the training class, students will learn how to configure an Oracle database 10g for multilingual applications and practice various methods of recovering database using RMAN and Flashback technology. Training faculty with strong expertise in Oracle Database 10g possess several years of industry experience. Various modules cover database performance monitoring tools, processes to resolve common problems and improve performance, and administering a database efficiently. Online and offline classes cover all database technologies such as Resource Manager, Scheduler, Automatic Storage Management (ASM) and VLDB. Excellent self study material, reference resources, online support, doubt clearing sessions, job interview Q&A and mock interviews form part of placement assistance offered by training institutes to their students. Hands-on exercises, case studies and practical insights will ensure you get the best Oracle Database 10g training. The Oracle Database 10g training course is the best way to prepare for the Oracle Certification Exam for associate, professional or master level.
-
• Standard Edition One (SE1) with a limited capacity of two processors
• Standard Edition (SE) can be licensed on single servers with a maximum capacity
of four processors
• Enterprise Edition (EE) supports all sizes of computers and is not limited to a
maximum processor count
• Personal Edition (PE) is run on any number of processors but is restricted to a
single user
• Express Edition (XE) can be installed on any size machine with any number of
CPUs -
In this Oracle Database 10g training course, you’ll learn
• Installation of the software and creation of new databases
• In-depth exploration of the database architecture including memory, process and
data structures, as well as the management of those structures
• Management of database files
• Management of security policies and procedures, including administration of user
accounts, roles, privileges and profiles
• Utilization of advanced self-tuning and self-management capabilities including
the use of Oracle-managed files, database advisors and other components
• Performance monitoring, problem troubleshooting and resolving lock and conflict
issues
• Using the Oracle Enterprise Manager and SQL interfaces for administration tasks
• Control over database support services including iSQL*Plus, the Database
Control, Oracle Net and others
• A primer on backup and recovery structures and strategies
• Operating system-specific considerations for Unix, Linux and MS Windows