SQL Server Training

Interface is a Microsoft partner, and we’ve been providing quality SQL Server Training for 20 years. We’ve trained more than 4500 IT professionals and we have tuned our SQL courses and built our program based on what they require. We often use Microsoft Official courses. Sometimes we modify and improve these courses. Sometimes we build our own courses from the ground up. You can attend our classes in person, or online with RemoteLive, and you can watch your live class again with Replay! We also offer on-demand video courses, and free tech blogs and Classroom Drillbits™. Try our training – we guarantee your satisfaction.

LIVE / VIRTUAL TRAINING

NON-TECHNICAL SQL TRAINING

BUSINESS USERS AND NON-PROGRAMMERS

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.  

TECHNICAL SQL TRAINING

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

BI790 – SQL Server 2016 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 TRAINING

Advanced SQL Concepts and Query Tuning

SQL416: Advanced T-SQL Querying, Programming, and Tuning for SQL Server with Itzik Ben-Gan
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.  

ON-DEMAND VIDEO TRAINING

TOP SQL BLOGS

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

Posted on May 28, 2013 by PeterAvila

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 PeterAvila

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 PeterAvila

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 PeterAvila

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