Synopses & Reviews
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 HandbookFocuses on how to port the SQL dialects to either database as neededExplains 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
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