Data Science with VBA Programming and SQL Database Management
Datascience, Data Analysis, Programming, SQL, Databases
Updated on Sep, 2023
Language - English
The purpose of the this datascience course is to make it as practical as possible therefore the emphasis in this course is to teach Data Science through a case study with hands-on and practical learning. As such, the case study is based on financial GDP data and other data downloaded from the World bank website for numerous countries from 1960 through to 2020.
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 course starts with learning about the concepts, principles, and terminology of programming languages and how to develop program solving skills. It then covers what datascience is, its components and why and where it is used.
Visual Basic for Applications (VBA) is introduced. The Worldbank data will be imported into excel. You will learn how to program and write your first program using the very handy buttons supplied in the ActiveX tab of the Developer module.
To be a good Data Scientist, you should have some knowledge on databases specifically about SQL (Structured Query Language). Many interview questions of Data Science start with SQL queries. Therefore, SQL is essential for Data Science. Many beginners who are trying to get into Data Science but, worried about coding, start with SQL queries. You will also learn how to populate, retrieve and manipulate data using the relational database tool SQL .
Descriptive statistics are covered as well as correlation and regression. The what and why of visualizations are covered along with the different types. Practical examples are given throughout the course. Included 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.
What will you learn in this course:
- Datascience, its components along with the concepts, principles, and terminology of programming languages and how to develop program solving skills.
- Learn and practice to write an application in a Microsoft programming language (VBA) along with the use of the ActiveX buttons
- Install SQL, create a database and tables. Load Case Study into tables using VBA.
- Load the GDP data case study into the SQL database.
- Learn and practice the SQL language using Case Study data.
- Link to SQL from VBA and visualize data using ActiveX dropdown and command buttons.
- Statistical Analyses and write a View/Query linking tables in SQL.
- Data analyses and visualization including correlation and regression.
- Write a stored procedure in SQL comparing and visualizing GDP per capita for different countries and different income groups.
What are the prerequisites for this course?
- This course is for any beginner keen to upskill him/herself in data science.
- You need a computer and have a Microsoft license as we will be working with Excel, VBA and the free Microsoft SQL data management tool.
Check out the detailed breakdown of what’s inside the course
Introduction to presenter
- Introduction to lecturer 02:55 02:55
Introduction and Course Outline
Chapter 1: DATA SCIENCE AND PROGRAMMING LANGUAGES
Chapter 2: VBA (Visual Basic for Application)
Chapter 3: SQL (Structured Query Language)
Chapter 4: STATISTICAL ANALYSES OF DATA
Chapter 5: VISUALIZATION
Chapter 6: COMPARATIVE ANALYSES
Dr Alida Herbst
Teaching and sharing knowledge as well as making life easier through automation of processes is her passion. She loves working with data and have used VBA, SQL, Python and Microsoft power BI extensively. Throughout her life I have numerous applications using SQL and VBA. She has worked at numerous financial institutions as a fund manager, researcher and data scientist. She started her career as a lecturer in statistics at a university in South Africa. She loves life and are passionate about everything she does. Her motto is to maximize life and go with the flow.
QUALIFICATIONS: PHD (Thesis: The statistical Modelling of Growth)
Recipient of two Governor’s Awards (2011, 2015) at South African Reserve Bank (SARB) and four Head of Department team awards.
Executive Development Senior Management Development program at University Stellenbosch,
Data science, Database (SQL) specialist and VBA expert.
Her business knowledge covers:
• Data science using python or r studio
• Database management, SQL;
• Business Intelligence, Power BI, Qlikview
• Risk Management (Market, Credit & Operational);
• Investment Management, institutional and retail as well as Performance and Attribution.
• Change Management
• Programming, VBA, C#, C++,Fortran, MATLAB, R, VB.net; Python
User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.
Our students work
with the Best
Related Video CoursesView More
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video CoursesSubscribe now
Master prominent technologies at full length and become a valued certified professional.Explore Now