Home >> All Categories >> COMPUTERS / IT Training

Database Private Group / On-Site Training

 2072 Administering a Microsoft SQL Server 2000 Database

 

This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft® SQL Server™ 2000

 2073 Programming a Microsoft SQL Server 2000 Database

 

This course provides students with the technical skills required to program a database solution by using Microsoft® SQL Server™ 2000

 2778 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

 

This course provides students with the technical skills required to write basic Transact-SQL queries for Microsoft SQL Server 2008.

 2779 Implementing a Microsoft SQL Server 2005 Database

 

This course provides students with product knowledge and skills needed to implement a Microsoft SQL Server 2005 database

 2780 Maintaining a Microsoft SQL Server 2005 Database

 

This course provides students with product knowledge and skills needed to maintain a Microsoft SQL Server 2005 database

 2781 Designing Microsoft SQL Server 2005 Server-Side Solutions

 

This course provides students with the knowledge and skills to design server-side solutions for Microsoft® SQL Server 2005T

 2782 Designing Microsoft SQL Server 2005 Databases

 

This course provides students with the knowledge and skills to design databases for Microsoft SQL ServerT 2005 using business requirements to guide their decisions

 2784 Tuning and Optimizing Queries Using Microsoft SQL Server 2005

 

This workshop provides database developers working in enterprise environments using Microsoft SQL ServerT 2005 the knowledge and skills to evaluate and improve queries and query response times.

 2786 Designing Microsoft SQL Server 2005 Infrastructure and Services

 

This course provides database administrators working in enterprise environments with the knowledge and skills to design a Microsoft SQL ServerT 2005 database infrastructure

 2787 Designing Security for Microsoft SQL Server 2005

 

This course enables database administrators in enterprise environments to design security for database systems using Microsoft SQL ServerT 2005

 2788 Designing a High Availability Database Solutions Using Microsoft SQL Server 2005

 

The course focuses on teaching experienced database administrators working in enterprise environments to design database solutions that meet the availability needs of their organization

 2789 Administering and Automating Microsoft SQL Server 2005 Databases and Servers

 

This course provides students with the knowledge and skills to administer and automate Microsoft® SQL ServerT 2005 databases and servers

 2790 Troubleshooting and Optimizing Database Servers using Microsoft SQL Server 2005

 

This workshop teaches database administrators working in enterprise environments how to determine and troubleshoot performance issues using Microsoft SQL Server 2005

 2793 Implementing and Maintaining Microsoft SQL Server 2005 Reporting Services

 

This course teaches how to implement a Reporting Services solution in an organization

 50027 Querying and Processing SQL Server Data with SQL Statements

 

This course concentrates on providing students with the knowledge and skills necessary to exploit the features and functions available in SQL Server

 6232 Implementing a Microsoft SQL Server 2008 Database

 

This course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database

 Administering Microsoft SQL Server 2012 Databases

 

Administering Microsoft SQL Server 2012 Databases

 Analyzing Data with Power BI, DAX, and Power Query M

 

This course provides a robust and in-depth introduction to Microsoft's Power BI suite of products and gives students a solid understanding of data analysis with Power BI, DAX, and Power Query M

 Analyzing Data with Power BI, DAX, and Power Query M (Canada)

 

This course provides a robust and in-depth introduction to Microsoft's Power BI suite of products and gives students a solid understanding of data analysis with Power BI, DAX, and Power Query M

 Data Center Infrastructure Management

 

Data Center Infrastructure Management

 Designing and Implementing a SQL Server 2008 R2 Database

 

Designing and Implementing a SQL Server 2008 R2 Database

 Developing Microsoft SQL Server 2012 Databases

 

Developing Microsoft SQL Server 2012 Databases

 Implementing a Data Warehouse with Microsoft SQL Server 2012

 

Implementing a Data Warehouse with Microsoft SQL Server 2012

 Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

 

Implementing and Maintaining Microsoft SQL Server 2008 Integration Services

 Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions

 

Implementing and Maintaining SQL Server 2008 Analysis Services and Business Intelligence Solutions

 Implementing Data Models and Reports with Microsoft SQL Server 2012

 

Implementing Data Models and Reports with Microsoft SQL Server 2012

 Maintaining, Troubleshooting, and Developing Solutions with Microsoft SQL Server 2008 Reporting Services

 

Maintaining, Troubleshooting, and Developing Solutions with Microsoft SQL Server 2008 Reporting Services

 MCITP Database Administrator, SQL Server 2008 Boot Camp

 

MCITP Database Administrator, SQL Server 2008 Boot Camp

 Microsoft SQL Server 2014 Administration

 

This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2014 database engine.

 Microsoft SQL Server 2014 Administration (Canada)

 

This class consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2014 database engine.

 Microsoft SQL Server 2016 Administration

 

This five-day instructor-led course provides students who administer and maintain SQL Server 2016 databases with the knowledge and skills to administer a SQL Server database infrastructure.

 Microsoft SQL Server 2016 Administration (Canada)

 

This five-day instructor-led course provides students who administer and maintain SQL Server 2016 databases with the knowledge and skills to administer a SQL Server database infrastructure.

 Microsoft SQL Server 2017 Administration

 

This hands-on course provides students with the knowledge and skills to administer a SQL Server 2017 database infrastructure

 Microsoft SQL Server 2017 Administration (Canada)

 

This hands-on course provides students with the knowledge and skills to administer a SQL Server 2017 database infrastructure

 Microsoft Transact-SQL Programming

 

This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft environment

 Microsoft Transact-SQL Programming (Canada)

 

This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft environment

 Querying Microsoft SQL Server 2012

 

Querying Microsoft SQL Server 2012

 Relational Database Design Concepts

 

This relational database design class develops relational database design skills and techniques

 Relational Database Design Concepts (Canada)

 

This relational database design class develops relational database design skills and techniques

 Relational Database Design: A Practical Approach

 

In this course, students will design and create a relational database.

 SQL Programming

 

This SQL programming course teaches students relational database fundamentals and SQL programming skills

 SQL Programming (Canada)

 

This SQL programming course teaches students relational database fundamentals and SQL programming skills

 SQL Querying - Level 1 Fundamentals of Querying

 

In this course, students learn how to compose SQL queries to retrieve information from the database.

 SQL Querying - Level 2 Advanced Querying

 

In this course, students create advanced SQL queries, and manipulate and index tables.

 SQL Server 2008 R2 for Administration

 

SQL Server 2008 R2 for Administration

 SQL Server 2014 Business Intelligence Application Development (SSRS, SSIS, SSAS)

 

This hands-on course introduces the SQL Server 2014 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS).

 SQL Server 2014 Business Intelligence Application Development (SSRS, SSIS, SSAS) (Canada)

 

This hands-on course introduces the SQL Server 2014 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS).

 SQL Server 2014 Business Intelligence: Integration Services and Analysis Services

 

This hands-on course focuses on the Integration Services (SSIS) and Analysis Services (SSAS) business intelligence tools that are bundled with SQL Server 2014.

 SQL Server 2014 Business Intelligence: Integration Services and Analysis Services (Canada)

 

This hands-on course focuses on the Integration Services (SSIS) and Analysis Services (SSAS) business intelligence tools that are bundled with SQL Server 2014.

 SQL Server 2014 Reporting Services

 

This course introduces Microsoft's SQL Server Reporting Services 2014 (SSRS) utility.

 SQL Server 2014 Reporting Services (Canada)

 

This course introduces Microsoft's SQL Server Reporting Services 2014 (SSRS) utility.

 SQL Server 2016 Business Intelligence Application Development (SSRS, SSIS, SSAS)

 

Three of the five days are reserved for SSRS, with the remaining two days providing an introduction to SSIS and SSAS services.

 SQL Server 2016 Business Intelligence Application Development (SSRS, SSIS, SSAS) (Canada)

 

Three of the five days are reserved for SSRS, with the remaining two days providing an introduction to SSIS and SSAS services.

 SQL Server 2016 Business Intelligence: Integration Services and Analysis Services

 

The focus of this five day course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data warehouses through ETL processing and build Multidimensional and Tabular models to use and reporting data sources.

 SQL Server 2016 Business Intelligence: Integration Services and Analysis Services (Canada)

 

The focus of this five day course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data warehouses through ETL processing and build Multidimensional and Tabular models to use and reporting data sources.

 SQL Server 2016 Reporting Services

 

The three day course includes an overview of the SQL Server business intelligence architecture focusing the role of Reporting services

 SQL Server 2016 Reporting Services (Canada)

 

The three day course includes an overview of the SQL Server business intelligence architecture focusing the role of Reporting services

 SQL Server 2017 Business Intelligence Application Development (SSRS, SSIS, SSAS)

 

This hands-on course introduces the SQL Server 2017 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS). Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs

 SQL Server 2017 Business Intelligence Application Development (SSRS, SSIS, SSAS) (Canada)

 

This hands-on course introduces the SQL Server 2017 Business Intelligence Suite, including Reporting Services (SSRS), Integration Services (SSIS) and Analysis Services (SSAS). Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs

 SQL Server 2017 Business Intelligence: Integration Services and Analysis Services

 

The focus of this course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data warehouses through ETL processing and build Multidimensional and Tabular models to use and reporting data sources.

 SQL Server 2017 Business Intelligence: Integration Services and Analysis Services (Canada)

 

The focus of this course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data warehouses through ETL processing and build Multidimensional and Tabular models to use and reporting data sources.

 SQL Server 2017 Reporting Services

 

This course introduces Microsoft's SQL Server Reporting Services 2017 (SSRS) utility

 SQL Server 2017 Reporting Services (Canada)

 

This course introduces Microsoft's SQL Server Reporting Services 2017 (SSRS) utility

 Writing Queries Using Microsoft SQL Server 2008 Transact-SQL

 

Writing Queries Using Microsoft SQL Server 2008 Transact-SQL