WGU Data Management - Applications - C170 OA GSA1

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;


Drop Database
DROP DATABASE databasename;


Create Table
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
);