{"id":460,"date":"2023-01-25T13:36:24","date_gmt":"2023-01-25T13:36:24","guid":{"rendered":"http:\/\/learnlearn.uk\/ibcs\/?page_id=460"},"modified":"2023-01-25T13:36:24","modified_gmt":"2023-01-25T13:36:24","slug":"database-manipulation-language-queries","status":"publish","type":"page","link":"https:\/\/learnlearn.uk\/ibcs\/database-manipulation-language-queries\/","title":{"rendered":"Database Manipulation Language Queries"},"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 Queries<\/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 Queries - IB 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\/ibcs\/database-manipulation-language-queries\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Manipulation Language Queries - IB 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 Queries\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learnlearn.uk\/ibcs\/database-manipulation-language-queries\/\" \/>\n<meta property=\"og:site_name\" content=\"IB Computer Science\" \/>\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\/ibcs\/database-manipulation-language-queries\/\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/database-manipulation-language-queries\/\",\"name\":\"Database Manipulation Language Queries - IB Computer Science\",\"isPartOf\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#website\"},\"datePublished\":\"2023-01-25T13:36:24+00:00\",\"dateModified\":\"2023-01-25T13:36:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/database-manipulation-language-queries\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learnlearn.uk\/ibcs\/database-manipulation-language-queries\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/database-manipulation-language-queries\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"IB Computer Science\",\"item\":\"https:\/\/learnlearn.uk\/ibcs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Database Manipulation Language Queries\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#website\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/\",\"name\":\"IB Computer Science\",\"description\":\"- learnlearn..uk\",\"publisher\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learnlearn.uk\/ibcs\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#organization\",\"name\":\"IB Computer Science\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png\",\"contentUrl\":\"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png\",\"width\":300,\"height\":41,\"caption\":\"IB Computer Science\"},\"image\":{\"@id\":\"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Database Manipulation Language Queries - IB 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\/ibcs\/database-manipulation-language-queries\/","og_locale":"en_GB","og_type":"article","og_title":"Database Manipulation Language Queries - IB 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 Queries","og_url":"https:\/\/learnlearn.uk\/ibcs\/database-manipulation-language-queries\/","og_site_name":"IB Computer Science","twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/learnlearn.uk\/ibcs\/database-manipulation-language-queries\/","url":"https:\/\/learnlearn.uk\/ibcs\/database-manipulation-language-queries\/","name":"Database Manipulation Language Queries - IB Computer Science","isPartOf":{"@id":"https:\/\/learnlearn.uk\/ibcs\/#website"},"datePublished":"2023-01-25T13:36:24+00:00","dateModified":"2023-01-25T13:36:24+00:00","breadcrumb":{"@id":"https:\/\/learnlearn.uk\/ibcs\/database-manipulation-language-queries\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learnlearn.uk\/ibcs\/database-manipulation-language-queries\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learnlearn.uk\/ibcs\/database-manipulation-language-queries\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"IB Computer Science","item":"https:\/\/learnlearn.uk\/ibcs\/"},{"@type":"ListItem","position":2,"name":"Database Manipulation Language Queries"}]},{"@type":"WebSite","@id":"https:\/\/learnlearn.uk\/ibcs\/#website","url":"https:\/\/learnlearn.uk\/ibcs\/","name":"IB Computer Science","description":"- learnlearn..uk","publisher":{"@id":"https:\/\/learnlearn.uk\/ibcs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learnlearn.uk\/ibcs\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/learnlearn.uk\/ibcs\/#organization","name":"IB Computer Science","url":"https:\/\/learnlearn.uk\/ibcs\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/","url":"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png","contentUrl":"https:\/\/learnlearn.uk\/ibcs\/wp-content\/uploads\/sites\/25\/2022\/09\/LearnLearnLogowhite-300x41.png","width":300,"height":41,"caption":"IB Computer Science"},"image":{"@id":"https:\/\/learnlearn.uk\/ibcs\/#\/schema\/logo\/image\/"}}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"learnlearnadmin","author_link":"https:\/\/learnlearn.uk\/ibcs\/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\/ibcs\/wp-json\/wp\/v2\/pages\/460"}],"collection":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/comments?post=460"}],"version-history":[{"count":1,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages\/460\/revisions"}],"predecessor-version":[{"id":462,"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/pages\/460\/revisions\/462"}],"wp:attachment":[{"href":"https:\/\/learnlearn.uk\/ibcs\/wp-json\/wp\/v2\/media?parent=460"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}