See what we can offer to your school
"SimpleStudy just makes sense...”
Get the best plan for your school
15 cards from this deck
Structured Query Language
Managing and manipulating data in relational databases
DDL, DML, DQL, DCL
Define or modify database structure
Manipulate data within tables
Creates a table with specified columns & data types
Adds a new record to a table
Fetches records from a table
Updates existing records in a table
Deletes records from a table
Modifies table structure (add/delete/modify columns)
Retrieves specific rows by setting conditions
Orders results by one or more columns
COUNT, AVG, SUM, MAX, MIN
Shows data where there's a match in both tables
Select your subjects, and get access to A+ resources today.