|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/azure-sql-for-beginners-sqlt-sql-ssms-azure-data-studio/
课程评论：没有评论
课程名称：初学者的Azure SQL：SQL、T-SQL、SSMS、Azure数据工作室 课程概述：Azure SQL是一个管理、受保护和智能的产品系列，运用SQL Server数据库引擎在Azure云中运行。Azure SQL数据库支持现代云应用，是一种智能的管理数据库服务，提供无服务器计算能力。Azure SQL托管实例旨在以几乎100%功能对等的方式，使现有SQL Server应用程序在规模上现代化，最适合大多数云迁移。Azure虚拟机上的SQL Server允许轻松迁移SQL Server工作负载，并保持100%的SQL Server兼容性及操作系统级别的访问权限。 Azure SQL基于熟悉的SQL Server引擎，帮助用户轻松迁移应用程序并持续使用熟悉的工具、语言和资源。许多组织面临老旧或设计不佳的数据平台策略。近期，向云迁移现有系统、快速构建新应用的趋势显著增加，并降低了一些本地成本。您需要制定计划，以便将某些工作负载迁移到云中，并了解如何为您的组织设置成功的框架。同时还需理解数据库管理员（DBA）或数据专业人员的角色如何保持不变，以及需要做出哪些调整。 本模块将带您简要回顾Microsoft为何以及如何构建Azure SQL的历史。您将了解不同的部署选项和服务层，包括如何为您的组织选择合适的服务，以及何时使用这些选项，这些选项包括Azure SQL数据库、Azure SQL托管实例和Azure虚拟机中的SQL Server。了解平台即服务（PaaS）的概念及其与传统SQL Server环境的对比，将帮助您理解迁移到云时所获得的与未获得的内容。
Azure SQL is a family of managed, secure, and intelligent products that use the SQL Server database engine in the Azure cloud.Azure SQL Database: Support modern cloud applications on an intelligent, managed database service, that includes serverless compute.Azure SQL Managed Instance: Modernize your existing SQL Server applications at scale with an intelligent fully managed instance as a service, with almost 100% feature parity with the SQL Server database engine. Best for most migrations to the cloud.SQL Server on Azure VMs: Lift-and-shift your SQL Server workloads with ease and maintain 100% SQL Server compatibility and operating system-level access.Azure SQL is built upon the familiar SQL Server engine, so you can migrate applications with ease and continue to use the tools, languages, and resources you're familiar with. Your skills and experience transfer to the cloud, so you can do even more with what you already have.Many organizations have an aging or under-engineered data platform strategy. There's been a significant trend of moving existing systems to the cloud, building newapplications quickly by using the cloud, and offloading some on-premises costs. You need a plan for how to move some workloads to the cloud. And you need to understand how to set up your organization for success. You also need to understand how the role of a database administrator (DBA)or data professional stays the same, and what changes you'll have to make. In this module, you'll start with a brief history of why and how Microsoft built Azure SQL. You'll then learn about the various deployment options and service tiers, including what to use for your organization, and when.. These options include Azure SQL Database, Azure SQL Managed Instance, and SQL Server in an Azure virtual machine. Understanding what platform as a service (PaaS) encompasses and how it compares to a traditional SQL Server environment will help you understand what you do and don't get when you move to the cloud.
