> > > >

Instructor Led Database Administrators Training

Database Administrators Training Provider? - Tell us about your Training!

Please select the location nearest to you: India United States Pakistan Canada United Kingdom Phillipines

online course

instructor-led class

learn at home

group study

self-directed study

cd-based training

DVD video training

printed book

e-book digital book

workshop seminar

train the trainer

computer-based learning

discount pricing

online tutorial

Database Administrators Training Seminars and Classes

From iWare Logic

Siebel CRM 80 Essentials

...rface Audience: a Application Developers a Database Administrators a Developer a Forms Developer a Support Engineer a Technical Administrator a Technical Consultant Prerequisites: Required Prerequisites: a Familiarity with Web-based and client/ server applications a Familiarity with application development a Basic Windows or NT more...

From Wintrac Inc.

Oracle Database 11g R2 - SQL Tuning ...database administrators and application developers to build efficient SQL statements and to tune database applications. When this effort is complemented by database server and PL/ SQL application tuning, then a highly efficient application execution environment is created. One will learn about the internals of SQL statement execution, how to monitor the performance of such execution, and how more...

Oracle9i Database Backup Recovery - DBA II ...database administrators is that of recovery from failure, especially if the recovery must not result in a loss of any data. This course presents all the standard failure scenarios and the best recovery strategies for each. Backup strategies for cold backups, on-line backups, complete and partial backups are discussed. Extensive exercises allow students to simulate failures and perform actual more...

Oracle 9i New and Advanced Features for DBAs This course is designed for database administrators who will be moving to the Oracle9i database platform. This course presents the new and advanced features of the database introduced in its 9i release. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp more...

Oracle 9i Architecture For Developers ...of the database architecture module normally presented to database administrators but customized for the benefit of developers. With a series of in-depth lectures developers are acquainted with the internal architecture of the Oracle database, including memory structures, data file structures, block and row internals. The objective is to provide developers with the skills needed to properly more...

Oracle9i New & Advanced Features for DBAs This course is designed for database administrators who will be moving to the Oracle9i database platform. This course presents the new and advanced features of the database introduced in its 9i release. You can get a complete list of other Oracle classes at http://www.wintrac.com/courses/coursesoracle.asp more...

Oracle Database 10g Performance Tuning ...This Oracle 10g courseware training guide book will equip database administrators to recognize, diagnose and remedy performance problems which might arise in the operation of the Oracle database server. Beyond reactive measures, proactive actions which can be taken to avoid performance issues before they arise or are recognized are also considered. This course goes beyond basic automatic tuning more...

Oracle Database 10g Administration I This Oracle 10g courseware training guide book will allow the reader to gain the skills necessary for basic day-to-day administration of an Oracle10g database. This course is the starting for Oracle database administrators and also sets the foundation for advanced administrator training and certification You can get a complete list of other Oracle classes at more...

Oracle Database 10g- Administration II ...each. One of the most challenging tasks ever presented to database administrators is that of recovery from failure, especially if the recovery must not result in a loss of any data. Strategies for on-line backups, complete and incomplete recovery, media recovery vs. flashback database recovery and many other subjects are discussed. Extensive exercises allow students to simulate failures and more...

Oracle Database 10g- Architecture For Developers ...of the database architecture module normally presented to database administrators but customized for the benefit of developers and technical managers. With a series of in-depth lectures students are progressively acquainted with the internal architecture of the Oracle database, including memory structures, data file structures, block and row internals, advanced manageability features and more. more...

Oracle Database 11g - New Features For Administrators This Oracle 11g courseware training guide book will assist experienced Oracle database administrators to quickly learn the new features and concepts associated with the 11g release of the Oracle database. Based upon this knowledge one will be able to utilize these features and realize the benefits they bring. You can get a complete list of other Oracle classes at more...

Oracle Database 11g -Administration II This Oracle 11g courseware training guide book will bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database within a large-scale enterprise. You can get a complete list of other Oracle classes at more...

Oracle11g Administration 1 This Oracle 11g courseware training guide book will allow the student to gain the skills necessary for day-today administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification. You can get a complete list of other Oracle classes at more...

From Alliance Training and Solutions

Oracle SQL new batch starts on 1st June 2011 Audience: Application Developers Business Intelligence Developer Database Administrators End Users Forms Developer PL/ SQL Developer Portal Developer Required Prerequisites: Familiarity with Data Processing Concepts and Techniques Ability to use a graphical user interface (GUI) more...

From Technology Education Academy

Instructor Led Training Oracle Apps DBA R12

... Apply patches Clone Oracle E-Business Suite Audience Database Administrators Database Designers Functional Implementer Project Manager Support Engineer Technical Consultant Course Objectives Gain an overview of Oracle E-Business Suite Install Oracle E-Business Suite Describe Oracle E-Business Suite architecture Identify key files and their purposes Navigate the Oracle E-Business more...

Oracle Applicatins Database Administrator OCP Training Certifications 1Z0-238

Oracle Certified Professional (OCP) Certification Course: R12. x Install/ Patch/ Maintain Oracle E-Business Suite 1Z0-238 Duration of The Program : Five Working Days: 9: 00a. m. to 5: 00p. m. Class Schedule : Monday to Friday Pre-requisite : Prior Certifications: OCP DBA on Oracle 10g or Oracle 11g Registration Deadline : more...

From Software Training Academy, Inc

Oracle 10g Administration

Comprehensive, hands-on class focusing on the day-to-day tasks a DBA will perform to create, maintain and manage an Oracle 10g Database such as security, creating and managing users, creating and managing database objects (tablespaces, tables, indexes, etc.), running utilities, configuring Oracle networking, and simple backup and recovery techniques. Provides an overview of the Oracle Data more...

Oracle 10g 11g PL SQL Programming

This class will teach you how to write efficient and scalable PL/ SQL programs to create database-intensive PL/ SQL applications. Learning how to create efficient, scalable PL/ SQL programs is an important objective of this course. To meet that objective, the course includes instruction on such things as the proper use of bind variables, bulk processing, pipelining, benchmarking different more...

Oracle 10g 11g Advanced SQL

...to query Oracle databases including developers, analysts, database administrators and decision support personnel. Persons working in a data warehouse or decision support environment will benefit greatly from the lessons on analytic functions, grouping with CUBE and ROLLUP, modeling (the Oracle10g MODEL clause) and coding queries on partitioned data. Further, this course is well suited for more...

Oracle 10g 11g Introduction to SQL

This course is designed for developers who are new to relational database and need to know how to query, update and create basic objects in Oracle databases. Students receive a comprehensive introduction to Oracle's implementation of the SQL language and the common query tools, SQL*Plus and iSQL*Plus. The course includes a lesson on basic relational database concepts. LEARNING more...

From NobleProg - IT training courses

Oracle 10g XE Administration

This course has been created for database administrators. It covers the concepts and day-to-day Oracle database administrator activities. Requirements Good SQL language knowledge. more...

From Last Minute Training

Updating Your SQL Server 2005 Skills to SQL Server 2008 - nexient This course is intended for experienced SQL Server 2005 developers & database administrators who want to upgrade their skills to SQL Server 2008. Learn how to: Describe the new features of SQL Server 2008; Manage, Optimize, Secure & SQL Server 2008... more...

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL This course is intended for SQL Server database administrators, implementers, system engineers, and developers who are responsible for writing queries. more...

Designing Microsoft SQL Server 2005 Infrastructure and Services This course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure. more...

Designing Security for Microsoft SQL Server 2005 This course enables database administrators in enterprise environments to design security for database systems using Microsoft SQL ServerT 2005. more...

Designing a High Availability Database Solutions Using Microsoft SQL Server 2005 The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization. more...

Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005 This workshop teaches database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting. more...

2786B Designing a Microsoft SQL Server 2005 Infrastructure MS Certification This two-day instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure. more...

2790A Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 MS Certification The purpose of this two-day workshop is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. more...

2786 - Designing a Microsoft SQL Server 2005 Infrastructure This two-day instructor-led course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure. more...

From e-Telligent Solutions, Inc

PostgreSQL Administration

PostgreSQL Administration training provides technical introduction on installing, configuring and managing PostgreSQL database server. This course is usually taken by database administrators. These are the topics in the course: introduction about PostgreSQL, SQL Syntax, Data Definition, Data Manipulation, Data Types, Functions and Operators, Types of Conversion, Concurrency Control and more...

From Modulus

Unix Shell Programming Training

...hese larger scripts are written by system administrators, database administrators, testers, utility programmers, and others to create utilities that are largely composed of powerful UNIX commands, such as find, sed, awk, and hundreds of others. In this course, students learn to read, write, and debug Korn shell scripts. Back at work they can greatly increase productivity by automating more...

Introduction to Oracle 11g SQL Programming Training

In this class, students will learn how to create, retrieve, and manipulate objects in Oracle 11g Structured Query Language (SQL). Students will also be introduced to Oracle 11g database features and tools. Objectives Application developers, database administrators, system administrators and users who write applications and procedures that access an Oracle 11g database. Prerequisites more...

From Webucator

Comprehensive Introduction to Oracle SQL on Oracle 10g

This course is a common starting point in the Sideris Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide a comprehensive introduction to the SQL database language within the context of an Oracle database. This course can be tailored for application designers and developers, database administrators, and business users and more...

Oracle Designer Data Modeling

This Oracle training course considers all the features of building complex logical data models using sophisticated modeling techniques. Numerous real-world' problems and special situations are presented along with solutions. Classic structures and common models are also given to assist participants in rapidly completing a data model. Traditional modeling techniques as well as newer object-oriented more...

Comprehensive Introduction to Programming with PL/SQL on Oracle 10g

The Oracle PL/SQL language provides for programming logic features not contained within SQL. The grammar, syntax and benefits of using the PL/SQL language within an Oracle database environment are considered. This course can be tailored for Application designers and developers or Database administrators. more...

From Pierson Requirements Group

Data Modeling for Business Analysts DATA MODELING FOR THE BUSINESS ANALYST This 2-day Data Modeling for BAs focuses on the concepts of data modeling and various effective techniques used to gather the necessary information needed to create the data model. The workshop is designed to provide each participant with practical exercises for interpreting and creating logical data models. The relationship of the data model to more more...

From Affinity IT Training, LLC

Oracle Database 11g Administration I

The overall objective of this course is to allow the student to gain the skills necessary for day-today administration of an Oracle database. This course is the starting point for Oracle database administrators and also sets the foundation for advanced administrator training and certification. Audience:The primary target audience for this course is Oracle database administrators. Oracle web more...

Oracle Database 11g Administration II

The overall objective of this course is to bring database administrators beyond a basic understanding of their environment and to focus attention on more advanced skills needed to effectively configure, administer, monitor and tune the database within a large-scale enterprise. Audience:The primary target audience for this course is Oracle database administrators. Oracle web server and application more...

Oracle Database 11g New Features For Administrators

...o present some of the most advanced features available to database administrators which were either introduced with the Oracle 11g release or have been substantially improved with that release. Audience:The primary target audience for this course is Oracle database administrators. Oracle web server and application server administrators, as well as others who must manage an embedded repository more...

Oracle Database 11g PL SQL Fundamentals - Complete Coverage

The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. This course equips students to develop database server-side PL/SQL program units within an Oracle more...

Oracle Database 11g PL SQL Fundamentals I

The primary objective of this course is to provide an introduction to the PL/SQL database programming language, based upon the latest features available with the Oracle database. Syntax, structure and features of the language are discussed in the context of database applications and programming. Audience:All Oracle professionals, both business and systems professionals. Among the specific groups more...

Oracle Database 11g PL SQL Fundamentals II

The objective of this course is to equip students to develop database server-side PL/SQL program units within an Oracle database. Audience:All Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are Application designers and developers and Database administrators. more...

Oracle Database 11g SQL Fundamentals - Complete Coverage

The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in more...

Oracle Database 11g SQL Fundamentals I

This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database, based upon the latest features available. Audience:All Oracle professionals, both business and systems professionals. Among the specific groups more...

Oracle Database 11g SQL Fundamentals II

The primary objective of this course is to consider advanced subjects and techniques pertaining to the SQL database language, based upon the latest features available with the Oracle release. Even professionals experienced in other implementations of the industry-standard SQL language will benefit from the advanced and Oracle-specific features of SQL discussed in this course. This enhanced and more...

Relational Database Design

This course is one common starting point for the entire database curriculum. The objective of this course is to consider the logical design of relational databases using a methodology known as semantic data modeling and related practical techniques. Audience:The target audience for this course is all database professionals concerned about the design and implementation of databases. Among the more...

Understanding ADO NET

In this course, you will learn how to retrieve and manipulate data using Microsoft's new ADO.NET library. Understand how to work with the new ADO.NET object model, including the DataReader, DataAdapter, and DataSet. See how to apply constraints and relationships to disconnected data. Learn how to update data, including how to handle stored procedures, parameters, and return values. Understand how more...

Oracle 9i DBA Fundamentals I

This class will develop the fundamental skills necessary to be an Oracle DBA. Students will design and create a server using the Optimal Flexible Architecture (OFA), configure logical and physical structures, set up database and user security, add and administer users, and monitor and tune main server areas. Each student will create a toolkit of administration scripts for database management and more...

Oracle 9i DBA Fundamentals II

Presents the fundamentals of setting up Oracle Net Services, configuring the shared server architecture, and backup and recovery. This class covers the different ways an Oracle9i instance and database can fail and the best options for recovery. Students will learn how to perform backup and recovery with and without RMAN. Students will learn how to minimize points of failure and reduce the Mean more...

Oracle 9i PL SQL Programming

Students will learn the fundamentals of the PL/SQL programming language. Stored procedures, functions, packages and triggers implement complex business rules in Oracle. Students will learn programming, management and security issues of working with PL/SQL program units. Numerous exercises and labs will introduce students to the new PL/SQL features in Oracle9. Audience:Database administrators, more...

Oracle 9i Advanced PL SQL Programming

This class will focus on developing advanced PL/SQL programming skills. Topics will include the built-in packages that come with Oracle, the creation of triggers and advanced stored procedure features. The class will also cover object-relational concepts, performance tuning and dynamic SQL. The Oracle9 release has greatly enhanced the features and functionality of PL/SQL. Numerous exercises and more...

Oracle 9i SQL Programming

This class will develop database programming skills using SQL. Relational and object concepts will be covered. Students will learn complex SQL programming skills, features, and tools. Audience:Database administrators, application developers, and system administrators. more...

Oracle 9i Server Performance Tuning

This class teaches DBAs how to tune an Oracle9i server. Participants will learn the different areas that impact performance, how to detect performance issues, verify the performance problem, determine what to tune, understand the ramifications of making changes, and then verify the results. Tuning Oracle memory areas, contention and waits, physical I/O, checkpoints, undo segments, temporary more...

Sybase Administrators Performance and Tuning for ASE 12 5 1

...database administrators how to tune an Adaptive Server for optimal performance. It explores Adaptive Server architecture in depth, and includes sections on designing databases for performance, managing Adaptive Server system resources (CPUs, disks, I/O), choosing appropriate locking schemes, optimizer statistics, SMP features, relevant data structures, and parallel processing. more...

Sybase System and Database Administration For ASE 12 5 1

Through a combination of lectures and hands-on labs, you will identify the major tasks of Sybase system and database administration. You will practice these tasks using your own Adaptive Servers (12.5) in a safe and controlled environment. Emphasis is given to resource management (memory, disk, and CPU) with a goal of creating a reliable Adaptive Server environment. The course also presents more...

Introduction To Sybase ASE 12 5 1

Learn to create tables and manipulate data, tables and other database objects using ANSI-standard SQL and Sybases Transact-SQL extensions, and gain hands-on experience using Adaptive Server databases. You will also learn the special features and functions of the Adaptive Server, such as automatic recovery of transactions, stored procedures, triggers, and cursors. In addition, you will learn to use more...

SQL Server 2000 Performance and Tuning

You need to know how to tune queries and stored procedures for optimal performance. This course thoroughly covers SQL Server 2000 Query Optimizer. You will learn techniques to write high performance queries, allowing the optimizer to use the most efficient query plan, and diagnose and correct performance problems with already existing queries. Additionally, you will learn to interpret optimizer more...

From The Training Experts Ltd

Advanced ACT This one day course is designed to increase delegatesa ™ existing knowledge of ACT! Target Group This course is aimed at database administrators or any personnel who currently use ACT! 2009 and wish to implement the more advanced functions to further aid them in their job role. Objectives By the end of this course delegates will be able to use ACT! fully as a contact more...

From Intertech

Querying and Processing SQL Server Data with SQL Statements Training This two-day, hands-on course covers everything database administrators and developers need to know to query SQL Server databases using SELECT statements ranging from simple to complex, and use INSERT, UPDATE and DELETE statements to modify and maintain data. Creating and using of VIEWS is also covered, along with accessing data through stored procedures and user-defined functions. more...

From Microsys Technologies and Solutions Pvt. Ltd.,

SQL Server 2008 Database Administration You Will Learn How To Administer SQL Server 2008 with SQL Server Management Studio and Transact- SQL Build databases and upgrade from prior versions Secure the server through logins and database permissions management Implement backup and recovery strategies and manage transaction logs Automate administrative activities with SQL Server Agent multistep jobs Perform routine more...

From Mercury Solutions Limited

Oracle Database 11g New Features for Oracle 9i DBA The Oracle Database 11g: New Features for Oracle 9i DBAs accreditation teaches about the usage of new features of Oracle Database 10g and Oracle Database 11g. The new features such as ASM, RMAN, and Flashback, help increase the database availability and streamline the entire database management. Taking this certification course, the database administrators learn how to upgrade Oracle9i database to more...

Microsoft SQL Server 2008 for Experienced Oracle Database Administrator This course teaches students how to make the most of their skills and knowledge as an Oracle DBA to manage a Microsoft SQL Server system. The Microsoft SQL Server 2008 for the Experienced Oracle Database Administrator certification course helps Oracle database administrators to distinguish and compare Oracle database management to SQL Server database management. Upon the successful completion of more...

From Corporate Education Group

Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005

...ange. The purpose of this two-day workshop is to teach database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005. The primary focus of this workshop is to teach the overall process of troubleshooting. It includes establishing monitoring standards and baselines, determining performance thresholds, and more...

From IT Centers LLC

Microsoft MCDBA

The Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server2000 credential is the premier certification for professionals who implement and administer Microsoft SQL Server databases. The certification is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage more...

From Corporate Education Group

Updating Your Database Administration Skills to Microsoft SQL Server 2005

...rvers. Audience This course is intended for experienced database administrators and database developers who are responsible for the supporting, configuring, and maintaining enterprise SQL Server 2005 databases and servers. At Course Completion After completing this course, students will be able to: ? Describe the architecture of SQL Server 2005. � ? Install SQL Server 2005. � ? Use SQL more...

Updating Your Database Development Skills to Microsoft SQL Server 2005

...ourse is intended for experienced database developers and database administrators, who are responsible for the design, build, query, and develop enterprise SQL Server 2005 databases and servers. At Course Completion After completing this course, students will be able to: ? Use the Development Tools provided with SQL Server 2005. � ? Use Transact-SQL enhancements to perform database more...

Oracle Database 10g Administration Workshop I

... Oracle Certified Associate exam.� � Who should attend:� Database Administrators Sales Consultants Support Engineer Technical Consultant Course Objectives: Install and configure the Oracle Database 10g Create and administer user accounts in the Oracle Database 10g Backup and Recovery of the Oracle Database 10g Monitor, troubleshoot, and maintain the Oracle Database 10g more...

Oracle Database 10g Administration Workshop II

...essional exam. � �� Who Should Attend: Sales Consultants Database Administrators Support Engineer Technical Consultant Prerequisites: Oracle Database 10g: Administration Workshop I Suggested Prerequisites: Oracle Database 10g: SQL Fundamentals I Oracle Database 10g: SQL and PL/SQL Fundamentals Course Objectives: Use RMAN to create and manage backup sets and image copies more...

Oracle Database 10g: New Features for Administrators

...ould Attend: � Technical Consultant PL/SQL Developer Database Administrators Support Engineer Prerequisites: Administration experience with Oracle9i Database Course Objectives: Implement improved manageability features to simplify database management Utilize database advisors to provide proactive database monitoring Increase data availability through Oracle Database 10g more...