23 08 2016

You should know:

• What is a database?
• What is a table?

DDL

Data Definition Language are commands that change the structure of the table.

• Create
  • CREAT TABLE
• Drop – Delete
  • DROP TABLE
• Change structure of table or object
  • ALTER TABLE

DML

Data  Manipulation Language

• Insert
  • INSERT into TABLE (name of table)
• Read
  • SELECT * TABLE (name of table)
• Update
  • UPDATE TABLE
• Delete
  • DELETE from TABLE

DCL 

Data Control Language grant user permission (Select, Insert, Delete, Update)

• Grant
• Revoke

All these make up SQL.

What is an index? An index is a copy of select columns of data from a table that can be searched very efficiently that also includes a low-level disk block address or direct link to the complete row of data it was copied from. Where the data is located.

What is a view? They act as filters, do not store data, provide security, users do not have to know the underlying table name.

Visual Design DIY Video Set Up