Period
to 24 May 2018

The following table provides summary statistics for permanent job vacancies advertised in Portsmouth 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 24 May 2018 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
Hampshire > Portsmouth
6 months to
24 May 2018
Same period 2017 Same period 2016
Rank 2 7 4
Rank change year-on-year +5 -3 -3
Permanent jobs citing SQL 216 199 138
As % of all permanent IT jobs advertised in Portsmouth 36.42% 31.24% 27.38%
As % of the Programming Languages category 60.00% 46.50% 42.20%
Number of salaries quoted 176 183 138
Portsmouth median annual salary £42,500 £40,000 £40,000
Median salary % change year-on-year +6.25% - -
10th Percentile £24,000 £22,500 £26,250
90th Percentile £57,500 £53,700 £55,000
Hampshire median annual salary £40,000 £40,000 £37,500
% change year-on-year - +6.67% -6.25%

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 Portsmouth with a requirement for coding skills.

All Programming Languages
Portsmouth
Permanent vacancies with a requirement for coding skills 360 428 327
As % of all permanent IT jobs advertised in Portsmouth 60.71% 67.19% 64.88%
Number of salaries quoted 284 394 314
Portsmouth median annual salary £42,500 £40,000 £40,000
Median salary % change year-on-year +6.25% - -
10th Percentile £26,250 £25,000 £26,625
90th Percentile £57,500 £56,250 £55,000
Hampshire median annual salary £42,500 £40,000 £40,000
% change year-on-year +6.25% - -

SQL
Job Vacancy Trend in Portsmouth

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

Job vacancy trend for SQL in Portsmouth

SQL
Salary Trend in Portsmouth

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

Salary trend for SQL in Portsmouth

SQL
Salary Histogram in Portsmouth

The salary distribution of IT jobs citing SQL in Portsmouth over the 6 months to 24 May 2018.

Salary histogram for SQL in Portsmouth

For the 6 months to 24 May 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 Portsmouth region with a requirement for SQL.

1 125 (57.87%) SQL Server
2 120 (55.56%) C#
3 117 (54.17%) .NET
4 96 (44.44%) JavaScript
5 79 (36.57%) MVC
6 69 (31.94%) HTML
7 67 (31.02%) ASP.NET
8 61 (28.24%) T-SQL
9 60 (27.78%) CSS
10 57 (26.39%) Microsoft
11 56 (25.93%) ASP.NET MVC
12 53 (24.54%) AngularJS
13 52 (24.07%) Agile Software Development
14 46 (21.30%) E-Commerce
15 44 (20.37%) jQuery
15 44 (20.37%) Analytics
16 42 (19.44%) Problem-Solving
17 37 (17.13%) Business Intelligence
18 36 (16.67%) SQL Server 2016
19 34 (15.74%) Git (software)
20 33 (15.28%) SQL Server Integration Services
21 32 (14.81%) SQL Server Reporting Services
21 32 (14.81%) Performance Tuning
22 30 (13.89%) Retail
22 30 (13.89%) HTML5
23 29 (13.43%) Analytical Skills
23 29 (13.43%) Linux
23 29 (13.43%) Web Services
24 28 (12.96%) Microsoft Azure
25 27 (12.50%) Data Analytics

SQL
Co-occurring IT Skills in Portsmouth 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 9 (4.17%) NServiceBus
2 7 (3.24%) SharePoint
3 6 (2.78%) Confluence
4 4 (1.85%) SAS
5 3 (1.39%) Apache
5 3 (1.39%) BizTalk Server
5 3 (1.39%) Elasticsearch
5 3 (1.39%) MQSeries
5 3 (1.39%) nginx
6 1 (0.46%) Apache Spark
6 1 (0.46%) CMS
6 1 (0.46%) IIS
6 1 (0.46%) Tomcat
Applications
1 11 (5.09%) SPSS
2 3 (1.39%) Microsoft Excel
3 2 (0.93%) Microsoft Office
4 1 (0.46%) MS Visio
Business Applications
1 9 (4.17%) SAP ERP
2 5 (2.31%) Dynamics AX
3 1 (0.46%) Oracle EBS
3 1 (0.46%) Oracle EBS R12
3 1 (0.46%) Oracle ERP
Cloud Services
1 28 (12.96%) Microsoft Azure
2 15 (6.94%) GitHub
3 10 (4.63%) Amazon AWS
4 5 (2.31%) Dynamics 365
5 4 (1.85%) Boomi
5 4 (1.85%) Google Analytics
5 4 (1.85%) SaaS
5 4 (1.85%) SuccessFactors
6 3 (1.39%) Office 365
7 2 (0.93%) Amazon S3
Communications & Networking
1 8 (3.70%) TCP/IP
2 6 (2.78%) Internet
3 5 (2.31%) HTTP
4 4 (1.85%) DNS
4 4 (1.85%) SMTP
5 1 (0.46%) CTI
5 1 (0.46%) SNMP
5 1 (0.46%) VoIP
Database & Business Intelligence
1 125 (57.87%) SQL Server
2 36 (16.67%) SQL Server 2016
3 33 (15.28%) SQL Server Integration Services
4 32 (14.81%) SQL Server Reporting Services
5 23 (10.65%) SQL Server 2012
6 22 (10.19%) Big Data
7 17 (7.87%) SQL Server 2005
7 17 (7.87%) SQL Server 2008
7 17 (7.87%) SQL Server Analysis Services
8 15 (6.94%) MySQL
8 15 (6.94%) Power BI
9 12 (5.56%) MongoDB
10 11 (5.09%) InfluxDB
11 8 (3.70%) Crystal Reports
11 8 (3.70%) Data Warehouse
12 7 (3.24%) SAP BW
13 6 (2.78%) NoSQL
14 5 (2.31%) OLAP Cube
14 5 (2.31%) RDBMS
14 5 (2.31%) Relational Database
Development Applications
1 34 (15.74%) Git (software)
2 15 (6.94%) Jenkins
3 11 (5.09%) SQL Server Management Studio (SSMS)
4 10 (4.63%) Moq
4 10 (4.63%) NUnit
5 9 (4.17%) JIRA
6 7 (3.24%) Octopus Deploy
6 7 (3.24%) TeamCity
7 5 (2.31%) Selenium
7 5 (2.31%) Team Foundation Server
7 5 (2.31%) Visual Studio
8 4 (1.85%) Cucumber
8 4 (1.85%) Subversion
8 4 (1.85%) webpack
9 3 (1.39%) HP UFT
9 3 (1.39%) RSpec
10 2 (0.93%) Rational DOORS
11 1 (0.46%) Gitweb
11 1 (0.46%) Mercurial
General
1 30 (13.89%) Retail
2 17 (7.87%) Marketing
3 11 (5.09%) Advertising
3 11 (5.09%) Finance
4 3 (1.39%) Banking
5 2 (0.93%) Aerospace
5 2 (0.93%) Back Office
5 2 (0.93%) Telecoms
6 1 (0.46%) Legal
6 1 (0.46%) Manufacturing
Job Titles
1 132 (61.11%) Developer
2 75 (34.72%) .NET Developer
3 62 (28.70%) C# Developer
4 55 (25.46%) C# .NET Developer
5 49 (22.69%) Software Developer
6 39 (18.06%) ASP.NET Developer
6 39 (18.06%) C# ASP.NET Developer
7 37 (17.13%) Senior Developer
8 35 (16.20%) .NET Software Developer
9 33 (15.28%) Senior .NET Developer
10 32 (14.81%) ASP.NET MVC Developer
11 31 (14.35%) Analyst
11 31 (14.35%) C# Software Developer
12 30 (13.89%) Senior Software Developer
13 28 (12.96%) Senior .NET Software Developer
14 27 (12.50%) Senior C# .NET Developer
14 27 (12.50%) Senior C# Developer
15 25 (11.57%) DBA
16 24 (11.11%) Senior C# Software Developer
17 21 (9.72%) Senior C# ASP.NET Developer
Libraries, Frameworks & Software Standards
1 117 (54.17%) .NET
2 69 (31.94%) HTML
3 67 (31.02%) ASP.NET
4 60 (27.78%) CSS
5 56 (25.93%) ASP.NET MVC
6 53 (24.54%) AngularJS
7 44 (20.37%) jQuery
8 30 (13.89%) HTML5
9 29 (13.43%) Web Services
10 20 (9.26%) CSS3
10 20 (9.26%) Twitter Bootstrap
11 19 (8.80%) Kendo UI
12 16 (7.41%) .NET Core
13 15 (6.94%) ASP.NET Web API
14 13 (6.02%) ASP.NET Web Forms
14 13 (6.02%) React
14 13 (6.02%) WCF
15 12 (5.56%) .NET Framework
15 12 (5.56%) KnockoutJS
16 9 (4.17%) NHibernate
Miscellaneous
1 29 (13.43%) Analytical Skills
2 17 (7.87%) Replication
3 14 (6.48%) Greenfield Project
4 9 (4.17%) Algorithms
5 6 (2.78%) Management Information System
5 6 (2.78%) Self-Motivation
6 4 (1.85%) Enterprise Software
7 3 (1.39%) Computer Science
7 3 (1.39%) Credit Risk
8 1 (0.46%) Clustering
8 1 (0.46%) Data Centre
Operating Systems
1 29 (13.43%) Linux
2 24 (11.11%) Windows
3 12 (5.56%) Unix
4 7 (3.24%) Windows 10
4 7 (3.24%) Windows 7
5 6 (2.78%) Windows Server
6 4 (1.85%) Solaris
6 4 (1.85%) Windows Server 2008
7 3 (1.39%) Ubuntu
Processes & Methodologies
1 79 (36.57%) MVC
2 52 (24.07%) Agile Software Development
3 46 (21.30%) E-Commerce
4 44 (20.37%) Analytics
5 42 (19.44%) Problem-Solving
6 37 (17.13%) Business Intelligence
7 32 (14.81%) Performance Tuning
8 27 (12.50%) Data Analytics
8 27 (12.50%) ETL
9 26 (12.04%) CRM
9 26 (12.04%) Data Modelling
9 26 (12.04%) Software Engineering
10 23 (10.65%) Unit Testing
11 22 (10.19%) Statistics
12 20 (9.26%) Mentoring
13 17 (7.87%) Data Analysis
13 17 (7.87%) Web Development
14 14 (6.48%) Machine Learning
15 13 (6.02%) Scrum
15 13 (6.02%) SOLID
Programming Languages
1 120 (55.56%) C#
2 96 (44.44%) JavaScript
3 61 (28.24%) T-SQL
4 19 (8.80%) VB.NET
5 15 (6.94%) R
6 14 (6.48%) TypeScript
7 12 (5.56%) Java
7 12 (5.56%) Python
8 10 (4.63%) VB
9 8 (3.70%) C
9 8 (3.70%) VBScript
10 6 (2.78%) PL/SQL
11 4 (1.85%) ABAP
11 4 (1.85%) C++
11 4 (1.85%) PowerShell
11 4 (1.85%) Ruby
11 4 (1.85%) Shell Script
12 2 (0.93%) VB6
13 1 (0.46%) PHP
13 1 (0.46%) Scala
Qualifications
1 18 (8.33%) Security Cleared
2 17 (7.87%) Degree
2 17 (7.87%) SC Cleared
3 11 (5.09%) Numerate Degree
4 3 (1.39%) Computer Science Degree
5 1 (0.46%) MCITP
5 1 (0.46%) MCTS
5 1 (0.46%) Microsoft Certification
5 1 (0.46%) PhD
Quality Assurance & Compliance
1 13 (6.02%) QA
2 8 (3.70%) Data Quality
3 5 (2.31%) PMO
4 4 (1.85%) ISO/IEC 20000
5 1 (0.46%) ISO/IEC 27001
5 1 (0.46%) SLA
System Software
1 15 (6.94%) Docker
2 8 (3.70%) Active Directory
3 4 (1.85%) Oracle RAC
4 3 (1.39%) Postfix
Systems Management
1 15 (6.94%) Docker Swarm
2 11 (5.09%) Perfmon
3 4 (1.85%) HP ALM
3 4 (1.85%) SCCM
3 4 (1.85%) SCOM
4 3 (1.39%) Ansible
5 2 (0.93%) Oracle Enterprise Manager
5 2 (0.93%) SQL Sentry
6 1 (0.46%) BMC PATROL
Vendors
1 57 (26.39%) Microsoft
2 20 (9.26%) Oracle
3 16 (7.41%) SAP
4 4 (1.85%) Google
4 4 (1.85%) HP
4 4 (1.85%) VMware
5 2 (0.93%) Ariba
5 2 (0.93%) Salesforce.com
5 2 (0.93%) Tableau
6 1 (0.46%) Atlassian
6 1 (0.46%) Cognos