null
US
Anmelden
kostenlos registrieren
Registrieren
Wir haben festgestellt, dass Javascript in deinem Browser nicht aktiviert ist. Aufgrund des dynamischen Charakters unserer Website muss Javascript allerdings entsprechend aktiviert sein. Bitte lese dir unsere
Geschäftsbedingungen
durch, um mehr Informationen zu erhalten.
Nächster
Kopieren und bearbeiten
Sie müssen sich anmelden, um diese Aktion abzuschließen!
Kostenlos registrieren
7905314
Structured Query Language
Beschreibung
A level Computing Mindmap am Structured Query Language, erstellt von Matt Smith am 01/03/2017.
Keine Merkmale angegeben
computing
a level
Mindmap von
Matt Smith
, aktualisiert more than 1 year ago
Mehr
Weniger
Erstellt von
Matt Smith
vor mehr als 7 Jahre
67
2
0
Zusammenfassung der Ressource
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.
Medienanhänge
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)
Zusammenfassung anzeigen
Zusammenfassung ausblenden
Möchten Sie
kostenlos
Ihre eigenen
Mindmaps
mit GoConqr erstellen?
Mehr erfahren
.
ähnlicher Inhalt
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
Bibliothek durchsuchen