{"id":472,"date":"2020-04-03T01:05:01","date_gmt":"2020-04-03T01:05:01","guid":{"rendered":"http:\/\/learnlearn.uk\/alevelcs\/?page_id=472"},"modified":"2021-03-22T21:11:35","modified_gmt":"2021-03-22T21:11:35","slug":"database-manipulation-language","status":"publish","type":"page","link":"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/","title":{"rendered":"Database Manipulation Language"},"content":{"rendered":"
\n

Intro<\/h2>\n
\n\n

What is a Database Manipulation Langauge?<\/h3>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n\n<\/div>

Select<\/h2>\n
\n\n

SELECT<\/h3>\n

SELECT * FROM People<\/strong><\/p>\n

This is used to retrieve data from a database table(or multiple tables)<\/p>\n

You can retrieve all columns from the tables, or restrict to specific rows<\/p>\n

WHERE<\/p>\n

This is used to filter results based on the criteria given<\/p>\n

 <\/p>\n

 <\/p>\n

ORDER BY<\/p>\n

This is used to sort the table by a certain column<\/p>\n

 <\/p>\n

 <\/p>\n

GROUP BY<\/p>\n

This is used to collate with certain shared values together<\/p>\n

 <\/p>\n\n<\/div>

Aggregates<\/h2>\n
\n\n

Aggregate Funtions (Sum, Count, average)<\/h3>\n

These queries are all used with the SELECT Query and all return number<\/strong> as the response to the query.<\/p>\n

SUM<\/strong><\/p>\n

This sums up values within a certain column.<\/p>\n

 <\/p>\n

 <\/p>\n

COUNT<\/strong><\/p>\n

The returns the number of rows retrieved by a statement<\/p>\n

 <\/p>\n

 <\/p>\n

AVG<\/strong><\/p>\n

This returns the mean average of the attributes specified<\/p>\n

 <\/p>\n

 <\/p>\n\n<\/div>

Inner Join<\/h2>\n
\n\n

INNER JOIN<\/h3>\n

This combines data from two tables (or more) into a single query.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n\n<\/div>

Insert<\/h2>\n
\n\n

INSERT<\/h3>\n

This adds a new row into a database table.<\/p>\n

 <\/p>\n

 <\/p>\n\n<\/div>

Update<\/h2>\n
\n\n

UPDATE<\/h3>\n

The update\u00a0 alters the data stored within a row or rows, depending on the parameters given.<\/p>\n

 <\/p>\n\n<\/div>

Delete<\/h2>\n
\n\n

DELETE<\/h3>\n

This query removes a row or rows, depending on the query. If you don’t specify what\u00a0 data to delete then it will delete all data in a table<\/p>\n

 <\/p>\n

 <\/p>\n\n<\/div>

Practice<\/h2>\n
\n\n

Online Practice Websites<\/h3>\n

https:\/\/www.w3schools.com\/sql\/default.asp<\/a><\/p>\n

SQL Island Online SQL Game<\/a><\/p>\n

Learnlearn SQL Unit<\/a><\/p>\n

 <\/p>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

What is a Database Manipulation Langauge?       SELECT 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 WHERE This is used to filter results based on the criteria given     ORDER BY… Read More »Database Manipulation Language<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":70,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":""},"yoast_head":"\nDatabase Manipulation Language - A Level Computer Science<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Manipulation Language - A Level Computer Science\" \/>\n<meta property=\"og:description\" content=\"What is a Database Manipulation Langauge?       SELECT 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 WHERE This is used to filter results based on the criteria given     ORDER BY… Read More »Database Manipulation Language\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/\" \/>\n<meta property=\"og:site_name\" content=\"A Level Computer Science\" \/>\n<meta property=\"article:modified_time\" content=\"2021-03-22T21:11:35+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/\",\"url\":\"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/\",\"name\":\"Database Manipulation Language - A Level Computer Science\",\"isPartOf\":{\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/#website\"},\"datePublished\":\"2020-04-03T01:05:01+00:00\",\"dateModified\":\"2021-03-22T21:11:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"A Level Computer Science Home\",\"item\":\"https:\/\/learnlearn.uk\/alevelcs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Manipulation Language\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/#website\",\"url\":\"https:\/\/learnlearn.uk\/alevelcs\/\",\"name\":\"A Level Computer Science\",\"description\":\"CIE Specification\",\"publisher\":{\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learnlearn.uk\/alevelcs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/#organization\",\"name\":\"A Level Computer Science\",\"url\":\"https:\/\/learnlearn.uk\/alevelcs\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/09\/LearnLearnLogowhite.png\",\"contentUrl\":\"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/09\/LearnLearnLogowhite.png\",\"width\":710,\"height\":98,\"caption\":\"A Level Computer Science\"},\"image\":{\"@id\":\"https:\/\/learnlearn.uk\/alevelcs\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database Manipulation Language - A Level Computer Science","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/","og_locale":"en_GB","og_type":"article","og_title":"Database Manipulation Language - A Level Computer Science","og_description":"What is a Database Manipulation Langauge?       SELECT 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 WHERE This is used to filter results based on the criteria given     ORDER BY… Read More »Database Manipulation Language","og_url":"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/","og_site_name":"A Level Computer Science","article_modified_time":"2021-03-22T21:11:35+00:00","twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/","url":"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/","name":"Database Manipulation Language - A Level Computer Science","isPartOf":{"@id":"https:\/\/learnlearn.uk\/alevelcs\/#website"},"datePublished":"2020-04-03T01:05:01+00:00","dateModified":"2021-03-22T21:11:35+00:00","breadcrumb":{"@id":"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learnlearn.uk\/alevelcs\/database-manipulation-language\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"A Level Computer Science Home","item":"https:\/\/learnlearn.uk\/alevelcs\/"},{"@type":"ListItem","position":2,"name":"Database Manipulation Language"}]},{"@type":"WebSite","@id":"https:\/\/learnlearn.uk\/alevelcs\/#website","url":"https:\/\/learnlearn.uk\/alevelcs\/","name":"A Level Computer Science","description":"CIE Specification","publisher":{"@id":"https:\/\/learnlearn.uk\/alevelcs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learnlearn.uk\/alevelcs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/learnlearn.uk\/alevelcs\/#organization","name":"A Level Computer Science","url":"https:\/\/learnlearn.uk\/alevelcs\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/learnlearn.uk\/alevelcs\/#\/schema\/logo\/image\/","url":"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/09\/LearnLearnLogowhite.png","contentUrl":"https:\/\/learnlearn.uk\/alevelcs\/wp-content\/uploads\/sites\/20\/2019\/09\/LearnLearnLogowhite.png","width":710,"height":98,"caption":"A Level Computer Science"},"image":{"@id":"https:\/\/learnlearn.uk\/alevelcs\/#\/schema\/logo\/image\/"}}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"learnlearnadmin","author_link":"https:\/\/learnlearn.uk\/alevelcs\/author\/learnlearnadmin\/"},"rttpg_comment":0,"rttpg_category":null,"rttpg_excerpt":"What is a Database Manipulation Langauge?       SELECT 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 WHERE This is used to filter results based on the criteria given     ORDER BY… Read…","_links":{"self":[{"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/pages\/472"}],"collection":[{"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/comments?post=472"}],"version-history":[{"count":7,"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/pages\/472\/revisions"}],"predecessor-version":[{"id":484,"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/pages\/472\/revisions\/484"}],"wp:attachment":[{"href":"https:\/\/learnlearn.uk\/alevelcs\/wp-json\/wp\/v2\/media?parent=472"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}