C170 Performance Assessment QUESTION
AND ANSWER
Syntax for updating a specific column in a specific row - ✔✔UPDATE <table>
SET <atrribute> = <value>
WHERE <primary key> = <value>;
Syntax for deleting a row - ✔✔DELETE FROM <TableName>
WHERE <PrimaryKey> = <#>;
Syntax for creating a view - ✔✔CREATE VIEW <name>
AS SELECT <columnname>
CONCAT (<attribute>, ' ', <attribute>) AS <newname>, <attributes>
FROM <tablename>
Syntax to create an Index - ✔✔CREATE INDEX <indexname>
ON <table> (<attribute);
Syntax for inserting rows into a table - ✔✔INSERT INTO <TableName> (ColumnName1,
ColumnName2, ColumnName3)
VALUES (Column1Value, Column2Value);
Syntax for updating a value in a specific row - ✔✔UPDATE <TableName>
SET <Attribute> = <NewValue>
WHERE <PrimaryKey> = <#>;
Syntax for deleting a row from table - ✔✔DELETE FROM <TableName>
WHERE <PrimaryKey> = <#>;
Going from Unnormalized to 1NF - ✔✔Add a primary key
AND ANSWER
Syntax for updating a specific column in a specific row - ✔✔UPDATE <table>
SET <atrribute> = <value>
WHERE <primary key> = <value>;
Syntax for deleting a row - ✔✔DELETE FROM <TableName>
WHERE <PrimaryKey> = <#>;
Syntax for creating a view - ✔✔CREATE VIEW <name>
AS SELECT <columnname>
CONCAT (<attribute>, ' ', <attribute>) AS <newname>, <attributes>
FROM <tablename>
Syntax to create an Index - ✔✔CREATE INDEX <indexname>
ON <table> (<attribute);
Syntax for inserting rows into a table - ✔✔INSERT INTO <TableName> (ColumnName1,
ColumnName2, ColumnName3)
VALUES (Column1Value, Column2Value);
Syntax for updating a value in a specific row - ✔✔UPDATE <TableName>
SET <Attribute> = <NewValue>
WHERE <PrimaryKey> = <#>;
Syntax for deleting a row from table - ✔✔DELETE FROM <TableName>
WHERE <PrimaryKey> = <#>;
Going from Unnormalized to 1NF - ✔✔Add a primary key
