You are here

SQL Server

Featured in 

SQL Server Reporting Services 2016 contains significant new functionality and improvements over its predecessors including the new Reporting Services Web portal, support for mobile reports and dashboards, a new HTML5 rendering engine, and exciting new report design enhancements. The three day course includes an overview of the SQL Server business intelligence architecture focusing the role of Reporting services. All reports are developed utilizing SQL Server Data Tools (SSDT), however the new 2016 Report Designer is also introduced.

Monday, May 21, 2018 - 9:00am
Featured in 

This course introduces Microsoft's SQL Server Reporting Services 2012 (SSRS) utility. It begins with a discussion of the Reporting Services architecture and how to set up Reporting Services servers. Students will install and configure Reporting Services, and perform hands-on exercises where they create various types of reports, including basic table-based reports, parameterized reports, drilldown reports, linked reports, sub-reports, matrix reports (pivot tables), free-form reports and reports with charts and gauges.

Monday, May 21, 2018 - 9:00am
Featured in 

This 3-day course is designed to give the right amount of Internals knowledge and wealth of practical tuning & optimization techniques that they can put into production. The course offers a comprehensive coverage of SQL Server architecture, indexing and statistics strategies, optimize transaction log operations, tempdb and data file configuration, transactions and isolation levels, and locking and blocking. The course also teaches how to create baselines and benchmark SQL Server performance, how to analyze workload and figure out where performance problems are, and how to fix them.

Wednesday, May 2, 2018 - 10:00am
Featured in 

This hands-on course introduces the SQL Server 2014 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS). Students start by installing and configuring SQL Server 2014 servers that support SSRS, SSIS and SSAS. Hands-on exercises will be performed where they create various types of reports, including basic table-based reports, parameterized reports, drilldown reports, linked reports, sub-reports, matrix reports (pivot tables), free-form reports and reports with charts and gauges.

Monday, May 21, 2018 - 9:00am
Featured in 

SQL Server Reporting Services 2016 contains significant new functionality and improvements over its predecessors including the new Reporting Services Web portal, support for mobile reports and dashboards, a new HTML5 rendering engine, and exciting new report design enhancements. Three of the five days are reserved for SSRS, with the remaining two days providing an introduction to SSIS and SSAS services.

Monday, May 21, 2018 - 9:00am
Featured in 

Complete Course Title: SQL Server 2012 Business Intelligence Application Development (SSRS, SSIS, SSAS) You will learn how to create various types of reports, including basic table-based reports, parameterized reports, drilldown reports, linked reports, sub-reports, matrix reports (pivot tables), free-form reports and reports with charts and gauges. Students learn how to group data and add subtotals and totals to reports, as well as how to add custom calculations using the built-in functions or using custom functions written in .NET.

Monday, May 21, 2018 - 9:00am
Featured in 

This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2012 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2012. The course focuses on performing common administrative tasks, understanding how SQL Server works under the covers, and optimizing SQL Server performance as well as assuring high data availability. You will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2012.

Monday, June 11, 2018 - 9:00am
Featured in 

Course Title: SQL Server 2012 Business Intelligence: Integration Services and Analysis Services This hands-on course focuses on the Integration Services (SSIS) and Analysis Services (SSAS) business intelligence tools that are bundled with SQL Server 2012. Students will install and configure SQL Server 2012 servers that are enabled for SSIS and SSAS, which are then used for comprehensive hands on exercises demonstrating key features of SSIS/SSAS.

Monday, June 4, 2018 - 9:00am
Featured in 

In this 2-day course, students will continue their learning on the foundations of report writing with Microsoft SQL Server Report Builder and SSRS. The focus will be on report writing by connecting to a database and manipulating the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, sorting and filtering data, charting data, and preparing reports for printing and exporting. Report Builder 3.0 is available for Microsoft SQL Server versions 2014, 2012, and 2008 R2.

Thursday, December 27, 2018 - 9:00am
Featured in 

In this 2-day course, students will continue their learning on the foundations of report writing with Microsoft SQL Server Report Builder and SSRS. The focus will be on report writing by connecting to a database and manipulating the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions, displaying aggregated data, sorting and filtering data, charting data, and preparing reports for printing and exporting. Report Builder 3.0 is available for Microsoft SQL Server versions 2014, 2012, and 2008 R2.

Thursday, September 27, 2018 - 9:00am

Pages