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.
LIVE / VIRTUAL TRAINING
NON-TECHNICAL SQL TRAINING
BUSINESS USERS AND NON-PROGRAMMERS
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
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.
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.
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
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.
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.
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.
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
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
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
These on-demand courses by Microsoft combine video, courseware, online labs and knowledge checks in a self-paced format. Build your skills on your schedule—all at once or 5 minutes at a time.
TOP SQL BLOGS
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…
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…
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…
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.…