Oracle 11g Database Administration / DBA (Hands-on)

Please Contact
Posted over a month ago
Mississauga, ON L4W3W6(View Map)


Oracle 11g Database Administration / DBA : Interactive instructor-led (hands-on) Flexible Schedules, affordable price, 100% Success.. This online IT Training course is conducted one to one basis or in a small group with very reasonable FEE.

Online interactive hands-on instructor led training help candidates to learn Oracle 11g Database Architecture and day-to-day activities of a DBA such as Database installation, backup & recovery, troubleshooting performance issues. We give special care to every candidates to complete the hands-on lab exercises on each topic.

Please contact us for detail

Introduction to DBA • Relational Database Systems • Integrity Constraints • Structured Query Language • Tasks of an Oracle Database Administrator

Oracle Server Installtion • Installation of Oracle Database Software • Optimal Flexible Architecture (OFA) • Oracle Universal Installer • Prerequisite Checks • Configuration Assistants

Database Creation • Creating an Oracle Database • Database Architecture • Exploring the Storage Structure • Control Files • Redo Log Files • Tablespaces and Datafiles • Segments, Extents, and Blocks • Oracle Instance Management • Oracle Memory Structures • Oracle Processes • Data Dictionary • Database Control • Grid Control • Database Configuration Assistant (DBCA) Overview • Creating a Database • Passwords and Storage • File Locations and Backup Recovery • Content and Initialization Parameters • Other Actions with DBCA

Managing the Database • Starting and Stopping iSQL*Plus • Starting and Stopping Database Control • Accessing Database Control • SYSOPER and SYSDBA • Database Home Page • Changing the Listener Status • NOMOUNT MOUNT OPEN States • SHUTDOWN Options • Initialization Parameter Files • Viewing the Alert Log

Net Services • Oracle Net Services • Oracle Net Listener • Monitoring the Listener • Listening Addresses • Static Database Registration • Listener Control Utility • Oracle Net Connections • Directory Naming • Advanced Connections • Oracle Net Manager • Configuring Service Aliases with Net Manager

Managing Schema Objects • Schemas • Accessing Schema Objects • Schema Object Namespaces • Specifying Data Types in Tables • Other Data Types • Creating and Modifying Tables • Understanding Data Integrity • Defining Constraints • Viewing the Attributes of a Table • Viewing the Contents of a Table • Creating Indexes • Creating Views • Using a Sequence

Storage Structures • Tablespaces and Data Files • Space Management in Tablespaces • Storage for Locally Managed Tablespaces • Altering a Tablespace • Actions with Tablespaces • Dropping Tablespaces • Viewing Tablespace Information

Administering Users • Database User Accounts • Creating a User • Profiles and Users • Authenticating Users • Database Users and Schemas • Privileges : System and Object

Roles • Assigning Quota to Users • Assigning Roles to Users

Managing Data • Manipulating Data Through SQL • The INSERT Command • The UPDATE Command • The DELETE Command • The COMMIT and ROLLBACK Commands • Integrity Constraints and DML

Oracle Utilities • Data Pump (Export & Import) • DIRECTORY Objects • SQL*Loader • The SQL*Loader Control File • Loading Methods • Comparing Direct and Conventional Path Loads • External Tables • Transportable tablespace

Undo Management • Undo Data • Transactions and Undo Data • Storing Undo Information • Monitoring Undo • Administering Undo • Configuring Undo Retention • Guaranteeing Undo Retention • Sizing the Undo Tablespace • Using the Undo Advisor

Database Backup and Recovery • Backup and Recovery Concepts • Backup and Recovery Issues • Categories of Failures • Instance Recovery • Phases of Instance Recovery • Tuning Instance Recovery • Using the MTTR Advisor • Configuring for Recoverability • ARCHIVELOG Mode • Configuring Backup Strategy • Scheduling Backups: Review • Backup Control File to Trace • Manage Backups

Database Recovery • Opening a Database • Changing Instance Status • Keeping a Database Open Scenarios: • Loss of a Control File • Loss of a Redo Log File • Loss of a Data File in NOARCHIVELOG Mode • Loss of a Noncritical Data File in ARCHIVELOG Mode • Loss of a System-Critical Data File in ARCHIVELOG Mode • Oracle Recovery Manager • Oracle Recovery Catalog maintenance • Backups using Oracle Recovery Manager • Recovery using Oracle recovery manager

• Database Cloning using RMAN • Tablespace Point in time recovery • Incomplete recovery

Database Monitoring • Monitoring and Resolving Lock Conflicts • Locks • Locking Mechanism • Data Concurrency • DML Locks • Enqueue Mechanism • Lock Conflicts • Possible Causes of Lock Conflicts • Detecting Lock Conflicts • Resolving Lock Conflicts • Deadlocks

Performance Monitoring • Monitoring Methodologies • Database and Instance Metrics • Data Dictionary Metrics • Optimizer Statistics • Schedule Optimizer Statistics Collection • Dynamic Performance Views • Viewing Metric Information • Reacting to Performance Issues • Reacting to Performance Issues

Proactive Maintenance • Server Generated Alerts • Thresholds • Setting Thresholds • Baseline Measurements • Tuning and Diagnostic Advisors • SQL Tuning and Access Advisors • Memory Advisors • Segment Advisor • Automatic Workload Repository (AWR) • Managing the AWR • Automatic Database Diagnostic Monitor (ADDM)

Skill Learning Program

66 visits
About the Poster
Sign in or register to see this poster's details, including:
  • When they joined Kijiji
  • How quickly they respond
  • Other ads they have posted
  • Phone number (if available)

Contact Poster

Kijiji filters and masks emails for security reasons. By clicking on "Send Email", you consent to this action in accordance with our Terms of Use and Privacy Policy.

Take steps to make your Kijiji transactions as secure as possible by following our suggested safety tips.Read our Safety Tips

My Favourites ()

Recently Added: