In the realm of relational databases, schemas define and organize data structures and relationships. While SQL Server and PostgreSQL use schemas as logical containers within databases, Oracle intertwines schemas with user accounts, and MariaDB/MySQL equates schemas to databases themselves. Read on to learn more. Continue reading →

Here are summaries of each of the tools you’ve mentioned along with examples of how to implement the ETL (Extract, Transform, Load) process using each tool within a Python workflow: Continue reading →

Data modeling is the systematic process of defining the structure, relationships, and constraints of a database. Through entity-relationship diagrams, it captures entities, attributes, and connections to mirror real-world scenarios. The resulting design ensures data accuracy, enhances query efficiency, and supports decision-making by transforming complex information into a structured and accessible format. Continue reading →

Starting to use, or interested in using MariaDB? This is a getting started post that will get you started with MariaDB and SkySQL. Prerequisite knowledge of SQL is helpful, but I step through every single little detail in this post to get you up and running, with a good context of what you’re getting. Continue reading →

Some top database providers for various open source databases like MariaDB, PostgreSQL, MongoDB, Apache Cassandra, Redis, Elasticsearch, and Neo4j: Continue reading →