What is a Database Manipulation Langauge?
SELECT * FROM People
This is used to retrieve data from a database table(or multiple tables)
You can retrieve all columns from the tables, or restrict to specific rows
This is used to filter results based on the criteria given
This is used to sort the table by a certain column
This is used to collate with certain shared values together
Aggregate Funtions (Sum, Count, average)
These queries are all used with the SELECT Query and all return number as the response to the query.
This sums up values within a certain column.
The returns the number of rows retrieved by a statement
This returns the mean average of the attributes specified
This combines data from two tables (or more) into a single query.
This adds a new row into a database table.
The update alters the data stored within a row or rows, depending on the parameters given.
This query removes a row or rows, depending on the query. If you don’t specify what data to delete then it will delete all data in a table