SQL Server Training

Interface offers quality SQL Server Training to IT professionals. We tune our SQL training courses and build our program based on what you require. We often use Microsoft Official Courses. Sometimes we modify and improve these courses. Sometimes we build our own courses from the ground up. Attend our classes in person, or online with RemoteLive™. And, watch your live class again with Replay! Try our SQL training – we guarantee your satisfaction.




SQL101: Introduction to Transact SQL
This 4-day course is for students with no programming background! You’ll learn how to access complex databases and master the SELECT statement in order to retrieve the data you need. If you are responsible for data reporting, and you need access a SQL Server database, this is the perfect course.  


Database Administrators

SQL764A: Provisioning and Administering a SQL Server Database
Interface created this 5-day course by combining all the infrastructure training (and removing all the cloud implementation) from two Microsoft Official courses – 20764 and 20765. If you need to administer a full SQL Server implementation in an on-premise or cloud infrastructure, and you have no intention of implementing in the cloud, you’ll gain mastery in SQL Server implementation in one week instead of 2 weeks.  

Database Developers

SQL250: Transact-SQL for Developers
This 5-day course is structured the same way the SQL executes a query, rather than teaching to a list of features. The result is a more logical way to learn. You’ll master the technical skills required to write Transact-SQL queries, scripts, Views, Stored Procedures and User-Defined Functions, and how to use T-SQL statements inside common database objects. If you need to go faster and deeper than SQL101, and have a programming and developer background, this is the perfect course.  
20762: Developing SQL Databases in Microsoft SQL Server 2016
This 5-day Microsoft Official course provides students with the knowledge and skills to develop a Microsoft SQL Server 2016 database. The course focuses on teaching individuals how to use SQL Server 2016 product features and tools related to developing a database.  

Business Intelligence Developers

BI795 – SQL Server Reporting Services (SSRS) for Report Developers
This 4-day course gives students the skills required to design, enhance and manage the SQL Server 2016 Reporting Services (SSRS) toolset. Students will learn how to use SSRS tools, work with solutions and projects, design basic reports, enhance reports with formatting, images, and charts, effectively group and summarize data, work with parameterized reports, incorporate charts and custom maps, work with drillthrough reports, manage reports, and to utilize Report Builder.  
20767: Implementing a SQL Server 2016 Data Warehouse in SSIS
This 5-day Microsoft Official course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with SQL Server 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services. This class also dives into Data Quality Services and Master Data Services implementations for Business Intelligence (BI) solutions.  
20768: Developing SQL Server 2016 Data Models in SSAS
This 3-day Microsoft Official course is for students who fulfill a Business Intelligence (BI) developer role. This course looks at implementing multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models for analysis with SSAS. Get the skills needed to successfully create multidimensional and tabular databases using Microsoft SQL Server Analysis Services (SSAS). Students will learn to create, implement and manage enterprise BI solutions, use MDX and DAX cube customizations and use data mining for predictive analysis.  
20778: Analyzing Data with Power BI
This 3-day Microsoft Official course will give you the skills to create Power BI solutions using the Power BI desktop tool and then distribute them using the Power BI service. The course includes extracting/transforming from various data sources, tabular data modelling, DAX, creating visualizations, the Power BI Service, and the Power BI Mobile App.  


Advanced SQL Concepts and Query Tuning

SQL419: Advanced T-SQL Querying, Programming and Tuning for SQL Server 2012 – 2019
This 5-day master course is taught by Itzik Ben Gan, the world-renowned expert in Transact SQL. This course is for students who want to master all of the power of the SQL language, and leverage it in their applications. This include SQL query tuning. Interface is the only resource for this very special class in North America.  

SQL Server Internals and Server Tuning

10987: Performance Tuning and Optimizing SQL Databases
This 4-day Microsoft Official course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their servers. Learn the high level architectural overview of SQL Server 2016 and explore SQL Server execution model, waits and queues. This class covers concepts such as SQL Server I/O, database structures, SQL Server memory configuration, statistics and index internals, query execution and plan analysis and finisher with monitoring and troubleshooting SQL Server 2016.  



How to Use Values from Previous or Next Rows in a SQL Server Query

Posted on May 28, 2013 by Peter Avila

I recently came across a problem that required having to perform a calculation in a query that involved a value in the current row and a value in the previous row.  The problem is that SQL queries perform operations on a row-by-row basis; accessing data on different rows at the same time requires the query…

How to Audit Report Execution in SSRS

Posted on February 21, 2014 by Peter Avila

Do you need to know how often a report runs, who or what processes run the report, how long it takes to run, statistics on report parameters, which reports are not being used, and so on? SQL Server Reporting Services has built-in audit logging that can give you this type of information pretty easily. Audit…

Adding a Secondary Axis to a SSRS Chart

Posted on July 15, 2013 by Peter Avila

What happens when you use the same scale to compare values that are actually in different scales? Have a look at this chart that was generated using Reporting Services and notice that you can barely see the gold columns for the Average Sales values. The data (see the table next to the chart) tells us…

How to Implement Expand All/Collapse All for Drill-Down in SSRS

Posted on November 05, 2013 by Peter Avila

While SSRS allows drill-down into individual groups in a Tablix, there is no built-in, direct support for an “expand all/collapse all” capability that would allow all groups to be simultaneously expanded or collapsed. No problem. We can create our own pretty easily. Here’s what it will do: The user will interact with two radio buttons.…