|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-developers-and-analysts/
课程评论：没有评论
《SQL for Developers and Analysts with MS SQL Server》课程大纲： 本课程将通过微软 SQL Server 提供全方位的 SQL 实操学习。您将学会下载免费的 SQL Server 2017 版本并搭建工作环境。课程内容涵盖 SQL Server 中的各种对象，如表、视图和存储过程。在介绍 SQL 查询的基本结构后，课程将以易于理解的方式深入讲解不同的 SQL 子句。您将初步了解如何管理和保护数据，掌握查询、排序、限制输出以及构建子查询的技巧。此外，课程还会讲解数据操作，包括插入、删除和更新。您还将学习如何对数据进行分组和汇总。课程还将简要介绍一些高级概念，以及如何使用 Excel、SQL Server Reporting Service 和 Tableau 构建报表。最后，课程将提供 SQL 开发相关的求助资源和职业发展建议，帮助您成为一名 SQL 开发人员或分析师。
This course will give you hands-on learning of SQL using Microsoft SQL Server. The course will teach you how you could download a free copy of SQL Server 2017 Edition from Microsoft website and set up your working environment. It will teach you various objects in SQL Server including tables, views, stored procedures. After providing you a basic structure of a SQL query structure, it will show different SQL clauses in a way that will make more sense for students to follow. It will give you a basic understanding of how you can manage your data and protect it. The course will show you how you can be able to query data, sort, restrict the output and build sub-queries. You will also understand how you can manipulate data insert, delete and update works. The course will teach how you can group and summarize your data. The course will briefly touch some advanced concepts and how you can be able to build reports using Excel, SQL Server Reporting Service, and Tableau. Finally, the course will show you can get help when while working as a SQL developer and some career advice to work as a SQL developer or analyst.
