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

SQL (Structured Query Language)
Hampshire > Portsmouth
6 months to
17 Feb 2018
Same period 2017 Same period 2016
Rank 2 3 3
Rank change year-on-year +1 0 0
Permanent jobs citing SQL 209 204 230
As % of all permanent IT jobs advertised in Portsmouth 32.30% 33.22% 30.83%
As % of the Programming Languages category 55.59% 54.26% 43.98%
Number of salaries quoted 210 198 234
Portsmouth median annual salary £42,500 £40,000 £42,500
Median salary % change year-on-year +6.25% -5.88% +6.25%
10th Percentile £24,000 £25,000 £23,500
90th Percentile £57,500 £52,500 £65,875
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 376 376 523
As % of all permanent IT jobs advertised in Portsmouth 58.11% 61.24% 70.11%
Number of salaries quoted 328 353 479
Portsmouth median annual salary £42,500 £40,000 £42,500
Median salary % change year-on-year +6.25% -5.88% +6.25%
10th Percentile £24,000 £26,000 £27,500
90th Percentile £57,500 £52,500 £58,750
Hampshire median annual salary £41,500 £40,000 £41,674
% change year-on-year +3.75% -4.02% +4.19%

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 17 February 2018.

Salary histogram for SQL in Portsmouth

For the 6 months to 17 February 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 147 (70.33%) C#
2 146 (69.86%) .NET
3 116 (55.50%) MVC
4 109 (52.15%) JavaScript
5 107 (51.20%) SQL Server
6 106 (50.72%) ASP.NET
7 86 (41.15%) ASP.NET MVC
8 83 (39.71%) HTML
9 76 (36.36%) CSS
9 76 (36.36%) Agile Software Development
10 71 (33.97%) AngularJS
11 69 (33.01%) jQuery
12 63 (30.14%) T-SQL
13 57 (27.27%) Analytics
14 51 (24.40%) Data Analytics
15 45 (21.53%) Kendo UI
16 44 (21.05%) Twitter Bootstrap
17 43 (20.57%) Microsoft Azure
17 43 (20.57%) SQL Server 2016
18 36 (17.22%) Web Services
19 35 (16.75%) Microsoft
20 34 (16.27%) ASP.NET Web API
21 33 (15.79%) Docker
21 33 (15.79%) E-Commerce
22 32 (15.31%) Jenkins
23 31 (14.83%) Git (software)
24 29 (13.88%) .NET Core
24 29 (13.88%) Docker Swarm
24 29 (13.88%) GitHub
25 28 (13.40%) CRM

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 10 (4.78%) NServiceBus
2 6 (2.87%) Tomcat
3 5 (2.39%) Confluence
4 3 (1.44%) Apache Spark
4 3 (1.44%) Elasticsearch
5 2 (0.96%) Apache
5 2 (0.96%) CMS
5 2 (0.96%) Moodle
5 2 (0.96%) SharePoint
6 1 (0.48%) IIS
6 1 (0.48%) WebLogic
Applications
1 6 (2.87%) SPSS
2 5 (2.39%) Microsoft Excel
3 2 (0.96%) MS Visio
3 2 (0.96%) Photoshop
Business Applications
1 3 (1.44%) SAP ERP
2 1 (0.48%) Dynamics AX
2 1 (0.48%) Oracle Applications
2 1 (0.48%) Oracle EBS
2 1 (0.48%) Oracle EBS R12
Cloud Services
1 43 (20.57%) Microsoft Azure
2 29 (13.88%) GitHub
3 9 (4.31%) Amazon AWS
4 8 (3.83%) SaaS
5 3 (1.44%) PaaS
6 1 (0.48%) Dynamics 365
6 1 (0.48%) Google Cloud Platform
6 1 (0.48%) SuccessFactors
Communications & Networking
1 8 (3.83%) Internet
2 6 (2.87%) TCP/IP
3 5 (2.39%) DNS
3 5 (2.39%) HTTP
3 5 (2.39%) SMTP
4 4 (1.91%) SNMP
5 3 (1.44%) SSL
6 1 (0.48%) tcpdump
6 1 (0.48%) Wireshark
Database & Business Intelligence
1 107 (51.20%) SQL Server
2 43 (20.57%) SQL Server 2016
3 26 (12.44%) SQL Server Integration Services
3 26 (12.44%) SQL Server Reporting Services
4 15 (7.18%) SQL Server Analysis Services
5 14 (6.70%) Big Data
5 14 (6.70%) MongoDB
6 13 (6.22%) SQL Server 2012
7 11 (5.26%) InfluxDB
8 10 (4.78%) SQL Server 2008
9 8 (3.83%) Data Warehouse
9 8 (3.83%) Power BI
10 7 (3.35%) Crystal Reports
11 6 (2.87%) SQL Server 2005
12 5 (2.39%) Relational Database
12 5 (2.39%) SAP BW
13 4 (1.91%) MySQL
13 4 (1.91%) OLAP
14 3 (1.44%) Hadoop
15 2 (0.96%) Microsoft Power View
Development Applications
1 32 (15.31%) Jenkins
2 31 (14.83%) Git (software)
3 13 (6.22%) NUnit
4 12 (5.74%) Moq
5 7 (3.35%) Selenium
6 6 (2.87%) JIRA
7 5 (2.39%) Octopus Deploy
7 5 (2.39%) SQL Server Management Studio (SSMS)
7 5 (2.39%) TeamCity
7 5 (2.39%) Visual Studio
8 4 (1.91%) Subversion
9 3 (1.44%) Atlassian Bamboo
9 3 (1.44%) Travis CI
9 3 (1.44%) Vagrant
10 2 (0.96%) Team Foundation Server
11 1 (0.48%) Cucumber
11 1 (0.48%) Oracle Forms
General
1 25 (11.96%) Retail
2 9 (4.31%) Marketing
3 8 (3.83%) Advertising
3 8 (3.83%) Back Office
4 4 (1.91%) Finance
Job Titles
1 160 (76.56%) Developer
2 99 (47.37%) C# Developer
3 90 (43.06%) .NET Developer
4 76 (36.36%) C# .NET Developer
5 63 (30.14%) ASP.NET Developer
5 63 (30.14%) C# ASP.NET Developer
6 59 (28.23%) ASP.NET MVC Developer
7 55 (26.32%) Software Developer
8 42 (20.10%) C# Software Developer
9 41 (19.62%) Senior Developer
10 40 (19.14%) SQL Developer
11 36 (17.22%) .NET Software Developer
11 36 (17.22%) Senior .NET Developer
12 35 (16.75%) Senior ASP.NET Developer
12 35 (16.75%) Senior C# .NET Developer
12 35 (16.75%) Senior C# ASP.NET Developer
12 35 (16.75%) Senior C# Developer
13 34 (16.27%) Senior ASP.NET MVC Developer
14 31 (14.83%) Senior Software Developer
15 30 (14.35%) Senior .NET Software Developer
Libraries, Frameworks & Software Standards
1 146 (69.86%) .NET
2 106 (50.72%) ASP.NET
3 86 (41.15%) ASP.NET MVC
4 83 (39.71%) HTML
5 76 (36.36%) CSS
6 71 (33.97%) AngularJS
7 69 (33.01%) jQuery
8 45 (21.53%) Kendo UI
9 44 (21.05%) Twitter Bootstrap
10 36 (17.22%) Web Services
11 34 (16.27%) ASP.NET Web API
12 29 (13.88%) .NET Core
13 18 (8.61%) HTML5
13 18 (8.61%) KnockoutJS
14 16 (7.66%) ASP.NET Web Forms
15 9 (4.31%) WCF
16 8 (3.83%) .NET Framework
17 7 (3.35%) ASP.NET MVC 4
17 7 (3.35%) Entity Framework
17 7 (3.35%) REST
Miscellaneous
1 16 (7.66%) Analytical Skills
2 12 (5.74%) Greenfield Project
3 6 (2.87%) Management Information System
3 6 (2.87%) Replication
4 5 (2.39%) Algorithms
5 4 (1.91%) Computer Science
5 4 (1.91%) User Experience
6 2 (0.96%) EPoS
6 2 (0.96%) Learning Management System
7 1 (0.48%) Enterprise Software
Operating Systems
1 21 (10.05%) Linux
2 11 (5.26%) Windows
3 9 (4.31%) Unix
4 4 (1.91%) Windows 10
4 4 (1.91%) Windows 7
4 4 (1.91%) Windows Server 2008
5 1 (0.48%) Solaris
5 1 (0.48%) Windows Server
Processes & Methodologies
1 116 (55.50%) MVC
2 76 (36.36%) Agile Software Development
3 57 (27.27%) Analytics
4 51 (24.40%) Data Analytics
5 33 (15.79%) E-Commerce
6 28 (13.40%) CRM
7 25 (11.96%) Web Development
8 24 (11.48%) Unit Testing
9 23 (11.00%) Scrum
10 18 (8.61%) Business Intelligence
11 16 (7.66%) Software Engineering
12 14 (6.70%) Data Modelling
13 13 (6.22%) ETL
13 13 (6.22%) SOLID
14 12 (5.74%) Front End Development
14 12 (5.74%) Performance Tuning
15 11 (5.26%) Continuous Integration
15 11 (5.26%) Creative Thinking
15 11 (5.26%) Statistics
16 10 (4.78%) Mathematics
Programming Languages
1 147 (70.33%) C#
2 109 (52.15%) JavaScript
3 63 (30.14%) T-SQL
4 15 (7.18%) Python
4 15 (7.18%) VB.NET
5 6 (2.87%) Java
5 6 (2.87%) R
6 5 (2.39%) PL/SQL
6 5 (2.39%) PowerShell
6 5 (2.39%) Ruby
7 4 (1.91%) Bash Shell
7 4 (1.91%) VBScript
8 3 (1.44%) C
9 2 (0.96%) C++
9 2 (0.96%) PHP
10 1 (0.48%) Perl
10 1 (0.48%) VBA
Qualifications
1 17 (8.13%) Security Cleared
2 13 (6.22%) SC Cleared
3 10 (4.78%) Degree
4 6 (2.87%) Numerate Degree
5 3 (1.44%) Microsoft Certification
6 2 (0.96%) MCSA
6 2 (0.96%) MCSE
7 1 (0.48%) DV Cleared
7 1 (0.48%) ISEB
7 1 (0.48%) ISTQB
7 1 (0.48%) MCITP
7 1 (0.48%) MCTS
Quality Assurance & Compliance
1 6 (2.87%) QA
2 2 (0.96%) Data Quality
3 1 (0.48%) ISO/IEC 20000
3 1 (0.48%) ISO/IEC 27001
3 1 (0.48%) PMO
System Software
1 33 (15.79%) Docker
2 5 (2.39%) Active Directory
3 1 (0.48%) VMware Workstation
Systems Management
1 29 (13.88%) Docker Swarm
2 5 (2.39%) Perfmon
3 4 (1.91%) SCCM
3 4 (1.91%) SCOM
4 1 (0.48%) Data Guard
4 1 (0.48%) Oracle Enterprise Manager
4 1 (0.48%) Oracle RMAN
4 1 (0.48%) Oracle ZFS
Vendors
1 35 (16.75%) Microsoft
2 6 (2.87%) Oracle
2 6 (2.87%) SAP
3 5 (2.39%) VMware
4 4 (1.91%) Ariba
5 2 (0.96%) Adobe
5 2 (0.96%) Blackboard
5 2 (0.96%) Salesforce.com
6 1 (0.48%) Cisco
6 1 (0.48%) Google
6 1 (0.48%) Pegasus
6 1 (0.48%) Perforce
6 1 (0.48%) Tableau