ORACLE DBA Workshop

MTI EDGE
Fremont, CA, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Teacher/Instructor: Industry Experts
Term: 40 classroom hrs
Seats: 5 to 10
Fee: 1500

Course Description:

'' Course Fees: $1500.00
Duration: 40 Classroom Hours, weekends and weekday evenings.
ORACLE Access: 2 Months ORACLE access for practice and home study from the date of enrollment.

Course Outline

Oracle10gâ„?Database: Administration I â„?
* Installing Oracle10gâ„?Database Software
* Identify system requirements
* Use Optimal Flexible Architecture
* Install software with Oracle Universal Installer
* Identify and configure commonly used environment variables
* Creating an Oracle Database
* Explain the Oracle database architecture
* Explain the instance architecture
* Use the management framework
* Use DBCA to Create a database
* Use DBCA to Configure a database
* Use DBCA to Drop a database
* Use DBCA to Manage templates
* Managing Schema Objects
* Create and modify tables
* Define constraints
* View the attributes of a table
* View the contents of a table
* Create indexes and views
* Name database objects
* Select appropriate data types
* Create and use sequences
* Managing Data
* Manipulate data through SQL using INSERT, UPDATE, and DELETE
* Use Data Pump to export data
* Use Data Pump to import data
* Load data with SQL Loader
* Create directory objects
* PL/SQL
* Identify PL/SQL objects
* Describe triggers and triggering events
* Identify configuration options that affect PL/SQL performance
* Undo Management
* Monitor and administer undo
* Configure undo retention
* Guarantee undo retention
* Use the Undo Advisor
* Describe the relationship between undo and transactions
* Size the undo tablespace
* Monitoring and Resolving Lock Conflicts
* Detect and resolve lock conflicts
* Manage deadlocks
* Describe the relationship between transactions and locks
* Explain lock modes within the Oracle10gâ„?Database
* Database Interfaces
* Use SQL*Plus and iSQL*Plus to access the Oracle10gâ„?Database
* Use SQL*Plus and iSQL*Plus to describe the logical structure of tables
* Use SQL to query, manipulate, and define data using SELECT, UPDATE/INSERT/DELETE and
* CREATE/ALTER/DROP statements
* Identify common database interfaces
* Describe a database transaction
* Controlling the Database
* Start and stop iSQL*Plus
* Start and stop Enterprise Manager Database Control
* Start and stop the Oracle Listener
* Start up and shut down Oracle10gâ„?Database
* Describe startup and shutdown options for the Oracle Database
* Handle Parameter files
* Locate and view the Database alert log
* Oracle Database Security
* Apply the principal of least privilege
* Manage default user accounts
* Implement standard password security features
* Audit database activity
* Register for security updates
* Oracle Net Services
* Use Database Control to Create additional listeners
* Use Database Control to Create Oracle Net service aliases
* Use Database Control to Configure connect time failover
* Use Listener features
* Use the Oracle Net Manager to configure client and middle-tier connections
* Use TNSPING to test Oracle Net connectivity
* Describe Oracle Net Services
* Describe Oracle Net names resolution methods
* Backup and Recovery Concepts
* Describe the basics of database backup, restore and recovery
* Describe the types of failure that may occur in an Oracle Database
* Describe ways to tune instance recovery
* Identify the importance of checkpoints, redo log files, and archived log files
* Configure ARCHIVELOG mode
* Configure a database for recoverability
* Storage Structures
* Define the purpose of tablespaces and data files
* Create tablespaces
* Manage tablespaces (alter, drop, generate DDL, take offline, put on line, add data files, make
read-only/read-write)
* Obtain tablespace information from EM and the data dictionary
* Drop tablespaces
* Describe the default tablespaces
* Administering Users
* Create and manage database user accounts
* Create and manage roles
* Grant and revoke privileges
* Control resource usage by users
* Oracle Shared Servers
* Identify when to use Oracle Shared Servers
* Configure Oracle Shared Servers
* Monitor Shared Servers
* Describe the shared server architecture
* Performance Monitoring
* Troubleshoot invalid and unusable objects
* Gather optimizer statistics
* View performance metrics
* React to performance issues
* Proactive Maintenance
* Set warning and critical alert thresholds
* Collect and use baseline metrics
* Use tuning and diagnostic advisors
* Use the Automatic Database Diagnostic Monitor (ADDM)
* Manage the Automatic Workload Repository
* Describe server generated alerts
* Database Backups
* Create consistent database backups
* Back up your database without shutting it down
* Create incremental backups
* Automate database backups
* Monitor the flash recovery area
* Describe the difference between image copies and backup sets
* Describe the different types of database backups
* Backup a control file to trace
* Manage backups
* Database Recovery
* Recover from loss of a Control file
* Recover from loss of a Redo log file
* Recover from loss of a system-critical data file
* Recover from loss of a non system-critical data file

Oracle10gâ„?Database: Administration II â„?
* Using Globalization Support Objectives
* Customize language-dependent behavior for the database and individual sessions
* Specify different linguistic sorts for queries
* Use datatime datatypes
* Query data using case insensitive and accent insensitive searches
* Obtain Globalization support configuration information
* Securing the Oracle Listener
* Secure the listener
* Remove default EXTPROC entry and add a separate listener to handle external procedure calls
* Configuring Recovery Manager
* Configure database parameters that affect RMAN operations
* Change RMAN default settings with CONFIGURE
* Manage RMAN’s persistent settings
* Start RMAN utility and allocate channels
* Recovering from User Errors
* Recover a droppedusing Flashback technology
* Perform Flashbackoperation
* Manage the recycle bin
* Recover from user errors using Flashback versions query
* Perform transaction level recovery using Flashback Transaction query
* Dealing with Database Corruption
* Define block corruption and list its causes and symptoms
* Detect database corruptions using the following utilities: ANALYZE DBVERIFY
* Detect database corruptions using the dbms_repair package
* Implement the DB_BLOCK_CHECKING parameter to detect corruptions
* Repair corruptions using RMAN
* Automatic Database Management
* Use the Database Advisors to gather information about your database
* Use the SQL Tuning Advisor to improve database performance
* Use automatic undo retention tuning
* Using Recovery Manager
* Use the RMAN BACKUP command tobackup sets and image copies
* Enable block change tracking
* Manage the backups and image copies taken with RMAN with the LIST and REPORT
commands
* Diagnostic Sources
* Use the alert log and database trac ...''

Phone:510 440 1200

School Address:

42472 Albrae Street

Jobs & Resumes: Fremont
Houses & Roommates: Fremont

Search other schools for ORACLE DBA training resources.

SAP FI/CO, SD, MM, BI/BW, HR, Security/ABAP
SAP FICO
SAP MM
SAP SD
SAP Security/ABAP
SAP HR module
SAP Netweaver
ORACLE 11i APPS DBA
Oracle 10g PL/SQL
ORACLE 9i RAC
ORACLE SOA/BPEL
Oracle Enterprise

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.