DMIT1508 Database Fundamentals Design Data Definition Langauge (DDL) Basic Table Definition CREATE TABLE Syntax Verifying Your Table DROP Statement Constraints PK Constraints FK Constraints CHECK Constraints LIKE Operator Testing a CHECK Constraint DEFAULT Constraint ALTER TABLE Indexes SQL Queries UNION Aggregate Functions JOINs Subqueries Data Manipulation Language (DML) INSERT UPDATE DELETE SQL Views SQL Stored Procedures Variables Flow Control Stored Procedures SQL Transactions SQL Triggers Code Samples References Home