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
MySQL Stored Procedure Programming
Built-in Functions
Options for Using MySQL with PHP
Using Stored Programs with MySQLdb
Optimizing Stored Program Code
Stored Programs as an Alternative to Expensive SQL
Lotus Notes and Domino 6 Development (2nd Edition)
New Language Features
Creating Shared Actions
Formula Syntax
JavaScript Application
Implementing Document-Level Security
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Address Resolution Protocol (ARP)
Internet Protocol (IP) Basics
Internet Protocol (IP) Addressing
Internet Protocol Version 6 (IPv6)
Internet Protocol Security (IPSec)
The Complete Cisco VPN Configuration Guide
VPNs: Choosing a Solution
Packet Authentication
Introduction to Accessing a Concentrator
IPsec Preparation
ISAKMP/IKE Phase 1 Policies
C++ How to Program (5th Edition)
Machine Languages, Assembly Languages and High-Level Languages
Typical C++ Development Environment
Summary
Introduction
Summary
Introducing Microsoft ASP.NET AJAX (Pro - Developer)
The AJAX Revolution
The Microsoft Client Library for AJAX
The AJAX Control Toolkit
Built-in Application Services
Building AJAX Applications with ASP.NET
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