Classroom
2 days1100,-
excl. VAT
- Pleasant venue with a good trainer
- Small groups
- Inspiring and motivating
You work with data in Microsoft SQL Server and want to be able to write your own queries. In this course you will learn the building blocks of T-SQL: from simple SELECT statements to joins, groupings and subqueries.
Description
Microsoft SQL Server is one of the most widely used database systems for database management, development and business intelligence. Transact-SQL is the SQL variant that Microsoft has added to it, with extra options for logical blocks and programming constructs.
You start with the basics: how a relational database works, what primary and foreign keys are, and how to retrieve data with SELECT. You then build up step by step to filtering, sorting, calculating and combining data from several tables.
The course is practice-oriented. You work extensively in Microsoft SQL Server Management Studio and practise with realistic datasets. Theory and practice alternate continuously, so you apply what you have learned straight away.
Topics
Day 1: SQL basics and simple queries
- Basic principles: databases, data types, primary key and foreign key
- Introduction to Microsoft SQL Server and Management Studio
- Retrieving data with SELECT, FROM, TOP and DISTINCT
- Sorting with ORDER BY
- Filtering with WHERE, comparison operators and BETWEEN
- Advanced filtering with AND, OR, IN and NOT
- Working with wildcards (LIKE)
- Calculations and concatenation
Day 2: Advanced queries and T-SQL
- Functions: ROUND, LTRIM, RTRIM, DATEPART
- Summarising with COUNT, SUM, AVG, MAX and MIN
- Grouping with GROUP BY and HAVING
- Subqueries with IN
- Combining tables with INNER JOIN, LEFT OUTER JOIN and RIGHT OUTER JOIN
- Table aliases and advanced joins
- Combining queries with UNION
- Adding, modifying and deleting data (INSERT, UPDATE, DELETE)
- Managing tables with CREATE, ALTER and DROP
- The added value of T-SQL over standard SQL
Result
After this course you understand how Microsoft SQL Server works and you know the difference between SQL and T-SQL. You independently write queries to retrieve, filter, sort and combine data from several tables. You apply functions and groupings to summarise data, and you can add, change and delete records. This allows you to get more value out of the data in your organisation.
Target audience
This course is intended for beginning users of Microsoft SQL Server who want to get started with T-SQL. Think of beginning database administrators and database managers, BI professionals, data analysts, report builders and software developers who want to be able to write their own queries.
Teaching method
You work in a small group under the guidance of an experienced database trainer. Theory alternates with demos and plenty of practical exercises in Microsoft SQL Server Management Studio. You are welcome to bring in examples from your own working practice. Before the course you will receive a course book with exercises, which you can also use afterwards as a reference work. The software and the course material are in English.
Prior knowledge
No specific prior knowledge is required. An affinity with data and logical thinking is useful, however.
Comments
Would you prefer a platform-independent SQL basics course? Then take our SQL Basics course.
Looking for a basic SQL course aimed specifically at Oracle? Then register for the SQL Basics Oracle course.
Language
The training is given in Dutch as standard. The trainer has a good command of English. English-language course material can be used. With a minimum enrolment of 3 participants, the training can also be given entirely in English.
