Overview
Main description
The definitive Oracle Press guide to programming and working with Oracle Database 11g 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 11g and Oracle MySQL 5.5 unique SQL and PL/SQL/Stored Program features
Author comments
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.
