Introduction to SQL Databases

Course is aimed at people looking to move into a database professional role or whose job role is expanding to encompass databse elements. The course describes fundamental database concepts including databse types, database languages, and database design.

Length (Days)

3

Price

$

1745

Provisioning SQL Databases

This course provides students with the knowledge & skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on premise and in Azure, and covers installing from new and migrating from an existing install.

Length (Days)

3

Price

$

1750

Implementing a SQL Data Warehouse

Students will learn how to create a data warehouse with Microsoft® SQL Server® 2016 and with Azure SQL Data Warehouse, to implement ETL with SQL Server Integration Services, and to validate and cleanse data with SQL Server Data Quality Services.

Length (Days)

5

Price

$

2795

Querying Microsoft SQL Server

Learn the technical skills 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.

Length (Days)

5

Price

$

2795

Administering Microsoft SQL Server Databases

The course focuses on teaching individuals how to use SQL Server 2014 product features and tools related to maintaining a database.

Length (Days)

5

Price

$

2795

Implementing a Data Warehouse with MS SQL Server

Learn how to create a data warehouse with MS SQL Server 2014, implement ETL with SQL Server Integration Services, & validate & cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.

Length (Days)

5

Price

$

2795

Developing Microsoft SQL Server Databases

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

Length (Days)

5

Price

$

2795

Implementing Data Models and Reports with Microsoft® SQL Server

This course 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.

Length (Days)

5

Price

$

2795

Designing Self-Service Business Intelligence and Big Data Solutions

Participants learn how to design and implement a BI infrastructure. The course covers design, installation, and maintenance of a BI platform.

Length (Days)

5

Price

$

2795

Developing SQL Data Models

This course is aimed at database professionals who fulfil a Business Intelligence (BI) developer role. Students will learn to implement multidimensional databases by using SQL Server Analysis Services (SSAS), and at creating tabular semantic data models.

Length (Days)

3

Price

$

1750

Analyzing Big Data with Microsoft R

The main purpose of the course is to give students the ability to use Microsoft R Server to create and run an analysis on a large dataset, and show how to utilize it in Big Data environments, such as a Hadoop or Spark cluster, or a SQL Server database.

Length (Days)

3

Price

$

1750

Analyzing Data with Power BI

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App.

Length (Days)

3

Price

$

1750

Designing a Data Solution with Microsoft SQL Server

The focus of this course is on planning and implementing enterprise database infrastructure solutions by using SQL Server 2014 and other Microsoft technologies

Length (Days)

3

Price

$

1750

Writing Reports with Report Builder and SSRS Level 1

In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS.

Length (Days)

2

Price

$

1175

Microsoft SQL Server Report Builder 3.0 Level 2

In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.

Length (Days)

2

Price

$

1175

Writing Reports with Report Designer and SSRS 2016 Level 2

In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Designer and SSRS. The focus will be on report creation by connecting to a database and manipulating the data for presentation including: creating parameter reports, creating list reports, adding complex expressions to reports, adding images and subreports to reports, adding drilldown and drillthrough functionality, and adding sparklines, data bars, and indicators to reports. Report Designer is available for all supported versions of Microsoft® SQL Server®.

Length (Days)

2

Price

$

1175

Writing Reports with Report Designer and SSRS 2014 Level 1

The focus will be on report writing by connecting to a database and manipulating the data for presentation including: creating table and matrix reports, formatting reports, grouping report data, creating simple and complex expressions.

Length (Days)

2

Price

$

1175

Writing Analytical Queries for Business Intelligence

This course is about writing TSQL queries for the purpose of database reporting, analysis, and business intelligence.

Length (Days)

3

Price

$

1750

Designing Business Intelligence Solutions with MS SQL Server 2014

This course teaches students how to implement self-service Business Intelligence (BI) and Big Data analysis solutions using the Microsoft data platform.

Length (Days)

5

Price

$

2795

Upgrading Your Skills to SQL Server 2016

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

Length (Days)

3

Price

$

1750

Performance Tuning and Optimizing SQL Databases

This four day course provides participants who manage and maintain SQL Server databases with the knowledge and skills to performance tune and optimize their datbases.

Length (Days)

4

Price

$

2350

Managing SQL Business Intelligence Operations

This course looks at various options that provide the ability of business users to analyze and share their findings, starting with managed BI data sources and expanding to personal and external/public data sources

Length (Days)

3

Price

$

1750

Analyzing Data with SQL Server Reporting Services

This course teaches students how to implement a SQL Server 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.

Length (Days)

5

Price

$

2795

Querying Data with Transact SQL

The main purpose of this course is to give students a good understanding of the Transact-SQL language which is used by all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.

Length (Days)

5

Price

$

2795

Developing SQL Databases

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

Length (Days)

5

Price

$

2795

Administering a SQL Database Infrastructure

This course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure.

Length (Days)

5

Price

$

2795

WCT LOGO 2019.png

Have a Question?

Call Us: 406.542.1573

Email Us:: Click Here

© 2019 WATERCOLORCT

Website by Yaz Designs