Oracle is the leading database on the market, putting Oracle database administrators in high demand. However, before embarking on a career as a DBA, individuals need a solid understanding of database administration and SQL programming fundamentals, and that's exactly what this book provides. Oracle Database Foundations assumes no prior knowledge of databases and provides a comprehensive introduction to the major topics involved, explaining the fundamentals of database administration in simple terms with tangible examples.
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 Common Database Platforms. Glossary. 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.