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.
Big Data & Data Engineering
Developer Dive into Azure Cosmos DB
Description
This full day workshop will ramp you up quickly on Azure Cosmos DB, Microsoft’s globally distributed, massively scalable, low (single-digit millisecond) latency, fully managed NoSQL database service designed specifically for modern web and mobile applications. Like other NoSQL platforms, Cosmos DB supports a schema-free data model, built-in partitioning for sustained heavy-write ingestion, and replication for high availability. But only Cosmos DB offers turnkey global distribution, automatic indexing, and SLAs for guarantees on 99.999% availability, throughput, latency, and consistency.
For many newcomers to Cosmos DB, the learning process starts with data modeling and partitioning. How should you structure your model? When should you combine multiple entity types in a single container? Should you de-normalize your entities? What’s the best partition key for your data? So we start off with the key strategies for modeling and partitioning data effectively in Cosmos DB. Using a real-world NoSQL example based on the AdventureWorks relational database, we explore key Cosmos DB concepts—request units (RUs), partitioning, and data modeling—and how their understanding guides the path to an optimal data model that yields the best performance and scalability.
Throughout the day, we tour the many features of Cosmos DB, including its multi-model capabilities which allow you to store and query schema-free JSON documents (using either SQL or MongoDB APIs), graphs (Gremlin API), and key/value entities (table API), and columnar (Cassandra API). You’ll learn about global distribution, multi-region conflict resolution, scale-out partitioning, tunable consistency, and custom indexing. Plus we’ll cover security, including V-Net with Private Link, authentication and authorization, and client-side encryption.
You’ll also learn client development, starting with the .NET SDK as we build a Cosmos DB application from scratch in C#. You’ll also learn how to how to query Cosmos DB using SQL, how to write data access code that creates and queries databases, containers, and documents. We’ll also create, deploy, and execute server-side transactional stored procedures, triggers, and user-defined functions, using the Cosmos DB JavaScript server-side programming model, and build event-driven microservices using the Azure Cosmos DB Change Feed. Attend this workshop, and get ready for Cosmos DB!
For many newcomers to Cosmos DB, the learning process starts with data modeling and partitioning. How should you structure your model? When should you combine multiple entity types in a single container? Should you de-normalize your entities? What’s the best partition key for your data? So we start off with the key strategies for modeling and partitioning data effectively in Cosmos DB. Using a real-world NoSQL example based on the AdventureWorks relational database, we explore key Cosmos DB concepts—request units (RUs), partitioning, and data modeling—and how their understanding guides the path to an optimal data model that yields the best performance and scalability.
Throughout the day, we tour the many features of Cosmos DB, including its multi-model capabilities which allow you to store and query schema-free JSON documents (using either SQL or MongoDB APIs), graphs (Gremlin API), and key/value entities (table API), and columnar (Cassandra API). You’ll learn about global distribution, multi-region conflict resolution, scale-out partitioning, tunable consistency, and custom indexing. Plus we’ll cover security, including V-Net with Private Link, authentication and authorization, and client-side encryption.
You’ll also learn client development, starting with the .NET SDK as we build a Cosmos DB application from scratch in C#. You’ll also learn how to how to query Cosmos DB using SQL, how to write data access code that creates and queries databases, containers, and documents. We’ll also create, deploy, and execute server-side transactional stored procedures, triggers, and user-defined functions, using the Cosmos DB JavaScript server-side programming model, and build event-driven microservices using the Azure Cosmos DB Change Feed. Attend this workshop, and get ready for Cosmos DB!
Learning Objectives
This training day will provide a comprehensive introduction and overview, combined with a deeper technical treatment of database architecture and design with Azure Cosmos DB.
Previous Experience
Although a strong understanding of relational databases is expected, no prior knowledge of Cosmos DB is required.
Tech Covered
Azure, security, Cosmos DB, Functions, Developing, Managing, Modelling, Big Data & Data Engineering, Developer, NoSQL/NewSQL