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 n_name = n_name; CREATE VIEW - CREATE VIEW viewname AS SELECT Col1, Col2 FROM table WHERE condition; Concatenate - CONCAT(Col1, Col2) AS NewColumnName; Create Index - CREAT...

WGU Data Management - Applications - C170 OA GSA1 Add New Row Ans- INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row Ans- UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; Delete Row Ans- DELETE FROM table_name WHERE condition; Inner Join Ans- SELECT column_name(s) FROM table1 INNER JOIN table2 ON n_name = n_name; CREATE VIEW Ans- CREATE VIEW viewname AS SELECT Col1, Col2 FROM table WHERE condition; Con...

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; 00:08 01:11 Delete Row DELETE FROM table_name WHERE condition; Inner Join SELECT column_name(s) FROM table1 INNER JOIN table2 ON n_name = n_name; CREATE VIEW CREATE VIEW viewname AS SELECT Col1, Col2 FROM table WHERE condition; Concatenate CONCAT(Col1, Col2) AS ...