At DataCraft Solutions, we specialise in empowering professionals with the skills they need to succeed in the world of data. 
Our SQL Part 1: Introduction to SQL Server Query Writing course is designed to kickstart your journey into the realm of SQL, providing a solid foundation in working with Microsoft SQL Server.

Part 2: Doing More with Your Data 1-day workshop

Overview

The purpose of the training is to equip participants with more skills in SQL querying techniques, enabling them to efficiently retrieve and manipulate data from relational databases. The training covers a broad range of topics.

On completing the course attendees will be provided with a set of course reference notes in a pdf format.

What to Expect

Our carefully curated curriculum ensures you’ll walk away with a clear understanding of key SQL concepts and techniques. Throughout the day, you'll gain insights into the core components of SQL Server, explore how to navigate SQL Server Management Studio, and practice writing queries to retrieve and manage data effectively.

Who Should Attend?

The course is designed for delegates who need to extend on the basic concepts of SQL Server query writing.

Delegate Pre-Requisites

Attendees have previously attended the Part 1: Introduction to SQL Server Query Writing, or experience writing queries using the concepts covered in the Part 1 course.

To attend the training, delegates must have access to SQL Server and SQL Server Management Studio (SSMS). We’ll provide the training database script file(s). If you don’t have access, we may organise a virtual machine via a remote desktop connection to ensure a seamless learning experience.

Course Topics

Review Multi-table queries 

• using INNER/OUTER Joins

Writing CROSS join & ‘Self’ join queries. 

Combining queries with SET operators

• UNION, 
• UNION ALL, 
• INTERSECT, 
• EXCEPT

Creating more expressions using Functions

• String Functions
• Maths Functions
• Date Functions
• Conversion Functions

Writing Subqueries

• Subquery overview & rules
• Simple subqueries
• Correlated subqueries

Performing Analysis with Analytic & Window Functions

• OVER Clause
• PARTITION BY clause
• ROW_NUMBER, RANK, DENSE_RANK, LAG, LEAD, FIRST_VALUE and LAST_VALUE functions

Extending the ‘reach’ of your queries using temporary named result sets

• Creating Derived tables
• Creating Common Table Expressions (CTE’s)

SQL Best Practice Tips

These guidelines can help improve the quality and efficiency of SQL code and contribute to the overall success of database projects.

Why Choose DataCraft Solutions?

• Expert-Led Training: Learn from experienced instructors passionate about making complex topics accessible.
• Hands-On Learning: Practice real-world SQL tasks with guidance and feedback from your trainer.
• Beginner-Friendly: No technical background? No problem! We start from the very basics to ensure everyone keeps up.

Cost per person £255.00

We currently do not provide public schedule courses for this workshop.

Please contact us to book a training day for your company if required.