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

SQL (Structured Query Language)
Hampshire > Portsmouth
6 months to
18 Dec 2018
Same period 2017 Same period 2016
Rank 7 4 3
Rank change year-on-year -3 -1 -1
Permanent jobs citing SQL 159 208 216
As % of all permanent IT jobs advertised in Portsmouth 23.52% 30.28% 33.33%
As % of the Programming Languages category 39.55% 52.53% 55.10%
Number of salaries quoted 142 222 218
Portsmouth median annual salary £45,000 £44,500 £40,000
Median salary % change year-on-year +1.12% +11.25% -5.88%
10th Percentile £28,750 £25,000 £25,000
90th Percentile £57,500 £57,500 £52,500
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 396 392
As % of all permanent IT jobs advertised in Portsmouth 59.47% 57.64% 60.49%
Number of salaries quoted 350 360 380
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,844 £24,000 £26,225
90th Percentile £60,000 £57,500 £53,750
Hampshire median annual salary £45,000 £42,000 £40,000
% change year-on-year +7.14% +5.00% -5.88%

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 December 2018.

Salary histogram for SQL in Portsmouth

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

1 99 (62.26%) C#
2 94 (59.12%) .NET
3 76 (47.80%) JavaScript
4 72 (45.28%) MVC
5 71 (44.65%) SQL Server
6 69 (43.40%) ASP.NET
7 67 (42.14%) ASP.NET MVC
8 63 (39.62%) Microsoft
9 60 (37.74%) Agile Software Development
10 59 (37.11%) CSS
10 59 (37.11%) HTML
11 47 (29.56%) T-SQL
12 46 (28.93%) AngularJS
13 39 (24.53%) Finance
14 38 (23.90%) XML
15 35 (22.01%) Team Foundation Server
15 35 (22.01%) Greenfield Project
16 33 (20.75%) Web Services
17 29 (18.24%) Oracle
18 28 (17.61%) ASP.NET Web API
19 27 (16.98%) Business Intelligence
20 26 (16.35%) InstallShield
20 26 (16.35%) jQuery
21 24 (15.09%) Problem-Solving
22 22 (13.84%) Java
23 21 (13.21%) CRM
23 21 (13.21%) Customer Engagement
23 21 (13.21%) TDD
23 21 (13.21%) WiX
24 19 (11.95%) .NET Framework

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 6 (3.77%) IIS
1 6 (3.77%) SharePoint
2 4 (2.52%) BizTalk Server
2 4 (2.52%) MQSeries
3 1 (0.63%) Apache Solr
3 1 (0.63%) Apache Spark
3 1 (0.63%) Elasticsearch
Applications
1 4 (2.52%) Microsoft Excel
Business Applications
1 8 (5.03%) SAP ERP
2 5 (3.14%) Oracle EBS
2 5 (3.14%) Oracle EBS R12
2 5 (3.14%) Oracle Payroll
3 2 (1.26%) Oracle HRMS
4 1 (0.63%) Dynamics AX
Cloud Services
1 9 (5.66%) Microsoft Azure
2 8 (5.03%) Boomi
3 7 (4.40%) Amazon AWS
4 3 (1.89%) Office 365
4 3 (1.89%) SuccessFactors
5 1 (0.63%) Amazon EC2
5 1 (0.63%) AWS CloudFormation
5 1 (0.63%) AWS Lambda
5 1 (0.63%) Dynamics 365
5 1 (0.63%) GitHub
5 1 (0.63%) npm
5 1 (0.63%) Serverless
Communications & Networking
1 8 (5.03%) DNS
2 7 (4.40%) SMTP
3 5 (3.14%) IMAP
3 5 (3.14%) Internet
3 5 (3.14%) TCP/IP
4 4 (2.52%) Firewall
5 3 (1.89%) VoIP
5 3 (1.89%) VPN
6 2 (1.26%) HTTP
Database & Business Intelligence
1 71 (44.65%) SQL Server
2 8 (5.03%) MySQL
2 8 (5.03%) PostgreSQL
3 7 (4.40%) Power BI
3 7 (4.40%) SQL Server 2008
4 6 (3.77%) Big Data
4 6 (3.77%) QlikView
5 5 (3.14%) NoSQL
5 5 (3.14%) SQL Server Reporting Services
6 4 (2.52%) SAP Data Services
6 4 (2.52%) SQL Server Integration Services
7 3 (1.89%) Azure SQL Database
7 3 (1.89%) Relational Database
7 3 (1.89%) SQL Server Analysis Services
8 2 (1.26%) Data Warehouse
8 2 (1.26%) Hadoop
8 2 (1.26%) Oracle BI EE
8 2 (1.26%) Qlik Sense
9 1 (0.63%) SAP BW
9 1 (0.63%) SQL Server 2016
Development Applications
1 35 (22.01%) Team Foundation Server
2 26 (16.35%) InstallShield
3 21 (13.21%) WiX
4 16 (10.06%) Git (software)
5 9 (5.66%) JIRA
6 5 (3.14%) Octopus Deploy
6 5 (3.14%) TeamCity
7 4 (2.52%) NUnit
7 4 (2.52%) Visual Studio
8 3 (1.89%) HP UFT
9 1 (0.63%) Oracle APEX
9 1 (0.63%) Selenium
9 1 (0.63%) SQL Server Management Studio (SSMS)
General
1 39 (24.53%) Finance
2 14 (8.81%) Retail
3 6 (3.77%) Back Office
4 5 (3.14%) Marketing
5 3 (1.89%) Local Government
6 1 (0.63%) Banking
6 1 (0.63%) Publishing
Job Titles
1 104 (65.41%) Developer
2 60 (37.74%) .NET Developer
3 49 (30.82%) Software Developer
4 40 (25.16%) C# Developer
5 39 (24.53%) C# .NET Developer
6 31 (19.50%) Senior Developer
7 27 (16.98%) SQL Developer
8 26 (16.35%) .NET Software Developer
8 26 (16.35%) C# Software Developer
9 24 (15.09%) ASP.NET Developer
9 24 (15.09%) C# ASP.NET Developer
10 20 (12.58%) Senior .NET Developer
11 18 (11.32%) Analyst
12 14 (8.81%) ASP.NET MVC Developer
13 13 (8.18%) Senior Software Developer
14 9 (5.66%) Senior ASP.NET Developer
14 9 (5.66%) Senior ASP.NET MVC Developer
14 9 (5.66%) Senior C# .NET Developer
14 9 (5.66%) Senior C# ASP.NET Developer
14 9 (5.66%) Senior C# Developer
Libraries, Frameworks & Software Standards
1 94 (59.12%) .NET
2 69 (43.40%) ASP.NET
3 67 (42.14%) ASP.NET MVC
4 59 (37.11%) CSS
4 59 (37.11%) HTML
5 46 (28.93%) AngularJS
6 38 (23.90%) XML
7 33 (20.75%) Web Services
8 28 (17.61%) ASP.NET Web API
9 26 (16.35%) jQuery
10 19 (11.95%) .NET Framework
11 18 (11.32%) Entity Framework
12 15 (9.43%) WCF
13 14 (8.81%) ASP.NET Web Forms
14 12 (7.55%) CSS3
14 12 (7.55%) HTML5
14 12 (7.55%) J2EE
14 12 (7.55%) React
14 12 (7.55%) RESTful
15 8 (5.03%) SAP PI
Miscellaneous
1 35 (22.01%) Greenfield Project
2 13 (8.18%) Analytical Skills
3 11 (6.92%) Fintech
4 8 (5.03%) Enterprise Software
5 6 (3.77%) Self-Motivation
6 5 (3.14%) Management Information System
7 3 (1.89%) W3C
8 2 (1.26%) Driving Licence
9 1 (0.63%) Replication
Operating Systems
1 16 (10.06%) Windows
2 7 (4.40%) Windows Server 2008
3 6 (3.77%) Unix
4 5 (3.14%) Linux
5 4 (2.52%) Windows NT
5 4 (2.52%) Windows Server
5 4 (2.52%) Windows Server 2003
6 3 (1.89%) AIX
7 2 (1.26%) Windows 10
7 2 (1.26%) Windows 7
8 1 (0.63%) Windows Server 2012
Processes & Methodologies
1 72 (45.28%) MVC
2 60 (37.74%) Agile Software Development
3 27 (16.98%) Business Intelligence
4 24 (15.09%) Problem-Solving
5 21 (13.21%) CRM
5 21 (13.21%) Customer Engagement
5 21 (13.21%) TDD
6 17 (10.69%) Analytics
6 17 (10.69%) E-Commerce
7 16 (10.06%) Unit Testing
8 14 (8.81%) Web Development
9 13 (8.18%) Test Automation
10 12 (7.55%) Test Scripting
11 11 (6.92%) ERP
12 10 (6.29%) Continuous Integration
12 10 (6.29%) ITIL
12 10 (6.29%) Software Engineering
13 9 (5.66%) Software Testing
13 9 (5.66%) Visualisation
13 9 (5.66%) Web Analytics
Programming Languages
1 99 (62.26%) C#
2 76 (47.80%) JavaScript
3 47 (29.56%) T-SQL
4 22 (13.84%) Java
5 14 (8.81%) C
6 12 (7.55%) C++
7 10 (6.29%) Python
8 8 (5.03%) ABAP
8 8 (5.03%) PL/SQL
9 6 (3.77%) VB.NET
10 5 (3.14%) PowerShell
10 5 (3.14%) VBScript
11 4 (2.52%) VB
12 2 (1.26%) ES6
13 1 (0.63%) Ada
13 1 (0.63%) Perl
13 1 (0.63%) R
13 1 (0.63%) Scala
13 1 (0.63%) TypeScript
13 1 (0.63%) VBA
Qualifications
1 18 (11.32%) Degree
2 17 (10.69%) SC Cleared
2 17 (10.69%) Security Cleared
3 7 (4.40%) ISEB
3 7 (4.40%) ISTQB
4 6 (3.77%) MCSE
4 6 (3.77%) Microsoft Certification
5 4 (2.52%) ITIL Foundation Certificate
6 3 (1.89%) MCP
6 3 (1.89%) MCSA
6 3 (1.89%) VMware Certified Professional (VCP)
7 2 (1.26%) PRINCE2 Certification
8 1 (0.63%) Cisco Certification
8 1 (0.63%) Computer Science Degree
Quality Assurance & Compliance
1 4 (2.52%) SLA
2 3 (1.89%) ISO/IEC 20000
2 3 (1.89%) QA
3 1 (0.63%) PMO
System Software
1 8 (5.03%) Oracle RAC
2 3 (1.89%) Active Directory
2 3 (1.89%) Hyper-V
2 3 (1.89%) VMware Infrastructure
2 3 (1.89%) XenServer
3 2 (1.26%) Docker
Systems Management
1 4 (2.52%) HP Quality Center
2 3 (1.89%) HP ALM
3 2 (1.26%) SCCM
3 2 (1.26%) SCOM
4 1 (0.63%) Grafana
4 1 (0.63%) Kibana
4 1 (0.63%) Perfmon
4 1 (0.63%) Terraform
Vendors
1 63 (39.62%) Microsoft
2 29 (18.24%) Oracle
3 12 (7.55%) SAP
4 7 (4.40%) Atlassian
5 6 (3.77%) Tableau
6 5 (3.14%) VMware
7 4 (2.52%) Citrix
8 3 (1.89%) HP
8 3 (1.89%) IBM
9 2 (1.26%) Google
10 1 (0.63%) Cisco
10 1 (0.63%) IFS
10 1 (0.63%) Pegasus