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

3 months to
5 May 2016
Same period 2015 Same period 2014
Transact-SQL
Rank 6 9 15
Rank change year-on-year
+3 +6
Permanent jobs citing T-SQL 12 10 7
As % of all permanent IT jobs located in West Lothian 21.43% 16.39% 7.53%
As % of the Programming Languages category 37.50% 26.32% 12.96%
Number of salaries quoted 7 10 5
Median salary £45,000 £35,000 £40,000
Median salary % change year-on-year
+28.57% -12.50%
UK excluding London median salary £40,000 £40,000 £38,500
% change year-on-year
- +3.89%
T-SQL
Scotland

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

Programming Languages Category
West Lothian
Permanent IT job ads with a match in the
Programming Languages category
32 38 54
As % of all permanent IT jobs located in West Lothian 57.14% 62.30% 58.06%
Number of salaries quoted 15 28 45
Median salary £45,000 £35,000 £37,500
Median salary % change year-on-year
+28.57% -6.66%
90% offered a salary of more than £32,500 £34,000 £35,000
10% offered a salary of more than £50,000 £45,000 £50,000
UK excluding London median salary £41,500 £40,000 £39,500
% change year-on-year
+3.75% +1.26%

T-SQL
Jobs Demand Trend in West Lothian

The demand trend of job ads across the West Lothian 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 West Lothian

T-SQL
Salary Trend in West Lothian

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

T-SQL Salary Trend in West Lothian

T-SQL
Job Locations in West Lothian

The table below looks at the demand and provides a guide to the median salaries quoted in IT jobs citing T-SQL within the West Lothian region over the 3 months to 5 May 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
Livingston +4 9 £45,000 +28.57%
Bathgate - 1 - -
T-SQL
Scotland

T-SQL
Top 30 Related IT Skills in West Lothian

For the 6 months to 5 May 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 West Lothian region with a requirement for T-SQL.

1 14 (82.35%) ASP.NET
1 14 (82.35%) .NET
2 12 (70.59%) SQL Server
3 11 (64.71%) CSS
3 11 (64.71%) HTML
4 10 (58.82%) SQL
4 10 (58.82%) E-Commerce
5 9 (52.94%) SQL Server Integration Services
6 8 (47.06%) JavaScript
7 7 (41.18%) jQuery
8 6 (35.29%) Ajax
8 6 (35.29%) C#
9 5 (29.41%) IIS
9 5 (29.41%) Systems Analysis
10 4 (23.53%) VMware Infrastructure
10 4 (23.53%) Microsoft Azure
10 4 (23.53%) HTML5
10 4 (23.53%) VMware
10 4 (23.53%) Back Office
10 4 (23.53%) ERP
11 3 (17.65%) B2B
11 3 (17.65%) Mobile Development
11 3 (17.65%) Amazon AWS
12 2 (11.76%) ASP.NET MVC
12 2 (11.76%) Android
12 2 (11.76%) SQL Server 2008
12 2 (11.76%) CSS3
12 2 (11.76%) ASP.NET Web Forms
12 2 (11.76%) Mobile App
12 2 (11.76%) Mobile Application Development

T-SQL
Top Related IT Skills in West Lothian 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 (29.41%) IIS
Applications
1 2 (11.76%) MS Excel
Cloud Services
1 4 (23.53%) Microsoft Azure
2 3 (17.65%) Amazon AWS
Communications & Networking
1 2 (11.76%) Intranet
Database & Business Intelligence
1 12 (70.59%) SQL Server
2 9 (52.94%) SQL Server Integration Services
3 2 (11.76%) SQL Server 2008
4 1 (5.88%) Relational Database
4 1 (5.88%) SQL Server 2005
Development Applications
1 1 (5.88%) Xcode
General
1 4 (23.53%) Back Office
2 2 (11.76%) Finance
3 1 (5.88%) Banking
3 1 (5.88%) Retail
Job Titles
1 16 (94.12%) Developer
2 7 (41.18%) Database Developer
3 6 (35.29%) .NET Developer
4 5 (29.41%) SQL Developer
5 3 (17.65%) .NET Software Developer
5 3 (17.65%) C# .NET Developer
5 3 (17.65%) C# Developer
5 3 (17.65%) C# Software Developer
5 3 (17.65%) Software Developer
6 2 (11.76%) ASP.NET Developer
6 2 (11.76%) C# ASP.NET Developer
6 2 (11.76%) Senior .NET Developer
6 2 (11.76%) Senior Developer
6 2 (11.76%) SQL Database Developer
7 1 (5.88%) Database Specialist
7 1 (5.88%) HTML Developer
7 1 (5.88%) Systems Developer
7 1 (5.88%) T-SQL Developer
Libraries, Frameworks & Software Standards
1 14 (82.35%) .NET
1 14 (82.35%) ASP.NET
2 11 (64.71%) CSS
2 11 (64.71%) HTML
3 7 (41.18%) jQuery
4 6 (35.29%) Ajax
5 4 (23.53%) HTML5
6 2 (11.76%) ASP.NET MVC
6 2 (11.76%) ASP.NET Web Forms
6 2 (11.76%) CSS3
Miscellaneous
1 2 (11.76%) Mobile App
2 1 (5.88%) Computer Science
2 1 (5.88%) User Experience
Operating Systems
1 2 (11.76%) Android
1 2 (11.76%) Apple iOS
Processes & Methodologies
1 10 (58.82%) E-Commerce
2 5 (29.41%) Systems Analysis
3 4 (23.53%) ERP
4 3 (17.65%) B2B
4 3 (17.65%) Mobile Development
5 2 (11.76%) B2C
5 2 (11.76%) Mobile Application Development
5 2 (11.76%) MVC
6 1 (5.88%) Agile Software Development
6 1 (5.88%) BDD
6 1 (5.88%) Front End Development
6 1 (5.88%) High Availability
6 1 (5.88%) iOS Development
6 1 (5.88%) OO
6 1 (5.88%) OOP
6 1 (5.88%) Performance Tuning
6 1 (5.88%) SDLC
6 1 (5.88%) TDD
6 1 (5.88%) Web Development
Programming Languages
1 10 (58.82%) SQL
2 8 (47.06%) JavaScript
3 6 (35.29%) C#
4 1 (5.88%) VB.NET
Qualifications
1 1 (5.88%) Degree
System Software
1 4 (23.53%) VMware Infrastructure
Vendors
1 4 (23.53%) VMware
2 2 (11.76%) Microsoft
3 1 (5.88%) Telerik