Oracle Database 11g & MySQL 5.6 Developer Handbook
1st Edition
Published on 16. October 2011
676 pages
978-0-07-176886-3 (ISBN)
Available for download
Description
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
- 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
More details
Other editions
Additional editions
Michael McLaughlin
Oracle Database 11g & MySQL 5.6 Developer Handbook
Book
11/2011
Osborne/McGraw-Hill
€55.70
Article not available at the moment
Person
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.
Content
- Cover
- Title page
- Copyright page
- Dedication
- Contents at a Glance
- Contents
- Acknowledgments
- Introduction
- PART I Development Components
- 1 Architecture
- General Client-Server Computing Model
- Oracle Database 11g
- Client Software: SQL*Plus
- Oracle 11g Server Software
- Oracle Data Dictionary
- Oracle MySQL 5.6
- Client Software: The MySQL Monitor
- MySQL Server Software
- MySQL Data Dictionary
- Summary
- Mastery Check
- 2 Client Interface
- SQL*Plus
- Connecting to and Disconnecting from SQL*Plus
- Working in the SQL*Plus Environment
- Writing SQL Statements with SQL*Plus
- Saving SQL Statements with SQL*Plus
- Editing SQL Statements with SQL*Plus
- Rerunning SQL*Plus SQL Statements from the Buffer
- Aborting Entry of SQL Statements in SQL*Plus
- Calling and Running SQL*Plus Script Files
- Passing Parameters to SQL*Plus Script Files
- Calling PL/SQL Programs
- Writing SQL*Plus Log Files
- MySQL Monitor
- Connecting to and Disconnecting from MySQL Monitor
- Writing MySQL SQL Statements
- Saving MySQL SQL Statements
- Editing MySQL SQL Statements
- Aborting MySQL SQL Statements
- Calling and Running MySQL Script Files
- Setting a Session Variable
- Calling SQL/PSM Programs
- Writing MySQL Log Files
- Summary
- Mastery Check
- 3 Security Models
- Security Barriers
- Securing the Network
- Securing the Operating System
- Securing the Database
- Security Privileges
- Data Control Language
- Definer and Invoker Rights
- Definer Rights
- Invoker Rights
- Summary
- Mastery Check
- 4 Transaction Models
- Data Transactions
- ACID-compliant SQL Statements
- INSERT Statement
- UPDATE Statement
- DELETE Statement
- Stored Programs
- Triggers
- Summary
- Mastery Check
- 5 Constraints
- NOT NULL Constraints
- Oracle NOT NULL Constraints
- MySQL NOT NULL Constraints
- UNIQUE Constraints
- Oracle UNIQUE Constraints
- MySQL UNIQUE Constraints
- Unique Indexes
- Primary Key Constraints
- Oracle Primary Key Constraints
- MySQL Primary Key Constraints
- Foreign Key Constraints
- Oracle Foreign Key Constraints
- MySQL Foreign Key Constraints
- CHECK Constraints
- Oracle CHECK Constraints
- MySQL CHECK Constraints
- Trigger Constraints
- Summary
- Mastery Check
- PART II SQL Development
- 6 Creating Users and Structures
- Users
- Oracle Users
- MySQL Users
- Databases
- Oracle Schemas
- MySQL Databases
- Tables
- Oracle Tables
- MySQL Tables
- Indexes
- Oracle Indexes
- MySQL Indexes
- Summary
- Mastery Check
- 7 Modifying Users and Structures
- Users
- Oracle Users
- MySQL Users
- Database
- Sessions
- Enable SQL Tracing
- Enable Conditional Compilation
- Tables
- Data Catalog Table Definitions
- Adding, Modifying, and Dropping Columns
- Dropping Tables
- Indexes
- Oracle Index Maintenance
- MySQL Index Maintenance
- Views
- Oracle Drop Views
- MySQL Drop Views
- Summary
- Mastery Check
- 8 Inserting Data
- Insert by Values
- Oracle Insert by Values
- MySQL Insert by Values
- Insert by Queries
- Oracle Insert by Queries
- MySQL Insert by Queries
- Summary
- Mastery Check
- 9 Updating Data
- Update by Values and Queries
- Oracle Update by Values and Queries
- MySQL Update by Values
- Update by Correlated Queries
- Oracle Correlated Queries
- MySQL Correlated Queries
- Summary
- Mastery Check
- 10 Deleting Data
- Delete by Value Matches
- Delete Nested Table Row Elements
- Delete by Correlated Queries
- MySQL Delete by Multiple-Table Statement
- Summary
- Mastery Check
- 11 Querying
- Query Results
- Queries that Return Columns or Results from Columns
- Queries that Aggregate
- Queries that Return Columns or Results Selectively
- Join Results
- Joins that Splice Together Rows
- Joins that Splice Collections
- Views: Stored Queries
- Creating Oracle Views
- Creating MySQL Views
- Summary
- Mastery Check
- 12 Merging Data
- Merging Data in Oracle
- Step 1: Create a Virtual Directory
- Step 2: Position Your Physical CSV File
- Step 3: Create Example Tables
- Step 4: Test Configuration
- Step 5: Merge the Import Source
- Merging Data in MySQL
- Import and Export Data Processes
- Merging with the INSERT statement
- Merging with the REPLACE INTO Statement
- Summary
- Mastery Check
- 13 PL/SQL Programming Language
- PL/SQL Blocks
- Anonymous Blocks
- Named Blocks
- PL/SQL Variables: Types, Assignments, and Operators
- Text Data Types
- Date Types
- Number Types
- Composite Variable Types
- PL/SQL Control Structures
- If Statement
- CASE Statement
- Iterative Structures
- Bulk Operations
- Native Dynamic SQL
- NDS Statements Without Bind Variables
- NDS Statements with Bind Variables
- Exception Handling
- User-Defined Exceptions
- Dynamic User-Defined Exceptions
- Summary
- Mastery Check
- 14 SQL/PSM Basics
- SQL/PSM Stored Programs
- Function and Procedure Coding Rules
- SQL/PSM Functions
- SQL/PSM Procedures
- SQL/PSM Variables
- SQL/PSM Local Variables
- SQL/PSM Cursors
- SQL/PSM Handlers
- SQL/PSM Control Structures
- If Statements
- CASE Statements
- Loop Statements
- Prepared Statements
- Prepared Statements at the Command Line
- Prepared Statements in Stored Programs
- Summary
- Mastery Check
- 15 Triggers
- Trigger Architecture
- Oracle Trigger Architecture
- MySQL Trigger Architecture
- DDL Triggers
- Oracle DDL Triggers
- MySQL DDL Triggers
- DML Triggers
- Oracle DML Triggers
- MySQL DML Triggers
- Compound Triggers
- Oracle Compound Triggers
- MySQL Compound Triggers
- INSTEAD OF Triggers
- Oracle INSTEAD OF Triggers
- MySQL Instead-of Triggers
- System Triggers
- Oracle System Triggers
- MySQL System Triggers
- Summary
- Mastery Check
- Mastery Check Answers
- Index
