Oracle 10g Database Administrator II

Backup/recovery & Network Administration

Author: Claire Rajan

Publisher: Cengage Learning

ISBN: 1418836648

Category: Computers

Page: 627

View: 6859

DOWNLOAD NOW »

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

Expert Oracle9i Database Administration

Author: Sam Alapati

Publisher: Apress

ISBN: 1430207736

Category: Computers

Page: 1248

View: 4389

DOWNLOAD NOW »

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

SQL in 10 Minutes, Sams Teach Yourself

Author: Ben Forta

Publisher: Sams Publishing

ISBN: 013304808X

Category: Computers

Page: 256

View: 7034

DOWNLOAD NOW »

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
Release

Sams Teach Yourself SQL in 10 Minutes

Author: Ben Forta

Publisher: Pearson Education

ISBN: 0672336073

Category: Computers

Page: 274

View: 4714

DOWNLOAD NOW »

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

Oracle Administration and Management

Author: Michael R. Ault

Publisher: John Wiley & Sons

ISBN: 0471274771

Category: Computers

Page: 1008

View: 9174

DOWNLOAD NOW »

Many databases are large and complex, making them very difficult to manage. In turn, data can become difficult to access, expensive to store, and even damaged or destroyed. Oracle 9i offers new functionality for the Oracle database system, ensuring that the database runs quickly, efficiently, and reliably. Shows the best techniques, tips, and tools for Oracle systems New edition focuses on the 9i version, but also covers releases 8 and 8i since many organizations still support these versions Companion Web site includes all of the software scripts to manage a database, plus links to lite and demo versions of database management software and other DBA tools
Release

OCA Oracle Application Server 10g Administrator Exam Guide (Exam 1Z0-311)

OCA Oracle 10 App Server EG

Author: Sam R. Alapati

Publisher: McGraw-Hill Professional

ISBN: 0072262710

Category: Computers

Page: 539

View: 8172

DOWNLOAD NOW »

A Comprehensive, Fully Integrated Study System Prepare for the Oracle Certified Administrator Oracle Application Server 10g exam with help from this exclusive Oracle Press guide. Get complete coverage of all topics on the exam 1Z0-311, including installation, configuration, and management of Oracle Application Server 10g, as well as details on Oracle Internet Directory, Oracle HTTP Server, Oracle Single Sign-On Server, Oracle Portal, Oracle Application Server Containers for J2EE (OC4J), and Oracle Web Cache. In each chapter, you’ll find certification objectives, examples, a two-minute drill, and a self-test to highlight what you’ve learned. This book and CD-ROM package is the most comprehensive preparation tool available for this OCA exam. Ideal as both an exam guide and an on-the-job Oracle Application Server 10g reference All official Oracle OCA objectives for exam 1Z0-311 are covered in detail Two-minute drills reinforce knowledge Exam Readiness checklist at the front of the book--you’re ready for the exam when all objectives on the list are checked off 200+ simulated exam questions match the format, topics, and difficulty of the real exam On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration
Release

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: 1364

DOWNLOAD NOW »

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
Release

Oracle Database 10g Linux Administration

Author: Edward Whalen

Publisher: McGraw Hill Professional

ISBN: 9780072230536

Category: Computers

Page: 465

View: 627

DOWNLOAD NOW »

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

Oracle Database 10g DBA Handbook

Author: Kevin Loney,Bob Bryla

Publisher: McGraw Hill Professional

ISBN: 9780071770439

Category: Computers

Page: 736

View: 8612

DOWNLOAD NOW »

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