|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/how-to-download-and-restore-databases-in-sql-server/
课程评论：没有评论
课程总结：如何下载和恢复 SQL Server 数据库 本课程旨在讲解 SQL Server 数据库的下载和恢复方法。SQL Server 是由微软开发和推广的关系数据库管理系统（RDBMS），其基本构建在 SQL 语言之上，并使用微软的 T-SQL 进行扩展。课程将介绍 SQL Server 的四种主要版本，包括免费的开发者版和表达版，适用于不同场景的数据库管理需求。此外，课程还将涉及如何利用微软提供的样本数据库（如 AdventureWorks 和 AdventureWorksDW）来进行测试和学习。 通过本课程，您将学习如何使用 SQL Server Management Studio（SSMS）来恢复数据库。这将为您的数据库开发、测试或学习提供重要的实践技能。
SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft. Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with relational databases. SQL Server is tied to Transact-SQL, or T-SQL, the Microsoft's implementation of SQL that adds a set of proprietary programming constructs.SQL Server has four primary editions that have different bundled services and tools. Two editions are available free of charge:SQL Server Developer edition for use in database development and testing.SQL Server Expression for small databases with the size of up to 10 GB of disk storage capacity.For larger and more critical applications, SQL Server offers the Enterprise edition that includes all SQL Server's features.SQL Server Standard Edition has partial feature sets of the Enterprise Edition and limits on the Server regarding the numbers of processor core and memory that can be configured.Sometimes, we need a sample database that has all the required objects along with a large set of data inside the database for our various testing needs or our learning purpose. Microsoft has developed several sample databases for each type of workloads like the AdventureWorks database for OLTP workload and the AdventureWorksDW database for data warehouse workloads.You will learn how to restore databases into SQL Server using SQL Server Management Studio -SSMS
