|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/sql-data-analyst-sql-microsoft-sql-postgresql-mysql/
课程评论：没有评论
课程名称：SQL数据分析师 - SQL，Microsoft SQL，PostgreSQL，MySQL 课程概述： SQL数据分析师是一种使用SQL语言来解释数据的数据科学家。这种分析旨在改善商业信息，并为管理者提供新的见解。SQL数据分析师设计脚本和程序以执行特定的数据库功能，以及分析和维护数据。相应的职责和任务包括： - 整合数据：将来自多个数据集的数据整合到一个数据库系统中，以简化信息。 - 创建数据库功能：为数据库编程特定的功能，设计数据表和创建触发器。 - 设计报告：在审查和分析数据后，设计报告以展示特定数据库主题的统计信息和其他信息。 - 清理数据库：删除无效数据文件和其他不相关的信息，以释放数据库空间。 - 编写脚本：编写脚本以分析数据并执行特定的数据查询。 - 解决数据问题：隔离并解决与数据和数据库相关的问题。 - 添加数据：从多个来源收集数据并将其添加到数据库中。 在本课程中，我们将使用SQL对关系数据库（如MySQL、PostgreSQL和MS SQL Server）进行数据分析。关系数据库是一种数据库类型，它使用结构化的方式来识别和访问数据库中与其他数据相关的数据，通常数据以表格形式组织，包含行和列。例如，一个典型的商务订单输入数据库可能包含一个描述客户的表，列包括姓名、地址、电话号码等。 SQL（结构化查询语言）是数据专业人员的重要工具，毫无疑问是进入数据分析或数据科学领域的最重要的语言。每分钟都有数百万个数据点被生成，原始数据本身并没有故事可讲。在所有这些数据被存储在数据库之后，专业人员使用SQL提取数据进行进一步分析。 通过本课程，学员将掌握SQL数据分析的核心知识和技能，为在数据分析领域的职业生涯打下坚实基础。
A SQL data analyst is a data scientist that uses the SQL language to interpret data. This analysis is used to improve business information and provide new insights to managers.SQL data analysts design scripts and programs to perform specific database functions and to analyse and maintain data. Some SQL Data Analyst Duties and ResponsibilitiesDuties vary for SQL data analysts based on the specific needs of the hiring company and the amount of data being analysed. However, these core tasks are commonly associated with this job:Integrate DataSQL data analysts integrate data from multiple data sets into o:ne database system to streamline information.Create Database FunctionsSQL data analysts program specific database functions to create database triggers and design data tables.Design ReportsAfter reviewing and analysing data, SQL data analysts design reports to show statistics and other information about specific database topics.Clean DatabaseSQL data analysts remove dead data files and other irrelevant information to free up database space.Write ScriptsSQL data analysts write scripts to analyse data and perform specific data queries.Resolve Data IssuesSQL data analysts isolate and resolve issues with data and databases.Add DataSQL data analysts collect data from multiple sources and add it to the database.We will be performing data analysis using SQL on relational databases like: MySQL, PostgreSQL and MS SQL Server.A relational database is a type of database. It uses a structure that allows us to identify and access data in relation to another piece of data in the database. Often, data in a relational database is organized into tables. A relational database includes tables containing rows and columns. For example, a typical business order entry database would include a table that describes a customer with columns for name, address, phone number and so forth.SQL or Structured Query Language is a critical tool for data professionals. It is undoubtedly the most important language for getting a job in the field of data analysis or data sciences. Millions of data points are being generated every minute. And raw data does not have any story to tell. After all this data gets stored in databases and professionals use SQL to extract this data for further analysis.
