SQL Server Training

Training Courses

MOC 10977 Upgrading Your SQL Server Skills to Microsoft® SQL Server® 2014

This five-day instructor-led course 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.More Details

MOC 20462 Administering Microsoft® SQL Server® Databases

This five-day instructor-led course provides 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. Also this course helps you prepare for the Exam 70-462.More Details

MOC 10775A Administering Microsoft SQL Server 2012 Databases

This Microsoft Official Course (MOC) provides students with the knowledge 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.More Details

MOC 20467C Designing Self-Service Business Intelligence and Big Data Solutions

This Microsoft Official Course (MOC) teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to use Microsoft SQL Server Reporting Services, Microsoft Excel, and Microsoft Office 365 to deliver a self-service BI solution, and how to use Microsoft Windows Azure HDInsight to incorporate Big Data analysis into a BI scenario.More Details

MOC 10778A Implementing Data Models and Reports with Microsoft SQL Server 2012

In this Microsoft Offficial Course (MOC), students will learn to develop advanced ASP.NET MVC and Web Forms applications using .NET Framework 4.5 tools and technologies. The focus will be on coding activities that enhance the performance and scalability of the Web site application. ASP.NET MVC will be introduced and compared with Web Forms so that students know when each should/could be used.More Details

MOC 10774A Querying Microsoft SQL Server 2012

This Microsoft Official Course (MOC) provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012. Students will learn how to select, sort and group data, how to use subqueries and stored procedures and how to utilize functions and transactions.More Details

MOC 20461C Querying Microsoft SQL Server

This instructor led Microsoft Official Course (MOC) provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2012 or 2014. Students will learn how to select, sort, and group data as well as how to join tables, use aggregate functions and execute stored procedures.More Details

MOC 20464C Developing Microsoft SQL Server 2014 Databases

This Microsoft Official Course (MOC) provides students with an introduction to 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. This course helps you prepare for Exam 70-464.More Details

MOC 20463C Implementing a Data Warehouse with Microsoft SQL Server

This course 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® 2012 or 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.More Details

SQL Server 2012 Queries using T-SQL Training

In this SQL Server 2012 Queries using T-SQL Training Course students will learn about the SELECT statement, the WHERE, ORDER BY and GROUP BY clauses. Finally, attendees will learn to use T-SQL INSERT, UPDATE, and DELETE statements.More Details

SQL Querying Introduction Training

In this SQL Querying Introduction Training course, students will learn the basics of retrieving data from a database using Structured Query Language (SQL.) Students will also learn how to sort, filter and group data in a query result.More Details

SQL Querying Advanced Training

In this SQL Querying Advanced Training course, students will learn how to use subqueries; how to insert, modify and delete data using a SQL statement; how to create, backup and delete tables and how to work with views, indexes and transactions.More Details

SQL Server 2008 Reporting Services Training

In this SQL Server 2008 Reporting Services Training course students learn how to create tabular and list reports, use global, field and parameter collections, create groups using the grouping pane for Details Group and Row Groups, create Matrix reports and see the new features of Matrix reports for SSRS 08, and to create a Web Service, a Web Service Subscription and Custom Assemblies.More Details

SQL Server 2008 Integration Services Training

In this SQL Server 2008 Integration Services Training course students learn how to use BIDS to create well-designed packages, to work with Control Flows and understand how to build them using many of the built-in tasks, including the various containers, and to understand variables and configurations to make their packages dynamic and resilient to changes in environments.More Details

SQL Server 2008 Analysis Services Training

In this SQL Server 2008 Analysis Services Training course students learn how Business Intelligence applies to a database, how the cube structure works for viewing data information, see how to create cube models using SQL Server Business Intelligence Development Studio (BIDS), and how to create key performance indicators (KPIs).More Details

SQL Server 2008 for Developers Training

In this SQL Server 2008 for Developers Training course students learn how to apply relational database design principles, use SQL Server Management Studio (SSMS), implement security with authentification, authorization and encryption, and to understand Business Intelligence to add reporting and analysis capabilities to databases and applications.More Details

T-SQL with SQL Server 2008 Training

In this T-SQL with SQL Server 2008 Training course students learn how to create a SQL Server database based on sound design principles, create constraints, triggers, and indexes, write and use stored procedures to provide a safe, controlled, efficient way to execute Transact-SQL code to access and update data and database objects, and to understand the complex data types in SQL Server.More Details