Oracle 10g Database Administrator II

Backup/recovery & Network Administration

Author: Claire Rajan

Publisher: Cengage Learning

ISBN:

Category: Computers

Page: 627

View: 822

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:

Category: Computers

Page: 1248

View: 659

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.

Tru64 UNIX-Oracle9i Cluster Quick Reference

Author: Tim Donar

Publisher: Digital Press

ISBN:

Category: Computers

Page: 298

View: 934

This quick reference provides step-by-step instructions on setting up Oracle9i RAC to run on a Tru64 UNIX cluster. Configuration information is included from start to finish. Command summary guides are built into each chapter for quick information retrieval. Examples and concise instructions assist in the complete installation of Tru64 UNIX 5.1A and Oracle9i. Designed as an introduction to Tru64 UNIX and Oracle9i RAC, Tru64 UNIX-Oracle9i Cluster Quick Reference will give intermediate and advanced administrators an invaluable resource for quickly locating vital information. Until now, setting up a Tru64 UNIX cluster running Oracle9i would involve referencing information from an entire shelf of books. Organizing this information into one source, Tru64 UNIX-Oracle9i Cluster Quick Reference simplifies the task of installation and makes a quick start possible with clear instructions and graphic illustrations. Command summary guides in each chapter serve as keys for fast information retrieval. Knowledge from over thirty references is distilled into this single book, seamlessly linking subject to subject for greatly simplified, quick installations. - Hardware Configuration Tips - StorageWorks HSG80 Setup Steps - UNIX Installation and Cluster Configuration - LSM/AdvFS Examples - Oracle9i RAC Installation, Database Configuration - Performance Tuning Tools, Backup, and Recovery

Oracle9i Database Administrator

Implementation and Administration

Author: Carol McCullough-Dieter

Publisher: Course Technology Ptr

ISBN:

Category: Computers

Page: 539

View: 633

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).

SQL in 10 Minutes, Sams Teach Yourself

Author: Ben Forta

Publisher: Sams Publishing

ISBN:

Category: Computers

Page: 256

View: 840

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

Sams Teach Yourself SQL in 10 Minutes

Author: Ben Forta

Publisher: Pearson Education

ISBN:

Category: Computers

Page: 274

View: 434

Explains how to use Structured Query Language to work within a relational database system, including information retrieval, security, data manipulation, and user management.

Oracle Enterprise Manager 101

Author: Lars Bo Vanting

Publisher: McGraw-Hill Osborne Media

ISBN:

Category: Computers

Page: 556

View: 527

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.

Oracle9i Development by Example

Author: Dan Hotka

Publisher: Que Publishing

ISBN:

Category: Computers

Page: 620

View: 978

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.

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

Author: John Watson

Publisher: McGraw Hill Professional

ISBN:

Category: Computers

Page: 1072

View: 201

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