|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/online-t-sql-developer-video-training/
课程评论：没有评论
**课程名称：** Beginning T-SQL for SQL Server Developer, Data Analyst & DBA **课程简介：** 本课程专为完全没有SQL知识背景的学习者设计，提供从零开始、循序渐进的Transact-SQL（T-SQL）实操训练。课程内容涵盖Microsoft SQL Server数据库引擎的基础知识和T-SQL查询的实际应用，是Microsoft SQL Server数据库开发人员、数据库管理员、Web开发人员（如.NET开发人员）、数据库分析师、报表开发人员（如SSRS）、ETL开发人员（如SSIS）等所有相关领域从业者的必备课程。 **课程主要内容：** * **T-SQL基础：** 介绍关系型数据库、关系型数据库管理系统（RDBMS）、SQL Server和SQL Server Management Studio（SSMS）、SQL Server及SSMS的安装。 * **数据库表与数据操作：** 创建数据库表、插入数据、主键与外键的概念。 * **SELECT查询：** 基本SELECT命令、聚合函数、GROUP BY子句（单列和多列）、WHERE与HAVING子句的区别、SELECT命令语法。 * **T-SQL JOIN操作：** INNER JOIN、LEFT JOIN、RIGHT JOIN、FULL JOIN、CROSS JOIN、SELF JOIN，以及JOIN与GROUP BY的结合应用。 * **集合操作：** UNION、UNION ALL、INTERSECT、EXCEPT操作。 * **Schema管理：** Schema的定义、重要性、创建、转移以及在Schema内查看对象。 * **子查询：** 子查询入门、常见的子查询应用场景（JOIN、GROUP BY、派生表、列）、子查询作为列、NOT EXISTS、ALL、ANY、SOME关键字、相关子查询及其在优化查询性能方面的应用。 * **数据类型与转换：** 数据类型详解、数据类型隐式及显式转换（类型转换）。 * **DML操作与约束：** INSERT、UPDATE、DELETE操作的多种方式，以及Primary Key、Foreign Key、Unique、Not NULL、Default、Check等约束的设置。 * **多表连接：** 连接两个、三个、四个表及更多表的实例。 * **CASE语句与内置函数：** 使用CASE语句执行SELECT和UPDATE操作，以及EOMONTH、IIF、CHOOSE、DatePart、字符串函数等常用内置函数的应用。
This course starts from the beginning , no prior knowledge is needed and it is step By step Practical Training on Programming Transact SQL Query from basics on Microsoft SQL Server Database EngineThis course is must for all the Aspirants who want to become Microsoft SQL Server Database Developers , Microsoft Database Administrator, Web Developers such as.NET Developers,Database ANALYSTS , Report Developers such as SSRS or ETL Developers such as SSIS etcFollowing are the course contents which are covered in this course T-SQL Online SQL Server Video Step By Step TrainingIntroductionWhat is a Relational DatabaseWhat is Relational Database Management SystemSSMS and SQL Server Database EngineSQL Server and SSMS InstallationBasic T-SQLCreating DB Tables & Inserting Data into the tablesPrimary Key and Foreign KeyBasic Select CommandsAggregate Functions with SELECT CommandGroup By Clause using Single and Multiple ColumnsDifference Between WHERE and HAVING ClauseSyntax of SELECT CommandT-SQL Joins to query SQL ServerInner JoinT-SQL with Inner Join and Group By TogetherLeft JoinRight JoinFull JoinCross JoinSelf-JoinUnion OperationUnion All OperationIntersect OperationExcept OperationWorking with SchemaWhat is Schema and its ImportanceSchema Creation & Transfer and Viewing the objects inside Schema using T-SQLSubqueriesGetting Started with first Subquery ExampleCommon Interview Question on SubqueryJoins Group by Derived table Subquery combined TSQLSubquery as a ColumnSubquery using NOT ExistsALL ANY SOME Keywords in SubqueryCorrelated SubqueryNot Exists Keyword Scenario of Correlated Subquery to speed up query performanceDatatypesDatatype ConversionImplicit & Explicit Conversion (Type Casting)DML Operations and ConstraintsMany Different Options while performing insert update and delete operationsPrimary Key, Foreign Key, Unique, Not NULL, Default, Check ConstraintsJoining more than two tablesJoining three tablesJoining four TablesOne more example in joining four tablesWorking with CASE Statements and Inbuilt FunctionsPerforming Select and Update operation using case statementWHILE LoopInbuilt Functions - EOMONTH, IIF, CHOOSE, DatePart, String Functions etc.
