Computer Science > QUESTIONS & ANSWERS > WGU C170 Data Management - Applications - OA GSA1 Already Passed (All)
WGU C170 Data Management - Applications - OA GSA1 Already Passed Add New Row ✔✔INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row ✔✔UPDATE tabl... e_name SET column1 = value1, column2 = value2, ... WHERE condition; Delete Row ✔✔DELETE FROM table_name WHERE condition; Inner Join ✔✔SELECT column_name(s) FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name; CREATE VIEW ✔✔CREATE VIEW viewname AS SELECT Col1, Col2 FROM table WHERE condition; Concatenate ✔✔CONCAT(Col1, Col2) AS NewColumnName; Create Index ✔✔CREATE INDEX index_name ON table_name (column1, column2, ...); Create Database ✔✔CREATE DATABASE databasename; Drop Database ✔✔DROP DATABASE databasename; Create Table ✔✔CREATE TABLE table_name ( column1 datatype, column2 datatype, column3 datatype, .... ); Set Primary Key ✔✔CREATE TABLE Persons ( ID int NOT NULL, LastName varchar(255) NOT NULL, FirstName varchar(255), Age int, PRIMARY KEY (ID) ); Set Foreign Key ✔✔CREATE TABLE Orders ( OrderID int NOT NULL, OrderNumber int NOT NULL, PersonID int, PRIMARY KEY (OrderID), FOREIGN KEY (PersonID) REFERENCES Persons(PersonID [Show More]
Last updated: 1 year ago
Preview 1 out of 2 pages
Instant download
Buy this document to get the full access instantly
Instant Download Access after purchase
Add to cartInstant download
Connected school, study & course
About the document
Uploaded On
Sep 16, 2022
Number of pages
2
Written in
This document has been written for:
Uploaded
Sep 16, 2022
Downloads
0
Views
75
In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.
We're available through e-mail, Twitter, Facebook, and live chat.
FAQ
Questions? Leave a message!
Copyright © Browsegrades · High quality services·