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

SQL (Structured Query Language)
Hampshire > Portsmouth
6 months to
18 Oct 2018
Same period 2017 Same period 2016
Rank 6 7 3
Rank change year-on-year +1 -4 -1
Permanent jobs citing SQL 160 208 186
As % of all permanent IT jobs advertised in Portsmouth 27.16% 30.36% 30.74%
As % of the Programming Languages category 42.55% 50.98% 53.45%
Number of salaries quoted 148 219 187
Portsmouth median annual salary £43,750 £42,500 £40,000
Median salary % change year-on-year +2.94% +6.25% -5.88%
10th Percentile £24,600 £25,000 £25,000
90th Percentile £62,500 £56,250 £52,500
Hampshire median annual salary £42,500 £40,000 £38,500
% change year-on-year +6.25% +3.90% -3.75%

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 376 408 348
As % of all permanent IT jobs advertised in Portsmouth 63.84% 59.56% 57.52%
Number of salaries quoted 336 380 339
Portsmouth median annual salary £45,000 £42,500 £40,000
Median salary % change year-on-year +5.88% +6.25% -5.88%
10th Percentile £28,500 £23,975 £26,250
90th Percentile £60,000 £57,500 £58,150
Hampshire median annual salary £45,000 £42,500 £40,000
% change year-on-year +5.88% +6.25% -3.61%

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 18 October 2018.

Salary histogram for SQL in Portsmouth

For the 6 months to 18 October 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 92 (57.50%) C#
1 92 (57.50%) .NET
2 89 (55.63%) SQL Server
3 78 (48.75%) JavaScript
4 65 (40.63%) Microsoft
5 62 (38.75%) MVC
6 61 (38.13%) ASP.NET
7 58 (36.25%) HTML
8 56 (35.00%) T-SQL
8 56 (35.00%) ASP.NET MVC
9 55 (34.38%) CSS
10 52 (32.50%) Agile Software Development
11 38 (23.75%) Business Intelligence
12 37 (23.13%) Finance
12 37 (23.13%) AngularJS
13 36 (22.50%) XML
14 33 (20.63%) Web Services
15 32 (20.00%) Team Foundation Server
16 31 (19.38%) Oracle
16 31 (19.38%) Analytics
17 25 (15.63%) Java
17 25 (15.63%) CRM
18 24 (15.00%) Greenfield Project
19 23 (14.38%) Problem-Solving
19 23 (14.38%) E-Commerce
19 23 (14.38%) jQuery
19 23 (14.38%) Git (software)
20 22 (13.75%) .NET Framework
20 22 (13.75%) CSS3
20 22 (13.75%) HTML5

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 8 (5.00%) BizTalk Server
1 8 (5.00%) MQSeries
2 6 (3.75%) IIS
3 5 (3.13%) SharePoint
4 3 (1.88%) Apache
4 3 (1.88%) nginx
5 1 (0.63%) Apache Solr
5 1 (0.63%) Apache Spark
5 1 (0.63%) CMS
5 1 (0.63%) Elasticsearch
5 1 (0.63%) SAS
Applications
1 3 (1.88%) Microsoft Excel
2 1 (0.63%) Microsoft Office
2 1 (0.63%) MS Visio
Business Applications
1 16 (10.00%) SAP ERP
2 1 (0.63%) Dynamics AX
2 1 (0.63%) Dynamics CRM
2 1 (0.63%) Oracle EBS
2 1 (0.63%) Oracle EBS R12
2 1 (0.63%) Oracle ERP
Cloud Services
1 14 (8.75%) Boomi
2 13 (8.13%) Amazon AWS
3 8 (5.00%) Microsoft Azure
4 7 (4.38%) Google Analytics
5 5 (3.13%) SuccessFactors
6 2 (1.25%) Dynamics 365
7 1 (0.63%) Amazon EC2
7 1 (0.63%) AWS CloudFormation
7 1 (0.63%) AWS Lambda
7 1 (0.63%) GitHub
7 1 (0.63%) npm
7 1 (0.63%) Serverless
Communications & Networking
1 8 (5.00%) DNS
2 7 (4.38%) SMTP
3 5 (3.13%) IMAP
3 5 (3.13%) Internet
4 4 (2.50%) TCP/IP
5 3 (1.88%) HTTP
Database & Business Intelligence
1 89 (55.63%) SQL Server
2 11 (6.88%) NoSQL
2 11 (6.88%) Relational Database
2 11 (6.88%) SQL Server Analysis Services
3 10 (6.25%) SQL Server 2016
4 9 (5.63%) Big Data
4 9 (5.63%) Power BI
4 9 (5.63%) SQL Server Reporting Services
5 8 (5.00%) SAP Data Services
5 8 (5.00%) SQL Server 2008
5 8 (5.00%) SQL Server Integration Services
6 7 (4.38%) MySQL
6 7 (4.38%) RDBMS
7 6 (3.75%) Data Warehouse
8 5 (3.13%) PostgreSQL
8 5 (3.13%) QlikView
9 3 (1.88%) Apache Hive
9 3 (1.88%) Hadoop
10 2 (1.25%) Azure SQL Database
10 2 (1.25%) MongoDB
Development Applications
1 32 (20.00%) Team Foundation Server
2 23 (14.38%) Git (software)
3 19 (11.88%) InstallShield
4 15 (9.38%) WiX
5 10 (6.25%) JIRA
6 5 (3.13%) HP UFT
6 5 (3.13%) NUnit
7 4 (2.50%) Octopus Deploy
7 4 (2.50%) TeamCity
7 4 (2.50%) Visual Studio
8 3 (1.88%) Cucumber
8 3 (1.88%) RSpec
8 3 (1.88%) Subversion
9 2 (1.25%) Selenium
9 2 (1.25%) SQL Server Management Studio (SSMS)
10 1 (0.63%) Mercurial
10 1 (0.63%) Moq
General
1 37 (23.13%) Finance
2 13 (8.13%) Retail
3 6 (3.75%) Back Office
3 6 (3.75%) Marketing
4 2 (1.25%) Advertising
5 1 (0.63%) Banking
5 1 (0.63%) Manufacturing
5 1 (0.63%) Telecoms
Job Titles
1 102 (63.75%) Developer
2 58 (36.25%) .NET Developer
3 44 (27.50%) Software Developer
4 42 (26.25%) C# Developer
5 41 (25.63%) C# .NET Developer
6 31 (19.38%) Senior Developer
7 28 (17.50%) .NET Software Developer
7 28 (17.50%) C# Software Developer
8 25 (15.63%) ASP.NET Developer
8 25 (15.63%) C# ASP.NET Developer
8 25 (15.63%) SQL Developer
9 21 (13.13%) Senior .NET Developer
10 18 (11.25%) Senior Software Developer
11 14 (8.75%) Analyst
11 14 (8.75%) ASP.NET MVC Developer
12 12 (7.50%) Senior C# .NET Developer
12 12 (7.50%) Senior C# Developer
13 10 (6.25%) Senior .NET Software Developer
13 10 (6.25%) Senior C# Software Developer
14 9 (5.63%) Senior C# ASP.NET Developer
Libraries, Frameworks & Software Standards
1 92 (57.50%) .NET
2 61 (38.13%) ASP.NET
3 58 (36.25%) HTML
4 56 (35.00%) ASP.NET MVC
5 55 (34.38%) CSS
6 37 (23.13%) AngularJS
7 36 (22.50%) XML
8 33 (20.63%) Web Services
9 23 (14.38%) jQuery
10 22 (13.75%) .NET Framework
10 22 (13.75%) ASP.NET Web API
10 22 (13.75%) CSS3
10 22 (13.75%) HTML5
11 15 (9.38%) J2EE
11 15 (9.38%) React
12 14 (8.75%) IDoc
12 14 (8.75%) SAP ALE
12 14 (8.75%) SAP PI
13 13 (8.13%) Entity Framework
14 11 (6.88%) SAP Fiori
Miscellaneous
1 24 (15.00%) Greenfield Project
2 11 (6.88%) Analytical Skills
3 10 (6.25%) Enterprise Software
4 8 (5.00%) Computer Science
5 5 (3.13%) Management Information System
6 4 (2.50%) Fintech
7 3 (1.88%) W3C
8 2 (1.25%) Driving Licence
8 2 (1.25%) Self-Motivation
9 1 (0.63%) Data Centre
9 1 (0.63%) Replication
Operating Systems
1 19 (11.88%) Windows
2 11 (6.88%) Linux
3 7 (4.38%) Unix
4 6 (3.75%) Windows Server
5 4 (2.50%) Windows Server 2008
6 3 (1.88%) Ubuntu
7 2 (1.25%) Windows 10
7 2 (1.25%) Windows 7
8 1 (0.63%) Solaris
8 1 (0.63%) Windows NT
8 1 (0.63%) Windows Server 2003
8 1 (0.63%) Windows Server 2012
Processes & Methodologies
1 62 (38.75%) MVC
2 52 (32.50%) Agile Software Development
3 38 (23.75%) Business Intelligence
4 31 (19.38%) Analytics
5 25 (15.63%) CRM
6 23 (14.38%) E-Commerce
6 23 (14.38%) Problem-Solving
7 20 (12.50%) TDD
8 19 (11.88%) ERP
9 18 (11.25%) Web Development
10 16 (10.00%) Test Automation
10 16 (10.00%) Test Scripting
11 15 (9.38%) Customer Engagement
12 14 (8.75%) SAP Implementation
12 14 (8.75%) Software Engineering
12 14 (8.75%) Unit Testing
12 14 (8.75%) Web Analytics
13 13 (8.13%) Mentoring
14 11 (6.88%) Software Testing
14 11 (6.88%) Waterfall
Programming Languages
1 92 (57.50%) C#
2 78 (48.75%) JavaScript
3 56 (35.00%) T-SQL
4 25 (15.63%) Java
5 14 (8.75%) ABAP
6 12 (7.50%) VB.NET
7 9 (5.63%) C
8 7 (4.38%) TypeScript
9 6 (3.75%) PL/SQL
10 5 (3.13%) C++
11 3 (1.88%) Ruby
11 3 (1.88%) VB
11 3 (1.88%) VB6
11 3 (1.88%) VBScript
12 2 (1.25%) PowerShell
12 2 (1.25%) Python
12 2 (1.25%) Scala
13 1 (0.63%) Ada
13 1 (0.63%) ES6
13 1 (0.63%) Shell Script
Qualifications
1 21 (13.13%) SC Cleared
1 21 (13.13%) Security Cleared
2 16 (10.00%) Degree
3 8 (5.00%) ISEB
3 8 (5.00%) ISTQB
4 2 (1.25%) Computer Science Degree
5 1 (0.63%) ITIL Foundation Certificate
5 1 (0.63%) MCP
5 1 (0.63%) MCSE
5 1 (0.63%) Microsoft Certification
5 1 (0.63%) PhD
Quality Assurance & Compliance
1 7 (4.38%) QA
2 6 (3.75%) SLA
3 2 (1.25%) Data Quality
3 2 (1.25%) ISO/IEC 20000
4 1 (0.63%) PMO
System Software
1 14 (8.75%) Oracle RAC
2 4 (2.50%) Active Directory
3 3 (1.88%) Postfix
4 1 (0.63%) Docker
Systems Management
1 5 (3.13%) HP ALM
2 3 (1.88%) Ansible
3 2 (1.25%) SCCM
3 2 (1.25%) SCOM
4 1 (0.63%) Grafana
4 1 (0.63%) HP Quality Center
4 1 (0.63%) Kibana
4 1 (0.63%) Perfmon
4 1 (0.63%) Terraform
Vendors
1 65 (40.63%) Microsoft
2 31 (19.38%) Oracle
3 21 (13.13%) SAP
4 7 (4.38%) Google
5 5 (3.13%) HP
5 5 (3.13%) Tableau
6 2 (1.25%) VMware
7 1 (0.63%) Atlassian
7 1 (0.63%) Citrix
7 1 (0.63%) Cognos
7 1 (0.63%) IFS
7 1 (0.63%) Pegasus
7 1 (0.63%) Salesforce.com