Period
to 26 April 2019

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 26 April 2019 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
Hampshire > Portsmouth
6 months to
26 Apr 2019
Same period 2018 Same period 2017
Rank 4 2 5
Rank change year-on-year -2 +3 -2
Permanent jobs citing SQL 209 226 204
As % of all permanent IT jobs advertised in Portsmouth 26.97% 35.70% 32.28%
As % of the Programming Languages category 42.74% 60.27% 48.80%
Number of salaries quoted 186 188 186
Portsmouth median annual salary £37,500 £45,000 £40,000
Median salary % change year-on-year -16.67% +12.50% -
10th Percentile £25,875 £24,000 £22,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 489 375 418
As % of all permanent IT jobs advertised in Portsmouth 63.10% 59.24% 66.14%
Number of salaries quoted 410 298 382
Portsmouth median annual salary £45,000 £45,000 £40,000
Median salary % change year-on-year - +12.50% -
10th Percentile £28,725 £24,000 £25,888
90th Percentile £62,500 £57,500 £55,000
Hampshire median annual salary £45,000 £42,500 £40,000
% change year-on-year +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 26 April 2019.

Salary histogram for SQL in Portsmouth

For the 6 months to 26 April 2019, 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 118 (56.46%) C#
2 110 (52.63%) .NET
3 95 (45.45%) JavaScript
4 77 (36.84%) MVC
5 76 (36.36%) Agile Software Development
6 61 (29.19%) ASP.NET
7 59 (28.23%) SQL Server
8 54 (25.84%) Microsoft
9 52 (24.88%) ASP.NET MVC
10 50 (23.92%) HTML
11 48 (22.97%) Oracle
11 48 (22.97%) AngularJS
12 46 (22.01%) Problem-Solving
13 45 (21.53%) Business Intelligence
14 44 (21.05%) Degree
15 41 (19.62%) CSS
16 39 (18.66%) Greenfield Project
17 31 (14.83%) Web Services
17 31 (14.83%) PL/SQL
17 31 (14.83%) T-SQL
18 29 (13.88%) Java
18 29 (13.88%) jQuery
18 29 (13.88%) RESTful
19 28 (13.40%) Self-Motivation
19 28 (13.40%) Finance
20 27 (12.92%) CRM
21 26 (12.44%) XML
22 25 (11.96%) Windows
23 24 (11.48%) ASP.NET Web API
24 23 (11.00%) Team Foundation Server

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 12 (5.74%) Confluence
2 4 (1.91%) SAS
3 3 (1.44%) IIS
3 3 (1.44%) SharePoint
4 2 (0.96%) Apache Spark
5 1 (0.48%) WebLogic
Applications
1 16 (7.66%) Microsoft Excel
2 2 (0.96%) Microsoft PowerPoint
3 1 (0.48%) Microsoft Project
Business Applications
1 16 (7.66%) Oracle Payroll
2 15 (7.18%) Oracle EBS
2 15 (7.18%) Oracle EBS R12
3 3 (1.44%) Unit4 Business World
4 2 (0.96%) Cognos TM1
4 2 (0.96%) Oracle HRMS
5 1 (0.48%) Oracle Utilities
5 1 (0.48%) SAP BPC
5 1 (0.48%) SAP ERP
Cloud Services
1 21 (10.05%) Amazon AWS
2 11 (5.26%) Google Cloud Platform
3 6 (2.87%) Amazon EC2
3 6 (2.87%) AWS CloudFormation
3 6 (2.87%) AWS Lambda
3 6 (2.87%) Microsoft Azure
3 6 (2.87%) Serverless
4 3 (1.44%) Office 365
5 1 (0.48%) Boomi
Communications & Networking
1 6 (2.87%) Firewall
2 5 (2.39%) Internet
3 4 (1.91%) TCP/IP
4 3 (1.44%) DNS
4 3 (1.44%) IMAP
4 3 (1.44%) SMTP
4 3 (1.44%) VoIP
4 3 (1.44%) VPN
5 1 (0.48%) Broadband
Database & Business Intelligence
1 59 (28.23%) SQL Server
2 19 (9.09%) MySQL
3 15 (7.18%) NoSQL
4 13 (6.22%) PostgreSQL
5 11 (5.26%) MongoDB
5 11 (5.26%) Oracle BI EE
6 8 (3.83%) Data Warehouse
6 8 (3.83%) Power BI
6 8 (3.83%) SQL Server Integration Services
7 7 (3.35%) SAP BW
8 6 (2.87%) QlikView
8 6 (2.87%) SAP HANA
9 5 (2.39%) Oracle Database
9 5 (2.39%) Relational Database
10 4 (1.91%) Data Mining
11 3 (1.44%) Big Data
11 3 (1.44%) SQL Server 2008
11 3 (1.44%) SQL Server 2016
11 3 (1.44%) WebFOCUS
12 2 (0.96%) Qlik Sense
Development Applications
1 23 (11.00%) Team Foundation Server
2 20 (9.57%) JIRA
3 17 (8.13%) InstallShield
4 15 (7.18%) WiX
5 10 (4.78%) Git (software)
6 8 (3.83%) Oracle APEX
6 8 (3.83%) Subversion
7 6 (2.87%) Bitbucket
7 6 (2.87%) Eclipse
7 6 (2.87%) IntelliJ
7 6 (2.87%) Visual Studio
8 2 (0.96%) Toad
9 1 (0.48%) Octopus Deploy
9 1 (0.48%) TeamCity
General
1 28 (13.40%) Finance
2 15 (7.18%) Marketing
3 12 (5.74%) Local Government
4 4 (1.91%) Retail
5 2 (0.96%) Advertising
5 2 (0.96%) Billing
6 1 (0.48%) Publishing
Job Titles
1 146 (69.86%) Developer
2 75 (35.89%) Software Developer
3 51 (24.40%) .NET Developer
4 47 (22.49%) C# Developer
5 44 (21.05%) SQL Developer
6 36 (17.22%) C# Software Developer
7 30 (14.35%) Analyst
8 29 (13.88%) C# .NET Developer
9 24 (11.48%) .NET Software Developer
10 22 (10.53%) Senior Developer
11 21 (10.05%) Full Stack Developer
12 19 (9.09%) Support Analyst
13 15 (7.18%) Oracle Analyst
14 13 (6.22%) Oracle Support Analyst
15 12 (5.74%) Oracle Developer
15 12 (5.74%) PL/SQL Developer
16 11 (5.26%) Junior
17 9 (4.31%) Database Developer
17 9 (4.31%) Junior Developer
17 9 (4.31%) Oracle Database Developer
Libraries, Frameworks & Software Standards
1 110 (52.63%) .NET
2 61 (29.19%) ASP.NET
3 52 (24.88%) ASP.NET MVC
4 50 (23.92%) HTML
5 48 (22.97%) AngularJS
6 41 (19.62%) CSS
7 31 (14.83%) Web Services
8 29 (13.88%) jQuery
8 29 (13.88%) RESTful
9 26 (12.44%) XML
10 24 (11.48%) ASP.NET Web API
11 23 (11.00%) WCF
12 21 (10.05%) .NET Framework
13 20 (9.57%) Entity Framework
14 12 (5.74%) .NET Core
14 12 (5.74%) Node.js
14 12 (5.74%) Spring
15 11 (5.26%) Angular 2
15 11 (5.26%) Ionic Framework
15 11 (5.26%) NgRx
Miscellaneous
1 39 (18.66%) Greenfield Project
2 28 (13.40%) Self-Motivation
3 19 (9.09%) Analytical Skills
4 7 (3.35%) Fintech
5 3 (1.44%) Management Information System
5 3 (1.44%) Renewable Energy
5 3 (1.44%) Smart Energy
5 3 (1.44%) W3C
6 2 (0.96%) Data Structures
6 2 (0.96%) Internet of Things
7 1 (0.48%) Data Centre
Operating Systems
1 25 (11.96%) Windows
2 4 (1.91%) Linux
2 4 (1.91%) Unix
3 3 (1.44%) AIX
3 3 (1.44%) Windows NT
3 3 (1.44%) Windows Server
3 3 (1.44%) Windows Server 2003
3 3 (1.44%) Windows Server 2008
Processes & Methodologies
1 77 (36.84%) MVC
2 76 (36.36%) Agile Software Development
3 46 (22.01%) Problem-Solving
4 45 (21.53%) Business Intelligence
5 27 (12.92%) CRM
6 19 (9.09%) Web Development
7 17 (8.13%) Continuous Integration
8 16 (7.66%) Machine Learning
9 15 (7.18%) Analytics
9 15 (7.18%) Artificial Intelligence
9 15 (7.18%) Customer Engagement
10 14 (6.70%) ERP
10 14 (6.70%) Mentoring
10 14 (6.70%) SDLC
10 14 (6.70%) Software Engineering
11 13 (6.22%) OO
12 12 (5.74%) Computer Science
12 12 (5.74%) PRINCE2
12 12 (5.74%) Project Management
13 11 (5.26%) Dimensional Modelling
Programming Languages
1 118 (56.46%) C#
2 95 (45.45%) JavaScript
3 31 (14.83%) PL/SQL
3 31 (14.83%) T-SQL
4 29 (13.88%) Java
5 21 (10.05%) C
6 15 (7.18%) Python
7 11 (5.26%) PHP
8 10 (4.78%) C++
8 10 (4.78%) VB
9 6 (2.87%) Java 8
9 6 (2.87%) TypeScript
9 6 (2.87%) VBA
10 4 (1.91%) R
11 3 (1.44%) Delphi
11 3 (1.44%) PowerShell
11 3 (1.44%) VBScript
12 2 (0.96%) ES6
12 2 (0.96%) MATLAB
12 2 (0.96%) VB.NET
Qualifications
1 44 (21.05%) Degree
2 11 (5.26%) PRINCE2 Certification
3 8 (3.83%) Computer Science Degree
4 7 (3.35%) MCSE
4 7 (3.35%) Microsoft Certification
4 7 (3.35%) SC Cleared
4 7 (3.35%) Security Cleared
5 4 (1.91%) MCP
6 3 (1.44%) ISEB
6 3 (1.44%) ISTQB
6 3 (1.44%) ITIL Foundation Certificate
6 3 (1.44%) MCSA
6 3 (1.44%) VMware Certified Professional (VCP)
7 2 (0.96%) Cisco Certification
Quality Assurance & Compliance
1 4 (1.91%) ISO/IEC 20000
2 2 (0.96%) QA
3 1 (0.48%) Data Quality
3 1 (0.48%) SLA
System Software
1 3 (1.44%) Hyper-V
1 3 (1.44%) VMware Infrastructure
1 3 (1.44%) XenServer
2 2 (0.96%) Docker
3 1 (0.48%) Oracle RAC
Systems Management
1 3 (1.44%) HP Quality Center
2 2 (0.96%) BMC PATROL
3 1 (0.48%) Single Sign-On
Vendors
1 54 (25.84%) Microsoft
2 48 (22.97%) Oracle
3 14 (6.70%) SAP
4 13 (6.22%) Atlassian
5 11 (5.26%) Google
6 9 (4.31%) Tableau
7 5 (2.39%) IBM
8 4 (1.91%) Citrix
9 3 (1.44%) Infragistics
9 3 (1.44%) VMware
10 2 (0.96%) Alteryx
10 2 (0.96%) Cisco
10 2 (0.96%) Cognos
11 1 (0.48%) Ariba
11 1 (0.48%) Dell
11 1 (0.48%) MuleSoft