book

Oracle Database 11g & MySQL 5.6 Developer Handbook

by Michael McLaughlin

October 2011

Intermediate to advanced

464 pages

17h 3m

English

McGraw Hill Computing

Read now

Unlock full access

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

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
Security BarriersSecuring the NetworkSecuring the Operating SystemSecuring the DatabaseSecurity PrivilegesData Control LanguageDefiner and Invoker RightsDefiner RightsInvoker RightsSummaryMastery Check
Data TransactionsACID-compliant SQL StatementsINSERT StatementUPDATE StatementDELETE StatementStored ProgramsTriggersSummaryMastery Check
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
UsersOracle UsersMySQL UsersDatabasesOracle SchemasMySQL DatabasesTablesOracle TablesMySQL TablesIndexesOracle IndexesMySQL IndexesSummaryMastery Check
UsersOracle UsersMySQL UsersDatabaseSessionsEnable SQL TracingEnable Conditional CompilationTablesData Catalog Table DefinitionsAdding, Modifying, and Dropping ColumnsDropping TablesIndexesOracle Index MaintenanceMySQL Index MaintenanceViewsOracle Drop ViewsMySQL Drop ViewsSummaryMastery Check
Insert by ValuesOracle Insert by ValuesMySQL Insert by ValuesInsert by QueriesOracle Insert by QueriesMySQL Insert by QueriesSummaryMastery Check
Update by Values and QueriesOracle Update by Values and QueriesMySQL Update by ValuesUpdate by Correlated QueriesOracle Correlated QueriesMySQL Correlated QueriesSummaryMastery Check
Delete by Value MatchesDelete Nested Table Row ElementsDelete by Correlated QueriesMySQL Delete by Multiple-Table StatementSummaryMastery Check
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
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
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
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
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