Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Murach MySQL Chapter 1

memorize.ai (lvl 286)

(0)

44 cards

()

Section 1

Preview this deck

index

Front

1 / 44

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

Section 1

(44 cards)

index

Front

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

Back

default value

Front

value used if another value isn't provided when a row Is added to a table

Back

web server

Front

server that stores web applications and web services

Back

foreign key

Front

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

Back

USE

Front

statement that selects the current database

Back

column

Front

also called a field, and it represents some attribute of the entity represented by the table

Back

base table

Front

the table referred to in the FROM column for a query

Back

INSERT

Front

SQL DML statement; adds new rows to a table

Back

composite primary key

Front

a primary key that consists of two or more columns

Back

data type

Front

determines the type of information that can be stored in the column.

Back

join

Front

operation whereby the data from two tables are brought into a single result set.

Back

result table

Front

the result of a SELECT statement

Back

database driver

Front

software used by an API used to communicate with the database

Back

PHP, Java, C# or VB.NET

Front

common options for accessing MySQL data

Back

DDL acronym

Front

data definition language

Back

API acronym

Front

application programming interface

Back

DML acronym

Front

data manipulation language

Back

DBMS acronym

Front

database management system

Back

ALTER TABLE, INDEX

Front

SQL DDL statement; changes the definition of an existing table or changes the structure of an existing index

Back

SQL

Front

standard language for working with a relationship database

Back

data access API

Front

provides the interface between the application program and the DBMS.

Back

UPDATE

Front

SQL DML statement; changes existing rows in a table

Back

JDBC and Java driver

Front

used by Java to access MySQL data

Back

non-primary key

Front

also called a unique key, and it isn't the primary key but also uniquely identifies each row in a table

Back

Connector/J and Connector/Net

Front

two commonly used MySQL drivers

Back

null value

Front

indicates that the value of the column is unknown

Back

calculated value

Front

value derived from a calculation within the SQL statement

Back

referential integrity

Front

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

Back

SELECT

Front

SQL DML statement; retrieves data from one or more tables

Back

relational database

Front

database that uses tables, and contains records which have fields

Back

DROP DATABASE, TABLE, INDEX

Front

SQL DDL statement; deletes an existing database, table, or index

Back

row

Front

also called a record, and it contains a set of values for a single entity of the entity

Back

cell

Front

the intersection of each row and column, and it represents a value

Back

ADO.NET

Front

used by C# or VB.NET to access MySQL data

Back

table

Front

where data is stored within a relational database

Back

DELETE

Front

SQL DML statement; deletes existing rows in a table

Back

auto increment column

Front

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

Back

CREATE DATABASE, TABLE, INDEX

Front

SQL DDL statement that creates a new database, table or index

Back

query

Front

what a SELECT statement is commonly referred to as being

Back

unique key

Front

also called a non-primary key, and it isn't the primary key but also uniquely identifies each row in a table

Back

application server

Front

server that stores the business components

Back

primary key

Front

column or columns that uniquely identifies that record in the table

Back

SQL acronym

Front

Structured Query Language

Back

mysqli or PDO

Front

used by PHP to access MySQL data

Back