WGU Data Management - Applications - C170 OA
GSA1
Add New Row - ✔✔INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, value3, ...);
Update Row - ✔✔UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
Delete Row - ✔✔DELETE FROM table_name
WHERE condition;
Inner Join - ✔✔SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;
CREATE VIEW - ✔✔CREATE VIEW viewname AS
SELECT Col1, Col2
FROM table
WHERE condition;
Concatenate - ✔✔CONCAT(Col1, Col2) AS NewColumnName;
Create Index - ✔✔CREATE INDEX index_name
ON table_name (column1, column2, ...);
Create Database - ✔✔CREATE DATABASE databasename;
GSA1
Add New Row - ✔✔INSERT INTO table_name (column1, column2, ...)
VALUES (value1, value2, value3, ...);
Update Row - ✔✔UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
Delete Row - ✔✔DELETE FROM table_name
WHERE condition;
Inner Join - ✔✔SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;
CREATE VIEW - ✔✔CREATE VIEW viewname AS
SELECT Col1, Col2
FROM table
WHERE condition;
Concatenate - ✔✔CONCAT(Col1, Col2) AS NewColumnName;
Create Index - ✔✔CREATE INDEX index_name
ON table_name (column1, column2, ...);
Create Database - ✔✔CREATE DATABASE databasename;
