Abdulrahman AlQallaf

Decluttering my mind into the web ...






Quick SQL reference

date posted: 2020-Jul-03, last edit date: 2026-Feb-02


These are a few pages from a book on databases that I find myself going back to over and over again for a quick refresher on SQL. I thought I might as well post them here for easy access.

Book name: Database Systems, models, languages, design, and application programming. Sixth edition. By Ramez ElMasri and Shamkant B. Navathe.

 

summary of frequently used SQL syntax

 

create table - basic

 

create table - advanced





# Post Title ⇅ Date Posted ⇅ Last Edit Date ⇅
1 [Medium Article] 12 Years in Data & AI: Lesson #2 — How Organizational Structure Determines Data & AI Success 2026-03-18 2026-03-18
2 [Medium Article] 12 Years in Data & AI: Lessons Organizations Keep Learning the Hard Way 2026-03-07 2026-03-11
3 [Medium Article] Kuwait's Addition to the FATF Grey List — Why Implementation Matters More Than Regulation 2026-02-18 2026-03-11
4 New tools for data analysis (ipython-sql and Azure Data Studio) 2021-10-16 2021-10-16
5 How to setup a remote jupyter server 2021-10-13 2026-02-02
6 How to setup ZSH 2021-10-12 2021-10-12
7 Concepts in Data Architecture 2021-05-01 2026-02-02
8 Loading data into PostgreSQL reference 2021-03-19 2026-02-02
9 SQLite <--> Pandas reference 2021-03-15 2021-03-15
10 Creating an automated data mart (in SQL) 2020-07-16 2020-07-16
11 Personal finance management and open banking 2020-07-12 2020-07-12
12 current post -- Quick SQL reference 2020-07-03 2026-02-02
13 How to back up Digital Ocean Spaces (S3 compatible storage) 2020-06-07 2020-07-03
14 PostgreSQL initiation 2020-05-25 2020-06-01