Oracle Database 11g & MySQL 5.6 Developer Handbook

The definitive Oracle Press guide to programming and working with Oracle Database 11 gand Oracle MySQL in a mixed environment. Oracle Database 11g and MySQL 5.5 Database Developer Handbookis a comparative handbook to support developers moving from MySQL to Oracle or Oracle to MySQL. The book compares and demonstrates development environments, architecture, security, transactions, and referential integrity concepts. It compares and contrasts SQL dialects and approaches across the spectrum of SQL commands and discusses their portability. The book also compares and contrasts stored programs in both databases and discusses their design portability. Clear examples, instructions, and explanations make this single volume handbook the standard for porting dialects between the Oracle and MySQL databases. Best practices are highlighted throughout the chapters. Mastery questions are provided at the end of each chapter with an appendix containing answers with explanations. Oracle Database 11g and MySQL 5.5 Database Developer Handbook Focuses on how to port the SQL dialects to either database as needed Explains comparable SQL and PL/SQL/Stored Procedure development techniques Compares and contrasts development strategies in solving problems with SQL and PL/SQL/Stored Procedures Features best practices in database development to support web-based applications Highlights Oracle Database 11 gand Oracle MySQL 5.5 unique SQL and PL/SQL/Stored Program features

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