OCA / OCP: Oracle9i DBA Fundamentals I Study Guide

OCA / OCP: Oracle9i DBA Fundamentals I Study Guide
Author: Biju Thomas
Publisher: John Wiley & Sons
Total Pages: 461
Release: 2006-02-20
Genre: Computers
ISBN: 9780782152456

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: Oracle Database 12c Administrator Certified Associate Study Guide

OCA: Oracle Database 12c Administrator Certified Associate Study Guide
Author: Biju Thomas
Publisher: John Wiley & Sons
Total Pages: 1238
Release: 2014-05-12
Genre: Computers
ISBN: 111864395X

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.

OCA / OCP: Introduction to Oracle9i SQL Study Guide

OCA / OCP: Introduction to Oracle9i SQL Study Guide
Author: Chip Dawes
Publisher: John Wiley & Sons
Total Pages: 611
Release: 2006-02-20
Genre: Computers
ISBN: 0782152503

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
Total Pages: 532
Release: 2006-02-20
Genre: Computers
ISBN: 078215249X

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: 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
Total Pages: 895
Release: 2009-05-18
Genre: Computers
ISBN: 9780470496893

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 SQL Exam Guide

OCA Oracle Database SQL Exam Guide
Author: Steve O'Hearn
Publisher:
Total Pages: 609
Release: 2017
Genre: Database management
ISBN: 9781259585500

Features detailed explanations, examples, practice questions, and chapter summaries. "Certification Objectives," "Exam Watch," and "On the Job" sections reinforce salient points throughout.

Expert Oracle Database 11g Administration

Expert Oracle Database 11g Administration
Author: Sam Alapati
Publisher: Apress
Total Pages: 1376
Release: 2009-01-10
Genre: Computers
ISBN: 1430210168

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.

OCP: Oracle9i Performance Tuning Study Guide

OCP: Oracle9i Performance Tuning Study Guide
Author: Joseph C. Johnson
Publisher: John Wiley & Sons
Total Pages: 613
Release: 2006-07-14
Genre: Computers
ISBN: 9780782152746

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.

Oracle PL/SQL Programming

Oracle PL/SQL Programming
Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
Total Pages: 1028
Release: 2002
Genre: Computers
ISBN: 9780596003814

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