SQL Server Training - with Microsoft Certified Instructors

This Transact-SQL training class provides students with the technical skills... (More) required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

This SQL Server training class provides students with the knowledge and... (More) skills to maintain a Microsoft SQL Server 2008 R2 database. The class focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database.

This SQL Server training class is intended for Microsoft SQL Server database... (More) developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server.

This Microsoft SQL Server 2012 training provides students with the technical... (More) skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461. Many of the exercises in this course are SQL Azure enabled.

This SQL Server 2012 Database training provides students with the knowledge... (More) and skills to maintain a Microsoft SQL Server 2012 database. The course focuses on teaching individuals how to use SQL Server 2012 product features and tools related to maintaining a database. Also this course helps you prepare for the Exam 70-462.

This Microsoft SQL Server 2012 Database training introduces SQL Server Denali... (More) and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as transactions, concurrency, error handling, triggers, and SQL CLR are also covered in this course.

This Data Warehouse with Microsoft SQL Server 2012 instructor-led training... (More) describes how to implement a BI platform to support information worker analytics. Students will learn how to create a data warehouse with SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. This course helps people prepare for the exam 70-463.

This Microsoft SQL Server 2012 instructor-led training describes how to... (More) empower information workers through self-service analytics and reporting. Students will learn how to implement PowerPivot and tabular data models, create and deliver rich data visualizations with Power View and SQL Server Reporting Services, and discover business insights by using data mining. This course helps people prepare for exam 70-466.

This Microsoft SQL Server 2012 instructor-led training provides existing... (More) SQL Server database professionals with the knowledge and skills to use new and enhanced capabilities in SQL Server 2012.

This Microsoft SQL Server 2012 instructor-led training provides existing... (More) SQL Server Business Intelligence (BI) professionals with the knowledge and skills to use new and enhanced BI capabilities in SQL Server 2012.

This Microsoft SQL Server 2012 database training describes how to design... (More) and monitor high performance, highly available data solutions with SQL Server 2012. This course focuses on creating plans and designs for database structure, storage, objects, and servers. Students will have the opportunity to practices hands-on skills and design tasks in a virtual lab environment and will learn about topics such as data compression, high availability, data migration, security, and scalability.

This Business Intelligence Solutions with Microsoft SQL Server 2012 training... (More) teaches students how to design and implement a BI infrastructure. The course discusses design, installation. the course discusses design, installation, and maintenance of a BI platform. This course maps to skills and knowledge measured by Microsoft Exam 70-467, and in conjunction with on-the-job experience, can help prepare you for the exam.

This SQL Server training course is designed for students new to writing... (More) SQL queries using SQL Server. The SQL learned in this course is standard to all modern databases, but SQL Server will be used in class and syntax and functionality specific to SQL Server will be pointed out.

In this DDL training class, you will learn to the basic principles of normalization... (More) and to create and modify database tables, views and stored procedures using SQL. Syntax will be shown in SQL Server, Oracle, and MySQL.

This SSAS training class teaches students how to implement an Analysis Services... (More) solution in an organization. The class 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.

In this SQL Server Integration Services (SSIS) training class, students... (More) learn how to implement an Integration Services solution in an organization. The course discusses how to develop, deploy, and manage Integration Services packages.

This SQL Server Reporting Services (SSRS) class teaches students how to... (More) implement a Reporting Services solution in an organization. The class 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.

This SSRS training class teaches students how to implement a Reporting Services... (More) 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.

This Dashboards for Monitoring, Analyzing and Managing Training is designed... (More) to empower the students to effectively design web-based dashboards by utilizing the three main tools for dashboard building in the Microsoft tool set. Report Builder 3.0 from SQL Reporting Services, Dashboard Designer from PerformancePoint Services and SharePoint Designer. In using each of these tools you gain the best of breed to combine features and develop dashboards that are highly effective for monitoring, analyzing and managing your business.

This SQL Server training class provides experienced SQL Server 2005 developers... (More) and database administrators the knowledge and skills to upgrade their SQL Server 2005 skills to SQL Server 2008.

This SQL Server 2005 training class provides students with the knowledge... (More) 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 SQL Server training class provides students with the knowledge and... (More) 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 instructor-led SQL Server 2008 training class provides students... (More) with the knowledge and skills to create database solutions that use spatial data in Microsoft SQL Server 2008. The course introduces developers to spatial data concepts and the geography and geometry spatial data types in SQL Server 2008 and how to use these data types to store geographic and location-based data and to perform spatial operations and queries.

This Visual Studio Team System training class provides students with the... (More) knowledge and skills to properly manage the SQL Server database development lifecycle in an agile environment. The student will learn how to manage changes to the database structure, ensuring quality through T-SQL unit testing, and how to automate the building and deploying of SQL Server databases. Intended for developers and administrators already comfortable with the concepts of designing, programming, testing, and deploying SQL Server databases, this course focuses on using Visual Studio Team System 2008 Database Edition to maximize productivity while minimizing mistakes.

This SSIS training class teaches students how to implement an Integration... (More) Services solution in an organization. The class discusses how to develop, deploy, and manage Integration Services packages.

This .NET training class will give the working DBA sufficient skills with... (More) .NET so that they can use it effectively in all the areas supported by SQL Server. The course starts with learning Visual Basic language concepts, including Data Types, Variables, and Classes and Objects while building simple console applications. Then it moves on to handling exceptions by using try/catch blocks and other programming tools - ADO.NET will be used for connecting to data sources and related topics. You'll then learn to work with SQL 2008's features like SQL Server Management (SSMS), Object Explorer, Query Editor plus others and then the development feature SQL CLR (Common Language Runtime). Finally, there is an overview of SQL Business Intelligence for 2008.

This database design training class can be customized based on the students'... (More) experience working with and building databases.