DBA Training Courses and Workshops

Schools providing training courses, certificates, diplomas or degree programs of Database Administrator




Total 268 training courses and degree programs available around the world.

United States - United Kingdom - Canada - Australia - India

Popular courses:
Oracle DBA
MCDBA
Oracle 10g DBA
Giving and Receiving Feedback
SQL Server DBA
Advanced Services Implementing Broadband Aggregation on Cisco 10000 Series


Oracle 11g DBA (Certificate)

Course Format: Online
School/Trainer: Intertech, Inc.
Training Center(s)/Venue(s): Eagan, United States
  V

Oracle Database 11g, building on Oracle&,#146,s unique ability to deliver Grid Computing, gives Oracle customers the agility to respond faster to changing business conditions, gain competitive advantage through technology innovation, and reduce costs.

With Oracle Database 11g you can:
Adopt new technology faster with Real Application Testing
Manage more data for less with advanced compression and partitioning
Simplify systems by storing all your data in the Oracle Database with Oracle Secure Files
Maximize the ROI of disaster recovery resources with Oracle Active Data Guard
Free critical personnel for strategic tasks with management automation

DBA

Course Format: Classroom
School/Trainer: Globe University - Wisconsin
Training Center(s)/Venue(s): Appleton, Eau Claire, La Crosse, Madison, Wausau, United States
  V

Students work with an industry-leading database server,
practicing skills and technologies required to install, replicate, and carry out
other common administrative and maintenance tasks. They also explain and
demonstrate data migration, data cleaning, data preservation, concurrency,
replication, distributed models, database security and data mining tasks.

DBA

Course Format: Classroom
School/Trainer: Globe University Sioux Falls Campus
Training Center(s)/Venue(s): Sioux Falls, United States
  V

Students work with an industry-leading database server,
practicing skills and technologies required to install, replicate, and carry out
other common administrative and maintenance tasks. They also explain and
demonstrate data migration, data cleaning, data preservation, concurrency,
replication, distributed models, database security and data mining tasks.

DBA

Course Format: Classroom
School/Trainer: Minnesota School of Business & Globe University
Training Center(s)/Venue(s): Blaine, Minneapolis, Richfield, Rochester, Woodbury, United States
  V

Students work with an industry-leading database server,
practicing skills and technologies required to install, replicate, and carry out
other common administrative and maintenance tasks. They also explain and
demonstrate data migration, data cleaning, data preservation, concurrency,
replication, distributed models, database security and data mining tasks.

Oracle Database 11g Security DBA

Course Format: Classroom
School/Trainer: Koenig Solutions Ltd.
Training Center(s)/Venue(s): Bangalore, Dehradun, Goa, New Delhi, Shimla, India
  V

Koenig offers a course on Oracle Database 11g: Security DBA Release 2. After completing Oracle security training, students will be able to learn how to employ Oracle Database features to meet the security, privacy and compliance requirements of their organization. Students will also learn to execute Oracle Database security features to ensure the data is secure and compliance with regulations. This course is best suited for: administrators, database administrators, security administrators, support engineers, system analysts, and technical administrators.

Course Objectives

Choose Security Solutions
Audit Database Users, Privileges, and Objects
Audit DML Statements
Use Basic User Authentication
Use Strong Authentication
Use Enterprise User Security
Use Proxy Authentication
Oracle Label Security Concepts
Implement Oracle Label Security
Use the Data Masking Pack
Encryption Concepts
Use Application-Based Encryption
Apply Transparent Data Encryption
Apply File Encryption
Oracle Net Services: Security Checklists
Secure the Listener

Oracle Database 11g: Performance Tuning DBA Release 2 Workshop (Certificate)

Course Format: Classroom
School/Trainer: Koenig Solutions Ltd.
Training Center(s)/Venue(s): Bangalore, Dehradun, Goa, New Delhi, Shimla, India
  V

Students learn how to use Oracle Database 11g automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement performance, and tuning the Oracle Database Instance components.

Course Objectives

Describe Oracle tuning methodology.
Use Oracle supplied tools for monitoring and diagnosing SQL and Instance tuning issues.
Use database advisors to correct performance problems proactively.
Identify problem SQL statements &, tune SQL performance problems.

Oracle 11g DBA OCA & OCP Workshop (Certificate)

Course Format: Classroom
School/Trainer: Koenig Solutions Ltd.
Training Center(s)/Venue(s): Bangalore, Dehradun, Goa, New Delhi, Shimla, India
  V

Koenig offers a course on Oracle 11g DBA OCA &, OCP. Oracle 11g DBA training takes the database administrator beyond the basic tasks covered in the SQL NEW and Administration Workshop I. Students will gain a deep understanding of the most important responsibilities a DBA has: performing backup and recovery. After completing this course, students will be able to diagnose and repair data failures with Flashback technology and manage space to optimize database storage.

Course Objectives

Configure for Recoverability
Use the RMAN Recovery Catalog
Configure Backup Settings
Create Backups with RMAN
Restore and Recovery Task
Use RMAN to Perform Recovery
Monitor and Tune RMAN
Diagnose the Database
Use Flashback Technology I
Use Flashback Technology II
Perform Flashback Database
Manage Memory
Manage Database Performance
Manage Performance by SQL Tuning
Manage Resources
Automate Tasks with the Scheduler
Manage Space in Blocks
Manage Space in Seg/ments
Manage Space for the Database
Duplicate a Database

OCA DBA 11g (Certificate)

Course Format: Classroom
School/Trainer: Koenig Solutions Ltd.
Training Center(s)/Venue(s): Bangalore, Dehradun, Goa, New Delhi, Shimla, India
  V

Oracle Certified Associate (OCA) DBA 11g is designed for IT professionals who are beginning to work with Oracle technologies. This certificate is appropriate for junior-level database administrators that maintain an Oracle database, or work on a team that administers the DBMS in a business environment.

This certification validates the fundamental skills needed to install, configure and maintain an Oracle database. Oracle Database 11g Administrator Certified Associates can also configure and manage the Oracle network environment.

Course Objectives

Retrieve Data using the SQL SELECT Statement
Learn to Restrict and Sort Data
Usage of Single-Row Functions to Customize Output
Describe the differences between single row and multiple row functions
Invoke Conversion Functions and Conditional Expressions
Aggregate Data Using the Group Functions
Display Data from Multiple Tables Using Joins
Use Sub-queries to Solve Queries
Use of DDL Statements to Create and Manage Tables
Create a simple and complex view
Retrieve data from views
Create, maintain, and use sequences
Management of Schema Objec... [Read More]

Oracle Database 12c : OCA DBA (Certificate)

Course Format: Classroom
School/Trainer: Koenig Solutions Ltd.
Training Center(s)/Venue(s): Bangalore, Dehradun, Goa, New Delhi, Shimla, India
  V

This Oracle database 12c release comes re-engineered for Cloud computing. It also offers a multitenant infrastructure that ensures unparalleled software and hardware efficiencies, including high performance and management benefits, along with efficient and fast Cloud provisioning. Oracle Database 12c certification emphasizes the complete practical knowledge required by DBAs in today&,#146,s competitive world. Oracle Database 12c OCA DBA certification will provide advanced skills and expertise required of proficient database administrators. Achieving this Oracle Database 12c OCA DBA credential will validate your skills in managing Oracle databases effectively and efficiently while optimizing their performance.

Course Objectives

Installing Oracle Grid Infrastructure for Standalone Servers.
Managing components with Oracle Restart.
Upgrading existing versions of Oracle Database to the latest Oracle Database 12c.
Creating container databases and provisioning pluggable databases.
Creating and maintaining Oracle Database Instances.
Building and managing Storage Structures.
Configuring and managing the Network Environment.Read More]

Oracle Database 12c : OCP DBA (Certificate)

Course Format: Classroom
School/Trainer: Koenig Solutions Ltd.
Training Center(s)/Venue(s): Bangalore, Dehradun, Goa, New Delhi, Shimla, India
  V

Oracle Database 12c OCP DBA certification provides advanced level expertise in administering Oracle databases while gaining deep understanding of underlying architecture and internal workings of this latest version of Oracle database 12c deployment. The OCP DBA credential in this latest version of Oracle Database 12c will help professionals confirm their advanced skills in complete database management and maintenance.

Course Objectives

Managing the performance of pluggable databases and multitenant container databases
Configuring resource manager for sharing resources between and within a multitenant container database and a pluggable database
Implementing unified auditing
Making use of SQL*Loader and Oracle Data Pump in pluggable databases
Monitoring the operations and performance of multitenant container database and pluggable database
Completely understand the multitenant architecture
Creating multitenant container databases from scratch
Creating pluggable databases using various prescribed techniques
Plugging a non-CDB into a multitenant container database
Administering the storage structures of multit... [Read More]

Oracle DBA 10g (Certificate)

Course Format: Classroom
School/Trainer: Dyaus Infotech
Training Center(s)/Venue(s): Pune, India

�SQL
�Admin-1
�Admin-2

Oracle 11g DBA & Developer Tracks OCP

Course Format: Classroom
School/Trainer: Synergy Education Services
Training Center(s)/Venue(s): Karachi, Pakistan
  V

Synergy Education Services (SES), a company of Synergy Computers (Pvt.) Ltd., offers Oracle 11g OCA &, OCP training courses at very low cost.

PKR 13,800 for OCA training.

Synergy Computers (Pvt) Ltd. is today one of the leading technology company in the country providing best off the shelf solutions for Technology Infrastructures and Education Services.

DBA Bootcamp (Certificate)

Course Format: Classroom
School/Trainer: GetCertified IT Training
Training Center(s)/Venue(s): Johannesburg, South Africa
  V

Entry Requirements
•Matric (good pass in CAT �Computer Application Technology)
•Duration 4 months
•Do various employment-grade practical projects under mentorship of senior IT professionals
•We certify your projects for potential employers
•You get an assigned mentor to assist and guide you in between courses and projects
•International Alignment : 70-462

Modules
1.Beginning SQL �also covering MTA
2.Beginner DBA
3.Advanced DBA �(70-462)

Schedule
•Once in 4 months we start a new DBA bootcamp
•You can do this course via distance learning as well

SQL Server 2012 DBA

Course Format: Classroom
School/Trainer: VerticalDivers
Training Center(s)/Venue(s): Bangalore, India
  V

SQL Server 2012 Overview

Availability and Scalability Features
Security Features
Data Management Features
Administration and Maintenance Features
Development Features
To enable SQLiMail
Testing mail delivery

Installing SQL Server 2012

SQL Server 2012 Editions
Installing Microsoft SQL Server
System Requirements
Preparing for a SQL 2012 Installation
Installation Checklist
Setup Features
Using the System Consistency Checker
Component Install
Unattended Installation
Installation Sequence
Installation Maintenance
Upgrading from previous versions of SQL Server
Retaining SQL 2000 / 2005
To verify the Installation
Administrative Tools

Upgrading to SQL Server Management Studio

Management Studio Windows
Registered Servers
Object Explorer
Review Database Objects
Modify Database Properties
Create Database Scripts
The Maintenance Plans Node
Solution Explorer
Query Editor
Template Explorer
Dynamic Help
Upgrading to SQL Server Computer Manager
SQL Server 2012 Services nodeRead More]

SQL Server 2008 DBA

Course Format: Classroom
School/Trainer: VerticalDivers
Training Center(s)/Venue(s): Bangalore, India
  V

SQL Server 2008 Overview

Availability and Scalability Features
Security Features
Data Management Features
Administration and Maintenance Features
Development Features
To enable SQLiMail
Testing mail delivery

Installing SQL Server 2008

SQL Server 2008 Editions
Installing Microsoft SQL Server
System Requirements
Preparing for a SQL 2008 Installation
Installation Checklist
Setup Features
Using the System Consistency Checker
Component Install
Unattended Installation
Installation Sequence
Installation Maintenance
Upgrading from previous versions of SQL Server
Retaining SQL 2000 / 2005
To verify the Installation
Administrative Tools

Upgrading to SQL Server Management Studio

Management Studio Windows
Registered Servers
Object Explorer
Review Database Objects
Modify Database Properties
Create Database Scripts
The Maintenance Plans Node
Solution Explorer
Query Editor
Template Explorer
Dynamic Help
Upgrading to SQL Server Computer Manager
SQL Server 2008 Services nodeRead More]

Oracle Database 11g: Performance Tuning DBA Release 2

Course Format: Classroom
School/Trainer: VerticalDivers
Training Center(s)/Venue(s): Bangalore, India
  V

The course starts with an unknown database that requires tuning. The lessons will proceed through the steps a DBA will perform to acquire the information needed to identify problem areas, to diagnose common problems, and remedy those problems. The methodology used in the practices is primarily reactive. After configuring monitoring tools, and reviewing the available reports, the student will be presented with the Oracle architecture based on the SQL statement processing of SELECT and DML. The SQL tuning section assumes that the DBA has little or no ability to change the code. The DBA will influence the SQL performance with available tools. The DBA will be introduced to various methods of identifying the SQL statements that require tuning, and the diagnostic tools needed to find ways to change the performance. This will include the use of statistics, outlines, and profiles to influence the optimizer, adding and rebuilding indexes, and using the SQL Advisors. A major task of DBAÂ’s is to maintain SQL performance across changes. This course introduces the DB Replay, and SQL Performance Analyzer tools to help the DBA test and minimize the impact of change.

MCSA SQL Server 2012 DBA (Certificate)

Course Format: Classroom
School/Trainer: Certification Guru
Training Center(s)/Venue(s): Pimpri, Pune, India
  V

This training course is designed for IT professionals who support or plan to support Microsoft SQL Server 2012 or 2008 R2 databases and who also plan to take Exam 70-462, “Administering Microsoft SQL Server 2012 Databases&,quot,.

This course is based on the Microsoft official syllabus for the MCSA: SQL Server certification exam.

1 Planning and Installing SQL Server 2012 •Planning Your Installation
•Installing SQL Server and Related Services

2 Configuring and Managing SQL Server Instances •Configure SQL Server instances
•Manage SQL Server instances

3 Configuring SQL Server 2012 Components �Configure additional SQL Server components
•Manage and configure databases

4 Migrating, Importing, and Exporting data
5 SQL Server Logins, Roles, and Users •Manage logins and server roles
•Manage users and database roles

6 Securing SQL Server 2012: database security &, permissions
7 Mirroring and Replication •Implement database mirroring
•Implement replication

8 Clustering SQL Server 2012 •Windows Server Clustering
•Deploy a failover SQL Server 2012 cluster i... [Read More]

Oracle DBA

Course Format: Online
School/Trainer: BigClasses
Training Center(s)/Venue(s): Hyderabad, India
  V


Course Duration : 50 Hours

Database Management Systems

Relational Database Modeling

Oracle Database Installation

Oracle Database Architecture

Database Objects

Database Storage

Oracle Networking

Oracle Utilities

User Management, Role and Privilege

Backup and Recovery

RMAN Backup and Recovery

Oracle Database Upgrades

Oracle Database Management Tools

Performance Tuning

Oracle Automatic Storage Management

Oracle Database High Availability

SQL Server DBA

Course Format: Online
School/Trainer: BigClasses
Training Center(s)/Venue(s): Hyderabad, India
  V

SQL Server DBA Training makes you understand Designing and implementing highly available production systems and Assisting in the definition and implementation of database standards.

Sql Server dba online training developing and maintaining existing databases based on standard specifications, Installing and maintaining all database software.

Here we teach you on MS Sql Server 2005 DBA training and MS Sql Server 2008 DBA training. An overview of MS sql server 2012 DBA is also given.

SQL Server and Relational Databases History

SQL Server Installation

SQL Server Configuration

SQL Server Data Store Management

Managing Data with DTS Utility

SQL Server Security Management

SQL Server Backup and Recovery

SQL Server Database Replication

SQL Server Job Scheduling

Ratio Analysis

SQL Server DBA performance Tuning

DB2 UDB DBA on Linux, unix and windows (Master Degree)

Course Format: Online
School/Trainer: DB2 School
Training Center(s)/Venue(s): Katowice, Poland
  V

Course material

Overview of DB2

Contrast the DB2 Family of products
Identify the DB2 Tools
Functions of DB2 components
Explore installation and parameters

The DB2 Environment

Key features of an Instance
Create and drop an Instance
Use db2start and db2stop
Distinguish b/w types of Config.
Describe and modify the Database Manager Configuration

Creating Databases and Data Placement

Creating a Database.
Explore system Catalog tables, views
Compare DMS Vs SMS table Spaces.
Database with Automatic Storage.
Differentiate between table spaces, containers, extents, and pages
Define table spaces
Get snapshot for table spaces
Explore Database Config. Parameter.

Moving Data

Discuss the INSERT statement and Recognize its limitations
Explain the differences between IMPORT and LOAD
Explain the EXPORT, IMPORT, and LOAD syntax
Create and use Exception Tables and Dump-Files
Distinguish and Resolve Table States: Load Pending and... [Read More]

Pages: 1 2 3 4 5 6 ...


Find DBA training courses, certificates, diplomas and degrees in Countries:



Australia - Canada - India - Indonesia - Ireland - Malaysia - New Zealand
Pakistan - Philippines - Singapore - South Africa - United Arab Emirates
United Kingdom - United States



Tips:
If you can not find a training course suitable for you instantly, you can leave your training request here and let trainers contact you later.



- Other Topics -
- Online/E-learning -
DBA
Ask for Training
Add Courses