Period
to 22 November 2017

The following table provides summary statistics for permanent job vacancies advertised in Preston 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 22 November 2017 with a comparison to the same period in the previous 2 years.

SQL (Structured Query Language)
Lancashire > Preston
6 months to
22 Nov 2017
Same period 2016 Same period 2015
Rank 6 2 5
Rank change year-on-year -4 +3 -1
Permanent jobs citing SQL 67 65 49
As % of all permanent IT jobs advertised in Preston 26.91% 28.63% 25.52%
As % of the Programming Languages category 40.12% 49.62% 40.83%
Number of salaries quoted 60 58 44
Preston median annual salary £39,000 £35,000 £31,500
Median salary % change year-on-year +11.43% +11.11% -3.08%
10th Percentile £27,500 £22,750 £24,475
90th Percentile £47,750 £42,500 £42,500
Lancashire median annual salary £35,000 £37,500 £35,000
% change year-on-year -6.67% +7.14% -2.78%

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 Preston with a requirement for coding skills.

All Programming Languages
Preston
Permanent vacancies with a requirement for coding skills 167 131 120
As % of all permanent IT jobs advertised in Preston 67.07% 57.71% 62.50%
Number of salaries quoted 135 122 106
Preston median annual salary £35,000 £32,500 £37,500
Median salary % change year-on-year +7.69% -13.33% +15.38%
10th Percentile £27,875 £22,750 £25,000
90th Percentile £50,750 £43,750 £45,000
Lancashire median annual salary £35,000 £36,500 £35,000
% change year-on-year -4.11% +4.29% -

SQL
Job Vacancy Trend in Preston

Job postings citing SQL as a percentage of all IT jobs advertised in Preston.

Job vacancy trend for SQL in Preston

SQL
Salary Trend in Preston

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing SQL in Preston.

Salary trend for SQL in Preston

SQL
Salary Histogram in Preston

The salary distribution of IT jobs citing SQL in Preston over the 6 months to 22 November 2017.

Salary histogram for SQL in Preston

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

1 40 (59.70%) SQL Server
2 36 (53.73%) .NET
2 36 (53.73%) C#
3 33 (49.25%) ASP.NET
4 24 (35.82%) MVC
5 21 (31.34%) Web Development
6 20 (29.85%) Unit Testing
7 19 (28.36%) SQL Server Reporting Services
8 17 (25.37%) SQL Server Integration Services
8 17 (25.37%) .NET Framework
8 17 (25.37%) Windows
8 17 (25.37%) ASP.NET MVC
9 16 (23.88%) LINQ
9 16 (23.88%) Entity Framework
9 16 (23.88%) ASP.NET Web Forms
9 16 (23.88%) TDD
9 16 (23.88%) Workflow
10 14 (20.90%) CSS
11 13 (19.40%) HTML
12 12 (17.91%) Business Intelligence
13 11 (16.42%) PHP
13 11 (16.42%) T-SQL
13 11 (16.42%) Agile Software Development
13 11 (16.42%) Analytical Skills
13 11 (16.42%) jQuery
14 10 (14.93%) Degree
14 10 (14.93%) Ajax
14 10 (14.93%) XML
14 10 (14.93%) ITIL
14 10 (14.93%) OO

SQL
Co-occurring IT Skills in Preston 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 2 (2.99%) WordPress
2 1 (1.49%) Apache
2 1 (1.49%) nginx
Applications
1 7 (10.45%) Microsoft Excel
2 1 (1.49%) Microsoft PowerPoint
Business Applications
1 5 (7.46%) Dynamics NAV
2 2 (2.99%) Oracle EBS
3 1 (1.49%) Cognos TM1
3 1 (1.49%) Dynamics AX
3 1 (1.49%) Oracle Applications
3 1 (1.49%) Oracle EBS R12
Communications & Networking
1 4 (5.97%) SMS
Database & Business Intelligence
1 40 (59.70%) SQL Server
2 19 (28.36%) SQL Server Reporting Services
3 17 (25.37%) SQL Server Integration Services
4 9 (13.43%) MySQL
4 9 (13.43%) SQL Server Analysis Services
5 8 (11.94%) SQL Server 2008
6 6 (8.96%) SQL Server 2012
7 5 (7.46%) Power BI
7 5 (7.46%) SQL Server 2005
8 4 (5.97%) DB2
9 2 (2.99%) Data Warehouse
9 2 (2.99%) Oracle Reports
10 1 (1.49%) BusinessObjects
10 1 (1.49%) Microsoft Analysis Services
10 1 (1.49%) MongoDB
10 1 (1.49%) NoSQL
10 1 (1.49%) Oracle Database
10 1 (1.49%) Oracle Database 12c
10 1 (1.49%) QlikView
10 1 (1.49%) Relational Database
Development Applications
1 2 (2.99%) Oracle APEX
1 2 (2.99%) Oracle Forms
2 1 (1.49%) Bitbucket
2 1 (1.49%) Git (software)
2 1 (1.49%) GitLab
2 1 (1.49%) PhpStorm
General
1 8 (11.94%) Finance
1 8 (11.94%) Marketing
2 3 (4.48%) Manufacturing
2 3 (4.48%) Telecoms
3 1 (1.49%) Advertising
3 1 (1.49%) Back Office
3 1 (1.49%) Games
Job Titles
1 45 (67.16%) Developer
2 25 (37.31%) .NET Developer
3 24 (35.82%) C# .NET Developer
3 24 (35.82%) C# Developer
4 19 (28.36%) ASP.NET Developer
4 19 (28.36%) C# ASP.NET Developer
5 16 (23.88%) ASP.NET MVC Developer
6 11 (16.42%) PHP Developer
7 8 (11.94%) Analyst
8 6 (8.96%) SQL Developer
8 6 (8.96%) Technical Leader
9 5 (7.46%) Applications Support
9 5 (7.46%) Business Intelligence Developer
9 5 (7.46%) DBA
10 4 (5.97%) Applications Support Analyst
10 4 (5.97%) Senior Developer
10 4 (5.97%) SQL DBA
10 4 (5.97%) Support Analyst
11 3 (4.48%) T-SQL Developer
11 3 (4.48%) XML Developer
Libraries, Frameworks & Software Standards
1 36 (53.73%) .NET
2 33 (49.25%) ASP.NET
3 17 (25.37%) .NET Framework
3 17 (25.37%) ASP.NET MVC
4 16 (23.88%) ASP.NET Web Forms
4 16 (23.88%) Entity Framework
4 16 (23.88%) LINQ
5 14 (20.90%) CSS
6 13 (19.40%) HTML
7 11 (16.42%) jQuery
8 10 (14.93%) Ajax
8 10 (14.93%) XML
9 9 (13.43%) HTML5
9 9 (13.43%) Symfony
10 8 (11.94%) CakePHP
10 8 (11.94%) Laravel
10 8 (11.94%) SOAP
11 1 (1.49%) CSS3
11 1 (1.49%) DHTML
11 1 (1.49%) Web Services
Miscellaneous
1 11 (16.42%) Analytical Skills
2 5 (7.46%) Clustering
3 4 (5.97%) AS400
3 4 (5.97%) iSeries
4 2 (2.99%) Greenfield Project
4 2 (2.99%) N-Tier
5 1 (1.49%) Computer Science
5 1 (1.49%) Data Structures
5 1 (1.49%) iPad
5 1 (1.49%) Linux Command Line
5 1 (1.49%) W3C
Operating Systems
1 17 (25.37%) Windows
2 2 (2.99%) Linux
3 1 (1.49%) Ubuntu
Processes & Methodologies
1 24 (35.82%) MVC
2 21 (31.34%) Web Development
3 20 (29.85%) Unit Testing
4 16 (23.88%) TDD
4 16 (23.88%) Workflow
5 12 (17.91%) Business Intelligence
6 11 (16.42%) Agile Software Development
7 10 (14.93%) ITIL
7 10 (14.93%) OO
8 8 (11.94%) Creative Marketing
8 8 (11.94%) Data Analysis
8 8 (11.94%) Digital Marketing
8 8 (11.94%) OOP
9 6 (8.96%) ERP
9 6 (8.96%) Project Management
10 5 (7.46%) Business Analysis
10 5 (7.46%) Data Protection
10 5 (7.46%) Incident Management
10 5 (7.46%) PRINCE
10 5 (7.46%) User Acceptance Testing
Programming Languages
1 36 (53.73%) C#
2 11 (16.42%) PHP
2 11 (16.42%) T-SQL
3 4 (5.97%) JavaScript
3 4 (5.97%) RPG
3 4 (5.97%) VBA
4 2 (2.99%) PL/SQL
5 1 (1.49%) Bash Shell
5 1 (1.49%) PHP 5
5 1 (1.49%) PHP 7
5 1 (1.49%) X++
Qualifications
1 10 (14.93%) Degree
2 1 (1.49%) ACCA
2 1 (1.49%) CIMA
2 1 (1.49%) ITIL Certification
2 1 (1.49%) Microsoft Certification
Quality Assurance & Compliance
1 6 (8.96%) SLA
2 1 (1.49%) Actionable Recommendations
2 1 (1.49%) PMO
2 1 (1.49%) QA
Vendors
1 5 (7.46%) IBM
2 4 (5.97%) Microsoft
3 3 (4.48%) Oracle
4 2 (2.99%) Capita
4 2 (2.99%) Cognos
5 1 (1.49%) Cisco
5 1 (1.49%) Epicor
5 1 (1.49%) Zend