|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/writing-advanced-sql-queries-on-microsoft-sql-server/
课程评论：没有评论
**课程名称：** 编写 Microsoft SQL Server 高级 SQL 查询 **课程概述：** 本课程旨在帮助学习者掌握 Microsoft SQL Server 这一强大的关系型数据库管理系统。SQL（结构化查询语言）是与 SQL Server 数据库进行交互和操作的标准语言。本课程适合从入门到略有基础的学习者，将引导您学习如何开发用于 SQL Server 数据库的查询。 **课程内容涵盖：** * **多表数据提取：** 学习使用内连接 (Inner joins)、左外连接 (Left outer joins) 和右外连接 (Right Outer joins) 从多个表中提取数据。 * **数据汇总：** 掌握使用聚合函数（如 COUNT, SUM, AVG, MIN, MAX, VAR, VARP）对数据进行汇总分析。 * **分析函数：** 学习使用各种高级分析函数，包括 LEAD, LAG, LAST_VALUE, FIRST_VALUE, PERCENT_RANK, CUME_DIST。 SQL 是所有关系型数据库操作的基石。要充分发挥其功能，需要深入理解该语言。通过本课程，您将学会如何利用 SQL 的全部潜力，编写用于 SQL Server 数据库的查询。您将获得实际技能，选择最佳的查询方法，以确保准确性并避免常见的错误或陷阱。 **目标受众：** 希望提升 SQL 查询能力，特别是针对 Microsoft SQL Server 的学习者。 **核心技能：** SQL 查询编写，多表连接，数据聚合，使用 SQL Server 特有的分析函数。
Microsoft SQL Server is robust relational database management system used by so many organizations of various sizes including top fortune 100 companies. SQL -Structural Query language is the language used to interrogate and manipulateMicrosoft SQL Server Databases. This course is a beginners to slightly advanced course that will walk you through how to develop queriesto execute on and SQL Server Database. We will developing queries to extract data from multiple tables using: Inner joins Left outer joins Right Outer joins We will also be Summarising data with aggregate functions such as: COUNT SUM AVG MIN MAX VARVARP We will also be writing queries using various analytic functions like:LEADLAGLAST_VAUEFIRST_VALUEPERCENT_RANKCUME_DIST SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language. In this course, you learn to use the full potential of SQL to write simple queries for SQL Server databases. You will gain the practical skills to choose the best query method to ensure accuracy and avoid common errors or pitfalls.
