Abdulrahman AlQallaf

Decluttering my mind into the web ...







Quick SQL reference

date posted: 2020-Jul-03, last edit date: 2020-Nov-29


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 New tools for data analysis (ipython-sql and Azure Data Studio) 2021-10-16 2021-10-16
2 How to setup a remote jupyter server 2021-10-13 2021-10-13
3 How to setup ZSH 2021-10-12 2021-10-12
4 Concepts in Data Architecture 2021-05-01 2021-10-16
5 Loading data into PostgreSQL reference 2021-03-19 2021-03-19
6 SQLite <--> Pandas reference 2021-03-15 2021-03-15
7 Creating an automated data mart (in SQL) 2020-07-16 2020-07-16
8 Personal finance management and open banking 2020-07-12 2020-07-12
9 current post -- Quick SQL reference 2020-07-03 2020-11-29
10 How to back up Digital Ocean Spaces (S3 compatible storage) 2020-06-07 2020-07-03
11 PostgreSQL initiation 2020-05-25 2020-06-01