Period
to 21 October 2018

The following table provides summary statistics for permanent job vacancies advertised in Scotland with a requirement for SQL skills. Included is a benchmarking guide to the salaries offered in vacancies that have cited SQL over the 6 months to 21 October 2018 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
UK > Scotland
6 months to
21 Oct 2018
Same period 2017 Same period 2016
Rank 3 4 5
Rank change year-on-year +1 +1 -1
Permanent jobs citing SQL 1,380 1,334 959
As % of all permanent IT jobs advertised in Scotland 25.82% 24.12% 18.19%
As % of the Programming Languages category 45.22% 38.81% 34.18%
Number of salaries quoted 951 758 565
Scotland median annual salary £45,000 £40,000 £40,000
Median salary % change year-on-year +12.50% - -5.29%
10th Percentile £29,750 £28,000 £26,850
90th Percentile £65,000 £60,000 £60,000
UK median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - -

SQL is in the Programming Languages category. The following table is for comparison with the above and provides summary statistics for all permanent job vacancies advertised in Scotland with a requirement for coding skills.

All Programming Languages
Scotland
Permanent vacancies with a requirement for coding skills 3,052 3,437 2,806
As % of all permanent IT jobs advertised in Scotland 57.10% 62.14% 53.22%
Number of salaries quoted 2,057 2,201 1,651
Scotland median annual salary £45,000 £42,500 £42,500
Median salary % change year-on-year +5.88% - +6.25%
10th Percentile £30,000 £28,750 £28,000
90th Percentile £65,000 £63,750 £60,000
UK median annual salary £50,000 £48,500 £47,500
% change year-on-year +3.09% +2.11% +5.56%

SQL
Job Vacancy Trend in Scotland

Job postings citing SQL as a percentage of all IT jobs advertised in Scotland.

Job vacancy trend for SQL in Scotland

SQL
Salary Trend in Scotland

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing SQL in Scotland.

Salary trend for SQL in Scotland

SQL
Salary Histogram in Scotland

The salary distribution of IT jobs citing SQL in Scotland over the 6 months to 21 October 2018.

Salary histogram for SQL in Scotland

SQL
Job Locations in Scotland

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing SQL within the Scotland region over the 6 months to 21 October 2018. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 6 month period last year.

Location Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Past 6 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Glasgow +2 743 £46,500 +8.77% 89
Edinburgh -1 469 £44,750 +11.88% 81
West Lothian -4 60 £40,000 +23.08% 7
South Lanarkshire +11 18 £42,500 +1.19% 3
Aberdeen -3 14 £43,857 +9.64% 5
Dundee +11 12 £34,500 -12.66% 3
Stirling -4 12 £38,500 -14.44% 3
Renfrewshire +2 11 £35,250 +2.47% 3
Scottish Borders 0 7 £28,500 -17.39%
Fife -2 7 £31,500 -12.94% 4
South Ayrshire - 4 £50,000 -
North Lanarkshire +3 3 £47,500 +11.76% 1
Lothian -1 3 £32,000 -25.58%
Highlands - 3 £35,000 -
Falkirk - 3 £51,750 -
Lanarkshire +2 2 £42,500 +19.72%
Aberdeenshire +1 2 £37,500 -6.25%
Inverclyde -1 1 £30,000 -33.33%
Perth and Kinross - 1 £38,000 -
East Ayrshire - 1 - -
SQL
UK

For the 6 months to 21 October 2018, IT jobs citing SQL also mentioned the following skills in order of popularity. The figures indicate the absolute number co-occurrences and as a proportion of all permanent job ads across the Scotland region with a requirement for SQL.

1 567 (41.09%) Agile Software Development
2 444 (32.17%) Java
3 436 (31.59%) Finance
4 417 (30.22%) C#
5 398 (28.84%) Oracle
6 364 (26.38%) JavaScript
7 346 (25.07%) .NET
8 337 (24.42%) SQL Server
9 288 (20.87%) Python
10 272 (19.71%) HTML
11 250 (18.12%) OO
12 238 (17.25%) Microsoft
13 230 (16.67%) PL/SQL
14 224 (16.23%) SDLC
15 223 (16.16%) Test Automation
16 220 (15.94%) TDD
17 216 (15.65%) AngularJS
18 204 (14.78%) Relational Database
19 188 (13.62%) Degree
20 186 (13.48%) Software Engineering
21 182 (13.19%) XML
21 182 (13.19%) Microsoft Azure
22 175 (12.68%) CSS
22 175 (12.68%) Windows
23 173 (12.54%) Scrum
24 170 (12.32%) NoSQL
25 162 (11.74%) MVC
26 154 (11.16%) Git (software)
27 153 (11.09%) Business Intelligence
28 144 (10.43%) T-SQL

SQL
Co-occurring IT Skills in Scotland by Category

The follow tables expand on the table above by listing co-occurrences grouped by category. The same job type, locality and period is covered with up to 20 co-occurrences shown in each of the following categories:

Application Platforms
1 52 (3.77%) MQSeries
2 45 (3.26%) SAS
3 36 (2.61%) Apache Spark
3 36 (2.61%) SharePoint
4 30 (2.17%) WebSphere
5 29 (2.10%) IIS
6 27 (1.96%) JBoss
7 22 (1.59%) Apache
8 20 (1.45%) Tomcat
9 15 (1.09%) Apache Pig
10 12 (0.87%) Elasticsearch
10 12 (0.87%) Skype for Business
10 12 (0.87%) WebLogic
11 8 (0.58%) CMS
11 8 (0.58%) Confluence
11 8 (0.58%) MS Exchange
11 8 (0.58%) Oracle SOA Suite
12 6 (0.43%) CloudStack
12 6 (0.43%) Exchange Server 2010
12 6 (0.43%) OpenStack
Applications
1 37 (2.68%) Microsoft Excel
2 32 (2.32%) Microsoft Office
3 6 (0.43%) MS Visio
4 5 (0.36%) Microsoft PowerPoint
5 3 (0.22%) Microsoft Project
6 1 (0.072%) 3ds Max
6 1 (0.072%) Adobe Illustrator
6 1 (0.072%) Maya
6 1 (0.072%) Photoshop
Business Applications
1 26 (1.88%) Oracle EBS
2 25 (1.81%) Dynamics CRM
3 19 (1.38%) Oracle ERP
4 11 (0.80%) Oracle Applications
5 10 (0.72%) Markit EDM
6 6 (0.43%) Magento
7 4 (0.29%) Dynamics AX
8 2 (0.14%) Cognos TM1
8 2 (0.14%) Salesforce.com CRM
9 1 (0.072%) Cognos Business Intelligence
9 1 (0.072%) Dynamics NAV
9 1 (0.072%) Oracle AML
9 1 (0.072%) thinkFolio
9 1 (0.072%) Unit4 Business World
Cloud Services
1 182 (13.19%) Microsoft Azure
2 103 (7.46%) Amazon AWS
3 35 (2.54%) Office 365
4 26 (1.88%) npm
5 22 (1.59%) GitHub
6 21 (1.52%) Serverless
7 19 (1.38%) Google Cloud Platform
8 17 (1.23%) Dynamics 365
8 17 (1.23%) SaaS
9 14 (1.01%) Amazon EMR
10 11 (0.80%) Amazon CloudWatch
10 11 (0.80%) AWS Lambda
11 10 (0.72%) Azure Functions
11 10 (0.72%) Cloud Computing
12 9 (0.65%) Yammer
13 8 (0.58%) Google Analytics
13 8 (0.58%) OpenShift
14 7 (0.51%) Amazon EC2
14 7 (0.51%) Amazon S3
14 7 (0.51%) IaaS
Communications & Networking
1 23 (1.67%) HTTP
2 22 (1.59%) DNS
3 18 (1.30%) TCP/IP
4 17 (1.23%) Firewall
5 15 (1.09%) SMS
6 14 (1.01%) Internet
7 13 (0.94%) Intranet
8 12 (0.87%) WAN
9 11 (0.80%) LAN
9 11 (0.80%) Skype
10 10 (0.72%) DHCP
11 9 (0.65%) VLAN
12 8 (0.58%) IPv4
12 8 (0.58%) IPv6
12 8 (0.58%) Kerberos
13 6 (0.43%) VPN
14 5 (0.36%) FTP
14 5 (0.36%) HTTPS
14 5 (0.36%) SAN
14 5 (0.36%) SSL
Database & Business Intelligence
1 337 (24.42%) SQL Server
2 204 (14.78%) Relational Database
3 170 (12.32%) NoSQL
4 137 (9.93%) PostgreSQL
5 119 (8.62%) Data Warehouse
6 115 (8.33%) Big Data
7 107 (7.75%) SQL Server Integration Services
8 99 (7.17%) MySQL
9 92 (6.67%) Hadoop
10 79 (5.72%) SQL Server Reporting Services
11 70 (5.07%) RDBMS
12 65 (4.71%) Power BI
13 63 (4.57%) Oracle Database
14 62 (4.49%) Apache Cassandra
15 56 (4.06%) SQL Server 2012
16 52 (3.77%) Bigtable
17 50 (3.62%) SQL Server Analysis Services
18 41 (2.97%) QlikView
19 38 (2.75%) MongoDB
20 31 (2.25%) DB2
Development Applications
1 154 (11.16%) Git (software)
2 104 (7.54%) Visual Studio
3 78 (5.65%) Jenkins
4 71 (5.14%) Selenium
5 68 (4.93%) Maven
6 63 (4.57%) Cucumber
7 57 (4.13%) JIRA
8 49 (3.55%) JUnit
9 46 (3.33%) SpecFlow
10 44 (3.19%) Team Foundation Server
10 44 (3.19%) TeamCity
11 39 (2.83%) Subversion
12 26 (1.88%) NetBeans
13 25 (1.81%) NUnit
14 24 (1.74%) Toad
15 23 (1.67%) Bugzilla
15 23 (1.67%) Oracle Forms
16 20 (1.45%) Hudson
17 16 (1.16%) Oracle APEX
18 15 (1.09%) Eclipse
General
1 436 (31.59%) Finance
2 127 (9.20%) Banking
3 30 (2.17%) Marketing
4 29 (2.10%) Retail
5 25 (1.81%) Investment Banking
6 24 (1.74%) Law
7 19 (1.38%) Manufacturing
8 15 (1.09%) Electronics
8 15 (1.09%) Financial Institution
8 15 (1.09%) Telecoms
9 13 (0.94%) Retail Banking
10 10 (0.72%) Front Office
11 9 (0.65%) Advertising
11 9 (0.65%) Back Office
12 8 (0.58%) Legal
13 3 (0.22%) Games
13 3 (0.22%) Local Government
14 2 (0.14%) Billing
14 2 (0.14%) German Language
14 2 (0.14%) Multimedia
Job Titles
1 607 (43.99%) Developer
2 187 (13.55%) Analyst
3 154 (11.16%) .NET Developer
4 144 (10.43%) Java Developer
5 109 (7.90%) Software Engineer
6 105 (7.61%) Senior Developer
7 93 (6.74%) Software Developer
8 89 (6.45%) Java Engineer
9 85 (6.16%) C# Developer
10 71 (5.14%) SQL Developer
11 68 (4.93%) Consultant
12 56 (4.06%) C# .NET Developer
12 56 (4.06%) Test Engineer
13 48 (3.48%) C# Software Engineer
13 48 (3.48%) DBA
13 48 (3.48%) Java Software Engineer
14 45 (3.26%) Python Engineer
15 41 (2.97%) Oracle Developer
16 38 (2.75%) Administrator
16 38 (2.75%) Support Analyst
Libraries, Frameworks & Software Standards
1 346 (25.07%) .NET
2 272 (19.71%) HTML
3 216 (15.65%) AngularJS
4 182 (13.19%) XML
5 175 (12.68%) CSS
6 129 (9.35%) Spring
7 122 (8.84%) ASP.NET
8 102 (7.39%) Hibernate
8 102 (7.39%) jQuery
9 96 (6.96%) Web Services
10 87 (6.30%) HTML5
11 80 (5.80%) REST
12 78 (5.65%) React
13 77 (5.58%) SOAP
14 69 (5.00%) Middleware
15 68 (4.93%) ASP.NET MVC
16 63 (4.57%) RESTful
17 57 (4.13%) JSON
17 57 (4.13%) WPF
18 56 (4.06%) ASP.NET Web API
Miscellaneous
1 142 (10.29%) Analytical Skills
2 101 (7.32%) Enterprise Software
3 78 (5.65%) Computer Science
4 59 (4.28%) Greenfield Project
5 58 (4.20%) Virtual Team
6 50 (3.62%) Fintech
7 48 (3.48%) Robotics
8 31 (2.25%) User Experience
9 29 (2.10%) Management Information System
10 22 (1.59%) Replication
11 17 (1.23%) Algorithms
11 17 (1.23%) Self-Motivation
12 16 (1.16%) Mainframe
13 15 (1.09%) Clustering
14 14 (1.01%) Mobile App
15 13 (0.94%) Foreign Exchange (FX)
16 10 (0.72%) Hybrid Cloud
16 10 (0.72%) Smartphone
17 8 (0.58%) DataPower
17 8 (0.58%) Derivative
Operating Systems
1 175 (12.68%) Windows
2 134 (9.71%) Linux
3 108 (7.83%) Unix
4 35 (2.54%) Windows Server
5 17 (1.23%) Android
6 15 (1.09%) Apple iOS
7 11 (0.80%) Windows Server 2008
8 8 (0.58%) Windows 10
9 7 (0.51%) AIX
9 7 (0.51%) Windows Server 2012
10 6 (0.43%) Windows 7
11 4 (0.29%) Red Hat Enterprise Linux
12 3 (0.22%) CentOS
12 3 (0.22%) Windows Server 2003
13 2 (0.14%) Tru64
13 2 (0.14%) Windows XP
14 1 (0.072%) Ubuntu
14 1 (0.072%) Windows 2000
14 1 (0.072%) Windows 8
14 1 (0.072%) Windows Phone
Processes & Methodologies
1 567 (41.09%) Agile Software Development
2 250 (18.12%) OO
3 224 (16.23%) SDLC
4 223 (16.16%) Test Automation
5 220 (15.94%) TDD
6 186 (13.48%) Software Engineering
7 173 (12.54%) Scrum
8 162 (11.74%) MVC
9 153 (11.09%) Business Intelligence
10 142 (10.29%) BDD
11 139 (10.07%) OOP
12 136 (9.86%) Analytics
13 122 (8.84%) Continuous Integration
14 120 (8.70%) ETL
14 120 (8.70%) Unit Testing
15 117 (8.48%) Problem-Solving
16 91 (6.59%) Data Modelling
17 90 (6.52%) Visualisation
18 88 (6.38%) Collaborative Working
19 87 (6.30%) Mentoring
Programming Languages
1 444 (32.17%) Java
2 417 (30.22%) C#
3 364 (26.38%) JavaScript
4 288 (20.87%) Python
5 230 (16.67%) PL/SQL
6 144 (10.43%) T-SQL
7 124 (8.99%) C++
8 72 (5.22%) PHP
9 55 (3.99%) Ruby
10 52 (3.77%) XPath
11 42 (3.04%) TypeScript
12 37 (2.68%) PowerShell
12 37 (2.68%) R
13 35 (2.54%) Bash Shell
14 31 (2.25%) Shell Script
15 25 (1.81%) VB.NET
16 19 (1.38%) Java 8
16 19 (1.38%) Scala
17 16 (1.16%) Perl
18 15 (1.09%) VB
Qualifications
1 188 (13.62%) Degree
2 34 (2.46%) Numerate Degree
3 29 (2.10%) Computer Science Degree
4 19 (1.38%) ISEB
5 18 (1.30%) ISTQB
6 14 (1.01%) Security Cleared
7 13 (0.94%) Microsoft Certification
8 12 (0.87%) BPSS Clearance
9 9 (0.65%) ISTQB Foundation Certification
10 8 (0.58%) OCP
10 8 (0.58%) Oracle Certification
11 7 (0.51%) MCSE
12 5 (0.36%) ITIL Certification
12 5 (0.36%) PhD
13 4 (0.29%) MCP
13 4 (0.29%) SC Cleared
14 3 (0.22%) HND
15 2 (0.14%) AWS Certification
15 2 (0.14%) ITIL Foundation Certificate
15 2 (0.14%) MCSA
Quality Assurance & Compliance
1 85 (6.16%) QA
2 26 (1.88%) Data Quality
3 11 (0.80%) SLA
4 5 (0.36%) COBIT
5 4 (0.29%) ISO/IEC 27001
5 4 (0.29%) SEPA
6 3 (0.22%) GDPR
6 3 (0.22%) PMO
7 2 (0.14%) PCI DSS
8 1 (0.072%) Actionable Recommendations
8 1 (0.072%) Cyber Essentials
8 1 (0.072%) Cyber Essentials PLUS
8 1 (0.072%) HL7
8 1 (0.072%) HMG Security Policy Framework
8 1 (0.072%) ISO/IEC 20000
System Software
1 81 (5.87%) Docker
2 35 (2.54%) Active Directory
3 18 (1.30%) Hyper-V
4 17 (1.23%) VMware Infrastructure
5 13 (0.94%) HDFS
6 10 (0.72%) Oracle RAC
6 10 (0.72%) vSphere
7 6 (0.43%) Xen
7 6 (0.43%) XenServer
8 5 (0.36%) Samba
8 5 (0.36%) Tivoli Workload Scheduler
9 4 (0.29%) NFS
10 3 (0.22%) Firmware
10 3 (0.22%) Virtual Machines
10 3 (0.22%) VMware ESXi
10 3 (0.22%) XenApp
11 2 (0.14%) Job Entry Subsystem
11 2 (0.14%) RACF
11 2 (0.14%) Time Sharing Option
12 1 (0.072%) Microsoft App-V
Systems Management
1 83 (6.01%) Ansible
2 80 (5.80%) Puppet
3 30 (2.17%) Opscode Chef
4 22 (1.59%) Kubernetes
5 14 (1.01%) Oozie
6 12 (0.87%) Systems Management Server (SMS)
7 11 (0.80%) HP Quality Center
7 11 (0.80%) Oracle RMAN
7 11 (0.80%) Tivoli
8 6 (0.43%) Cobbler
8 6 (0.43%) Data Guard
8 6 (0.43%) SCCM
9 5 (0.36%) Terraform
10 4 (0.29%) Kibana
11 3 (0.22%) HP ALM
11 3 (0.22%) Single Sign-On
12 2 (0.14%) Enterprise Manager Cloud Control
12 2 (0.14%) Grafana
12 2 (0.14%) Prometheus
12 2 (0.14%) Sysdig
Vendors
1 398 (28.84%) Oracle
2 238 (17.25%) Microsoft
3 42 (3.04%) Tableau
4 34 (2.46%) Google
5 33 (2.39%) Xamarin
6 29 (2.10%) IBM
6 29 (2.10%) VMware
7 25 (1.81%) Sybase
8 24 (1.74%) Cognos
9 22 (1.59%) Informatica
10 21 (1.52%) SAP
11 17 (1.23%) MicroStrategy
12 16 (1.16%) Cognizant
13 15 (1.09%) Teradata
14 12 (0.87%) Avaloq
15 11 (0.80%) Solace
15 11 (0.80%) TIBCO
16 10 (0.72%) New Relic
16 10 (0.72%) Salesforce.com
17 8 (0.58%) Citrix