OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)

OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)

Author: John Watson

Publisher: McGraw Hill Professional

Published: 2008-05-15

Total Pages: 770

ISBN-13: 0071591036

DOWNLOAD EBOOK

A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11g Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration


Oracle Database 10g DBA Handbook

Oracle Database 10g DBA Handbook

Author: Kevin Loney

Publisher: McGraw Hill Professional

Published: 2005-04-14

Total Pages: 737

ISBN-13: 0071770437

DOWNLOAD EBOOK

Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it’s been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.


Oracle Data Guard 11g Handbook

Oracle Data Guard 11g Handbook

Author: Larry Carpenter

Publisher: McGraw Hill Professional

Published: 2009-07-22

Total Pages: 545

ISBN-13: 0071621482

DOWNLOAD EBOOK

Master Oracle Data Guard 11g Provide superior data protection, availability, and disaster recovery using the tested techniques in this Oracle Press guide. Cowritten by a team of Oracle experts, Oracle Data Guard 11g Handbook provides a sound architectural foundation along with best practices for configuration, monitoring, maintenance, and troubleshooting. You will get full details on implementing deployment architectures to address requirements that extend beyond disaster recovery. This invaluable resource also includes a complete set of monitoring scripts available for download. Develop a disaster recovery plan for your Oracle database to meet your organization's requirements Configure and deploy Oracle Data Guard for your environment Tune and troubleshoot your physical and logical standby databases Implement the Oracle Data Guard Broker management framework Integrate with Oracle Grid Control Monitor your Oracle Data Guard environment Enable read-only services and disaster recovery with Oracle Active Data Guard Configure seamless database and application failover Minimize planned downtime using Oracle Data Guard switchover Handle backup and recovery with Oracle Recovery Manager


SQL Fundamentals

SQL Fundamentals

Author: John J. Patrick

Publisher: Prentice Hall

Published: 2002

Total Pages: 870

ISBN-13:

DOWNLOAD EBOOK

Based on John Patrick's hands-on SQL IT professionals at the University of California, Berkeley, this book shows exactly how to retrieve the data you want, when you need it, in any application. This 2nd edition is completely updated to include Oracle 9i and Access 2000.


Oca Oracle Database 11g Database Administration I

Oca Oracle Database 11g Database Administration I

Author: Steve Ries

Publisher: Packt Publishing Ltd

Published: 2013-02-22

Total Pages: 777

ISBN-13: 1849687315

DOWNLOAD EBOOK

Developed as a practical book, "Oracle Database 11g Administration I Certification Guide" will show you all you need to know to effectively excel at being an Oracle DBA, for both examinations and the real world. This book is for anyone who needs the essential skills to become an Oracle DBA, pass the Oracle Database Administration I exam, and use those skills in the real world to manage secure, high performance, and highly available Oracle databases.


OCA: Oracle Database 12c Administrator Certified Associate Study Guide

OCA: Oracle Database 12c Administrator Certified Associate Study Guide

Author: Biju Thomas

Publisher: John Wiley & Sons

Published: 2014-05-12

Total Pages: 1238

ISBN-13: 111864395X

DOWNLOAD EBOOK

An all-in-one study guide prepares you for the updated Oracle Certified Associate certification It's been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority. This resource answers that demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams. Provides you with a solid understanding of restricting and sorting data Walks you through using conversion functions and conditional expressions Addresses displaying data from multiple tables, manipulating data, database maintenance, and database backups and recovery Explores the Oracle database architecture and discusses preparing the database environment, creating an Oracle database, and managing the Oracle instance Focuses on administering and implementing user security This must-have study guide thoroughly prepares you to take the dramatically updated Oracle 12c OCA exams.


OCP Oracle Database 11g Administration II Exam Guide

OCP Oracle Database 11g Administration II Exam Guide

Author: Bob Bryla

Publisher: McGraw Hill Professional

Published: 2008-08-31

Total Pages: 754

ISBN-13: 0071643796

DOWNLOAD EBOOK

A Fully Integrated Study System for OCP Exam 1Z0-053 Prepare for the Oracle Certified Professional Oracle Database 11g: Administration II exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-053, including: Database structure and Oracle Automatic Storage Management Configuring database recoverability Oracle Recovery Manager (RMAN) Oracle Flashback Memory management techniques Database tuning advisors Disk space and resource management Configuring database diagnostics Administering the Oracle Scheduler Database globalization On the CD-ROM: One full practice exam that simulates the actual OCP exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration


OCA / OCP Java SE 8 Programmer Practice Tests

OCA / OCP Java SE 8 Programmer Practice Tests

Author: Scott Selikoff

Publisher: John Wiley & Sons

Published: 2017-03-16

Total Pages: 710

ISBN-13: 1119363365

DOWNLOAD EBOOK

Test your knowledge and prepare for the OCA/OCP exams OCA/OCP Java SE 8 Programmer Practice Tests complements the Sybex OCA: Oracle Certified Associate Java SE 8 Programmer I Certification Study Guide and the OCP: Oracle Certified Professional Java SE 8 Programmer II Study Guide for exams 1Z0-808 and 1ZO-809 by providing last minute review of 100% of exam objectives. Get the advantage of over 1,000 expert crafted questions that not only provide the answer, but also give detailed explanations. You will have access to unique practice questions that cover all 21 objective domains in the OCA/OCP exams in the format you desire--test questions can also be accessed via the Sybex interactive learning environment. Two additional practice exams will ensure that you are ready for exam day. Whether you have studied with Sybex study guides for your OCA/OCP or have used another brand, this is your chance to test your skills. Access to all practice questions online with the Sybex interactive learning environment Over 1,000 unique practice questions and 2 practice exams include expert explanations Covers 100% of all 21 OCA/OCP objective domains for Exams 1Z0-809 and 1Z0-809 Studying the objectives are one thing, but diving deeper and uncovering areas where further attention is needed can increase your chance of exam day success. Full coverage of all domains shows you what to expect on exam day, and accompanying explanations help you pinpoint which objectives deserve another look.


Oracle Database 11g SQL

Oracle Database 11g SQL

Author: Jason Price

Publisher: McGraw Hill Professional

Published: 2007-11-26

Total Pages: 690

ISBN-13: 0071596135

DOWNLOAD EBOOK

Write powerful SQL statements and PL/SQL programs Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization techniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL. Explore SQL Plus and SQL Developer Use SQL SELECT, INSERT, UPDATE, and DELETE statements Write PL/SQL programs Create tables, sequences, indexes, views, and triggers Write advanced queries containing complex analytical functions Create database objects and collections to handle abstract data Use large objects to handle multimedia files containing music and movies Write Java programs to access an Oracle Database using JDBC Tune your SQL statements to make them execute faster Explore the XML capabilities of the Oracle Database Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more


Oracle PL/SQL Programming

Oracle PL/SQL Programming

Author: Steven Feuerstein

Publisher: "O'Reilly Media, Inc."

Published: 2002

Total Pages: 1028

ISBN-13: 9780596003814

DOWNLOAD EBOOK

The authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.