book

Oracle Database 11g & MySQL 5.6 Developer Handbook

Name: Oracle Database 11g & MySQL 5.6 Developer Handbook
Author: Michael McLaughlin
ISBN: 9780071768863

by Michael McLaughlin

October 2011

Intermediate to advanced

464 pages

17h 3m

English

McGraw Hill Computing

Read now

Unlock full access

Cover
Title page
Copyright page
Dedication
Contents at a Glance
Contents
Acknowledgments
Introduction
PART I Development Components
1 Architecture
General Client-Server Computing ModelOracle Database 11gClient Software: SQL*PlusOracle 11g Server SoftwareOracle Data DictionaryOracle MySQL 5.6Client Software: The MySQL MonitorMySQL Server SoftwareMySQL Data DictionarySummaryMastery Check

2 Client Interface
SQL*PlusConnecting to and Disconnecting from SQL*PlusWorking in the SQL*Plus EnvironmentWriting SQL Statements with SQL*PlusSaving SQL Statements with SQL*PlusEditing SQL Statements with SQL*PlusRerunning SQL*Plus SQL Statements from the BufferAborting Entry of SQL Statements in SQL*PlusCalling and Running SQL*Plus Script FilesPassing Parameters to SQL*Plus Script FilesCalling PL/SQL ProgramsWriting SQL*Plus Log FilesMySQL MonitorConnecting to and Disconnecting from MySQL MonitorWriting MySQL SQL StatementsSaving MySQL SQL StatementsEditing MySQL SQL StatementsAborting MySQL SQL StatementsCalling and Running MySQL Script FilesSetting a Session VariableCalling SQL/PSM ProgramsWriting MySQL Log FilesSummaryMastery Check
3 Security Models
Security BarriersSecuring the NetworkSecuring the Operating SystemSecuring the DatabaseSecurity PrivilegesData Control LanguageDefiner and Invoker RightsDefiner RightsInvoker RightsSummaryMastery Check
4 Transaction Models
Data TransactionsACID-compliant SQL StatementsINSERT StatementUPDATE StatementDELETE StatementStored ProgramsTriggersSummaryMastery Check
5 Constraints
NOT NULL ConstraintsOracle NOT NULL ConstraintsMySQL NOT NULL ConstraintsUNIQUE ConstraintsOracle UNIQUE ConstraintsMySQL UNIQUE ConstraintsUnique IndexesPrimary Key ConstraintsOracle Primary Key ConstraintsMySQL Primary Key ConstraintsForeign Key ConstraintsOracle Foreign Key ConstraintsMySQL Foreign Key ConstraintsCHECK ConstraintsOracle CHECK ConstraintsMySQL CHECK ConstraintsTrigger ConstraintsSummaryMastery Check
PART II SQL Development
6 Creating Users and Structures
UsersOracle UsersMySQL UsersDatabasesOracle SchemasMySQL DatabasesTablesOracle TablesMySQL TablesIndexesOracle IndexesMySQL IndexesSummaryMastery Check
7 Modifying Users and Structures
UsersOracle UsersMySQL UsersDatabaseSessionsEnable SQL TracingEnable Conditional CompilationTablesData Catalog Table DefinitionsAdding, Modifying, and Dropping ColumnsDropping TablesIndexesOracle Index MaintenanceMySQL Index MaintenanceViewsOracle Drop ViewsMySQL Drop ViewsSummaryMastery Check
8 Inserting Data
Insert by ValuesOracle Insert by ValuesMySQL Insert by ValuesInsert by QueriesOracle Insert by QueriesMySQL Insert by QueriesSummaryMastery Check
9 Updating Data
Update by Values and QueriesOracle Update by Values and QueriesMySQL Update by ValuesUpdate by Correlated QueriesOracle Correlated QueriesMySQL Correlated QueriesSummaryMastery Check
10 Deleting Data
Delete by Value MatchesDelete Nested Table Row ElementsDelete by Correlated QueriesMySQL Delete by Multiple-Table StatementSummaryMastery Check
11 Querying
Query ResultsQueries that Return Columns or Results from ColumnsQueries that AggregateQueries that Return Columns or Results SelectivelyJoin ResultsJoins that Splice Together RowsJoins that Splice CollectionsViews: Stored QueriesCreating Oracle ViewsCreating MySQL ViewsSummaryMastery Check
12 Merging Data
Merging Data in OracleStep 1: Create a Virtual DirectoryStep 2: Position Your Physical CSV FileStep 3: Create Example TablesStep 4: Test ConfigurationStep 5: Merge the Import SourceMerging Data in MySQLImport and Export Data ProcessesMerging with the INSERT statementMerging with the REPLACE INTO StatementSummaryMastery Check
13 PL/SQL Programming Language
PL/SQL BlocksAnonymous BlocksNamed BlocksPL/SQL Variables: Types, Assignments, and OperatorsText Data TypesDate TypesNumber TypesComposite Variable TypesPL/SQL Control StructuresIf StatementCASE StatementIterative StructuresBulk OperationsNative Dynamic SQLNDS Statements Without Bind VariablesNDS Statements with Bind VariablesException HandlingUser-Defined ExceptionsDynamic User-Defined ExceptionsSummaryMastery Check
14 SQL/PSM Basics
SQL/PSM Stored ProgramsFunction and Procedure Coding RulesSQL/PSM FunctionsSQL/PSM ProceduresSQL/PSM VariablesSQL/PSM Local VariablesSQL/PSM CursorsSQL/PSM HandlersSQL/PSM Control StructuresIf StatementsCASE StatementsLoop StatementsPrepared StatementsPrepared Statements at the Command LinePrepared Statements in Stored ProgramsSummaryMastery Check
15 Triggers
Trigger ArchitectureOracle Trigger ArchitectureMySQL Trigger ArchitectureDDL TriggersOracle DDL TriggersMySQL DDL TriggersDML TriggersOracle DML TriggersMySQL DML TriggersCompound TriggersOracle Compound TriggersMySQL Compound TriggersINSTEAD OF TriggersOracle INSTEAD OF TriggersMySQL Instead-of TriggersSystem TriggersOracle System TriggersMySQL System TriggersSummaryMastery Check
Mastery Check Answers
Index

Overview

Master Application Development in a Mixed-Platform Environment

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.

Julian F.

Head of Cybersecurity

I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.

Addison B.

Field Engineer

I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.

Amir M.

Data Platform Tech Lead

I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.

Mark W.

Embedded Software Engineer

OCA Oracle Database 11g Administration I Exam Guide (Exam 1Z0-052)

Publisher Resources

ISBN: 9780071768856

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills