WGU Data Management - Applications - C170 OA GSA1
WGU Data Management - Applications - C170 OA GSA1 Document Content and Description Below WGU Data Management - Applications - C170 OA GSA1 Add New Row Answer- INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row Answer- UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; Delete Row Answer- DELETE FROM table_name WHERE condition; Inner Join Answer- SELECT column_name(s) FROM table1 INNER JOIN table2 ON n_name = n_name; CREATE VIEW Answer- CREATE VIEW viewname AS SELECT Col1, Col2 FROM table WHERE condition; Concatenate Answer- CONCAT(Col1, Col2) AS NewColumnName; Create Index Answer- CREATE INDEX index_name ON table_name (column1, column2, ...); Create Database Answer- CREATE DATABASE databasename;WGU Data Management - Applications - C170 OA GSA1 Sho
Document information
- Uploaded on
- April 22, 2023
- Number of pages
- 2
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
