In this post, you’ll learn three main logical operators used to filter data in MySQL database. The three logical operators we will look into are: AND, OR and NOT operators. […]
Category: SQL Database
Push a Local Directory to a GitHub (Remote Directory)
In this post, you’ll learn how to push a directory on your local machine to a remote directory like GitHub using the Linux command line. A directory is pushed to […]
How to Fork a Directory (Repository) on GitHub
In Github, forking is a concept of making a copy of the main repository or directoy to your account so that you can make modifications in it. This post will […]
Filter Data in MySQL Using IN, BETWEEN and LIKE Logical Operators
Logical operators in MySQL are used to manipulate or combine Boolean conditions in SQL select statement (queries). Logical operators are essential for filtering data in WHERE clauses, joining conditions, and […]
Foreign & Candidate Keys in SQL Table
A foreign key is simply a primary key of another table in a table. A foreign key is an entity (column) (or a set of entities (columns)) in a table […]
How to Set Default Value in SQL
A Default Value in SQL (Structural Query Language) is a value set to be automatically assigned to a column if no value is specified when a new row is inserted […]
CRUD Operations in SQL Database Explained
In SQL, CRUD operation is the four basic operation used to manage and manipulate data in a relational database. CRUD stands for: C – create or insert, R – read […]
Data Types in SQL Database
In SQL (Structured Query Language) database there are various data types to determine the kind of value that can be stored in a column or field of a table. Below […]
How to Create a SQL Table with Primary Key
A SQL (Structural Query Language) table is a structured set of data organized in rows and columns, SQL is the main storage unit in a relational database management system (RDBMS). […]