Category
Databases
7-Day Challenge
Land Your First Data Science Job
A proven roadmap to prepare for $75K+ entry-level data roles. Perfect for Data Scientist ready to level up their career.
Build portfolios that hiring managers love
Master the Python and SQL essentials to be industry-ready
Practice with real interview questions from tech companies
Access to the $100k/y Data Scientist Cheatsheet
Databases
2 min readHow to Read a Folder of CSVs in Python Using DuckDB
Explore the power of DuckDB, an efficient open-source analytical database system for processing large datasets. This post delves into reading a folder of CSVs using DuckDB in Python, demonstrating its advantages over traditional methods like Pandas.
5/30/2023Read More
Redis
1 min readHow to use Redis in Python
Learn how to use Redis in Python for faster, more scalable and flexible data storage with redis-py library, complete with example code and explanations.
3/3/2023Read More
Fundamentals
1 min read6 ways to efficiently store data in Python
Learn various ways to store data efficiently in Python, including relational databases, NoSQL databases, data serialization, data compression, and data containers like NumPy array and Pandas DataFrame.
2/13/2023Read More
SQLite
2 min readHow to retrieve data entries from SQLite3 using Python
How to retrieve data entries from an SQLite3 Database using the built-in sqlite3 library. An easy way to store data in a SQL-ready storage system.
8/5/2022Read More
SQLite
2 min readHow to add an entry to an SQLite database
Learn how to add an entry to an SQLite database using the execute() method.
8/5/2022Read More
SQLite
2 min readHow to use SQLite3 in Python
Learn how to use SQLite3 with Python using the built-in library sqlite3.
8/4/2022Read More
SQLite
2 min readHow to add a new table in SQLite3 using Python
Learn how to add a new table in SQLite3 using Python.
7/16/2022Read More
SQLite
5 min readHow to create an SQLite3 Database using Python
Learn how to create an SQLite3 database using Python.
7/16/2022Read More
Data
1 min readHow to install SQLite3 in Python
Learn how to install SQLite 3 in Python
7/16/2022Read More
Free Newsletter
Master Data Science in Days, Not Months 🚀
Skip the theoretical rabbit holes. Get practical data science skills delivered in bite-sized lessons – Approach used by real data scientist. Not bookworms. 📚
Weekly simple and practical lessons
Access to ready to use code examples
Skip the math, focus on results
Learn while drinking your coffee