|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-essentials-in-an-hour-the-select-statement/
课程评论：没有评论
课程名称：一小时掌握SQL Server基础知识：SELECT语句 概述：你想快速学习SQL Server吗？请注意：本课程与微软没有关联、认可或赞助。学员评价：Melisa表示：“讲解非常清晰！我推荐这门课程。”Monde说：“讲师的例子直截了当，让我理解了聚合函数，比如SUM、MIN、COUNT、AVG和MAX，他实在太棒了，我很喜欢他。”Jay则提到：“我多年前学习过SQL，现在需要重温基本语法。这个课程正好满足了这个需求！” 本课程将用一小时的时间详细讲解SELECT语句，包含六个组成部分： - SELECT：类似于其他语言中的打印语句。 - FROM：指定数据源。 - WHERE：过滤数据源。 - GROUP BY：对结果进行汇总。 - HAVING：对汇总结果进行过滤。 - ORDER BY：对结果进行排序。 课程最后将介绍如何使用视图和存储过程来保存代码，并将报告导出到Excel，包括统计导出（复制粘贴）和动态导出（确保报告始终最新）。通过本课程，在短短一小时内，你将能够创建自己的SELECT语句，以便在SQL Server（SSMS、SSRS和SSIS）以及Excel中使用。这些知识将帮助你快速、轻松地开始编写和使用自己的代码。 如果你的计算机尚未安装SQL Server，本课程还提供了一个视频链接，指导你如何免费安装SQL Server开发版以及SQL Server管理工作室（SSMS），这些工具可以在你的笔记本或台式机上进行学习使用。 掌握这些知识对于DP-300和DP-600考试也将大有帮助。
Do you want to learn SQL Server quickly?Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.ReviewsMelisa says: Explanations are very clear! I recommend this course.Monde says: Its was nice the lecture made clear to the point examples and I could make sense of what he was explaining example was making sense about all the aggregate clauses such as SUM, MIN, COUNT and AVG and MAX he was too good I like himJay says: I learned SQL years ago, and I needed a refresher on the basic syntax. This course was perfect for that purpose!In this course, we will look in an hour at the SELECT statement.There are six constituent clauses in this statement: SELECT - this is akin to the Print statement in other languages, andFROM - this shows your data source,WHERE - this filters down your data source,GROUP BY - this enables the results to be summarised,HAVING - this filters the summary, andORDER BY - this sorts your results.We will then look at saving your code using both views and procedures.Finally, we'll export your reports into Excel, both statistically (copy and paste) and dynamically (so that you always have the latest reports).In just an hour, you'll be able to create your own SELECT statements, so you can use them in SQL Server (SSMS, SSRS and SSIS) and in Excel. This is all you need to start writing and using your own code. Quick and easily.If you have not already got SQL Server installed on your machine, this course includes a link to a video which shows you how you can install for free SQL Server Developer edition, together with SQL Server Management Studio (SSMS). These can be installed on your laptop or desktop to use for learning purposes for as long as you need.Knowledge of this will also help with the DP-300 and DP-600 exams.
