Relational Database

Relational Database

• Database Index
• Database Transaction
• Database Normalization
• Database Tuning
• Database Lock

SQL Basics

• SQL Basics | SQL
• SQL Basics | DDL: Data Definition Language
• SQL Basics | DCL: Data Control Language
• SQL Basics | DML: Data Manipulation Language
• SQL Basics | Functions

MySQL

• MySQL | Installing MySQL
• MySQL | Connecting to a Database from the Console
• MySQL | Checking the Version
• MySQL | Create Tables and Add, Delete, or Modify Columns
• MySQL | Table Creation Error Related to DEFAULT timestamp
• MySQL | Strings
• MySQL | Totals with WITH ROLLUP
• MySQL | Change the Sort Order of NULL Values

PostgreSQL

• PostgreSQL | Installing PostgreSQL
• PostgreSQL | Connecting to PostgreSQL with psql
• PostgreSQL | PostgreSQL Configuration Files
• PostgreSQL | PostgreSQL Basic Syntax
• PostgreSQL | Data Types
• PostgreSQL | Database
• PostgreSQL | Schema
• PostgreSQL | Creating Roles (Users)
• PostgreSQL | Terminal Command Collection
• PostgreSQL | ALTER Constraints and Table Names
• PostgreSQL | Using Sequences
• PostgreSQL | Using ROWNUM with row_number()
• PostgreSQL | Trigger Usage Example
• PostgreSQL | Functions
• PostgreSQL | Query Foreign Key Table and Column Lists

SQLite

• SQLite | Installing SQLite
• SQLite | SQLite Basic Knowledge
• SQLite | Database
• SQLite | Data Types
• SQLite | Table
• SQLite | View
• SQLite | Index
• SQLite | Trigger
• SQLite | Adding, Updating, and Deleting Data
• SQLite | Querying Data
• SQLite | Data Joins
• SQLite | SQLite Commands
• SQLite | SQLite Functions

DBeaver