|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/microsoft-sql-for-database-creation/
课程评论：没有评论
课程名称：微软SQL数据库创建 课程概述：本课程旨在提升您对微软Transact SQL的基础知识，学习创建数据库所需的关键SQL语句。尽管您可以通过SQL Server管理工作室手动创建完整数据库，但熟悉数据库创建的SQL命令对于准备担任数据库管理员、数据库工程师或微软Web开发人员的角色至关重要。课程假设您已经掌握SQL的基本知识，但我们会从一些关键的SQL CRUD语法（创建、读取、更新和删除）开始复习。 本课程将解释SQL Server中创建三种类型数据库关系（多对一、一对一和多对多）的机制和SQL语法，以及主键和外键约束的使用。您将学习如何使用SQL创建数据库模式，如何在模式内创建表格，如何在不同模式之间移动表格，以及使用模式的安全性好处。此外，我们将深入探讨不同数据类型的数据库列创建，以及以正确格式插入数据的SQL技术。您还将学习创建数据库约束的SQL语法，以增强数据的完整性。同时，本课程将展示如何使用SQL语句创建聚集索引和非聚集索引，以提高数据库的性能。 因此，如果您需要一个Transact SQL课程来提升您的基础知识，这将是您所寻找的课程。
This course will enable you to enhance your basic knowledge of Microsoft Transact SQL by learning the key SQL statements involved in the creation of databases.Although you can create a complete database manually, using the SQL Server Management Studio interface, knowing the SQL commands for database creation is essential if you are preparing yourself for a role as a database administrator, a database engineer or Microsoft web developer. This course assumes that you know the basics of SQL; but we do begin with a revision of some key SQL CRUD syntax: Create, Read, Update and Delete. The course will explain the mechanics of, and SQL syntax for, the creation of the three types of database relationship used in SQL Server: one-to-many, one-to-one and many-to-many; and the use of primary and foreign key constraints. You will learn how to use SQL to create database schemas; how to create tables within a schema; move tables between schemas; and the security benefits of using schemas. We also take an in-depth look at the creation of database columns of different data types; and the SQL techniques for inserting data in the correct format. You will also learn the SQL syntax for creating database constraints to enhance the integrity of your data. And the course will also show you how to use SQL statements to create clustered and non-clustered indexes, to improve the performance of your databases. So, if you need a Transact SQL course to take your basic knowledge to the next level, this could be just the course you are looking for.
