null
US
Entrar
Registre-se gratuitamente
Registre-se
Detectamos que o JavaScript não está habilitado no teu navegador. Habilite o Javascript para o funcionamento correto do nosso site. Por favor, leia os
Termos e Condições
para mais informações.
Próximo
Copiar e Editar
Você deve estar logado para concluir esta ação!
Inscreva-se gratuitamente
7905314
Structured Query Language
Descrição
A level Computing Mapa Mental sobre Structured Query Language, criado por Matt Smith em 01-03-2017.
Sem etiquetas
computing
a level
Mapa Mental por
Matt Smith
, atualizado more than 1 year ago
Mais
Menos
Criado por
Matt Smith
mais de 7 anos atrás
67
2
0
Resumo de Recurso
Structured Query Language
Syntax.
Keyword are Not case sensitive.
* = All.
After each command a ';' is needed to show the end.
This is not needed after each line.
% = missing words.
Select.
Allows data to be selected from a Database.
More than one selection can be made, all separated with a comma.
Needs From statement to specify which database to select from.
Distinct.
Removes all of the Duplicates from a Selection.
Where.
Allows Data to be Filtered. ie: only select records where country = 'Germany'.
And/Or.
And Allows Records to be selected based on two values. ie: where sex = male AND age = < 30.
Or allows data to be selected based on either of two values. ie: Sex = male OR Age = < 30.
Order By.
Allows a Database or selection to be ordered by a specific thing. ie: CustomerNames in descending order.
Insert Into.
Allows Data to be added to a database.
Update.
Allows date to be modified in a database.
Where statement needed to make sure all records are not modifies.
Delete.
Allows records to be deleted from a database.
Needs Where statement to make sure not all records are deleted.
From.
Tells it what to do the operation on.
Like.
Allows a pattern to be searched for.
Drop.
Allows an entire database to be deleted.
Join.
Allows all data from two data bases to be joined together, if the columns match.
Anexos de mídia
698b3fc3-1b86-4626-a1a7-0409f906e3b9.PNG (image/PNG)
754a9cd9-c174-48bf-9c2d-c8b943a06ed8.PNG (image/PNG)
7094a81d-8f62-4059-b50c-5efba2d3294e.PNG (image/PNG)
e406a52e-3b80-4c77-b80b-5afce2c8a8ff.PNG (image/PNG)
98202f19-9a3d-4546-a32d-debd09c47831.PNG (image/PNG)
a7c86de2-65c8-4a2a-b5db-1f56bc86989e.PNG (image/PNG)
ddde52ff-ad0a-4ae0-b123-825562dd569e.PNG (image/PNG)
d46184cb-0bc2-4da3-bc5a-b17e24d929c4.PNG (image/PNG)
e4092d23-b656-41a5-aa89-d55f1aeb04c0.PNG (image/PNG)
784f5254-7db8-458f-b50c-3d5e1eed4a0f.PNG (image/PNG)
Quer criar seus próprios
Mapas Mentais
gratuitos
com a GoConqr?
Saiba mais
.
Semelhante
A level Computing Quiz
Zacchaeus Snape
Types and Components of Computer Systems
Jess Peason
Input Devices
Jess Peason
Output Devices
Jess Peason
Computing
Kwame Oteng-Adusei
Pack of playing cards answer
Karl Taylor
Code Challenge Flow Chart
Charlotte Hilton
Computing Hardware - CPU and Memory
ollietablet123
Computer Systems
lisawinkler10
Computer science quiz
Ryan Barton
GCSE Computing - 4 - Representation of data in computer systems
lilymate
Explore a Biblioteca