Please enable JavaScript.
Coggle requires JavaScript to display documents.
1.3.2 databases (SQL (join- joins tble using priimary keys and turns in to…
1.3.2 databases
SQL
-
allows for fast and efficient querying and reporting of vast amounts of data held in a relational databse
-
-
INSERT INTO "form"
VALUES ("a","b","c")
-
-
CREATE TABLE "table"("primary fields" PRIMARY KEY, "other field" NOT NULL)
-
-
-
-
% follows a parterre means any amount of characters, _ means a single character , use with like
-
(INNER) JOIN: Returns records that have matching values in both tables
LEFT (OUTER) JOIN: Return all records from the left table, and the matched records from the right table
RIGHT (OUTER) JOIN: Return all records from the right table, and the matched records from the left table
FULL (OUTER) JOIN: Return all records when there is a match in either left or right table
-
-
-
ACID
information processing which is divided into individual , indivisble operations
-
-
-
-
-
-
-