Expert Oracle9i Database Administration, 2 Teile

This is the only real Oracle9i database administration book in the market! This 1,000+ page book enables a beginner or intermediate level Oracle DBA or Oracle developer/manager to master the art of building and managing complex Oracle9i databases. Expert Oracle9i Database Administration is thorough in covering all aspects of the 9i database, and includes a UNIX primer as well as an introduction to SQL and PL/SQL. Author Sam Alapati covers the entire spectrum of the new Oracle9i RDBMS software and clearly explains how to use all of its powerful features.
Currently there is no one book that includes the necessary UNIX administration, Windows NT management, and SQL backgrounds and the necessary database administration principles. This book fills that gap well, by providing all the necessary material in one comprehensive volume.
It takes several courses as well as mastery of several Oracle manuals to become a proficient database administrator. Readers will be able to become expert Oracle Database administrators by using this book. Expert Oracle9i Database Administration is designed to be the most complete Oracle9i database text available.

List of contents

One Database Basics, Data Modeling, and UNIX/Linux.- 1 The Oracle DBA's World.- 2 Relational Database Modeling and Database Design.- 3 Essential UNIX (and Linux) for the Oracle DBA.- Two The Oracle RDBMS.- 4 Installing the Oracle9i RDBMS.- 5 Introduction to the Oracle9i Architecture.- 6 Using SQL*Plus and iSQL*Plus.- 7 Schema Management in Oracle9i.- 8 Oracle Transaction Management.- Three Database Creation, Connectivity, and User Management.- 9 Creating an Oracle Database.- 10 Connectivity and Networking.- 11 User Management and Database Security.- Four Data Loading, Backup, and Recovery.- 12 Loading and Transforming Data.- 13 Using the Export and Import Utilities.- 14 Backing Up Databases.- 15 Database Recovery.- Five Managing the Operational Oracle Database.- 16 Managing the Operational Database.- 17 Using Oracle9i Enterprise Manager.- Six Performance Tuning and Troubleshooting the Production Database.- 18 Improving Database Performance: SQL Query Optimization.- 19 Performance Tuning: Tuning the Instance.- 20 The Oracle Data Dictionary and the Dynamic Performance Views.- 21 Using Oracle PL/SQL Packages.- 22 Managing Oracle Databases on Windows and Linux Systems.- Appendix A Brief Oracle9i SQL and PL/SQL Primer.- The Oracle9i Sample Schemas.- Basic SQL.- The Select Statement.- The Insert Statement.- The Delete Statement.- The Update Statement.- Filtering Data.- Sorting the Results of a Query.- The Order By Clause.- Sorting Order.- Sorting by Multiple Columns.- Operators.- Comparison Operators.- Logical Operators.- The Set Operators.- SQL Functions.- Single-Row Functions.- Aggregate Functions.- Number and Date Functions.- General Functions and Conditional Expressions.- SQL Analytical Functions.- Hierarchical Retrieval of Data.- Selecting Data from Multiple Tables.-The Cartesian Product.- The Four Types of Oracle Joins.- Grouping Operations.- Nesting Group Functions.- The Group By Clause with a Rollup Operator.- The Group By Clause with a Cube Operator.- The Group By Clause with a Grouping Operator.- The Group By Clause with a Grouping Sets Operator.- The Having Clause.- Writing Subqueries.- Top N Analysis.- Single-Row Subqueries.- Multiple-Row Subqueries.- Multiple-Column Subqueries.- Advanced Subqueries.- The Exists and Not Exists Operators.- Abstract Data Types.- The Create Type Command.- Object Tables.- Collections.- Type Inheritance.- The Cast Operator.- Using PL/SQL.- The Basic PL/ SQL Block.- Declaring Variables.- Writing Executable Statements.- Handling Errors.- PL/SQL Control Structures.- Conditional Control.- PL/ SQL Looping Constructs.- Cursors.- Implicit Cursors.- Explicit Cursors.- Cursor Attributes.- Cursor For Loops.- PL/ SQL Records.- Cursor Variables.- Functions.- Packages.- Oracle XML DB.- Storing XML in Oracle XML DB.- The Oracle XML DB Repository.- Setting Up an XML Schema.- Creating a Relational View from an XML Document.- Using Java with Oracle.- Summary.

About the author

Sam Alapati is an Oracle DBA for the Boy Scouts of America, working at their national office in Los Colinas, Texas. Prior to this, Sam worked at Sabre, NBC as well as Oracle Corporation as a Senior Principal Consultant in New York City. Sam has previously published Expert Oracle9i Database Administration, Expert Oracle Database 10g Administration, Oracle Database 11g RMAN Recipes(with Darl Kuhn and Arup Nanda) and Oracle Database 11g New Features(with Charles Kim), all for Apress, as well as two Oracle Certified Professional (OCP) certification books for Oracle Press. Sam has been working with relational databases since 1985, starting with the Ingres database. Sam holds the OCP certification for Oracle DBAs as well as the HP-UX System Administrator certification.

Summary

This is the only real Oracle9i database administration book in the market! This 1,000+ page book enables a beginner or intermediate level Oracle DBA or Oracle developer/manager to master the art of building and managing complex Oracle9i databases. Expert Oracle9i Database Administration is thorough in covering all aspects of the 9i database, and includes a UNIX primer as well as an introduction to SQL and PL/SQL. Author Sam Alapati covers the entire spectrum of the new Oracle9i RDBMS software and clearly explains how to use all of its powerful features.

Currently there is no one book that includes the necessary UNIX administration, Windows NT management, and SQL backgrounds and the necessary database administration principles. This book fills that gap well, by providing all the necessary material in one comprehensive volume.

It takes several courses as well as mastery of several Oracle manuals to become a proficient database administrator. Readers will be able to become expert Oracle Database administrators by using this book. Expert Oracle9i Database Administration is designed to be the most complete Oracle9i database text available.

Product details

• Authors: Sam Alapati, Sam R. Alapati, Martin Reid, Martin W. P. Reid
• Publisher: Springer, Berlin
• Languages: English
• Product format: Paperback / Softback
• Released: 01.01.2003
• EAN: 9781590590225
• ISBN: 978-1-59059-022-5
• No. of pages: 1248
• Dimensions: 178 mm x 55 mm x 235 mm
• Illustrations: LXXXIV, 1248 p. 127 illus. In 2 volumes, not available separately.
• Series: The Expert's Voice; The Expert's Voice
• Subjects: Natural sciences, medicine, IT, technology > IT, data processing > IT; B, Software Engineering, Database Management, Software Engineering/Programming and Operating Systems, database programming, Operating systems, Professional and Applied Computing