SQL Fundamentals

Most web applications rely on storing their data in a relational database, consisting of tables which are comprised of columns and rows. PostgreSQL, MySQL and SQLite are the most popular and established relational databases, and luckily, they have a LOT in common.

SQL Fundamentals

Creating, Updating and Deleting

Now that we have gotten used to the different ways to retrieve data from our database, we will learn how to create, manipulate and destroy records.