Logo

Go on. Explore!

lvl 0 • 0 xp

lvl 1

HomeMarketDecksInterests
sql

sql

memorize.aimemorize.ai (lvl 286)
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%
(0)
(0)
(0)
19 cards
()
Section 1

Preview this deck

Database Management System (DBMS)

Front

1 / 19

SQL
Star 0%
Star 0%
Star 0%
Star 0%
Star 0%

0.0

0 reviews

5
0
4
0
3
0
2
0
1
0

Active users

0

All-time users

0

Favorites

0

Last updated

6 years ago

Date created

Mar 1, 2020

Cards (19)

Section 1

(19 cards)

Database Management System (DBMS)

Front

Special software to create and maintain a database -makes it easy to manage large amts of info -handles security -backups -importing/exporting data -concurrency

Back

Select

Front

Defines a drop-down list

Back

from

Front

Defines the table

Back

Non-Relational Databases

Front

not a relational database very general

Back

relational databases

Front

organize data into one or more tables (SQL) most popular = like excel spreadsheet columns and rows unique key identifies each row

Back

DML (Data Manipulation Language)

Front

The portion of SQL, used for querying, inserting, updating, and deleting data from tables.

Back

DDL (Data Definition Language)

Front

used for defining database schemas

Back

C.R.U.D.

Front

create read update delete

Back

where

Front

Restrict the result set or queries Comes after FROM

Back

queries

Front

select, from, where

Back

SQL

Front

used to perform CRUD operations used to define tables and structures

Back

foreign key (FK)

Front

Attribute that allows database tables to be linked together; fk are the primary keys of other tables placed in the current table to support the link between the two tables.

Back

distinct

Front

Constrains results to unique values

Back

can there be more than one fk?

Front

yes

Back

DQL (Data Query Language)

Front

Managers would most likely use this to retrieve information about sales during the month.

Back

DCL (Data Control Language)

Front

Commands that control a database, including administering privileges and committing data

Back

Composite Key

Front

Two or more fields that collectively define the primary key by unique combinations of their values.

Back

queries

Front

are "requests" made to the database management system for specific information

Back

Database

Front

(DB) -any collection of related information (phone book, facebook user base)

Back