|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/complete-sql/
课程评论：没有评论
课程名称：完整的SQL与关系数据库管理系统 课程概述：在这门课程中，您将学习关系数据库管理系统（RDBMS）及结构化查询语言（SQL）。您将掌握以下内容： - 关系数据库基础知识 - 信息与数据模型 - 关系的类型 - 实体到表的映射 - 高级关系模型约束 - 主键和外键的概念 - 实体及其属性 - 数据定义语言（DDL）与数据操作语言（DML） - SQL语句的类型 - 如何开始数据库工作：安装和设置Microsoft SQL Server Management Studio - 如何使用CREATE TABLE命令在Microsoft SQL Server中创建表 - 如何使用INSERT INTO语句向表中插入数据 - 如何使用SELECT语句从表中检索数据 课程还包括高级DDL和DML语句的使用，如在SELECT语句中使用字符串模式、值范围和集合；使用ORDER BY语句排序数据；使用GROUP BY子句分组数据；以及使用GROUP BY HAVING子句进行筛选。 此外，您将学习如何处理多个表，包括不同表的使用、理解主键与外键的作用，以及各种连接的不同类型： - 内连接 - 左外连接 - 右外连接 - 全外连接 所有这些主题将结合理论概念与动手实践进行学习。完成课程后，您将能够理解RDBMS概念，学会在Microsoft SQL Server Studio中执行不同的SQL语句，并与任何数据库工具进行工作。
In this course, you will learn about Relational Database Management systems and Structured Query Language (SQL)You will learn about the Relational Database Management system:Introduction to Relational DatabasesInformation and Data ModelsTypes of RelationshipsMapping Entities to tablesAdvanced relational model constraintsWhat is Primary KeyWhat is Foreign keyWhat is Entity, Attributes´Data Definition Language(DDL) & Data Manipulation Language (DML)Types of SQL statementsWhat is DDL (Data Definition Language)What is DML (Data Manipulation Language)How to get started with Database - install and set up Microsoft SQL Server Management studioHow to create a table in a Microsoft SQL server with CREATE TABLE commandHow to insert data in a table in a Microsoft SQL server with INSERT INTO statementHow to retrieve data from a table with a SELECT statementAdvanced DDL & DML statements: How to use string pattern, range of values and set in the SELECT statementhow to sort data with ORDER BY statementhow to group by data with GROUP BY clausehow to use GROUP BY HAVING clause Working with multiple tablesHow to use different tablesunderstand the use of Primary key and foreign keyunderstand Different types of Joins:Inner JoinsLeft Outer JoinRight Outer joinFull outer joinAll these topics you will learn with theoretical concepts along with hands-on practices. By end of the course, you gain:Understand RDBMS conceptslearn to execute different SQL statements in Microsoft SQL server studiolearn to work with any database tool.
