SQL

In this article, we’ll learn how to handle dates using SQL. We’ll take a closer… Read More »SQL date functions with examples

Let’s move further in the aggregations functions that covered in the last article. In this… Read More »SQL (5) GROUP BY and HAVING

In the last article, we’ve talked about the basics of SELECT and WHERE clauses. In… Read More »SQL (4) Filtering (BETWEEN, IN, OR, NOT)

Let’s learn how to create a simple table. ■ CREATE TABLE CREATE TABLE clause create… Read More »SQL (3) Creating a table

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