|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-bootcamp-zero-to-hero-using-microsoft-sql-server/
课程评论：没有评论
课程名称：SQL Bootcamp: 从零到英雄使用Microsoft SQL SERVER 课程概述：在本课程中，您将学习以下主题：从初学者到专业人士的SQL语法。了解T-SQL（Transact SQL）。在Windows 10上安装SQL Server 2019。在Windows 10上安装SQL Server Management Studio。创建Oracle VirtualBox中的虚拟机，在虚拟机上安装Windows Server 2019上的SQL Server 2019。学习创建数据库，创建关系表并向表中插入记录。掌握所有类型的SQL连接（内连接、左连接、右外连接、全外连接、合并连接、Self-Join、交叉连接）。使用Union、Union All、IN运算符、Between运算符、Exists运算符、Not Exists运算符、Like运算符和子查询分析数据。学习所有类型的SQL约束（主键约束、外键约束、非空约束、默认约束、唯一约束、检查约束），理解复合主键。掌握所有类型的聚合函数。使用Coalesce、NullIF、Case语句、Group By和Having子句进行数据分析。学习和实现数据操作语言（DML）语句（插入、更新和删除）。学习和实现数据定义语言（DDL）（创建、修改、删除、截断）。学习和实现数据控制语言（DCL）（授权、撤销）。掌握事务控制语言（TCL）（提交、回滚、保存点）。学习创建复杂的存储过程并修改存储过程。学习和实现不同类型的触发器（DDL触发器，DML触发器）。了解本地和全局临时表。学习公共表表达式（CTE），理解排名函数（Row Number、Rank和Dense Rank）。 此课程适合希望深入了解SQL和数据库管理的人，无论是初学者还是有一定基础的开发人员。通过本课程，您将获得实用的技能，能够胜任SQL相关的工作。
In this course you will learn fowling topics:Learn SQL syntax from a beginner to a pro level.Learn about T-SQL (Transact SQL).Install SQL Server 2019 on Windows 10.Install SQL Server Management Studio on Windows 10.Create a Virtual Machine in Oracle VirtualBoxInstall SQL Server 2019 on Windows Server 2019 (Virtual Machine).Learn to create databases.Learn to create relational tables and insert records into tables.Learn all types of SQL Joins (Inner Join, Left Join, Right Outer Join, Full Outer Join, Merge Join, Self-Join, Cross Join)Analyze data using Union, Union All, IN Operator, Between Operator, Exists Operator, Not Exists Operator, Like Operator, Between Operator, and Sub QueryLearn all types of SQL constraints (Primary Key constraint, Foreign Key constraint, Not Null Constraint, Default Constraint, Unique Constraint, Check Constraint)Understand the Composite Primary KeyLearn all types of aggregate functions.Analyzing data using Coalesce, NullIF, Case Statement, Group By, and Having ClauseLearn the DML Statement (Insert, Update, and Delete).Learn and Implement the Data Definition Languages (Create, Alter, Drop, Truncate)Learning and Implementing Data Control Language (DCL) (Grant, Revoke)Learn Transaction Control Language (TCL) (Commit, Rollback, Savepoint)Learn to create complex store procedures and alter store procedures.Learn and implement different types of triggers (DDL Trigger, DML Trigger).Learn about both local and global temporary tables.Learn Common Table Expression (CTE)Understanding the Ranking Functions (Row Number, Rank, and Dense Rank)
