Read more
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
>
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
List of contents
Part I: Development ComponentsChapter 1. Architecture
Chapter 2. Client Interface
Chapter 3. Security Models
Chapter 4. Transaction Models
Chapter 5. Constraints
Part II: SQL DevelopmentChapter 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
