YoVDO

Choose Azure SQL Database and Learn What Every Developer Should Know

Offered By: Microsoft via YouTube

Tags

Microsoft Azure Courses SQL Courses Database Security Courses High Availability Courses API Development Courses Azure SQL Database Courses SQL Injection Prevention Courses

Course Description

Overview

Dive into a comprehensive conference talk from Visual Studio Live! that equips developers with essential knowledge for leveraging Azure SQL Database. Explore the foundations of Azure SQL, including family types, tiers, and SKUs, along with programming language support. Learn best practices for building secure applications, implementing passwordless connectivity, and preventing SQL injection attacks. Discover scalability techniques, smart SQL programming, and connection string optimization. Gain insights into query processing, cost-based optimization, and Intelligent Query Processing. Understand the differences between columnstore and rowstore indexes, as well as clustered and non-clustered indexes. Explore multi-model support for JSON, Graph, and Geospatial data. Master retry logic implementation using various tools and libraries. Address concerns about managing large-scale databases with billions of rows. Benefit from additional resources, book recommendations, and a Q&A session to enhance your Azure SQL Database expertise.

Syllabus

- Start.
- Agenda.
- Foundations - Azure SQL family, Azure SQL DB tiers, Azure SQL DB SKUs, programming languages support.
- Security - Building a secure application, going passwordless, avoiding SQL injection, getting proactive secuirity monitoring via Microsoft Defender.
- Scalability - Building a scalable application, smart SQL programming, scaling-out the database, connection strings best practices.
- Query processor, cost-based optimization, DAG and executing plans, Intelligent Query Processing.
- Indexes - Columnstore and Rowstore indexes, Clustered and Non-clustered index.
- Mult-Model support - JSON, Graph, Geospatial.
- Retry Logic - Microsoft.Data.SqlClient, Polly.NET, Tenacity.
- Is Azure SQL database a good choice if I have 100 Billions rows to manage?.
- Session Summary.
- Additional resources and books.
- Questions and Answers.


Taught by

Microsoft Developer

Tags

Related Courses

Optimizing Microsoft Windows Server Storage
Microsoft via edX
High Availability and Disaster Recovery with the SAP HANA Platform
SAP Learning
Microsoft Exchange Server 2016 - 3: Mailbox Databases
Microsoft via edX
Microsoft SharePoint 2016: Workload Optimization
Microsoft via edX
Microsoft Azure Virtual Machines
Microsoft via edX