| Description |
1 online resource (lxiii, 1080 pages) : illustrations |
| Series |
Sybex serious skills |
|
Serious skills.
|
| Summary |
"Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification--this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you'll learn how to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, and more"--Resource description page. |
| Contents |
SQL Fundamentals I Assessment Test -- Administration I Assessment Test -- pt. I. Oracle Database 11g: SQL Fundamentals I -- Ch. 1. Introducing SQL -- Ch. 2. Using Single-Row Functions -- Ch. 3. Using Group Functions -- Ch. 4. Using Joins and Subqueries -- Ch. 5. Manipulating Data -- Ch. 6. Creating Tables and Constraints -- Ch. 7. Creating Schema Objects -- pt. II. Oracle Database 11g: Administration I -- Ch. 8. Introducing Oracle Database 11g Components and Architecture -- Ch. 9. Creating an Oracle 11g Database -- Ch. 10. Allocating Database Storage and Creating Schema Objects -- Ch. 11. Understanding Network Architecture -- Ch. 12. Implementing Security and Auditing -- Ch. 13. Managing Data and Undo -- Ch. 14. Maintaining the Database and Managing Performance -- Ch. 15. Implementing Database Backups -- Ch. 16. Recovering the Database -- Ch. 17. Moving Data and Using EM Tools -- App. About the Companion CD. |
| Subject |
Oracle (Computer file)
|
|
Oracle (Computer file) |
|
Oracle (Computer file) |
|
Electronic data processing personnel -- Certification.
|
|
Database management -- Examinations -- Study guides.
|
|
Bases de données -- Gestion -- Examens -- Guides de l'étudiant. |
|
Electronic data processing personnel -- Certification. |
|
Database management -- Examinations -- Study guides. |
|
Database management -- Examinations |
|
Electronic data processing personnel -- Certification |
| Genre |
Study guides
|
| Added Title |
Oracle database 11g administrator certified associate study guide |
| Other Form: |
Print version: Thomas, Biju. OCA. Indianapolis, Ind. : Wiley Pub., ©2009 9780470395127 (DLC) 2008052085 (OCoLC)244768434 |
| ISBN |
0470395125 |
|
9780470395127 |
|
9780470488348 (electronic bk.) |
|
0470488344 (electronic bk.) |
|
More Resources