• Author: Ian Abramson,Michael Abbey,Michael Corey
• Publisher: McGraw Hill Professional
• ISBN: 007160460X
• Category: Computers
• Page: 432
• View: 4511

DOWNLOAD NOW »
Get a Solid Foundation in Oracle Database Technology Master Oracle Database 11g fundamentals quickly and easily. Using self-paced tutorials, this book covers core database essentials, the role of the administrator, high availability, and large database features. Oracle Database 11g: A Beginner's Guide walks you, step by step, through database setup, administration, programming, backup, and recovery. In-depth introductions to SQL and PL/SQL are included. Designed for easy learning, this exclusive Oracle Press guide offers: Core Concepts--Oracle Database 11g topics presented in logically organized chapters Critical Skills--Lists of specific skills covered in each chapter Projects--Practical exercises that show how to apply the critical skills learned in each chapter Progress Checks--Quick self-assessment sections to check your progress Notes--Extra information related to the topic being covered Mastery Checks--Chapter-ending quizzes to test your knowledge

• Author: Ian Abramson,Michael Abbey,Michael Corey
• Publisher: McGraw Hill Professional
• ISBN: 9780071706773
• Category: Computers
• Page: 416
• View: 9815

DOWNLOAD NOW »
Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you’ll get the fundamentals applicable to all Oracle database releases.

From Novice to Professional

• Author: Iggy Fernandez
• Publisher: Apress
• ISBN: 1590599683
• Category: Computers
• Page: 464
• View: 7609

DOWNLOAD NOW »
This book, written by veteran Oracle database administrator Iggy Fernandez, a regular on the Oracle conference circuit and the editor of NoCOUG Journal, is a manageable introduction to key Oracle database administration topics including planning, installation, monitoring, troubleshooting, maintenance, and backups, to name just a few. As is clear from the table of contents, this book is not simply a recitation of Oracle Database features such as what you find in the reference guides available for free download on the Oracle web site. For example, the chapter on database monitoring explains how to monitor database availability, database changes, database security, database backups, database growth, database workload, database performance, and database capacity. The chapters of this book are logically organized into four parts that closely track the way your database administration career will naturally evolve. Part 1 gives you necessary background in relational database theory and Oracle Database concepts, Part 2 teaches you how to implement an Oracle database correctly, Part 3 exposes you to the daily routine of a database administrator, and Part 4 introduces you to the fine art of performance tuning. Each chapter has exercises designed to help you apply the lessons of the chapter. Each chapter also includes a list of reference works that contain more information on the topic of the chapter. In this book, you'll find information that you won't find in other books on Oracle Database. Here you'll discover not only technical information, but also guidance on work practices that are as vital to your success as technical skills. The author's favorite chapter is "The Big Picture and the Ten Deliverables." If you take the lessons in that chapter to heart, you can quickly become a much better Oracle database administrator than you ever thought possible. What you’ll learn Theory of relational database management systems Oracle Database internals Licensing, architecture, and sizing Software installation and database creation Using indexes to improve performance User management and data loading How to monitor all aspects of your database How to solve and fix problems Database backups and database recovery Database maintenance Database tuning SQL tuning Who this book is for If you are an IT professional who has been thrust into an Oracle database administration role without the benefit of formal training, or you just want to understand how Oracle Database works, this book is for you. It's the book the author wishes he'd had when he first started using Oracle Database many years ago. It's the book that he would have liked to have given to the many IT colleagues and friends who, over the years, have asked him to teach them the basics of Oracle Database.

• Author: Emre Baransel
• Publisher: Packt Publishing Ltd
• ISBN: 1849687919
• Category: Computers
• Page: 404
• View: 2279

DOWNLOAD NOW »
Using real-world examples and hands-on tasks, Oracle Data Guard 11gR2 Administration Beginner's Guide will give you a solid foundation in Oracle Data Guard. It has been designed to teach you everything you need to know to successfully create and operate Data Guard environments with maximum flexibility, compatibility, and effectiveness.If you are an Oracle database administrator who wants to configure and administer Data Guard configurations, then "Oracle Data Guard 11gR2 Administration Beginner's Guide" is for you. With a basic understanding of Oracle database administration, you'll be able to easily follow the book.

A Hands-On Tutorial

• Author: David Hecksel,Bernard Wheeler
• Publisher: Packt Publishing Ltd
• ISBN: 1849680698
• Category: Computers
• Page: 384
• View: 5602

DOWNLOAD NOW »
Combine high volume data movement, complex transformations and real-time data integration with the robust capabilities of ODI in this practical guide.

• Author: Bob Bryla
• Publisher: McGraw Hill Professional
• ISBN: 007179879X
• Category: Computers
• Page: 704
• View: 9044

DOWNLOAD NOW »
The definitive reference for every Oracle DBA—completely updated for Oracle Database 12c Oracle Database 12c DBA Handbook is the quintessential tool for the DBA with an emphasis on the big picture—enabling administrators to achieve effective and efficient database management. Fully revised to cover every new feature and utility, this Oracle Press guide shows how to harness cloud capability, perform a new installation, upgrade from previous versions, configure hardware and software, handle backup and recovery, and provide failover capability. The newly revised material features high-level and practical content on cloud integration, storage management, performance tuning, information management, and the latest on a completely revised security program. Shows how to administer a scalable, flexible Oracle enterprise database Includes new chapters on cloud integration, new security capabilities, and other cutting-edge features All code and examples available online

• Author: Michael McLaughlin
• Publisher: McGraw-Hill Prof Med/Tech
• ISBN: 0071768858
• Category: Computers
• Page: 608
• View: 5814

DOWNLOAD NOW »
Master Application Development in a Mixed-Platform Environment Build powerful database applications in a mixed environment using the detailed information in this Oracle Press guide. Oracle Database 11g & MySQL 5.6 Developer Handbook lays out programming strategies and best practices for seamlessly operating between the two platforms. Find out how to migrate databases, port SQL dialects, work with Oracle MySQL databases, and configure effective queries. Security, monitoring, and tuning techniques are also covered in this comprehensive volume. Understand Oracle Database 11g and MySQL 5.6 architecture Convert databases between platforms and ensure transactional integrity Create tables, sequences, indexes, views, and user accounts Build and debug PL/SQL, SQL*Plus, SQL/PSM, and MySQL Monitor scripts Execute complex queries and handle numeric and date mathematics Merge data from source tables and set up virtual directories

• Author: Michael McLaughlin
• Publisher: McGraw Hill Professional
• ISBN: 0071643567
• Category: Computers
• Page: 835
• View: 7293

DOWNLOAD NOW »
Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You'll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance. Create, debug, and manage Oracle-driven PL/SQL programs Use PL/SQL structures, delimiters, operators, variables, and statements Identify and eliminate errors using PLSQL_WARNINGS and exception handlers Work with functions, procedures, packages, collections, and triggers Define and deploy varray, nested table, and associative array data types Handle external routines, object types, large objects, and secure files Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE Call external procedures through Oracle Net Services and PL/SQL wrappers Integrate internal and server-side Java class libraries using Oracle JVM Develop robust Web applications using PL/SQL Gateway and Web Toolkit

• Author: Asif Momen
• Publisher: Packt Publishing Ltd
• ISBN: 1849686750
• Category: Computers
• Page: 146
• View: 4636

DOWNLOAD NOW »
Build and manage your Oracle Database XE environment with this fast paced, practical guide

• Author: Sam Alapati
• Publisher: Springer Science & Business
• ISBN: 1430210168
• Category: Computers
• Page: 1400
• View: 1650

DOWNLOAD NOW »
Sam Alapati’s Expert Oracle Database 11g Administration is a comprehensive handbook for Oracle database administrators (DBAs) using the 11g release of the Oracle Database. All key aspects of database administration are covered, including backup and recovery, day–to–day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It’ll help you get the job done. Comprehensive handbook for Oracle Database administrators. Covers all major aspects of database administration. Tests and explains in detail key DBA commands. Offers primers on Linux/Unix, data modeling, SQL, and PL/SQL. What you’ll learn Prepare an environment for Oracle. Configure the system. Install the software. Create a database. Monitor your database environment day–to–day with confidence that you will detect and resolve problems before they become emergencies. Get the most out of Oracle Database 11g by taking full advantage of its management features and cutting–edge technologies. Back up your database and be able to recover it if needed. Secure your database, in terms of both regulatory compliance and user management. Troubleshoot and resolve connectivity, network, and performance problems. Who this book is for Expert Oracle Database 11g Administration is written for Oracle database administrators who want a comprehensive reference to refer to during their day–to–day work. It’s clearly written in a way that is accessible to both intermediate and beginning administrators. Readers can easily and quickly find the content they need.

• Author: Chris Zeis,Chris Ruel,Wessler
• Publisher: John Wiley & Sons
• ISBN: 9780470465073
• Category: Computers
• Page: 408
• View: 7329

DOWNLOAD NOW »
Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you’ll be glad to have Oracle 11g For Dummies in your cubicle. This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You’ll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running in tiptop form. Oracle 11g For Dummies covers: The building blocks behind the database engine as well as Oracle’s physical and logical structures Hardware, software, system, and storage requirements for implementation How to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIX Daily and intermittent tasks necessary to keep your database running properly How to assess potential threats to your database, configure Oracle Recovery Manager, and set up backup and recovery procedures When to use online, offline, controlfile, and archivelog backups Troubleshooting methodology and how to use Oracle database logs and other diagnostic utilities Different ways to manage your database How to automate jobs with the Oracle Scheduler Using SQL in Oracle, and a great deal more Completely up to date for the newest release of Oracle, Oracle 11g For Dummies will give you both the information and the confidence to set up and maintain an Oracle database for your organization.

• Author: Kevin Loney
• Publisher: McGraw Hill Professional
• ISBN: 0071770496
• Category: Computers
• Page: 1392
• View: 6363

DOWNLOAD NOW »
Get a thorough understanding of Oracle Database 10g from the most comprehensive Oracle database reference on the market, published by Oracle Press. From critical architecture concepts to advanced object-oriented concepts, this powerhouse contains nearly 50 chapters designed to enlighten you. Upgrade from earlier versions, use SQL, SQL Plus, and PL/SQL. Get code examples and access popular documentation PDFs--plus a full electronic copy of the book on the included CD-ROM. Go beyond the basics and learn security, text searches, external tables, using Java in Oracle, and a great deal more.

• Author: Saurabh K. Gupta
• Publisher: Packt Publishing Ltd
• ISBN: 1849687234
• Category: Computers
• Page: 440
• View: 3444

DOWNLOAD NOW »
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.

The Definitive Guide

• Author: Jonathan Gennick
• Publisher: "O'Reilly Media, Inc."
• ISBN: 9780596552619
• Category: Computers
• Page: 584
• View: 8753

DOWNLOAD NOW »
Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQLPlus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.The new second edition of Oracle SQLPlus: The Definitive Guide clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQLPlus--and maybe some you didn't realize you could perform.With Oracle SQLPlus: The Definitive Guide, you'll expertly: write and execute script files generate ad hoc reports extract data from the database query the data dictionary tables customize an SQLPlus environment and much more It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction.This book is truly the definitive guide to SQLPlus. It's an indispensable resource for those who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.

• Author: Vinod Krishnan
• Publisher: Packt Publishing Ltd
• ISBN: 1849689016
• Category: Computers
• Page: 330
• View: 8625

DOWNLOAD NOW »
Oracle ADF 11gR2 Development Beginner's Guide will cover the basics of Oracle ADF 11g development and will then work through more complex topics as the reader gains more skills. This book will follow a tutorial approach with the content and tasks getting more advanced throughout.This book is intended for beginners who know a little about Java programming and would like to learn how to develop rich web applications using the Oracle Application Development Framework.

• Author: John J. Patrick
• Publisher: Prentice-Hall PTR
• ISBN: 9780137126026
• Category: Computers
• Page: 803
• View: 5688

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.

For Oracle Database 12c

• Author: Tim Gorman,Inger Jorgensen,Melanie Caffrey,Lex deHaan
• Publisher: Apress
• ISBN: 1430265574
• Category: Computers
• Page: 440
• View: 6448

DOWNLOAD NOW »
Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQL*Plus and SQL Developer. SQL*Plus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQL Developer is a powerful, graphical environment for developing and debugging queries. Oracle's is possibly the most valuable dialect of SQL from a career standpoint. Oracle's database engine is widely used in corporate environments worldwide. It is also found in many government applications. Oracle SQL implements many features not found in competing products. No developer or DBA working with Oracle can afford to be without knowledge of these features and how they work, because of the performance and expressiveness they bring to the table. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle Database. Takes an example-based approach, with clear and authoritative explanations Introduces both SQL and the query tools used to execute SQL statements Shows how to create tables, populate them with data, and then query that data to generate business results

Oracle Certification Prep

• Author: Matthew Morris
• Publisher: CreateSpace
• ISBN: 9781478217992
• Category: Computers
• Page: 178
• View: 4143

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.

• Author: Andy Oppel,Robert Sheldon
• Publisher: McGraw Hill Professional
• ISBN: 0071548653
• Category: Computers
• Page: 575
• View: 401

DOWNLOAD NOW »
Essential Skills--Made Easy! Written to the SQL:2006 ANSI/ISO standard, this easy-to-follow guide will get you started programming in SQL right away. You will learn how to retrieve, insert, update, and delete database data, and perform management and administrative functions. SQL: A Beginner's Guide, Third Edition covers new features, including SQL/XML, and is loaded with updated SQL examples along with notes on using them with the latest RDBMS software versions such as MySQL 5.0, SQL Server 2008, and Oracle Database 11g. Designed for Easy Learning: Key Skills & Concepts--Lists of specific skills covered in the chapter Ask the Experts--Q&A sections filled with bonus information and helpful tips Try This--Hands-on exercises that show how to apply your skills Notes--Extra information related to the topic being covered Self-Tests--Chapter-ending quizzes to test your knowledge Annotated Syntax--Example code with commentary that describes the programming techniques being illustrated

A Practical Guide to Enterprise Reporting

• Author: Daniela Bozdoc
• Publisher: Packt Publishing Ltd
• ISBN: 9781849683197
• Category: Computers
• Page: 254
• View: 1946

DOWNLOAD NOW »
This is a practical guide with step-by step instructions for enhancing your application of Oracle BI Publisher 11g for enterprise reporting. If you are an Oracle BI Publisher 11g end user, be it a report developer, business analyst or consultant, this book is for you. You should have good knowledge of general reporting practices and XML/XSL programming, though experience of using BI/XML publisher is not essential.