Oracle Database 11g Release 2 DBA using Enterprise Manager
|
Summary
|
|
|||||||||||||
Oracle Database 11g Release 2 DBA using Enterprise Manager
The Oracle Database 11g Release 2 DBA using Enterprise Manager course is designed for Database Administrators of small sized databases who need to carry out basic system administration tasks on Oracle Database 11g Release 1 or 2. The Oracle Database 11g Release 2 DBA using Enterprise Manager course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. The Oracle Database 11g Release 2 DBA using Enterprise Manager course is not aimed at delegates who are full time Database Administrators. The focus is on using Enterprise Manager to teach delegates how to manage the database.
Full time Database Administrators should attend the Oracle Database 11g Release 2 DBA - Part I and Oracle Database 11g Release 2 DBA - Part II courses.
The delegate will practice:
- Installing Oracle Database 11g Release 2 Software
- Creating an Oracle database
- Administering an Oracle database with Enterprise Manager
- Configuring the Oracle Network Environment
- Creating and Managing Database Storage Structures
- Managing Schema Objects
- Managing Users
- Maintaining Database Security
- Backing up, Restoring and Recovering the Database
- Monitoring the Performance of the Database Using Advisors
The Oracle Database 11g Release 2 DBA using Enterprise Manager course is aimed at Database Administrators of small sized databases who need to install Oracle Database 11g Release 1 or Release 2 software, create, monitor and support an Oracle Database 11g database. The Oracle Database 11g Release 2 DBA using Enterprise Manager course is also suitable for support staff and personnel who are required to carry out occasional administration or troubleshooting tasks. It aims to gives delegates practical experience in installing Oracle Database 11g Release 2 software, configuring the database, performing basic monitoring of the database and in carrying out basic administration tasks.
The Oracle Database 11g Release 2 DBA using Enterprise Manager course is designed to provide the knowledge and skills needed to successfully manage an Oracle database.
Delegates wishing to attend the Oracle Database 11g Release 2 DBA using Enterprise Manager course should have an understanding of relational database concepts and basic operating system knowledge. They should also have a working knowledge of Oracle SQL, this can be gained by attendance on the pre-requisite course.
- Oracle SQL
- Oracle Database 11g Release 2 DBA - Part I
- Oracle SQL Advanced
- Oracle PL/SQL
NOTE: Course technical content is subject to change without notice.
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Oracle product overview
- Oracle Support services
- Relational database concepts
- Oracle architecture
- Database administration tasks
- Database administration responsibilities
- Understand system requirements
- Use Oracle Universal Installer to install Oracle software (OUI)
- Create a database using Database Configuration Assistant (DBCA)
- Delete a database using DBCA
- Use DBCA to manage templates
- Upgrade a database using Database Upgrade Assistant (DBUA)
- Administrative tools available to a DBA
- Use SQL*Plus and SQL Developer to manage a database
- Administer the database using Enterprise Manager (EM)
- Start and stop the EM Database Console
- EM navigation
- Grant EM administrative privileges to a user
- Overview of network configuration
- Oracle Net Listener configuration and management
- Oracle Net Naming methods
- Tools for configuring and managing the Oracle network
- Configure local naming for client connections with Net Manager
- Start and stop the Oracle listener
- Configure the listener with EM
- Use TNSPING to test Oracle Net connectivity
- Connect to the database
- Oracle Instance
- Instance management
- Memory structures
- Background processes
- Access an Oracle database
- Initialization parameters
- Password file
- Shutdown the database
- Startup the database
- View alert log and trace files
- Oracle database structures
- Control files
- Redo log and archive redo log files
- Tablespaces and data files
- Create tablespaces
- Manage tablespaces
- Manage undo and use the Undo Advisor
- Use EM to view the storage structure of the database
- Database administration accounts
- User accounts
- Create and administer user accounts
- Lock and unlock user accounts
- Change a user's password
- Administer privileges and roles
- Create schema objects
- Create a new table
- View the attributes and contents of a table
- Understand data integrity
- Define constraints
- Create indexes
- View index attributes
- Create views
- Create synonyms
- Create sequences
- Oracle backup strategy
- Overview of backup, restore and recovery
- Backup and recovery configuration
- Configure ARCHIVELOG mode
- Backup and recover the database using EM
- Schedule backups
- Configure backup settings
- Configure recovery settings
- Configure catalog settings
- Perform recovery
- Self-monitoring architecture
- Monitor an Oracle database
- Automatic Workload Repository
- Automatic Database Diagnostics Monitor (ADDM)
- Use the advisors
- Set up notification rules
- Conclusion
If you want to find out more about Oracle Database 11g Release 2 DBA using Enterprise Manager, you can make an information request below and the school will contact you with further information.
Expenses
StayAhead Training
StayAhead Training - SQL, Oracle, UNIX and Linux training courses delivered by IT experts
StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.
StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.
Specialist IT training for professionals
StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena.
UNIX training courses not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle training courses also have depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.
In-house Professional IT training for your organisation
In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.
StayAhead's focus on IT training
StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.
Show all courses with
StayAhead Training
Request information - obligation free
Contact information for StayAhead Training
Phone no: +44 (0)20 7600 6116 
To request information from Oracle Database 11g Release 2 DBA using Enterprise Manager, please fill out the following details:
