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
over 8 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
GCSE Biology AQA
isabellabeaumont
MCAT Chemistry Review: Chemical Bonds
HappyOwl
Chemistry C1
Chloe Winn
A View from the Bridge Quotes
Emma Payne
Test for positive ions
bella.mort
Penson
Roslyn Penson
PHR Sample Questions
Elizabeth Rogers8284
DEV I Part II
d owen
10 Ways to Improve Your Productivity
Rebecca Tarpey
Clinical Pathoanatomy MCQs (Q 151-250)
Ore iyanda
ASSD & PSBD QUESTION 2018 200
Dhiraj Tamang
Browse Library