SQL BASICS P1.

The Role of Databases in Data Science
What will SQL Fundamentals cover?
Manipulating Data
Querying Data
Aggregating Data
Working with Multiple Tables
Data Acquisition

What is a Relational Database Management System?

On Codecademy, we use both SQLite and PostgreSQL

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



SQL BASIC STATEMENTS
CREATE TABLE creates a new table.
INSERT INTO adds a new row to a table.
SELECT queries data from a table.
ALTER TABLE changes an existing table.
UPDATE edits a row in a table.
DELETE FROM deletes rows from a table.