Flylib.com
Oracle9i DBA JumpStart
Oracle9i DBA JumpStart
ISBN: 0782141897
EAN: 2147483647
Year: 2006
Pages: 138
Authors:
Bob Bryla
BUY ON AMAZON
Table of Contents
BackCover
Oracle9i DBA JumpStart
Introduction
What This Book Covers
Understanding Oracle Certification
Making the Most of This Book
About the Author
Chapter 1: Relational Database Concepts
Relational Databases
Object-Relational Databases
Review Questions
Terms to Know
Chapter 2: SQLPlus and iSQLPlus Basics
Tools for Running SQL
The Ubiquitous SELECT Statement
DML for Making Changes
DDL for Handling Database Objects
DCL for Handling Privileges
Review Questions
Terms to Know
Chapter 3: Oracle Database Functions
Built-in Single-Row Functions
User-Defined Functions
Review Questions
Terms to Know
Chapter 4: Restricting, Sorting, and Grouping Data
The ORDER BY Clause
Group Functions and the GROUP BY Clause
Review Questions
Terms to Know
Chapter 5: Using Multiple Tables
Equijoins
Non-equijoins
Outer Joins
Self-Joins
Cartesian Products: The Black Sheep of the Family
Review Questions
Terms to Know
Chapter 6: Advanced SQL Queries
Set Operators
ROLLUP and CUBE
Review Questions
Terms to Know
Chapter 7: Logical Consistency
Transaction Processing
Review Questions
Terms to Know
Chapter 8: Installing Oracle and Creating a Database
Oracle Components Overview
Installing Oracle Software
Creating an Oracle Database
Review Questions
Terms to Know
Chapter 9: Reporting Techniques
iSQLPlus Configuration
Report Formatting
Substitution Variables
Saving and Running Scripts
Review Questions
Terms to Know
Chapter 10: Creating and Maintaining Database Objects
Creating Tables
Creating Indexes
Creating and Using Views
Creating Sequences and Synonyms
Review Questions
Terms to Know
Chapter 11: Users and Security
Granting and Revoking Privileges
Auditing
Review Questions
Terms to Know
Chapter 12: Making Things Run Fast (Enough)
Indexes
Data Design Tuning
SQL Application Tuning
Memory Tuning
Review Questions
Terms to Know
Chapter 13: Saving Your Stuff (Backups)
Database Failures
User Backup and Recovery Methods
DBA Backup and Recovery Methods
Review Questions
Terms to Know
Chapter 14: Troubleshooting
The Alert Log File
OEM s Event Manager
System Trace Files
User Trace Files
Review Questions
Terms to Know
Appendix A: Answers to Review Questions
Chapter 2
Chapter 3
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Chapter 11
Chapter 12
Chapter 13
Chapter 14
Appendix B: Glossary
Appendix C: Common Database Platforms
Personal and Freeware Databases
Index
Index_A
Index_B
Index_C
Index_D
Index_E
Index_F
Index_G
Index_H
Index_I
Index_J
Index_K
Index_L
Index_M
Index_N
Index_O
Index_P
Index_Q
Index_R
Index_S
Index_T
Index_U
Index_V
Index_W
Where Can I Find?
List of Tables
List of Sidebars
Oracle9i DBA JumpStart
ISBN: 0782141897
EAN: 2147483647
Year: 2006
Pages: 138
Authors:
Bob Bryla
BUY ON AMAZON
Project Management JumpStart
Defining the Project Goals
Budgeting 101
Appendix A Answers to Review Questions
Appendix B Sample Project Management Forms
Appendix C Sample Project Management Checklists
ERP and Data Warehousing in Organizations: Issues and Challenges
ERP System Acquisition: A Process Model and Results From an Austrian Survey
The Effects of an Enterprise Resource Planning System (ERP) Implementation on Job Characteristics – A Study using the Hackman and Oldham Job Characteristics Model
Healthcare Information: From Administrative to Practice Databases
A Hybrid Clustering Technique to Improve Patient Data Quality
Relevance and Micro-Relevance for the Professional as Determinants of IT-Diffusion and IT-Use in Healthcare
Certified Ethical Hacker Exam Prep
Determining Assessment Scope
Summary
Key Terms
Hacking Web Servers
U.S. Government Restricted Rights
Cisco Voice Gateways and Gatekeepers
Media Gateway Control Protocol
Case Study: Configuring an H.323 Gateway
Review Questions
Circuit Signaling
Configuring the Gateway to Use a Tcl Script
Persuasive Technology: Using Computers to Change What We Think and Do (Interactive Technologies)
Overview of Captology
Computers as Persuasive Social Actors
Credibility and Computers
The Ethics of Persuasive Technology
Captology Looking Forward
HTI+ Home Technology Integrator & CEDIA Installer I All-In-One Exam Guide
Connector Types and Uses
Trim-Out Installation
Designing and Installing Distributed Audio Systems
Distributed Video Basics
HVAC Controls
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies