The definitive Oracle Press guide to programming and working with Oracle Database 11 g and Oracle MySQL in a mixed environment. Oracle Database 11g and MySQL 5.5 Database Developer Handbook is 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 g and Oracle MySQL 5.5 unique SQL and PL/SQL/Stored Program features.