Oracle Database 11g & MySQL 5.6 Developer Handbook

Have a Promotion Code?

Please enter it here:

Great deals and more!

Sign up for special offers, exclusive discounts, and new product announcements from McGraw-Hill Professional.

SIGN UP TODAY


Date

October 21, 2011

Format

Paperback, 608 pages

Other Formats


ISBN

0071768858 / 9780071768856

$

Your Price

50.00



Overview


Main description

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


Table of contents

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


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.





Copyright 2014 McGraw-Hill Global Education Holdings, LLC

WELCOME!

Before you can enjoy free downloads from McGraw-Hill Professional, we ask that you please provide your email address and country.



Yes, I want to receive other special offer.