Database Design - Learn Data Science with Travis

Travis chat

Good Database Design Starts Here

Towards Data Science

Rules to follow when you start a new database project: usage, model selection, process and testing.

Database Design Considerations — Questions answered

Analytics Vidhya

Database design can be a tricky and laborious project and is often associated with stringent timelines. Below are some questions that you need to have answered before starting a database design…

SQL Database Design Basics with Example

Towards Data Science

It is a common practice that a DB architect has to design a relational database tailored to a particular solution. One Friday evening, I was coming home from work on a commuter train, and I was…

A Crash Course on Relational Database Design

ByteByteGo Newsletter

In today's data-driven world, efficient storage and management of information are critical requirements for businesses and organizations of all sizes. Relational databases provide a robust framework f...

Designing Database Storage and Retrieval

Towards Data Science

Database is an integral part of any application design where processes store and manage data. Although, one may never need to design a database from scratch but understanding its design and how…

Database Design and Creation: MySQL Workbench

Towards Data Science

It is always risky to manage data from different files. It often leads to creating inconsistencies. An organization cannot track its business activities efficiently by maintaining thousands of files…

Principles of Database Schema Design

Level Up Coding

How to design database schemas in distributed systems, in SQL and No-SQL databases, taking into account processes, databases, entities and queries.

System Design Fundamentals: Relational Databases

Level Up Coding

A brief look into relational databases Continue reading on Level Up Coding

How To Design A Relational Database Schema

Level Up Coding

Designing a Database Using Spotify Data Continue reading on Level Up Coding

Designing your database schema — best practices

Towards Data Science

Good database schema design is essential for any company leveraging relational database management systems. If time isn't spent designing a logical and intuitive database schema now, it will be spent…...

Database Concerns in Large System Design

Level Up Coding

While we design a large scale system, the database is one of the core parts we have to take into consideration. Designing the table scheme is not just what we are looking for. We may have to spend…

Practical SQL: Designing and Creating a Relational Database

Towards Data Science

SQL is a programming language that is used by most relational database management systems (RDBMS) to manage data stored in tabular form (i.e. tables). A relational database consists of multiple…

Coding and Implementing a Relational Database using MySQL

Towards Data Science

This is part 2 of a 3-part series taking you through the process of designing, coding, implementing and querying a relational database, starting from zero. See part 1 (Designing a Relational Database…...

Designing a Relational Database and Creating an Entity Relationship Diagram

Towards Data Science

This is part 1 of a 3-part series taking you through the process of designing, coding, implementing and querying a relational database, starting from zero. See part 2 (Coding and Implementing a…

Database Normalization

Towards Data Science

“Data” is at the core of every software application. Hence, the success and usability of any software are highly dependent on how the data has been organized. There can be multiple ways to organize…

Databases: Fundamentals of SQL

Towards Data Science

This post by no means can completely cover every aspect of SQL functionality, however, I’m attempting to create a quick reference guide that provides the practical aspect of SQL and shows important…

Which database shall I use?

ByteByteGo Newsletter

Which database shall I use? This is one of the most important questions we usually need to address in a system design interview. Choosing the right database is hard. Google Cloud recently posted a gre...

System Design Interview: Mastering Databases

Level Up Coding

When it comes to system design interviews, understanding the intricacies of databases is paramount. If you’re gearing up for such an interview and you’re scratching your head over databases, you’ve co...

A Simple Database

Object-oriented Programming in Java

The document provides information about implementing a simple database of employee records using an array. It includes a template for creating employee record objects, along with details about the Emp...

Choosing a Database Technology:

Towards Data Science

Helping Data architects choose the right Database technology - storage engine and processing engine. Relational, right tool for right application, NoSQL, Cloud Platform, all choices are to be consider...

Choosing the right Database

Towards Data Science

Based on various factors like structure, query pattern, data format, scalability requirements, etc how would you decide the most suitable database?

How to Design a Clean Database

Level Up Coding

No matter what kind of developer you are, every once in a while, we come across an API which returns data in such a way that we don’t have to spend much time understanding it. But generating this…

Designing data storage

Software Architecture with C plus plus

Let's now discuss the storage for your application. First let's decide whether you should go with SQL, NoSQL, or something else. A good rule of thumb is to decide on the technology according to the si...

Intro to SQL Schemas & Normalization

Towards Data Science

Hi there! Welcome to the 4th instalment of a series of tutorials on SQL and SQL Server Studio. There’s a simple goal: To make you familiar and comfortable with the tool, and the language. “Why does…