Rules for SQL Flashcards
Primary Key
Must be made to never be NULL. Must be unique.
Unique Key
Must be unique. One can be NULL
Foreign key
The key in this table that corresponds to another table’s primary key.
DDL
Data Definition Language - CREATE, ALTER, DROP
DML
Data Manipulation Language- what I’m used to
DCL
Data Control Language - GRANT, REVOKE
TCL
Transaction Control Language - SAVEPOINT, ROLLBACK, COMMIT
INSERT INTO
A command to create new values in a table. Syntax-INSERT INTO TABLE_NAME (column1, column2, column3,…columnN)
VALUES (value1, value2, value3,…valueN);
Relational Database Management System
A program that allows you to create, update, and administer a relational database. Most relational database management systems use the SQL language to access the database
Three ways of using CSS
Inline - by using the style attribute in HTML elements
Internal - by using a element in the <head> section
External - by using an external CSS file
