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
almost 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
Photosynthesis
ecarleton622
GCSE French Edexcel High Frequency Verbs: First Set
alecmorley2013
Edexcel History A Gcse ~ USA 1919-1941
Kieran Elson
OCR Physics P2 revision cards
Alex Howard
GCSE Chemistry - module c4
jessmitchell
B5 - Growth and Deveolopment
blairzy123
IB Bio - Mitosis Quiz
j. stu
Algebra Quiz
Norman McBrien
AS Psychology Unit 1 - Memory
Asterisked
GCSE REVISION TIMETABLE
holbbox
OP doplnovaci otazky
Helen Phamova
Browse Library