Recommended skills:
- Experience using Oracle database
- Solid understanding of databases, and managing databases
- Oracle Database 9i or 10g
IT professionals
This training takes you from having little-to-no experience on Oracle, to managing your own Oracle database. If you're new to Oracle, this is just the start you need to dive in and start working in Oracle. If you already work with Oracle, this series can fill out your knowledge and teach you more about making Oracle function well, plus show you the latest features of Oracle version 10g. These practice tests help you review your knowledge and prepare you for exams.
Course Duration: 11:30:07
- Series Intro
- SQL Plus and iSQL Plus
- Installing Oracle Software and Creating a Database
- Oracle Database and Instance Architecture
- Startup, Shutdown, and the Initialization File
- Managing Tables, Views, Constraints and Sequences
- Data Moving Utilities
- PL/SQL Basics
- Triggers, procedures, functions
- Packages
- Managing undo
- Tablespaces
- Managing users
- Oracle net services
- Oracle's shared server option
- Oracle security
- Locks, latches, and waits
- Performance
- Backup and Recovery Techniques
- Backups using RMAN
- Database recovery
- Enterprise Manager