Oracle is the leading database on the market, putting Oracle database administrators in high demand. Oracle recently restructured their certification programme into three tiers: OCA (Oracle Certified Associate); OCP (Oracle Certified Professional); and OCM (Oracle Certified Master). However, before embarking on a comprehensive Oracle9i certification study programme, aspiring DBAs need a solid foundation in database administration and SQL programming fundamentals. This text offers simple, tangible explanations to clarify the complex issues surrounding Oracle9i.
Table of Contents
Contents at a Glance. Introduction. Chapter 1: Relational Database Concepts. Chapter 2: SQLPlus and iSQLPlus Basics. Chapter 3: Oracle Database Functions. Chapter 4: Restricting, Sorting, and Grouping Data. Chapter 5: Using Multiple Tables. Chapter 6: Advanced SQL Queries. Chapter 7: Logical Consistency. Chapter 8: Installing Oracle and Creating a Database. Chapter 9: Reporting Techniques. Chapter 10: Creating and Maintaining Database Objects. Chapter 11: Users and Security. Chapter 12: Making Things Run Fast (Enough). Chapter 13: Saving Your Stuff (Backups). Chapter 14: Troubleshooting. Appendix A: Answers to Review Questions. Appendix B: Glossary. Appendix C: Common Database Platforms. Index.
Bob Bryla, OCP, has worked with Oracle databases for over 10 years. He currently works as an Oracle DBA and Analyst for Lands' End in Dodgeville, Wisconsin.