SQL 2017 DBA Courses

PostgreSQL Administration

Course ID: TP3025
Delivery: On-Site or Instructor-led Virtual

PostgreSQL Administration training class teaches students how to build, query, administer, backup, and secure PostgreSQL.

View Details

SQL 2016 Developer Courses

Introduction to SQL

Course ID: WA3021
Delivery: On-Site or Instructor-led Virtual

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. 

View Details

Introduction to SQL Databases

Course ID: 10985
Delivery: On-Site or Instructor-led Virtual

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.

View Details

SQL 2016 DBA Courses

Performance Tuning and Optimizing SQL Databases

Course ID: 10987
Delivery: On-Site or Instructor-led Virtual

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.

View Details

PowerShell for SQL Administration

Course ID: 55207
Delivery: On-Site or Instructor-led Virtual

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.

View Details

Querying Data with Transact-SQL

Course ID: 20761
Delivery: On-Site or Instructor-led Virtual

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.

View Details

SQL 2014 Business Intelligence Courses

Microsoft Report Builder 3.0 with SQL 2008R2, SQL 2012, and SQL 2014

Course ID: 55005
Delivery: On-Site or Instructor-led Virtual

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.

View Details

Quick Microsoft SQL Server 2012-2014 Integration Services

Course ID: 55120
Delivery: On-Site or Instructor-led Virtual

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.

View Details

Data Modeling with SQL BISM Tabular Mode

Course ID: 55163
Delivery: On-Site or Instructor-led Virtual

This course is designed to introduce the participant to SQL Business Intelligence Semantic Model (BISM) Tabular mode, data modeling, and DAX.

View Details

SQL 2014 DBA Courses

PowerShell for SQL Server Administrators

Course ID: 55069
Delivery: On-Site or Instructor-led Virtual

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.

View Details

Master Data Services, Data Quality Services with SQL 2012-2014 and Excel

Course ID: 55073
Delivery: On-Site or Instructor-led Virtual

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.

View Details

Microsoft SQL AlwaysOn and High Availability

Course ID: 55153
Delivery: On-Site or Instructor-led Virtual

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.

View Details

SQL 2014 Developer Courses

SQL Server 2014 Performance Tuning and Optimization

Course ID: 55144
Delivery: On-Site or Instructor-led Virtual

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. 

View Details

SQL AZURE DBA Courses

Advanced SQL Azure

Course ID: 50592
Delivery: On-Site or Instructor-led Virtual

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.

View Details

SQL2012 Business Intelligence Courses

SQL Server 2012 Reporting Services

Course ID: 55119
Delivery: On-Site or Instructor-led Virtual

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.

View Details

SQL 2008 Business Intelligence Courses

PowerPivot for End Users

Course ID: 50433
Delivery: On-Site or Instructor-led Virtual

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.

View Details

SQL 2008 DBA Courses

Basics of Transact SQL with SQL Server 2008 R2

Course ID: 50439
Delivery: On-Site or Instructor-led Virtual

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.

View Details

Microsoft SQL Server 2008 R2: What's New

Course ID: WA1960
Delivery: On-Site or Instructor-led Virtual

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.

View Details

Database Administration Fundamentals: MTA Exam 98-364

Course ID: 40364
Delivery: On-Site or Instructor-led Virtual

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.

View Details

SQL 2008 Reporting Services Courses

SQL Server 2008 R2 Reporting Services

Course ID: WA1956
Delivery: On-Site or Instructor-led Virtual

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.

View Details

Visualizing Data with SQL 2008 R2 and Report Builder 3.0

Course ID: 50555
Delivery: On-Site or Instructor-led Virtual

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.

View Details

SQL 2019 DBA Courses

Querying Data with Microsoft Transact SQL

Course ID: DP-080T00
Delivery: On-Site or Instructor-led Virtual

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.

View Details