Oracle Database 11g & MySQL 5.6 Developer Handbook - Michael McLaughlin

Oracle Database 11g & MySQL 5.6 Developer Handbook

Buch | Softcover
608 Seiten
2011
Osborne/McGraw-Hill (Verlag)
978-0-07-176885-6 (ISBN)
49,85 inkl. MwSt
This Oracle Press guide is the definitive reference to programming and working with Oracle Database 11g and Oracle MySQL in a mixed environment.
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 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 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

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.

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

Erscheint lt. Verlag 16.11.2011
Zusatzinfo 100 Illustrations, unspecified
Verlagsort New York
Sprache englisch
Maße 185 x 234 mm
Gewicht 972 g
Themenwelt Informatik Datenbanken MySQL
Informatik Datenbanken Oracle
Informatik Office Programme Outlook
ISBN-10 0-07-176885-8 / 0071768858
ISBN-13 978-0-07-176885-6 / 9780071768856
Zustand Neuware
Haben Sie eine Frage zum Produkt?
Mehr entdecken
aus dem Bereich

von Jon Duckett

Buch | Softcover (2022)
Wiley-VCH (Verlag)
45,00