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
CISSP Exam Cram 2
Risk Assessment
Access-Control Types
Answers to Exam Prep Questions
Cryptographic Basics
History of Encryption
VBScript Programmers Reference
What VBScript Is and Isn™t!
Remote Scripting
Adding VBScript to Your VB Applications
Appendix H Regular Expressions
Appendix I VBScript Features not in VBA
MySQL Cookbook
Date-Based Summaries
Determining Presence or Absence of a Result Set
Getting Server Metadata
Sequencing an Unsequenced Table
Inserting Records in One Table That Include Values from Another
An Introduction to Design Patterns in C++ with Qt 4
Structs
tr() and Internationalization
Creational Patterns
Review Questions
Data Model: Mp3File
Special Edition Using Crystal Reports 10
Using the OLAP Report Creation Wizard and OLAP Expert
Configuring the Application Server
Troubleshooting
Understanding the Crystal Enterprise Object Model
Creating Enterprise Reporting Applications with Crystal Enterprise Part II
Visual Studio Tools for Office(c) Using C# with Excel, Word, Outlook, and InfoPath
Code Behind a Document
Working with the Workbooks Collection
Conclusion
Working with the NameSpace Object
Implementing IDTExtensibility2
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