Period
to 15 November 2018

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

SQL (Structured Query Language)
West Lothian > Livingston
6 months to
15 Nov 2018
Same period 2017 Same period 2016
Rank 1 1 7
Rank change year-on-year 0 +6 0
Permanent jobs citing SQL 33 27 12
As % of all permanent IT jobs advertised in Livingston 36.26% 40.30% 19.05%
As % of the Programming Languages category 56.90% 51.92% 29.27%
Number of salaries quoted 22 22 11
Livingston median annual salary £40,000 £37,500 £32,500
Median salary % change year-on-year +6.67% +15.38% -13.33%
10th Percentile £26,950 £24,000 £24,000
90th Percentile £48,375 £45,000 £38,750
West Lothian median annual salary £40,000 £33,750 £32,500
% change year-on-year +18.52% +3.85% -18.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 Livingston with a requirement for coding skills.

All Programming Languages
Livingston
Permanent vacancies with a requirement for coding skills 58 52 41
As % of all permanent IT jobs advertised in Livingston 63.74% 77.61% 65.08%
Number of salaries quoted 37 37 35
Livingston median annual salary £42,500 £40,000 £37,500
Median salary % change year-on-year +6.25% +6.67% -6.25%
10th Percentile £29,200 £24,000 £25,100
90th Percentile £52,500 £48,500 £45,750
West Lothian median annual salary £40,000 £40,000 £37,500
% change year-on-year - +6.67% -6.25%

SQL
Job Vacancy Trend in Livingston

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

Job vacancy trend for SQL in Livingston

SQL
Salary Trend in Livingston

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

Salary trend for SQL in Livingston

SQL
Salary Histogram in Livingston

The salary distribution of IT jobs citing SQL in Livingston over the 6 months to 15 November 2018.

Salary histogram for SQL in Livingston

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

1 25 (75.76%) Oracle
2 23 (69.70%) PL/SQL
3 22 (66.67%) JavaScript
4 17 (51.52%) XML
5 15 (45.45%) Degree
6 13 (39.39%) C#
6 13 (39.39%) HTML
7 12 (36.36%) Toad
7 12 (36.36%) Finance
7 12 (36.36%) Ajax
7 12 (36.36%) Computer Science
7 12 (36.36%) Oracle APEX
7 12 (36.36%) jQuery
7 12 (36.36%) Agile Software Development
7 12 (36.36%) Retail
7 12 (36.36%) Software Engineering
7 12 (36.36%) Business Development
7 12 (36.36%) Test Automation
8 11 (33.33%) Java
9 10 (30.30%) C++
9 10 (30.30%) C
9 10 (30.30%) Shell Script
9 10 (30.30%) Python
9 10 (30.30%) Scrum
9 10 (30.30%) Management Information System
9 10 (30.30%) Kanban
9 10 (30.30%) JSON
9 10 (30.30%) Refactoring
9 10 (30.30%) AngularJS
9 10 (30.30%) Microservices

SQL
Co-occurring IT Skills in Livingston 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 5 (15.15%) Apache
1 5 (15.15%) JBoss
1 5 (15.15%) Oracle HTTP Server
2 3 (9.09%) IIS
Business Applications
1 1 (3.03%) Oracle Applications
1 1 (3.03%) Oracle EBS
1 1 (3.03%) Oracle ERP
Cloud Services
1 3 (9.09%) Microsoft Azure
Communications & Networking
1 5 (15.15%) HTTP
1 5 (15.15%) TCP/IP
2 3 (9.09%) Firewall
3 1 (3.03%) Internet
Database & Business Intelligence
1 5 (15.15%) Apache Cassandra
1 5 (15.15%) Oracle Reports
2 2 (6.06%) SQL Server Analysis Services
2 2 (6.06%) SQL Server Integration Services
2 2 (6.06%) SQL Server Reporting Services
3 1 (3.03%) Relational Database
3 1 (3.03%) SQL Server
Development Applications
1 12 (36.36%) Oracle APEX
1 12 (36.36%) Toad
2 10 (30.30%) Team Foundation Server
3 5 (15.15%) ClearCase
3 5 (15.15%) CppUnit
3 5 (15.15%) Git (software)
3 5 (15.15%) JUnit
3 5 (15.15%) ProC
4 2 (6.06%) HP UFT
4 2 (6.06%) Ranorex
4 2 (6.06%) SoapUI
4 2 (6.06%) Visual Studio
General
1 12 (36.36%) Finance
1 12 (36.36%) Retail
Job Titles
1 15 (45.45%) Developer
2 12 (36.36%) Oracle Developer
3 10 (30.30%) Software Engineer
4 7 (21.21%) Analyst
5 5 (15.15%) PL/SQL Developer
5 5 (15.15%) SQL Analyst
5 5 (15.15%) SQL Developer
6 3 (9.09%) Developer/Software Engineer
6 3 (9.09%) Embedded Engineer
6 3 (9.09%) Embedded Software Engineer
6 3 (9.09%) Software Developer
6 3 (9.09%) Technical Analyst
7 2 (6.06%) C++ Software Engineer
7 2 (6.06%) Cloud Technical Analyst
7 2 (6.06%) Report Analyst
7 2 (6.06%) Software Test Engineer
7 2 (6.06%) SQL Reporting Analyst
7 2 (6.06%) Support Engineer
7 2 (6.06%) Test Engineer
8 1 (3.03%) Test Automation Engineer
Libraries, Frameworks & Software Standards
1 17 (51.52%) XML
2 13 (39.39%) HTML
3 12 (36.36%) Ajax
3 12 (36.36%) jQuery
4 10 (30.30%) AngularJS
4 10 (30.30%) JSON
5 5 (15.15%) Kafka
5 5 (15.15%) RESTful
5 5 (15.15%) SOAP
5 5 (15.15%) WebSockets
Miscellaneous
1 12 (36.36%) Computer Science
2 10 (30.30%) Management Information System
3 1 (3.03%) Analytical Skills
3 1 (3.03%) Embedded Systems
3 1 (3.03%) Fintech
Operating Systems
1 9 (27.27%) Linux
2 6 (18.18%) Windows
2 6 (18.18%) Windows Server
3 1 (3.03%) Windows Server 2008
3 1 (3.03%) Windows Server 2012
Processes & Methodologies
1 12 (36.36%) Agile Software Development
1 12 (36.36%) Business Development
1 12 (36.36%) Software Engineering
1 12 (36.36%) Test Automation
2 10 (30.30%) Kanban
2 10 (30.30%) Microservices
2 10 (30.30%) Refactoring
2 10 (30.30%) Scenario Testing
2 10 (30.30%) Scrum
3 6 (18.18%) Configuration Management
4 5 (15.15%) Multithreaded Programming
4 5 (15.15%) Multithreading
4 5 (15.15%) Open Source
4 5 (15.15%) Web Application Development
5 3 (9.09%) Deployment Automation
5 3 (9.09%) ITIL
6 2 (6.06%) Business Intelligence
6 2 (6.06%) Problem-Solving
6 2 (6.06%) Software Deployment
6 2 (6.06%) Task Automation
Programming Languages
1 23 (69.70%) PL/SQL
2 22 (66.67%) JavaScript
3 13 (39.39%) C#
4 11 (33.33%) Java
5 10 (30.30%) C
5 10 (30.30%) C++
5 10 (30.30%) Python
5 10 (30.30%) Shell Script
6 7 (21.21%) Perl
7 3 (9.09%) PowerShell
8 2 (6.06%) R
8 2 (6.06%) T-SQL
8 2 (6.06%) VBScript
Qualifications
1 15 (45.45%) Degree
2 2 (6.06%) HND
Systems Management
1 5 (15.15%) Kubernetes
2 3 (9.09%) Ansible
2 3 (9.09%) Opscode Chef
3 2 (6.06%) HP Quality Center
Vendors
1 25 (75.76%) Oracle
2 6 (18.18%) Microsoft