Managing Data in Azure SQL Database
Learn all about Azure SQL Database and prepare for the AZ-103 Exam with our study material.
What you will learn
Introduction/Overview of SQL Database.
Comparing SQL Azure Database to Azure / On-Premise SQL Server.
Creating and Using SQL Server and SQL Database Services.
About Azure SQL Database Tools
Migrating on premise database to SQL Azure
Planning the Deployment of an Azure SQL Database Elastic Pools.
Monitoring Azure SQL Database
Configure SQL Database Auditing
Manage Business Continuity
Export and Import of Database
Export and Import of Database
Active GEO-Replication
Long Term Backup Retention
Description
In this course, "Managing Data in Azure SQL Database", you will learn-
Introduction/Overview of SQL Database.
Comparing SQL Azure Database to Azure / On-Premise SQL Server.
Creating and Using SQL Server and SQL Database Services.
Azure SQL Database Tools.
Migrating on premise database to SQL Azure.
Planning the Deployment of an Azure SQL Database Elastic Pools.
Monitoring Azure SQL Database
Configure SQL Database Auditing
Manage Business Continuity
Export and Import of Database
Backup and Recovery options in SQL Database
Active GEO-Replication
Long Term Backup Retention
• SQL Database is a cloud-based relational database service that is built on SQL Server technologies. It supports T-SQL commands, tables, indexes, views, primary keys, stored procedures, triggers, roles, functions etc.
• SQL Database delivers predictable performance, scalability with no downtime, business continuity and data protection—all with near-zero administration. You can focus on rapid app development and accelerating your time to market, rather than managing virtual machines and infrastructure.
• Because it’s based on the SQL Server engine, SQL Database supports existing SQL Server tools, libraries and APIs, which makes it easier for you to move and extend to the cloud.
• SQL databases is available in Basic, Standard, and Premium service tiers. Each service tier offers different levels of performance and capabilities to support lightweight to heavyweight database workloads. You can build your first app on a small database for a few bucks a month, then change the service tier manually or programmatically at any time as your app goes viral worldwide, without downtime to your app or your customers.