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

Capstone: Photo Tourist Web Application
Johns Hopkins University via Coursera
Introduction to NodeJS
Microsoft via edX
API Development on Google Cloud's Apigee API Platform
Google Cloud via Coursera
Desarrollo de páginas con Angular
Universidad Austral via Coursera
Full Stack Web Developer
Udacity