book

Oracle Database 11g A Beginner's Guide

by Ian Abramson, Michael Abbey, Michael Corey

October 2008

Beginner

432 pages

10h 25m

English

McGraw Hill Computing

Read now

Unlock full access

Cover Page
Oracle Database 11g: A Beginner’s Guide
Copyright Page
Contents
ACKNOWLEDGMENTS
INTRODUCTION
1 Database Fundamentals
Critical Skill 1.1 Define a DatabaseCritical Skill 1.2 Learn the Oracle Database 11g ArchitectureThe Control FilesThe Online Redo LogsThe System TablespaceThe Sysaux TablespaceDefault Temporary TablespaceUndo TablespaceThe Server Parameter FileBackground ProcessesProject 1-1 Review the Oracle Database 11g ArchitectureThe Database AdministratorCritical Skill 1.3 Learn the Basic Oracle Database 11g Data Typesvarchar2numberdatetimestampclobblobCritical Skill 1.4 Work with TablesTables Related to part_masterCritical Skill 1.5 Work with Stored Programmed ObjectsViewsTriggersProceduresFunctionsPackagesCritical Skill 1.6 Become Familiar with Other Important Items in Oracle Database 11gIndexesUsersTablespace QuotasSynonymsRolesDefault User EnvironmentsCritical Skill 1.7 Work with Object and System PrivilegesSelectInsertUpdateDeleteSystem PrivilegesCritical Skill 1.8 Introduce Yourself to the GridCritical Skill 1.9 Tie It All TogetherChapter 1 Mastery Check
2 Installing Oracle
Critical Skill 2.1 Research and Plan the InstallationDefine System RequirementsLinux InstallationCritical Skill 2.2 Set Up the Operating SystemProject 2-1 Configure Kernel ParametersCritical Skill 2.3 Get Familiar with LinuxCritical Skill 2.4 Choose Components to InstallCritical Skill 2.5 Install the Oracle SoftwareDatabase Configuration AssistantVerify the InstallationChapter 2 Mastery Check
3 Connecting to Oracle
Critical Skill 3.1 Use Oracle Net ServicesNetwork ProtocolsOptimize Network BandwidthConnectionsMaintain ConnectionsDefine a LocationCritical Skill 3.2 Learn the Difference Between Dedicated and Shared Server ArchitecturesDedicated ServerShared ServerSet DispatchersViews to Monitor the Shared ServerCritical Skill 3.3 Define ConnectionsA Connect DescriptorDefine a Connect DescriptorThe Oracle Connection ManagerSession MultiplexingFirewall Access ControlCritical Skill 3.4 Use the Oracle Net ListenerPassword AuthenticationMultiple ListenersConnection PoolingCritical Skill 3.5 Learn Naming MethodsDirectory Naming MethodDirectory Information TreesDistinguished NamesHow to Find the Directory Naming InformationNet Service Alias EntriesThe Local Naming MethodThe Easy Naming MethodThe External Naming MethodWhich Naming Method to UseCritical Skill 3.6 Use Oracle Configuration FilesCritical Skill 3.7 Use Administration ToolsThe Oracle Enterprise Manager/Grid ControlThe Oracle Net ManagerThe OEM ConsoleThe OEM ComponentsThe Oracle Net Configuration AssistantThe Oracle Internet Directory Configuration AssistantCommand-Line UtilitiesThe Oracle Advanced Security OptionDispatchersProject 3-1 Test a ConnectionCritical Skill 3.8 Use ProfilesCritical Skill 3.9 Network in a Multi-tiered EnvironmentCritical Skill 3.10 Install the Oracle 11g Client SoftwareChapter 3 Mastery Check
4 SQL: Structured Query Language
Critical Skill 4.1 Learn the SQL Statement ComponentsDDLDMLCritical Skill 4.2 Use Basic Insert and Select StatementsInsertSelectCritical Skill 4.3 Use Simple Where ClausesA Where Clause with and/orThe Where Clause with NOTThe Where Clause with a Range SearchThe Where Clause with a Search ListThe Where Clause with a Pattern SearchThe Where Clause: Common OperatorsCritical Skill 4.4 Use Basic Update and Delete StatementsUpdateDeleteCritical Skill 4.5 Order DataCritical Skill 4.6 Employ Functions: String, Numeric, Aggregate (No Grouping)String FunctionsNumeric FunctionsAggregate FunctionsCritical Skill 4.7 Use Dates and Data Functions (Formatting and Chronological)Date FunctionsSpecial Formats with the Date Data TypeNested FunctionsCritical Skill 4.8 Employ Joins (ANSI vs. Oracle): Inner, Outer, SelfInner JoinsOuter JoinsProject 4-1 Join Data Using Inner and Outer JoinsProject 4-2 Join Data Using ANSI SQL JoinsSelf-JoinsCritical Skill 4.9 Learn the Group By and Having ClausesGroup ByHavingProject 4-3 Group Data in Your Select StatementsCritical Skill 4.10 Learn Subqueries: Simple and Correlated Comparison with JoinsSimple SubqueryCorrelated Subqueries with JoinsCritical Skill 4.11 Use Set Operators: Union, Intersect, MinusUnionUnion AllIntersectMinusProject 4-4 Use the Union Function in Your SQLCritical Skill 4.12 Use ViewsCritical Skill 4.13 Learn Sequences: Just Simple StuffCritical Skill 4.14 Employ Constraints: Linkage to Entity Models, Types, Deferred, Enforced, Gathering ExceptionsLinkage to Entity ModelsTypesDeferredCritical Skill 4.15 Format Your Output with SQL *PlusPage and Line SizePage TitlesPage FootersFormatting ColumnsProject 4-5 Format Your SQL OutputWriting SQL*Plus Output to a FileChapter 4 Mastery Check

5 PL/SQL
Critical Skill 5.1 Define PL/SQL and Learn Why We Use ItCritical Skill 5.2 Describe the Basic PL/SQL Program StructureCritical Skill 5.3 Define PL/SQL Data TypesValid CharactersArithmetic OperatorsThe varchar2 Data TypeThe Number Data TypeThe Date Data TypeThe Boolean Data TypeCritical Skill 5.4 Write PL/SQL Programs in SQL*PlusProject 5-1 Create a PL/SQL ProgramSQL in Your PL/SQL ProgramsPL/SQL CursorsThe Cursor FOR LoopCritical Skill 5.5 Handle Error Conditions in PL/SQLError Handling Using Oracle-Supplied VariablesCritical Skill 5.6 Include Conditions in Your ProgramsProgram ControlProject 5-2 Use Conditions and Loops in PL/SQLCritical Skill 5.7 Create Stored Procedures—How and WhyCritical Skill 5.8 Create and Use FunctionsProject 5-3 Create and Use a FunctionCritical Skill 5.9 Call PL/SQL ProgramsChapter 5 Mastery Check
6 The Database Administrator
Critical Skill 6.1 Learn What a DBA DoesCritical Skill 6.2 Perform Day-to-Day OperationsArchitecture and DesignCapacity PlanningBackup and RecoverySecurityPerformance and TuningManaging Database ObjectsStorage ManagementChange ManagementSchedule JobsNetwork ManagementTroubleshootingCritical Skill 6.3 Understand the Oracle Database 11g InfrastructureSchemasStorage StructuresCritical Skill 6.4 Operate Modes of an Oracle Database 11gModes of OperationDatabase and Instance ShutdownCritical Skill 6.5 Get Started with Oracle Enterprise ManagerInstance ConfigurationUser SessionsResource Consumer GroupsSchema, Security, and Storage ManagementDistributed ManagementWarehouse FeaturesOther ToolsCritical Skill 6.6 Manage Database ObjectsControl FilesRedo LogsUndo ManagementSchema ObjectsCritical Skill 6.7 Manage SpaceArchive LogsTablespaces and Data FilesCritical Skill 6.8 Manage UsersCreate a UserEdit UsersCritical Skill 6.9 Manage Privileges for Database UsersGrant AuthorityRolesProfilesProject 6-1 Create Essential ObjectsChapter 6 Mastery Check
7 Backup and Recovery
Critical Skill 7.1 Understand Oracle Backup and Recovery FundamentalsWhere Do I Start?Backup ArchitectureOracle BinariesParameter FilesControl FilesRedo LogsUndo SegmentsCheckpointsArchive LogsData Files, Tablespaces, Segments, Extents, and BlocksDump FilesCritical Skill 7.2 Learn about Oracle User-Managed Backup and RecoveryTypes of User-Managed BackupsCold BackupsHot BackupsRecovery from a Cold BackupRecovery from a Hot BackupSeven Steps to RecoveryRecovery Using Backup Control FilesCritical Skill 7.3 Write a Database BackupCritical Skill 7.4 Back Up Archived Redo LogsCritical Skill 7.5 Get Started with Oracle Data PumpCritical Skill 7.6 Use Oracle Data Pump ExportCritical Skill 7.7 Work with Oracle Data Pump ImportCritical Skill 7.8 Use Traditional Export and ImportCritical Skill 7.9 Get Started with Recovery ManagerRMAN ArchitectureSet Up a Recovery Catalog and Target DatabaseKey RMAN FeaturesBackupsRMAN Using Enterprise ManagerPerforming BackupsRestore and RecoveryProject 7-1 RMAN End to EndChapter 7 Mastery Check
8 High Availability: RAC, ASM, and Data Guard
Critical Skill 8.1 Define High AvailabilityCritical Skill 8.2 Understand Real Application ClustersCritical Skill 8.3 Install RACCritical Skill 8.4 Test RACWorkload ManagerASMCritical Skill 8.5 Set Up the ASM InstanceProject 8-1 Install ASMLibCritical Skill 8.6 Create ASM Disk GroupsProject 8-2 Create Disk GroupsCritical Skill 8.7 Use ASMCMD and ASMLIBCritical Skill 8.8 Convert an Existing Database to ASMCritical Skill 8.9 Understand Data GuardCritical Skill 8.10 Explain Data Guard Protection ModesCritical Skill 8.11 Create a Physical Standby ServerProject 8-3 Create a Physical Standby ServerChapter 8 Mastery Check
9 Large Database Features
Critical Skill 9.1 Learn to Identify a Very Large DatabaseCritical Skill 9.2 Why and How to Use Data PartitioningWhy Use Data PartitioningImplement Data PartitioningProject 9-1 Create a Range-Partitioned Table and a Local-Partitioned IndexCritical Skill 9.3 Compress Your DataData CompressionIndex Key CompressionCritical Skill 9.4 Use Parallel Processing to Improve PerformanceParallel Processing Database ComponentsParallel Processing ConfigurationInvoke Parallel ExecutionCritical Skill 9.5 Use Materialized ViewsUses for Materialized ViewsQuery RewriteWhen to Create Materialized ViewsCreate Materialized ViewsCritical Skill 9.6 Use SQL Aggregate and Analysis FunctionsAggregation FunctionsAnalysis FunctionsOther FunctionsCritical Skill 9.7 Create SQL ModelsProject 9-2 Use Analytic SQL Functions and ModelsChapter 9 Mastery Check
A Mastery Check Answers
Chapter 1: Database FundamentalsChapter 2: Installing OracleChapter 3: Connecting to OracleChapter 4: SQL: Structured Query LanguageChapter 5: PL/SQLChapter 6: The Database AdministratorChapter 7: Backup and RecoveryChapter 8: High Availability: RAC, ASM, and Data GuardChapter 9: Large Database Features
Index

Overview

Get a Solid Foundation in Oracle Database Technology

Master Oracle Database 11g fundamentals quickly and easily. Using self-paced tutorials, this book covers core database essentials, the role of the administrator, high availability, and large database features. Oracle Database 11g: A Beginner's Guide walks you, step by step, through database setup, administration, programming, backup, and recovery. In-depth introductions to SQL and PL/SQL are included. Designed for easy learning, this exclusive Oracle Press guide offers:

Core Concepts--Oracle Database 11g topics presented in logically organized chapters
Critical Skills--Lists of specific skills covered in each chapter
Projects--Practical exercises that show how to apply the critical skills learned in each chapter
Progress Checks--Quick self-assessment sections to check your progress
Notes--Extra information related to the topic being covered
Mastery Checks--Chapter-ending quizzes to test your knowledge

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

Publisher Resources

ISBN: 9780071604598

Cloud Computing

Data Engineering

Data Science

AI & ML

Programming Languages

Software Architecture

IT/Ops

Security

Design

Business

Soft Skills