|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/database-design-for-beginners-microsoft-sql-server-ssms/
课程评论：没有评论
课程名称：初学者的数据库设计：Microsoft SQL Server SSMS 课程概述：数据库设计是根据数据库模型对数据进行组织的过程。设计师需要确定需要存储的数据以及数据元素之间的关系。掌握这些信息后，他们便可以将数据适应于数据库模型。数据库管理系统会相应地管理这些数据。正确设计的数据库能够为用户提供最新、准确的信息。因此，学习良好设计原则所需的时间是值得的，因为正确的设计是实现数据库使用目标的关键。最终，你更可能拥有一个满足需求并且易于变更的数据库。 在课程中，学员将学习如何决定所需信息、如何将信息划分为适当的表和列，以及这些表之间的关系。建议在开始设计之前，先将数据库的目的书面化，明确其用途、预期使用方式以及用户。如果是一个小型家庭企业的数据库，例如，可以简单写道：“客户数据库用于保持客户信息的列表，以便生成邮件和报告。”而在更复杂或多人使用的企业环境中，目的说明可能更为详细，包括每个人使用数据库的时间和方式。拥有一个明确的使命陈述将有助于在设计过程中聚焦目标。 Microsoft SQL Server 是由微软开发的一种关系型数据库管理系统。作为数据库服务器，它的主要功能是根据其他软件应用程序的请求存储和检索数据，这些应用程序可以在同一台计算机上运行，也可以通过网络在另一台计算机上运行。 SQL Server Management Studio 是与 Microsoft SQL Server 2005 一同推出的软件应用程序，用于配置、管理和管理 Microsoft SQL Server 内的所有组件。
Database design is the organization of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model. Database management system manages the data accordingly.A properly designed database provides you with access to up-to-date, accurate information. Because a correct design is essential to achieving your goals in working with a database, investing the time required to learn the principles of good design makes sense. In the end, you are much more likely to end up with a database that meets your needs and can easily accommodate change.You will learn how to decide what information you need, how to divide that information into the appropriate tables and columns, and how those tables relate to each other.It is a good idea to write down the purpose of the database on paper - its purpose, how you expect to use it, and who will use it. For a small database for a home based business, for example, you might write something simple like "The customer database keeps a list of customer information for the purpose of producing mailings and reports." If the database is more complex or is used by many people, as often occurs in a corporate setting, the purpose could easily be a paragraph or more and should include when and how each person will use the database. The idea is to have a well developed mission statement that can be referred to throughout the design process. Having such a statement helps you focus on your goals when you make decisions.Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications-which may run either on the same computer or on another computer across a network.SQL Server Management Studio is a software application first launched with Microsoft SQL Server 2005 that is used for configuring, managing, and administering all components within Microsoft SQL Server.
