Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Chapter 6: SQL Enviroment and types of SQL statements

memorize.ai (lvl 286)

(0)

9 cards

()

Section 1

Preview this deck

Data manipulation language (DML)

Front

1 / 9

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

Section 1

(9 cards)

Data manipulation language (DML)

Front

commands used to maintain and query a database, including those for updating, inserting, modifying, and querying data.

Back

Notation in the illustrative SQL commands:

Front

i. All-capitalized words denote commands ii. Lowercase and mixed-case words denote values that must be supplied by the user iii. Brackets enclose optional syntax iv. An ellipsis indicates that the accompanying syntactic clause may be repeated as necessary. v. Each SQL command ends with a semicolon;

Back

Data definition language (DDL)

Front

commands used to define a database, including those for creating, altering, and dropping tables and establishing constraints

Back

Benefits of a standardized relational language

Front

1. Reduced training costs 2. Productivity 3. Application portability 4. Application longevity 5. Reduced dependence on a single vendor 6. . Cross-system communication 7. Original SQL standard has been widely criticized, especially for its lack of referential integrity and certain relational operators 8. Continue to be SQL based, MySQL.com 9. New releases may be changed

Back

Schema

Front

- a structure that contains descriptions of objects created by a user, such as base tables, views, and constraints, as part of a database

Back

The SQL Environment

Front

the user has used a prewritten (written in java) with embedded SQL commands for database processing.

Back

Catalog

Front

a set of schemas that, when put together, constitute a description of a database

Back

Relational DBMS (RDBMS)

Front

a database management system that manages data as a collection of tables in which all data relationships are represented by common values in related tables, relational data model

Back

Data control language (DCL)

Front

commands used to control a database, including those for administering privileges and committing (saving) data

Back