|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-voor-beginners-4-uur-durende-cursus/
课程评论：没有评论
课程名称：SQL Server voor Dummies（7小时实践） 课程概述：本课程使用英语授课，同时提供荷兰语字幕。如果您对SQL Server一无所知并希望开始学习这项技术，那么这门课程正适合您！您将学习如何用Transact SQL编写您的第一条查询。课程涵盖以下内容：在工作站上安装SQL Server和管理工作室；创建和定义数据库；表格的创建和定义；数据的选择、更新、删除和插入（SELECT、INSERT、UPDATE、DELETE）；使用别名列以及LIKE的特性；TOP的用途；使用DISTINCT去除重复项；比较操作符的使用（=!=等）；通过SELECT INTO复制表格；理解IN、NOT IN、IS和IS NOT操作符，并使用ORDER BY进行数据排序；聚合函数的使用（MIN、MAX、AVG）以及AND、OR两个操作符；了解COUNT和SUM的特定特点，以及如何使用BETWEEN选择数据范围；使用GROUP BY对不同结果进行分组，并了解HAVING和PRINT的特性；使用INNER JOIN、LEFT/RIGHT JOIN和FULL OUTER JOIN进行合并；深入探讨Transact SQL中的CHOOSE、IIF、CASE WHEN、SUBSTRING、OFFSET FETCH NEXT ROWS等内容；了解CHOOSE、TRIM/LTRIM/RTIM和COALESCE函数；实验UNION和UNION ALL，LEFT和RIGHT函数；通过CAST和CONVERT、TRY_CAST和TRY_CONVERT，及TRY_PARSE和PARSE进行数据转换；创建和定义视图；创建和定义存储过程。该课程包含7小时的演示和30分钟的理论，理论部分将在课堂上进行，而非课程中。课程设置了50多个问题，帮助巩固学习。学习SQL技术的意义在于，SQL是当前职场上最受欢迎的技能之一，管理SQL服务器和在TSQL中进行查询是一项全职工作。此外，SQL Server的简单性使您迅速掌握特定主题成为可能。课程结束时，您将对SQL语言感到更加自信。为了避免无聊，课程视频时长不超过10分钟。
This course is in English, but the subtitles are in Dutch. Don't know anything about SQL Server and want to get started with this technology? Would you like to learn how to write your very first queries in Transact SQL? Then this course is for you! In this course we will cover these different chapters:Install SQL Server and management studio on your workstation.Creating and Defining a DatabaseThe creation and definition of a tableSelect, update, delete and insert data (SELECT,INSERT,UPDATE,DELETE) Discover the aliases column and tackle the specificity and the secrets of LIKE.Do you know the usefulness of the TOP ?Learn how to remove duplicates with the DISTINCT and discover the Comparison operators =!= and so on.Copying a table with the SELECT INTO.Let's talk about the IN, NOT IN, IS and IS NOT operators, and sort your data with ORDER BY.Discover the aggregated functions with MIN MAX and AVG and the two operators AND,OR.Let's find out the specifics of COUNT and SUM and how to SELECT a range of data with the BETWEENGroup different results with the GROUP BY and Let's discover the specifics of HAVING and the PRINT.The merge with INNER JOIN,LEFT/RIGHT JOIN FULL OUTER JOIN and so on.Let's take Transact SQL even further with the CHOOSE,IIF,CASE WHEN,SUBSTRING, OFFSET FETCH NEXT ROWS.Have you heard of the CHOOSE, TRIM/LTRIM/RTIM or COALLESCE function?Let's discover the specific features of UNION and UNION ALL, and the LEFT and RIGHT function.Laten we eens kijken naar de conversiefuncties via CAST en CONVERT, TRY_CAST en TRY_CONVERT, en ook via TRY_PARSE en PARSE.Het creëren en definiëren van een view.Het creëren en definiëren van een Stored Procedure.Deze cursus bestaat uit 7 uur demo en 30 minuten theorie. De theorie bevindt zich in het klaslokaal, niet in deze cursus:)Deze cursus omvat meer dan 50 vragen! Waarom zou ik de SQL technologie gebruiken?SQL is één van de actiefst gezochte vaardigheden op de arbeidsmarkt.Het beheren van een SQL server en queryen in TSQL is vandaag de dag een fulltime baan.Bovendien stelt SQL Server u door zijn eenvoud in staat om snel competent te worden in zeer specifieke onderwerpen. When this course is over, believe me you will feel much more comfortable with the SQL language.I also made sure that the videos are no longer than 10 minutes so it's not too sleep-inducing:)
