Microsoft SQL Server Training
Microsoft SQL Server is a powerful database platform used to store, manage, query and report on business data. Our SQL training helps delegates understand database structure, write effective queries and work confidently with tables, views, joins, stored procedures and data-driven business systems.
Choose Your SQL Server Course
Click a course below to view the full details
SQL Foundations
Introduction Microsoft SQL Server Course
Duration: 1 Day
Delivery: Face To Face & Live Online
This course provides a practical introduction to SQL Server and relational database management. Delegates learn how databases are structured, how tables connect together, and how SQL can be used to retrieve, organise and manage business information efficiently.
Who Should Attend?
- Database Administrators
- Software Developers
- Data Engineers
- Application and Report Developers
- Staff who need to query, check or report on business data
Course Requirements
No previous experience of Microsoft SQL Server is required. Delegates should have basic computer skills and an interest in working with data, databases or business reporting.
Course Content
- Overview of SQL Server: Understand SQL Server components, terminology and core functionality.
- Designing Databases: Learn how databases are created, managed and configured.
- Creating Tables: Build tables and understand how data is stored in rows and columns.
- Understanding Data Structure: Use primary keys and foreign keys for relational integrity.
- Selecting Data: Write simple queries to retrieve useful information from tables.
- Filtering and Sorting: Use criteria, ordering and conditions to refine query results.
- Creating Views: Simplify access to commonly used data with views.
- Joins: Understand inner joins, outer joins and how related tables work together.
- Triggers: See how automated actions can enhance database functionality.
- Stored Procedures: Understand how stored procedures support repeatable database tasks.
- System Security: Explore connectivity considerations for ODBC, web systems and reporting tools.
- Performance: Learn the importance of efficient queries, indexes and relationships.
Bespoke SQL Training
Custom SQL Server & Database Development Training
Duration: Tailored To Requirements
Delivery: Face To Face & Live Online
Bespoke SQL Server training is ideal when your team needs help with real databases, reports, queries or business systems. The course can be tailored around your company data, existing SQL databases, reporting needs or the exact problems staff face day to day.
This bespoke option can be delivered with support from the Pringle PCS Development Team, who build, support and troubleshoot real business database solutions. This means the training can include practical examples from live development work, database design, query writing, reporting and problem-solving workshops.
Who Should Attend?
- Teams who use SQL Server databases or business systems
- Staff who need to write or understand SQL queries
- Managers who need better reports from company data
- Developers or support staff maintaining internal systems
- Organisations with specific database problems to solve
Course Requirements
Requirements can be agreed before the course. Delegates can bring examples of databases, reports, queries or problems they work with, so the session is practical, focused and directly relevant to their role.
Course Content
- Your Own Data: Work with company-style tables, queries, reports and database examples.
- Query Writing: Build practical SELECT queries, joins, filters and calculations.
- Database Design: Understand table structure, relationships, keys and good database practice.
- Reporting Support: Create queries that support dashboards, management reports and exports.
- Problem Solving: Fix slow, inaccurate or difficult queries using practical troubleshooting methods.
- Stored Procedures: Learn how repeatable database tasks can be packaged and reused.
- Data Quality: Identify duplicates, missing data and inconsistent records.
- Development Team Guidance: Learn practical methods used by the Pringle PCS Development Team.
- Business Systems: Understand how SQL Server links to Access, websites, dashboards and CRM systems.
- Workshop Session: Use real examples to create solutions delegates can apply after the course.
