

Introduction

Introduction

SQL, Structured Query Language, is a programming language designed to manage data stored in relational databases. SQL operates through simple, declarative statements. This keeps data accurate and secure, and helps maintain the integrity of databases, regardless of size.

The SQL language is widely used today across web frameworks and database applications. Knowing SQL gives you the freedom to explore your data, and the power to make better decisions. By learning SQL, you will also learn concepts that apply to nearly every data storage system.

The statements covered in this course use SQLite Relational Database Management System (RDBMS).

Types of Databases

1. Relational DB (sql, postgres, cql etc)
2. Key-Value

What is a Relational Database

A relational database is a database that organizes information into one or more tables. A table is a collection of data organized into rows and columns. Tables are sometimes referred to as relations

Data Types

All data stored in a relational database is of a certain data type. Some of the most common data types are:

• INTEGER, a positive or negative whole number
• TEXT, a text string
• DATE, the date formatted as YYYY-MM-DD
• REAL, a decimal value