-
SQL Views
How to create views and interact with them in a SQL database
-
SQL Joins
How to perform a simple join between two database tables
-
SQL, how to delete data and tables
How to delete data from a SQL database table, and how to delete the table
-
SQL, how to update a table structure
How to update a SQL database table structure
-
SQL, how to update data
How to update data stored in a SQL database table
-
SQL, Unique and Primary keys
How to create unique and primary keys in a SQL database
-
SQL, Handling empty cells
How to handle null data in a SQL database
-
SQL, how to use SELECT
How to get data from a SQL database table
-
SQL, adding data to a table
How to insert data in a SQL database table
-
SQL, creating a table
How to create a table in a SQL database
-
MySQL User Permissions
A quick introduction at User Permissions in a MySQL Database
-
SQLite User Permissions
A quick introduction to user permissions in SQLite
-
PostgreSQL vs MySQL, a comparison
A quick comparison between PostgreSQL and MySQL
-
Creating a user on MySQL
A quick step by step guide at how to create a user on MySQL
-
How to install MySQL on macOS
Step by step instructions to install MySQL on macOS using Homebrew
-
How to list tables in the current database using PostgreSQL
A quick explanation of how to list tables in the current database inside the `psql` tool in PostgreSQL, or using SQL
-
How to list all databases using PostgreSQL
A quick explanation of how to list all databases inside the `psql` tool in PostgreSQL, or using SQL
-
How to switch database using PostgreSQL
A quick explanation of how to switch between databases inside the `psql` tool in PostgreSQL
-
How to list all users in PostgreSQL
Find out how to get a list of all the users present in a PostgreSQL database, and their permissions
-
PostgreSQL User Permissions
In this tutorial I will explain how to managing users and permissions in PostgreSQL.
-
Introduction to PostgreSQL
A high level overview of the PostgreSQL database
-
How to install SQLite on macOS
In this tutorial I want to explain what you need to do to install SQLite.
-
Do you always need a database for your app?
Some thoughts on the need of a database. Maybe you need it, maybe not.
-
How to install PostgreSQL on macOS
Instructions for installing the PostgreSQL DBMS
-
Introduction to SQL
SQL (Structured Query Language) is a language we use to interact with a Data Base Management System (DBMS).
-
What is a Database? And a DBMS?
The main properties of a database and of a DBMS.
-
Relational Databases
Relational Databases are the software implementation of the concepts expressed by the theory introduced by the Relational Model.
-
Relational Algebra
When working with the relational model, we have 2 groups of operations we can use. One of them is relational algebra.
-
The Relational Model
The Relational Model is the most popular of the logic data models listed in the Data Models post, and it's at the basis of SQL databases.
-
Introduction to the ER Data Model
A simple but comprehensive overview of the entity-relationship data model
-
Data models
Data Models define how we give a structure to data, and how data is connected to other data.
-
Information systems, data and information
The modern world is completely centered around information and data. What's the difference?