Skip to main content

SQL

What is SQL:

  • SQL is a 4th generation programming language to interact with relational databases.

 

Four Basic SQL Statements:

  • SELECT
    • For user's intents and purposes, this statement is often used
    • Basic Structure
      • Select column(s) <- Project
      • From table(s) <- Join
      • Where clause(s) <- Restrict
  • INSERT
  • UPDATE
  • DELETE