Start with 7 free days of training.

Gain instant access to our entire IT training library, free for your first week.
Train anytime on your desktop, tablet, or mobile devices.

Oracle DBA Certified Associate on versions 9i and 10g

This course will be retired in 290 days. If you have questions, please contact us.

This video training with Julie Johnson covers databases, including data moving utilities, managing users, and more....
This video training with Julie Johnson covers databases, including data moving utilities, managing users, and more.

Recommended skills:
    Experience using Oracle database
  • Solid understanding of databases, and managing databases

Recommended equipment:
  • Oracle Database 9i or 10g

Related certifications:
  • Oracle Database 10g Administrator Certified Associate
  • Oracle Database 10g Administrator Certified Master
  • Oracle Database 10g Administrator Certified Professional
  • Oracle Database 10g Managing Oracle on Linux Certified Expert
  • Oracle Database 10g Real Applications Clusters Administrator Certified Expert

Related job functions:
  • 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 course can fill out your knowledge and teach you more about making Oracle function well, plus show you the latest features of Oracle version 10g.

This course also maps to exam objectives for the Oracle Database 10g: Administration I exam 1Z0-042, for Oracle 10g OCA certification. Plus, the training covers topics from the Oracle 9i OCA exams, making distinctions where a new feature applies to just 10g.

All trademarks and copyrights are the property of their respective holders.
 show less
1. Course Intro (7 min)
2. SQL Plus andiSQL Plus (40 min)
3. Installing Oracle Software and Creatinga Database (28 min)
4. Oracle Database and Instance Architecture (33 min)
5. Startup, Shutdown, and the Initialization File (28 min)
6. Managing Tables, Views, Constraints and Sequences (34 min)
7. Data Moving Utilities (32 min)
8. PL/SQL Basics (43 min)
9. Triggers, procedures, functions (47 min)
10. Packages (22 min)
11. Managing undo (23 min)
12. Tablespaces (28 min)
13. Managing users (25 min)
14. Oracle net services (29 min)
15. Oracle's shared server option (30 min)
16. Oracle security (24 min)
17. Locks, latches, and waits (37 min)
18. Performance (42 min)
19. Backup and Recovery Techniques (27 min)
20. Backups using RMAN (30 min)
21. Database recovery (43 min)
22. Enterprise Manager (26 min)

Please help us improve by sharing your feedback on training courses and videos. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus
12 hrs 22 videos


Training Features

Practice Exams
These practice tests help you review your knowledge and prepare you for exams.

Virtual Lab
Use a virtual environment to reinforce what you are learning and get hands-on experience.

Offline Training
Our iOS and Android mobile apps offer the ability to download videos and train anytime, anywhere offline.

Accountability Coaching
Develop and maintain a study plan with one-to-one assistance from coaches.

Supplemental Files
Files/materials that supplement the video training.

Speed Control
Play videos at a faster or slower pace.

Included in this course
Pick up where you left off watching a video.

Included in this course
Jot down information to refer back to at a later time.

Closed Captions
Follow what the trainers are saying with ease.