> > > > >

Instructor Led Database Administrators Training in United States

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

Please select the location nearest to you: New York Connecticut New Jersey Minnesota Oregon Massachusetts Wisconsin

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 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 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 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...

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 Wintrac Inc.

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 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...