OCA Oracle Database SQL Exam Guide (Exam 1Z0-071)

Author: Steve O'Hearn

Publisher: McGraw Hill Professional

ISBN: 1259584615

Category: Computers

Page: 832

View: 5209

DOWNLOAD NOW »
A fully updated, integrated self-study system for the Oracle Database SQL Exam This thoroughly revised Oracle Press guide offers 100% coverage of all objectives on the latest version of the Oracle Database SQL Exam. Ideal both as a study guide and on-the-job reference, OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) features detailed explanations, examples, practice questions, and chapter summaries. “Certification Objectives,” “Exam Watch,” and “On the Job” sections reinforce salient points throughout. You will gain access to two complete practice exams that match the tone, tenor, and format of the live test. Get complete coverage every topic on Exam 1Z0-071, including: • DDL and SQL SELECT statements • Manipulating, restricting, and sorting data • Single-row and group functions • Displaying data from multiple tables • Subqueries • Schema objects • Set operators • Grouping related data • Report creation • Data dictionary views • Large data sets • Hierarchical retrieval • Regular expression support • User access control The electronic includes: • Two full practice exams • Detailed answers and explanations

OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)

Author: John Watson

Publisher: McGraw Hill Professional

ISBN: 0071591036

Category: Computers

Page: 733

View: 3357

DOWNLOAD NOW »
A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11g Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements 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

Study Guide for 1z0-047

Oracle Database SQL Expert: Oracle Certification Prep

Author: Matthew Morris

Publisher: CreateSpace

ISBN: 9781475152432

Category: Computers

Page: 214

View: 4936

DOWNLOAD NOW »
This Study Guide is targeted at IT professionals who are looking to become an Oracle Database Certified SQL Expert. The book provides information covering all of the exam topics for the Oracle Expert exam: "1Z0-047: Oracle Database SQL Expert." This book has been updated to include the topics added to the exam for 12c. The books in the Oracle Certification Prep series are built in lockstep with the test topics provided by Oracle Education's certification program. Each book is intended to provide the information that will be tested in a clean and concise format. The guides introduce the subject you'll be tested on, follow that with the information you'll need to know for it, and then move on to the next topic. They contain no drills or unrealistic self-tests to bump the page count without adding value. The series is intended to provide a concentrated source of exam information that is compact enough to be read through multiple times. This series is ideal for experienced Oracle professionals that are familiar with the topic being tested, but want a means to rapidly reinforce their existing skills and bridge any gaps in their knowledge. It is also an excellent option as a second source of information for candidates pursuing certification.

OCA Oracle Solaris 11 System Administration Exam Guide (Exam 1Z0-821)

Author: Michael Ernest

Publisher: McGraw Hill Professional

ISBN: 0071775730

Category: Computers

Page: 768

View: 9623

DOWNLOAD NOW »
A Complete Study System for OCA Exam 1Z0-821 Prepare for the Oracle Certified Associate Oracle Solaris 11 System Administration exam with help from this exclusive Oracle Press guide. In each chapter, you’ll find challenging practice questions, a two-minute drill, and a chapter summary to highlight what you’ve learned. This authoritative resource will help you pass the test and will serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-821, including: Installing Oracle Solaris 11 Managing boot environments Understanding ZFS and other Oracle Solaris file systems Securing systems and files Managing users, groups, and processes Administering the Services Management Facility (SMF) Configuring additional storage Adding and updating Oracle Solaris software Monitoring the system with logging Administering process and kernel crash data Managing network resources Administering Oracle Solaris Zones Electronic content includes: Two practice exams with detailed answers and explanations

Oracle SQL Tricks and Workarounds

Expert Guide to Oracle SQL Excellence

Author: Zahar Hilkevich

Publisher: AuthorHouse

ISBN: 1463421354

Category: Computers

Page: 252

View: 8606

DOWNLOAD NOW »
This book introduces a relatively new approach to mastering one’s Oracle SQL skills. This book will teach you how to leverage your existing Oracle SQL knowledge as well as how you can benefit from a variety of SQL tricks and techniques we present thereafter. This is a text book rather than a reference, and it aims to teach you how to become a better SQL specialist. Even though the recommendations found in this book may be applied to a variety of SQL flavors, Oracle SQL is the main subject of this book. Our goal was not to impress you with clever tricks and sophisticated techniques, but rather give you a roadmap to excellence in writing Oracle SQL queries. No doubt, this book presents tricks and classy approaches, which still serve the main goal – to let you master your Oracle SQL skills.

OCP Developer PL/SQL Program Units Exam Guide

Author: Steve O'Hearn

Publisher: McGraw Hill Professional

ISBN: 0071712887

Category: Computers

Page: 499

View: 3335

DOWNLOAD NOW »
Prepare for the Oracle Certified Professional Developer PL/SQL Program Units exam using this Oracle Press study guide. Throughout each chapter, you’ll find in-depth details on all the material covered on this challenging exam, followed by practice questions and chapter summaries. The CD-ROM contains hundreds of practice exam questions in an adaptive format.

Oracle Big Data Handbook

Author: Tom Plunkett,Brian Macdonald,Bruce Nelson,Mark Hornick,Helen Sun,Keith Laker,Khader Mohiuddin,Debra Harding,Gokula Mishra,David Segleau,Robert Stackowiak

Publisher: McGraw Hill Professional

ISBN: 0071827269

Category: Computers

Page: 464

View: 6038

DOWNLOAD NOW »
"Cowritten by members of Oracle's big data team, [this book] provides complete coverage of Oracle's comprehensive, integrated set of products for acquiring, organizing, analyzing, and leveraging unstructured data. The book discusses the strategies and technologies essential for a successful big data implementation, including Apache Hadoop, Oracle Big Data Appliance, Oracle Big Data Connectors, Oracle NoSQL Database, Oracle Endeca, Oracle Advanced Analytics, and Oracle's open source R offerings"--Page 4 of cover.

Java WebSocket Programming

Author: Dr. Danny Coward

Publisher: McGraw Hill Professional

ISBN: 0071827188

Category: Computers

Page: 256

View: 7428

DOWNLOAD NOW »
Master Application Development with Java WebSocket Build dynamic enterprise Web applications that fully leverage state-of-the-art communication technologies. Written by the leading expert on Java WebSocket programming, this Oracle Press guide offers practical development strategies and detailed example applications. Java WebSocket Programming explains how to design client/server applications, incorporate full-duplex messaging, establish connections, create endpoints, handle path mapping, and secure data. You’ll also learn how to encrypt Web transmissions and enrich legacy applications with Java WebSocket. Develop Web applications using the Java WebSocket API Create and publish annotated and programmatic endpoints Manage the lifecycle events of WebSocket endpoints Maintain reliable connections across the endpoint lifecycle Manage synchronous and asynchronous messaging Define encoding and decoding strategies for complex messaging Configure message timeouts, size limits, and exceptions Map message paths and route incoming URIs to Web containers Secure data, authenticate users, and encrypt connections

OCA: Oracle Database 11g Administrator Certified Associate Study Guide

Exams1Z0-051 and 1Z0-052

Author: Biju Thomas

Publisher: John Wiley & Sons

ISBN: 1118059425

Category: Computers

Page: 1152

View: 1439

DOWNLOAD NOW »
Candidates for the Oracle Certified Associate in Oracle Database 11g need to pass Exams 1Z0-051 and 1Z0-052 to achieve their certification—this guide prepares you for taking both those exams. This two-in-one study guide covers the Oracle Certified Associate certification for Oracle database 11g and reviews exam topics such as restricting and sorting data, using conversion functions and conditional expressions, displaying data from multiple tables, and exploring the Oracle database architecture. Plus, you’ll learn how to create and maintain an Oracle database, perform database backups and recovery, move and manipulate data, prepare the database environment, and more. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file. For Instructors: Teaching supplements are available for this title.

OCA Oracle Database 11g SQL Fundamentals I Exam Guide

Exam 1Z0-051

Author: John Watson,Roopesh Ramklass

Publisher: McGraw Hill Professional

ISBN: 007164380X

Category: Computers

Page: 581

View: 1588

DOWNLOAD NOW »
A Fully Integrated Study System for OCA Exam 1Z0-051 Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-051, including: SQL SELECT statements Restricting and sorting data Single-row functions Conversion functions and conditional expressions Group functions Displaying data from multiple tables Subqueries Set operators DML and DDL statements Schema objects 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

Oracle Database 12c Release 2 Performance Tuning Tips & Techniques

Author: Richard Niemiec

Publisher: McGraw Hill Professional

ISBN: 1259589692

Category: Computers

Page: 848

View: 9839

DOWNLOAD NOW »
Proven Database Optimization Solutions―Fully Updated for Oracle Database 12c Release 2 Systematically identify and eliminate database performance problems with help from Oracle Certified Master Richard Niemiec. Filled with real-world case studies and best practices, Oracle Database 12c Release 2 Performance Tuning Tips and Techniques details the latest monitoring, troubleshooting, and optimization methods. Find out how to identify and fix bottlenecks on premises and in the cloud, configure storage devices, execute effective queries, and develop bug-free SQL and PL/SQL code. Testing, reporting, and security enhancements are also covered in this Oracle Press guide. • Properly index and partition Oracle Database 12c Release 2 • Work effectively with Oracle Cloud, Oracle Exadata, and Oracle Enterprise Manager • Efficiently manage disk drives, ASM, RAID arrays, and memory • Tune queries with Oracle SQL hints and the Trace utility • Troubleshoot databases using V$ views and X$ tables • Create your first cloud database service and prepare for hybrid cloud • Generate reports using Oracle’s Statspack and Automatic Workload Repository tools • Use sar, vmstat, and iostat to monitor operating system statistics

SQL Fundamentals

Author: John J. Patrick

Publisher: Prentice-Hall PTR

ISBN: 9780137126026

Category: Computers

Page: 803

View: 2013

DOWNLOAD NOW »
Third edition of the hands-on, real-world guide to mastering SQL through using the world's top two databases: Oracle and Microsoft Access.

OCP MySQL 5.6 Database Administrator All-in-One Exam Guide (Exam 1Z0-883)

Author: Steve O'Hearn

Publisher: McGraw-Hill Education

ISBN: 9780071775786

Category: Computers

Page: 816

View: 2766

DOWNLOAD NOW »
The only Oracle Press exam guide for Oracle OCP MySQL certification OCP MySQL 5.6 Database Administrator Exam Guide covers all of the exam objectives on the OCP level exam for MySQL DBAs in detail. You can become MySQL certified by passing OCP Exam 1Z0-883. This book prepares you for this highly technical exam and focuses on practitioner-level skills, covering a broad set of topics, including security, backup, replication, and optimization. Ideal as both an exam guide and on-the-job reference, each chapter of this Oracle Press book includes examples, practice questions, lab questions, and a chapter summary. An Exam Readiness Checklist appears at the front of the book—you’re ready for the exam when all objectives on the list are checked off. Two-minute drills at the end of the chapter reinforce knowledge. Inside the Exam sections in each chapter highlight key exam topics covered. 150+ exam questions match the format, topics, and difficulty of the real exam. Covers the single exam required to achieve OCP certification for Oracle MySQL—Exam 1Z0-883 Electronic content includes two interactive practice exams and a PDF copy of the book The electronic exams also feature an open-book mode with hints, references to the book, and detailed answers and explanations

Oracle Database 10g Real Application Clusters Handbook

Author: K Gopalakrishnan

Publisher: McGraw Hill Professional

ISBN: 0071632190

Category: Computers

Page: 421

View: 1137

DOWNLOAD NOW »
Learn cutting-edge technology from Oracle experts Written by Oracle insiders, this comprehensive guide covers everything you need to know about Real Application Clusters -- low-cost hardware platforms that can rival and exceed the quality of service, availability, and scalability of the most expensive mainframe systems. Concepts covered are applicable to all previous versions of Oracle Tuning and troubleshooting tips, providing insight on the most advanced diagnostics available Detailed coverage of advanced RAC concepts Working code for all examples available online

OCA Java SE 8 Programmer I Study Guide (Exam 1Z0-808)

Author: Edward G. Finegan,Robert Liguori

Publisher: McGraw Hill Professional

ISBN: 1259587533

Category: Computers

Page: 608

View: 4068

DOWNLOAD NOW »
The official study guide for the entry-level Oracle Certified Associate exam for Java Programmers—fully updated for Java SE 8 Confidently prepare for the OCA Java SE 8 Programmer I exam with this thoroughly revised, up-to-date guide from Oracle Press. Featuring step-by-step exercises, comprehensive chapter self-tests, and two complete downloadable practice exams, this volume provides an integrated, easy-to-follow study system based on a proven methodology. OCA Java SE 8 Programmer I Study Guide (Exam 1Z0-808) offers the most complete and in-depth coverage of all of the exam objectives, and also serves as an essential on-the-job reference for Java developers. You’ll have access to a total of more than 250 challenging practice questions that precisely mirror the content of the live exam—no other guide on the market provides the same level of accuracy and detail. Questions accurately simulate the type and style of questions found on the actual test Includes special “Exam Watch,” “Inside the Exam,” and “On the Job” sections Downloadable MAC and PC compatible test engine includes two complete practice exams

Study Guide for 1Z0-144: Oracle Database 11g: Program with PL/SQL

Oracle Certification Prep

Author: Matthew Morris

Publisher: CreateSpace

ISBN: 9781478217992

Category: Computers

Page: 178

View: 4532

DOWNLOAD NOW »
This Study Guide is targeted at IT professionals who are working towards becoming an Oracle Certified Associate in the PL/SQL developer track. The book provides information covering all of the exam topics for the Oracle certification exam: "1Z0-144: Oracle Database 11g: Program with PL/SQL." The books in the Oracle Certificaton Prep series are built in lockstep with the test topics provided by Oracle Education's certification program. Each book is intended to provide the information that will be tested in a clean and concise format. The guides introduce the subject you'll be tested on, follow that with the information you'll need to know for it, and then move on to the next topic. They contain no drills or unrealistic self-tests to bump the page count without adding value. The series is intended to provide a concentrated source of exam information that is compact enough to be read through multiple times. This series is ideal for experienced Oracle professionals that are familiar with the topic being tested, but want a means to rapidly reinforce their existing skills and bridge any gaps in their knowledge. It is also an excellent option as a second source of information for candidates pursuing certification.

OCA / OCP Java SE 8 Programmer Certification Kit

Exam 1Z0-808 and Exam 1Z0-809

Author: Jeanne Boyarsky,Scott Selikoff

Publisher: Sybex

ISBN: 9781119272090

Category: Computers

Page: N.A

View: 1330

DOWNLOAD NOW »
Your complete certification guide on the path to Oracle Java SE The Oracle Java SE Certification track now consists of three levels – Associate (OCA), Professional (OCP), and Master (OCM). This valuable kit helps you attain success at the OCA and OCP levels, providing clarification of the complex material along with plenty of practice that covers all exam objectives. OCA / OCP Oracle Java SE 8 Programmer Certification Kit is the ideal tool for preparing for the OCA and OCP exams. With two comprehensive study guides in one package, this kit serves as a helpful companion throughout your journey to Oracle Java SE 8 certification. The release of Java 8 brought the language's biggest changes to date, and for the first time, candidates are required to learn functional programming to pass the exam. The OCA: Oracle Certified Associate Java SE 8 Programmer I Study Guide has you covered, with thorough functional programming explanation and information on all key topic areas Java programmers need to know, covering one hundred percent of the material on Exam 1Z0-808. Once you're OCA certified, the OCP: Oracle Certified Professional Java SE 8 Programmer II Study Guide is your comprehensive companion for preparing for Exam 1Z0-809 as well as upgrade Exam 1Z0-810 and Exam 1Z0-813. You'll review the basics of object-oriented programming, understand functional programming, apply your knowledge to database work, and much more. From the basic to the advanced, this guide walks you through everything you need to know to confidently take the OCP 1Z0-809 exam (and upgrade exams 1Z0-810 and 1Z0-813). Work confidently with operators, conditionals, and loops Understand object-oriented design principles and patterns Master functional programming fundamentals Understand abstract classes, interfaces, and class design Learn object-oriented design principles and patterns Delve into functional programming, advanced strings, and localization Master IO, NIO, and JDBC with expert-led database practice If you're ready to take the next step in your IT career and tackle these challenging exams, OCA / OCP Oracle Java SE 8 Programmer Certification Kit is your ideal companion on the road to certification, and can give you the confidence you need.

HBase - The Definitive Guide

Random Access to Your Planet-Size Data

Author: Lars George

Publisher: N.A

ISBN: 9781492024262

Category: Computers

Page: 1300

View: 9311

DOWNLOAD NOW »
If you're looking for a scalable storage solution to accommodate a virtually endless amount of data, this updated edition shows you how Apache HBase can meet your needs. Modeled after Google's BigTable architecture, HBase scales to billions of rows and millions of columns, while ensuring that write and read performance remain constant. Fully revised for HBase 1.0, this second edition brings you up to speed on the new HBase client API, as well as security features and new case studies that demonstrate HBase use in the real world. Whether you just started to evaluate this non-relational database, or plan to put it into practice right away, this book has your back. Launch into basic, advanced, and administrative features of HBase's new client-facing API Use new classes to integrate HBase with Hadoop's MapReduce framework Explore HBase's architecture, including the storage format, write-ahead log, and background processes Dive into advanced usage, such extended client and server options Learn cluster sizing, tuning, and monitoring best practices Design schemas, copy tables, import bulk data, decommission nodes, and other tasks Go deeper into HBase security, including Kerberos and encryption at rest