
SQL joins (JOINS, INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN, …).SQL modify data (INSERT, UPDATE, DELETE, TRUNCATE, …).SQL condition (WHERE, AND, OR, NOT, EXISTS, LIKE, BETWEEN, …).SQL table (CREATE Table, Drop Table, Alter Table, Constraints, Primary Key, Foreign Key, Index, Partitions, …).SQL database (CREATE DB, DROP DB, BACKUP DB, …).Some keywords below are highly recommended: In the first step, Tutorial Page is a great example resource to adapt basic knowledge before working with Database. Each table has its number of columns and rows and represents a set of data. Require knowledge when working with DatabaseĪ Database may be presented as several tables. In this article, relational database will be addressed. There are multiple database types to be listed down. SQL ( Structured Query Language) is a programming language that enables developers to interact with data.



For example, an application like Messenger, WhatApp holds users’ message information, including data about their friends’ message and image also. Data is a base part of new modern applications.
