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.
Database Administration
Azure SQL and SQL Server for Developers - Immersion Workshop
Description
A full day packed content to learn everything you need to be a great developer with great Azure SQL knowledge and T-SQL skills. And knowing SQL, as the whole IT industry now recognizes, is really a developer
's super-power. So don't miss this chance to learn anything one the best database for developers in the cloud. After defining some foundational concepts around database architecture and introducing security key points, we'll start from the basic concepts of tables and their design best practices. Then we'll move to indexes to understand why and how they are vital in improving performance. We'll then move to query plans, transactions and everything related to consistency *and* scalability. Functions, stored procedures, and views will also then be discussed, closing with some additional best practices, "lesson learned" and overviews of some more advanced features that can make a developer the hero of the day.
's super-power. So don't miss this chance to learn anything one the best database for developers in the cloud. After defining some foundational concepts around database architecture and introducing security key points, we'll start from the basic concepts of tables and their design best practices. Then we'll move to indexes to understand why and how they are vital in improving performance. We'll then move to query plans, transactions and everything related to consistency *and* scalability. Functions, stored procedures, and views will also then be discussed, closing with some additional best practices, "lesson learned" and overviews of some more advanced features that can make a developer the hero of the day.
Learning Objectives
Understand how Azure SQL and SQL Server can be use correctly and efficiently; best practices around logical and physical modeling; multi-model features; best practices around security, connectivity, resiliency; understand how to measure and improve performances
Previous Experience
Basic development experience
Tech Covered
Azure, security, SQL 2019, Azure SQL Database, Database Administration, Developing, Monitoring, Modelling, Optimising, SQL 2022, Architecture & Infrastructure, Developer