DMIT1508

Database Fundamentals

Main Topics

• Normalization
• 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