SQL

Let’s look at some of the most basic questionnaires with examples. We will use SQLite… Read More »SQL (2) SELECT – Let's look up data

Now that we have a basic knowledge of database systems, let’s take a closer look… Read More »SQL (1) SQLite Studio installation and practice DB download

In the last article, we drew blueprints of approximate data with ERD. Now, it is… Read More »Database101 (4) logical data modeling and relational model

After analyzing the requirements that we’ve covered in the last article, we should design a… Read More »Database101 (3) Conceptual Data Modeling and ERD

Now that we have established the basic concept of the database, let’s get started with… Read More »Database101 (2) Database Modeling – Analyzing Requirements

In the previous article, we covered what a DBMS is. In this article, we will… Read More »Database101 (1.5) Database Management System (DBMS) Features and Components