Microsoft SQL Server with Transact-SQL - 5 days Online Classroom
3.450,00 EUR
- 5 days
Build the practical SQL Server skills needed to work confidently with Microsoft databases. This hands-on course takes you from essential Transact-SQL (T-SQL) concepts to advanced querying techniques, enabling you to retrieve, transform, and manage data efficiently. Through live instructor-led training and practical labs using SQL Server Management Studio (SSMS), you'll learn how to write powerful queries, optimise performance, work with multiple tables, and create scalable database solutions for real-world business environments
Key Features
Language
Course and materials are in English
Level
Beginner - Intermediate level
5 days (8 hours / day) live classroom
with accredited trainers
60+ recommended study hours
Exercises and solutions
Downloadable PDF documents with detailed content (slides, explanations)
Certificate
Certificate of completion available
Learning Outcomes
At the end of this course, you will be able to:
Organize
Learn how to retrieve, filter, and organise data using core SQL statements. You'll use SELECT, WHERE, ORDER BY, DISTINCT, and OFFSET-FETCH to produce accurate, well-structured results for reporting, analysis, and everyday database tasks.
Combine
Develop the skills to combine related data using INNER, OUTER, CROSS, and SELF joins. You'll also use table aliases to create clearer, more maintainable queries for working with complex relational databases.
Enhance
Enhance your SQL queries with subqueries and conditional expressions. You'll use standalone and correlated subqueries alongside CASE statements to filter data, apply business logic, and generate more dynamic query results.
Build
Master advanced SQL features including views, Common Table Expressions (CTEs), derived tables, pivoting, and window functions. These techniques enable you to build efficient queries, perform sophisticated data analysis, and create powerful business reports.
Course timeline
Day 1: SQL Fundamentals and Querying
Lesson 01
- Understand database concepts, schemas, tables, keys, indexes, and data types.
- Navigate and use SQL Server Management Studio (SSMS).
- Write, filter, sort, and customise SELECT queries.
- Combine query results using UNION, INTERSECT, EXCEPT, and APPLY.
- Summarise data with aggregate functions and GROUP BY.
- Filter grouped results using HAVING and advanced grouping techniques.
Day 2: Working with Data and Functions
Lesson 02
- Query multiple tables using INNER, OUTER, CROSS, and SELF joins.
- Simplify complex queries with table aliases.
- Apply numeric and mathematical SQL functions.
- Manipulate text using character functions.
- Format and calculate dates and times.
- Perform date arithmetic and extract date components.
Day 3: Data Manipulation and Subqueries
Lesson 03
- Convert data types and work with NULL values.
- Use CASE expressions for conditional logic.
- Create standalone and correlated subqueries.
- Query efficiently using the EXISTS predicate.
- Insert, update, merge, and delete database records.
- Manage transactions and maintain data integrity.
Day 4: Advanced SQL Techniques
Lesson 04
- Create views, derived tables, CTEs, and table-valued functions.
- Use advanced grouping with GROUPING SETS, ROLLUP, and CUBE.
- Transform data with PIVOT and UNPIVOT.
- Analyse data using window aggregate functions.
- Apply ranking functions for ordered results.
- Use window offset functions for advanced reporting.
Day 5: Database Objects and Performance
Lesson 05
- Create, modify, and manage tables, constraints, and temporary tables.
- Work with sequences, synonyms, and database metadata.
- Create and optimise indexes for faster queries.
- Understand filtered, included, and indexed views.
- Explore metadata using INFORMATION_SCHEMA and sys views.
- Analyse and optimise SQL query performance.
Who Should Enroll in this Program?
Database Administrators (DBAs)
SQL Developers and Database Developers
Data Analysts and Business Intelligence professionals
Software Developers working with SQL Server
Business Analysts who need to query and analyse data
IT professionals looking to strengthen their Microsoft SQL Server and T-SQL skills
Prerequisites
- A basic understanding of relational database concepts
- Familiarity with tables, rows, and columns
- Some experience using SQL or another database platform is helpful but not essential
- General computer literacy and basic Windows skills
Licensing
and equality policy
Licensing and accreditation
This course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
AVCdoes not provide accommodations due to a disability or medical condition of any students. Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Questions
Need a Custom In-company or Group Training?
Request for in-company training program tailored specifically to your team. We offer flexible customization options to align with your business goals, alongside competitive group rates for larger teams. Fill out the form below, and our corporate training experts will design the perfect solution for you.