{"id":169,"date":"2016-07-24T08:30:50","date_gmt":"2016-07-24T08:30:50","guid":{"rendered":"http:\/\/learnlearn.uk\/sql\/?page_id=169"},"modified":"2019-02-04T19:01:26","modified_gmt":"2019-02-04T19:01:26","slug":"unit-overview","status":"publish","type":"page","link":"https:\/\/learnlearn.uk\/sql\/","title":{"rendered":"Unit Overview"},"content":{"rendered":"

\"linustorvaldwallpaperquote\"<\/h2>\n

Unit Overview<\/h2>\n

This \u00a0unit has been designed to equip students will all the skills need to view, edit and ultimately design SQL databases. The unit is designed to cover and exceed the requirements of the OCR GCSE Computer Science specification, specifically giving students the skills and confidence to use a professional database when tackling the controlled assessment element.<\/p>\n

This hands on unit starts by getting students accustomed with Querying and navigating databases, and\u00a0then covers how to edit, update and delete entries in a database. The unit then takes a look at the considerations required when designing a database, and takes a peek at some of the more advanced queries that make SQL as powerful as it is.<\/p>\n

Towards the end of the unit, we look at how SQL can function as a powerful back-end to a Python application, and finally students are issued with a mini project to go off an design their own database schema.<\/p>\n","protected":false},"excerpt":{"rendered":"

Unit Overview This \u00a0unit has been designed to equip students will all the skills need to view, edit and ultimately design SQL databases. The unit is designed to cover and exceed the requirements of the OCR GCSE Computer Science specification, specifically giving students the skills and confidence to use a professional database when tackling the… Read More »Unit Overview<\/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":"\nUnit Overview - SQL<\/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\/sql\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Unit Overview - SQL\" \/>\n<meta property=\"og:description\" content=\"Unit Overview This \u00a0unit has been designed to equip students will all the skills need to view, edit and ultimately design SQL databases. The unit is designed to cover and exceed the requirements of the OCR GCSE Computer Science specification, specifically giving students the skills and confidence to use a professional database when tackling the… Read More »Unit Overview\" \/>\n<meta property=\"og:url\" content=\"https:\/\/learnlearn.uk\/sql\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL\" \/>\n<meta property=\"article:modified_time\" content=\"2019-02-04T19:01:26+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2016\/07\/linustorvaldwallpaperquote-300x132.jpg?_t=1549306879\" \/>\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\/sql\/\",\"url\":\"https:\/\/learnlearn.uk\/sql\/\",\"name\":\"Unit Overview - SQL\",\"isPartOf\":{\"@id\":\"https:\/\/learnlearn.uk\/sql\/#website\"},\"datePublished\":\"2016-07-24T08:30:50+00:00\",\"dateModified\":\"2019-02-04T19:01:26+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/learnlearn.uk\/sql\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/learnlearn.uk\/sql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/learnlearn.uk\/sql\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Unit Overview\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/#website\",\"url\":\"https:\/\/learnlearn.uk\/sql\/\",\"name\":\"SQL\",\"description\":\"Databases\",\"publisher\":{\"@id\":\"https:\/\/learnlearn.uk\/sql\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/learnlearn.uk\/sql\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/#organization\",\"name\":\"SQL\",\"url\":\"https:\/\/learnlearn.uk\/sql\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/learnlearn.uk\/sql\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2019\/02\/LearnLearnLogowhite.png\",\"contentUrl\":\"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2019\/02\/LearnLearnLogowhite.png\",\"width\":710,\"height\":98,\"caption\":\"SQL\"},\"image\":{\"@id\":\"https:\/\/learnlearn.uk\/sql\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Unit Overview - SQL","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\/sql\/","og_locale":"en_GB","og_type":"article","og_title":"Unit Overview - SQL","og_description":"Unit Overview This \u00a0unit has been designed to equip students will all the skills need to view, edit and ultimately design SQL databases. The unit is designed to cover and exceed the requirements of the OCR GCSE Computer Science specification, specifically giving students the skills and confidence to use a professional database when tackling the… Read More »Unit Overview","og_url":"https:\/\/learnlearn.uk\/sql\/","og_site_name":"SQL","article_modified_time":"2019-02-04T19:01:26+00:00","og_image":[{"url":"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2016\/07\/linustorvaldwallpaperquote-300x132.jpg?_t=1549306879"}],"twitter_card":"summary_large_image","twitter_misc":{"Estimated reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/learnlearn.uk\/sql\/","url":"https:\/\/learnlearn.uk\/sql\/","name":"Unit Overview - SQL","isPartOf":{"@id":"https:\/\/learnlearn.uk\/sql\/#website"},"datePublished":"2016-07-24T08:30:50+00:00","dateModified":"2019-02-04T19:01:26+00:00","breadcrumb":{"@id":"https:\/\/learnlearn.uk\/sql\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/learnlearn.uk\/sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/learnlearn.uk\/sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/learnlearn.uk\/sql\/"},{"@type":"ListItem","position":2,"name":"Unit Overview"}]},{"@type":"WebSite","@id":"https:\/\/learnlearn.uk\/sql\/#website","url":"https:\/\/learnlearn.uk\/sql\/","name":"SQL","description":"Databases","publisher":{"@id":"https:\/\/learnlearn.uk\/sql\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/learnlearn.uk\/sql\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/learnlearn.uk\/sql\/#organization","name":"SQL","url":"https:\/\/learnlearn.uk\/sql\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/learnlearn.uk\/sql\/#\/schema\/logo\/image\/","url":"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2019\/02\/LearnLearnLogowhite.png","contentUrl":"https:\/\/learnlearn.uk\/sql\/wp-content\/uploads\/sites\/6\/2019\/02\/LearnLearnLogowhite.png","width":710,"height":98,"caption":"SQL"},"image":{"@id":"https:\/\/learnlearn.uk\/sql\/#\/schema\/logo\/image\/"}}]}},"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"learnlearnadmin","author_link":"https:\/\/learnlearn.uk\/sql\/author\/learnlearnadmin\/"},"rttpg_comment":0,"rttpg_category":null,"rttpg_excerpt":"Unit Overview This \u00a0unit has been designed to equip students will all the skills need to view, edit and ultimately design SQL databases. The unit is designed to cover and exceed the requirements of the OCR GCSE Computer Science specification, specifically giving students the skills and confidence to use a professional database when tackling the… Read…","_links":{"self":[{"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/pages\/169"}],"collection":[{"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/comments?post=169"}],"version-history":[{"count":2,"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/pages\/169\/revisions"}],"predecessor-version":[{"id":219,"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/pages\/169\/revisions\/219"}],"wp:attachment":[{"href":"https:\/\/learnlearn.uk\/sql\/wp-json\/wp\/v2\/media?parent=169"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}