|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-for-non-technical-users/
课程评论：没有评论
**Coursera 课程总结：面向非技术用户的 SQL** **课程概述：** 本课程旨在帮助没有任何技术背景的学习者掌握基础 SQL 查询编写能力，以便能够自主获取工作所需信息。您是否曾依赖他人为您编写 SQL 查询？您是否对编写自己的 SQL 查询感到畏惧？现在是时候掌握这项重要技能了。 **课程目标：** 在本课程结束时，您将能够： * 从一个或多个表中检索数据。 * 使用别名简化查询。 * 使用 `WHERE` 子句过滤数据。 * 理解并使用外部连接（Outer Joins）。 * 运用常用函数，如 `DATEPART`、`DATENAME`、`DATEDIFF`、`TRIM`、`SUM` 和 `AVG`，进行日期、文本格式化以及求和与平均值计算。 * 使用 `GROUP BY` 和 `HAVING` 子句检索和过滤汇总数据。 * 编写子查询，包括嵌套子查询。 **课程特色：** * **内容全面：** 涵盖 SQL 基础知识，并引入部分进阶主题。 * **实用性强：** 帮助您摆脱对他人数据提取的依赖。 * **教学风格：** 采用 Bigger Brains 教师-学习者互动式教学风格，提供约 75 分钟的高清优质内容。 * **工具支持：** 课程使用 SQL Server Management Studio，但所学 SQL 查询语言可适用于多种工具。 **适用人群：** 所有希望学习 SQL 基础，并能独立进行数据提取和分析的非技术人员。
Learn to write simple queries to get the information you need to do your jobDo you often have to ask others to write SQL queries for you? Are you intimidated by the idea of writing your own SQL query? It's time to take matters into your own hands.In this course, you'll learn how to write a basic SQL query from start to finish. This course will quickly teach you what you need to know to get started. By the end of the course, you'll be able to retrieve data from multiple tables, sort and filter query results, and use simple calculations. We'll cover commonly used functions, so you can format dates and text as well as calculate sums and averages.These lessons will help you learn the fundamentals of the SQL language while also introducing you to some of the more advanced topics. If you're ready to stop waiting on someone else to pull data for you, this course is for you.Note: This course uses SQL Server Management Studio, but the language of an SQL query is not specific to any one tool.Topics covered include:Retrieving data from one or multiple tablesUsing aliases to simplify your queriesFiltering data with the WHERE clauseUsing Outer JoinsWorking with functions: DATEPART, DATENAME, DATEDIFF, TRIM, SUM, AVGUsing the GROUP BY and HAVING clauses to retrieve and filter summarized dataWriting subqueries including nested subqueriesEnjoy seventy-five minutes of high-quality HD content in the "Uniquely Engaging"TM Bigger Brains Teacher-Learner style!
