|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/beginner-data-analysis-using-sql-and-microsoft-sql-server/
课程评论：没有评论
SQL Server：Microsoft出品的关系型数据库管理系统，全球众多企业的数据解决方案。SQL（Structured Query Language）是国际通用的数据库通信和操作语言。T-SQL是Microsoft对SQL的实现，两者相似但T-SQL有SQL Server特有的部分。 SQL在数据分析中有广泛应用，能将数据库中的原始数据转化为有价值的信息，辅助企业决策。本课程是SQL入门指南，教授如何使用SQL查询SQL Server，解决数据相关问题。您将学习编写实用的SQL查询，应用于真实生产环境。 随处可见的数据收集（交易、网页访问、支付等）都充实着关系型数据库，这些原始数据可通过分析提供有用的信息。掌握数据分析和报告技能的人才需求旺盛，能帮助企业做出关键决策。 课程将涵盖： * 设计和编写简单的SQL查询以进行数据分析。 * 合并多表数据。 * 使用聚合函数。 * 在SQL查询中使用通配符。 * 对相关数据进行分组。 * 使用WHERE子句过滤数据。 * 使用别名（Alias）。 * 检索表中所有数据。 本课程将通过SQL回答诸如“公司有多少客户或员工？”“公司有多少销售代表？”“第一个订单是什么时候下的？”等实际问题。课程包含大量真实世界示例，助您提升SQL技能。
SQL Server is a relational database management system -RDBMS developed and owned by Microsoft.Thousands of companies all over the world use SQL Server for their data solution. SQL -Structured Query Language is an internationally recognised language used to communicate and manipulate various database systems.T-SQL - Transact SQL is Microsoft's implementation of SQL. There are a lot of similarities between them but also proprietary parts that are specific to SQL Server. SQL can be used for Data Analysis to transform data already present in the database to valuable useful information that help companies and organisations make key business and management decisions. This course is a beginners guide to performing data analysis using SQL to interrogate SQL Server to provide answers to data related questions. You will learn to write useful SQL queries that is applicable to the Real World production environment. Everywhere data is being collected, every transaction, every web page visit,every payment-all these and much, much more are filling relational databases with raw data that can be analysed to provide useful information. There is a demand for people who can use data to perform reporting and analysis thus helping businesses and organizations make important and critical decisions. Skills You will learn include: • How to design and write simple SQL queries for data analysis. • How to merge data from multiple tables• How to use aggregate functions • How to use wild cards with SQL queries• How to group related data• How to Filter Data search with SQL WHERE clause• How to Use Alias • How to retrieve all the data from a table In this course we will use SQL to provide answers to questions like:How many customers or employees doe a company has?How many sales reps does a company have?When was the first order placed? This course is packed with real world examples that will help you build your SQL Skills. .
