Connect with us:

Client Testimonials

"The instructor was wonderful... we really benefited from his expertise and learned a great deal. He was open to answering multiple questions and learning our table structure on the fly."

Student - DBOR-606 Oracle 9i Basic SQL for Testers and Business Analysts using SQL Navigator

View More Testimonials

SQL Server 2005 Training Courses

Course #	Course Name	Duration
DBSQ-240	Fundamentals of SQL Server 2005 Training This training course is designed to provide students with the features that are available in the SQL Server, how to design and create a database and how to build basic queries using Transact-SQL, the language of the SQL Server. Students will learn how to build effective views, stored procedures, triggers and user-defined functions using Transact-SQL. The new enhancements to the Transact-SQL programming language including improved support for error handling and hierarchical queries, and the use of .NET languages like C# and Visual Basic to build database objects are also covered. SQL Server 2005 includes a rich set of tools that go beyond the basics of querying and manipulating data. The student will learn how to take advantage of the new, user-friendly management console that integrates both authoring and administrative tasks, and how to take advantage of SQL Server's tools for analyzing and tuning databases. Students will also learn about integration services, implementing security and Microsoft's new Business Intelligence (BI) suite.	5 days
DBSQ-245	SQL Server 2005 Integration Services Training This training course is designed to provide students with instruction in SSIS tools and technologies. Students will learn about the SQL Server Management Studio (SSMS) and building Database Maintenance Plans. They will be introduced to the Business Intelligence Development Studio (BIDS) and work with Control Flow and Data Flow. They will also become familiar with SSIS package management and package deployment along with learning to write solid code using debugging, error handling and logging techniques.	3 days
DBSQ-250	Microsoft SQL Server 2005 Additional Topics Training This training course is designed to provide students with instruction beyond the basics of database production. It examines other SQL Server 2005 essential application, support and maintenance features that support high-availability, stability, reliability and scalability of databases plus enhancements for processing large amounts of data, handling complex data structures, implementing asynchronous messaging and working with XML.	3 days
DBSQ-255	SQL Server 2005 Analysis Services Training This training course is designed to provide instruction in the use of Microsoft SQL Server 2005 Analysis Services (SSAS) to design and implement OnLine Analytical Processing (OLAP) cubes and data mining models to support Business Intelligence (BI) solutions. This training course includes concepts, procedures and practices based on real-world experience giving both the novice and experienced SQL Server 2005 developer the tools to build data warehousing and decision support system solutions. This training course also provides information on end-user tools including Microsoft Excel 2003/2007 and Microsoft SQL Server 2005 Reporting Services. Implementing SSAS solutions have shown to boost data retrieval and report generation from SQL Server by up to 1000%.	3 days
DBSQ-260	SQL Server 2005 Reporting Services Training This training course is designed to provide students with instruction in SQL Server 2005 Reporting Services to be able to create, execute and manage reports. The student will learn how to create tabular, matrix (cross-tab) and chart reports using Visual Studio 2005 and SQL Server 2005 Business Intelligence Studio. The student will explore creating reports with groups, expressions, conditional formatting and parameters. The reports that are created in the course will employ shared data sources, interactive sorting and drill-down capabilities. The deployment and printing of reports and the export of reports to PDF, Excel and other formats will also be explored. The course provides a thorough understanding of Reporting Services security, report snapshots, subscriptions and the use of custom assemblies. The student will also discover how to integrate reports into ASP.NET and WinForms applications using URL access and the Reporting Services Web Service API without requiring users to use Internet Explorer. Finally, the student will learn how to empower users to create ad-hoc reports using Report Builder and Report Model projects.	3 days
DBSQ-265	SQL Server 2005 for Developers Training This training course is designed to train students in SQL in order to write queries, create tables and generate views. Students will also create stored procedures, triggers and user-defined functions using Transact-SQL and .NET languages like C# and Visual Basic.	5 days
DBSQ-270	SQL Server 2005 SQL for Testers Training This training course is designed to train students to write queries using SQL Server SQL.	2 days
DBSQ-275	New Features of SQL Server 2005 for SQL Server 2000 Developers Training This training course will introduce the new concepts in SQL Server 2005.	2 days
DBSQ-280	Microsoft SQL Server 2005 for Administrators Training This training course provides students with the knowledge to design, create, modify, analyze and tune databases in SQL Server. Students will learn how to build basic queries using Transact-SQL, how to take advantage of the new, user-friendly management console, and how to use SQL Server's tools for configuring, tuning and monitoring database activity. This training course also covers critical topics such as integration services, implementing security, disaster prevention and recovery, failover clustering, database mirroring and more.	4 days
MOC-2779	Implementing a Microsoft SQL Server 2005 Database Training This training course is designed to provide students with the skills necessary 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 databse.	5 days
MOC-2781	Designing Microsoft SQL Server 2005 Server-Side Solutions Training This training course is designed to provide students with the knowledge and skills to design server-side solutions for Microsoft SQL Server 2005. The course 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.	3 days
MOC-2782	Designing Microsoft SQL Server Databases 2005 Training This training course is designed to provide 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.	2 days
MOC-2783	Designing the Data Tier for Microsoft SQL Server 2005 Training This training course is designed to provide students with the knowledge and skills to design the data tier for Microsoft SQL Server 2005. The course focuses on teaching database developers working in enterprise environments to understand and decide how application developers are going to access and consume their data. This is a major failure point of database solutions today.	1 day
MOC-2784	Tuning and Optimizing Queries Using Microsoft SQL Server 2005 Training This training course is designed to provide 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.	3 days
MOC-2786	Designing a Microsoft SQL Server 2005 Infrastructure Training This training course is designed to provide Database Administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL Server 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 tradeoffs that need to be made during design.	2 days
MOC-2787	Designing Security for Microsoft SQL Server 2005 Training This training course is designed to enable Database Administrators who work with enterprise environments to design security for database systems using Microsoft SQL Server 2005. The course emphasizes 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.	2 days
MOC-2788	Designing High Availability Database Solutions Using Microsoft SQL Server 2005 Training This training course is designed to provide 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.	3 days
MOC-2789	Administering and Automating Microsoft SQL Server 2005 Databases and Servers Training This training course is designed to provide students with the knowledge and skills to administer and automate Microsoft SQL Server 2005 databases and servers. This training course focuses on the need to maintain administration and automation information.	1 day
MOC-2790	Troubleshooting and Optimizing Database Servers Using Microsoft SQL Server 2005 Training This training course is designed 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 focusing the investigation on specific issues.	2 days
MOC-2792	Implementing and Planning Microsoft SQL Server 2005 Integration Services Training This training course is designed to provide students with the knowledge and skills to implement an Integration Services solution in an organization. The course discusses how to develop, deploy and manage Integration Services packages.	3 days
MOC-2794	Designing a Business Intelligence Solution for the Enterprise Using Microsoft SQL Server 2005 Training This training course is designed to teach Business Intelligence (BI) Professionals working in enterprise environments to design a BI solution architecture. Students will be taught the importance of keeping all components of the solution and stages of the lifecycle in mind. The first day focuses on foundational standards and practices for the enterprise. The second day focuses on a project-specific lifecycle for capturing requirements and deriving a solution architecture.	2 days
MOC-2795	Designing an ETL Solution Architecture Using Microsoft SQL Server 2005 Integration Services Training This training course is designed to teach Business Intelligence (BI) Professionals working in enterprise environments to design an extract, transform, and load (ETL) solution that supports their BI solution. Students will learn how to plan an ETL solution, and specifically how to design and implement a SQL Server Integration Services (SSIS) based ETL solution. They will also learn how to monitor, optimize, and deploy an SSIS solution. The course focuses on the planning and design aspects of an ETL solution and does not teach students how to create SSIS packages or how to use the development tools provided with SQL Server 2005.	2 days
MOC-2796	Designing an Analysis Solution Architecture Using Microsoft SQL Server 2005 Analysis Services Training This training course is designed to teach Business Intelligence (BI) Professionals working in enterprise environments how to design a multidimensional solution architecture that supports their BI solution. Students will go through the entire process-from capturing business and technical requirements, to deploying a multidimensional solution, to production. Students will also be taught to develop custom functionality and optimize a multidimensional solution. The course focuses on the planning and design aspects of an analysis solution and does not teach students how to create Analysis Services database objects or how to use the development tools provided with SQL Server 2005.	3 days
MOC-2797	Designing a Reporting Solution Architecture Using Microsoft SQL Server 2005 Reporting Services Training This training course is designed to teach Business Intelligence (BI) Professionals working in enterprise environments to design a reporting solution architecture that supports their BI solution. Students will go through the entire process-from identifying report data to promoting the reporting solution to production. Students will scale a reporting solution. Students will also be taught best practices for collaborating with application developers to integrate applications and reporting services. The course focuses on the planning and design aspects of a reporting solution and does not teach you how to create reports or how to use the development tools provided with SQL Server 2005.	2 days