|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mysql-for-data-analysis/
课程评论：没有评论
课程名称：SQL 数据分析：初学者 MySQL 商业智能 课程概述：SQL 和 MySQL 是管理和分析关系型数据库的强大工具，是每个分析师和商业智能专业人士必备的技能。在本课程中，您将扮演一位新近收购 Maven Movies DVD 租赁店的老板。通过使用 MySQL 数据库和 MySQL Workbench，您的任务是深入了解新业务的库存、员工和客户行为。课程提供系统的指导，包括清晰的讲解、MySQL 专业技巧以及最佳实践，并通过小测验、项目和作业来测试您的 SQL 数据分析和数据库分析技能。 课程大纲： 1. SQL 简介与 MySQL 设置 - 介绍 SQL 的基本概念及不同的数据库系统（MySQL、SQLite、PostgreSQL 等），并指导安装所需的工具（MySQL Community Server + MySQL Workbench）。 2. SQL 数据库基础（第一部分） - 快速回顾数据库基础知识，探索包含 Maven Movies 客户、库存和交易信息的 16 个表格。 3. 从单个表分析数据 - 学习如何从 MySQL 数据库中提取、筛选、排序和分组信息，以进行分析和商业智能。 4. SQL 数据库基础（第二部分） - 讲解关系型数据库、数据建模及数据库分析的相关概念（主外键、关系基数、规范化等）。 5. 通过 MySQL JOIN 分析多个表 - 复习常见的 SQL 连接（INNER、LEFT、RIGHT、OUTER 等），并探索复杂的 MySQL 查询来分析涉及多个表的数据。 重要提示：本课程不涉及数据库的构建、修改或维护，专注于使用 MySQL 和 MySQL Workbench 的数据探索和数据库分析。 课程优势： - 超过 5 小时的高质量视频 - 可下载的 MySQL 电子书 - 小测验和作业 - 期中和期末 SQL 项目 - 30 天退款保证 如果您希望通过 SQL/MySQL 掌握数据分析的实践技能，这门课程非常适合您。探索商业智能的完整工具包，搜索“Maven Analytics”以浏览更多课程，包括 Excel、Power BI、MySQL 和 Tableau 课程。 本课程在 Udemy 上获得了极高的评价，众多学员给予正面反馈，称赞其清晰的信息呈现和频繁的实践示例，使得学习过程既愉快又富有成效。 - 约翰（主讲 SQL 教师及 MySQL 专家，Maven Analytics）
SQL and MySQL are incredibly powerful tools for managing and analyzing relational databases, and a skill that every Analyst and Business Intelligence professional should have in the arsenal.In this course, you'll play the role of a business owner who just acquired Maven Movies, a brick and mortar DVD rental shop. Using only a MySQL database and MySQL Workbench, your mission is to learn everything that you can about your new business; including your inventory, staff, and customer behavior.But don't worry, you're not alone! We'll be right here to guide you from start to finish, sharing crystal clear explanations, MySQL pro tips and best practices, and course quizzes, projects and homework assignments to test your SQL data analysis and database analytics skills along the way.COURSE OUTLINE:SQL Intro & MySQL SetupWe'll start with a quick intro to the SQL landscape and it's common "flavors" (MySQL, SQLite, PostgreSQL, etc), then download and install the tools that we'll need to access and explore our MySQL database (MySQL Community Server + MySQL Workbench)SQL Database Fundamentals (Part 1)Once we have our tools installed, we'll quickly review some database fundamentals and begin to explore the 16 tables contained within our MySQL database, containing information about Maven Movies customers, inventory, and transactions. Analyzing Data from Single Tables with MySQLIn 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 for analysis and business intelligence.[MID-COURSE MYSQL PROJECT]SQL Database Fundamentals (Part 2)The second half of the course is all about anayzing data from multiple tables in MySQL, so we'll begin with a quick review of relational databases, data modeling and database analysis: primary vs. foreign keys, relationship cardinality, normalization, etc.Analyzing Multiple Tables via MySQL JOINSIn 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.[FINAL MYSQL PROJECT]IMPORTANT NOTE: This course does NOT cover building, altering, or maintaining SQL/MySQL databases. Our goal here is to focus on data exploration and database analysis using MySQL and MySQL Workbench (we'll cover database administration tools in a separate course).______________________________Enroll today and get LIFETIME access to:5+ hours of high-quality videoDownloadable MySQL ebookQuizzes and homework assignmentsMid-course and Final SQL projects30-day money-back guaranteeIf you're looking for a hands-on, practical guide to mastering data analysis with SQL/MySQL, this is the course for you!Happy analyzing!-John (Lead SQL Instructor & MySQL Expert, Maven Analytics)______________________________Looking for the full business intelligence stack? Search for "Maven Analytics" to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!See why this is one of the TOP RATED SQL/MySQL Courses on Udemy:"Clear presentation of information and with enough repetition of important SQL concepts to help make the information memorable. Loved the frequent practice examples and code debugging exercises!"- Maggi M."I totally loved this course! Everything was very easy to understand, but it moved at a fast enough pace that I never got bored. I learned SO much about MySQL and had fun doing it. In fact, at the end of the day I didn't want to stop learning - I wanted to keep charging on to the next lesson!"- Ann S."John's deep understanding of SQL and database analysis and ability to explain those tools to a newcomer with 0 experience, is really unmatched. I've taken other SQL and MySQL courses and tried reading books, but this course is by far the easiest way to understand SQL. Excited to see more courses from John!"- Steven M.
