Member-only story
Master SQL Queries (in 5 minutes)
My article is for everyone! Non-members can click on this link and jump straight into the full text!!
Handling databases is at the heart of software development in this day and age; long gone are the days when the software was only supposed to handle present data and then forget it. Programs nowadays are designed from the ground up to store any and all input data in databases or warehouses to further process them when needed, the most common of these datastores being Relational Databases like PostgreSQL, MySQL, et cetera.
As a result, any programmer worth their salt must know how to interface with databases and the easiest way to do that is through “Structured Query Language” (SQL). A computer language specifically designed to interface with relational databases.
In this article, we will go over some key concepts and commands/functions in SQL; after which we will be confident in facing almost any database-related challenge thrown at us.
What is Database?
A collection of data and hold this data in certain pre-defined structures such as tables & columns, documents & fields, etc.
Types of databases:
- Relational Database — have rows and columns and also have the tables have a relation between them.
Example: Mysql, SQL Server, PostgreSQL…
