Introduction < > Contents (“Manchester”)+(“Digital”)> Objectives What Are Databases? Frontend & Backend Database Types Setting up the Project Query Tool Window Session Quick Tour Of Pg-Admin Query A Relational Database? SELECT... Data Types Data Types - Manipulating SQL Functions Sequel-Mart Database FROM... WHERE... (Comparison) WHERE... (Logical) Nested Statements ORDER BY... LIMIT... GROUP BY... HAVING... Aliasing Revisited INNER JOIN... LEFT OUTER JOIN... How Do We Change Content? CREATE TABLE... CREATE TABLE... Example INSERT INTO... (Single row) INSERT INTO... (Multiple row) UPDATE... (Single table) UPDATE... (Multiple tables) DELETE... TRUNCATE TABLE... DROP... ALTER COLUMN... How Do We Optimise? System Tables Pages Execution Plans CREATE INDEX... TRANSACTIONS CREATE VIEW... CREATE PROCEDURE... SQL Injection Sequel-Mart Frontend & Backend II Building Sequel-Mart API Routes Exercises Transactions View Customer View Product View Summary View Over To You!!!