Master it Training verzorgt trajecten (MCSE, MCSA, MCTS, MCITP) en cursussen voor Systeembeheerders (SQL Server, Citrix, Cisco), Developers en Eindgebruikers (cursus Ms Word, Excel, Access of Powerpoint). U kunt hiervoor terecht in Eindhoven, Utrecht en Amsterdam, bijvoorbeeld voor een training volgens ons maatwerk principe in het Open Leer Centrum. Ons aanbod bestaat uit ruim 500 ICT trainingen, waaronder Windows Server 2008, .NET, Linux, Exchange, System Center, Visio, Project!

Deelnemers leren gebruik te maken van nieuwe functionaliteit in SQL Server 2005 met betrekking tot de ontwikkeling van database-applicaties. Met behulp van de nieuwe development tools wordt ingegaan op de verbeteringen die zijn aangebracht in Transact-SQL en andere uitbreidingen zoals .NET-integratie, service broker, notification services, bouwen van webservices, XML-oplossingen en SQL Server als HTTP endpoint.

Bij deze training volgt u de eLearning MS2778 (voorbereiding op examen 70-431) in de Open Master Class en onder actieve begeleiding van een ervaren en gecertificeerde docent. Alle benodigde en beschreven eLEarning modules (4326, 4327, 4328, 4329, 4330, 4331, 4332, 4333, 4334) zijn inbegrepen.

Update
Inmiddels is er een nieuwe versie van deze training beschikbaar met de code MS2778AK: Writing Queries Using Microsoft SQL Server 2008 Transact-SQL. Hoewel de titel doet vermoeden dat deze enkel geschikt is voor SQL versie 2008, kunt u deze training ook uitstekend volgen voor SQL versie 2005. Wij adviseren u dan ook om, indien u liever geen begeleide eLearning volgt, te kiezen voor de MS2778AK.

Omschrijving
This collection introduces you to Transact-SQL starting with basic SELECT queries, then advancing to grouping, joins, subqueries, data modification, transactions, and heterogeneous data sources.

After completing this collection, you will be able to:

• Get started with databases and Transact-SQL.
• Perform basic queries.
• Group and summarize data.
• Join data from multiple tables.
• Work with subqueries.
• Modify data.
• Query metadata, XML, and full-text indexes.
• Use programming objects for data retrieval.
• Use advanced querying techniques.

Alto’s Querying and Processing SQL Server Data Using Microsoft SQL Server 2005 concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server.

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.

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.

This three-day course provides students with the knowledge and skills to design server-side solutions for Microsoft SQL Server 2005T. 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.

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

This one-day course provides students with the knowledge and skills to design the data tier for Microsoft SQL Server 2005. The clinic 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.

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

This two-day course provides 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 trade-offs that need to be made during design.

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

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 administering and automation information.

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

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 learning how to establish monitoring standards and baselines, determining performance thresholds, and focusing the investigation on specific issues.

This three-day course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

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.

In deze cursus leert u hoe u met de Business Intelligence Development Studio Reporting Services-rapporten en oplossingen kunt bouwen.

The purpose of this two-day course is 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.

The purpose of this 2-day course is 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.

The purpose of this three day course is 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.

The purpose of this 2 day course is 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.