SQL

In this post, we’ll explore how to declare and assign variables using the SET and… Read More »How to use SQL SET/DECLARE Statements (with example)

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