Oracle Database 11g & MySQL 5.6 Developer Handbook

Author: Michael McLaughlin

Publisher: McGraw-Hill Prof Med/Tech

ISBN: 0071768858

Category: Computers

Page: 608

View: 1017

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
Posted in Computers

MySQL Workbench: Data Modeling & Development

Author: Michael McLaughlin

Publisher: McGraw Hill Professional

ISBN: 0071791892

Category: Computers

Page: 480

View: 9081

The only Oracle Press guide to MySQL Workbench explains how to design and model MySQL databases. MySQL Workbench Data Modeling and Development helps developers learn how to effectively use this powerful product for database modeling, reverse engineering, and interaction with the database without writing SQL statements. MySQL Workbench is a graphical user interface that can be used to create and maintain MySQL databases without coding. The book covers the interface and explains how to accomplish each step by illustrating best practices visually. Clear examples, instructions, and explanations reveal, in a single volume, the art of database modeling. This Oracle Press guide shows you how to get the tool to do what you want. Annotated screen shots demonstrate all interactions with the tool, and text explains the how, what, and why of each step. Complete coverage Installation and Configuration; Creating and Managing Connections; Data Modeling Concepts; Creating an ERD; Defining the Physical Schemata; Creating and Managing Tables; Creating and Managing Relationships; Creating and Managing Views; Creating and Managing Routines; Creating and Managing Routine Groups; Creating and Managing User & Groups; Creating and Managing SQL Scripts; Generating SQL Scripts; Forward Engineering a Data Model; Synchronize a Model with a Database; Reverse Engineering a Database; Managing Differences in the Data Catalog; Creating and Managing Model Notes; Editing Table Data; Editing Generated Scripts; Creating New Instances; Managing Import and Export; Managing Security; Managing Server Instances
Posted in Computers

Oracle Database 12c PL/SQL Programming

Author: Michael McLaughlin

Publisher: McGraw Hill Professional

ISBN: 007181244X

Category: Computers

Page: 1192

View: 3457

Master Oracle Database 12c PL/SQL Application Development Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide. Explore new SQL and PL/SQL features in Oracle Database 12c Build control structures, cursors, and loop statements Work with collections, varrays, tables, and associative array collections Locate and repair errors and employ exception handlers Execute black box, white box, and integration tests Configure and manage stored packages and libraries Handle security with authentication and encryption Use LOBs to store text and multimedia content Write and implement PL/SQL and Java triggers Extend functionality using dynamic SQL statements Understand object types, nested tables, and unnesting queries
Posted in Computers

Oracle GoldenGate 11g Handbook

Author: Robert G. Freeman

Publisher: McGraw Hill Professional

ISBN: 0071790896

Category: Computers

Page: 448

View: 7068

Master Oracle GoldenGate 11g Enable highly available, real-time access to enterprise data in heterogeneous environments. Featuring hands-on workshops, Oracle GoldenGate 11g Handbook shows you how to install, configure, and implement this high-performance application. You’ll learn how to replicate data across Oracle databases and other platforms, including MySQL and Microsoft SQL Server, and perform near-zero-downtime migrations and upgrades. Monitoring, performance tuning, and troubleshooting are also discussed in this Oracle Press guide. Install and configure Oracle GoldenGate Implement Oracle GoldenGate one-way replication Configure multitarget and cascading replication Use bidirectional replication to build a heterogeneous database infrastructure Secure your environment, control and manipulate data, and prevent errors Configure Oracle GoldenGate for Oracle Clusterware and Oracle Real Application Clusters Use Oracle GoldenGate with MySQL and Microsoft SQL Server Perform near-zero-downtime upgrades and migrations Use Oracle GoldenGate Monitor and Oracle GoldenGate Director Ensure data quality with Oracle GoldenGate Veridata Implement nondatabase integration options
Posted in Computers

Oracle WebLogic Server 11g Administration Handbook

Author: Sam R. Alapati

Publisher: McGraw Hill Professional

ISBN: 0071774262

Category: Computers

Page: 528

View: 6161

Master the Configuration and Administration of Oracle WebLogic Server 11g Oversee a robust, highly available environment for your mission-critical applications using the expert information in this Oracle Press guide. Oracle WebLogic Server 11g Administration Handbook explains the latest management techniques for the de facto application server for Oracle Fusion Middleware 11g> and provides detailed examples and best practices. Find out how to use the Oracle WebLogic Server Administration Console feature, employ command-line and scripting tools, implement failover and migration capabilities, and generate reliable backups. Troubleshooting, tuning, and security procedures are also covered in this comprehensive resource. Install Oracle WebLogic Server 11g or upgrade from a previous version Configure domains, servers, clusters, custom networks, and virtual hosts Work with the Administration Console and Monitoring Dashboard features of Oracle WebLogic Server Use the WebLogic Scripting Tool (WLST) feature of Oracle WebLogic Server to manage and monitor domains Use the Oracle WebLogic Server Work Managers feature to optimize scheduled work Deploy Web applications, Enterprise JavaBeans, and Java EE modules Improve scalability and reliability using Oracle WebLogic Server clusters Monitor servers, tune the Java Virtual Machine, maximize throughput, and optimize performance Authenticate, authorize, and map users within defined security realms
Posted in Computers

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

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
Posted in Computers

Oracle Database Problem Solving and Troubleshooting Handbook

Author: Tariq Farooq,Mike Ault,Paulo Portugal,Mohamed Houri,Syed Jaffar Hussain,Jim Czuprynski,Guy Harrison

Publisher: Addison-Wesley Professional

ISBN: 0134429257

Category: Computers

Page: 512

View: 1661

An Expert Guide for Solving Complex Oracle Database Problems Oracle Database Problem Solving and Troubleshooting Handbook delivers comprehensive, practical, and up-to-date advice for running the Oracle Database reliably and efficiently in complex production environments. Seven leading Oracle experts have brought together an unmatched collection of proven solutions, hands-on examples, and step-by-step tips for Oracle Database 12c, 11g, and other recent versions of Oracle Database. Every solution is crafted to help experienced Oracle DBAs and DMAs understand and fix serious problems as rapidly as possible. The authors cover LOB segments, UNDO tablespaces, high GC buffer wait events, poor query response times, latch contention, indexing, XA distributed transactions, RMAN backup/recovery, and much more. They also offer in-depth coverage of a wide range of topics, including DDL optimization, VLDB tuning, database forensics, adaptive cursor sharing, data pumps, data migration, SSDs, indexes, and how to go about fixing Oracle RAC problems. Learn how to Choose the quickest path to solve high-impact problems Use modern best practices to make your day more efficient and predictable Construct your “Call 9-1-1 plan” for future database emergencies Proactively perform maintenance to improve your environment’s stability Save time with industry-standard tools and scripts Register your product at informit.com/register for convenient access to downloads, updates, and corrections as they become available.
Posted in Computers

Oracle Essentials

Author: Rick Greenwald,Robert Stackowiak,Jonathan Stern

Publisher: O'Reilly Media, Incorporated

ISBN: 9781449343033

Category: Computers

Page: 420

View: 9824

Written by experienced Oracle insiders, this essential guide distills a vast amount of information into an easy-to-read volume that covers every aspect of the Oracle database. Readers of all technical levels will learn about Oracle's features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning and much more. Augmented with illustrations and helpful hints, the fifth edition of Oracle Essentials offers a valuable one-stop overview of Oracle Database 12c, Oracle's newest database release. More comprehensible than huge complete references, and more detailed than most primers, this book gives current Oracle users the conceptual background they need to understand how the Oracle database truly works. For those new to Oracle, this all-in-one guide provides an essential introduction that will get them up to speed.
Posted in Computers

Securing Oracle Database 12c: A Technical Primer eBook

Author: Michelle Malcher,Scott Rotondo,Paul Needham

Publisher: McGraw Hill Professional

ISBN: 0071826173

Category: Computers

Page: N.A

View: 954

This Oracle Press eBook is filled with cutting-edge security techniques for Oracle Database 12c. It covers authentication, access control, encryption, auditing, controlling SQL input, data masking, validating configuration compliance, and more. Each chapter covers a single threat area, and each security mechanism reinforces the others.
Posted in Computers

Oracle Database 12c PL/SQL Advanced Programming Techniques

Author: Michael McLaughlin,John Harper

Publisher: McGraw Hill Professional

ISBN: 0071835156

Category: Computers

Page: 448

View: 3525

Take Your PL/SQL Programming Skills to the Next Level Build robust database-centric PL/SQL applications quickly and effectively. Oracle Database 12c PL/SQL Advanced Programming Techniques shows you how to write and deploy Java libraries inside Oracle Database 12c, use the utl_file and DBMS_SCHEDULER packages, and create external tables and external procedures. Application security, performance tuning, and Oracle Database In-Memory are also covered in this Oracle Press guide. Configure, deploy, and troubleshoot Java libraries for Oracle object types Use the utl_file package to manage unstructured and structured data Develop and deploy Java I/O libraries and wrap them with PL/SQL Create and use external tables Implement high-speed data transfer Harden database systems and develop secure applications Manage complex schedules and jobs with the DBMS_SCHEDULER package Optimize PL/SQL for use in performance tuning Create and deploy external procedures Implement the Oracle Database In-Memory column store feature
Posted in Computers

Pro ODP.NET for Oracle Database 11g

Author: Edmund Zehoo

Publisher: Apress

ISBN: 1430228202

Category: Computers

Page: 468

View: 476

This book is a comprehensive and easy-to-understand guide for using the Oracle Data Provider (ODP) version 11g on the .NET Framework. It also outlines the core GoF (Gang of Four) design patterns and coding techniques employed to build and deploy high-impact mission-critical applications using advanced Oracle database features through the ODP.NET provider. The book details the features of the ODP.NET provider in two main sections: “Basic,” covering the basics and mechanisms for data access via ODP.NET; and “Advanced,’ covering advanced Oracle features such as globalization, savepoints, distributed transactions and how to call them via ODP.NET, advanced queueing (AQ), and promotable transactions. It takes you from the ground up through different implementation scenarios via a rich collection of C# code samples. It outlines database security and performance optimization tricks and techniques on ODP.NET that conform to best practices and adaptable design. Different GoF design patterns are highlighted for different types of ODP.NET usage scenarios with consideration of performance and security. It provides a comprehensive guide to the synergistic integration of Oracle and Microsoft technologies such as the Oracle Developer Tools for Visual Studio (11.1.0.7.10). It also details how programmers can make use of ODT to streamline the creation of robust ODP.NET applications from within the Visual Studio environment. What you’ll learn How to use the full set of features available in ODP.NET 11g (with code samples and diagrams illustrating each feature/concept). New features such as using Oracle Streams AQ, promotable transactions, Oracle database event notifications, and Oracle database control are also covered. The core performance and feature differences between ODP.NET, Microsoft .NET Provider for Oracle, OLEDB.NET, and ODBC.NET, together with the strengths and weaknesses of each method. This section also provides comprehensive coverage on the differences between ODP.NET 9i, 10g, and 11g. How to take advantage of connection pooling, fetch size controls, ref cursors, bind variables, client result cache and statement caching via ODP.NET to squeeze every ounce of performance from your .NET application. How to secure your ODP.NET applications via authentication and ODP.NET 11g’s new classes to enforce imperative and declarative Oracle security. The common programming pitfalls and design patterns to use/avoid in different ODP.NET usage scenarios How to use a significant set of features of Oracle Developer Tools for Visual Studio (11.1.0.7.10), including new features such as the AQ designers, user/role management, and performance-tuning tools. Who this book is for This book is aimed at .NET developers looking for a comprehensive guide to ODP.NET and its latest features. The book will also appeal to those looking to optimize their ODP.NET applications by applying the best design patterns and other practices. Table of Contents Introduction to Oracle .NET Connectivity ODP.NET: A Functional Overview Connecting to Oracle with ODP.NET Retrieving and Manipulating Data with ODP.NET Using PL/SQL and NET CLR Stored Procedures with ODP.NET ODP.NET Globalization Transactions with ODP.NET Oracle Database Change Notifications with ODP.NET Using Oracle Database Streams Advanced Queuing with ODP.NET Oracle XML Support ODP.NET Security Features ODP.NET Performance Design Patterns and Considerations in Using ODP.NET ODP.NET Tool Basics Building Data-Driven Applications with ODP.NET
Posted in Computers

Oracle Business Intelligence 11g Developers Guide

Author: Mark Rittman

Publisher: McGraw Hill Professional

ISBN: 0071798749

Category: Computers

Page: 1088

View: 2892

Master Oracle Business Intelligence 11g Reports and Dashboards Deliver meaningful business information to users anytime, anywhere, on any device, using Oracle Business Intelligence 11g. Written by Oracle ACE Director Mark Rittman, Oracle Business Intelligence 11g Developers Guide fully covers the latest BI report design and distribution techniques. Find out how to execute effective queries, build accurate models, use scorecards and KPIs, create dynamic reports, set up dashboards, and publish to smartphones and wireless devices. This Oracle Press guide contains comprehensive details on Oracle Exalytics In-Memory Machine, the best-in-class, preintegrated BI platform. Install or upgrade to Oracle Business Intelligence 11g Develop and manage custom Oracle Business Intelligence repositories Access relational, file, and multidimensional data sources Design print-quality reports with Oracle Business Intelligence Publisher Create web-enabled analyses, dashboards, and visualizations Integrate with other applications using Oracle Business Intelligence 11g Action Framework Employ authentication, authorization, and row-level security Configure and deploy Oracle Exalytics In-Memory Machine
Posted in Computers

The Java Tutorial

A Short Course on the Basics

Author: Sharon Biocca Zakhour,Sowmya Kannan,Raymond Gallardo

Publisher: Addison-Wesley

ISBN: 0132761947

Category: Computers

Page: 744

View: 9488

The Java® Tutorial, Fifth Edition, is based on Release 7 of the Java Platform Standard Edition. This revised and updated edition introduces the new features added to the platform, including a section on NIO.2, the new file I/O API, and information on migrating legacy code to the new API. The deployment coverage has also been expanded, with new chapters such as “Doing More with Rich Internet Applications” and “Deployment in Depth,” and a section on the fork/join feature has been added to the chapter on concurrency. Information reflecting Project Coin developments, including the new try-with-resources statement, the ability to catch more than one type of exception with a single exception handler, support for binary literals, and diamond syntax, which results in cleaner generics code, has been added where appropriate. The chapters covering generics, Java Web Start, and applets have also been updated. In addition, if you plan to take one of the Java SE 7 certification exams, this guide can help. A special appendix, “Preparing for Java Programming Language Certification,” lists the three exams available, details the items covered on each exam, and provides cross-references to where more information about each topic appears in the text. All of the material has been thoroughly reviewed by members of Oracle Java engineering to ensure that the information is accurate and up to date.
Posted in Computers

Oracle Warehouse Builder 11g

Getting Started

Author: Bob Griesemer

Publisher: Packt Publishing Ltd

ISBN: 184719575X

Category: Computers

Page: 353

View: 9155

Extract, Transform, and Load data to build a dynamic, operational data warehouse.
Posted in Computers

SQL Fundamentals

Author: John J. Patrick

Publisher: Prentice-Hall PTR

ISBN: 9780137126026

Category: Computers

Page: 803

View: 2975

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

Beginning Oracle Database 11g Administration

From Novice to Professional

Author: Iggy Fernandez

Publisher: Apress

ISBN: 1590599683

Category: Computers

Page: 464

View: 2424

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.
Posted in Computers

Oracle to DB2 Conversion Guide: Compatibility Made Easy

Author: Yvonne Chan,Nick Ivanov,Olaf Mueller,IBM Redbooks

Publisher: IBM Redbooks

ISBN: 0738438758

Category: Computers

Page: 456

View: 2327

This IBM® Redbooks® publication describes IBM DB2® SQL compatibility features. The latest version of DB2 includes extensive native support for the PL/SQL procedural language, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQLPlus, and more. These features can help with developing applications that run on both DB2 and Oracle and can help simplify the process of moving from Oracle to DB2. In addition, IBM now provides tools to simplify the enablement process, such as the highly scalable IBM Data Movement Tool for moving schema and data into DB2, and an Editor and Profiler for PL/SQL provided by the IBM Data Studio tool suite. This Oracle to DB2 migration guide describes new technology, preferred practices for moving to DB2, and common scenarios that can help you as you move from Oracle to DB2. This book is intended for IT architects and developers who are converting from Oracle to DB2. DB2 compatibility with Oracle is provided through native support. The new capabilities in DB2 that provide compatibility are implemented at the lowest and most intimate levels of the database kernel, as though they were originally engineered for DB2. means that the DB2 implementation is done without the aid of an emulation layer. This intimacy leads to the scalable implementation that DB2 offers, providing identical performance between DB2 compatibility features and DB2 other language elements. For example, DB2 runs SQL PL at the same performance as PL/SQL implementations of the same function.
Posted in Computers

Linux Recipes for Oracle DBAs

Author: Darl Kuhn,Bernard Lopuz,Charles Kim

Publisher: Apress

ISBN: 1430215755

Category: Computers

Page: 528

View: 6132

Linux Recipes for Oracle DBAs is an example–based book on managing Oracle Database in a Linux environment. Covering commonly used distributions such as Red Hat Enterprise Linux and Oracle Enterprise Linux, the book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of Linux documentation. The book is task–oriented: Look up the task to perform. See the solution. Read up on the details. Get the job done. Takes you directly from problem to solution Covers the “right” mix of Linux user and administration tasks for database administrators Respects your time by being succinct and to–the–point What you’ll learn Execute Linux commands applicable to Oracle Database administration. Write shell scripts to automate critical DBA tasks. Monitor, tune, and optimize a Linux server to run Oracle Database. Perform Linux system administration tasks relevant to Oracle Database. Implement Oracle real application clusters on Linux. Implement Oracle automatic storage management on Linux. Remotely (and securely!) manage Oracle on Linux. Who this book is for Linux Recipes for Oracle DBAs is a book for Oracle database administrators who want to expertly operate Oracle databases on the Linux operating system. If you’re new to Linux, or are migrating from a Unix platform, or just want detailed solutions for tasks that Oracle DBAs perform on Linux servers, this book is for you.
Posted in Computers