What's New
The Wait for Visual Studio 2008 is Over!
One may picture, too, the sudden shifting of the attention, the swiftly spreading coils and bellyings of that blackness advancing headlong,...
Oracle10g : Introduction to SQL
DAY_DBA - Oracle 10g: 2 Day DBA
Oracle Database 2 Day DBA is for anyone who wants to perform common day-to-day
administrative tasks with the Oracle Database. Prior knowledge or experience with managing
databases is not required. The only requirement is a basic knowledge of computers. This book is
equally useful for enterprise DBAs. It provides recommended best practices and describes
efficient ways of performing administrative tasks with Oracle Enterprise Manager as the primary
interface.
Who the course is for
• Database administrators
• System administrators
• Consultants
• Technical Support Staff
What we teach you
• Manage schema objects
• Monitor the database and use the Advisors
• Use Enterprise Manager Database Control to manage the database
• Administer users and security
• Manage database storage structures
• Configure and manage the Oracle Network environment
• Back up and recover the Oracle Database
• Install Oracle Database software and create a database
Required skills
Working knowledge of SQL
Teaching methods
Expert instruction with practical examples, computer practice
Teaching materials
Standard Oracle University Kits
Course syllabus
Overview of Oracle Database Administration
• Overview of the Oracle Instance and Database
• Tasks of an Oracle Database Administrator
• Tools Used to Administer an Oracle Database
• Working with Oracle Support
• Searching MetaLink
• Logging TARs
Installing Oracle Software and Creating the Database
• Using the Oracle Universal Installer (OUI)
• Installation Pre-requisites
• Installing the Oracle Software
• Using the Database Configuration Assistant (DBCA) to Create a Database
• Using DBCA to Manage Templates
• Upgrading the Database Using the Database Upgrade Assistant (DBUA)
• Install the Oracle Software Using OUI
• Use the DBCA to Create a Database Using Oracle Enterprise Manager Database Control and
SQL*Plus
• Overview of Administering the Database Using Enterprise Manager (EM)
• Starting the EM Database Console
• Enterprise Manager Navigation
• Granting EM Administrative Privileges
• Grant EM Administrative Privileges to Another User
Configuring the Oracle Network Environment
• Network Configuration Overview
• Oracle Net Listener Configuration and Management
• Oracle Net Naming Methods
• Tools for Configuring and Managing the Oracle Network
• Using EM to Configure and Manage the Oracle Network
• Start and Stop the Listener
• Configure Local Naming
• Connect to the Database
Managing the Oracle Instance
• Oracle Instance and Instance Management
• Memory Structures
• Background Processes
• Accessing the Oracle Database
• Initialization Parameters
• Password File
• Starting Up and Shutting Down the Instance
• Viewing the Alert Log and Trace Files
Managing Database Storage Structures
• Oracle Database Structures
• Control Files
• Multiplexing and Archiving the Redo Log Files
• Tablespaces and Data Files
• Creating a New Tablespace
• Managing Undo in the Database
• Using the Undo Advisor
• Use EM to View the Storage Structure of the Database
Administering Users and Security
• Overview of Users and Security
• Creating and Administering Users
• Locking and Unlocking Accounts
• Setting Passwords
• Administering Privileges and Roles
• Create a New User
• Grant Privileges to the User
• Lock and Unlock the User Account
Managing Schema Objects
• Creating Schema Objects
• Create a New Table and View the Attributes and Contents of a Table
• Understanding Data Integrity and Defining Constraints
• Creating and Viewing Attributes of Indexes
• Creating Views
• Loading Data
• Export and Import
• External Tables
Performing Backup and Recovery
• Backup, Restore and Recovery Concepts
• Configuring the Database for Backup and Recovery and Setting Backup Policies
• Configure the ARCHIVELOG Mode and Automatic Archiving
• Configure the Flash Recovery Area
• Retention Policy
• Backing Up the Database Using EM
• Oracle-Suggested Backup Strategy
• Perform a Whole Database Backup and Recovery
Monitoring and Tuning the Database
• Monitoring the Oracle Database
• Self-Monitoring Architecture
• Automatic Workload Repository
• Metrics, Thresholds, and Alerts
• Automatic Database Diagnostics Monitor (ADDM)
• Monitoring and Tuning Usage Model
• Setting Up Notification Rules
• Using the Advisors
| Attachment | Size |
|---|---|
| Oracle10g2 DaysDBA.pdf | 56.66 KB |
Code:
10g SQL
Duration:
5
Price:
6000000
Schedule:
Available Upon Request
Copyright 2010 Iverson Technology. All Rights Reserved.