OCA: Oracle Database 11g Administrator Certified Associate Study Guide Exams1Z0–051 and 1Z0–052

Oracle is the leading developer of database software, and the Oracle certifications have long been the standard for professional Database Administrators. Oracle 11g OCAs need to have an understanding of the following: Restricting and Sorting Data Using Conversion Functions and Conditional Expressions Displaying Data from Multiple Tables Manipulating Data Exploring the Oracle Database Architecture Preparing the Database Environment Creating an Oracle Database Managing the Oracle Instance Managing Database Storage Structures Administering and Implementing User Security Database Maintenance Performance Management Performing Database Backups and Recovery Moving Data This two in one book covers the Oracle Database 11g: SQL Fundamentals (1Z0-051) and Oracle Database 11g: Administration I (1Z0-052) exams. Focusing 100% on the exam objectives, the OCA: Oracle Database 11g Administrator Certified Associate Study Guide is designed for those who feel they are ready to attempt these challenging exams. The book also comes with an interactive CD, including two the Sybex Test Engine featuring Chapter Review Questions and Bonus Exams, a series of Flashcards that can be used on your PC or handheld, and an e-book. 

Part I: Oracle Database 11g: SQL Fundamentals I. 1. Basic SQL SELECT Statements. 2. Single-Row Functions. 3. Group Functions. 4. Joins and Sub-queries. 5. Modifying Data. 6. Creating Tables. 7. Creating Schema Objects. Part II: Oracle Database 11g: Administration I. 8. Oracle Database 11g Components and Architecture. 9. Create an Oracle11g Database. 10. Database Storage and Schema Objects. 11. Oracle Network Architecture. 12. Security and Auditing. 13. Managing Data and Undo. 14. Proactive Maintenance and Performance Monitoring. 15. Implementing Database Backups. 16. Recovering Database. 17. EM Tools and Data Utilities.