As many of you know, my technical roots are in databases, SQL, and full stack web development. I’ve spent a lot of time creating videos on YouTube over databases. For example, I have a 51 part video series on Database Design. Who or What is freeCodeCamp? Recently I was reached out to by freeCodeCamp. For […]
Database Design
Intro to MongoDB
What is Mongo DB? MongoDB is an unstructured database that is becoming extremely popular for speed, ease-of-use, and scalability. The Problem with Structured Data Until now, the majority of the my content has covered relational databases. You communicate with a relational database using SQL (Structured Query Language). A relational database follows a structure defined by columns in a […]
Introduction to Indexes
This will be a blog dedicated to designing relational database indexes. By this I mean we will be discussing the important topics of indexing a database but we will not be programming any SQL. This is all part of database design. What is an index? Wow, such as awesome question! An index allows us to […]
Introduction to Database Normalization
Any time that you design a database you will have to use normal forms. Normal forms are steps used create the best database design. Good database design prevents non-scalar data. Non-scalar data is data that does not store only one value. Having non-scalar data violates the rule that everything should be atomic. Good database design […]
Cardinality and Modality
In the blog about designing binary relationships, I briefly described crow’s foot notation. Crow’s foot notation is a design technique that visually explains our relationship between tables. In order to understand crow’s foot notation, we must first understand the basics of database design. I recommend you read the previous blogs listed to familiarize yourself with […]
Designing Binary Relationships
We talked about relationships in the relationship blog. We talked a little about how to structure relationships in a database, but this blog will be dedicated to specifically that. One to One One to one relationships over multiple tables are not very common. This is because a one to one relationship can be stored in […]