This course is for anyone who is interested in learning about the Oracle 8 relational database management system, its main components, and how to install it.
This is self-paced, internet-based course -- there are no books to purchase and no scheduled classes to attend.
Training that's Easy, Convenient and Affordable! High-quality, online, self-paced training designed to help you achieve your goals.
Affordable annual subscription plans give you unlimited access to an entire suite of training topics at prices that you just won't find anywhere else.
Our courses are based on sound principles, from extensive research in instructional design, adult learning and information processing. All courses are design so that new knowledge and skills will be remembered and retrieved for future use. Each course include a 30-questions skill assessment, which evaluates your knowledge of the course material. You can be assured that this high-quality, instructionally-sound online product will enchance your professional and personal growth.
Try our FREE courses right now, and see for yourself how much you will learn!
After completing our Oracle courses, the user should be able to:
- Define the job of Administration
- Explain basic operation
- List the factors that affect performance
- Prepare for installation
- Install Oracle
- Identify the major components
- Plan for database capacity and size
- Calculate the system requirements of a database and server
- Calculate the disk requirements of a database and server
- Manage a database
- Use Server Manager and Database Assistant
- Start and shut down instances of databases
- Connect to and modify instances of databases
- Plan and design a database
- Prepare for a new database
- Create a new database and catalog
- Modify a database
- Create and modify tablespaces
- Manage tablespaces
- Use redo log files
- Describe control files and rollback segments
- Create user accounts
- Manage user accounts
- Manage user roles
- Create tables
- Manage different table views and types
- Create indexes
- Identify and use index types
- Export and import data using Export/Import
- Load data using the SQL*Loader Utility
- Describe the types of processes
- Monitor processes
- Manage job queues
- Use Auditing for security monitoring
- Describe backups
- Configure systems for maximum protection of data
- Create backup and recovery strategies
- Back up databases
- Recover data from backups
- Replicate databases
All courses are included in "Tech General Pack"
Course Features
Courses have special design features listed below:
- Certificates of Completion
- Instructional steps -- walk through a procedure
- Exercises -- try it out
- Notes - See additional information related to the topic in the text
- Tips - See a different, faster, or easier way of doing something
- Quick References - See a quick reference guide to the features introduced in a chapter
- Details - Display more detailed information related to the current topic
- Hotwords - See related information
- Navigation Bar - Maneuver easily through the courses
- Course Topics and Index -- with searching feature and hyper-links
- Printable Exercises - PDF downloadable files
- Sample Application Files - PDF downloadable files
- Course Glossary
- Skill Assessment - can be used for pre and post-testing -- tracking first try, best try and course grade - if passed, green check mark will appear as 'mastered' - hyperlinks to units within the course to go back and re-take a certain unit again. Use as pre-test to determine which course topics you want to focus on and to go directly into that unit.
Sign up for our courses right now, and join the ranks of people who are taking financial advantage of the explosion in the Information Technology field.
|