|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-queries-101-a-beginners-guide-to-data-retrieval/
课程评论：没有评论
Coursera 上的 "SQL Queries 101: A Beginner's Guide to Data Retrieval" 课程是一门面向学生和职场人士的入门级 SQL 学习课程。该课程旨在帮助学习者轻松掌握 SQL 查询，实现高效的数据检索。 **课程内容涵盖：** * **基础 SELECT 语句：** 学习如何从数据库中选取数据。 * **标量函数：** 了解在 SQL 中使用的各种函数。 * **聚合函数：** 掌握 SUM, AVG, COUNT 等函数的使用，用于数据汇总。 * **GROUP BY 和 HAVING 子句：** 学习如何对数据进行分组和过滤。 * **比较和逻辑运算符：** 掌握 WHERE 子句中的查询条件。 * **表关系与 JOIN：** 学习如何连接多个表以获取更全面的数据。 * **子查询：** 掌握在查询中使用嵌套查询。 * **CASE Switch：** 学习如何创建条件逻辑。 * **SQL Views：** 了解视图的作用和创建方法。 * **CREATE Table, INSERT, UPDATE, and DELETE Rows：** 学习数据库的基本操作，包括创建表、插入、更新和删除数据。 **课程特色：** * 包含 11 个章节，提供易于理解的教学视频。 * 包含 2 个测验，检验学习成果。 **所需软件和凭证：** * 可以安装 SQL Server Basic 和 SQL Server Management Studio。 * 或者，可以使用在线工具 SQLiteonline 执行 SQL 查询。 **课程目标：** * **数据检索：** 精通 SELECT 查询，高效准确地从数据库表中提取所需信息。 * **数据过滤：** 利用 WHERE 子句，根据特定条件筛选数据。 * **数据排序：** 掌握 ASC 和 DESC，根据一列或多列对数据进行排序。 * **数据聚合：** 运用聚合函数进行数据计算和汇总，获取有价值的洞察。 * **数据连接：** 通过 JOIN 子句合并多个表的数据，进行深入的数据分析和报告。 该课程由一位拥有丰富线下培训经验的讲师教授，其培训领域广泛，包括办公生产力、编程、数据库、分析和云计算，能够帮助学习者快速掌握新技能。
If you are a student or working professional, join me in this engaging beginner course on SQL Queries. This course will teach you how to write SQL Queries for effortless data retrieval with a minimal learning curve. As of October 2023, I have provided in-person training to over 3,000 professionals, covering skills such as office productivity, programming, databases, analytics, and cloud computing, which enables rapid integration of newfound skill sets.Course CurriculumBasic SELECT StatementScalar FunctionsAggregatesGROUP BY and HAVING ClauseComparison and Logical OperatorsTable Relationships with JOINSSub QueriesCase SwitchSQL ViewsCREATE TableINSERT, UPDATE and DELETE RowsWhat this course contains11 Sections with Easy-to-follow instructional videos2 QuizzesSoftware and Credentials RequiredYou can install SQL Server Basic along with SQL Server Management Studio. Alternatively, if you cannot install SQL Server, you may utilize the website SQLiteonline to execute the SQL queries relevant to this course.Intended Course OutcomeData Retrieval: Mastering SQL SELECT queries allows learners to efficiently access specific data from one or multiple database tables, ensuring quick and accurate information retrieval.Data Filtering: Users can employ filtering conditions in SQL SELECT queries using the WHERE clause, enabling data extraction that meets particular criteria, such as date ranges, categories, or values.Data Sorting: Utilizing SQL SELECT queries, retrieved data can be sorted in ascending or descending order based on one or more columns, simplifying analysis and presentation.Data Aggregation: Proficiency in SQL SELECT queries empowers users to perform calculations and use aggregate functions (e.g., SUM, AVG, COUNT) on selected data, offering valuable insights and information summaries.Data Joining: By mastering SQL JOIN clauses, learners can merge data from multiple related tables, promoting extensive data analysis and reporting.
