WGU D426-D427 Data Management Applications & SQL Syntax | Complete Study Guide, Practice Questions, Answers & OA Review

WGU D426-D427 Syntax
WGU D426/D427 Syntax
Study online at https://quizlet.com/_fx3u8q

1. List all Databases SHOW DATABASES;

2. List all Tables in a data- USE Database;
base SHOW TABLES;

3. List all columns and SHOW COLUMNS
their properties in a FROM TableName;
table

4. Create a Table CREATE TABLE TableName (
ColumnName1 DataType,
ColumnName2 DataType,
ColumnName3 DataType,
...
);

5. Add a column to a table ALTER TABLE TableName
ADD ColumnName DataType;

6. Modify a column in a ALTER TABLE TableName
table CHANGE CurrentColumnName NewColumnName DateType;

7. Remove a column from ALTER TABLE TableName
a table DROP ColumnName;

8. Aggregate function (sin- SELECT Function(Column) AS NewColumnName
gle value output) FROM TableName;

9. Aggregate function SELECT LabelsColumn, FUNCTION(DataColumn)
(multi-value (summary) FROM TableName
output) GROUP BY LabelsColumn;

10. Insert new data into a INSERT INTO TableName
table (all columns) VALUES (Value1, Vaule2, Value3....);
1/5
1

, WGU D426-D427 Syntax
WGU D426/D427 Syntax
Study online at https://quizlet.com/_fx3u8q


11. Insert new data into a INSERT INTO TableName (Column1, Column2, Column3....)
table (not all columns) VALUES (Value1, Value2, Value3....);

12. Insert multiple rows of INSERT INTO TableName (Column1, Column2, Column3....)
data (not all columns) VALUES (Value1, Value2, Value3....),
(Value1, Value2, Value3....),
(Value1, Value2, Value3....);

13. Modify data in a table UPDATE TableName
(specific rows) SET ColumnName = NewValue
WHERE Condition;

14. Modify data in a table UPDATE TableName
(all rows) SET ColumnName = NewValue;

15. Remove data from a DELETE FROM TableName
table WHERE Condition;

16. Remove all data from a DELETE FROM TableName;
table

17. Set a primary key on an ALTER TABLE TableName
existing table ADD PRIMARY KEY (ColumnName);

18. Set a foreign key on an ALTER TABLE TableName
existing table ADD FORIEGN KEY (Column) REFERENCE Table (Column);

19. Create an index on a CREATE INDEX IndexName ON TableName (ColumnName);
table

20. Output all values from a SELECT * FROM TableName;
table


2/5
2