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
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.
Tuesday 14 March, 2023 at 9:00 am (GMT)
Theme:
Developer
Session Level:
Beginner
Required Experience:
Basic development experience
Technologies covered:
Azure SQL Database, SQL 2019 & SQL 2022