Instructor Led Database Administrators Training Classes
From Oranet (pvt) Ltd
Oracle Database 10g Data Guard Administration Release 2
Minimize the downtime associated with any outage and prevent data loss by learning how to use Oracle Data Guard. The course details Data Guard architecture as well as the creation of physical and logical standby databases. In addition, it examines the performance implications of using various Data Guard features and offers some troubleshooting tips.
Learn to use Enterprise Manager Grid Control
more...
Oracle 10g Dataguard Release 2
...ol to manage the Data Guard configuration
Audience:
a Database Administrators
a Support Engineer
a Technical Consultant
Prerequisites:
Suggested Prerequisites:
Oracle Enterprise Manager 10g Grid Control Release 2
Course Objectives:
a Use Data Guard to achieve a highly available Oracle Database
a Describe the Data Guard architecture
a Modify the
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 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 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.
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 Gates
MCITP Certification






Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) is the premier certification for database server administrators.
This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day, 7 days a week.
Database administrators install or configure Microsoft SQL Server and manage or maintain databases or
more...
From Boston University Corporate Education Center
Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005
...hange.
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 Thinkpath Training LLC
Updating Your Database Administration and Development Skills to Microsoft SQL Server 2005





THANK YOU FOR YOUR INTEREST IN COURSE 2733X!
Introduction
This 5-day combination,
instructor-led course provides students with the knowledge
and skills to upgrade their skills to SQL Server 2005 so
that they can design, build, query and develop enterprise
SQL Server 2005 databases and servers. Provides students
with the knowledge and skills to
more...
Updating Your Database Administration and Development Skills to Microsoft SQL Server 2005





THANK YOU FOR YOUR INTEREST IN COURSE 2733X!
Introduction
This 5-day combination,
instructor-led course provides students with the knowledge
and skills to upgrade their skills to SQL Server 2005 so
that they can design, build, query and develop enterprise
SQL Server 2005 databases and servers. Provides students
with the knowledge and skills to
more...
Updating Your Database Administration Skills to Microsoft SQL Server 2005 (Course 2733)


Thank you for your interest in Course 2733.
Introduction
This three-day instructor-led course provides students with the knowledge and skills to upgrade their skills to SQL Server 2005 so that they can support, configure, and maintain enterprise SQL Server 2005 databases and servers.
This course is intended for experienced database administrators and database developers who are responsible for
more...
From Insider Training
Live Online:Windows Scripting Technologies +LIVE


...rovides a comprehensive track for systems administrators, database administrators, or programmers to learn Microsoft Scripting Technologies. Microsoft scripting technologies are the keys to automating routine procedures or extending the capabilities of your network and systems. The course focuses on the language syntax and features of VBScript, along with Windows Scripting Host, Active
more...
Live Online:Windows Scripting Technologies +LIVE PREMIUM


...rovides a comprehensive track for systems administrators, database administrators, or programmers to learn Microsoft Scripting Technologies. Microsoft scripting technologies are the keys to automating routine procedures or extending the capabilities of your network and systems. The course focuses on the language syntax and features of VBScript, along with Windows Scripting Host, Active
more...
From Boston University Corporate Education Center
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...
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 Boston University Corporate Education Center
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...
From IT Centers LLC
Microsoft MCSA/MCSE/MCDBA (Quad Cert)



By becoming certified you are investing in yourself and your career.
Employers and professionals know that certification results in:
An increased understanding of the planning, design, and maintenance of complex systems
A more effective troubleshooting approach
Efficiency and productivity in the workplace
Higher morale and self-confidence
Salary increases, bonuses, and
more...
Microsoft MCITP: Database Administrator



...rprise business solutions 24 hours a day, 7 days a week.
Database administrators install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security -or server automation and monitor and troubleshoot SQL Server activity.
MCITP: Database Administrator
more...
