› › Oca Ocp Oracle9i Dba Fundamentals I Study Guide

OCA / OCP: Oracle9i DBA Fundamentals I Study Guide

Author : Biju Thomas

Publisher : John Wiley & Sons

Page : 461 pages

File Size : 27,13 MB

Release : 2006-02-20

Category : Computers

ISBN : 9780782152456

Get eBook

Book Description

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

Author : Chip Dawes

Publisher : John Wiley & Sons

Page : 611 pages

File Size : 50,44 MB

Release : 2006-02-20

Category : Computers

ISBN : 0782152503

Get eBook

Book Description

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

Author : Matthew Weishan

Publisher : John Wiley & Sons

Page : 532 pages

File Size : 26,3 MB

Release : 2006-02-20

Category : Computers

ISBN : 078215249X

Get eBook

Book Description

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

Author : Joseph C. Johnson

Publisher : John Wiley & Sons

Page : 613 pages

File Size : 16,13 MB

Release : 2006-07-14

Category : Computers

ISBN : 9780782152746

Get eBook

Book Description

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

Author : Bob Bryla

Publisher : John Wiley & Sons

Page : 367 pages

File Size : 18,6 MB

Release : 2006-02-20

Category : Computers

ISBN : 0782151612

Get eBook

Book Description

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

Author : Robert G. Freeman

Publisher : John Wiley & Sons

Page : 895 pages

File Size : 28,52 MB

Release : 2009-05-18

Category : Computers

ISBN : 9780470496893

Get eBook

Book Description

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

Author : Biju Thomas

Publisher : John Wiley & Sons

Page : 1238 pages

File Size : 11,39 MB

Release : 2014-05-12

Category : Computers

ISBN : 111864395X

Get eBook

Book Description

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

Author : Sam Alapati

Publisher : Apress

Page : 1376 pages

File Size : 22,91 MB

Release : 2009-01-10

Category : Computers

ISBN : 1430210168

Get eBook

Book Description

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.



Oracle PL/SQL Programming

Author : Steven Feuerstein

Publisher : "O'Reilly Media, Inc."

Page : 1028 pages

File Size : 29,41 MB

Release : 2002

Category : Computers

ISBN : 9780596003814

Get eBook

Book Description

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