Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

sql

memorize.ai (lvl 286)

(0)

23 cards

()

Section 1

Preview this deck

drop view

Front

1 / 23

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 (23)

Section 1

(23 cards)

drop view

Front

it deletes a created or existing view

Back

right join

Front

it returns all row from right table

Back

1nf 2nf 3nf boyce-codd normal from 4nf 5nf

Front

normal forms

Back

data manipulation language

Front

dml

Back

database management system

Front

dbms

Back

select where from

Front

basic data retrieval

Back

Data Definition Language

Front

ddl

Back

sql join

Front

these are used to combine records from two or more tables

Back

outer join

Front

it is considered as an extension of the inner join, but does not require each record in the two joined tables the have a matching record

Back

create view

Front

it creates a new view from existing database tables

Back

alter view

Front

it allows the editing or alteration of a created or existing view

Back

left join

Front

it returns all rows from the left table

Back

sql

Front

stands for structured query language

Back

sum avg max min count

Front

aggregation function

Back

insert update delete

Front

database table manipulation

Back

create database drop database create table alter table drop table

Front

data definition

Back

inner join

Front

it is a join statement that return rows where there is at least one match in both tables.

Back

hierarchical database model network model relational model entity-relationship object-oriented model

Front

database model

Back

Front

Back

full join

Front

if rows are being matched in table A and B, then all rows from table A are displayed even if there is no matching row in a table B, and vise versa

Back

data control language

Front

dcl

Back

sql views

Front

these are select statements saved in the database

Back

aggregation

Front

a common programming term means to "combine into groups"

Back