Vor Ort
Merkzettel Warenkorb
Produktbild: Expert Oracle9i Database Administration

Expert Oracle9i Database Administration

43,99 €

inkl. gesetzl. MwSt., Versandkostenfrei

Beschreibung

Produktdetails

Einband

Set mit diversen Artikeln

Erscheinungsdatum

15.04.2003

Abbildungen

LXXXIV, 127 illus. In 2 volumes, not available separately., schwarz-weiss Illustrationen

Verlag

Apress

Seitenzahl

1248

Maße (L/B/H)

23,5/19,1/6,8 cm

Gewicht

2373 g

Auflage

Softcover Reprint of the Original 1st edition

Sprache

Englisch

ISBN

978-1-59059-022-5

Beschreibung

Produktdetails

Einband

Set mit diversen Artikeln

Erscheinungsdatum

15.04.2003

Abbildungen

LXXXIV, 127 illus. In 2 volumes, not available separately., schwarz-weiss Illustrationen

Verlag

Apress

Seitenzahl

1248

Maße (L/B/H)

23,5/19,1/6,8 cm

Gewicht

2373 g

Auflage

Softcover Reprint of the Original 1st edition

Sprache

Englisch

ISBN

978-1-59059-022-5

Herstelleradresse

Libri GmbH
Europaallee 1
36244 Bad Hersfeld
DE

Email: gpsr@libri.de

Noch keine Bewertungen vorhanden

Verfassen Sie die erste Bewertung zu diesem Artikel

Helfen Sie anderen Kundinnen und Kunden durch Ihre Meinung.

Kundinnen und Kunden meinen

Bewertungen (0)
  • Produktbild: Expert Oracle9i Database Administration
  • 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.