Week 2 Resources

Articles

• The SQL Standard
• Life of a SQL query
• How does a relational database execute SQL statements and prepared statements
• A beginner’s guide to database table relationships
• A beginner’s guide to ACID and database transactions
• A Simple Guide to Five Normal Forms
• Say NO to Venn Diagrams When Explaining JOINs
• A beginner’s guide to SQL injection and how you should prevent it
• The anatomy of Connection Pooling

Blogs

• Java, SQL, and JOOQ
• Vlad Mihalcea

Books

PostgreSQL

• Wikibooks - SQL
• Wikibooks - PostgreSQL
• Wikibooks - Relational Database Design
• The Internals of PostgreSQL
• Database Design

Linux

• Conquering the Command Line
• Linux-Training
• TLDP Advanced Bash-Scripting Guide

Documentation

PostgreSQL

• SQL92 Specification
• PostgreSQL 12 Documentation
• PostgreSQL SQL Command Reference
• psql
• PostgreSQL on Amazon RDS

JDBC

• Java JDBC API
• java.sql (JavaSE 8)

Linux

• The Linux Documentation Project
• Linux man-pages
• Bash Manual
• GNU Coreutils Manual
• The Linux kernel user’s and administrator’s guide

Papers

• The Transaction Concept: Virtues and Limitations

Tools

• DBeaver
• pgAdmin
• Franchise
• JSLinux

Tutorials

Normalization

• Example of a Step by Step Normalization
• Description of the Database Normalization Basics
• 3 Normal Forms Database Tutorial

ANSI SQL

• SQL Bolt
• SQLZOO

PostgreSQL

• postgresql.org Tutorial
• Postgres Guide
• PostgreSQL Exercises
• Developer’s Guide to PostgreSQL on Linux: psql shell

AWS RDS

• Setting Up for Amazon RDS
• Creating Postgres RDS and Connecting Using pgAdmin

JDBC

• Oracle Java Tutorials - JDBC Introduction
• Oracle Java Tutorials - JDBC Basics
• JDBC Diver Connection URL strings
• JDBC Driver Maven dependency list

Linux

• Linux Journey
• Commandline Challenge
• cheat.sh - cli cheatsheets
• explainshell
• ShellCheck