Oracle Database 11g & MySql 5.6 Developer Handbook (Oracle Press) - Softcover

Mclaughlin, Michael

Softcover

ISBN 10: 0071768858 ISBN 13: 9780071768856

Publisher: McGraw-Hill Osborne Media, 2011

Synopsis

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

About this title

Product Description:

Paperback. Pub Date: 09 2011 Pages: 608 Publisher: McGraw-Hill Master Application Development in a Mixed-Platform EnvironmentBuild 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 architectureConvert databases between platforms and ensure transactional integrityCreate tables. sequences. indexes. views. and user accountsBuild and debug PLSQL. SQL * Plus. SQLPSM. and MySQL Monitor scriptsExecute complex queries a...

About the Author:

Michael is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School. He teaches courses on CIT management, databases and systems analysis and design. He is the author of Oracle Database 11g PL/SQL Programming, Oracle Database 11g and Oracle MySQL 5.6, Oracle Database 10g Express Edition PHP Web Programming, and co-author of four other Oracle Press books. He's an Oracle ACE and speaker at Oracle User Group Meetings. He worked at Oracle Corporation for over eight years in Consulting, Development and Support, working with the database, tools and Oracle E-Business Suite. He left Oracle as the Senior Applications Upgrade Manger in E-Business Suite Release Engineering.

About this edition

• Publisher: McGraw-Hill Osborne Media
• Publication date: 2011
• ISBN 10: 0071768858
• ISBN 13: 9780071768856
• Binding: Paperback
• Number of pages: 608