New to SQL Server? This course is for you. Over three days, you’ll learn how to write SQL queries using T-SQL, Microsoft’s query language. The training covers grouping, aggregations and data modification commands, giving you the tools to query and manage data.
Querying Microsoft SQL Server with Transact-SQL
Master the fundamentals of SQL for data analysis
This beginner-friendly course helps you understand the basics of SQL in Microsoft SQL Server. Designed for those looking to build or enhance their database skills, it provides a comprehensive foundation in writing and managing queries using SQL Server Management Studio (SSMS).
Learning objectives
- Write SELECT queries
- Sort and filter results
- Use GROUP BY and aggregates
- Combine data with UNION
- Work with multiple tables
- Use built-in SQL functions
- Write subqueries
- Insert, update and delete data
- Control transactions
What you’ll learn
With guidance from our experienced trainers, you’ll learn how to query and manage data confidently using Transact-SQL and SQL Server. In our live virtual classroom, you’ll write simple SELECT statements and handle joins, functions, subqueries, and transactions, all using SQL Server Management Studio.
Getting started with SQL Server Management Studio (SSMS)
Gain practical experience using SSMS, Microsoft’s dedicated environment for managing SQL Server databases. From connecting to a database and navigating the interface, to entering, editing and executing queries, you’ll become confident using the platform’s core features. By the end of the course, you’ll be equipped to work efficiently within SSMS.
Combining query results using SET and APPLY operators
Discover how to bring together results from multiple queries using SET operators like UNION, INTERSECT and EXCEPT, ideal for comparing datasets or consolidating outputs. You’ll also be introduced to the APPLY operator, a powerful tool for invoking table-valued functions and enabling more advanced query structures. This session helps you write more flexible and efficient queries by understanding how different datasets can interact.
Querying data across multiple tables
Build efficient multi-table queries that reflect real-world data relationships. Learn how to retrieve data from more than one table using a range of joins, including INNER, OUTER, and CROSS JOINs. These techniques allow you to combine related data and uncover deeper insights from your databases. You’ll also explore how to use table aliases to streamline your code, making queries easier to read and maintain.
Using subqueries for precise data control
Explore how subqueries can add depth and flexibility to your SQL statements. You’ll learn to nest queries within other queries to isolate specific results, use correlated subqueries that respond dynamically to outer query values, and apply the EXISTS predicate to test for the presence of data. These techniques allow for more targeted and efficient data retrieval, giving you greater control when working with complex datasets.
What’s included
- 3 days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
- Course completion certificate
Key facts
Ideal for
Ideal for those looking to build practical SQL skills for querying and managing data in Microsoft SQL Server, whether you're an analyst, developer or IT support.
Prerequisites
There are no formal prerequisites for this course, though a basic understanding of databases and general IT concepts would be helpful.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
This expert-led course offers an introduction to querying Microsoft SQL Server using Transact-SQL. Gain experience writing queries, working with multiple tables, using built-in functions and handling data operations.
What’s the difference between INNER, OUTER and CROSS JOINs in SQL?
INNER JOIN returns only the rows with matching values in both tables, OUTER JOIN includes unmatched rows from one or both tables, and CROSS JOIN combines every row from one table with every row in another.
How can I combine multiple queries in SQL Server?
You can combine query results using SET operators like UNION, INTERSECT, and EXCEPT, each offering a different way to merge or compare data. This course guides you through these techniques, introducing real use cases and showing how the APPLY operator can take your query skills further.
What are SQL aggregate functions and how are they used?
Aggregate functions, such as COUNT, SUM and AVG, summarise data across rows to deliver key insights like totals or averages. Our trainers will teach you how to apply these functions with GROUP BY and HAVING clauses to analyse data effectively and support decision making.
Is this course a suitable first step for more advanced SQL training?
This course builds a strong foundation in SQL and T-SQL, covering the core skills you need before moving on to more advanced querying or SQL programming courses. It’s the ideal starting point if you plan to deepen your SQL Server expertise.
What our customers say
"This is now my second course with John at StayAhead and once again the delivery was simply excellent. Best fun I've had at work for a while now and would very highly recommend the course to anyone who's taking on more PL/SQL work in their job. Hoping to come back for more in the future!"
Ashley, AppOps Engineer (Jr DBA) - Government
‘Really informative course, structured to support all forms of learning and at a good pace.’
Owen, Graduate Trainee Engineer - Utilities
Why study with StayAhead
96% customer satisfaction
We combine experience and passion to deliver training that meets the highest standards
30+ years’ experience
Industry-leading specialists delivering high-impact IT training
Experiential instructor-led training
Courses are delivered by experienced instructors using hands-on, practical live labs