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

SQL (Structured Query Language)
Hampshire > Portsmouth
6 months to
14 Aug 2018
Same period 2017 Same period 2016
Rank 2 6 3
Rank change year-on-year +4 -3 -2
Permanent jobs citing SQL 206 240 160
As % of all permanent IT jobs advertised in Portsmouth 34.11% 32.79% 29.96%
As % of the Programming Languages category 52.82% 49.59% 51.12%
Number of salaries quoted 174 222 158
Portsmouth median annual salary £42,500 £42,500 £40,000
Median salary % change year-on-year - +6.25% -5.88%
10th Percentile £24,000 £25,000 £27,500
90th Percentile £62,500 £54,875 £55,000
Hampshire median annual salary £42,000 £40,000 £37,500
% change year-on-year +5.00% +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 390 484 313
As % of all permanent IT jobs advertised in Portsmouth 64.57% 66.12% 58.61%
Number of salaries quoted 320 446 298
Portsmouth median annual salary £42,500 £42,500 £40,000
Median salary % change year-on-year - +6.25% -6.43%
10th Percentile £26,250 £25,000 £27,500
90th Percentile £58,750 £57,500 £56,250
Hampshire median annual salary £43,900 £42,500 £40,000
% change year-on-year +3.29% +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 14 August 2018.

Salary histogram for SQL in Portsmouth

For the 6 months to 14 August 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 110 (53.40%) SQL Server
2 102 (49.51%) C#
3 99 (48.06%) .NET
4 88 (42.72%) JavaScript
5 80 (38.83%) Microsoft
6 65 (31.55%) HTML
7 64 (31.07%) MVC
8 59 (28.64%) ASP.NET
9 57 (27.67%) CSS
10 53 (25.73%) T-SQL
11 51 (24.76%) ASP.NET MVC
12 50 (24.27%) Agile Software Development
13 48 (23.30%) Business Intelligence
14 41 (19.90%) AngularJS
15 39 (18.93%) E-Commerce
15 39 (18.93%) Oracle
16 37 (17.96%) Analytics
17 35 (16.99%) jQuery
18 31 (15.05%) HTML5
18 31 (15.05%) Problem-Solving
19 29 (14.08%) Finance
20 28 (13.59%) Retail
21 27 (13.11%) Web Services
21 27 (13.11%) SAP
21 27 (13.11%) Git (software)
21 27 (13.11%) Performance Tuning
22 26 (12.62%) CRM
23 25 (12.14%) Data Modelling
23 25 (12.14%) CSS3
24 24 (11.65%) Software Engineering

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 11 (5.34%) SharePoint
2 8 (3.88%) BizTalk Server
2 8 (3.88%) MQSeries
3 5 (2.43%) NServiceBus
4 4 (1.94%) SAS
5 3 (1.46%) Apache
5 3 (1.46%) nginx
6 2 (0.97%) IIS
7 1 (0.49%) Apache Solr
7 1 (0.49%) Apache Spark
7 1 (0.49%) CMS
7 1 (0.49%) Confluence
7 1 (0.49%) Elasticsearch
Applications
1 6 (2.91%) SPSS
2 4 (1.94%) Microsoft Excel
3 2 (0.97%) Microsoft Office
3 2 (0.97%) MS Visio
Business Applications
1 18 (8.74%) SAP ERP
2 5 (2.43%) Dynamics AX
3 2 (0.97%) Oracle EBS
3 2 (0.97%) Oracle EBS R12
3 2 (0.97%) Oracle ERP
4 1 (0.49%) Dynamics CRM
Cloud Services
1 15 (7.28%) Microsoft Azure
2 14 (6.80%) Amazon AWS
2 14 (6.80%) Boomi
3 8 (3.88%) SuccessFactors
4 7 (3.40%) GitHub
4 7 (3.40%) Google Analytics
5 6 (2.91%) Dynamics 365
6 3 (1.46%) Office 365
7 2 (0.97%) Amazon S3
8 1 (0.49%) npm
Communications & Networking
1 4 (1.94%) TCP/IP
2 2 (0.97%) DNS
2 2 (0.97%) IMAP
2 2 (0.97%) Internet
2 2 (0.97%) SMTP
3 1 (0.49%) CTI
3 1 (0.49%) HTTP
3 1 (0.49%) VoIP
Database & Business Intelligence
1 110 (53.40%) SQL Server
2 22 (10.68%) SQL Server Integration Services
2 22 (10.68%) SQL Server Reporting Services
3 19 (9.22%) Big Data
3 19 (9.22%) SQL Server 2016
4 16 (7.77%) SQL Server 2008
5 14 (6.80%) MySQL
5 14 (6.80%) Power BI
5 14 (6.80%) SQL Server 2012
6 13 (6.31%) SQL Server 2005
6 13 (6.31%) SQL Server Analysis Services
7 10 (4.85%) NoSQL
7 10 (4.85%) Relational Database
8 9 (4.37%) QlikView
9 8 (3.88%) SAP Data Services
10 7 (3.40%) Data Warehouse
10 7 (3.40%) RDBMS
11 5 (2.43%) MongoDB
12 4 (1.94%) OLAP
12 4 (1.94%) OLAP Cube
Development Applications
1 27 (13.11%) Git (software)
2 20 (9.71%) Team Foundation Server
3 9 (4.37%) InstallShield
3 9 (4.37%) NUnit
3 9 (4.37%) SQL Server Management Studio (SSMS)
4 8 (3.88%) JIRA
4 8 (3.88%) WiX
5 7 (3.40%) HP UFT
5 7 (3.40%) Visual Studio
6 6 (2.91%) Jenkins
6 6 (2.91%) Moq
7 5 (2.43%) Octopus Deploy
7 5 (2.43%) TeamCity
8 4 (1.94%) webpack
9 3 (1.46%) Cucumber
9 3 (1.46%) RSpec
9 3 (1.46%) Subversion
10 2 (0.97%) Rational DOORS
11 1 (0.49%) Gitweb
11 1 (0.49%) Mercurial
General
1 29 (14.08%) Finance
2 28 (13.59%) Retail
3 15 (7.28%) Marketing
4 4 (1.94%) Back Office
5 3 (1.46%) Advertising
5 3 (1.46%) Banking
6 2 (0.97%) Aerospace
6 2 (0.97%) Manufacturing
6 2 (0.97%) Telecoms
7 1 (0.49%) Legal
Job Titles
1 116 (56.31%) Developer
2 69 (33.50%) .NET Developer
3 49 (23.79%) Software Developer
4 48 (23.30%) C# Developer
5 47 (22.82%) C# .NET Developer
6 39 (18.93%) .NET Software Developer
7 34 (16.50%) Senior Developer
8 32 (15.53%) C# Software Developer
9 31 (15.05%) Senior .NET Developer
10 30 (14.56%) ASP.NET Developer
10 30 (14.56%) C# ASP.NET Developer
11 25 (12.14%) Analyst
11 25 (12.14%) Senior Software Developer
11 25 (12.14%) SQL Developer
12 22 (10.68%) DBA
12 22 (10.68%) Senior .NET Software Developer
13 20 (9.71%) Senior C# .NET Developer
13 20 (9.71%) Senior C# Developer
14 19 (9.22%) ASP.NET MVC Developer
15 18 (8.74%) Senior C# Software Developer
Libraries, Frameworks & Software Standards
1 99 (48.06%) .NET
2 65 (31.55%) HTML
3 59 (28.64%) ASP.NET
4 57 (27.67%) CSS
5 51 (24.76%) ASP.NET MVC
6 41 (19.90%) AngularJS
7 35 (16.99%) jQuery
8 31 (15.05%) HTML5
9 27 (13.11%) Web Services
10 25 (12.14%) CSS3
11 21 (10.19%) XML
12 20 (9.71%) .NET Framework
13 16 (7.77%) ASP.NET Web API
13 16 (7.77%) React
14 15 (7.28%) J2EE
15 14 (6.80%) IDoc
15 14 (6.80%) SAP ALE
15 14 (6.80%) SAP PI
16 13 (6.31%) SAP Fiori
17 11 (5.34%) Entity Framework
Miscellaneous
1 23 (11.17%) Analytical Skills
2 19 (9.22%) Greenfield Project
3 14 (6.80%) Replication
4 12 (5.83%) Enterprise Software
5 8 (3.88%) Computer Science
5 8 (3.88%) Management Information System
6 5 (2.43%) Algorithms
6 5 (2.43%) Self-Motivation
7 3 (1.46%) Credit Risk
8 2 (0.97%) Driving Licence
8 2 (0.97%) W3C
9 1 (0.49%) Clustering
9 1 (0.49%) Data Centre
Operating Systems
1 24 (11.65%) Windows
2 20 (9.71%) Linux
3 8 (3.88%) Unix
4 7 (3.40%) Windows Server
5 4 (1.94%) Solaris
6 3 (1.46%) Ubuntu
6 3 (1.46%) Windows 10
6 3 (1.46%) Windows 7
7 1 (0.49%) Windows NT
7 1 (0.49%) Windows Server 2003
7 1 (0.49%) Windows Server 2008
Processes & Methodologies
1 64 (31.07%) MVC
2 50 (24.27%) Agile Software Development
3 48 (23.30%) Business Intelligence
4 39 (18.93%) E-Commerce
5 37 (17.96%) Analytics
6 31 (15.05%) Problem-Solving
7 27 (13.11%) Performance Tuning
8 26 (12.62%) CRM
9 25 (12.14%) Data Modelling
10 24 (11.65%) Software Engineering
11 23 (11.17%) ERP
12 21 (10.19%) ETL
12 21 (10.19%) Web Development
13 18 (8.74%) Data Analysis
13 18 (8.74%) Mentoring
14 14 (6.80%) SAP Implementation
14 14 (6.80%) TDD
15 13 (6.31%) Statistics
15 13 (6.31%) Test Automation
15 13 (6.31%) Unit Testing
Programming Languages
1 102 (49.51%) C#
2 88 (42.72%) JavaScript
3 53 (25.73%) T-SQL
4 24 (11.65%) Java
5 15 (7.28%) VB.NET
6 14 (6.80%) ABAP
6 14 (6.80%) TypeScript
7 11 (5.34%) VB
8 10 (4.85%) C
8 10 (4.85%) R
9 7 (3.40%) PL/SQL
9 7 (3.40%) Python
10 5 (2.43%) C++
11 4 (1.94%) Ruby
11 4 (1.94%) Shell Script
11 4 (1.94%) VBScript
12 3 (1.46%) VB6
13 2 (0.97%) Scala
14 1 (0.49%) ES6
14 1 (0.49%) PHP
Qualifications
1 24 (11.65%) SC Cleared
1 24 (11.65%) Security Cleared
2 21 (10.19%) Degree
3 6 (2.91%) Numerate Degree
4 4 (1.94%) ISEB
4 4 (1.94%) ISTQB
5 3 (1.46%) Computer Science Degree
6 1 (0.49%) ITIL Foundation Certificate
6 1 (0.49%) PhD
Quality Assurance & Compliance
1 14 (6.80%) QA
2 7 (3.40%) Data Quality
3 6 (2.91%) SLA
4 5 (2.43%) PMO
5 4 (1.94%) ISO/IEC 20000
System Software
1 14 (6.80%) Oracle RAC
2 7 (3.40%) Docker
3 4 (1.94%) Active Directory
4 3 (1.46%) Postfix
Systems Management
1 8 (3.88%) HP ALM
1 8 (3.88%) Perfmon
2 6 (2.91%) Docker Swarm
3 3 (1.46%) Ansible
4 2 (0.97%) SQL Sentry
5 1 (0.49%) BMC PATROL
5 1 (0.49%) Grafana
5 1 (0.49%) HP Quality Center
5 1 (0.49%) Kibana
5 1 (0.49%) Oracle Enterprise Manager
5 1 (0.49%) Terraform
Vendors
1 80 (38.83%) Microsoft
2 39 (18.93%) Oracle
3 27 (13.11%) SAP
4 8 (3.88%) HP
5 7 (3.40%) Google
6 6 (2.91%) Tableau
7 2 (0.97%) Cognos
7 2 (0.97%) Salesforce.com
8 1 (0.49%) Atlassian
8 1 (0.49%) Pegasus