WGU - C170 - Data Management
Applications
Create Database Syntax - ✔✔CREATE DATABASE db_name;
Simple SFW query syntax - ✔✔SELECT * FROM db_name WHERE column_name operator value;
Cardinality: Inside or outside? - ✔✔Outside
Modality: Inside or outside? - ✔✔Inside
What commands are used with data definition? - ✔✔create, alter, drop, truncate, comment, rename
What commands are used with data manipulation? - ✔✔Select, Insert, Update, Delete, Merge, Call,
Explain Plan, Lock Table
Create Table Syntax - ✔✔CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
);
What does AUTO_INCREMENT attribute do for numeric values? - ✔✔It generates a series of unique
identifier values.
CREATE VIEW SYNTAX - ✔✔CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
Applications
Create Database Syntax - ✔✔CREATE DATABASE db_name;
Simple SFW query syntax - ✔✔SELECT * FROM db_name WHERE column_name operator value;
Cardinality: Inside or outside? - ✔✔Outside
Modality: Inside or outside? - ✔✔Inside
What commands are used with data definition? - ✔✔create, alter, drop, truncate, comment, rename
What commands are used with data manipulation? - ✔✔Select, Insert, Update, Delete, Merge, Call,
Explain Plan, Lock Table
Create Table Syntax - ✔✔CREATE TABLE table_name
(
column_name1 data_type(size),
column_name2 data_type(size),
);
What does AUTO_INCREMENT attribute do for numeric values? - ✔✔It generates a series of unique
identifier values.
CREATE VIEW SYNTAX - ✔✔CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
