Book description
Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.
Table of contents
- Cover Page
- Oracle Database 10g: A Beginner’s Guide
- Copyright Page
- About the Authors
- About the Contributing Authors
- Contents
- Acknowledgments
- Introduction
-
1 Database Fundamentals
- Critical Skill 1.1 Define a Database
- Critical Skill 1.2 Learn the Oracle Database 10g Architecture
- Critical Skill 1.3 Learn the Basic Oracle Database 10g Data Types
- Critical Skill 1.4 Work with Tables
- Critical Skill 1.5 Work with Stored Objects
- Critical Skill 1.6 Become Familiar with Other Important Items in the Oracle Database 10g
- Critical Skill 1.7 Work with Object and System Privileges
- Critical Skill 1.8 Introduce Yourself to the Grid
- Critical Skill 1.9 Tie It All Together
- Chapter 1 Mastery Check
-
2 SQL: Structured Query Language
- Critical Skill 2.1 Learn the SQL Statement Components
- Critical Skill 2.2 Use Basic insert and select Statements
- Critical Skill 2.3 Use Simple where Clauses
- Critical Skill 2.4 Use Basic update and delete Statements
- Critical Skill 2.5 Order Data
- Critical Skill 2.6 Employ Functions: String, Numeric, Aggregate (No Grouping)
- Critical Skill 2.7 Use Dates and Data Functions (Formatting and Chronological)
-
Critical Skill 2.8 Employ Joins (ANSI vs. Oracle): Inner, Outer, Self
- Inner Joins
- Project 2-1 Joining Data Using Inner and Outer Joins
- Project 2-2 Joining Data Using ANSI SQL Joins
- Critical Skill 2.9 Learn the group by and having Clauses
- Critical Skill 2.10 Learn Subqueries: Simple and Correlated Comparison with Joins
- Critical Skill 2.11 Use Set Operators: Union, Intersect, Minus
- Critical Skill 2.12 Use Views
- Critical Skill 2.13 Learn Sequences: Just Simple Stuff
- Critical Skill 2.14 Employ Constraints: Linkage to Entity Models, Types, Deferred, Enforced, Gathering Exceptions
- Critical Skill 2.15 Format Your Output with SQL*Plus
- Chapter 2 Mastery Check
-
3 The Database Administrator
- Critical Skill 3.1 Learn the Job of the DBA
- Critical Skill 3.2 Understand the Oracle Database 10g DBA Skill Set
- Critical Skill 3.3 Perform Day-to-Day Operations
- Critical Skill 3.4 Understand the Oracle Database 10g Infrastructure
- Critical Skill 3.5 Operate Modes of an Oracle Database 10g
- Critical Skill 3.6 Get Started with Oracle Enterprise Manager
- Critical Skill 3.7 Manage Database Objects
- Critical Skill 3.8 Manage Space
- Critical Skill 3.9 Manage Users
- Critical Skill 3.10 Manage Privileges for Database Users
- Chapter 3 Mastery Check
-
4 Networking
- Critical Skill 4.1 Use Oracle Net Services
- Critical Skill 4.2 Learn the Difference Between Dedicated and Shared Server Architectures
- Critical Skill 4.3 Define Connections
- Critical Skill 4.4 Use the Oracle Net Listener
- Critical Skill 4.5 Learn Naming Methods
- Critical Skill 4.6 Use Oracle Configuration Files
- Critical Skill 4.7 Use Administration Tools
- Critical Skill 4.8 Use Profiles
- Critical Skill 4.9 Network in a Multitiered Environment
- Chapter 4 Mastery Check
-
5 Backup and Recovery
- Critical Skill 5.1 Oracle Backup and Recovery Fundamentals
- Critical Skill 5.2 Learn about Oracle User-Managed Backup and Recovery
- Critical Skill 5.3 Write a Database Backup
- Critical Skill 5.4 Back Up Archived Redo Logs
- Critical Skill 5.5 Get Started with Oracle Data Pump
- Critical Skill 5.6 Use Oracle Data Pump Export
- Critical Skill 5.7 Work with Oracle Data Pump Import
- Critical Skill 5.8 Use Traditional Export and Import
- Critical Skill 5.9 Get Started with Recovery Manager
- Chapter 5 Mastery Check
-
6 PL/SQL
- Critical Skill 6.1 Define PL/SQL and Why We Use It
- Critical Skill 6.2 Describe the Basic PL/SQL Program Structure
- Critical Skill 6.3 Define PL/SQL Data Types
- Critical Skill 6.4 Write PL/SQL Programs in SQL*Plus
- Critical Skill 6.5 Handle Error Conditions in PL/SQL
- Critical Skill 6.6 Include Conditions in Your Programs
- Critical Skill 6.7 Create Stored Procedures—How and Why
- Critical Skill 6.8 Create and Use Functions
- Critical Skill 6.9 Call PL/SQL Programs
- Chapter 6 Mastery Check
-
7 Java
- Java Server Fundamentals
- Critical Skill 7.1 What Does Java Mean to an Oracle DBA?
-
Critical Skill 7.2 Overview of Java
- Platform Independence
- Java in All Three Tiers
- Java 2 Platform, Standard Edition
- Java 2 Platform, Enterprise Edition
- The J2EE Server
- Different Types of Java Programs
- Standalone Applications
- Applets
- JavaBeans
- JavaServer Pages and Servlets
- Enterprise JavaBeans
- Advantages of N-Tiered Architectures
- Java, XML, Web Services, and Oracle 10g
- Opportunities for Oracle DBAs
- Critical Skill 7.3 Configure Java for Oracle
- Critical Skill 7.4 Java in Oracle
- Critical Skill 7.5 JDBC Drivers
- Critical Skill 7.6 Use JDBC
- Critical Skill 7.7 Use SQLJ
- Critical Skill 7.8 Java-Stored Procedures
- Critical Skill 7.9 Create Java Objects in Oracle
- Critical Skill 7.10 Understand Oracle Java Products
- Chapter 7 Mastery Check
-
8 XML
- Critical Skill 8.1 Understand XML
- Critical Skill 8.2 XML DB: Use XML in the Database
- Critical Skill 8.3 SQLX: Create XML from Data Stored in Oracle
- Critical Skill 8.4 Store XML in Oracle XML DB
- Critical Skill 8.5 Use Simple Queries
- Critical Skill 8.6 Create a Relational View from XML
- Critical Skill 8.7 Learn Programmatic Access Using XSLT
- Chapter 8 Mastery Check
-
9 Large Database Features
- Critical Skill 9.1 What Is a Large Database?
- Critical Skill 9.2 Why and How to Use Data Partitioning
- Critical Skill 9.3 Compress Your Data
- Critical Skill 9.4 Use Parallel Processing to Improve Performance
- Critical Skill 9.5 Use Materialized Views
- Critical Skill 9.6 Real Application Clusters: A Primer
- Critical Skill 9.7 Automatic Storage Management: Another Primer
- Critical Skill 9.8 Grid Computing: The “g “in Oracle Database 10g
- Critical Skill 9.9 Use SQL Aggregate and Analysis Functions
- Critical Skill 9.10 Create SQL Models
- Project 9-2 Using Analytic SQL Functions and Models
- Chapter 9 Mastery Check
- A Mastery Check Answers
- Index
Product information
- Title: Oracle Database 10g: A Beginner's Guide
- Author(s):
- Release date: April 2004
- Publisher(s): McGraw Hill Computing
- ISBN: 9780071706773
You might also like
book
Oracle Database 10g The Complete Reference
Get a thorough understanding of Oracle Database 10 g from the most comprehensive Oracle database reference …
book
Hands-On Oracle Database 10g Express Edition for Windows
The fastest way to get up and running on Oracle Database XE Take full advantage of …
book
Oracle Database 10g DBA Handbook
Everything a DBA needs to know in one volume--this is the must-have reference for anyone working …
book
Oracle® Database 10g Insider Solutions
Oracle Database 10g Insider Solutions is a must-have reference guide for all Oracle professionals. It provides …