|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/data-analysis-business-intelligence-mysql-for-beginners/
课程评论：没有评论
**Coursera 课程总结：MySQL入门与商业智能数据分析** 本课程是一门面向初学者的MySQL数据分析速成课程，旨在通过一个DVD租赁店的真实案例，帮助学员掌握使用MySQL数据库和MySQL Workbench进行数据分析的核心技能。 **课程亮点：** * **实战导向：** 以DVD租赁店的业务场景为基础，让学员扮演业务分析师的角色，解决经理提出的数据分析需求。 * **工具聚焦：** 专注于MySQL Community Server和MySQL Workbench，提供详细的安装、连接和数据库导入指导。 * **SQL技能培养：** * 教授基础SQL查询的编写，包括数据提取、排序、过滤。 * 深入讲解单表和多表数据分析，重点教授各种JOIN（INNER, LEFT, RIGHT, OUTER等）的使用。 * 通过实践提高数据分析效率，如高效地提取、排序、过滤和分组数据。 * **循序渐进的学习路径：** * **SQL入门：** 快速介绍数据库、数据分析以及SQL的作用。 * **MySQL安装与连接：** 指导用户安装MySQL服务器和Workbench，并连接到数据库。 * **单表数据分析（上）：** 学习在单个表中进行查询、过滤、排序和分组。 * **单表数据分析（下）：** 学习连接多个表进行更复杂的数据分析。 * **综合项目：** 课程包含一个最终的MySQL项目，让学员巩固所学知识。 **目标学员：** * 希望获得MySQL数据分析实战经验的学生。 * 寻求数据库数据分析能力的分析师和商业智能专业人士。 * 希望进入数据分析或商业智能领域的个人。 * 希望从Excel进阶到商业智能和数据库技能的Excel用户。 **学习收获：** * 全面理解数据库基础（不包含数据库管理）。 * 掌握高效编写SQL查询的技巧，包括数据提取、排序、过滤和分组。 * 能够连接和分析来自多个表的数据。 * 通过互动式实操项目，全面掌握数据分析流程。 * 课程提供终身访问权限和结业证书，并有30天退款保证。 本课程将带领学员从零开始，一步步深入数据库分析的世界，培养解决实际业务问题的能力。
In this Crash Course you will play a role of business analyst who works in a DVD rental shopYou will use only MySQL database and MySQL Workbench to achieve the objectives the are required by the manager who needs you to analyze the data Don't worry I will be there for you, guiding you to from start to finish and assist you in your homework and project to explore MySQL database ( Community Server and MySQL Workbench) What you will learn:Write SQL queries in a simple way!Analyzing the data - Single table and multiple tables with JOINProblem solving by hands-on practicing with a real-world data case.Learn how to extract, sort, filter and group the data efficiently.Course Outline:Into to SQL:I will start a quick intro to database and data analysis and how we can use SQL in database analysis MySQL (Community and Server ):we will install MySQL the community and connect MySQL Workbench to the Server and then how to connect our source database to the server and an introduction to database structureData Analysis - Single Tables - Part 1:In this section we'll start exploring and extracting information from individual tables in our MySQL database, and practice writing SQL queries to select, filter, sort and group our data.Data Analysis - Single Tables - Part 2:In this section, we'll review the most common types of SQL joins (INNER, LEFT, RIGHT, OUTER, etc), and explore some more complex MySQL queries to analyze data that bridges multiple tables in our database.Course Project:[FINAL MYSQL PROJECT]This Crash course is Targeted for Students:Students looking for hands -on practicing MySQL data analysisAnalysts and business intelligence professionals looking to analyze data stored in database systemAnyone looking to pursue a career in data analysis or business intelligenceExcel users looking to enhance their level into business intelligence and databaseYou will get a life time access and a certificate upon completion 30-day money back guaranteeI am sure you gonna love the course, so let's dig in This course gives you a deep, 100% comprehensive understanding of database fundamental ( Database administration will not covered in this course) ,and writing SQL code while analyzing the data. including sorting, filtering, and grouping, and connecting tables together and guide you through interactive, hands-on project every step of the way.
