OCP Developer PL/SQL Program Units Exam Guide

OCP Developer PL/SQL Program Units Exam Guide

Author: Steve O'Hearn

Publisher: McGraw Hill Professional

Published: 2002

Total Pages: 536

ISBN-13: 9780072193367

DOWNLOAD EBOOK

This is the only authorized Oracle exam preparation for the developer PL/SQL program Units certification exam, complete with 400 practice questions, two-minute drills and self-tests.


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

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

Author: Matthew Morris

Publisher: Createspace Independent Publishing Platform

Published: 2012-07-10

Total Pages: 0

ISBN-13: 9781478217992

DOWNLOAD EBOOK

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.


SQL Fundamentals

SQL Fundamentals

Author: John J. Patrick

Publisher: Prentice Hall

Published: 2002

Total Pages: 870

ISBN-13:

DOWNLOAD EBOOK

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.


Oracle PL/SQL Programming

Oracle PL/SQL Programming

Author: Steven Feuerstein

Publisher: "O'Reilly Media, Inc."

Published: 2002

Total Pages: 1028

ISBN-13: 9780596003814

DOWNLOAD EBOOK

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


Oracle 12c: SQL

Oracle 12c: SQL

Author: Joan Casteel

Publisher: Cengage Learning

Published: 2015-09-08

Total Pages: 0

ISBN-13: 9781305251038

DOWNLOAD EBOOK

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.


OCP Java SE 6 Programmer Practice Exams (Exam 310-065)

OCP Java SE 6 Programmer Practice Exams (Exam 310-065)

Author: Bert Bates

Publisher: McGraw Hill Professional

Published: 2010-11-22

Total Pages: 448

ISBN-13: 0071702865

DOWNLOAD EBOOK

Don't Let the Real Test Be Your First Test! Written by two of the lead developers of the Java SE Programmer Exam, OCP Java SE 6 Programmer Practice Exams is filled with more than 260 realistic practice questions to prepare you for this challenging exam. To help you understand this material, in-depth explanations of both the correct and incorrect answers are included for every question. This practical guide covers all official objectives for Exam 310-065 and is the perfect companion to SCJP Sun Certified Programmer for Java 6 Study Guide. Covers all OCP Java SE 6 Programmer exam topics, including: Declarations and Access Control Object Orientation Assignments Operators Flow Control, Exceptions, and Assertions Strings, I/O, Formatting, and Parsing Generics and Collections Inner Classes Threads Development


OCE Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047)

OCE Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047)

Author: Steve O'Hearn

Publisher: McGraw Hill Professional

Published: 2009-11-22

Total Pages: 796

ISBN-13: 0071614222

DOWNLOAD EBOOK

A Fully Integrated Study System for OCA Exam 1Z0-047 Prepare for the Oracle Certified Associate SQL Certified Expert exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, and a two-minute drill 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 objectives for exam 1Z0-047, including: DDL and SQL SELECT statements Manipulating, restricting, and sorting data Single-row and group functions Subqueries Schema objects Set operators Data dictionary views Large data sets Hierarchical retrieval Regular expression support User access control And more On the CD-ROM: One full practice exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available with free online registration For a complete list of Oracle Press titles, visit www.OraclePressBooks.com


OCA: Oracle Database 12c Administrator Certified Associate Study Guide

OCA: Oracle Database 12c Administrator Certified Associate Study Guide

Author: Biju Thomas

Publisher: John Wiley & Sons

Published: 2014-05-12

Total Pages: 1238

ISBN-13: 111864395X

DOWNLOAD EBOOK

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.


Oracle Advanced PL/SQL Developer Professional Guide

Oracle Advanced PL/SQL Developer Professional Guide

Author: Saurabh K. Gupta

Publisher: Packt Publishing Ltd

Published: 2012-01-01

Total Pages: 647

ISBN-13: 1849687234

DOWNLOAD EBOOK

This book is packed with real world examples that cover all the advanced features of PL/SQL. In turn, each major certification topic is covered in a separate chapter that makes understanding concepts easier. At the end of each chapter, you will find plenty of practice questions to strengthen and test your learning.If you are a PL/SQL developer looking for deeper insight and a move from mid-level programmer to professional database developer, then this is the best guide for you. This book is also an ideal guide for all the Associate level PL/SQL programmers who are preparing for the Professional 1Z0-146 certification. This book assumes you have prior knowledge of PL/SQL programming.


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

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

Author: John Watson

Publisher: McGraw Hill Professional

Published: 2008-05-15

Total Pages: 770

ISBN-13: 0071591036

DOWNLOAD EBOOK

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