|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/design-and-query-a-relational-database-in-azure-sql-database/
课程评论：没有评论
课程名称：在 Azure SQL 数据库中设计和查询关系数据库 课程概述：本课程旨在帮助学习者了解 Azure 云平台及其多种服务，特别是 Azure SQL 数据库。Azure 是微软提供的云计算平台，最初称为 Windows Azure，后更名为 Microsoft Azure。它提供了丰富的服务，包括虚拟机、存储服务、软件开发与部署服务、网络服务、数据分析、人工智能、机器学习和物联网等。 在本课程中，您将学习如何使用 Azure 门户、T-SQL 和 SQL Server Management Studio (SSMS) 来创建和管理关系数据库。课程内容涵盖以下几个方面： - 使用 Azure 门户创建数据库 - 设置服务器级 IP 防火墙规则 - 使用 SSMS 连接数据库 - 使用 SSMS 创建数据表 - 绘制表关系的数据库图 - 通过 BCP 批量加载数据 - 使用 SSMS 查询数据 Azure SQL 数据库作为一种数据库即服务（DBaaS），允许用户定义计算和存储资源，数据库在 Azure 资源组中创建并通过逻辑 SQL 服务器进行管理。Azure SQL 数据库还在服务器级别创建 IP 防火墙，以防止未经授权的外部应用程序和工具连接到服务器和数据库。 此课程适合希望提升在 Azure SQL 环境中数据库设计和查询能力的个人，无论其行业背景如何。通过这个课程，您可以掌握在云环境中构建和管理关系数据库所需的关键技能。
The Azure cloud platform is more than 200 products and cloud services designed to help you bring new solutions to life - to solve today's challenges and create the future. Build, run and manage applications across multiple clouds, on-premises and at the edge, with the tools and frameworks of your choice.Cloud is everywhere. It has completely changed the way businesses think about IT resources and software solutions. Organizations of every type, size, and industry are using the cloud for a wide variety of use cases. Even individuals like you and me are using cloud and cloud services on a daily basis.Azure is a cloud computing platform from Microsoft. Initially it was called Windows Azure. Later renamed to Microsoft Azure. It is an ever expanding set of services to help you build solutions to meet your business goals. It offers a wide variety of services. For example, we haveVirtual machines running in the cloud for you to host and run your software.Storage services to store all sorts of data - relational, non-relational etc.Software development and deployment services.Networking and Data analysis services.Artificial Intelligence, Machine learning, Internet of Things etc. The list goes on.Azure SQL Database is a relational database-as-a-service (DBaaS) in the Microsoft Cloud (Azure).In this course, you learn how to use the Azure portal,T-SQL and SQL Server Management Studio (SSMS) to:Create a database using the Azure portal*Set up a server-level IP firewall rule using the Azure portalConnect to the database with SSMSCreate tables with SSMSCreate database diagram with table relationshipsBulk load data with BCPQuery data with SSMSA database in Azure SQL Database is created with a defined set of compute and storage resources. The database is created within an Azure resource group and is managed using an logical SQL server.Azure SQL Database creates an IP firewall at the server-level. This firewall prevents external applications and tools from connecting to the server and any databases on the server unless a firewall rule allows their IP through the firewall. Azure SQL Database communicates over port 1433. If you are trying to connect to this service from within a corporate network, outbound traffic over port 1433 may not be allowed by your network's firewall. If so, you cannot connect to your database unless your administrator opens port 1433.
