Data Lineage relates to the visibility of where data has originated from and what may have been done to that data to transform it on its journey from an original source to a final destination.

Our in-house team of full-time consultants are all based in the UK, with our offices and training centre based in Wokingham, just outside Reading. The vast majority of our delivery work takes place remotely, taking full advantage of cloud based technologies to provide the most flexible service possible. We do also love to get out and meet people in person though, and are very happy to join you onsite at your own premises as requirements suit.

Our in-house team of full-time consultants are all based in the UK, with our offices and training centre based in Wokingham, just outside Reading. The vast majority of our delivery work takes place remotely, taking full advantage of cloud based technologies to provide the most flexible service possible. We do also love to get out and meet people in person though, and are very happy to join you onsite at your own premises as requirements suit.

Wherever works for you! We can come to a venue of your choice, or we'd love to welcome you to our training centre in Wokingham, just outside Reading. Alternatively, all of our courses can be delivered remotely via Teams, Zoom, etc. and make use of our virtual classroom environment. Talk to our team to discuss what would be the best delivery option for you.

Wherever works for you! We can come to a venue of your choice, or we'd love to welcome you to our training centre in Wokingham, just outside Reading. Alternatively, all of our courses can be delivered remotely via Teams, Zoom, etc. and make use of our virtual classroom environment. Talk to our team to discuss what would be the best delivery option for you.

Typically, our closed courses are suited for groups of up to 8. If you have larger groups than this, please give us a call to discuss your requirements and the best options for you.

Joining instructions are typically sent out to each course attendee 2 weeks prior to the course start date, or immediately if booking within this time.

Our virtual classroom provides delegates with access to a browser based virtual lab environment through which our instructors can interact with and provide support for all course participants. The classroom also provides access to guided learning materials, shared whiteboards, and code snippets that may be worked on throughout the class, and students are able to take away their work files from the course for further study after the course ends.

Our virtual classroom provides delegates with access to a browser based virtual lab environment through which our instructors can interact with and provide support for all course participants. The classroom also provides access to guided learning materials, shared whiteboards, and code snippets that may be worked on throughout the class, and students are able to take away their work files from the course for further study after the course ends.

Microsoft Data Platform, BI, AI & Data Science Certifications

Prepare for the Future: SQL Server Certification Updates and Training

The traditional SQL Server Development and Administration exams and certifications are being retired at the end of January (31/01/2021). A full list of all certifications and exams recently retired or scheduled to retire can be found here.

Although from February 2021 there will be no exams associated with curriculum areas such as SQL Database Querying and TSQL Programming they are very much pre-requisites for many of the new tracks. SQL remains a vital language for data extraction from operational relational databases and data warehouses.

Certification Paths

The PTR Training portfolio offers a full range of SQL and TSQL training courses to help you prepare for an Azure Data journey.

Certification	Certification Type	Exams Needed	Certification Technologies/Topics
Microsoft Certified: Azure Data Fundamentals	Fundamentals	DP-900	Azure core data concepts, Working with relational and non-relational data on Azure, Analytics workloads on Azure. Target Job Roles: Anyone wishing to learn about database concepts in an Azure environment
Microsoft Certified: Azure AI Fundamentals	Fundamentals	AI-900	AI Workloads & considerations, Principles of ML on Azure, Computer Vision workloads on Azure, Natural Language Processing (NLP) on Azure, Conversational AI workloads on Azure Target Job Roles: Anyone interested in learning about Azure AI and services.
Microsoft Certified: Azure Fundamentals	Fundamentals	AZ-900	Cloud concepts, Core Azure Services, Core Azure Solutions & Management Tools, security & Network Features, Identity, Governance, Privacy & Compliance Features, Azure Cost Management & SLAs Target Job Roles: Anyone wishing to learn more about Microsoft Azure
Microsoft Certified: Azure Administrator Associate	Role-based	AZ-104	Azure AD, Azure Storage, Azure Compute Resource, Virtual Networking, Monitoring & Backup Target Job Roles: Azure Administrators
Microsoft Certified: Azure Database Administrator Associate	Role-based	DP-300	Data Platform Resources, AD Authentication & Security, Monitoring Activity & Performance, Query Optimization, Task Automation, HA/DR, Admin with TSQL Target Job Roles: Experienced DBAs, data architects, application developers.
Microsoft Certified: Azure Data Engineer Associate	Role-based	DP-200 DP-201	Azure storage, Data Factory, Data Bricks, Data Lake, Synapse Analytics Target Job Roles: Data Engineers
Microsoft Certified: Azure Developer Associate	Role-based	AZ-204	Azure compute solutions, Azure storage, Azure security, monitoring, troubleshooting and optimizing azure solutions, connecting to and consuming Azure services & 3rd party services. Target Job Roles: Azure Developers
Microsoft Certified: Azure Data Scientist Associate	Role-based	DP-100	Azure Machine Learning workspace, running experiments and training models, Optimising & managing models, Deploying & consuming models. Target Job Roles: Data Scientists
Microsoft Certified: Data Analyst Associate	Role-based	DA-100	Preparing Data, Modelling Data, Visualising Data, Analysing Data, Deploying & Maintaining deliverables. Target Job Roles: Data Analysts
Microsoft Certified: Azure AI Engineer Associate	Role-based	AI-100	Analyse solution requirements, Design AI solutions, Implement & Monitor AI solutions. Target Job Roles: Azure AI Engineer, Software Engineer
Microsoft Certified: Azure Solutions Architect Expert	Role-based	AZ-303 AZ-304	Implement & Monitor Azure Infrastructure, Implement Management & Security Solutions, Implement solutions for Apps, Implement & Manage Data Platforms. Design for Cost Optimisation, Design Monitoring, Design Identity & security, Design Data Storage, Design Business Continuity, Design Infrastructure. Target Job Roles: Solution Architects
Microsoft Certified: Microsoft Power Platform App Maker Associate	Role-based	PL-100	Design Power Platform Solutions, Create Power Platform Solutions, Analyse & visualise data, Implement & manage solutions. Target Job Roles: Anyone wishing to build solutions to simplify, automate, and transform tasks and processes for themselves and their team where they have deep expertise in the solution business domain.
Microsoft Certified: Power Platform Developer Associate	Role-based	PL-400	Create a technical design, Configure Common Data Service, Create & configure Power Apps, Configure business process automation, Extend the user experience, Extend the platform, Develop integrations. Target Job Roles: Power Platform Developers
Microsoft Certified: Power Platform Functional Consultant Associate	Role-based	PL-200	Configure Common Data Service, Create apps using Power Apps, Create & Manage Power Automate, Implement Power Virtual Agents chatbots, Integrate Power Apps with other apps and services. Target Job Roles: Power Platform Design & Implementation Consultants

You can see the full view of available certifications in this Microsoft poster.

Microsoft Data Platform, BI, AI & Data Science Certifications Consultancy Services

Choosing a Microsoft Certification Track Around Data

Prepare for the Future: SQL Server Certification Updates and Training

Certification Paths

Frequently Asked Questions

Microsoft Data Platform, BI, AI & Data Science Certifications Consultancy Services

Choosing a Microsoft Certification Track Around Data

Prepare for the Future: SQL Server Certification Updates and Training

Certification Paths

Frequently Asked Questions

What is Data Lineage?

Where are your consultants based?

Where will my course be run?

How many people can attend a closed course?

When will I receive joining instructions

How does the virtual classroom work?