OCA Oracle Database 11g Database Administration I : a Real-World Certification Guide.
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 a...
Clasificación: | Libro Electrónico |
---|---|
Autor principal: | |
Formato: | Electrónico eBook |
Idioma: | Inglés |
Publicado: |
Birmingham :
Packt Pub.,
2013.
|
Temas: | |
Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- Table of Contents; OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide; OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide; Credits; Foreword; About the Author; About the Reviewer; www.packtpub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions.
- 1. Introducing the Oracle Relational Database SystemUnderstanding the RDBMS; The importance of databases; Flat file databases; Limitations of the flat file paradigm; A new paradigm; Introducing the Oracle product family; Exploring the history of Oracle; Understanding the Oracle Database product; Understanding the different editions of Oracle Database; Understanding Oracle Database options; Examining the Oracle product family; Understanding Oracle's hardware solutions; Examining Oracle virtualization solutions; Exploring Oracle operating systems; Examining Oracle Application Servers.
- Interpreting Oracle Database versioningUnderstanding the role of the DBA; Examining the tools of the Oracle DBA; SQL*Plus; Oracle Enterprise Manager; TOAD; DBArtisan; Oracle SQL Developer; Introducing the Companylink database; Summary; Test your knowledge; 2. Installing the Oracle Database Software; Planning an Oracle installation; Understanding Oracle installation concepts; Acquiring the Oracle software; Reviewing the installation prerequisites; Reviewing hardware prerequisites for an installation; Meeting the minimum hardware requirements for an installation.
- Reviewing software prerequisites for an installationUsing the Oracle Universal Installer; Understanding how OUI works; Completing final preparations to install the Oracle software; Creating Oracle user accounts and groups; Establishing Oracle directory structures; Understanding the Optimal Flexible Architecture; Using environment variables in Oracle; Installing the Oracle Database software; Running the Oracle Universal Installer; Examining the installation; Understanding the de-installation process
- advanced topic; Summary; Test your knowledge; 3. Creating the Oracle Database.
- Planning for a database creationUnderstanding the memory requirements of a database; Understanding the disk requirements of a database; Running the Network Configuration Assistant; Creating an Oracle database using DBCA; Introducing the Database Configuration Assistant; Examining a manual database creation; Examining Windows Services in Oracle; Certification objectives covered; Summary; Test your knowledge; 4. Examining the Oracle Architecture; Understanding the Oracle RDBMS; Distinguishing between an instance and a database; Examining the Oracle instance.