Querying Microsoft SQL Server with Transact-SQL - 3 days Online Classroom
1.950,00 EUR
- 3 days
Build a strong foundation in Microsoft SQL Server and Transact-SQL (T-SQL) with this hands-on, instructor-led course. Learn how to write effective queries, retrieve and manipulate data, work with multiple tables, and apply built-in SQL functions to solve real business challenges. Through practical exercises in SQL Server Management Studio (SSMS), you'll gain the confidence to query, manage, and maintain SQL Server databases for reporting, application development, and data analysis.
Key Features
Language
Course and materials are in English
Level
Beginner - Intermediate level
3 days (8 hours / day) live classroom
with accredited trainers
40+ 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:
Build
Build a solid understanding of relational database concepts, including tables, indexes, primary and foreign keys, and constraints. Learn how these components work together to organise data, maintain integrity, and improve database performance.
Organize
Master the SELECT statement to retrieve and organise data efficiently. You'll use ORDER BY, column aliases, and expressions to create clear, accurate, and easy-to-maintain SQL queries.
Summarize
Learn to summarize data using GROUP BY and aggregate functions such as COUNT, SUM, and AVG. You'll also use the HAVING clause to filter grouped results and generate meaningful business insights.
Enhance
Enhance your queries with SQL Server's built-in numeric, string, and date functions. Apply CASE expressions and NULL handling techniques to transform, format, and present data more effectively.
Course timeline
Day 1: SQL Fundamentals and Querying
Lesson 01
- Understand relational database concepts, schemas, tables, keys, indexes, and data types.
- Navigate and execute queries using SQL Server Management Studio (SSMS).
- Write SELECT queries with filtering, sorting, and column aliases.
- Apply DISTINCT, logical operators, TOP, and OFFSET-FETCH.
- Combine query results using UNION, INTERSECT, EXCEPT, and APPLY.
- Summarise data with aggregate functions, GROUP BY, ROLLUP, and HAVING.
Day 2: Working with Multiple Tables and Functions
Lesson 02
- Retrieve data using INNER, OUTER, CROSS, and SELF joins.
- Simplify complex queries with table aliases.
- Use built-in numeric and character functions.
- Work with SQL Server date and time data types.
- Format dates, extract date components, and perform date calculations.
- Apply SQL functions to clean, transform, and present data effectively.
Day 3: Advanced Queries and Data Management
Lesson 03
- Convert between data types and handle NULL values.
- Apply CASE expressions for conditional logic.
- Create standalone and correlated subqueries using EXISTS.
- Insert, update, merge, and delete database records.
- Remove data efficiently with TRUNCATE.
- Manage transactions to maintain data integrity and consistency.
Who Should Enroll in this Program?
SQL developers and aspiring database developers
Data analysts and business intelligence professionals
Software developers working with Microsoft SQL Server
Database administrators (DBAs) seeking stronger T-SQL skills
Business analysts who need to retrieve and analyse business data
IT professionals and beginners looking to build practical SQL querying skills
Prerequisites
There are no formal prerequisites for this course, making it suitable for beginners. However, a basic understanding of databases, tables, and common database terminology will help you get the most from the training. Familiarity with Windows applications is also recommended
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.