| |
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 the Author
Michael McLaughlin Oracle ACE, is a professor at BYU - Idaho in the Computer Information Technology Department of the Business and Communication School.
Table of Contents
Part I: Development Components
1 Architecture
2 Client Interface
3 Security Models
4 Transaction Models
5 Constraints
Part II: SQL Development
6 Creating Users and Structures
7 Modifying Users and Structures
8 Inserting Data
9 Updating Data
10 Deleting Data
11 Querying
12 Merging Data
13 PL/SQL Programming Language
14 SQL/PSM Basics
15 Triggers
Mastery Check Answers isbn 9781259005312
|
| |
|