There are tons of great resources all over the internet. I've bookmarked hundreds of URLs and this page is my categorized collection of the references and free tools I've found to be helpful. If you're reading this and have something to add or find a dead link please send me a note. I'm continuing to add to this over time.
Analytics/Data Visualization | API Services | Career Management | Cloud Computing | Computer Science/Programming | Data Engineering | DataOps | Data Science/Machine Learning | Datasets | Website Tools
Apache Superset is a modern data exploration and visualization platform that is fast, lightweight, intuitive, and loaded with options.
An awesome curated list of dbt resources.
Google Data Studio
Free product lets you connect to all your marketing data and turn that data into beautiful, informative reports that are easy to understand, share, and fully customizable.
Hyperquery is a collaborative workspace for analytics. You can write SQL queries and consolidate your data context, automatically mapped from your favorite data tools such as Snowflake, Looker, Fivetran, Segment, and dbt. With Hyperquery, you can keep your documentation and business metadata in one place, so you can do your best work in analytics.
VisiData is an interactive multitool for tabular data. It combines the clarity of a spreadsheet, the efficiency of the terminal, and the power of Python, into a lightweight utility which can handle millions of rows with ease.
API Services[return to top]
Add high performance files and documents conversion to your website, web, or desktop application.
Google Analytics Query Explorer
This tool lets you play with the Core Reporting API by building queries to get data from your Google Analytics views (profiles). You can use these queries with any of the client libraries to build your own tools.
GraphQL is a query language for your API, and a server-side runtime for executing queries by using a type system you define for your data. Learn about GraphQL, how it works, and how to use it in this series of articles.
How to design a RESTful API architecture from a human-language spec
A three-post series that teaches RESTful API design to solve users’ needs with simplicity, reliability, and performance.
API for accessing current weather data for any location including over 200,000 cities.
This free Chrome extension allows developers to explore, test, and build APIs using a powerful collaborative testing and development suite.
Categorizes different APIs scoured from the web which make their resources available for public consumption.
https://github.com/public-apis/public-apis | or | github.com/abhishekbanthia/Public-APIs
Enables developers to find, test, and manage API integrations from one place and provides real-time performance metrics.
Technical documentation for RESTful web services with references and language-specific examples.
What is a REST API?
Thorough overview on what REST APIs are and how to use them.
Career Management[return to top]
3 Data Career Paths Decoded
Helpful article that compares and contrasts the role of a data analyst vs. data scientist vs. data engineer.
CodeFights - Practice for Technical Interviews
Technical interviews are tough. CodeFights, which is best known as a competitive coding and skill-based recruiting platform, helps developers practice for these interviews through a free platform that offers study topics and practice questions.
Coding Interview University
At a time where technology is outpacing the ability of many universities to update their course curriculum, many aspiring software engineers are seeking alternative forms of the education required to get a job. This is a popular complete computer science multi-month study plan to become a software engineer.
Data Flair Interview Questions
Frequently asked interview questions, by category. Each question is accompanied by answers shared by industry experts.
Data Glossary by Airbyte
A single place for all data knowledge. Instead of aligning all glossary terms in a single level, this site utilizes a digital garden approach that lets you go inwards. You can learn about each data term and go deeper into each of its connections. The glossary will show you each link that is related via an interactive visual graph that depicts all backlinks. glossary.airbyte.com
This repository contains a set of charts demonstrating different paths to take and technologies to adopt in order to become a front-end, back-end, or dev-ops engineer. While it seems a bit overwhelming in the beginning, it is a useful guide for what’s possible and needed in this fast-changing industry. The repo gets updated every year to reflect changes in the ecosystem.
A Computer Science portal for geeks. It contains computer science and programming articles, quizzes, and practice/competitive programming questions. It also has a large database of company-specific interview questions.
Free portfolio site that allows developers to easily feature projects from their GitHub repositories.
Google Cloud Certification - Data Engineer
A Google Certified Professional - Data Engineer enables data-driven decision making by collecting, transforming, and visualizing data. To earn this certification you must pass the in-person exam. This webpage offers a collection of useful training resources and reference materials aimed at achieving this certification.
HackerEarth is a network of top developers across the world. Developers participate in online coding challenges and hackathons, solve problems and discover the best jobs.
Join over 2 million developers in solving code challenges on HackerRank, one of the best ways to prepare for programming interviews.
At some point in your professional coding career, you’re going to feel stupid when you forgot some simple term. Hackterms is a crowdsourced dictionary of coding terms and serves as a sort of wiki for coding language. Programming is full of jargon and self-inflicted nomenclature wounds. Hackterms helps by returning plain-speak explanations for these.
IBM Certified Data Engineer - Big Data
This certification is intended for big data engineers. To attain IBM Certified Big Data Engineer status, candidates must pass one test.
Learn and Practice on almost all coding interview questions asked historically and get referred to the best tech companies.
Free practice programming interview questions. Interview Cake helps you prep for interviews to land offers from your dream companies.
Interviewing.io is a platform where people can practice technical interviewing anonymously with engineers from top companies.
Learn To Code
Programming and computer science are becoming more popular than ever. As a result, there are an increasingly huge number of resources and tutorials being produced for beginners who want to learn to code, ranging from books to online tutorials to interactive websites to massive open online courses (MOOCS). This can be overwhelming for beginners – there are almost too many resources available, and it’s difficult to figure out where to start. This page offers a curated list of resources for both new developers and developers looking to advance their skills and learn a new language/framework.
Level up your coding skills and quickly land a job. This is a good place to expand your knowledge and get prepared for your next interview.
Mastering SQL Queries
Practice easy, medium, and hard SQL interview questions.
Practice mock interviews and coding questions online, with peers, for free. Great practice for preparing for interviews and ultimately landing your dream tech job.
Undoubtedly you’ve heard about the skills gap challenges in the U.S. economy. Using select data from LinkedIn and [email protected]’s proprietary analysis, the [email protected] Skills Index takes a look at supply vs. demand around specific skill sets across top industries and provides actionable recommendations for getting up to speed.
StackShare provides online software for displaying and sharing your technology stack, which is made up of the software that you use. It’s an online community that features comparisons, ratings, reviews, recommendations, and discussions of the best software tools and software infrastructure services.
For developers, this site offers public technical tests and practice interview questions. If you score well you can get free certificates to display on your online profiles.
Things You Need to Know in a Programming Interview
This article covers general tips on how you, the interviewee, can impress your interviewer during a coding session and land your dream job.
Cloud Computing[return to top]
AWS Explained: The Basics
A nice introductory primer for getting started in AWS and cloud computing in general.
AWS Tutorial for Beginners
AWS (Amazon Web Service) is a cloud computing platform that enables users to access on demand computing services like database storage, virtual cloud server, etc. This online course will give an in-depth knowledge on EC2 instance as well as useful strategy on how to build and modify instance for your own applications.
Computer Science/Programming[return to top]
A curated list of delightful VS Code packages and resources.
Beginner’s Resources to Learn Programming Languages
This blog post details some important programming languages and offers numerous links for learning more about each.
A curated collection of tutorials and free learning resources for learning to code in new languages.
Big-O Notation Cheat Sheet
This webpage covers the space and time Big-O complexities of common algorithms used in Computer Science.
Create and share beautiful images of your source code.
Free site lets you share your code with others in CodeEnv online environments. Good for teaching, prototyping, and sharing fiddles.
Offers programming problems and lessons for challenging yourself to get to become a better coder.
Great collection of resources for exploring different careers in tech.
A specification for adding human and machine readable meaning to commit messages.
CS Algorithm Notes
Set of CS lecture notes, which you can use to teach yourself algorithms.
CS Playground React
Offers sandbox environments for developers to play around with and modify live sample code for all kinds of languages. It’s also easy to share or demonstrate solutions to problems.
Git Branching Model
This post outlines a development model for git branching strategy and release management.
Git Cheat Sheet
Handy visual reference for commonly used git version control commands.
GitHub Repository Structure Best Practices
Best practices for organizing repositories for better team contribution and more elegant project structure.
Gitignore: A Collection of .gitignore Templates
This repository is exactly what the name suggests: a collection of useful .gitignore templates. For every new project you set up as a GitHub repository, it becomes mandatory to have a .gitignore file to filter what gets uploaded. The repo contains templates for almost any language or framework.
Intro to Computer Science Terminology
A complex definition: Computer Science is the study of information technology, processes, and their interactions with the world.
Code faster in Python with intelligent snippets - Kite is a plugin for your IDE that uses machine learning to give you useful code completions for Python.
Learn Code The Hard Way
Learn Code The Hard Way courses are an effective system for learning the basics of computer programming, designed specifically for complete beginners.
Learn to Code From Home
Learning to code can be daunting, but you can do it at your own pace from the comfort of your own home. Thanks to dedicated programmers who have put time and energy into creating free online walkthroughs and guides to various programming languages, there are plenty of free resources right at your fingertips that offer hands-on activities and general overviews for beginner coding projects and advanced tasks.
A huge selection of cheat sheets for almost any current programming language and other technologies.
Project Euler is a series of challenging mathematical/computer programming problems that will require more than just mathematical insights to solve. Although mathematics will help you arrive at elegant and efficient methods, the use of a computer and programming skills will be required to solve most problems.
Python Challenge is a game in which each level can be solved by a bit of (Python) programming. It’s a good way to practice through solving riddles.
Python Cheat Sheets
A collection of popular Python cheat sheets.
Python Tutorial Notebook
Comprehensive Python tutorial notebook 📒👨💻 to get an in-depth understanding of Python coding.
Real Python: Python Tutorials
Learn Python online: Python tutorials for developers of all skill levels, Python books and courses, Python news, code examples, articles, and more.
Rosetta Code Programming Tasks
Offers over 800 problems that can be solved through programming in different languages. Great for practice.
Teach Yourself Computer Science
If you’re a self-taught engineer or bootcamp grad, you owe it to yourself to learn computer science. This guide offers the nine subjects you should learn with the best book or video lecture series for each subject. Ideally this list can be revisited throughout your career.
Topcoder is a company that administers contests in computer programming, through which prize money can be won. Competition aside, this site also offers regular challenges and matches through which you can learn new skills and hone skills you already have.
Data Engineering[return to top]
5 Data Engineering Projects To Add To Your Resume
One of the best ways to develop and refine data engineering skills is through real-world portfolio projects. In this article, SeattleDataGuy reviews five potential project ideas with accompanying data sources.
7 Steps to Understanding NoSQL Databases
The term NoSQL has come to be synonymous with schema-less, non-relational data storage schemes. NoSQL is an umbrella term, one which encompasses a number of different technologies. This article provides newcomers an overview of NoSQL technologies and architectures it includes.
Airflow for Beginners
Introduced by Airbnb, Airflow is a platform to schedule and monitor data pipelines. This article overviews the basic setup to run Airflow including an example use-case.
Around Data Engineering
This actively-maintained GitHub repository details the never-ending journey of learning around data engineering and machine learning.
Convert plain english to RegEx with Natural Language Processing.
Awesome Data Engineering
A curated list of data engineering tools for software developers.
A curated list of awesome pipeline toolkits.
Beginner’s Guide to Big Data Terminology
Walkthrough on some of the common lingo of big data, such as DaaS and Neural Networking.
Complete Data Engineer’s Vocabulary
Comprehensive A-Z list of different data engineering concepts and technologies with brief summaries and embedded links to learn more information.
Conduktor is the ultimate Apache Kafka desktop client for performing regular Kafka administration and development tasks.
Data Engineering Cookbook
The Data Engineering Cookbook (124 pages) - Mastering The Plumbing Of Data Science - Andreas Kretz.
Data Engineering Open Source Coursework
UC Berkeley published its spring 2021 data engineering course slides and resources. It is excellent learning material for data engineering practitioners.
Data Engineering Practice Problems
One of the main obstacles of Data Engineering is the large and varied technical skills that can be required on a day-to-day basis. This aim of this repository is to help you develop and learn those skills.
Free multi-platform database tool for developers, SQL programmers, database administrators, and analysts. Supports all popular databases: MySQL, PostgreSQL, MariaDB, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby, etc.
How to Become a Data Engineer
This article outlines helpful considerations if you’re interested in pursuing a career as a data engineer such as required skills, typical responsibilities, and career outlook.
Introduction to Apache Airflow
Apache Airflow is hot right now and if you’re interested in learning about it from a high-level, this a nice ‘intro’ guide.
Kafka for Beginners
Apache Kafka is used for enabling communication between producers and consumers using message-based topics. Apache Kafka is a fast, scalable, fault-tolerant, publish-subscribe messaging system.
A nice intro guide on what these are and why they are used.
Working with some messy address or name data? It helps to split each one into separate components. Parserator is a framework for making parsers using natural language processing (NLP) methods.
This page tries to collect the libraries for the queueing systems (job, messaging, etc.) that are widely popular and have a successful record of running on (big) production systems.
Self-Study List for Data Engineers and Aspiring Data Architects
With the explosion of “Big Data” over the last few years, the need for people who know how to build and manage data-pipelines has grown. This article takes a look at the sought after job skills for these areas and how you can go about learning these.
SQL Cheat Sheet
In this guide, you’ll find a useful cheat sheet that documents some of the more commonly used elements of SQL, and even a few of the less common.
SQL Query Optimization Techniques
Tips for writing faster and more efficient SQL queries
SQL vs NoSQL — What is better for you?
Important considerations when choosing a relational (SQL) or non-relational (NoSQL) data structure for your project architecture.
SqlDBM - SQL Database Modeler
SqlDBM offers you an easy, convenient way to design your database absolutely anywhere on any browser, working away without need for any extra database engine or database modelling tools or apps.
Stream Processing 101: From SQL to Streaming SQL in 10 Minutes
We have entered an era where competitive advantage comes from analyzing, understanding, and responding to an organization’s data. When doing this, time is of the essence, and speed will decide the winners and losers. This blog post introduces technologies we can use for stream processing.
This converter is used to convert various flat file data formats into markdown tables or SQL insert statements.
Three Questions to Help You Prepare for a Data Engineering Interview
Data engineering requires a combination of knowledge, from data warehousing to programming, in order to ensure the data systems are designed well and are as automated as possible. The question is: How do you prepare for an interview for a data engineering position?
Transactional vs. Analytical Processing
Good cross-comparison between OLTP and OLAP systems.
What Does a Data Engineer / Data Architect Do?
This post explores the path of becoming a data engineer / big data architect.
What Is Big Data?
Analyzing lots of data is only part of what makes big data analytics different from previous data analytics. This article delves into what those other aspects are.
What Is ETL?
ETL is shorthand for the extraction, transformation, and loading process used in most data movement operations. This article provides a nice overview for those wanting to understand the basics around these phases.
DataOps[return to top]
Find, understand, and use your data assets. With Castor, your data is well documented and discoverable by everyone in your team.
Through firsthand experience working with data across organizations, tools, and industries a group of professionals have uncovered a better way to develop and deliver analytics through an emerging practice called DataOps.
Dolt for Data Version Control
Dolt is the true Git for data experience in a SQL database, providing version control for schema and cell-wise for data, all optimized for collaboration. With Dolt, you can view a human-readable diff of the data you received last time versus the data you received this time. You can easily see updates you did not expect and fix the problem before you deploy the new data.
Monte Carlo for Data Observability
Monte Carlo is on a mission to accelerate the world’s adoption of data by minimizing data downtime. The platform brings full observability to data teams by monitoring, alerting, resolving, and preventing data quality issues, helping them achieve data reliability.
Soda’s data observability platform offers data quality monitoring & a testing framework. It allows your team to detect silent issues early, insert anomaly detection, and involve team members to ensure data quality is communicated.
Data Science/Machine Learning[return to top]
Best Practices for ML Engineering
This guide is intended to help those with a basic knowledge of machine learning get the benefit of best practices in machine learning. If you have taken a class in machine learning, built, or worked on a machine-learned model, then you have the necessary background to read this document.
Data Mining in Python: A Guide
Data mining is the process of discovering predictive information from the analysis of large databases. This guide provides an example-filled introduction to data mining using Python, one of the most widely used data mining tools - from cleaning and data organization to applying machine learning algorithms.
Efficient Python Tricks and Tools for Data Scientists
Interactive web book written by Khuyen Tran that teaches readers efficient methods of coding in Python to solve common problems in data science.
Foundations of Machine Learning
This training course offered through Bloomberg covers a wide variety of topics in machine learning and statistical modeling. The primary goal of the class is to help participants gain a deep understanding of the concepts, techniques and mathematical frameworks used by experts in machine learning. It is designed to make valuable machine learning skills more accessible to individuals with a strong math background, including software developers, experimental scientists, engineers, and financial professionals.
Handy Python Libraries for Formatting and Cleaning Data
Data scientists spend a lot of time cleaning messy data. This is a list of Python libraries that help make data more orderly and legible - from styling DataFrames to anonymizing datasets.
Offers a means of learning data science through both public and private competitions.
This website looks like its design hasn’t changed since the 90s, but it is home to lots of great content on business analytics, big data, data mining, and data science.
R or Python for Data Science?
This is a nice blog post on opendatascience.com that digs into the differences/advantages of using either R or Python for performing data science tasks.
Regular expressions are extremely useful in extracting information from text such as code, log files, spreadsheets, or even documents. This site offers an interactive tutorial and practice exercises to help you learn them.
Open source R packages that allow access to data repositories and provide programmatic access to a variety of scientific data and other real-time metrics of scholarly impact.
TensorFlow is a machine learning library that underlies many of Google’s products. With this playground site, you can tinker with a neural network right in your browser.
Datasets[return to top]
Appen AI Resource Center
Collection of free, downloadable, and categorized datasets that have been created and curated for teams working on world-class AI applications.
This GitHub repo contains a list of a topic-centric public data sources in high quality. They are collected and tidied from blogs, answers, and user responses.
AWS Registry of Open Data
This registry exists to help people discover and share datasets that are publicly available via AWS resources.
Data.World: The Social Network for Data People
Discover and share cool data, connect with interesting people, and work together to solve problems faster. Users can find and use a vast array of high-quality open data.
Gapminder fights devastating misconceptions and promotes a fact-based worldview everyone can understand. Many of their datasets around how the world lives have been many publicly available for download.
The largest video game database online, Giant Bomb features reviews, news, videos, and forums for the latest games on all major platforms.
Google Dataset Search
Free tool for searching over 25 million publicly available datasets. The search tool includes filters to limit results based on their license (free or paid), format (csv, images, etc), and update time. The results also include descriptions of the dataset’s contents as well as author citations.
Google’s My Activity Page
This portal reveals everything Google knows about you - every search you’ve made, the apps you’ve used, the videos you’ve watched, and everything in between. Visit to see how your data is being collected, modify activity settings, and delete data that you prefer not retained.
Website Tools[return to top]
Experte Bulk Page Speed Test
This tool allows you to test hundreds of URLs automatically. All you have to do is enter a URL and the tool crawls the website and determines the page speed scores for each subpage.
Font Awesome makes it easy to add vector icons and social logos to your website.
Google Design: Resizer
An interactive viewer to see and test how digital products respond to material design breakpoints across desktop, mobile, and tablet.
How To Use GitHub Pages To Make Websites
Step-by-step tutorial to getting started with building a website hosted on Github Pages.
HandleFinder is a powerful tool that can be used to find usernames across many social networks. This project is a wrapper around the Sherlock Project.
How to Host Your Static Site with HTTPS on GitHub Pages and CloudFlare
While GitHub offers free static website hosting and custom domain support, it is currently not possible to configure HTTPS for custom domains directly through GitHub Pages. This is where CloudFlare comes in.
Lighthouse is an open-source, automated tool for improving the quality of web pages. You can run it against any web page, public or requiring authentication. It has audits for performance, accessibility, progressive web apps, and more.
Mobile Website Speed Testing Tool
Another great Google product. Find out how well your site works across mobile and desktop devices by simply entering the URL.
Static Site Generators
A leaderboard of the top open-source static site generators based on Github stars.
Free online tool that grades any website against key metrics such as performance, mobile readiness, SEO, and security.
Who Is Hosting This
Allows a user to simply enter the domain name of any site and instantly uncover the identity of the company that is hosting the site.