|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-the-basics-of-transact-sql-4-hours-of-lessons/
课程评论：没有评论
**课程名称：** 99个查询：4小时内精通SQL！ **课程概述：** 本课程专为SQL初学者设计，旨在快速掌握T-SQL查询语言。课程内容涵盖： * **环境准备：** 在本地安装SQL Server。 * **基础操作：** 表的创建与定义，数据的插入（INSERT）、更新（UPDATE）、删除（DELETE）和选择（SELECT）。 * **数据筛选：** 使用TOP选择指定行数，DISTINCT去除重复项。 * **常用操作符：** BETWEEN, AND, OR, HAVING, PRINT, GROUP BY 等。 * **高级T-SQL：** UNION, UNION ALL, TRIM/LTRIM/RTRIM, UPPER/LOWER 等函数。 * **数据复制与比较：** 使用SELECT INTO复制表，以及比较运算符 =!= 等。 * **聚合函数：** MIN, MAX, AVG 等。 * **连接（Joins）：** 深入讲解INNER JOIN, LEFT/RIGHT JOIN, FULL OUTER JOIN等，时长达1.5小时。 **课程亮点：** * **高效学习：** 旨在4小时内掌握SQL核心查询。 * **短小精悍：** 视频时长控制在10分钟以内，避免枯燥。 * **实用价值：** SQL是热门职场技能，掌握SQL Server查询能力可增加就业机会。 * **易于上手：** SQL Server的简洁性帮助快速掌握特定知识。 * **高质量保证：** 作者其他课程评价普遍较高，课程质量有保障。
Are you a (very) big beginner on SQL, and you want to learn quickly how to make queries in TSQL? This course will therefore be ideal for you. After having installed SQL server on your computer, we will approach in this course in the order: The creation and definition of a tableSelecting, updating, deleting and inserting data (with SELECT, UPDATE etc...)Select a certain number of lines with the TOP, remove duplicates with the DISTINCT.The operators BETWEEN, AND, OR,HAVING,PRINT,GROUP BY etc...).Go even further in Transact SQL with UNION and UNION ALL, TRIM/LTRIM/RTRIM and UPPER/LOWER, etc.Copy a table via SELECT INTO and comparison operators =!= etc...Aggregate functions: MIN, MAV and AVGA long chapter of 1h 30 on joins! (INNER JOIN,LEFT/RIGHT JOIN FULL OUTER JOIN etc...)Once this course is over, believe me that you will be much more comfortable with SQL and I also made sure that the videos don't exceed 10 minutes, so that it won't be too soporific:) Why go for SQL technology? SQL is one of the skills very actively sought after in the job market.Administering an SQL server and querying in TSQL today is ensuring you have a full time job.Moreover, SQL Server, because of its simplicity, allows you to quickly become proficient on very specific subjects. Look at the average of my other courses (4,4/5), and you will see that my courses are quality courses:)
