Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

MySQL Chapter 1

memorize.ai (lvl 286)

(0)

49 cards

()

Section 1

Preview this deck

relational database

Front

1 / 49

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

Section 1

(49 cards)

relational database

Front

consists of a collection of tables, each of which contains information on a specific subject

Back

cell

Front

The intersection of a row and a column

Back

database driver

Front

A piece of software that is used to communicate with the database

Back

application software

Front

Does the work that the user wants to do

Back

query

Front

A SELECT statement is commonly referred to as a ?

Back

thin client

Front

a terminal that looks like a desktop but has limited capabilities and components

Back

data access API

Front

Provides the interface between the application program and the DBMS

Back

outer join

Front

Returns rows from one table in the join even if the other table doesn't contain a matching row.

Back

web applications

Front

Applications that are designed to run on a web server

Back

application servers

Front

Used to store business components that do part of the application processing

Back

/ /

Front

Characters to specify a block comment

Back

composite primary key

Front

When a primary keys uses two or more columns

Back

data type

Front

Determines what type of data the field can store.

Back

network

Front

Cabling, communication lines, etc that connect the clients and the server

Back

value

Front

A cell stores a single ?

Back

data manipulation language

Front

SQL statements that let you work with the data in the database

Back

DELETE

Front

The SQL command used to delete one or more rows from a table based on the condition you specify

Back

one-to-many

Front

The most common type of relationship between two tables is a/an ___________________ relationship.

Back

join

Front

Lets you combine data from two or more tables into a single result set

Back

INSERT

Front

The SQL command used to add rows to a table

Back

open-source

Front

MySQL is a popular ? database that runs on all major operating systems.

Back

client

Front

PCs, laptops, tablets and smartphones in a system

Back

non-primary key

Front

Another name for a unique key

Back

SQL dialect, variant

Front

Although SQL is a standard language, each vendor has its own ? ?, or ? , that may include extensions to the standard

Back

default value

Front

A value a field will assume unless an explicit value is entered for that field.

Back

--

Front

Characters to specify a single-line comment

Back

back end processing

Front

The processing done by the database management system

Back

back end

Front

Another term for the database server

Back

null values

Front

Indicates that the value of the column is unknown

Back

unique key

Front

A key that uniquely identifies each row in the table

Back

primary key

Front

A field that uniquely identifies each row in the table

Back

auto increment column

Front

A numeric column whose value is generated automatically when a row is added to the table.

Back

ALTER

Front

SQL command used to change the definition of an existing table or index

Back

web services

Front

Like business components designed to run on a web server

Back

enterprise system

Front

A system that consists of networks, midrange systems and mainframe systems

Back

records, fields

Front

Alternate names for rows and columns

Back

inner join

Front

The most common type of join. This type of join returns rows from both tables only if their related columns match.

Back

entity relationship diagram

Front

Can be used to show how the tables in a database are defined and related

Back

SELECT

Front

You can use this statement to retrieve selected columns and rows from a base table

Back

data definition language

Front

SQL statements that let you work with the objects in the database

Back

referential integrity

Front

Ensures that any changes to the data in a database don't create invalid relationships between tables

Back

rows, columns

Front

Tables consist of ? and ?

Back

foreign key

Front

One or more columns in a table that refer to a primary key in another table

Back

Data Definition Language (DDL)

Front

Database administrators work with ? statements (DDL or DML)

Back

UPDATE

Front

The SQL command used to change the values in one or more rows of a table

Back

structured query language

Front

SQL stand for

Back

index

Front

Provides an efficient way to access data from a table based on the values in specific columns

Back

server

Front

A computer that has enough processor speed, internal memory and disk storage to store the files and databases of the system and provide services to the clients of the system.

Back

enhanced entity-relationship diagram

Front

A newer form of entity relationship diagram

Back