Skills SQL Server TSQL

Used at:...

  Used at: 
  MUFG Securities
  SSE_Energy_GDPR
  ING Investment Management

Standard SQL

Select, Insert, Update, Delete, Truncate, Merge, tables, columns

Window functions

OVER (ORDER BY col1)

CTE - Common Table Expressions

Used at:...

  Used at: 
  MUFG Securities

Use of SQL Server CTEs (Common Table Expressions).

Sorting

Order By

Desc - descending order

Joins

Inner Join

Left Join

Cartesian joins (cross-products) with no where clause

Indexes and keys

Primary keys

Foreign keys

Unique keys

Clustered indexes

Non-clustered indexes

Index Rebuilds

Index/table statistics refreshing

Stored Procedures

Used at:...

  Used at: 
  MUFG Securities
  Five Guys
  Premier Foods
  Autodata

Pivot

Used at:...

  Used at: 
  Autodata

Pivot function

Unpivot function

Union

Used at:...

  Used at: 
  Autodata

Union

Union All

Datatypes

Int, VarChar(8000), nVarChar(4000), DateTime, Image, XML..

Dynamic SQL

Used at:...

  Used at: 
  Autodata

Dynamic SQL

SQL Injection

Other

Cursors

BCP - Bulk copy protocol

Triggers