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
Agile Project Management: Creating Innovative Products (2nd Edition)
Thriving in a Chaordic World
Management Style
Practice: Coaching and Team Development
The Scaling Challenge
Self-Organization Extensions
SQL Tips & Techniques (Miscellaneous)
Understanding SQL Basics and Creating Database Files
Performing Multiple-table Queries and Creating SQL Data Views
Working with Functions, Parameters, and Data Types
Working with Comparison Predicates and Grouped Queries
Exploiting MS-SQL Server Built-in Stored Procedures
C++ GUI Programming with Qt 3
Subclassing QDialog
Storing Settings
Double Buffering
Staying Responsive During Intensive Processing
Using QHttp
Twisted Network Programming Essentials
Starting the Twisted Event Loop
Accepting Connections from Clients
Calling SOAP Web Services
Looking Up the SMTP Server for a Domain
SSH
What is Lean Six Sigma
The Four Keys to Lean Six Sigma
Key #2: Improve Your Processes
Beyond the Basics: The Five Laws of Lean Six Sigma
Making Improvements That Last: An Illustrated Guide to DMAIC and the Lean Six Sigma Toolkit
The Experience of Making Improvements: What Its Like to Work on Lean Six Sigma Projects
HTI+ Home Technology Integrator & CEDIA Installer I All-In-One Exam Guide
Computer Network Hardware
Designing and Installing Distributed Video Systems
Troubleshooting Video Systems
Designing and Installing a Home Telephone System
Defining Users Needs and Desires
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