The table below looks at the statistics for T-SQL skills in IT jobs advertised for the Lancashire region. Included is a guide to the salaries offered in IT jobs that have cited T-SQL over the 3 months to 29 June 2016 with a comparison to the same period over the previous 2 years.

3 months to
29 Jun 2016
Same period 2015 Same period 2014
Transact-SQL
Rank 36 49 37
Rank change year-on-year
+13 -12
Permanent jobs citing T-SQL 26 25 20
As % of all permanent IT jobs located in Lancashire 5.78% 4.23% 4.48%
As % of the Programming Languages category 9.89% 6.87% 7.72%
Number of salaries quoted 12 22 20
Median salary £32,000 £36,000 £35,000
Median salary % change year-on-year
-11.11% +2.85%
90% offered a salary of more than £27,500 £33,050 £24,800
10% offered a salary of more than £47,200 £40,000 £35,750
UK excluding London median salary £40,000 £40,000 £38,500
% change year-on-year
- +3.89%
T-SQL
North West

The following table is for comparison with the above and provides statistics for the entire Programming Languages category in permanent jobs advertised in the Lancashire region.

Programming Languages Category
Lancashire
Permanent IT job ads with a match in the
Programming Languages category
263 364 259
As % of all permanent IT jobs located in Lancashire 58.44% 61.59% 58.07%
Number of salaries quoted 218 290 215
Median salary £37,500 £35,000 £34,000
Median salary % change year-on-year
+7.14% +2.94%
90% offered a salary of more than £27,500 £27,000 £22,750
10% offered a salary of more than £45,000 £42,500 £45,000
UK excluding London median salary £41,000 £40,000 £40,000
% change year-on-year
+2.50% -

T-SQL
Jobs Demand Trend in Lancashire

The demand trend of job ads across the Lancashire region citing T-SQL as a proportion of all IT jobs with a match in the Programming Languages category.

T-SQL Jobs Demand Trend in Lancashire

T-SQL
Salary Trend in Lancashire

This chart provides the 3-month moving average for salaries quoted in permanent IT jobs citing T-SQL across the Lancashire region.

T-SQL Salary Trend in Lancashire

T-SQL
Salary Histogram in Lancashire

This chart provides a salary histogram for IT jobs citing T-SQL across the Lancashire region over the 3 months to 29 June 2016.

T-SQL Salary Histogram in Lancashire

T-SQL
Job Locations in Lancashire

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing T-SQL within the Lancashire region over the 3 months to 29 June 2016. The 'Rank Change' column provides an indication of the change in demand within each location based on the same 3 month period last year.

Location
(Click see detailed
statistics and trends)
Rank Change
on Same Period
Last Year
Matching
Permanent
IT Job Ads
Median Salary
Last 3 Months
Median Salary
% Change
on Same Period
Last Year
Live
Job
Vacancies
Chorley +4 13 £31,500 -5.97%
Lancaster - 4 - -
Burnley - 3 £27,500 -
Preston - 3 £40,000 - 2
Blackburn +7 2 £48,000 +33.33%
T-SQL
North West

T-SQL
Top 30 Related IT Skills in Lancashire

For the 6 months to 29 June 2016, IT jobs citing T-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 Lancashire region with a requirement for T-SQL.

1 52 (100.00%) SQL
2 33 (63.46%) .NET
3 32 (61.54%) ASP.NET
4 26 (50.00%) SQL Server
5 24 (46.15%) SQL Server Reporting Services
6 20 (38.46%) Windows
6 20 (38.46%) Windows Server
7 19 (36.54%) Agile Software Development
8 17 (32.69%) Degree
9 16 (30.77%) C#
9 16 (30.77%) JavaScript
10 15 (28.85%) CSS
10 15 (28.85%) Business Intelligence
10 15 (28.85%) jQuery
11 14 (26.92%) User Acceptance Testing
11 14 (26.92%) ITIL
11 14 (26.92%) Windows Server 2012
11 14 (26.92%) Electronic Patient Records
11 14 (26.92%) Lorenzo
12 13 (25.00%) Microsoft
13 12 (23.08%) SQL Server Integration Services
14 11 (21.15%) TDD
14 11 (21.15%) MVC
14 11 (21.15%) Scrum
14 11 (21.15%) HTML
15 10 (19.23%) Continuous Integration
15 10 (19.23%) BDD
16 9 (17.31%) SQL Server 2012
16 9 (17.31%) Twitter Bootstrap
17 8 (15.38%) iPad

T-SQL
Top Related IT Skills in Lancashire 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 1 (1.92%) CMS
1 1 (1.92%) Drupal
1 1 (1.92%) SharePoint
1 1 (1.92%) WordPress
Applications
1 8 (15.38%) MS Office
2 6 (11.54%) MS Excel
Business Applications
1 14 (26.92%) Lorenzo
2 1 (1.92%) Magento
2 1 (1.92%) OpenCart
2 1 (1.92%) osCommerce
Cloud Services
1 6 (11.54%) Amazon AWS
1 6 (11.54%) Amazon EC2
1 6 (11.54%) Cloud Computing
1 6 (11.54%) Microsoft Azure
2 4 (7.69%) SaaS
Database & Business Intelligence
1 26 (50.00%) SQL Server
2 24 (46.15%) SQL Server Reporting Services
3 14 (26.92%) Electronic Patient Records
4 12 (23.08%) SQL Server Integration Services
5 9 (17.31%) SQL Server 2012
6 7 (13.46%) Crystal Reports
6 7 (13.46%) Data Warehouse
6 7 (13.46%) SQL Server Analysis Services
7 6 (11.54%) SQL Server 2014
8 5 (9.62%) SQL Server 2008
9 3 (5.77%) OLAP
9 3 (5.77%) Power BI
10 2 (3.85%) Big Data
10 2 (3.85%) Enterprise Data Warehouse
10 2 (3.85%) Microsoft Analysis Services
10 2 (3.85%) OLAP Cube
10 2 (3.85%) QlikView
10 2 (3.85%) Relational Database
10 2 (3.85%) SQL Server 2005
10 2 (3.85%) SQL Server 2016
Development Applications
1 5 (9.62%) Team Foundation Server
2 4 (7.69%) Mocha
2 4 (7.69%) Sinon.JS
2 4 (7.69%) Visual Studio
3 2 (3.85%) SQL Server Management Studio (SSMS)
4 1 (1.92%) Bazaar
4 1 (1.92%) Git (software)
4 1 (1.92%) Mercurial
4 1 (1.92%) PhantomJS
4 1 (1.92%) PHPUnit
4 1 (1.92%) Subversion
General
1 6 (11.54%) Retail
2 5 (9.62%) Billing
3 4 (7.69%) Finance
4 2 (3.85%) Legal
5 1 (1.92%) Manufacturing
Job Titles
1 31 (59.62%) Developer
2 12 (23.08%) C# Developer
3 11 (21.15%) Business Intelligence Developer
4 10 (19.23%) Applications Support
5 8 (15.38%) Analyst
5 8 (15.38%) SQL Developer
6 6 (11.54%) .NET Developer
6 6 (11.54%) IT Analyst
6 6 (11.54%) Senior C# Developer
6 6 (11.54%) Senior Developer
6 6 (11.54%) SQL BI Developer
7 5 (9.62%) ASP.NET Developer
7 5 (9.62%) C# .NET Developer
7 5 (9.62%) Report Analyst
8 4 (7.69%) .NET Programmer
8 4 (7.69%) ASP.NET Programmer
8 4 (7.69%) C# ASP.NET Developer
8 4 (7.69%) C# Programmer
8 4 (7.69%) JavaScript Developer
8 4 (7.69%) Programmer
Libraries, Frameworks & Software Standards
1 33 (63.46%) .NET
2 32 (61.54%) ASP.NET
3 15 (28.85%) CSS
3 15 (28.85%) jQuery
4 11 (21.15%) HTML
5 9 (17.31%) Twitter Bootstrap
6 8 (15.38%) ASP.NET MVC
7 7 (13.46%) HTML5
8 6 (11.54%) JSON
8 6 (11.54%) Node.js
8 6 (11.54%) REST
8 6 (11.54%) XML
9 5 (9.62%) .NET Framework
9 5 (9.62%) WCF
10 4 (7.69%) ASP.NET MVC 4
10 4 (7.69%) Chai
10 4 (7.69%) Entity Framework
10 4 (7.69%) Express
10 4 (7.69%) Unity DI Container
11 3 (5.77%) AngularJS
Miscellaneous
1 8 (15.38%) iPad
2 6 (11.54%) Management Information System
3 5 (9.62%) Data Integration
3 5 (9.62%) Smart Meter
4 4 (7.69%) Clustering
4 4 (7.69%) Enterprise Software
4 4 (7.69%) Replication
5 1 (1.92%) FMCG
5 1 (1.92%) User Experience
Operating Systems
1 20 (38.46%) Windows
1 20 (38.46%) Windows Server
2 14 (26.92%) Windows Server 2012
3 7 (13.46%) Linux
4 6 (11.54%) Unix
Processes & Methodologies
1 19 (36.54%) Agile Software Development
2 15 (28.85%) Business Intelligence
3 14 (26.92%) ITIL
3 14 (26.92%) User Acceptance Testing
4 11 (21.15%) MVC
4 11 (21.15%) Scrum
4 11 (21.15%) TDD
5 10 (19.23%) BDD
5 10 (19.23%) Continuous Integration
6 8 (15.38%) ETL
7 7 (13.46%) OO
8 6 (11.54%) Pair Programming
9 5 (9.62%) Release Management
9 5 (9.62%) Root Cause Analysis
10 4 (7.69%) Dependency Injection
10 4 (7.69%) Kanban
10 4 (7.69%) Kimball Methodology
11 3 (5.77%) Change Data Capture
11 3 (5.77%) Data Modelling
11 3 (5.77%) Front End Development
Programming Languages
1 52 (100.00%) SQL
2 16 (30.77%) C#
2 16 (30.77%) JavaScript
3 7 (13.46%) VB
4 6 (11.54%) C
5 3 (5.77%) VBA
6 2 (3.85%) Data Analysis Expressions (DAX)
6 2 (3.85%) VBScript
7 1 (1.92%) Bash Shell
7 1 (1.92%) Perl
7 1 (1.92%) PHP
7 1 (1.92%) Python
7 1 (1.92%) R
7 1 (1.92%) Shell Script
7 1 (1.92%) VB.NET
Qualifications
1 17 (32.69%) Degree
2 4 (7.69%) BPSS Clearance
2 4 (7.69%) SC Cleared
2 4 (7.69%) Security Cleared
Vendors
1 13 (25.00%) Microsoft
2 1 (1.92%) HP
2 1 (1.92%) Oracle
2 1 (1.92%) SAP
2 1 (1.92%) SYSPRO
2 1 (1.92%) Twitter
2 1 (1.92%) Zend
Preston, Lancashire
Talent International
Salary: £40000 - £45000 per annum
Posted: 1 hour ago
Blackpool, Lancashire
Ascent People Ltd
Salary: £28000 per annum
Posted: 5 days ago
Preston
Computer Futures
Salary: £35000 - £45000 per annum + bonus
Posted: 13 days ago