Data Science Resources
Gain and improve your data science skills and knowledge on Python, R, VBA, SQL, etc. to impress your future and current employer. Whether you are a beginner data scientist with little to no programming experience or an advanced data scientist looking for a challenge, these resources are for you.
This online course offers a book as well as informative videos that go over the basics of Python. Learn how to use Python to write programs and explore a rich library of modules for performing specific tasks such as scraping websites, and automating clicking and typing tasks.
This 100 minute course provides everything you need to know to get started with Python, along with a few incentives. It begins with the basics of Python, learning about strings, variables, data types, and later discussing file manipulation and functions. By the end of this course, you will know how to write your own scripts and functions using Python.
This course teaches the fundamental programming concepts in R including how to organize, modify and clean data frames, and create data visualizations to showcase your insights with the data! You will also further learn how to use statistical analysis and hypothesis testing to enhance your data analysis skills.
Python
This 25-hour course teaches fundamental Python concepts that can be used to create programs. Some of the few topics include: Python Syntax, Strings and Console Output, Conditionals and Control Flow, Functions, Loops, Lists and Dictionaries, and many more.
This course aims to teach the basics of programming computers using Python. It covers how to install Python and write a program; it goes through the Python programming language and how to use variables to store, retrieve and calculate information; as well as it explains how to utilize core programming tools, such as functions and loops.
This site offers multiple Python challenges with ranging difficulty levels from Easy, Medium, and Hard. It’s an excellent tool will tons of word problems to test out your knowledge in Python and to enhance your programming skills.
This website offers a variety of Python lessons for beginners as well as advanced users. Gain skills and knowledge from various tutorials, including the “Learn the Basics” tutorial, Data Science Tutorials, and the Advanced Tutorials, or even navigate through the website to learn skills that can be applied to the workplace.
This site contains coding problems with ranging difficulty levels from Easy, Medium, and Hard. It’s an excellent tool to test out your knowledge in Python and to enhance your critical thinking in programming skills. There are daily challenges and weekly calendars to help keep you on track of your learning process throughout.
This introductory course focuses on Python for data science and explores topics such as data manipulation and storage, along with various data science tools for analysis. The course breaks down these topics into chapters such as: beginner basics, lists, functions/packages, and scientific computing with NumPy.
R
An introduction to the basic statistical concepts and R programming skills necessary for analyzing data in the life sciences. Learn the basics of statistical inference in order to understand and compute p-values and confidence intervals, all while analyzing data with R code.
This online book is a great resource to learn how to use R and some best practices to follow when cleaning data and drawing plots. Learn how to manage resources while wrangling, visualizing, and exploring data. Witten by Hadley Wickham and Garret Grolemund.
W3schools is a training hub that teaches all of the aspects that make up the R coding language. It’s a great resource for R tutorials and further information on data structures, graphics and statistics. It also includes: step by step instructions, numerous examples and “Try it Yourself” problems every step of the way!
This online platform will help you learn how to install and configure the software necessary for a statistical programming environment. This course covers practical issues in statistical computing, including programming in R, reading data into R, accessing packages, writing functions, debugging, profiling, organizing, and commenting R code.
This course aims to help you master the basics of data analysis in R. Featured topics include: vectors, matrices, factors, data frames, and lists. R is important for data science and statistical analysis, making it one of the most popular programming languages to learn.
Visual Basic Applications (VBA)
This 10 week online course will teach you the fundamentals of computer programming using VBA language in Microsoft Excel. This course goes through the logic of programming, which can help you understand other computer languages. Upon completion, you will be able to write your own programs in the VBA language!
This site provides multiple lessons on VBA. Each lesson becomes more difficult, however more skills will be acquired along the way. Lessons go over topics such as variables, conditions, loops, procedures and functions, arrays and many more.
This is a beginners programming course. Learn how to create macros and put yourself ahead of the competition by upgrading your Excel skills. This course walks you through the very basics of programming and is perfect for those who have little to no experience in this area.
Structured Query Language (SQL)
Mode offers SQL Tutorial lessons ranging from 3 different levels of experience (Basic, Intermediate, and Advanced). So whether you have experience with SQL or no prior coding experience at all, this resource is definitely helpful for those wanting to brush up on their SQL knowledge.
HackerRank is a great place to put your SQL skills to the test and improve your coding skills. This site offers various problem sets that many employers use to identify the best talent and to test your technical skills. The questions vary from easy-hard difficulty with immediate feedback and online discussion boards for each question.
Learn the fundamental concepts of SQL and how to retrieve data stored from a database, as well as how to write and make use of SQL queries. This course covers concepts of entity, database schema, table, record, association and so much more! It provides examples, exercises and worked solutions throughout each lesson.
This course familiarizes you with the SQL language and different databases such as PostgreSQL, and others. SQL is key in the field of data science as the main component of the role involves working with raw data to extract valuable information. Topics in this course include: selecting columns, filtering rows, aggregate functions, and sorting/grouping.
