Oracle 10g Database Administrator II

Backup/recovery & Network Administration

Author: Claire Rajan

Publisher: Cengage Learning

ISBN: 1418836648

Category: Computers

Page: 627

View: 799

Oracle 10g Database Administrator II: Backup/Recovery uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator. This text drills down key tools and techniques for Oracle database backup, recovery and network administration and provides good preparation for the update Oracle certification exam, Database Fundamentals I (#1Z0-043). In addition to extensive review material, the end of chapter content also includes comprehensive coverage of the exam objectives and exam-like practice questions. This text is the perfect compliment to the Oracle 10g: Database Administrator: Implementation and Administration (DBA1) text and the 1Z0-042.

Expert Oracle9i Database Administration

Author: Sam Alapati

Publisher: Apress

ISBN: 1430207736

Category: Computers

Page: 1248

View: 9334

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 Oracle 9i databases.

Oracle9i Database Administrator

Implementation and Administration

Author: Carol McCullough-Dieter

Publisher: Course Technology Ptr

ISBN: 9780619159009

Category: Computers

Page: 539

View: 8131

Provides thorough instruction in the operations of an Oracle database using Oracle9i and prepares users for the Oracle certification exam, Database Fundamentals I (#1Z0-031).

Der Oracle DBA

Handbuch für die Administration der Oracle Database 12c

Author: Mirko Hotzy,Andrea Held,Marek Adar,Christian Antognini,Ronny Egner,Markus Flechtner,Angelika Gallwitz,Stefan Oehrli,Daniel Steiger

Publisher: Carl Hanser Verlag GmbH Co KG

ISBN: 3446444203

Category: Computers

Page: 832

View: 2708

Als Administrator der Oracle Database finden Sie in diesem Handbuch die ideale Unterstützung für die Herausforderungen Ihres Alltags. Hier hat sich eine Gruppe namhafter und praxiserfahrener Autoren zusammengetan, die gemeinsam 134 Jahre Erfahrung mit dieser Datenbank aufweisen und in den jeweiligen Kapiteln ihre Spezialgebiete darstellen. Die Autoren vermitteln Ihnen fundiertes Know-how sowie praktische Lösungen zu Themen wie Aufbau und Betrieb eines Datenbankservers, Administration und Monitoring, High Availability, Backup und Recovery, Security, Upgrade einer Datenbank und Optimierung. Zusätzlich finden Sie in diesem Handbuch neben einer Darstellung der Produkte und Features der Oracle Database 12c viele Beispiele, Praxistipps und Tricks, die Sie direkt in Ihre tägliche Arbeit integrieren können und die über Versionsgrenzen hinweg anwendbar sind. Im Internet finden Sie nicht nur die nützlichen Skripte des Buches, sondern auch wichtige Informationen, ideal aufbereitet.

SQL in 10 Minutes, Sams Teach Yourself

Author: Ben Forta

Publisher: Sams Publishing

ISBN: 013304808X

Category: Computers

Page: 256

View: 4056

Sams Teach Yourself SQL in 10 Minutes, Fourth Edition New full-color code examples help you see how SQL statements are structured Whether you're an application developer, database administrator, web application designer, mobile app developer, or Microsoft Office users, a good working knowledge of SQL is an important part of interacting with databases. And Sams Teach Yourself SQL in 10 Minutes offers the straightforward, practical answers you need to help you do your job. Expert trainer and popular author Ben Forta teaches you just the parts of SQL you need to know–starting with simple data retrieval and quickly going on to more complex topics including the use of joins, subqueries, stored procedures, cursors, triggers, and table constraints. You'll learn methodically, systematically, and simply–in 22 short, quick lessons that will each take only 10 minutes or less to complete. With the Fourth Edition of this worldwide bestseller, the book has been thoroughly updated, expanded, and improved. Lessons now cover the latest versions of IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, SQLite, MariaDB, and Apache Open Office Base. And new full-color SQL code listings help the beginner clearly see the elements and structure of the language. 10 minutes is all you need to learn how to... Use the major SQL statements Construct complex SQL statements using multiple clauses and operators Retrieve, sort, and format database contents Pinpoint the data you need using a variety of filtering techniques Use aggregate functions to summarize data Join two or more related tables Insert, update, and delete data Create and alter database tables Work with views, stored procedures, and more Table of Contents 1 Understanding SQL 2 Retrieving Data 3 Sorting Retrieved Data 4 Filtering Data 5 Advanced Data Filtering 6 Using Wildcard Filtering 7 Creating Calculated Fields 8 Using Data Manipulation Functions 9 Summarizing Data 10 Grouping Data 11 Working with Subqueries 12 Joining Tables 13 Creating Advanced Joins 14 Combining Queries 15 Inserting Data 16 Updating and Deleting Data 17 Creating and Manipulating Tables 18 Using Views 19 Working with Stored Procedures 20 Managing Transaction Processing 21 Using Cursors 22 Understanding Advanced SQL Features Appendix A: Sample Table Scripts Appendix B: Working in Popular Applications Appendix C : SQL Statement Syntax Appendix D: Using SQL Datatypes Appendix E: SQL Reserved Words

Oracle9i Development by Example

Author: Dan Hotka

Publisher: Que Publishing

ISBN: 9780789726711

Category: Computers

Page: 620

View: 8270

Learn the ins and outs of the Oracle9i development environment from product installation to advanced management configuration. Oracle 9i Development by Example provides coverage of everything from building, monitoring, and tuning an Oracle9i database to building forms and reports using developer 6i to understanding newer tools such as Log Miner in an easy to learn format.

Oracle Enterprise Manager 101

Author: Lars Bo Vanting,Dirk Schepanek

Publisher: McGraw-Hill Osborne Media

ISBN: 9780072223071

Category: Computers

Page: 556

View: 8658

Your Oracle career starts here! Ideal for those new to Oracle technology, this officially authorized guide explains in easy-to-follow detail how to administer an Oracle database using this state-of-the-art tool. Inside, you'll learn to eliminate, simplify, and automate administrative tasks and use Oracle Enterprise Manager (EM) as a management framework for your entire Oracle environment.

Oracle Database 10g Linux Administration

Author: Edward Whalen

Publisher: McGraw Hill Professional

ISBN: 9780072230536

Category: Computers

Page: 465

View: 8038

Install and configure Oracle Database 10g on a Linux enterprise platform. This book explains how to set up, administer, monitor, and tune Oracle Database 10g on Linux. You will also learn how to implement High Availability solutions as well as handle backup, recovery, and replication. This exclusive Oracle Press guide is the ideal resource for all Oracle DBAs working in a Linux environment.

SQL

kurz & gut ; [behandelt Oracle DB2, SQL Server & MySQL]

Author: Jonathan Gennick

Publisher: O'Reilly Verlag DE

ISBN: 9783897212688

Category:

Page: 171

View: 8667

OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063)

Author: John Watson,Roopesh Ramklass,Bob Bryla

Publisher: McGraw Hill Professional

ISBN: 0071828079

Category: Computers

Page: 1072

View: 5863

This Oracle Press certification exam guide prepares you for the new Oracle Database 12c certification track, including the core requirements for OCA and OCP certification. OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063) covers all of the exam objectives on the Installation and Administration, SQL Fundamentals, and Advanced Administration exams in detail. Each chapter includes examples, practice questions, Inside the Exam sections highlighting key exam topics, a chapter summary, and a two-minute drill to reinforce essential knowledge. 300+ practice exam questions match the format, topics, and difficulty of the real exam. Electronic content includes interactive practice exam software with hundreds of questions that include detailed answers and explanations, and a score report performance assessment tool Ideal as both exam guide and on-the-job reference The most comprehensive single preparation tool for the Oracle Database 12c OCA and OCP certification exams

OCP Oracle9i Database: Fundamentals II Exam Guide

Author: Rama Velpuri

Publisher: McGraw Hill Professional

ISBN: 9780072195439

Category: Computers

Page: 536

View: 8454

This is the only authorized Oracle certification exam preparation for Database Administration, Backup/Recovery, and Network Administration, developed in conjunction with Oracle University. Contains a step-by-step methodology.

Database Processing

Fundamentals, Design & Implementation

Author: David Kroenke

Publisher: N.A

ISBN: N.A

Category: Computers

Page: 702

View: 1991

This text integrates engaging Lived Experiences - extended examples that focus on various issues to illustrate chapter coverage. These extended examples are introduced with the social issue or application that opens each chapter and are then carried throughout the chapter in various boxes, features and exercises. The text also covers current social issues in 2003, along with its integration of race, class, gender and age perspectives. It includes diverse theoretical viewpoints, including feminist theory.

Guide to Oracle9i

Author: Joline Morrison,Mike Morrison

Publisher: Course Technology Ptr

ISBN: 9780619159597

Category: Computers

Page: 955

View: 4389

Provides comprehensive coverage of the database applications development using the latest release of the Oracle9i Database and Developer Suite.

Oracle Database 10g DBA Handbook

Author: Kevin Loney,Bob Bryla

Publisher: McGraw Hill Professional

ISBN: 9780071770439

Category: Computers

Page: 736

View: 5714

Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it’s been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.

Oracle9i DBA 101

Author: Marlene Theriault,Rachel Carmichael,James Viscusi

Publisher: McGraw Hill Professional

ISBN: 9780072224740

Category: Computers

Page: 550

View: 845

An updated handbook for new database administrators offers thorough coverage of the techniques, tools, and other essentials of managing an Oracle database, with discussion of the latest features of Oracle 9i and their applications, as well as a look at such important issues as server performance, security, and availability. Original. (Beginner)

Oracle9I Dba Handbook

Author: Kevin Loney,Marlene Theriault

Publisher: McGraw-Hill Osborne Media

ISBN: 9780072193749

Category: Computers

Page: 980

View: 7943

This authorized guide from Oracle Press explains how implement all the new features of Oracle9i and manage a robust, high-performance Oracle database. You'll get new and revised material on installation, database creation, using STATSPACK, Recovery Manager, Oracle9i Application Server, external tables, flashback queries, and much more.

OCA Oracle9i Associate DBA Certification Exam Guide

Author: Jason S. Couchman,Sudheer N. Marisetti

Publisher: McGraw-Hill Osborne Media

ISBN: 9780072225365

Category: Computers

Page: 1006

View: 4494

Full Coverage of exams 1Z0-007 and 1Z0-031! Prepare for the Oracle Certified Associate (OCA) exams with this exam guide from the exclusive publishers of Oracle Press books. This volume is comprised of OCP Introduction to Oracle9i: SQL Exam Guide and OCP Oracle9i Database: Fundamentals I Exam Guide. Books and CD-ROMs combined contain more than 600 practice questions and cover all objectives for OCA certification.

OCA: Oracle 10g Administration I Study Guide

Exam 1Z0-042

Author: Chip Dawes,Bob Bryla,Joseph C. Johnson,Matthew Weishan

Publisher: John Wiley & Sons

ISBN: 9780782150759

Category: Computers

Page: 672

View: 1692

Oracle Backup & Recovery 101

Author: Kenny Smith,Stephan Haisley

Publisher: McGraw-Hill Osborne Media

ISBN: 9780072194616

Category: Computers

Page: 487

View: 4466

This text introduces various methods for Oracle database backup and recovery. It includes backup and recovery exercises that can be practised at home which allows the reader to test their skills. Hands-on troubleshooting exercises show common issues that can occur during the backup and recovery process and chapter review questions and answers test reader's knowledge and comprehension.