Microsoft SQL Queries Course
Course code:
Course length:
Training language:
16 lessons
English
Course fee:
319 EUR + VAT
Microsoft SQL Queries Course - Dates and application
First training day: 20 July 2026, Further training days: 21.
Weekday daytime (09.00 - 16.30 CET)
Application deadline:
10 July 2026
Training language:
English
Course fee:
319 EUR + VAT
First training day: 14 September 2026, Further training days: 15.
Weekday daytime (09.00 - 16.30 CET)
Application deadline:
4 September 2026
Training language:
English
Course fee:
319 EUR + VAT
First training day: 30 November 2026, Further training days: 1 December
Weekday daytime (09.00 - 16.30 CET)
Application deadline:
20 November 2026
Training language:
English
Course fee:
319 EUR + VAT
Applying for closed-group training
If you and your colleagues are attending a closed group training course and you have a training date code, you can apply here.
Application without a date
If none of the dates is right for you, but you are interested in the course, please submit your application without a date. When we publish a new date you will be notified.
In this course, students will learn the basics of writing Microsoft T-SQL queries.
No previous knowledge is required.
Writing SQL queries is no longer required only for software developers, and is increasingly expected in the fields of analysis, design, testing or reporting. In this course, students will first learn the basics of the SQL language, and how to write queries.
In addition to the standard SQL statements, they will be able to use these stand-alone query languages effectively with specific knowledge of Microsoft Transact SQL.
Throughout the course, there will be a strong emphasis on practical knowledge, so students will learn about the most commonly used tools for SQL databases.
Course Outline:
1. SQL LANGUAGE AND RELATIONAL DATABASE MANAGERS
1.1. SQL standards
1.2. Data models
1.3. Relational database managers
1.4. Table
1.5. Field
1.6. Relationships between tables
1.7. Set theory
1.8. NULL value
2. BASICS OF MICROSOFT DATABASE SERVER
2.1. Microsoft SQL Server versions and variants
2.2. Copies on one machine
2.3. Referring to SQL Server
2.4. SQL Server databases
2.5. Authentication
2.6. Relationship between login, user and schema
2.7. Referring to objects
2.8. Course example database
3. TOOLS FOR MICROSOFT SQL SERVER
3.1. SQL Server Management Studio
3.2. Command line tool (osql, sqlcmd)
4. SIMPLE SQL QUERIES
4.1. Basics of SQL syntax
4.2. Database selection (USE)
4.3. SELECT statement
4.4. WHERE condition
4.5. Operators (LIKE, BETWEEN, IN, IS NULL)
4.6. ORDER BY - Sorting
4.7. GROUP BY - Grouping
4.8. Aggregation functions (SUM, COUNT, MIN, MAX, AVG)
4.9. HAVING condition
4.10. DISTINCT - Ensuring uniqueness
4.11. Limiting the number of lines retrieved (TOP, OFFSET, FETCH NEXT)
4.12. CASE expression
5. BUILT-IN FUNCTIONS
5.1. Numeric functions
5.2. Text-handling functions
5.3. Date and time functions
5.4. Conversion functions
5.5. NULL functions
6. COMPLEX QUERIES
6.1. UNION and UNION ALL
6.2. INTERSECT
6.3. EXCEPT
6.4. Nested queries (EXISTS, IN, ALL, SOME, ANY)
6.5. Linking tables
6.6. INNER JOIN
6.7. CROSS JOIN
6.8. OUTER JOIN
6.9. Self JOIN
Trainers
He obtained a diploma from the Juhász Gyula Teacher Training College of the University of Szeged as a computer science teacher. He is an official Microsoft trainer and system engineer in the field of network infrastructure. His expertise includes the introduction, design, and operation of Active Directory, Exchange, and SQL Server. As a project manager, he gained experience primarily in the introduction of Microsoft collaborative...
He graduated from the Budapest University of Technology and Economics with a degree in software technologies and telecommunications, but began his computer science studies at the Neumann János Vocational School and Grammar School. Even then, he demonstrated his abilities with excellent placements in national academic competitions in programming. He completed postgraduate studies in banking informatics engineering at BME and...
He graduated from the Faculty of Informatics at Eötvös Loránd University in program design mathematics. He started his teaching career during his university years when he taught programming skills to lower-level students as a delegated practice leader. He then worked as a software developer, participating in the implementation of domestic and foreign software. Over the years, he has mastered several programming languages at a high...
He graduated as a computer scientist specializing in robotics and image processing at Budapest University of Technology and Economics. He has been working as a software developer since 2004 and as a programming instructor in higher education since 2005. In the field of adult education, he has been providing corporate professional training courses in programming topics since 2012. His main areas of competence are Design Patterns, C#...
Do you have any questions about the training?
The instructor was able to convey the necessary knowledge to the maximum, and his examples from his professional experience made the course more colorful, which contributed to maintaining our attention until the end. I will recommend it to my acquaintances for exam preparation!
Zsolt Mogyorósi
Varian Medical Systems Hungary Kft