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

SQL (Structured Query Language)
UK > Scotland
6 months to
10 Dec 2018
Same period 2017 Same period 2016
Rank 3 4 5
Rank change year-on-year +1 +1 -1
Permanent jobs citing SQL 1,351 1,357 906
As % of all permanent IT jobs advertised in Scotland 25.26% 24.25% 18.08%
As % of the Programming Languages category 44.44% 40.17% 32.91%
Number of salaries quoted 924 809 568
Scotland median annual salary £45,000 £40,000 £40,500
Median salary % change year-on-year +12.50% -1.23% +1.25%
10th Percentile £29,750 £28,000 £26,925
90th Percentile £65,000 £57,500 £60,000
UK median annual salary £48,000 £45,000 £45,000
% change year-on-year +6.67% - -

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,040 3,378 2,753
As % of all permanent IT jobs advertised in Scotland 56.83% 60.35% 54.95%
Number of salaries quoted 2,011 2,218 1,722
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,250
90th Percentile £65,000 £62,500 £60,000
UK median annual salary £50,208 £50,000 £47,500
% change year-on-year +0.42% +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 10 December 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 10 December 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 707 £47,500 +7.95% 73
Edinburgh -2 456 £43,500 +8.75% 89
West Lothian -2 62 £42,500 +6.25% 7
South Lanarkshire +9 23 £42,500 +2.41% 2
Aberdeen -4 16 £36,250 -4.61% 7
South Ayrshire - 15 £50,000 -
Dundee +3 13 £34,000 -12.82% 2
Renfrewshire +2 12 £27,000 -21.51% 1
Stirling +1 10 £39,774 -9.09% 1
Scottish Borders 0 6 £28,500 -18.57% 1
Fife -8 6 £31,500 -12.50% 1
Aberdeenshire +3 5 £37,500 -6.25%
East Ayrshire - 3 £50,000 -
Lothian - 3 £32,000 -
Highlands - 2 £35,000 -
Falkirk - 2 £51,750 -
Perth and Kinross - 1 £38,000 -
West Dunbartonshire - 1 £43,000 -
SQL
UK

For the 6 months to 10 December 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 543 (40.19%) Agile Software Development
2 466 (34.49%) Finance
3 453 (33.53%) Java
4 416 (30.79%) C#
5 386 (28.57%) JavaScript
6 379 (28.05%) Oracle
7 342 (25.31%) SQL Server
8 336 (24.87%) .NET
9 298 (22.06%) HTML
10 279 (20.65%) Python
11 246 (18.21%) Test Automation
12 231 (17.10%) OO
13 221 (16.36%) Microsoft
14 211 (15.62%) AngularJS
15 209 (15.47%) PL/SQL
15 209 (15.47%) Relational Database
16 208 (15.40%) CSS
17 201 (14.88%) XML
18 197 (14.58%) SDLC
19 186 (13.77%) TDD
20 185 (13.69%) Degree
21 178 (13.18%) Scrum
22 171 (12.66%) Windows
22 171 (12.66%) Git (software)
23 169 (12.51%) Microsoft Azure
24 168 (12.44%) Software Engineering
25 159 (11.77%) MVC
25 159 (11.77%) Business Intelligence
26 158 (11.70%) Analytical Skills
27 149 (11.03%) NoSQL

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 49 (3.63%) MQSeries
2 46 (3.40%) SharePoint
3 44 (3.26%) WebSphere
4 41 (3.03%) SAS
5 31 (2.29%) Apache Spark
5 31 (2.29%) IIS
5 31 (2.29%) JBoss
6 23 (1.70%) Apache
7 21 (1.55%) WebLogic
8 20 (1.48%) Confluence
9 19 (1.41%) Tomcat
10 17 (1.26%) Umbraco
11 12 (0.89%) Skype for Business
11 12 (0.89%) WebSphere Application Server
11 12 (0.89%) WildFly
12 11 (0.81%) Elasticsearch
13 8 (0.59%) Apache Pig
14 7 (0.52%) Oracle SOA Suite
15 6 (0.44%) MS Exchange
15 6 (0.44%) Oracle HTTP Server
Applications
1 40 (2.96%) Microsoft Excel
2 35 (2.59%) Microsoft Office
3 7 (0.52%) Microsoft PowerPoint
4 3 (0.22%) MS Visio
5 1 (0.074%) SPSS
Business Applications
1 32 (2.37%) Oracle EBS
2 28 (2.07%) Oracle ERP
3 19 (1.41%) Dynamics CRM
4 10 (0.74%) Markit EDM
5 9 (0.67%) Magento
6 4 (0.30%) Oracle Applications
7 2 (0.15%) Cognos TM1
7 2 (0.15%) Salesforce.com CRM
8 1 (0.074%) Cognos Business Intelligence
8 1 (0.074%) Dynamics AX
8 1 (0.074%) Dynamics NAV
8 1 (0.074%) Hyperion Planning
8 1 (0.074%) Oracle AML
8 1 (0.074%) thinkFolio
Cloud Services
1 169 (12.51%) Microsoft Azure
2 106 (7.85%) Amazon AWS
3 29 (2.15%) Office 365
4 18 (1.33%) GitHub
4 18 (1.33%) SaaS
5 16 (1.18%) Serverless
6 11 (0.81%) Amazon CloudWatch
6 11 (0.81%) Dynamics 365
7 10 (0.74%) Azure Functions
7 10 (0.74%) Cloud Computing
7 10 (0.74%) Google Cloud Platform
7 10 (0.74%) npm
7 10 (0.74%) OpenShift
8 9 (0.67%) PaaS
8 9 (0.67%) Yammer
9 8 (0.59%) Amazon EC2
10 7 (0.52%) Amazon EMR
10 7 (0.52%) IaaS
11 6 (0.44%) Amazon S3
12 5 (0.37%) AWS Lambda
Communications & Networking
1 25 (1.85%) DNS
2 19 (1.41%) TCP/IP
3 18 (1.33%) Firewall
4 16 (1.18%) Internet
5 15 (1.11%) HTTP
6 13 (0.96%) Intranet
6 13 (0.96%) SMS
7 12 (0.89%) WAN
8 11 (0.81%) LAN
8 11 (0.81%) Skype
9 9 (0.67%) DHCP
10 7 (0.52%) Kerberos
10 7 (0.52%) Remote Desktop
11 6 (0.44%) AMQP
11 6 (0.44%) SAN
12 5 (0.37%) SSL
12 5 (0.37%) VPN
13 4 (0.30%) FTP
13 4 (0.30%) SSH
13 4 (0.30%) VoIP
Database & Business Intelligence
1 342 (25.31%) SQL Server
2 209 (15.47%) Relational Database
3 149 (11.03%) NoSQL
4 145 (10.73%) PostgreSQL
5 108 (7.99%) Data Warehouse
6 106 (7.85%) Big Data
7 103 (7.62%) MySQL
8 95 (7.03%) SQL Server Integration Services
9 90 (6.66%) SQL Server Reporting Services
10 77 (5.70%) Hadoop
11 64 (4.74%) Power BI
12 63 (4.66%) Apache Cassandra
13 59 (4.37%) RDBMS
14 57 (4.22%) Oracle Database
15 55 (4.07%) SQL Server 2012
16 49 (3.63%) Bigtable
17 38 (2.81%) SQL Server Analysis Services
18 35 (2.59%) QlikView
19 27 (2.00%) Oracle Reports
20 25 (1.85%) MongoDB
Development Applications
1 171 (12.66%) Git (software)
2 118 (8.73%) Visual Studio
3 91 (6.74%) Jenkins
4 85 (6.29%) Selenium
5 70 (5.18%) Cucumber
6 61 (4.52%) Maven
7 60 (4.44%) JIRA
8 57 (4.22%) SpecFlow
9 51 (3.77%) Subversion
9 51 (3.77%) TeamCity
10 41 (3.03%) JUnit
11 36 (2.66%) Hudson
12 30 (2.22%) Eclipse
13 27 (2.00%) Team Foundation Server
14 25 (1.85%) Toad
15 23 (1.70%) NUnit
15 23 (1.70%) Oracle Forms
16 20 (1.48%) NetBeans
17 19 (1.41%) Ant
18 18 (1.33%) Ranorex
General
1 466 (34.49%) Finance
2 125 (9.25%) Banking
3 30 (2.22%) Retail
4 25 (1.85%) Marketing
5 24 (1.78%) Investment Banking
6 23 (1.70%) Law
7 22 (1.63%) Financial Institution
8 12 (0.89%) Retail Banking
9 10 (0.74%) Front Office
10 9 (0.67%) Manufacturing
11 7 (0.52%) Back Office
12 6 (0.44%) Corporate Banking
13 5 (0.37%) Automotive
13 5 (0.37%) Electronics
13 5 (0.37%) Legal
13 5 (0.37%) Telecoms
14 3 (0.22%) Games
14 3 (0.22%) Local Government
15 2 (0.15%) Advertising
15 2 (0.15%) Multimedia
Job Titles
1 586 (43.38%) Developer
2 178 (13.18%) Analyst
3 146 (10.81%) .NET Developer
4 142 (10.51%) Java Developer
5 112 (8.29%) Senior Developer
5 112 (8.29%) Software Engineer
6 89 (6.59%) Software Developer
7 82 (6.07%) Java Engineer
8 81 (6.00%) C# Developer
9 77 (5.70%) SQL Developer
10 58 (4.29%) Consultant
11 56 (4.15%) C# .NET Developer
11 56 (4.15%) Python Engineer
12 50 (3.70%) Test Engineer
13 48 (3.55%) C++ Developer
14 47 (3.48%) C# Software Engineer
15 43 (3.18%) Senior .NET Developer
16 40 (2.96%) DBA
16 40 (2.96%) Junior
17 39 (2.89%) Test Analyst
Libraries, Frameworks & Software Standards
1 336 (24.87%) .NET
2 298 (22.06%) HTML
3 211 (15.62%) AngularJS
4 208 (15.40%) CSS
5 201 (14.88%) XML
6 131 (9.70%) Spring
7 118 (8.73%) jQuery
8 107 (7.92%) HTML5
9 104 (7.70%) Web Services
10 101 (7.48%) Hibernate
11 100 (7.40%) ASP.NET
12 81 (6.00%) JSON
13 79 (5.85%) Middleware
14 77 (5.70%) React
15 70 (5.18%) SOAP
16 69 (5.11%) RESTful
17 68 (5.03%) CSS3
17 68 (5.03%) REST
18 57 (4.22%) ASP.NET Web API
19 56 (4.15%) Gherkin
Miscellaneous
1 158 (11.70%) Analytical Skills
2 94 (6.96%) Enterprise Software
3 68 (5.03%) Greenfield Project
4 58 (4.29%) Virtual Team
5 54 (4.00%) Fintech
6 43 (3.18%) Robotics
7 42 (3.11%) Management Information System
8 23 (1.70%) Algorithms
9 21 (1.55%) Replication
10 14 (1.04%) Clustering
10 14 (1.04%) Mobile App
10 14 (1.04%) Self-Motivation
11 13 (0.96%) Foreign Exchange (FX)
11 13 (0.96%) User Experience
12 12 (0.89%) Derivative
12 12 (0.89%) Mainframe
13 11 (0.81%) Linux Command Line
14 10 (0.74%) Hybrid Cloud
15 7 (0.52%) DataPower
16 6 (0.44%) Smartphone
Operating Systems
1 171 (12.66%) Windows
2 146 (10.81%) Linux
3 86 (6.37%) Unix
4 40 (2.96%) Windows Server
5 33 (2.44%) Android
6 31 (2.29%) Apple iOS
7 9 (0.67%) Windows Server 2008
8 7 (0.52%) AIX
9 6 (0.44%) Windows 10
9 6 (0.44%) Windows Server 2012
10 4 (0.30%) Windows 7
10 4 (0.30%) Windows Server 2003
11 3 (0.22%) Solaris
12 2 (0.15%) Red Hat Enterprise Linux
12 2 (0.15%) Tru64
12 2 (0.15%) Windows 2000
12 2 (0.15%) Windows XP
13 1 (0.074%) CentOS
13 1 (0.074%) Ubuntu
13 1 (0.074%) Windows Phone
Processes & Methodologies
1 543 (40.19%) Agile Software Development
2 246 (18.21%) Test Automation
3 231 (17.10%) OO
4 197 (14.58%) SDLC
5 186 (13.77%) TDD
6 178 (13.18%) Scrum
7 168 (12.44%) Software Engineering
8 159 (11.77%) Business Intelligence
8 159 (11.77%) MVC
9 131 (9.70%) OOP
10 130 (9.62%) Unit Testing
11 125 (9.25%) Continuous Integration
12 114 (8.44%) Analytics
13 108 (7.99%) ETL
14 107 (7.92%) BDD
14 107 (7.92%) Problem-Solving
15 100 (7.40%) Mentoring
16 97 (7.18%) Data Modelling
17 82 (6.07%) Computer Science
18 74 (5.48%) System Testing
Programming Languages
1 453 (33.53%) Java
2 416 (30.79%) C#
3 386 (28.57%) JavaScript
4 279 (20.65%) Python
5 209 (15.47%) PL/SQL
6 133 (9.84%) T-SQL
7 125 (9.25%) C++
8 75 (5.55%) PHP
9 58 (4.29%) Ruby
10 50 (3.70%) XPath
11 38 (2.81%) PowerShell
12 34 (2.52%) TypeScript
13 33 (2.44%) R
14 30 (2.22%) Bash Shell
14 30 (2.22%) Shell Script
15 23 (1.70%) VB.NET
16 21 (1.55%) Scala
17 16 (1.18%) Java 8
17 16 (1.18%) Perl
17 16 (1.18%) VB
Qualifications
1 185 (13.69%) Degree
2 35 (2.59%) Computer Science Degree
3 28 (2.07%) Numerate Degree
4 15 (1.11%) Microsoft Certification
5 13 (0.96%) ISTQB
6 12 (0.89%) ISEB
7 7 (0.52%) ISTQB Foundation Certification
7 7 (0.52%) MCSE
8 6 (0.44%) Security Cleared
9 5 (0.37%) HND
9 5 (0.37%) MCP
10 4 (0.30%) MCSA
10 4 (0.30%) OCP
10 4 (0.30%) Oracle Certification
10 4 (0.30%) PhD
11 3 (0.22%) CEH
11 3 (0.22%) CISSP
11 3 (0.22%) SSCP
12 2 (0.15%) CISA
12 2 (0.15%) CISM
Quality Assurance & Compliance
1 104 (7.70%) QA
2 27 (2.00%) Data Quality
3 11 (0.81%) SLA
4 4 (0.30%) COBIT
4 4 (0.30%) GDPR
4 4 (0.30%) ISO/IEC 27001
4 4 (0.30%) PMO
5 3 (0.22%) SEPA
6 2 (0.15%) PCI DSS
7 1 (0.074%) Actionable Recommendations
7 1 (0.074%) Cyber Essentials
7 1 (0.074%) Cyber Essentials PLUS
7 1 (0.074%) HL7
7 1 (0.074%) ISO/IEC 20000
System Software
1 86 (6.37%) Docker
2 42 (3.11%) Active Directory
3 17 (1.26%) VMware Infrastructure
4 16 (1.18%) Hyper-V
5 9 (0.67%) vSphere
6 6 (0.44%) Oracle RAC
6 6 (0.44%) Tivoli Workload Scheduler
7 4 (0.30%) HDFS
7 4 (0.30%) NFS
7 4 (0.30%) Samba
7 4 (0.30%) Xen
7 4 (0.30%) XenServer
8 3 (0.22%) Firmware
8 3 (0.22%) Virtual Machines
8 3 (0.22%) VMware ESXi
9 2 (0.15%) XenApp
10 1 (0.074%) Job Entry Subsystem
10 1 (0.074%) Microsoft App-V
10 1 (0.074%) RACF
10 1 (0.074%) Time Sharing Option
Systems Management
1 81 (6.00%) Ansible
2 66 (4.89%) Puppet
3 30 (2.22%) Kubernetes
4 17 (1.26%) Opscode Chef
5 11 (0.81%) Systems Management Server (SMS)
6 10 (0.74%) Tivoli
7 9 (0.67%) HP Quality Center
8 7 (0.52%) Oozie
8 7 (0.52%) Oracle RMAN
9 6 (0.44%) SCCM
9 6 (0.44%) Terraform
10 4 (0.30%) Cobbler
10 4 (0.30%) Kibana
10 4 (0.30%) Prometheus
11 3 (0.22%) Data Guard
11 3 (0.22%) Enterprise Manager Cloud Control
11 3 (0.22%) HP ALM
12 2 (0.15%) Microsoft Clustering
12 2 (0.15%) Single Sign-On
12 2 (0.15%) Sysdig
Vendors
1 379 (28.05%) Oracle
2 221 (16.36%) Microsoft
3 35 (2.59%) Tableau
4 31 (2.29%) Xamarin
5 28 (2.07%) VMware
6 25 (1.85%) IBM
7 23 (1.70%) Google
7 23 (1.70%) Solace
7 23 (1.70%) TIBCO
8 22 (1.63%) Sybase
9 18 (1.33%) Teradata
10 17 (1.26%) Cognos
11 15 (1.11%) MicroStrategy
12 14 (1.04%) Cognizant
12 14 (1.04%) Talarian
13 13 (0.96%) SAP
14 11 (0.81%) Informatica
14 11 (0.81%) New Relic
14 11 (0.81%) Salesforce.com
15 10 (0.74%) Red Hat