Microsoft SQL Server Training
Practical, instructor-led Microsoft SQL Server training, delivered onsite or live online and customized for your team's needs.
Available onsite in Mc Allen, Texas or live online.
10 courses in this category
This two-day, instructor-led course provides students with the knowledge and skills to effectively develop, test, and deliver modern SQL Server databases. Students will experience how to manage changes to a database schema, ensure quality through T-SQL unit testing and static code analysis, and automate the build and deployment of SQL Server and Azure SQL databases. …
This Introduction to SQL Server 2016/2019 Reporting Services (SSRS) training class teaches students how to create, format, and manage SQL Server 2016/2019 Reporting Services reports. This course focuses primarily on the Report Designer tool in the SQL Server Data Tools (SSDT) for Visual Studio. Attendees will also work in and become familiar with Report Builder and Report Manager. …
The Intermediate SQL for Microsoft SQL Server course is intended for SQL users in programming roles who have taken an Introduction to SQL course. This course covers creating CTEs, using a Windows function, creating and using Global Variables, and pivoting data. This course is applicable to Microsoft SQL Server. Some topics may be applicable to other Database Management Systems, but most…
This one-day course familiarizes the participant with Power BI Online, which allows you to intuitively discover and automate the import, transformation, and combination of data across a variety of data sources.…
This two or three day instructor-led course is designed for database administrators and Windows engineers to familiarize them with the concepts in SQL AlwaysOn and High Availability. The course utilizes SQL 2016, but explains the differences from SQL 2012- SQL 2014. For skills to be transferred this is a lab intense course. It is designed for the student to understand the the reason for the lab…
This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards…
This five-day course provides a comprehensive understanding of SQL Server and its various components. Students will learn about the SQL Server platform, its architecture, and how to configure services, accounts, and networking. The course covers topics such as installation, upgrade strategies, and configuring databases and data files. Students will…
This five-day instructor-led course is intended for IT professionals who wish to use the Transact-SQL language to query and configure Microsoft SQL Server. Students are typically database developers and database administrators, but might also be Business Intelligence developers, report creators, or application developers. In this course, students learn how to query single tables, join…
Today it may not be possible to request a report for a changing business from traditional IT but instead it is much more practical to teach every business user how easy it is to create and modify their own or the reports from their teams... Microsoft anticipated this trend with their purchase of the popular technology known as DataZen. DataZen was popular because it allowed regular business users …
This 4-day SQL Server course, Introduction to SQL for Analysts, is designed to teach attendees both beginning and intermediate Transact-SQL (T-SQL). The course covers writing simple and complex queries, working with data types, using built-in functions, and more. Students will also learn how to combine data from multiple tables and result sets using JOIN operations, subqueries, and…
No Microsoft SQL Server courses match your search. Search the full catalog →
Training locations
We provide Microsoft SQL Server training onsite and live online for organizations throughout the United States and internationally.
Need help choosing?
Tell us what you need to accomplish. We'll recommend the best course or create a custom class for your organization.