SQL 2017 DBA Courses

Updating Your Skills to SQL Server 2017

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

This two-day instructor-led course is aimed at database professionals looking to update their skills to cover SQL Server 2017.

View Details

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 Business Intelligence Courses

Data Analysis Fundamentals using Excel

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

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.

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

Developing SQL Databases

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

This five-day instructor-led 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.

View Details

Developing SQL Data Models

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

The focus of this 3-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course helps you prepare for the Exam 70-768.

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

Updating Your Skills to SQL Server 2016

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

This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.

View Details

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

Administering a SQL Database Infrastructure

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

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases.

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

Provisioning SQL Databases

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

This course is designed to teach students how to provision SQL Server databases both on premise and in SQL Azure.

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

Implementing Data Models and Reports with SQL Server 2014

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

The focus of this five-day instructor-led course is on creating managed enterprise BI solutions. It describes how to implement multidimensional and tabular data models, deliver reports with Microsoft® SQL Server® Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining.

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

Designing Self-Service Business Intelligence and Big Data Solutions

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

This five-day instructor-led course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform. The course discusses the rationale for self-service BI, and describes how to use Microsoft SQL Server Reporting Services, Microsoft Excel, Microsoft SharePoint Server, and Microsoft Office 365 Power BI to create self-service data models and reports. The course then goes on to describe how to use Windows Azure HDInsight to perform Big Data analysis.

View Details

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

Administering Microsoft SQL Server 2014 Databases

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

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2014 database. The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

View Details

Implementing a Data Warehouse with Microsoft SQL Server 2014

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

This course describes how to implement a data warehouse platform to support a BI solution. Students will learn how to create a data warehouse with Microsoft SQL Server 2014, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

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

Querying Microsoft SQL Server 2014

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

This 5-day instructor led course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence. This course helps people prepare for exam 70-461.

View Details

SQL 2014 Developer Courses

Designing Solutions for Microsoft SQL Server 2014

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

The focus of this five-day instructor-led course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies. It describes how to consolidate SQL Server workloads, work with both on-premises and Microsoft Azure cloud-based solutions, and how to plan and implement high availability and disaster recovery solutions.

View Details

Developing Microsoft SQL Server 2014 Databases

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

This 5-day instructor-led course introduces SQL Server 2014 and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course. Also this course helps you prepare for the Exam 70-464.

View Details

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 Analysis Services Courses

Implementing and Maintaining Microsoft SQL Server2008 Analysis Services

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

This three-day instructor-led course teaches students how to implement an Analysis Services solution in an organization. The course discusses how to use the Analysis Services development tools to create an Analysis Services database and an OLAP cube, and how to use the Analysis Services management and administrative tools to manage an Analysis Services solution.

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

Maintaining a Microsoft SQL Server 2008 R2 Database

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

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 R2 database. The course focuses on teaching individuals how to use SQL Server 2008 R2 product features and tools related to maintaining a database.

View Details

Implementing a Microsoft SQL Server 2008 R2 Database

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

This five-day instructor-led course is intended for Microsoft SQL Server database developers who are responsible for implementing a database on SQL Server 2008 R2. In this course, students learn the skills and best practices on how to use SQL Server 2008 R2 product features and tools related to implementing a database server.

View Details

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

Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

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

This three-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

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