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

Author: Matthew Morris
Publisher: Createspace Independent Publishing Platform
ISBN: 9781478217992
Category :
Languages : en
Pages : 0

Book Description
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: Introduction to Oracle9i SQL Study Guide

Author: Chip Dawes
Publisher: John Wiley & Sons
ISBN: 0782152503
Category : Computers
Languages : en
Pages : 611

Book Description
Here's the book you need to prepare for Exam 1Z0-007: Introduction to Oracle9i: * In-depth coverage of official exam objectives * Practical information on using SQL in a real-world Oracle9i environment * Hundreds of challenging review questions, in the book and on the CD Authoritative coverage of all exam objectives, including: * Writing basic SQL SELECT statements * Restricting and sorting data * Displaying data from multiple tables * Aggregating data using group functions * Producing readable output with iSQL*Plus * Creating and managing tables * Controlling user access

Oracle PL/SQL Programming

Author: Steven Feuerstein
Publisher: "O'Reilly Media, Inc."
ISBN: 9780596003814
Category : Computers
Languages : en
Pages : 1028

Book Description
The authors have revised and updated this bestseller to include both the Oracle8i and new Oracle9i Internet-savvy database products.

SQL Fundamentals

Author: John J. Patrick
Publisher: Prentice Hall
ISBN:
Category : Computers
Languages : en
Pages : 870

Book Description
Based on John Patrick's hands-on SQL IT professionals at the University of California, Berkeley, this book shows exactly how to retrieve the data you want, when you need it, in any application. This 2nd edition is completely updated to include Oracle 9i and Access 2000.

OCP: Oracle Certified Professional Java SE 8 Programmer II Study Guide

Author: Jeanne Boyarsky
Publisher: John Wiley & Sons
ISBN: 1119067901
Category : Computers
Languages : en
Pages : 720

Book Description
Complete, trusted preparation for the Java Programmer II exam 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. With full coverage of 100% of exam objectives, this invaluable guide reinforces what you know, teaches you what you don't know, and gives you the hands-on practice you need to boost your skills. Written by expert Java developers, this book goes beyond mere exam prep with the insight, explanations and perspectives that come from years of experience. 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. Java 8 represents the biggest changes to the language to date, and the latest exam now requires that you demonstrate functional programming competence in order to pass. This guide has you covered, with clear explanations and expert advice. 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, OCP: Oracle Certified Professional Java SE 8 Programmer II Study Guide is your ideal companion on the road to certification.

OCA Oracle Application Server 10g Administration I Study Guide

Author: Bob Bryla
Publisher: John Wiley & Sons
ISBN: 0470104422
Category : Computers
Languages : en
Pages : 558

Book Description
Complete coverage of the exam objectives, hands-on exercises, review questions, and more, this is the first and only book to offer such in-depth coverage of this challenging exam Takes into consideration that candidates must not only know how to install and configure Oracle Application Server 10g, but how to use the robust tool set, including Oracle HTTP Server and OracleAS Portal The book features an interactive CD-ROM, including the Sybex Test Engine with chapter review questions and bonus exams, a series of flash cards that can be used on a PC or handheld, and an e-version of the book Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

OCP: Oracle 10g New Features for Administrators Study Guide

Author: Bob Bryla
Publisher: John Wiley & Sons
ISBN: 0782150853
Category : Computers
Languages : en
Pages : 574

Book Description
Here's the book you need to prepare for Oracle's 10g upgrade exam, Oracle Database 10g: New Features for Administrators (1Z0-040). This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years, this book provides: Clear and concise information on the enhancements included in Oracle 10g Practical examples and insights drawn from the authors' real-world experiences Leading-edge exam preparation software, including a test engine and electronic flashcards You'll also find authoritative coverage of key exam topics, including: Installing and Configuring the Server Loading and Unloading Data Tuning Applications Supporting Analytical Applications Backing Up and Recovering Data Automating Data Storage Management Applying Security Policies Supporting Upgrade Paths to Oracle 10g Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Oracle 12c: SQL

Author: Joan Casteel
Publisher: Cengage Learning
ISBN: 9781305251038
Category : Computers
Languages : en
Pages : 0

Book Description
Introduce the latest version of the fundamental SQL language used in all relational databases today with Casteel’s ORACLE 12C: SQL, 3E. Much more than a study guide, this edition helps those who have only a basic knowledge of databases master the latest SQL and Oracle concepts and techniques. Learners gain a strong understanding of how to use Oracle 12c SQL most effectively as they prepare for the first exam in the Oracle Database Administrator or Oracle Developer Certification Exam paths. This edition initially focuses on creating database objects, including tables, constraints, indexes, sequences, and more. The author then explores data query techniques, such as row filtering, joins, single-row functions, aggregate functions, subqueries, and views, as well as advanced query topics. ORACLE 12C: SQL, 3E introduces the latest features and enhancements in 12c, from enhanced data types and invisible columns to new CROSS and OUTER APPLY methods for joins. To help readers transition to further studies, appendixes introduce SQL tuning, compare Oracle's SQL syntax with other databases, and overview Oracle connection interface tools: SQL Developer and SQL Plus. Readers can trust ORACLE 12C: SQL, 3E to provide the knowledge for Oracle certification testing and the solid foundation for pursuing a career as a successful database administrator or developer. Important Notice: Media content referenced within the product description or the product text may not be available in the ebook version.

OCA: Oracle Database 12c Administrator Certified Associate Study Guide

Author: Biju Thomas
Publisher: John Wiley & Sons
ISBN: 111864395X
Category : Computers
Languages : en
Pages : 1238

Book Description
An all-in-one study guide prepares you for the updated Oracle Certified Associate certification It's been nearly six years since Oracle updated its cornerstone database software, making the demand for a comprehensive study guide for the OCA 12c certification a top priority. This resource answers that demand. Packed with invaluable insight, chapter review questions, bonus practice exams, hundreds of electronic flashcards, and a searchable glossary of terms, this study guide prepares you for the challenging Oracle certification exams. Provides you with a solid understanding of restricting and sorting data Walks you through using conversion functions and conditional expressions Addresses displaying data from multiple tables, manipulating data, database maintenance, and database backups and recovery Explores the Oracle database architecture and discusses preparing the database environment, creating an Oracle database, and managing the Oracle instance Focuses on administering and implementing user security This must-have study guide thoroughly prepares you to take the dramatically updated Oracle 12c OCA exams.

OCA/OCP Java SE 7 Programmer I & II Study Guide (Exams 1Z0-803 & 1Z0-804)

Author: Kathy Sierra
Publisher: McGraw Hill Professional
ISBN: 0071771999
Category : Computers
Languages : en
Pages : 1094

Book Description
A complete update to the definitive, bestselling guide to the #1 certification for Java programmers Written and revised by the co-developers of the original SCJP exam and now published in the Oracle Press brand Includes two complete practice exams—250+ practice exam questions in book and via electronic content Replaces SCJP Sun Certified Programmer for Java Study Guide—150,000 copies sold