Unit Testing vs QA When Creating ETL pipelines using SQL

Hello, everyone. I've always found the distinction between unit testing and QA testing when creating ETP pipelines using SQL to be a somewhat gray area, so I thought I would throw this into ChatGPT and see its response. One of the more important aspects I find when performing checks is to ensure you have proper … Continue reading Unit Testing vs QA When Creating ETL pipelines using SQL

ChatGPT: SQL as a Religion

I have noticed that ChatGPT is quite adept at refining my technical writing and providing insights for creative composition (and really horrible at answering SQL quiz questions). Recently, I came across individuals sharing their ChatGPT generated texts that create religions based on various subjects, so I thought it would be interesting to ask ChatGPT to … Continue reading ChatGPT: SQL as a Religion

Attributes, Fields, and Columns

In the context of databases, the terms attribute, field, and column are often used interchangeably, especially in relational databases. However, there are slight nuances in the way they're used within different contexts. Here, I create a blog post to quickly define the differences and nuances of these terms. If you are unfamiliar with ERD, Conceptual, … Continue reading Attributes, Fields, and Columns

Understanding Different Key Types in SQL

In the realm of database design, there are a total of twelve distinct keys to be taken into account. Primary, foreign, and unique keys are typically well-known among SQL developers, as they are implemented through SQL syntax and serve as constraints. However, when undertaking database design, it is important to consider additional key types that … Continue reading Understanding Different Key Types in SQL