- Barajar
ActivarDesactivar
- Alphabetizar
ActivarDesactivar
- Frente Primero
ActivarDesactivar
- Ambos lados
ActivarDesactivar
- Leer
ActivarDesactivar
Leyendo...
Cómo estudiar sus tarjetas
Teclas de Derecha/Izquierda: Navegar entre tarjetas.tecla derechatecla izquierda
Teclas Arriba/Abajo: Colvea la carta entre frente y dorso.tecla abajotecla arriba
Tecla H: Muestra pista (3er lado).tecla h
Tecla N: Lea el texto en voz.tecla n
Boton play
Boton play
33 Cartas en este set
- Frente
- Atrás
|
Rdbms
|
Relational Database Management System
|
|
Ordbms
|
Object Relational Database Management Systemdbd
|
|
Tipos de db
|
Herarchical, network, relational y object relational
|
|
DML definition
|
Data Manipulation Language
|
|
DML definition
|
Data Manipulation Language
|
|
DML statements
|
Select, insert, update, delete, merge
|
|
DML definition
|
Data Manipulation Language
|
|
DML statements
|
Select, insert, update, delete, merge
|
|
DDL definition
|
Data Definition Language
|
|
DML definition
|
Data Manipulation Language
|
|
DML statements
|
Select, insert, update, delete, merge
|
|
DDL definition
|
Data Definition Language
|
|
DDL statements
|
Create, alter, drop, rename, truncate, comment
|
|
DML definition
|
Data Manipulation Language
|
|
DML statements
|
Select, insert, update, delete, merge
|
|
DDL definition
|
Data Definition Language
|
|
DDL statements
|
Create, alter, drop, rename, truncate, comment
|
|
DCL definition
|
Data Control Language
|
|
DCL statements
|
Grant, revoke
|
|
DCL statements
|
Grant, revoke
|
|
Transaction control
|
Commit, rollback, savepoint
|
|
Tareas de select
|
Projection, selection y join
|
|
Basic SELECT statement
|
|
|
Operadores aritméticos Precedencia
|
1 división, multiplicación
2 suma, resta 3 izq a derecha |
|
Nulos oprations
|
Cuando hay nulos en algún campo el resultado será nulo
|
|
Alias
|
Double quotation marks, sensitive case or there are spaces
|
|
Literal character
|
Solo Los strings y date son encerrados entre agile quotation marks
|
|
Alternative Quote(q)
|
Crea tu propio delimitador, ya que algunas cadenas incluyen el delimitador y es mal interpret ado.
[],{},(), o <> |
|
Dates
|
Are stored in an internal numeric format.
Default format DD-MON-RR |
|
Between and
|
Primero lower limit. También aplica para caracteres
|
|
Wildcard characters scape identifier
|
'\' Antes del simbolo
|
|
Rules of precedence
|
1 arithmetic 2 concatenation operator 3 comparison conditions 4 is (not) null, like, (not) in5 (not) between 6 not equal to 7 not 8 and 9 or
|
|
Order by
|
Asc default
|
