Period
to 18 July 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 18 July 2018 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
UK > Scotland
6 months to
18 Jul 2018
Same period 2017 Same period 2016
Rank 3 4 4
Rank change year-on-year +1 0 0
Permanent jobs citing SQL 1,461 1,195 1,179
As % of all permanent IT jobs advertised in Scotland 25.49% 22.94% 20.02%
As % of the Programming Languages category 45.12% 36.61% 39.04%
Number of salaries quoted 996 628 655
Scotland median annual salary £45,000 £40,000 £40,000
Median salary % change year-on-year +12.50% - -5.88%
10th Percentile £29,250 £27,000 £27,500
90th Percentile £65,625 £65,000 £64,500
UK median annual salary £47,500 £45,000 £45,000
% change year-on-year +5.56% - +5.88%

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,238 3,264 3,020
As % of all permanent IT jobs advertised in Scotland 56.50% 62.66% 51.29%
Number of salaries quoted 2,193 1,997 1,730
Scotland median annual salary £45,000 £42,500 £42,500
Median salary % change year-on-year +5.88% - +3.66%
10th Percentile £30,000 £28,250 £27,500
90th Percentile £67,500 £67,500 £61,250
UK median annual salary £50,000 £47,500 £47,500
% change year-on-year +5.26% - +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 18 July 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 18 July 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 807 £45,000 +12.50% 74
Edinburgh 0 521 £45,000 +12.50% 77
West Lothian +2 53 £40,000 +23.08% 6
Aberdeen +1 18 £47,000 +17.50% 2
South Lanarkshire +3 15 £42,500 +49.12%
North Lanarkshire +5 10 £40,000 -
Dundee +7 9 £38,750 -6.63% 3
Stirling -4 9 £39,137 +4.37% 2
Lanarkshire - 5 £25,000 - 3
Falkirk - 4 £38,500 - 1
South Ayrshire - 4 £55,000 -
Scottish Borders 0 3 £26,250 -22.79% 2
Renfrewshire 0 3 £25,000 -27.33% 7
Fife -11 3 £41,250 +9.53% 2
Midlothian -3 2 £38,000 +43.40%
Highlands +4 1 - - 2
Perth and Kinross +3 1 £38,000 -32.74%
Inverclyde -1 1 £30,000 -26.83% 1
North Ayrshire - 1 - -
Orkney Islands - 1 - -
SQL
UK

For the 6 months to 18 July 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 535 (36.62%) Agile Software Development
2 466 (31.90%) Java
3 423 (28.95%) C#
4 395 (27.04%) Oracle
4 395 (27.04%) Finance
5 380 (26.01%) .NET
6 370 (25.33%) JavaScript
7 339 (23.20%) Python
8 337 (23.07%) SQL Server
9 308 (21.08%) Microsoft
10 285 (19.51%) HTML
11 279 (19.10%) NoSQL
12 255 (17.45%) OO
12 255 (17.45%) SDLC
13 229 (15.67%) AngularJS
14 218 (14.92%) Microsoft Azure
15 212 (14.51%) TDD
16 211 (14.44%) PL/SQL
17 208 (14.24%) MVC
18 206 (14.10%) Relational Database
19 196 (13.42%) Test Automation
20 184 (12.59%) Software Engineering
21 182 (12.46%) ASP.NET
21 182 (12.46%) Windows
22 172 (11.77%) Business Intelligence
23 165 (11.29%) XML
24 164 (11.23%) CSS
24 164 (11.23%) Scrum
24 164 (11.23%) BDD
25 162 (11.09%) Degree

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 67 (4.59%) SAS
2 58 (3.97%) MQSeries
3 56 (3.83%) SharePoint
4 40 (2.74%) Apache Spark
5 25 (1.71%) Tomcat
6 23 (1.57%) Elasticsearch
7 21 (1.44%) JBoss
8 20 (1.37%) Confluence
9 19 (1.30%) WebSphere
10 17 (1.16%) Apache
11 14 (0.96%) CMS
11 14 (0.96%) MS Exchange
12 13 (0.89%) IIS
12 13 (0.89%) WebLogic
13 11 (0.75%) Skype for Business
14 10 (0.68%) Apache Pig
15 9 (0.62%) Oracle SOA Suite
15 9 (0.62%) SharePoint 2013
16 7 (0.48%) nginx
16 7 (0.48%) OpenStack
Applications
1 43 (2.94%) Microsoft Office
2 38 (2.60%) Microsoft Excel
3 9 (0.62%) Microsoft PowerPoint
4 8 (0.55%) MS Visio
5 7 (0.48%) Microsoft Project
6 1 (0.068%) 3ds Max
6 1 (0.068%) Adobe Illustrator
6 1 (0.068%) InfoPath
6 1 (0.068%) Maya
6 1 (0.068%) Photoshop
6 1 (0.068%) SPSS
Business Applications
1 26 (1.78%) Dynamics CRM
2 21 (1.44%) Oracle EBS
3 14 (0.96%) Oracle Applications
4 13 (0.89%) Dynamics AX
5 11 (0.75%) Oracle ERP
6 4 (0.27%) Remedy ITSM
7 3 (0.21%) Cognos TM1
7 3 (0.21%) Dynamics SL
7 3 (0.21%) LongView
7 3 (0.21%) Markit EDM
8 2 (0.14%) Cognos Business Intelligence
8 2 (0.14%) nopCommerce
8 2 (0.14%) thinkFolio
9 1 (0.068%) Dynamics NAV
9 1 (0.068%) JDE EnterpriseOne
9 1 (0.068%) JDE OneWorld
9 1 (0.068%) Oracle Cash Management
9 1 (0.068%) Oracle EBS R12
9 1 (0.068%) SAP Oil and Gas
9 1 (0.068%) Unit4 Business World
Cloud Services
1 218 (14.92%) Microsoft Azure
2 135 (9.24%) Amazon AWS
3 52 (3.56%) npm
4 51 (3.49%) Office 365
5 37 (2.53%) Serverless
6 34 (2.33%) Dynamics 365
7 32 (2.19%) Google Cloud Platform
8 31 (2.12%) AWS Lambda
9 29 (1.98%) AWS CloudFormation
10 27 (1.85%) Amazon Kinesis
11 26 (1.78%) GitHub
12 17 (1.16%) Cloud Computing
13 15 (1.03%) SaaS
14 11 (0.75%) Azure Data Factory
15 10 (0.68%) Amazon EMR
16 7 (0.48%) Amazon S3
17 6 (0.41%) Amazon EC2
17 6 (0.41%) IaaS
18 5 (0.34%) Google Analytics
18 5 (0.34%) PaaS
Communications & Networking
1 30 (2.05%) DNS
2 29 (1.98%) HTTP
3 28 (1.92%) Firewall
4 16 (1.10%) SMS
5 14 (0.96%) DHCP
6 12 (0.82%) Internet
6 12 (0.82%) SAN
7 11 (0.75%) TCP/IP
7 11 (0.75%) VLAN
7 11 (0.75%) VPN
8 10 (0.68%) IPv4
8 10 (0.68%) IPv6
9 9 (0.62%) Intranet
9 9 (0.62%) LAN
9 9 (0.62%) Skype
9 9 (0.62%) WAN
10 8 (0.55%) FTP
11 7 (0.48%) Kerberos
12 5 (0.34%) HTTPS
12 5 (0.34%) SSL
Database & Business Intelligence
1 337 (23.07%) SQL Server
2 279 (19.10%) NoSQL
3 206 (14.10%) Relational Database
4 157 (10.75%) PostgreSQL
5 113 (7.73%) MySQL
6 107 (7.32%) Hadoop
6 107 (7.32%) SQL Server Integration Services
7 103 (7.05%) Big Data
8 101 (6.91%) Data Warehouse
9 97 (6.64%) SQL Server Reporting Services
10 89 (6.09%) MongoDB
11 86 (5.89%) Apache Cassandra
12 77 (5.27%) RDBMS
13 66 (4.52%) Oracle Database
14 59 (4.04%) SQL Server Analysis Services
15 58 (3.97%) Bigtable
16 42 (2.87%) Power BI
17 34 (2.33%) DB2
18 31 (2.12%) QlikView
19 28 (1.92%) OLTP
Development Applications
1 155 (10.61%) Git (software)
2 85 (5.82%) Maven
3 68 (4.65%) Selenium
4 67 (4.59%) JIRA
5 63 (4.31%) Visual Studio
6 61 (4.18%) JUnit
7 57 (3.90%) Team Foundation Server
8 48 (3.29%) Subversion
9 43 (2.94%) Jenkins
10 41 (2.81%) Cucumber
11 29 (1.98%) NUnit
12 28 (1.92%) Oracle Forms
13 25 (1.71%) Protractor
13 25 (1.71%) SpecFlow
14 22 (1.51%) Bugzilla
14 22 (1.51%) Jasmine
14 22 (1.51%) TeamCity
14 22 (1.51%) webpack
15 21 (1.44%) NetBeans
15 21 (1.44%) TestNG
General
1 395 (27.04%) Finance
2 104 (7.12%) Banking
3 27 (1.85%) Retail
4 25 (1.71%) Marketing
5 23 (1.57%) Telecoms
6 21 (1.44%) Manufacturing
7 19 (1.30%) Advertising
8 18 (1.23%) Electronics
8 18 (1.23%) Investment Banking
8 18 (1.23%) Legal
9 15 (1.03%) Law
10 6 (0.41%) Retail Banking
11 4 (0.27%) Front Office
11 4 (0.27%) Private Banking
12 3 (0.21%) Automotive
12 3 (0.21%) Back Office
12 3 (0.21%) Billing
12 3 (0.21%) Games
12 3 (0.21%) Multimedia
12 3 (0.21%) Publishing
Job Titles
1 636 (43.53%) Developer
2 228 (15.61%) Analyst
3 170 (11.64%) .NET Developer
4 158 (10.81%) Java Developer
5 99 (6.78%) Software Engineer
6 94 (6.43%) Senior Developer
7 89 (6.09%) Software Developer
8 87 (5.95%) C# Developer
9 70 (4.79%) Java Engineer
10 63 (4.31%) Consultant
11 55 (3.76%) C# .NET Developer
12 53 (3.63%) DBA
13 46 (3.15%) Python Developer
13 46 (3.15%) Support Analyst
13 46 (3.15%) Test Engineer
14 45 (3.08%) Java Software Engineer
15 44 (3.01%) Senior Java Developer
16 41 (2.81%) Architect
17 39 (2.67%) Data Analyst
18 36 (2.46%) Senior Analyst
Libraries, Frameworks & Software Standards
1 380 (26.01%) .NET
2 285 (19.51%) HTML
3 229 (15.67%) AngularJS
4 182 (12.46%) ASP.NET
5 165 (11.29%) XML
6 164 (11.23%) CSS
7 152 (10.40%) Spring
8 125 (8.56%) ASP.NET MVC
9 116 (7.94%) Hibernate
10 99 (6.78%) REST
11 91 (6.23%) Web Services
12 85 (5.82%) React
13 82 (5.61%) Middleware
14 81 (5.54%) HTML5
15 80 (5.48%) Node.js
16 77 (5.27%) jQuery
17 68 (4.65%) .NET Framework
18 67 (4.59%) SOAP
19 60 (4.11%) XML Schema
20 58 (3.97%) .NET Core
Miscellaneous
1 123 (8.42%) Analytical Skills
2 117 (8.01%) Enterprise Software
3 76 (5.20%) Computer Science
4 67 (4.59%) Virtual Team
5 58 (3.97%) User Experience
6 57 (3.90%) Greenfield Project
7 41 (2.81%) Algorithms
7 41 (2.81%) Self-Motivation
8 38 (2.60%) Robotics
9 21 (1.44%) Mobile App
10 19 (1.30%) Data Centre
11 18 (1.23%) Fintech
11 18 (1.23%) Management Information System
12 17 (1.16%) Data Structures
13 14 (0.96%) Clustering
13 14 (0.96%) Foreign Exchange (FX)
14 12 (0.82%) Mainframe
15 11 (0.75%) Replication
16 10 (0.68%) Fixed Income
17 9 (0.62%) Smartphone
Operating Systems
1 182 (12.46%) Windows
2 124 (8.49%) Unix
3 112 (7.67%) Linux
4 49 (3.35%) Windows Server
5 20 (1.37%) Windows Server 2012
6 15 (1.03%) Windows Server 2008
7 14 (0.96%) AIX
8 9 (0.62%) Windows 7
8 9 (0.62%) Windows Server 2003
9 7 (0.48%) Apple iOS
9 7 (0.48%) Solaris
9 7 (0.48%) Windows 10
10 4 (0.27%) HPUX
10 4 (0.27%) Windows 8
11 2 (0.14%) Android
11 2 (0.14%) CentOS
11 2 (0.14%) Mac OS X
11 2 (0.14%) Red Hat Enterprise Linux
11 2 (0.14%) zOS
12 1 (0.068%) Mac OS
Processes & Methodologies
1 535 (36.62%) Agile Software Development
2 255 (17.45%) OO
2 255 (17.45%) SDLC
3 212 (14.51%) TDD
4 208 (14.24%) MVC
5 196 (13.42%) Test Automation
6 184 (12.59%) Software Engineering
7 172 (11.77%) Business Intelligence
8 164 (11.23%) BDD
8 164 (11.23%) Scrum
9 155 (10.61%) Analytics
10 138 (9.45%) Collaborative Working
11 135 (9.24%) Continuous Integration
12 127 (8.69%) OOP
13 125 (8.56%) Problem-Solving
14 123 (8.42%) ETL
15 111 (7.60%) Unit Testing
16 94 (6.43%) Machine Learning
17 91 (6.23%) Data Analysis
18 84 (5.75%) Open Source
Programming Languages
1 466 (31.90%) Java
2 423 (28.95%) C#
3 370 (25.33%) JavaScript
4 339 (23.20%) Python
5 211 (14.44%) PL/SQL
6 161 (11.02%) T-SQL
7 105 (7.19%) C++
8 94 (6.43%) PHP
9 59 (4.04%) XPath
10 55 (3.76%) TypeScript
11 46 (3.15%) Ruby
12 44 (3.01%) R
13 41 (2.81%) PowerShell
14 35 (2.40%) VB.NET
15 31 (2.12%) Bash Shell
15 31 (2.12%) Shell Script
16 27 (1.85%) Java 8
16 27 (1.85%) Perl
17 22 (1.51%) VBA
18 20 (1.37%) VB
Qualifications
1 162 (11.09%) Degree
2 38 (2.60%) BPSS Clearance
3 33 (2.26%) Security Cleared
4 25 (1.71%) Computer Science Degree
5 24 (1.64%) Numerate Degree
6 21 (1.44%) Microsoft Certification
7 19 (1.30%) ISEB
7 19 (1.30%) ISTQB
8 12 (0.82%) ITIL Certification
9 9 (0.62%) MCDBA
9 9 (0.62%) MCITP
9 9 (0.62%) PhD
10 8 (0.55%) OCP
10 8 (0.55%) Oracle Certification
11 5 (0.34%) MCSA
11 5 (0.34%) SC Cleared
12 4 (0.27%) MCSE
13 3 (0.21%) ISTQB Foundation Certification
14 2 (0.14%) A+ Certification
14 2 (0.14%) Postgraduate
Quality Assurance & Compliance
1 55 (3.76%) QA
2 26 (1.78%) Data Quality
3 21 (1.44%) SLA
4 10 (0.68%) PMO
5 6 (0.41%) ISO/IEC 27001
6 4 (0.27%) COBIT
6 4 (0.27%) GCP
6 4 (0.27%) SEPA
7 3 (0.21%) Dodd-Frank
7 3 (0.21%) EMIR
7 3 (0.21%) GDPR
7 3 (0.21%) ISO 9001
7 3 (0.21%) MiFID
8 2 (0.14%) HL7
8 2 (0.14%) HMG Security Policy Framework
8 2 (0.14%) PCI DSS
9 1 (0.068%) Actionable Recommendations
9 1 (0.068%) FATCA
9 1 (0.068%) Solvency II
System Software
1 99 (6.78%) Docker
2 40 (2.74%) Active Directory
3 27 (1.85%) Hyper-V
4 24 (1.64%) VMware Infrastructure
5 18 (1.23%) HDFS
6 10 (0.68%) vSphere
7 9 (0.62%) Oracle RAC
8 7 (0.48%) XenApp
9 6 (0.41%) NFS
9 6 (0.41%) Xen
9 6 (0.41%) XenServer
10 5 (0.34%) Firmware
11 4 (0.27%) Virtual Machines
12 2 (0.14%) Job Entry Subsystem
12 2 (0.14%) RACF
12 2 (0.14%) Samba
12 2 (0.14%) Time Sharing Option
12 2 (0.14%) VMware Server
12 2 (0.14%) VMware Workstation
13 1 (0.068%) Microsoft App-V
Systems Management
1 99 (6.78%) Puppet
2 83 (5.68%) Ansible
3 41 (2.81%) Opscode Chef
4 16 (1.10%) SCCM
5 15 (1.03%) SCOM
6 14 (0.96%) Oracle RMAN
7 10 (0.68%) Data Guard
7 10 (0.68%) HP Quality Center
7 10 (0.68%) Oozie
8 7 (0.48%) Cobbler
9 6 (0.41%) HP ALM
9 6 (0.41%) Systems Management Server (SMS)
9 6 (0.41%) Tivoli
10 5 (0.34%) Kubernetes
11 4 (0.27%) Kibana
12 2 (0.14%) Microsoft Data Protection Manager
12 2 (0.14%) Prometheus
12 2 (0.14%) Salt
12 2 (0.14%) Single Sign-On
12 2 (0.14%) Terraform
Vendors
1 395 (27.04%) Oracle
2 308 (21.08%) Microsoft
3 48 (3.29%) Google
4 36 (2.46%) VMware
5 35 (2.40%) Tableau
6 34 (2.33%) Sybase
7 32 (2.19%) Informatica
8 30 (2.05%) IBM
9 26 (1.78%) SAP
10 24 (1.64%) Xamarin
11 19 (1.30%) Cisco
12 17 (1.16%) HP
12 17 (1.16%) MicroStrategy
13 16 (1.10%) Citrix
14 14 (0.96%) Talend
14 14 (0.96%) Teradata
15 13 (0.89%) Cognos
16 12 (0.82%) Avaloq
17 11 (0.75%) SolarWinds
18 9 (0.62%) Vertica