Period
to 23 November 2017

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 23 November 2017 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
Hampshire > Portsmouth
6 months to
23 Nov 2017
Same period 2016 Same period 2015
Rank 5 3 2
Rank change year-on-year -2 -1 +10
Permanent jobs citing SQL 219 215 284
As % of all permanent IT jobs advertised in Portsmouth 31.69% 32.28% 34.98%
As % of the Programming Languages category 54.48% 54.57% 53.28%
Number of salaries quoted 228 214 286
Portsmouth median annual salary £43,500 £40,000 £42,500
Median salary % change year-on-year +8.75% -5.88% +13.33%
10th Percentile £26,250 £25,000 £25,000
90th Percentile £57,500 £52,500 £58,750
Hampshire median annual salary £40,000 £40,000 £40,000

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 402 394 533
As % of all permanent IT jobs advertised in Portsmouth 58.18% 59.16% 65.64%
Number of salaries quoted 369 382 461
Portsmouth median annual salary £42,500 £40,000 £42,500
Median salary % change year-on-year +6.25% -5.88% +6.25%
10th Percentile £23,950 £26,250 £27,500
90th Percentile £57,500 £56,125 £58,750
Hampshire median annual salary £42,500 £40,000 £42,500
% change year-on-year +6.25% -5.88% +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 23 November 2017.

Salary histogram for SQL in Portsmouth

For the 6 months to 23 November 2017, IT jobs citing SQL also mentioned the following skills in order of popularity. The figures indicate the number co-occurrences and its proportion to all job ads across the Portsmouth region with a requirement for SQL.

1 158 (72.15%) C#
2 145 (66.21%) .NET
3 144 (65.75%) MVC
4 121 (55.25%) JavaScript
5 111 (50.68%) HTML
6 109 (49.77%) ASP.NET
7 99 (45.21%) CSS
8 97 (44.29%) Agile Software Development
9 92 (42.01%) jQuery
10 86 (39.27%) ASP.NET MVC
11 79 (36.07%) AngularJS
12 73 (33.33%) SQL Server
13 56 (25.57%) Twitter Bootstrap
14 52 (23.74%) Kendo UI
15 50 (22.83%) Microsoft
16 48 (21.92%) Web Development
17 45 (20.55%) Retail
18 40 (18.26%) T-SQL
19 36 (16.44%) Analytics
20 35 (15.98%) Data Analytics
20 35 (15.98%) HTML5
21 34 (15.53%) NUnit
22 33 (15.07%) E-Commerce
23 32 (14.61%) Moq
24 31 (14.16%) Microsoft Azure
25 30 (13.70%) NServiceBus
25 30 (13.70%) ASP.NET Web API
26 26 (11.87%) Back Office
27 25 (11.42%) Python
27 25 (11.42%) Ruby

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 30 (13.70%) NServiceBus
2 6 (2.74%) IIS
2 6 (2.74%) Tomcat
3 4 (1.83%) Apache Spark
3 4 (1.83%) MS Exchange
4 3 (1.37%) SharePoint
5 2 (0.91%) Apache
5 2 (0.91%) CMS
5 2 (0.91%) Moodle
5 2 (0.91%) Skype for Business
6 1 (0.46%) Confluence
6 1 (0.46%) Elasticsearch
6 1 (0.46%) WebLogic
6 1 (0.46%) WebSphere
Applications
1 7 (3.20%) Microsoft Excel
2 2 (0.91%) MS Visio
2 2 (0.91%) Photoshop
Business Applications
1 3 (1.37%) SAP ERP
2 1 (0.46%) Infor M3
2 1 (0.46%) Oracle Applications
2 1 (0.46%) Oracle EBS
2 1 (0.46%) Oracle EBS R12
Cloud Services
1 31 (14.16%) Microsoft Azure
2 19 (8.68%) GitHub
3 8 (3.65%) Amazon AWS
3 8 (3.65%) SaaS
4 3 (1.37%) PaaS
5 2 (0.91%) Cloud Computing
5 2 (0.91%) npm
5 2 (0.91%) Office 365
6 1 (0.46%) Google Cloud Platform
6 1 (0.46%) SuccessFactors
Communications & Networking
1 5 (2.28%) TCP/IP
2 4 (1.83%) SNMP
3 3 (1.37%) DNS
3 3 (1.37%) Internet
3 3 (1.37%) SMTP
3 3 (1.37%) SSL
4 2 (0.91%) IMAP
4 2 (0.91%) SAN
5 1 (0.46%) HTTP
5 1 (0.46%) tcpdump
5 1 (0.46%) Wireshark
Database & Business Intelligence
1 73 (33.33%) SQL Server
2 22 (10.05%) SQL Server 2016
3 15 (6.85%) NoSQL
3 15 (6.85%) Redis
4 14 (6.39%) SQL Server Integration Services
4 14 (6.39%) SQL Server Reporting Services
5 12 (5.48%) SQL Server 2008
6 8 (3.65%) Data Warehouse
7 6 (2.74%) MongoDB
7 6 (2.74%) Relational Database
7 6 (2.74%) SQL Server Analysis Services
8 5 (2.28%) Big Data
8 5 (2.28%) SQL Server 2012
9 4 (1.83%) MySQL
9 4 (1.83%) OLAP
10 3 (1.37%) InfluxDB
10 3 (1.37%) SAP BW
10 3 (1.37%) SQL Server 2005
11 2 (0.91%) Microsoft Power View
11 2 (0.91%) OLAP Cube
Development Applications
1 34 (15.53%) NUnit
2 32 (14.61%) Moq
3 23 (10.50%) Jenkins
4 22 (10.05%) Git (software)
5 11 (5.02%) Selenium
6 9 (4.11%) JIRA
7 8 (3.65%) Team Foundation Server
8 6 (2.74%) Visual Studio
9 4 (1.83%) Atlassian Bamboo
9 4 (1.83%) Subversion
9 4 (1.83%) Travis CI
10 3 (1.37%) SQL Server Management Studio (SSMS)
10 3 (1.37%) Vagrant
11 1 (0.46%) Oracle Forms
11 1 (0.46%) TeamCity
General
1 45 (20.55%) Retail
2 26 (11.87%) Back Office
3 11 (5.02%) Finance
4 6 (2.74%) Marketing
5 2 (0.91%) Advertising
6 1 (0.46%) Aerospace
Job Titles
1 152 (69.41%) Developer
2 92 (42.01%) C# Developer
3 79 (36.07%) .NET Developer
4 67 (30.59%) C# .NET Developer
5 57 (26.03%) Software Developer
6 47 (21.46%) ASP.NET Developer
6 47 (21.46%) C# ASP.NET Developer
7 44 (20.09%) ASP.NET MVC Developer
8 34 (15.53%) Senior Developer
9 33 (15.07%) SQL Developer
10 29 (13.24%) Senior .NET Developer
10 29 (13.24%) Senior C# Developer
11 28 (12.79%) Senior C# .NET Developer
12 27 (12.33%) .NET Software Developer
13 26 (11.87%) C# Software Developer
13 26 (11.87%) Senior ASP.NET Developer
13 26 (11.87%) Senior C# ASP.NET Developer
14 22 (10.05%) Senior ASP.NET MVC Developer
15 20 (9.13%) Senior Software Developer
16 18 (8.22%) JavaScript Developer
Libraries, Frameworks & Software Standards
1 145 (66.21%) .NET
2 111 (50.68%) HTML
3 109 (49.77%) ASP.NET
4 99 (45.21%) CSS
5 92 (42.01%) jQuery
6 86 (39.27%) ASP.NET MVC
7 79 (36.07%) AngularJS
8 56 (25.57%) Twitter Bootstrap
9 52 (23.74%) Kendo UI
10 35 (15.98%) HTML5
11 30 (13.70%) ASP.NET Web API
12 23 (10.50%) Web Services
13 21 (9.59%) ASP.NET Web Forms
14 19 (8.68%) .NET Core
14 19 (8.68%) KnockoutJS
15 13 (5.94%) ASP.NET MVC 3
16 12 (5.48%) XML
17 9 (4.11%) Ajax
17 9 (4.11%) Ruby on Rails
18 7 (3.20%) .NET Framework
Miscellaneous
1 15 (6.85%) Wiki
2 10 (4.57%) User Experience
3 9 (4.11%) Greenfield Project
4 7 (3.20%) EPoS
5 6 (2.74%) Analytical Skills
5 6 (2.74%) Computer Science
6 4 (1.83%) Management Information System
7 3 (1.37%) Learning Management System
7 3 (1.37%) Replication
8 2 (0.91%) Data Centre
8 2 (0.91%) Data Structures
8 2 (0.91%) Enterprise Software
9 1 (0.46%) W3C
Operating Systems
1 20 (9.13%) Linux
2 16 (7.31%) Windows
3 8 (3.65%) Windows Server
4 5 (2.28%) Unix
5 1 (0.46%) AIX
5 1 (0.46%) Solaris
Processes & Methodologies
1 144 (65.75%) MVC
2 97 (44.29%) Agile Software Development
3 48 (21.92%) Web Development
4 36 (16.44%) Analytics
5 35 (15.98%) Data Analytics
6 33 (15.07%) E-Commerce
7 25 (11.42%) Scrum
7 25 (11.42%) SOLID
8 24 (10.96%) SDLC
9 20 (9.13%) Business Intelligence
10 18 (8.22%) Software Engineering
11 17 (7.76%) SOA
12 15 (6.85%) Pair Programming
13 14 (6.39%) CRM
13 14 (6.39%) Unit Testing
14 13 (5.94%) Front End Development
15 12 (5.48%) Mentoring
15 12 (5.48%) TDD
16 8 (3.65%) Continuous Integration
16 8 (3.65%) ITIL
Programming Languages
1 158 (72.15%) C#
2 121 (55.25%) JavaScript
3 40 (18.26%) T-SQL
4 25 (11.42%) Python
4 25 (11.42%) Ruby
5 23 (10.50%) Java
6 11 (5.02%) VB.NET
7 6 (2.74%) Bash Shell
8 5 (2.28%) C
8 5 (2.28%) PL/SQL
9 4 (1.83%) PowerShell
10 2 (0.91%) C++
10 2 (0.91%) PHP
11 1 (0.46%) Perl
11 1 (0.46%) VBA
11 1 (0.46%) VBScript
Qualifications
1 13 (5.94%) Security Cleared
2 9 (4.11%) SC Cleared
3 7 (3.20%) Degree
4 4 (1.83%) ISTQB
4 4 (1.83%) Microsoft Certification
5 3 (1.37%) ISEB
6 2 (0.91%) Computer Science Degree
6 2 (0.91%) MCSA
6 2 (0.91%) MCSE
7 1 (0.46%) DV Cleared
Quality Assurance & Compliance
1 9 (4.11%) QA
2 4 (1.83%) ISO/IEC 20000
3 2 (0.91%) Data Quality
4 1 (0.46%) PCI DSS
System Software
1 24 (10.96%) Docker
2 6 (2.74%) Active Directory
3 4 (1.83%) VMware Workstation
4 2 (0.91%) Hyper-V
4 2 (0.91%) VMware Infrastructure
5 1 (0.46%) Tivoli Workload Scheduler
Systems Management
1 19 (8.68%) Docker Swarm
2 3 (1.37%) Perfmon
3 1 (0.46%) Data Guard
3 1 (0.46%) Marathon
3 1 (0.46%) Oracle RMAN
3 1 (0.46%) Oracle ZFS
3 1 (0.46%) Tivoli
Vendors
1 50 (22.83%) Microsoft
2 7 (3.20%) Oracle
3 6 (2.74%) VMware
4 4 (1.83%) SAP
5 2 (0.91%) Adobe
5 2 (0.91%) Ariba
5 2 (0.91%) Blackboard
5 2 (0.91%) Citrix
5 2 (0.91%) Salesforce.com
6 1 (0.46%) Cisco
6 1 (0.46%) Google
6 1 (0.46%) IBM
6 1 (0.46%) JDA
6 1 (0.46%) Pegasus
6 1 (0.46%) Perforce
6 1 (0.46%) RedPrairie