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 30 July 2016 with a comparison to the same period over the previous 2 years.

3 months to
30 Jul 2016
Same period 2015 Same period 2014
Transact-SQL
Rank 39 47 42
Rank change year-on-year
+8 -5
Permanent jobs citing T-SQL 17 22 18
As % of all permanent IT jobs located in Lancashire 4.25% 4.08% 3.85%
As % of the Programming Languages category 7.73% 6.69% 6.41%
Number of salaries quoted 12 19 18
Median salary £33,750 £37,500 £37,500
Median salary % change year-on-year
-10.00% -
90% offered a salary of more than £27,500 £34,700 £25,400
10% offered a salary of more than £40,000 £45,000 £40,750
UK excluding London median salary £40,000 £40,000 £39,000
% change year-on-year
- +2.56%
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
220 329 281
As % of all permanent IT jobs located in Lancashire 55.00% 61.04% 60.04%
Number of salaries quoted 193 278 236
Median salary £37,500 £35,000 £36,500
Median salary % change year-on-year
+7.14% -4.10%
90% offered a salary of more than £26,150 £27,500 £24,000
10% offered a salary of more than £45,000 £44,000 £43,500
UK excluding London median salary £41,500 £40,000 £40,000
% change year-on-year
+3.75% -

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 30 July 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 30 July 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 -1 8 £32,500 -5.10%
Burnley - 4 £27,500 -
Preston +5 3 £40,000 -11.11%
T-SQL
North West

T-SQL
Top 30 Related IT Skills in Lancashire

For the 6 months to 30 July 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 51 (100.00%) SQL
2 33 (64.71%) .NET
3 32 (62.75%) ASP.NET
4 28 (54.90%) SQL Server
5 24 (47.06%) SQL Server Reporting Services
6 22 (43.14%) Agile Software Development
7 19 (37.25%) C#
7 19 (37.25%) JavaScript
8 17 (33.33%) CSS
8 17 (33.33%) jQuery
9 16 (31.37%) Windows
9 16 (31.37%) Windows Server
10 15 (29.41%) Microsoft
10 15 (29.41%) Business Intelligence
11 13 (25.49%) Scrum
11 13 (25.49%) HTML
12 12 (23.53%) MVC
12 12 (23.53%) TDD
12 12 (23.53%) SQL Server Integration Services
13 11 (21.57%) Degree
13 11 (21.57%) Continuous Integration
13 11 (21.57%) BDD
14 10 (19.61%) Windows Server 2012
14 10 (19.61%) Twitter Bootstrap
14 10 (19.61%) Electronic Patient Records
14 10 (19.61%) Lorenzo
14 10 (19.61%) User Acceptance Testing
14 10 (19.61%) ITIL
15 9 (17.65%) ETL
15 9 (17.65%) ASP.NET MVC

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 2 (3.92%) SharePoint
2 1 (1.96%) CMS
2 1 (1.96%) Drupal
2 1 (1.96%) IIS
2 1 (1.96%) WordPress
Applications
1 8 (15.69%) MS Office
2 7 (13.73%) MS Excel
Business Applications
1 10 (19.61%) Lorenzo
2 1 (1.96%) Magento
2 1 (1.96%) OpenCart
2 1 (1.96%) osCommerce
Cloud Services
1 6 (11.76%) Amazon AWS
1 6 (11.76%) Amazon EC2
1 6 (11.76%) Cloud Computing
1 6 (11.76%) Microsoft Azure
2 5 (9.80%) SaaS
Database & Business Intelligence
1 28 (54.90%) SQL Server
2 24 (47.06%) SQL Server Reporting Services
3 12 (23.53%) SQL Server Integration Services
4 10 (19.61%) Electronic Patient Records
5 8 (15.69%) SQL Server 2012
5 8 (15.69%) SQL Server 2014
5 8 (15.69%) SQL Server Analysis Services
6 7 (13.73%) Crystal Reports
7 6 (11.76%) Data Warehouse
8 5 (9.80%) Power BI
9 4 (7.84%) SQL Server 2016
10 3 (5.88%) Big Data
10 3 (5.88%) Microsoft Analysis Services
10 3 (5.88%) OLAP
10 3 (5.88%) SQL Server 2008
11 2 (3.92%) OLAP Cube
11 2 (3.92%) QlikView
11 2 (3.92%) Relational Database
11 2 (3.92%) SQL Server 2005
11 2 (3.92%) Star Schema
Development Applications
1 7 (13.73%) Team Foundation Server
2 6 (11.76%) Visual Studio
3 5 (9.80%) Mocha
3 5 (9.80%) Sinon.JS
4 2 (3.92%) SQL Server Management Studio (SSMS)
5 1 (1.96%) Bazaar
5 1 (1.96%) Git (software)
5 1 (1.96%) Mercurial
5 1 (1.96%) PhantomJS
5 1 (1.96%) PHPUnit
5 1 (1.96%) Subversion
General
1 6 (11.76%) Retail
2 5 (9.80%) Billing
2 5 (9.80%) Finance
3 2 (3.92%) Legal
4 1 (1.96%) Manufacturing
Job Titles
1 33 (64.71%) Developer
2 13 (25.49%) C# Developer
3 10 (19.61%) Applications Support
3 10 (19.61%) Business Intelligence Developer
4 8 (15.69%) Analyst
5 7 (13.73%) .NET Developer
5 7 (13.73%) SQL Developer
6 6 (11.76%) ASP.NET Developer
6 6 (11.76%) C# .NET Developer
6 6 (11.76%) IT Analyst
6 6 (11.76%) Senior C# Developer
6 6 (11.76%) Senior Developer
7 5 (9.80%) C# ASP.NET Developer
7 5 (9.80%) JavaScript Developer
7 5 (9.80%) Report Analyst
7 5 (9.80%) SQL BI Developer
8 4 (7.84%) ASP.NET Programmer
8 4 (7.84%) C# Programmer
8 4 (7.84%) Front End Developer (Client-Side Developer)
8 4 (7.84%) Programmer
Libraries, Frameworks & Software Standards
1 33 (64.71%) .NET
2 32 (62.75%) ASP.NET
3 17 (33.33%) CSS
3 17 (33.33%) jQuery
4 13 (25.49%) HTML
5 10 (19.61%) Twitter Bootstrap
6 9 (17.65%) ASP.NET MVC
7 7 (13.73%) HTML5
7 7 (13.73%) Node.js
8 6 (11.76%) .NET Framework
8 6 (11.76%) JSON
8 6 (11.76%) REST
8 6 (11.76%) XML
9 5 (9.80%) Chai
9 5 (9.80%) Entity Framework
9 5 (9.80%) Express
9 5 (9.80%) WCF
10 4 (7.84%) AngularJS
10 4 (7.84%) ASP.NET MVC 4
10 4 (7.84%) Unity DI Container
Miscellaneous
1 8 (15.69%) iPad
2 6 (11.76%) Data Integration
2 6 (11.76%) Management Information System
3 5 (9.80%) Clustering
3 5 (9.80%) Enterprise Software
3 5 (9.80%) Replication
3 5 (9.80%) Smart Meter
4 1 (1.96%) FMCG
4 1 (1.96%) User Experience
Operating Systems
1 16 (31.37%) Windows
1 16 (31.37%) Windows Server
2 10 (19.61%) Windows Server 2012
3 7 (13.73%) Linux
4 6 (11.76%) Unix
Processes & Methodologies
1 22 (43.14%) Agile Software Development
2 15 (29.41%) Business Intelligence
3 13 (25.49%) Scrum
4 12 (23.53%) MVC
4 12 (23.53%) TDD
5 11 (21.57%) BDD
5 11 (21.57%) Continuous Integration
6 10 (19.61%) ITIL
6 10 (19.61%) User Acceptance Testing
7 9 (17.65%) ETL
8 7 (13.73%) OO
9 6 (11.76%) Pair Programming
9 6 (11.76%) Root Cause Analysis
10 5 (9.80%) Kanban
10 5 (9.80%) Release Management
11 4 (7.84%) Change Data Capture
11 4 (7.84%) Dependency Injection
11 4 (7.84%) Front End Development
12 3 (5.88%) Functional Testing
12 3 (5.88%) Kimball Methodology
Programming Languages
1 51 (100.00%) SQL
2 19 (37.25%) C#
2 19 (37.25%) JavaScript
3 7 (13.73%) C
3 7 (13.73%) VB
4 3 (5.88%) R
4 3 (5.88%) VBA
5 2 (3.92%) Data Analysis Expressions (DAX)
5 2 (3.92%) Python
5 2 (3.92%) VBScript
6 1 (1.96%) Bash Shell
6 1 (1.96%) Perl
6 1 (1.96%) PHP
6 1 (1.96%) Shell Script
6 1 (1.96%) VB.NET
Qualifications
1 11 (21.57%) Degree
Vendors
1 15 (29.41%) Microsoft
2 1 (1.96%) HP
2 1 (1.96%) Oracle
2 1 (1.96%) SAP
2 1 (1.96%) SYSPRO
2 1 (1.96%) Twitter
2 1 (1.96%) Zend