Structured Query Language A Level Resources

A Level Computer Science: Structured query language

This module contains:

An editable PowerPoint lesson presentation
Editable revision handouts
A glossary which covers the key terminologies of the module
Topic mindmaps for visualising the key concepts
Printable flashcards to help students engage active recall
A quiz with answer key to test knowledge and understanding of the module

Compatible with the following examination boards

Structured Query Language A Level Resources Image 43

Structured Query Language A Level Resources Image 44

Structured Query Language A Level Resources Image 45

Structured Query Language A Level Resources Image 46

Structured Query Language A Level Resources Image 47

Structured query language

SQL is a declarative programming language used to access and manage databases. The SQL statements use simple language and are easy to understand and remember.

This A Level Computer Science module introduces structured query language to your students, explaining:

Queries used to display records
Operators used in queries to filter results
Queries used to insert and delete records to a table
Queries used to modify tables

More Exchanging data Modules

Structured query language is one lesson in our Exchanging data module. The other theory lessons can be found below:

Structured Query Language A Level Resources Image 48

Compression, Encryption and Hashing

Structured Query Language A Level Resources Image 49

Introduction to databases

Structured Query Language A Level Resources Image 50

Relational databases

Structured Query Language A Level Resources Image 51

Transaction processing and ACID

Structured Query Language A Level Resources Image 52

Introduction to computer networks

Structured Query Language A Level Resources Image 53

Network topologies

Structured Query Language A Level Resources Image 54

Network protocols and layers

Structured Query Language A Level Resources Image 55

Internet technologies

Structured Query Language A Level Resources Image 56

Network security

Structured Query Language A Level Resources Image 57

Designing web pages using HTML and CSS

Structured Query Language A Level Resources Image 58

Structured Query Language A Level Resources Image 59

Search engine indexing

Structured Query Language A Level Resources Image 60

Cloud computing and web applications

Structured Query Language A Level Resources Image 61

Database Management System

Structured Query Language A Level Resources Image 62

Data Transmission Technologies

Structured Query Language A Level Resources Image 63

Server-side scripting

.has-text-align-justify{text-align:justify;}#sp-ea-10977 .spcollapsing{height:0;overflow:hidden;transition-property:height;transition-duration:500ms;}.sp-easy-accordion iframe{width:100%;}#sp-ea-10977.sp-easy-accordion>.sp-ea-single{border:1px solid #e2e2e2;}#sp-ea-10977.sp-easy-accordion>.sp-ea-single>.ea-header a{color:#444;}#sp-ea-10977.sp-easy-accordion>.sp-ea-single>.sp-collapse>.ea-body{background:#fff;color:#444;}#sp-ea-10977.sp-easy-accordion>.sp-ea-single{background:#eee;}#sp-ea-10977.sp-easy-accordion>.sp-ea-single>.ea-header a .ea-expand-icon.fa{float:left;color:#444;font-size:16px;}body{background-color:#f1f5f9;color:#3a3a3a;}a{color:#1e73be;}a:hover,a:focus,a:active{color:#000;}body .grid-container{max-width:1100px;}.wp-block-group__inner-container{max-width:1100px;margin-left:auto;margin-right:auto;}.site-header .header-image{width:50px;}body,button,input,select,textarea{font-family:"Source Sans Pro",sans-serif;font-size:18px;}body{line-height:1.5;}.entry-content > [class*="wp-block-"]:not(:last-child){margin-bottom:1.5em;}.main-title{font-size:20px;}.main-navigation .main-nav ul ul li a{font-size:14px;}.sidebar .widget,.footer-widgets .widget{font-size:17px;}h1{font-weight:300;font-size:40px;}h2{font-weight:300;font-size:30px;}h3{font-size:20px;}h4{font-size:inherit;}h5{font-size:inherit;}@media (max-width:768px){.main-title{font-size:30px;}h1{font-size:30px;}h2{font-size:25px;}}.top-bar{background-color:#636363;color:#fff;}.top-bar a{color:#fff;}.top-bar a:hover{color:#303030;}.site-header{background-color:#fff;color:#3a3a3a;}.site-header a{color:#3a3a3a;}.main-title a,.main-title a:hover{color:#222;}.site-description{color:#757575;}.main-navigation,.main-navigation ul ul{background-color:#4f90f2;}.main-navigation .main-nav ul li a,.menu-toggle,.main-navigation .menu-bar-items{color:#fff;}.main-navigation .main-nav ul li:hover > a,.main-navigation .main-nav ul li:focus > a,.main-navigation .main-nav ul li.sfHover > a,.main-navigation .menu-bar-item:hover > a,.main-navigation .menu-bar-item.sfHover > a{color:#fff;background-color:#3580f2;}button.menu-toggle:hover,button.menu-toggle:focus,.main-navigation .mobile-bar-items a,.main-navigation .mobile-bar-items a:hover,.main-navigation .mobile-bar-items a:focus{color:#fff;}.main-navigation .main-nav ul li[class*="current-menu-"] > a{color:#fff;background-color:#3580f2;}.main-navigation .main-nav ul li[class*="current-menu-"] > a:hover,.main-navigation .main-nav ul li[class*="current-menu-"].sfHover > a{color:#fff;background-color:#3580f2;}.navigation-search input[type="search"],.navigation-search input[type="search"]:active,.navigation-search input[type="search"]:focus,.main-navigation .main-nav ul li.search-item.active > a,.main-navigation .menu-bar-items .search-item.active > a{color:#fff;background-color:#3580f2;}.main-navigation ul ul{background-color:#fff;}.main-navigation .main-nav ul ul li a{color:#222;}.main-navigation .main-nav ul ul li:hover > a,.main-navigation .main-nav ul ul li:focus > a,.main-navigation .main-nav ul ul li.sfHover > a{color:#fff;background-color:#4f90f2;}.main-navigation .main-nav ul ul li[class*="current-menu-"] > a{color:#fff;background-color:#3580f2;}.main-navigation .main-nav ul ul li[class*="current-menu-"] > a:hover,.main-navigation .main-nav ul ul li[class*="current-menu-"].sfHover > a{color:#fff;background-color:#3580f2;}.separate-containers .inside-article,.separate-containers .comments-area,.separate-containers .page-header,.one-container .container,.separate-containers .paging-navigation,.inside-page-header{background-color:#fff;}.entry-meta{color:#595959;}.entry-meta a{color:#595959;}.entry-meta a:hover{color:#1e73be;}.sidebar .widget{background-color:#fff;}.sidebar .widget .widget-title{color:#000;}.footer-widgets{background-color:#fff;}.footer-widgets .widget-title{color:#000;}.site-info{color:#613d0e;background-color:#efa647;}.site-info a{color:#613d0e;}.site-info a:hover{color:#0a0100;}.footer-bar .widget_nav_menu .current-menu-item a{color:#0a0100;}input[type="text"],input[type="email"],input[type="url"],input[type="password"],input[type="search"],input[type="tel"],input[type="number"],textarea,select{color:#666;background-color:#fafafa;border-color:#ccc;}input[type="text"]:focus,input[type="email"]:focus,input[type="url"]:focus,input[type="password"]:focus,input[type="search"]:focus,input[type="tel"]:focus,input[type="number"]:focus,textarea:focus,select:focus{color:#666;background-color:#fff;border-color:#bfbfbf;}button,html input[type="button"],input[type="reset"],input[type="submit"],a.button,a.wp-block-button__link:not(.has-background){color:#fff;background-color:#4e90f2;}button:hover,html input[type="button"]:hover,input[type="reset"]:hover,input[type="submit"]:hover,a.button:hover,button:focus,html input[type="button"]:focus,input[type="reset"]:focus,input[type="submit"]:focus,a.button:focus,a.wp-block-button__link:not(.has-background):active,a.wp-block-button__link:not(.has-background):focus,a.wp-block-button__link:not(.has-background):hover{color:#fff;background-color:#3580f2;}a.generate-back-to-top{background-color:rgba(0,0,0,.4);color:#fff;}a.generate-back-to-top:hover,a.generate-back-to-top:focus{background-color:rgba(0,0,0,.6);color:#fff;}@media (max-width: 768px){.main-navigation .menu-bar-item:hover > a,.main-navigation .menu-bar-item.sfHover > a{background:none;color:#fff;}}.inside-top-bar{padding:10px;}.inside-header{padding:10px;}.entry-content .alignwide,body:not(.no-sidebar) .entry-content .alignfull{margin-left:-40px;width:calc(100% + 80px);max-width:calc(100% + 80px);}.rtl .menu-item-has-children .dropdown-menu-toggle{padding-left:20px;}.rtl .main-navigation .main-nav ul li.menu-item-has-children > a{padding-right:20px;}.site-info{padding:20px;}@media (max-width:768px){.separate-containers .inside-article,.separate-containers .comments-area,.separate-containers .page-header,.separate-containers .paging-navigation,.one-container .site-content,.inside-page-header,.wp-block-group__inner-container{padding:30px;}.site-info{padding-right:10px;padding-left:10px;}.entry-content .alignwide,body:not(.no-sidebar) .entry-content .alignfull{margin-left:-30px;width:calc(100% + 60px);max-width:calc(100% + 60px);}}.one-container .sidebar .widget{padding:0px;}@media (max-width: 768px){.main-navigation .menu-toggle,.main-navigation .mobile-bar-items,.sidebar-nav-mobile:not(#sticky-placeholder){display:block;}.main-navigation ul,.gen-sidebar-nav{display:none;}[class*="nav-float-"] .site-header .inside-header > *{float:none;clear:both;}}.dynamic-author-image-rounded{border-radius:100%;}.dynamic-featured-image,.dynamic-author-image{vertical-align:middle;}.one-container.blog .dynamic-content-template:not(:last-child),.one-container.archive .dynamic-content-template:not(:last-child){padding-bottom:0px;}.dynamic-entry-excerpt > p:last-child{margin-bottom:0px;}.secondary-navigation{background-color:#fff;}.secondary-navigation .main-nav ul li a,.secondary-navigation .menu-toggle,.secondary-menu-bar-items .menu-bar-item > a{color:#3a3a3a;font-size:16px;line-height:44px;}.secondary-navigation .secondary-menu-bar-items{color:#3a3a3a;font-size:16px;}button.secondary-menu-toggle:hover,button.secondary-menu-toggle:focus{color:#3a3a3a;}.widget-area .secondary-navigation{margin-bottom:20px;}.secondary-navigation ul ul{background-color:#fff;top:auto;}.secondary-navigation .main-nav ul ul li a{color:#3a3a3a;font-size:15px;}.secondary-navigation .main-nav ul li:hover > a,.secondary-navigation .main-nav ul li:focus > a,.secondary-navigation .main-nav ul li.sfHover > a,.secondary-menu-bar-items .menu-bar-item:hover > a{color:#1e73be;background-color:#fff;}.secondary-navigation .main-nav ul ul li:hover > a,.secondary-navigation .main-nav ul ul li:focus > a,.secondary-navigation .main-nav ul ul li.sfHover > a{color:#fff;background-color:#1e73be;}.secondary-navigation .main-nav ul li[class*="current-menu-"] > a,.secondary-navigation .main-nav ul li[class*="current-menu-"] > a:hover,.secondary-navigation .main-nav ul li[class*="current-menu-"].sfHover > a{color:#1e73be;background-color:#fff;}.secondary-navigation .main-nav ul ul li[class*="current-menu-"] > a,.secondary-navigation .main-nav ul ul li[class*="current-menu-"] > a:hover,.secondary-navigation .main-nav ul ul li[class*="current-menu-"].sfHover > a{color:#fff;background-color:#1e73be;}@media (max-width: 768px){.secondary-menu-bar-items .menu-bar-item:hover > a{background:none;color:#3a3a3a;}}:root{}