|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-mysql-basics-for-data-science/
课程评论：没有评论
这是一门关于学习MySQL基础知识以应用于数据科学的课程。 **课程目标与价值：** * **提升解决问题能力：** 培养分析性思维，该能力对职业和日常生活都十分有益。 * **满足高需求：** 数据分析师和数据科学家需求量大且持续增长，掌握相关技能将增加职业价值。 * **数据分析无处不在：** 现代社会数据量庞大，各行各业都需要从数据中获取洞察来改进流程。 * **重要性日益增加：** 随着数据量的爆炸式增长，数据洞察对企业决策的重要性愈发凸显，为数据分析师创造更多就业机会。 * **技能广泛多样：** 数据科学领域融合了计算机科学、商业、数学等多个学科，并需要良好的沟通能力来解释复杂信息。 * **拓展职业领域：** 学习数据科学也可进入物联网和智慧城市等前沿领域。 **核心学习内容：** 本课程将教授MySQL的SQL语言基础，包括： * SELECT, INSERT, UPDATE, DELETE 语句 * ORDER BY, GROUP BY 子句 * Min, Max, Count, Sum, Average 等聚合函数 * LIKE 条件匹配 * JOIN (单表、双表、三表连接) * 创建数据表 * 处理NULL值 * 使用MySQL Workbench 此外，课程还将涉及： * 数据仓库基础 * 星型模式 (Star Schema) * 数据挖掘过程 * OLAP Rollup 操作 **先修或推荐课程（若追求SVBook Advanced Certificate in Software Development）：** 本课程是获得SVBook Advanced Certificate in Software Development系列认证的入门课程之一。该证书需要完成以下一系列编程基础课程并通过考试： * R编程基础 * Python编程基础 * C编程基础 * C#编程基础 * Java编程基础 * C#基础实践 **课程结构：** 课程内容涵盖MySQL的安装、卸载，数据库和表的操作，以及各种SQL查询语句和数据处理技术。
Why learn Data Analysis and Data Science?According to SAS, the five reasons are1. Gain problem solving skillsThe ability to think analytically and approach problems in the right way is a skill that is very useful in the professional world and everyday life. 2. High demandData Analysts and Data Scientists are valuable. With a looming skill shortage as more and more businesses and sectors work on data, the value is going to increase. 3. Analytics is everywhereData is everywhere. All company has data and need to get insights from the data. Many organizations want to capitalize on data to improve their processes. It's a hugely exciting time to start a career in analytics.4. It's only becoming more importantWith the abundance of data available for all of us today, the opportunity to find and get insights from data for companies to make decisions has never been greater. The value of data analysts will go up, creating even better job opportunities. 5. A range of related skillsThe great thing about being an analyst is that the field encompasses many fields such as computer science, business, and maths. Data analysts and Data Scientists also need to know how to communicate complex information to those without expertise.The Internet of Things is Data Science + Engineering. By learning data science, you can also go into the Internet of Things and Smart Cities. This is the bite-size course to learn MySQL for Data Science. You will learn the select, insert, update, delete, order by, and group by statements in SQL language. You will learn some data warehouse, star schema, use MySQL Workbench to create Star Schema, and data mining process, and OLAP Rollup. You can look at the following courses to get SVBook Advanced Certificate in Software DevelopmentSVBook Advanced Certificate in Software Development are given to people who have completed the following courses:- Create Your Calculator: Learn R Programming Basics Fast- Create Your Calculator: Learn Python Programming Basics Fast- Create Your Calculator: Learn C Programming Basics Fast- Create Your Calculator: Learn C# Programming Basics Fast- Create Your Calculator: Learn Java Programming Basics Fast- Create Your WebBrowser: Learn C# Fundamentals Practicallyand passed a 50 questions Exam. The six courses are created to help learners understand programming basics. The learner will be able to program R, Python, C, C#, and Java after the coursesContentInstall MySQLUninstall MySQLUninstall MySQL 2DatabaseCreate Tables from ERD in MySQL WorkbenchSelect StatementSelect DistinctSelect using OPerators and ConditionsAnd Or NotOrder ByInsert StatementCheck whether have null valuesUpdate StatementsDelete StatementsMin MaxCount Sum AverageLikeGroup ByJoin Two TablesJoin Two Tables 2Get Frequency Table with Join and Group ByJoin and Group By advanced Join 3 TablesJoin 3 Tables 2Star Schema BasicsData Warehouse BasicsData Mining ProcessROLAP ROLLUP Operation
