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
Database Modeling with MicrosoftВ® Visio for Enterprise Architects (The Morgan Kaufmann Series in Data Management Systems)
Conceptual Model Reports
Creating a Basic Logical Database Model
Generating a Physical Database Schema
Editing Logical Models”Advanced Aspects
Change Propagation and Round Trip Engineering
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Retrieving and Managing Data
Mapping Table and Column Names Between the Data Source and DataSet
Transmitting a DataSet Securely
Using Transaction Isolation Levels to Protect Data
Retrieving a Single Value from a Query
Project Management JumpStart
Building the Foundation
Developing Project Management Skills
Breaking Down the Project Activities
Executing the Project
Appendix C Sample Project Management Checklists
ERP and Data Warehousing in Organizations: Issues and Challenges
Challenging the Unpredictable: Changeable Order Management Systems
Enterprise Application Integration: New Solutions for a Solved Problem or a Challenging Research Field?
Distributed Data Warehouse for Geo-spatial Services
Data Mining for Business Process Reengineering
Intrinsic and Contextual Data Quality: The Effect of Media and Personal Involvement
MySQL Clustering
Using Multiple Management Nodes
Restoring a Backup
Common Setups
Web Farm/MySQL Farm
Network Redundancy
Cisco CallManager Fundamentals (2nd Edition)
Regions
The Seven Fundamentals of Call Routing
Translation Patterns
Media Processing
Client Solutions
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