|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/querying-microsoft-sql-server-the-essentials-skills/
课程评论：没有评论
课程名称：实用T-SQL：300+测验；165个动手实用练习 概述：本课程是我第一版SQL Server查询课程的第二版，全面进行了改革，基于SQL Server 2016和2019版本。本课程针对已经在行业中工作的专业人士，教授编写应用程序所需的SQL语句。如果您是准备进入竞争激烈的职场的学生，本课程将为您提供成功所需的优势。我们教您如何编写高效运行的SQL脚本，并展示如何利用SQL Server提供的最有用的高级功能。本课程涵盖了以下主题： - 快速入门 - 了解关系数据库和SQL的基本概念和术语 - 如何使用管理工作室（Management Studio）与SQL Server数据库进行交互 - 探索常见的数据操作语言（DML）和数据定义语言（DDL） - 学习如何将数据设计为第三范式 - 掌握日常使用的SQL - 编写 SQL 语句以检索和更新数据库中的数据 - 使用内连接和外连接、汇总查询和子查询 - 编写复杂的存储过程和函数，包括必需和可选参数及返回值 - 编写触发器（INSERT, UPDATE, DELETE, INSTEAD OF）以处理所有场景，包括数据和参照完整性 - 学习使用代码片段提供创建对象（存储过程、表、函数、触发器等）的模板 - 学会创建数据库及其表，使用SQL语句或管理工作室 - 学习DML编程，包括所有操作查询 - 通过创新的自定义用户定义界面进行互动动手练习，在该界面中执行所有SQL脚本，无需使用SSMS，便捷的在问题和解决方案之间切换 本课程为您提供独特的学习体验，帮助您掌握SQL Server的高效使用。
This is the second edition and a complete overhaul of my first SQL Server Querying course based on SQL Server 2016 and 2019. This course shows you how to code the SQL statements that you need for your application if you are already in the industry. If you are a student preparing to enter a competitive world, this course will give you the advantage you need to succeed. We teach you how to code SQL scripts so they run efficiently. The course shows you how to take advantage of the most useful advanced features that SQL Server has to offer. This SQL Server course is based on SQL Server 2016 and 2019. In this course we teach you all that you need to use SQL Server effectively and to write good SQL scripts. We cover the following topics:Get started fastThe concepts and terms you need for working with relational database and SQLHow to use the Management Studio to work with a SQL Server databaseExplore the common Data Manipulation Language (DML) and Data Definition Language (DDL)Learn to design your data to the 3rd Normal FormMaster the SQL that you will use everydayHow to write SQL statements that retrieve and update data in a databaseHow to work with inner and outer joins, summary queries, and subqueries...it's all here for youWrite sophisticated stored procedures and functions with required and optional parameters with return values to calling programsWrite Triggers (INSERT, UPDATE, DELETE, INSTREAD OF) to handle all scenarios including data and referential integrityLearn to use snippets to provide templates for creating objects (stored procs, tables, functions, triggers etc.)...and moreLearn how to create databasesLearn to create a database and its tables using SQL statements or the Management Studio...valuable skills, whether you are on the DBA track or notLearn to code the Data Manipulation Language (DML)including all the action queries.Interactive, hands-on exercises controlled by a (innovative) custom user-defined interface. Execute all your SQL scripts within custom interface (no SSMS). Move between problem and solution at the click of a button. Experience a unique learning experience
