5 Best Public Datasets to Practice Your Data Analysis Skills
Hone your SQL data analysis skills with these five publicly-available datasets
a year ago
Igor Bobriakov
Igor is an entrepreneur and educator with a background in marketing and data science. His passion is to help small businesses and startups to utilize modern technology for growth and success.
Three ways to import data into Postgres
If you're working with Postgres, you might need a way to get your data into your database. Here's approaches you can use.
a year ago
ER Diagrams vs. ER Models vs. Relational Schemas
This article will explain the differences between ER models, ER diagrams, and relational schemas. We'll look at how they're similar and what makes them different.
a year ago
Querying Shopify Data in Postgres
How to extract data from your Shopify store, load it into Postgres, and query it for more meaningful insights on your store's performance.
2 years ago
Advanced PostgreSQL Features: A Guide
Learn how to take advantage of advanced PostgreSQL features such as inheritance, nonatomic columns, and more in order to get the most out of your data.
2 years ago
What is The Difference between 2NF and 3NF?
Database Normalization is crucial for optimizing the usage of system storage and resources. This article explains the differences between DBMS normal forms (2NF and 3NF) with a simple example.
2 years ago
Featured
public
Analysis
Tackling Gender Bias Using Analytics
Using SQLite and Arctype visualizations to explore a US Bureau of Labor Statistics dataset with the goal of learning more about the gender wage gap.
2 years ago
Featured
public
Architecture
Build a Simple CRM Database Model
The sales process of companies is managed by CRM database software. In this post we model the customer relationship and create an ER diagram of it.
2 years ago