SQL Server Online and Onsite Training Classes - with Microsoft Certified Instructors

This SQL class is designed for students new to writing SQL queries using... (More) 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.

This Querying Microsoft SQL Server training class provides students with... (More) the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. 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.

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

This Implementing a Data Warehouse with Microsoft SQL Server 2014 training... (More) class describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, 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 Developing Microsoft SQL Server 2014 Databases training class introduces... (More) SQL Server 2014 and describes logical table design, indexing and query plans. It also focuses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464.

The focus of this Implementing Data Models and Reports with Microsoft SQL... (More) Server 2014 training class is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

This five-day Upgrading Your SQL Server Skills to Microsoft SQL Server 2014... (More) instructor-led training class provides existing SQL Server 2008 database professionals with the knowledge and skills to use new and enhanced capabilities in SQL Server 2014. The course covers the major advancements made in the SQL Server platform since SQL Server 2008, including new features in the SQL Server 2014 release.

This Microsoft SQL Server 2014 database training describes how to design... (More) and monitor high performance, highly available data solutions with SQL Server 2014. 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 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 Report Builder 3.0 with SQL 2008R2, SQL 2012 Express and... (More) SQL 2012 instructor-led training provides students with the necessary knowledge to develop reports using Microsoft Report Builder 3.0. The training environment includes SQL 2008R2, SQL Express 2012 and SQL 2012 Standard and Enterprise so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release.

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 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.

Designing Self-Service Business Intelligence and Big Data Solutions... (More)

This three-day MTA Training course helps you prepare for Microsoft Technology... (More) Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.

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 free SQL Server Solutions from the Web course is a survey of SQL Server solutions available from the web.

In this Introduction to SQL Server 2014 Reporting Services (SSRS) training... (More) class teaches students how to create, format, and manage SQL Server 2014 Reporting Services reports. This course focuses primarily on the Report Designer tool in the SSDT-BI for Visual Studio 2013. Attendees will also work in and become familiar with Report Builder and Report Manager.

In this Creating Reports with Report Builder training class, students learn... (More) how to create, format, and customize SQL Server 2014 Reporting Services reports using the Report Builder tool. This class is geared toward business analysts and data consumers who need to be able to successfully create reports on a SQL Server Reporting Services server. Our live online class is taught with SQL Server 2014 but the class is available as a private class using SQL Server 2008 R2 or 2012.

In this SQL Server Reporting Services 2012 for Report Writers training class,... (More) students obtain a thorough understanding of how to create reports with SQL Server Reporting Services.

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 Reporting Services 2008R2 for Report Writers training... (More) class, students obtain a thorough understanding of how to create reports with SQL Server Reporting Services.

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.

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 database design training class can be customized based on the students'... (More) experience working with and building databases.