OCA / OCP: Oracle9i DBA Fundamentals I Study Guide
OCA / OCP: Oracle9i DBA Fundamentals I Study Guide

Author: Biju Thomas

Publisher: John Wiley & Sons

Published: 2006-02-20

Total Pages: 461

ISBN-13: 9780782152456

DOWNLOAD EBOOK

Here's the book you need to prepare for Exam 1Z0-031: OCA/OCP: Oracle9i DBA Fundamentals I Study Guide In-depth coverage of official exam objectives Practical information on implementing and managing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Understanding Oracle architecture and its main components Identifying DBA administrative tools Setting up password file authentications Creating and managing Initialization Parameter Files Configuring OMF Create a database using Oracle Database Configuration Assistant Creating a database manually Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

OCA / OCP: Introduction to Oracle9i SQL Study Guide
OCA / OCP: Introduction to Oracle9i SQL Study Guide

Author: Chip Dawes

Publisher: John Wiley & Sons

Published: 2006-02-20

Total Pages: 611

ISBN-13: 0782152503

DOWNLOAD EBOOK

Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i: * In-depth coverage of official exam objectives * Practical information on using SQL in a real-world Oracle9i environment * Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: * Writing basic SQL SELECT statements * Restricting and sorting data * Displaying data from multiple tables * Aggregating data using group functions * Producing readable output with iSQL*Plus * Creating and managing tables * Controlling user access

OCP: Oracle9i DBA Fundamentals II Study Guide
OCP: Oracle9i DBA Fundamentals II Study Guide

Author: Matthew Weishan

Publisher: John Wiley & Sons

Published: 2006-02-20

Total Pages: 532

ISBN-13: 078215249X

DOWNLOAD EBOOK

Here's the book you need to prepare for Exam 1Z0-032: Oracle9i Database: Fundamentals II. In-depth coverage of official exam objectives Practical information on implementing and managing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Identifying solutions included with Oracle9i for managing complex networks Using Oracle Net Services and client server connections Establishing web client connections through Oracle networking products Troubleshooting database connections Using and configuring the Oracle Shared Server Backing up, restoring, and recovering databases Configuring the database archiving mode Using Recovery Manager (RMAN) Loading data into, and transporting data between databases Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

OCP: Oracle9i Performance Tuning Study Guide
OCP: Oracle9i Performance Tuning Study Guide

Author: Joseph C. Johnson

Publisher: John Wiley & Sons

Published: 2006-07-14

Total Pages: 613

ISBN-13: 9780782152746

DOWNLOAD EBOOK

Here's the book you need to prepare for Exam 1Z0-033: Oracle9i Database: Performance Tuning. This Study Guide provides: In-depth coverage of official exam objectives Practical information on optimizing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Using Diagnostic and Tuning Tools Monitoring and Managing the Buffer Cache Optimizing Sort Operations Detecting and Resolving Lock Contention Diagnosing Shared Server Performance Issues Using Oracle Blocks Efficiently Tuning SQL Statements Configuring Resource Manager Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Oracle9i DBA JumpStart
Oracle9i DBA JumpStart

Author: Bob Bryla

Publisher: John Wiley & Sons

Published: 2006-02-20

Total Pages: 367

ISBN-13: 0782151612

DOWNLOAD EBOOK

Get Up to Speed for Oracle9i Administration Training Courses--Fast! Oracle9i DBA JumpStart gives you the solid grounding you need to approach Oracle certification with confidence: * Introduction to relational database concepts * Using basic SQL*Plus and iSQL*Plus commands * Understanding Oracle database functions * Using multiple tables * Restricting, sorting, and grouping data * Creating and maintaining a database * Using SQL*Plus reporting techniques * Creating and maintaining database objects * Setting up users and managing security * Configuring optimization * Creating backups * Troubleshooting

OCP: Oracle Database 11g Administrator Certified Professional Study Guide
OCP: Oracle Database 11g Administrator Certified Professional Study Guide

Author: Robert G. Freeman

Publisher: John Wiley & Sons

Published: 2009-05-18

Total Pages: 895

ISBN-13: 9780470496893

DOWNLOAD EBOOK

This updated study guide for the latest release of the most popular database software in the world—Oracle Database 11g— reviews using the RMAN recovery catalog, handling Flashback technology, managing memory and resources, automating tasks, diagnosing the database, and much more. Plus, more than 100 pages of workbook exercises help prepare you to take the 1Z0-053 exam. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

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.

Expert Oracle Database 11g Administration
Expert Oracle Database 11g Administration

Author: Sam Alapati

Publisher: Apress

Published: 2009-01-10

Total Pages: 1376

ISBN-13: 1430210168

DOWNLOAD EBOOK

Sam Alapati's Expert Oracle Database 11g Administration is a comprehensive handbook for Oracle database administrators (DBAs) using the 11g release of the Oracle Database. All key aspects of database administration are covered, including backup and recovery, day–to–day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It'll help you get the job done. Comprehensive handbook for Oracle Database administrators. Covers all major aspects of database administration. Tests and explains in detail key DBA commands. Offers primers on Linux/Unix, data modeling, SQL, and PL/SQL.