Managing Data in Azure SQL Database

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.