SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Mastering T-SQL Querying Fundamentals
Description
T-SQL was named the most popular programming language in 2013. If you work with SQL Server in any capacity, as a developer, DBA, BI specialist, analyst, power user, you need to know your T-SQL. The thing is, this language is deceptive. When you start learning it you quickly get to write queries with filters, sorting, grouping, joining, and so on. You might get a false sense of confidence and the wrong impression that the language is easy to master.
In reality, most get to learn T-SQL without understanding the fundamentals correctly, and this incorrect understanding can lead to using the language incorrectly. Often people assume things about the language that are not guaranteed, and end up with bugs in their code. This seminar is dedicated to correct understanding of T-SQL querying fundamentals.
You will learn about the principal elements in the foundations of the language. You will learn about logical query processing—what I find to be the most critical aspect of T-SQL that any T-SQL practitioner should master. Then the seminar covers fundamentals of query constructs like joins, subqueries, table expressions (derived tables, CTEs, views, table valued functions), the APPLY operator, and set operators.
If time will permit, the seminar will also cover the fundamentals of more specialized query constructs like PIVOT, UNPIVOT, grouping sets and window functions. Know your T-SQL querying fundamentals well, and then tackling advanced problems will be so much easier.
In reality, most get to learn T-SQL without understanding the fundamentals correctly, and this incorrect understanding can lead to using the language incorrectly. Often people assume things about the language that are not guaranteed, and end up with bugs in their code. This seminar is dedicated to correct understanding of T-SQL querying fundamentals.
You will learn about the principal elements in the foundations of the language. You will learn about logical query processing—what I find to be the most critical aspect of T-SQL that any T-SQL practitioner should master. Then the seminar covers fundamentals of query constructs like joins, subqueries, table expressions (derived tables, CTEs, views, table valued functions), the APPLY operator, and set operators.
If time will permit, the seminar will also cover the fundamentals of more specialized query constructs like PIVOT, UNPIVOT, grouping sets and window functions. Know your T-SQL querying fundamentals well, and then tackling advanced problems will be so much easier.
Learning Objectives
Previous Experience
Tech Covered
BI