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.
A to Z Azure Cosmos DB
Description
Azure Cosmos DB is battle tested non-relational database service by Microsoft. It is used by many mission critical applications, including Xbox, Office 365, Azure and Skype.
This workshop will help you take a more in-depth look at Azure Cosmos DB's architecture, features and tools. We will start with an overview of Azure Cosmos DB's infrastructure and architecture, then explore its main features and benefits. Additionally, we will use Cosmos DB Emulator for development purposes. In addition, we will look at the Data Migration tool to import and transform data as well as cover stored procedures, available SDKs, and Rest API of Cosmos DB. For the closing of this session we will configure Change Feed functionality using Azure Functions.
Contents:
- History, Infrastructure and Architecture of Cosmos DB
- What does Multi-Model mean?
- Understanding Consistency Levels
- Why Partitioning is crucial?
- Managing Indexes in Cosmos DB.
- Cosmos DB Constraints
- Pricing
- Using Cosmos DB Emulator
- Querying Cosmos DB with SQL API
- Setting up TTL
- Data Type Problems of JSON
- Creating Stored Procedures
- How to Import&Transform Data
- Available SDKs and Rest API
- Spatial Data in Cosmos DB
- Configuring Change Feed
- Using Vs Code extension with Cosmos DB
- Connecting to Cosmos DB From Sql Server 2019
Learning Objectives
Previous Experience
Tech Covered
Cloud, Azure, Cosmos DB, SQL 2019, NoSQL, Data transformation and integration, Move to the cloud, CosmosDB, PolyBase, Developing