|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/business-analyst-sql-survival-guide/
课程评论：没有评论
**课程名称：** 商业分析师 - SQL生存指南 **课程概述：** 本课程专为希望快速入门SQL基础知识的商业分析师而设计，旨在帮助您轻松掌握SQL，即使您之前完全没有接触过或只想学习基础功能。 **课程内容将涵盖：** * **数据库基础：** 了解数据库是什么，以及应用程序如何使用数据库。 * **数据建模：** 学习实体关系图（ERD）的概念。 * **数据仓库：** 理解数据仓库的作用以及组织如何利用它们。 * **技术准备：** 介绍连接数据库所需的软件，并指导您创建自己的测试数据库。 * **核心SQL命令：** 学习从单个或多个SQL数据库表中查询数据的必备命令。 * **数据操作：** 掌握插入、更新和删除数据的SQL命令。 * **数据导出：** 学习如何将数据导出至Excel。 **课程重要性：** 在本课程中，您将了解到数据是商业分析的核心。准确的数据是验证或推翻假设和行动方案最直接有力的方式。然而，问题的关键在于如何获取这些数据。如果您缺乏查询数据库的技能或权限，您将依赖他人提供数据，而这可能无法满足您的精确需求。 **学习目标：** 本课程将赋予您理解数据库、其工作原理以及最重要的是，如何访问和查询数据的能力，从而使您能够独立、自主地获取所需数据。
Are you a business analyst and have either avoided getting to know SQL, or haven't had the opportunity? Or, maybe you just want to a quick start to the basics of SQL without the advanced functions? If you've answered yes to any of these then this course is for you.Starting with the absolute basics, this course covers;What a database isHow applications use databasesEntity Relationship DiagramsWhat a data warehouse is and how organisations use themWhat software you'll need to connect to a databaseHow to create your own test databaseThe essential SQL commands you'll need to query data from one or many tables in a SQL databaseCommands you'll need to manipulate data (insert, update, and delete)How to export data to ExcelTo a business analyst, data is king. Accurate data is the easiest and most powerful way to prove or disprove a hypothesis or course of action, the challenge is getting your hands on it. If you don't have access or the skills to query a database you are reliant on someone else getting the data that you've asked for, which might not be what you want.I want to give you the skills to understand what a database is, how they work, and most importantly, how you access one and query the data so you can be self-sufficient getting the data you need.
