SQL 2017 DBA Courses
SQL 2016 Developer Courses
Introduction to SQL
The ability to write the SQL language - the cornerstone of all relational database operations - is essential for anyone who develops database applications.
Learn to leverage all that the SQL language has to offer. In this introduction to SQL training, you learn how to optimize the accessibility and maintenance of data with the SQL programming language, and gain a solid foundation for building, querying, and manipulating databases.
Learn how to retrieve large amounts of data quickly and efficiently. Using SQL, you will be able to write basic to complex queries, build reporting solutions or implement data warehouses.
Introduction to SQL Databases
This three-day instructor-led course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass database elements. The course describes fundamental database concepts including database types, database languages, and database designs.
SQL 2016 DBA Courses
Performance Tuning and Optimizing SQL Databases
This four-day instructor-led course provides students who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their databases.
PowerShell for SQL Administration
This course is intended for SQL administrators with little or basic knowledge of PowerShell. The course centers on SQL administrative tasks that are commonly used, and provides the basic understanding needed for administrators to utilize the expanding PowerShell SQL interoperations. The course concludes with a copy of course 752552 PowerShell 5.0 Basics.
Querying Data with Transact-SQL
This course is designed to introduce students to Transact-SQL. It is designed in such a way that the first three days can be taught as a course to students requiring the knowledge for other courses in the SQL Server curriculum. Days 4 & 5 teach the remaining skills required to take exam 70-761.
SQL 2014 Business Intelligence Courses
Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014
This instructor-led course provides students with the necessary knowledge to develop reports using Microsoft Report Builder 3.0. The training environment includes SQL 2008R2, SQL 2012, and SQL 2014 Standard and Enterprise, so that the students can utilize Report Builder 3.0 and generate reports from multiple sources to investigate the different features of each release.
Quick Microsoft SQL Server 2012-2014 Integration Services
This two-day instructor-led course is intended for those that are new to SQL Server Integration Services or are interested in learning the features available. This course uses an instructor-led topic explanation, instructor performing detailed demonstrations, then the student performing exercises to duplicate what the instructor demonstrated. This style of training is a combination of traditional classroom training and mentored learning. Additionally, videos of the demonstrations performed by the course author are included with the course as a take-away. The course completes with additional scenario-based labs to reinforce the course content.
SQL 2014 DBA Courses
PowerShell for SQL Server Administrators
This two-day instructor-led course provides candidates with the knowledge and skills needed to use PowerShell for SQL Server administration. Students will learn how to manage day-to-day and scheduled maintenance tasks. The main focus will be administration of the database engine, but material & exercises on Analysis Services (SSAS) and Integration Services (SSIS) are also included.
Master Data Services, Data Quality Services with SQL 2012-2014 and Excel
Studies show that data decays at about 2% a month all organizations need to work from reliable information while ensuring that the integrity of information and consistency of data is constant across different applications. Microsoft SQL Server 2012-2014 Master Data Services is a powerful feature designed to help an organization create a structure and hierarchy for data, so that data collected and used across multiple departments, silos and databases is standardized and aligned. This ensures that different databases are interoperable. When combined with Data Quality Services and Excel a complete end to end system is available.
Microsoft SQL AlwaysOn and High Availability
This two-day instructor-led course is designed for database administrators to familiarize them with the concepts in SQL AlwaysOn and High Availability. The course utilizes SQL 2014, but explains the differences from SQL 2012.
SQL 2014 Developer Courses
SQL Server 2014 Performance Tuning and Optimization
This 5-day course is designed to give the right amount of internals knowledge combined with a wealth of practical tuning and optimization techniques that students can put into production.
SQL AZURE DBA Courses
Advanced SQL Azure
This 4-day Instructor Led course This class is an in-depth look at SQL Azure, the database cloud offering in Windows Azure. Learn the basics around server and database provisioning, valid Azure TSQL, and how security is implemented and managed. Advanced topics include partitioning with sharding, database design optimization, backup and synchronization via Synchronization Framework and Azure Data Sync and migrating various database scenarios to SQL Azure.
SQL2012 Business Intelligence Courses
SQL Server 2012 Reporting Services
This three-day instructor-led is intended for information workers and database professionals who are interested in expanding their knowledge about SQL Server 2012 Reporting Services. During this course, attendees will learn how to Report Designer in SSDT and Report Builder, work with solutions and projects, design basic reports, enhance reports with formatting and images, effectively group and summarize data, work with parameterized reports, incorporate charts and custom maps, and work with drill-through reports, and manage reports.
SQL 2008 Business Intelligence Courses
PowerPivot for End Users
This 2-day Instructor Led course How to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. You will also explore how PowerPivot workbooks can be integrated with SharePoint 2010.
SQL 2008 DBA Courses
Basics of Transact SQL with SQL Server 2008 R2
This instructor-led course provides students with the necessary knowledge to work with the data in SQL Server 2008R2. They will learn how to use the built in tools included with SQL Serverto construct queries, do tuning,analyze a query and it’s performance along with how to modify existing data, perform joins, create indexes and work with XML.The new features are discussed and their impact is explained.
Microsoft SQL Server 2008 R2: What's New
SQL Server 2008 brought many changes to the SQL platform and the R2 release added many more. This course will help to bring you up to speed on these changes and how they will affect how you work with SQL Server. You will see what is new with installation and security, see its support for managing data-tier applications and a multi-server environment, and learn about PowerPivot, which Microsoft calls “managed self-service business intelligence” that gets BI data in the hands of users who need it. Next you will learn about the new StreamInsight feature that lets you query high-volume data streams for useful nuggets of information and emerging trends. Reporting Services probably received by far the most enhancements in R2 and you will learn about the new expression language and data visualization features. Report Manager and Viewer received major overhauls, and you’ll see how to put them to good use, as well as exploring how to put Report Builder to use creating great reports.
Database Administration Fundamentals: MTA Exam 98-364
This three-day MTA Training course helps you prepare for Microsoft Technology Associate Exam 98-364, and build an understanding of these topics: Core Database Concepts, Creating Database Objects, Manipulating Data, Data Storage, and Administering a Database. This course leverages the same content as found in the Microsoft Official Academic Course (MOAC) for this exam.
SQL 2008 Reporting Services Courses
SQL Server 2008 R2 Reporting Services
This four-day instructor-led course teaches students how to implement a Reporting Services solution in an organization. The course discusses how to use the Reporting Services development tools to create reports, and how to use the Reporting Services management and administrative tools to manage a Reporting Services solution.
Visualizing Data with SQL 2008 R2 and Report Builder 3.0
This instructor led course provides students with the knowledge and skills to add graphs gauges and maps to reports developed utilizing SQL Server 2008 R2 reporting services. The development of these visualizations focuses on the use of report builder 3.0. This tool is reporting tools that integrates the development of reports with visualizations.
SQL 2019 DBA Courses
Querying Data with Microsoft Transact SQL
This course will teach the basics of Microsoft's dialect of the standard SQL language: Transact-SQL. Topics include both querying and modifying data in relational databases that are hosted in Microsoft SQL Server-based database systems, including: Microsoft SQL Server, Azure SQL Database and, Azure Synapse Analytics.