Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

my sql

memorize.ai (lvl 286)

(0)

6 cards

()

Section 1

Preview this deck

Data Definition language(DDL)

Front

1 / 6

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (6)

Section 1

(6 cards)

Data Definition language(DDL)

Front

Commands that define a database, including creating, altering, and dropping tables and establishing constraints CREATE ALTER DROP

Back

Data Manipulation Language (DML)

Front

A specific language, provided with a DBMS, which allows users to access and modify the data, to make queries, and to generate reports. SELECT, UPDATE, INSERT INTO and DELETE FROM

Back

SQL UNION Operator

Front

The UNION operator is used to combine the result-set of two or more SELECT statements. Each SELECT statement within UNION must have the same number of columns The columns must also have similar data types The columns in each SELECT statement must also be in the same order

Back

SQL JOIN

Front

A JOIN clause is used to combine rows from two or more tables, based on a related column between them. (INNER) JOIN: Returns records that have matching values in both tables LEFT (OUTER) JOIN: Returns all records from the left table, and the matched records from the right table RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table

Back

Data Control Language (DCL)

Front

Commands used to control a database, including those for administering privileges and committing (saving) data. Can also deny and revoke.

Back

INTERSECT Operator

Front

The SQL INTERSECT operator is used to return the results of 2 or more SELECT statements. However, it only returns the rows selected by all queries or data sets. If a record exists in one query and not in the other, it will be omitted from the INTERSECT results.

Back