Oca: Oracle Database 11G Administrator Certified Associate Study Guide (Exams 1Z0-051 And 1Z0-052)

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, this book 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. · basic sql select statements. · single-row functions. · group functions. · joins and sub-queries. · modifying data. · creating tables. · creating schema objects. Part ii: oracle database 11g: administration i. · oracle database 11g components and architecture. · create an oracle11g database. · database storage and schema objects. · oracle network architecture. · security and auditing. · managing data and undo. · proactive maintenance and performance monitoring. · implementing database backups. · recovering database. · em tools and data utilities.