- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
Publisher's Noteguaranteed 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 architectureConvert databases between platforms and ensure transactional integrityCreate tables, sequences, indexes, views, and user accountsBuild and debug PL/SQL, SQL*Plus, SQL/PSM, and MySQL Monitor scriptsExecute complex queries and handle numeric and date mathematicsMerge data from source tables and set up virtual directories
Contents
Part IChapter 1. ArchitectureChapter 2. Client InterfaceChapter 3. Security ModelsChapter 4. Transaction ModelsChapter 5. ConstraintsPart II: SQL DevelopmentChapter 6. Creating Users and StructuresChapter 7. Modifying Users and StructuresChapter 8. Inserting DataChapter 9. Updating DataChapter 10. Deleting DataChapter 11. QueryingChapter 12. Merging DataChapter 13. PL/SQL Programming LanguageChapter 14. SQL/PSM BasicsChapter 15. TriggersMastery Check AnswersIndexNER(01): WOW