SQL Server Training Course Portfolio
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