CITATION

McLaughlin, Michael. Oracle Database 11g & MySQL 5.6 Developer Handbook. US: McGraw-Hill Osborne Media, 2011.

Oracle Database 11g & MySQL 5.6 Developer Handbook

Published:  September 2011

eISBN: 9780071768863 0071768866 | ISBN: 9780071768856

Book description:

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

Michael McLaughlin, Oracle ACE, is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on IT management, databases, and systems analysis and design. Michael is the author of Oracle Database 11g PL/SQL Programming and Oracle Database 10g Express Edition PHP Web Programming, and co-author of Oracle Database 11g PL/SQL Programming Workbook, Oracle Database 10g PL/SQL Programming, Expert Oracle PL/SQL, and Oracle Database AJAX & PHP Web Application Development. He worked at Oracle Corporation for more than eight years, most recently as the senior applications upgrade manger in E-Business Suite Release Engineering.

Keywords: ORACLE DATABASE 11G & ORACLE MYSQL 5.5 DEVELOPER HANDBOOK, A GUIDE TO PORTABILITY OF PL/SQL AND STORED PROCEDURES, MICHAEL MCLAUGHLIN, MCLOFFLIN, MCLAFFLIN, ORACLE DATABASE 11G, ORACLE MYSQL, MIXED ENVIRONMENT, SUN MICROSYSTEMS, OPEN-SOURCE DATABASE, ORACLE PRESS, ORACLE DATABASE 11G, ORACLE MYSQL 5.5, DEVELOPER, DEVELOPMENT, BOOK, GUIDE, HOW TO, PORTABILITY, PL/SQL, STORED PROCEDURES, COMPARATIVE, ORACLE DATABASE 11G PL/SQL WORKBOOK, ENVIRONMENTS, ARCHITECTURE, SECURITY, MODEL, TRANSACTION, REFERENTIAL INTEGRITY, SQL, STRUCTURES, MAINTAINING, SEQUENCES, INSERTING, DATA, UPDATING, DELETING, IMPORTING, MERGING, EXPORTING, STORED PROGRAM, FRAMEWORKS, PSM, FUNCTIONS, PROCEDURES, TRIGGERS, KLINE, SQL IN A NUTSHELL, ORACLE JDEVELOPER 11G HANDBOOK, ORACLE JDEVELOPER 10G FOR FORMS & PL/SQL DEVELOPERS, ORACLE DATABASE 10G EXPRESS EDITION PHP WEB PROGRAMMING, ORACLE DATABASE 11G PL/SQL PROGRAMMING, ORACLE DATABASE 11G SQL, ORACLE DATABASE AJAX & PHP WEB APPLICATION DEVELOPMENT, ORACLE SQL DEVELOPER HANDBOOK, ORACLE APPLICATION SERVER 10G WEB DEVELOPMENT, ORACLE HTML DB HANDBOOK, ORACLE DATABASE 11G THE COMPLETE REFERENCE, ORACLE DATABASE 11G A BEGINNER'S GUIDE, ORACLE DATABASE 11G PL/SQL PROGRAMMING, ORACLE DATABASE 11G NEW FEATURES, ORACLE DATABASE 11G DBA HANDBOOK, ORACLE DATABASE 11G SQL, OCA ORACLE DATABASE 11G ADMINISTRATION I EXAM GUIDE, OCA ORACLE DATABASE 11G SQL FUNDAMENTALS I EXAM GUIDE, OCP ORACLE DATABASE 11G NEW FEATURES FOR ADMINISTRATORS EXAM GUIDE, OCP ORACLE DATABASE 11G ADMINISTRATION II EXAM GUIDE, ORACLE DATABASE 11G RMAN BACKUP & RECOVERY, OCA/OCP ORACLE DATABASE 11G ALL-IN-ONE EXAM GUIDE, MICROSOFT SQL SERVER 2008 ADMINISTRATION FOR ORACLE DBAS, ORACLE DATABASE ADMINISTRATION FOR SQL SERVER DBAS, ORACLE STREAMS 11G DATA REPLICATION, ORACLE DATABASE 11G RELEASE 2 HIGH AVAILABILITY, MAXIMIZE YOUR AVAILABILITY WITH GRID INFRASTRUCTURE, RAC AND DATA GUARD, ORACLE REAL APPLICATION CLUSTERS TESTING AND TUNING, ORACLE CRM ON DEMAND REPORTING, PEOPLESOFT DEVELOPER'S GUIDE FOR PEOPLETOOLS & PEOPLECODE, ORACLE E-BUSINESS SUITE FINANCIALS HANDBOOK, ORACLE E-BUSINESS SUITE MANUFACTURING & SUPPLY CHAIN MANAGEMENT, EFFECTIVE ORACLE BY DESIGN, ENTERPRISE GRID COMPUTING WITH ORACLE, ORACLE APPLICATION SERVER PORTAL HANDBOOK, ORACLE DATABASE 10G HIGH AVAILABILITY WITH RAC, FLASHBACK & DATA GUARD, ORACLE COLLABORATION SUITE HANDBOOK, ORACLE DATABASE 10G RMAN BACKUP & RECOVERY, ORACLE ENTERPRISE MANAGER 10G GRID CONTROL IMPLEMENTATION GUIDE, ORACLE E-BUSINESS SUITE SECURITY, TRANSFORMING INFOGLUT!, ORACLE CRM ON DEMAND REPORTING, ORACLE AUTOMATIC STORAGE MANAGEMENT, ORACLE DATABASE 11G DATA GUARD HANDBOOK, ORACLE GENERAL LEDGER GUIDE, ORACLE PROCURE-TO-PAY GUIDE, ORACLE ESSBASE & ORACLE OLAP, ORACLE DISCOVERER 10G HANDBOOK, ORACLE ENTERPRISE MANAGER 10G GRID CONTROL HANDBOOK, ORACLE FUSION DEVELOPER GUIDE, ORACLE E-BUSINESS SUITE DEVELOPMENT & EXTENSIBILITY HANDBOOK, ORACLE SOA SUITE 11G HANDBOOK, ORACLE WEBCENTER 11G HANDBOOK, ORACLE CRM ON DEMAND DEPLOYMENT GUIDE, PEOPLESOFT PEOPLETOOLS TIPS & TECHNIQUES, ORACLE CRM ON DEMAND DASHBOARDS, DESIGNING AN IAM FRAMEWORK WITH ORACLE IDENTITY AND ACCESS MANAGEMENT SUITE, QUICK START GUIDE TO ORACLE FUSION DEVELOPMENT, ORACLE CRM ON DEMAND COMBINED ANALYSES, ORACLE CRM ON DEMAND EMBEDDED ANALYTICS, MANAGING ORACLE FUSION APPLICATIONS, ORACLE FUSION MIDDLEWARE 11G ARCHITECTURE AND MANAGEMENT, ORACLE DATABASE 11G BUILDING XML APPLICATIONS, ORACLE DATABASE 11G REAL APPLICATION CLUSTERS HANDBOOK, ORACLE BPM SUITE 11G HANDBOOK, ORACLE VM IMPLEMENTATION AND ADMINISTRATION GUIDE, ORACLE WEBLOGIC SERVER 11G ADMINISTRATION HANDBOOK, ORACLE HYPERION FINANCIAL MANAGEMENT TIPS AND TECHNIQUES