|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-server-developer-select-query-foundations/
课程评论：没有评论
**Coursera 课程：SQL Server 开发者 - SELECT 查询基础** 本课程旨在教授您从 Microsoft SQL Server 数据库引擎检索数据的基本知识。我们将重点介绍如何在 SQL Server 环境中使用 `SELECT` 子句查询数据库表，并将数据呈现给报表或应用程序。 **课程目标受众：** * 希望提升数据查询技能的数据分析师 * 希望为应用程序添加数据库功能的程序员 * 任何需要访问公司数据库服务器中海量数据的个人 **课程内容亮点：** * **检索和组合列：** 使用 `SELECT` 子句从 SQL Server 表中检索和组合列，并利用函数为最终用户显示数据。 * **多表连接：** 学习如何通过 `FROM` 子句指定要连接的表，并使用多种 `JOIN` 子句将不同表中的信息合并。 * **数据过滤：** 使用 `WHERE` 子句根据一个或多个列过滤数据，并了解如何将 `WHERE` 子句与 `JOIN` 结合，高效地检索特定信息。 * **聚合函数与分组：** 运用聚合函数，通过 `GROUP BY` 对信息进行分组，计算总计和平均值，从而进行数据分析和报表制作。 * **工具安装与使用：** 指导您下载和安装所有必要的工具，包括免费的 SQL Server Express Edition、示例数据库 'AdventureWorks' 以及 SQL Server Management Studio (SSMS)。学习如何连接数据库并高效使用 SSMS。 * **学习资源：** 提供包含主题摘要和额外信息的讲义，以及难度递增的复习题，并附带视频解析和多种解题方法的分析。 * **综合评估：** 课程最后设有综合测试，检验您所学到的所有技术。
SQL Server SELECT query foundations aims to teach you the basics of retrieving data from the Microsoft SQL server database engine. the course contains details on how to use the SELECT clause in the SQL server environment to query database tables and bring back data to present in reports or applicationsThis course is aimed at anyone looking to improve their understanding of database development, from data analysts looking to increase their skills on data querying, programmers looking to add database capabilities to their apps, or anyone who needs to get at the wealth of data contained in their companies' database servers.the course includes lessons on:Retrieving and combining columns from SQL server tables using the SELECT clause to define columns and functions to display to the end users.Joining multiple tables in different ways to combine information. Using the FROM clause to specify which tables you want to connect to, and multiple JOIN clauses to connect tables to each other.Filtering data to retrieve only the information you want. Using the WHERE clause to filter your data on one or multiple columns, and the ways to combine the WHERE clause with JOINs on your tables to efficiently retrieve information.Using aggregate functions to GROUP BY information and find totals and averages of data to perform analysis and make reportsthe course contains lessons on how to download and install all the tools you need to become proficient in coding SQL; I'll take you through how you can download and install SQL server express edition, a free personal use version of SQL server, and the sample 'AdventureWorks' database so you can try out all the examples, and develop and test your own queries.We'll also download SQL Server Management Studio; your best interface into the database environment, and I'll go through the basics of how to connect to Databases, and how to use the tool more efficiently.I've included handouts with summaries and further information on some topics, as well as increasingly difficult review questions for you to try yourself. each set of questions is followed by a video analysis of the solutions and the different ways you could choose to solve them.There's also an end of course test that combines all the techniques you've learned into one final exam.
