Get Up to Speed for Oracle9i Administration Training Courses--Fast! Oracle9i DBA JumpStart gives you the solid grounding you need to approach Oracle certification with confidence: * Introduction to relational database concepts * Using basic SQL*Plus and iSQL*Plus commands * Understanding Oracle database functions * Using multiple tables * Restricting, sorting, and grouping data * Creating and maintaining a database * Using SQL*Plus reporting techniques * Creating and maintaining database objects * Setting up users and managing security * Configuring optimization * Creating backups * Troubleshooting

Developers and DBAs use Oracle SQL coding on a daily basis, whether for application development, finding problems, fine-tuning solutions to those problems, or other critical DBA tasks. Oracle SQL: Jumpstart with Examples is the fastest way to get started and to quickly locate answers to common (and uncommon) questions. It includes all the basic queries: filtering, sorting, operators, conditionals, pseudocolumns, single row functions, joins, grouping and summarizing, grouping functions, subqueries, composite queries, hierarchies, flashback queries, parallel queries, expressions and regular expressions, DML, datatypes (including collections), XML in Oracle, DDL for basic database objects such as tales, views and indexes, Oracle Partitioning, security, and finally PL/SQL.* Each of the hundreds of SQL code examples was tested on a working Oracle 10g database* Invaluable everyday tool that provides an absolute plethora of properly tested examples of Oracle SQL code* Authors have four decades of commercial experience between them as developers and database administrators

The world of IT is always evolving, but in every area there are stable, core concepts that anyone just setting out needed to know last year, needs to know this year, and will still need to know next year. The purpose of the Foundations series is to identify these concepts and present them in a way that gives you the strongest possible starting point, no matter what your endeavor. Oracle Database Foundations provides essential knowledge about installing, configuring, maintaining, and querying Oracle 9i and 10g databases. What you learn here will benefit you in the short term, as you acquire and practice your skills, and in the long term, as you use them. Topics covered include: Basic relational database concepts Reporting and querying using SQL*Plus and iSQL*Plus Creating and maintaining a database Managing user access and security Understanding Oracle database functions Using multiple tables in a query Restricting, sorting, and grouping data Optimizing database performance Creating backups Troubleshooting database errors

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Here's the book you need to prepare for Exam 1Z0-031: OCA/OCP: Oracle9i DBA Fundamentals I Study Guide In-depth coverage of official exam objectives Practical information on implementing and managing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: Understanding Oracle architecture and its main components Identifying DBA administrative tools Setting up password file authentications Creating and managing Initialization Parameter Files Configuring OMF Create a database using Oracle Database Configuration Assistant Creating a database manually Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Prepare to pass the OCP DBA Fundamentals I exam using this Oracle Press study guide. You’ll get complete coverage of all exam topics followed by practice questions and chapter summaries. The CD-ROM contains hundreds of practice exam questions in an adaptive format.

Oracle 8i is a database for the Windows NT/2000 platform. This book begins with looking at the fundamentals of the operating system and installation of Oracle 8i products on Windows NT/2000 and then goes on to cover intermediate and advanced topics such as: architecture: migration; clustering; parallel server; performance monitoring and troubleshooting; and using Oracle Enterprise Manager.