What Is Microsoft SQL Server?

SQL Server is Microsoft's server based Relational Database Management System (RDBMS) providing a robust, reliable  and scalable solution for live OLTP business applications data and historic OLAP reporting and analysis systems.

The PTR SQL Server Training Course Portfolio

Our portfolio of SQL Server training courses caters for all job roles within the data management, development, and data analysis business intelligence areas of interest.

Start with designing and creating relational databases and learning the basics of the Structured Query Language (SQL) to enable data to be added and maintained, and information to be retrieved with the core SELECT statement. From there you could progress to a Database Administrator (DBA) training track, a SQL Developer track or a Business Intelligence track.

SQL Server Developers

SQL developers need to develop skills in SQL and Transact SQL (TSQL).

Generic Relational Database Design

(SQL) Creating Databases in SQL Server

(SQL) SQL Server Database Querying

(SQL) Advanced SQL Server Database Querying

(TSQL) SQL Server Transact SQL Programming

SQL Server BI Specialists

Business Intelligence specialists will need to add to their basic SQL and TSQL skills with tools and platforms such as SQL Server Reporting, Integration and Analysis services (SSRS, SSIS, SSAS) - learning how to carry out ETL tasks, build cubes, slice, dice and mine, build KPIs and dashboards, and deliver simple and complex reports.

Introduction to SQL Server Business Intelligence

(SSRS) SQL Server Reporting Services

(SSIS) SQL Server Integration Services

(SSAS) SQL Server Analysis Services

Introduction to SQL Server MDX

(SSAS) SQL Server Analysis Services Tabular Model

(BI) Designing a Data Warehouse

SQL Server Database Administrators (DBAs)

DBAs will need to extend their database querying skills with administrative tasks and then on to monitoring, troubleshooting and tuning SQL Server instances.

SQL Server Essential Administration

SQL Server Performance & Tuning

SQL Server Audit & Security

If you have specific needs that cross over multiple courses we are very happy to tailor content to your requirement so if you cannot see what you want her do give us a call on 0118 979 4000 or email us at info@ptr.co.uk.