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

Part I: Development Components

Chapter 1. Architecture

Chapter 2. Client Interface

Chapter 3. Security Models

Chapter 4. Transaction Models

Chapter 5. Constraints

Part II: SQL Development

Chapter 6. Creating Users and Structures

Chapter 7. Modifying Users and Structures

Chapter 8. Inserting Data

Chapter 9. Updating Data

Chapter 10. Deleting Data

Chapter 11. Querying

Chapter 12. Merging Data

Chapter 13. PL/SQL Programming Language

Chapter 14. SQL/PSM Basics

Chapter 15. Triggers

Mastery Check Answers

Index