WGU - C170 - DATA MANAGEMENT APPLICATIONS

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
Primary Key Syntax
CREATE TABLE table_name
(
column1 data_type(size)
PRIMARY KEY (column1)
);
Create Index Syntax
CREATE INDEX index_name
ON table_name(column_name)
Insert syntax
INSERT INTO table_name
VALUES (value1,value2,value3,...);
Grant command syntax
GRANT privileges ON object TO user;
Drop Syntax: Table, Index, Database