FAIL (the browser should render some flash content, not this). FAIL (the browser should render some flash content, not this).

Database Technologies

Total Package Price:
unlisted

Call us at 704-246-7150 to try out a demonstration of a course:

5050:
Recovering Messaging Servers and Databases using Microsoft Exchange Server 2007

6235A:
Module 01 – Introduction to SQL Server 2008 Integration Services

Course

Retail
Cost

 

2072:
Administering a Microsoft SQL Server 2000 Database

$595.00

This course
provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000.

2073:
Programming a Microsoft SQL Server 2000 Database

$595.00

This five day course provides students with the technical skills required to program a database by using Microsoft SQL Server 2000.

2733:
Updating Your Database Administration Skills to SQL 2005

$495.00

This three-day 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.

2734:
Updating Your Database Development Skills to SQL 2005

$695.00

This three-day 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.

2778A:
Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

$495.00

This 3-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

2779B:
Implementing a Microsoft SQL Server 2005 Database

$495.00

This five-day course provides students with the knowledge and skills to implement a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to implementing a database.

2780:
Maintaining a Microsoft SQL Server 2005 Database

$495.00

This five-day course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features and tools related to maintaining a database.

2781:
Designing Microsoft SQL Server 2005 Server-Side Solutions

$495.00

This course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL ServerT 2005. It focuses on teaching database developers who work in enterprise environments to identify and place database technologies during design to achieve a suitable solution that meets the needs of an organization. Students will also learn to consider the solution from a system-wide view instead of from a single database or server perspective.

2782:
Designing Microsoft SQL Server 2005 Databases

$395.00

This course provides students with the knowledge and skills to design databases for Microsoft
SQL Server 2005 using business requirements to guide their decisions (beyond
structured third normal form [3NF] modeling techniques). Students will also
learn to incorporate security requirements throughout their design.

2783:
Designing the Data Tier for SQL Server 2005

$195.00

This course provides students with the knowledge and skills to design the data tier for Microsoft SQL Server 2005. It teaches database developers working in enterprise environments to understand and decide how application developers are going to access and consume their data.

2784A:
Tuning and Optimizing Queries using Microsoft SQL Server 2005

$495.00

This three-day instructor led workshop provides database developers working in enterprise environments using Microsoft SQL Server 2005 the knowledge and skills to evaluate and improve queries and query response times. The workshop focuses
on systematic identification and optimization of database factors that impact query performance.

2786:
Designing a Microsoft SQL Server 2005 Infrastructure

$395.00

This two-day
course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure. The course focuses on the development of strategies for data archiving, consolidation, distribution, and recovery. The course also stresses the importance of capacity analysis and emphasizes the trade offs that need to be made during design. This is the first course in the database administration curriculum and will serve as the entry point for other courses in the curriculum.

2787:
Designing Security for Microsoft SQL Server 2005

$395.00

This two-day course enables database administrators who work with enterprise environments to design security for database systems using Microsoft SQL ServerT 2005. The course emphasizes that students should think about the whole environment,
which includes business needs, regulatory requirements, network systems, and database considerations during design. Students will also learn how to monitor security and respond to threats.

2788:
Designing High Availability Database Solutions Using SQL 2005

$495.00

This three-day course provides students with the knowledge and skills to design 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. It emphasizes that students should think broadly about high availability, which includes thinking about the database itself and about their entire environment, including business needs; regulatory requirements; and network, systems, and database considerations during
design. Students will also learn how to document and test the high availability database solution.

2789:
Administering and Automating MS SQL Server 2005 Databases and Servers

$195.00

This one-day course provides students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers. This course focuses on the need to maintain administration and automation information.

2790:
Troubleshooting & Optimizing Database Server Using MS SQL Server 2005

$395.00

The purpose of this two-day course 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 course is to teach the overall process of troubleshooting. It includes establishing monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues.

2793:
Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services

$495.00

This three-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.

5050:
Recovering Messaging Servers and Databases using Microsoft Exchange Server
2007

$195.00

This one day course teaches messaging specialists to recover Exchange mailboxes and servers in a variety of disaster scenarios. Students will learn how to perform full and dial-tone recoveries of a mailbox server, as well as repair a mailbox database. They will also learn how to perform a full recovery of Client Access servers, Hub Transport servers, Unified Messaging servers, and
Edge Transport servers.

6231A:
Maintaining a Microsoft SQL Server 2008 Database

$695.00

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

6232A:
Implementing a Microsoft SQL Server 2008 Database

$695.00

This course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. It focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.

6234A:
Implementing and Maintaining Microsoft SQL Server 2008 Analysis Services

 

This instructor-led course teaches students how to implement an Analysis Services solution in an organization. It discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube. Additionally, the student will learn how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

6235A:
Implementing & Maintaining MS SQL Server 2008 Integration Services

 

This three-day
course teaches students how to implement an Integration Services solution in
an organization. The course discusses how to develop, deploy, and manage
Integration Services packages.

6236A:
Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

$495.00

This instructor-led course teaches students how to implement a Reporting Services solution in an organization. The three-day course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution. Upon completion of this course, students will be familiar with SQL Server Reporting Services and its components, be able to create and enhance a Reporting Services report, as well as manipulate a data set. Other techniques learned in this course include the ability to use report models to implement reporting for business users, configuring report publishing and execution settings, implementing subscriptions for reports, administering Reporting Services and implementing custom Reporting Services applications.

70-228:
SQL Server 2000 Administration

 

This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000.

70-229:
SQL Server 2000 Implementing Database Design

 

This five-day course provides students with the technical skills required to program a database by using Microsoft SQL Server 2000.

Crystal
Reports Training (XI) Getting Started

$595.00

This is an introductory course on Crystal Reports XI, the world’s leading reporting tool. The course will teach you the necessary skills to design, manage, and deliver reports via the web and embedded in enterprise applications. It can provide you with a solid starting point for your business intelligence (BI) strategy by helping you securely deliver the most requested pieces of information as highly formatted reports to end users both inside and outside your organization.

Crystal
Reports Training (XI) Training Power Development

$595.00

This course teaches advanced skills in Crystal Reports XI, the world’s leading reporting tool. It will provide lessons in Conditional Formatting, Distributing Reports, Creating Complex Formulas, Summarizing Data Using CrossTabs, Using Parameters in Reports, Building Specialized Reports, and more.

Database
Specialist Design Course (Exam 1D0-441)

$185.00

The Database Design course from Metrotek is fundamental training for those with no previous experience in database design. Expert instructor Wayne Snyder begins with basics of relational databases and uses examples, sample programs and clear step-by-step instruction to teach you database design methodology. At the conclusion of this course, you’ll be familiar with the concepts
underlying enterprise data model design.

Database
Specialist Using JDBC 2.0 Course (Exam 1D0-441)

$125.00

JDBC 2.0 is a Java application programming interface that allows database developers to send SQL statements to virtually any relational database. In the Database Specialist Using JDBC 2.0 course from Metrotek, expert instructor Wayne Snyder uses examples, sample programs and clear step-by-step instruction to teach you database application design with Java. At the conclusion of this course, you will be able to write platform independent applications to access Oracle, Sybase, Informix, Microsoft SQL Server, and DB2 databases.

Oracle
10g PL/SQL Training

$595.00

PL/SQL is Oracle’s Procedural Language extension to SQL. This course will provide students with techniques to design PL/SQL applications, and to solve real-world business problems. The student will be working with stored functions, stored procedures, and packages along with some standard Oracle supplied packages and exception handling techniques in PL/SQL. The Oracle PL/SQL language provides for programming features not available within SQL.

SQL
Server 2005 Designing Infrastructure and Security Course (Exam 70-443)

$270.00

Metrotek’s SQL Server 2005 Designing Infrastructure and Security covers the objectives needed to apply to your MCITP: Database Administration Track (Exam 70-443). Metrotek expert Wayne Snyder takes you through designing the database infrastructure layout strategies for data archiving, data distribution and recovery of data. You’ll learn to analyze data, set up a database that is secure, available, easy to maintain and achieves the system performance you expect.

SQL
Server 2005 Implementing a Database Course

$480.00

This course covers complete implementation procedures including creating data types and tables, using constraints, triggers, and XML schemas. Basic knowledge of Transact-SQL is recommended along with some database design experience. Completion of this course provides the skills necessary for understanding key technologies in database implementation and combined with Metrotek’s SQL Server 2005 Writing Queries and SQL Server 2005 Maintaining a Database will prepare you for the Microsoft MCTS exam 70-431.

SQL
Server 2005 Maintaining a Database Course

$480.00

Expert Wayne Snyder explains and demonstrates the tools and technologies for maintaining a database and shows complete implementation procedures including creating data types, using tables, constraints, triggers, and XML schemas. Students should have a basic knowledge of Transact-SQL along with familiarity of database design. This course, combined with Metrotek’s SQL Server 2005 Writing Queries and SQL Server 2005 Implementing a Database will prepare you for the Microsoft MCTS exam 70-431.

SQL
Server 2005 Optimizing and Maintaining Database Solutions Course (Exam
70-444)

$480.00

In Metrotek’s SQL Server 2005 Optimizing and Maintaining Database Solutions course you’ll learn how to make maintenance and optimization of your database a breeze by creating automated functions, agents and maintenance plans. Metrotek expert, Barbara Andrews, will teach you how to use the SSIS tools, optimize your queries, and give you tips and tricks for connectivity and configuration. At the conclusion of this course, you’ll know when and what to do should you need to scale or accelerate your database service to meet the demands of ever changing systems.

SQL
Server 2005 Writing Queries Course

$480.00

The Writing Queries course from Metrotek is the ultimate course for database administrators. Beginning with object-oriented databases, you’ll build upon basic query concepts, move through data manipulation language, master common table expressions and create stored procedures. By the end of this course, you’ll understand how to write SQL Server 2005 queries efficiently and accurately. This course, combined with Metrotek’s SQL Server 2005 Implementing a Database and SQL Server 2005 Maintaining a Database will prepare you for the Microsoft MCTS exam 70-431.

SQL
Server 2008 Designing, Optimizing, and Maintaining a Database Course

$670.00

The SQL Server 2008 Designing, Optimizing, and Maintaining a Database course will help you prepare for 70-450 exam from Microsoft. You will learn how to design a database security server solution, design a backup and recovery solution, and design a strategy to maintain and manage databases. At the end of this course you will understand how to install, configure, maintain, and secure a SQL Server 2008 database.

SQL
Server 2008 Implementation & Maintenance Course

$670.00

SQL Server 2008 Implementation and Maintenance course will prepare you to become a SQL Server 2008 Database Administrator. You will learn how to maintain a SQL server database, perform data management tasks, monitor and troubleshoot SQL servers, and install and configure SQL servers. You will also learn what it takes to manage SQL server securities; manage logins, servers, users, and database roles. Taking the necessary measures to keep the organizations assets secure. This course will prepare you for the Microsoft SQL Server Exam 70.432.

 

TOTAL
COST OF ALL COURSES WITHOUT PACKAGE:

$15,520.00