Oracle Database 11g and MySQL 5.6 Developer Handbook

Michael McLaughlin

608 pages, parution le 15/01/2012

Ajouter à une liste

Indisponible

Résumé

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

L'auteur - Michael McLaughlin

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.

Sommaire

Development Components
- Architecture
- Client Interface
- Security Models
- Transaction Models
- Constraints
SQL Development
- Creating Users and Structures
- Modifying Users and Structures
- Inserting Data
- Updating Data
- Deleting Data
- Querying
- Merging Data
- PL/SQL Programming Language
- SQL/PSM Basics
- Triggers
- Mastery Check Answers

Voir tout

Replier

Caractéristiques techniques

	PAPIER
Éditeur(s)	Mc Graw Hill
Auteur(s)	Michael McLaughlin
Parution	15/01/2012
Nb. de pages	608
Couverture	Broché
Intérieur	Noir et Blanc
EAN13	9780071768856
ISBN13	978-0-07-176885-6