If you need and introduction to SQL and Databases, I recommend reading these articles before diving into this one: Introduction to SQL SQL: Tables and Basic Structure SQL: Data Types SQL: Syntax SQLite is a database that comes pre-installed with…
SQL is not case sensitive, so you can use the keywords in uppercase like SELECT or lowercase like select, both work the same. For the sake of clarity and readability, it is advised to use the reserved keywords in uppercase,…
Data Types Each field in a Table has a Type. A Data Type is used to specify what kind of object that particular field will store. When creating your own structures, using the right type for the right data is…
This is a direct continuation of my previous article Introduction to SQL. SQL works on a structure with four components: Table, Field, Row, and Column. You can think of those components exactly like the ones in spreadsheets like Excel. A…
It doesn’t matter if you are a frontend, backend, or a full stack developer, knowing SQL is a must have skill. What is SQL and why you should learn it SQL stands for Structured Query Language. It is pronounced SEQUEL.…