|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/datascience-using-vba-programming-and-a-sql-database/
课程评论：没有评论
课程名称：使用VBA编程和SQL数据库的数据科学 课程概述：本课程旨在帮助学员顺利进入数据科学领域，掌握必要的编程知识和数据库使用技能。课程偏重于实践，结合成为数据科学家的理论基础。学员将学习微软的编程语言VBA（Visual Basic for Applications），并使用来自世界银行的真实数据。此外，课程还将教授如何使用结构化查询语言SQL（Structured Query Language）来填充、检索、清理和处理数据。课程内容包括对金砖国家（巴西、俄罗斯、印度、中国和南非）的国内生产总值（GDP）增长和人均GDP的比较分析，数据涵盖266个国家，时间范围从1960年到2020年，国家分为四个收入组和七个地区。课程包括自上而下的分析、回归分析、直方图等内容。 课程共分为六个章节： 第一章：数据科学和编程语言 讨论数据科学的组成部分、过程和工具，以及数据分析中的方法和数据科学家面临的挑战。同时介绍编程语言的概念、原则和术语，培养解决问题的编程技能，并介绍VBA的优势。 第二章：VBA的实际应用 讲解VBA的基础知识，包括声明变量、消息框和输入框、迭代循环、常用语句、ActiveX控件和数组。举例说明如何从网页中提取数据，并在课程中进行分析和展示。详细介绍了带按钮、组合框和列表框的实际应用编程及图表的使用。 第三章：SQL的实际应用 讨论数据库类型及其组成，详细介绍SQL（结构化查询语言）的基础知识。学员将开发数据库和表，学习如何使用VBA代码导入数据到SQL，并高效提取SQL表中的数据。课程还包括编写查询、合并表格及数据处理操作，以及编写和执行SQL程序。 第四章：数据的统计分析 聚焦于数据清洗和统计分析，重点使用经济学中的GDP和汇率数据进行描述性分析。 第五章：数据可视化 解释可视化的定义及其重要性，并通过实际示例演示数据可视化的技巧。 第六章：比较分析 详细讲解如何使用多个参数编写存储过程，并通过VBA执行它们。展示南非作为金砖国家中GDP增长和人均GDP增长的比较分析。 通过本课程，学员将获得进入数据科学领域所需的编程技能和数据库知识，提升其在实际工作中的应用能力。
This is the course that will help you walk right into a workplace as a data scientist with sufficient knowledge of programming and working with databases. This course has a very practical angle with the theoretical knowledge necessary to become a data scientist hitting the ground running. The programming language VBA (Visual Basic for Applications) of Microsoft is taught with real data obtained from the World bank. You will also learn how to populate, retrieve, clean and manipulate data using a relational database tool called SQL (Structured Query Language), Including in the course is comparative analyses of GDP (Gross Domestic Product) growth and GDP per capita for the BRICS countries (Brazil, Russia, India, China and South Africa). There are 266 countries that can be used for any comparative analyses with years ranging from 1960 to 2020. The countries are classified into 4 income groups and 7 regions. Top down analyses, regression, histograms and many more are included in this course.The The course is divided into 6 chapters with sub sections.Chapter 1: DATA SCIENCE AND PROGRAMMING LANGUAGESThe components of Data Science, processes and tools are discussed. The approaches in data analyses are covered along with the challenges a data scientist face. Concepts, principles, and terminology of programming languages are covered. How to develop program solving skills is discussed. The programming language of Microsoft Excel called Visual Basic for Applications (VBA) along with its benefits is also covered.Chapter 2: VBA WITH PRACTICAL APPLICATIONSThe basics of VBA is discussed including declaring variables, message and input boxes, iterative loops, popular statements, ActiveX Control boxes and arrays. An example is given to retrieve data from a webpage that will then be used throughout the course to analyse and present the data. Practical applications programming with buttons, Combo boxes and List boxes and graphs are covered in detail.Chapter 3: SQL WITH PRACTICAL APPLICATIONSTypes of databases are discussed as well as its components. The basics of SQL (Structured Query Language), a powerful programming language which is used for communicating with and extracting data from databases are covered in detail. The learner will develop a database and tables, work with Views and import data into SQL using VBA code. Extract data using VBA code from a SQL table. Write queries, join tables and learn to manipulate data. Writing procedures in SQL and executing them are also included.Chapter 4: STATISTICAL ANALYSES OF DATAData cleansing and statistical analyses are covered focusing on descriptive analyses using economic Gross Domestic Product (GDP) and exchange rate data.Chapter 5: VISUALIZATION OF DATAWhat and why visualizations along with practical examples of data visualisation are illustrated.Chapter 6: COMPARATIVE ANALYSESWriting stored procedures using more than one parameter and executing them using VBA are explained in detail. Comparative analyses of South Africa as part of the BRICS (Brazil Russia India China and South Africa) countries are done on GDP growth and GDP per capita growth is demonstrated.
