|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-code-challenges-use-sql-to-answer-business-questions/
课程评论：没有评论
**课程名称：** SQL代码挑战：用SQL回答业务问题 **课程概述：** 本课程是一门实践性极强的“边做边学”的SQL训练营。SQL（结构化查询语言）是数据存储、处理和检索的标准语言，在当今数据驱动的IT行业中，尤其是在大数据和依赖数据的业务及应用程序领域，SQL技能需求旺盛。 课程从零开始，将指导学员完成SQL实验环境的搭建，包括下载和安装Microsoft SQL Server以及Northwind示例数据库。 课程的核心是通过解决21个与业务相关的实际问题，教授学员如何编写SQL查询来从数据库中提取信息并得出解决方案。在课程中，您将学习并实践以下SQL关键概念和技术： * **数据检索：** 使用`SELECT`语句 * **条件逻辑：** 使用`CASE`表达式 * **去除重复：** 消除重复数据 * **数据筛选：** * 使用等值筛选 * 使用基本比较运算符 * 使用字符串比较 * 使用逻辑运算符 * 使用`NULL`值比较 * **数据排序：** 使用`ORDER BY`子句进行升序和降序排序 * **多表查询：** 使用`JOIN`从多个表中提取数据 * **结果合并：** 使用`UNION`运算符合并多个`SELECT`语句的结果 * **聚合计算：** 使用聚合函数计算单个输出值 * **分组查询：** 使用`GROUP BY`子句对相关数据进行分组 **学习目标：** 完成本课程后，学员将具备独立查询数据库、分析数据并回答业务问题的能力。
SQL is a standard language for storing, manipulating and retrieving data in databases.SQL is a standard language for storing, manipulating and retrieving data in databases.The best way to build up your skills in any area is by practice. This course is a hands-on practical learn by doing course.SQL ( SQL -Structural Query language ) is one of the most popular and sort after skills in the IT industry. SQL Skills is so important especially with big data and data dependent businesses and applications from Facebook to our local banks.This course was designed with the beginner in mind. The course starts by walking you through how to setup a lab where you will download and install Microsoft SQL Server and the sample Northwind database.In this course we will solve 21 business related problem questions by building SQL queries to interrogate the database and produce the answers to solving the business problems.We will use the following while building our queries to solve the business problems:Retrieve data with SELECT Use Case Expressions Eliminate duplicatesFilter data with equality filters Filter data with basic comparisons Filter data with string comparisons Filter data with logical comparisons Filter data with NULL comparisons Use order by clauseSort data by ascending and descending order Use Table joins to extract data from multiple tablesUse UNION operator to combine results of two or more SELECT Statements Aggregate functions to compute a single output valueGROUP BY Clause to group related dataBy the end of this course you will be would have gained enough skills to interrogate Databases.
