null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
3357452
introduccion a SQL
Description
trabajo par base de datos avansados
No tags specified
trabajo de base de datos avansada
Mind Map by
Carlos Sandoval
, updated more than 1 year ago
More
Less
Created by
Carlos Sandoval
about 9 years ago
8
0
0
Resource summary
introduccion a SQL
comandos SQL
Comandos DLL
CREATE.
utilizado para crear una tabla un objeto de la B.D
DROP
eliminar un objeto de la B.D.
ALTER
modifica un objeto de la B.D.
COmandos DML
SELECT
consultar registros en una B.D
INSERT
lotes en una B.D.
UPDATE
modifica datos en la B.D.
DELETE
eliminar un objeto
Estructura basica de consultas
recuperar info utilizar la sentencia select
FROM
espesifica cual de las tablas se van a tomar los registros
WHERE
espesifica como se van a reunir los registros
GROUP BY
separa registros seleccionados en grupos espesificos
HAVING
espesifica la condicion de cada grupo
ORDER BY
ordena registros espesificos
ALL
recupera todas las filas aunque alguna esten reptidas
DISTINCT
recupera filas distintas
Media attachments
e5f67b23-e815-4d50-9a20-7be59c0b2d22 (image/png)
33844d12-7e7b-4bd6-8294-3fc2377b0b69 (image/png)
bdc6434f-b656-4a3c-9268-bb2967b8e935 (image/png)
f58240a8-02b4-49e1-8aa2-c84530ab1c70 (image/png)
c88fe4d4-a7e6-49ca-bf15-797a0785f94e (image/png)
9aced3fa-5036-430d-8d04-2ebaa21f9daf (image/jpg)
799290cd-dc92-4139-9884-d56c4773c629 (image/png)
68fdc82a-b16d-485d-84e8-8dc131614db8 (image/png)
b03acc46-a42d-4c21-8a91-8938b9b05caa (image/png)
a4a61a87-e60a-4392-a1b5-aa829481060c (image/png)
Show full summary
Hide full summary
Want to create your own
Mind Maps
for
free
with GoConqr?
Learn more
.
Similar
Electromagnetism: Magnetic Flux Density & Magnetic Flux 2
tatemae.honne
Biology AQA 3.1.3 Absorption
evie.daines
AQA GCSE Physics Unit 2.3
Matthew T
Themes in Lord of the Flies
lowri_luxton
CPA Exam Topics and breakdown
joemontin
B2, C2, P2
George Moores
An Inspector Calls
Georgia 27
Biology (B3)
Sian Griffiths
Conferences of the Cold War
Alina A
Bay of Pigs Invasion : April 1961
Alina A
SFDC App Builder 1 (26-50)
Connie Woolard
Browse Library