Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Core T-SQL

By Steve Jones,

Often I find myself wondering about the minimum bar we expect people to clear to be competent in some field. Almost all fields are evolving these days as technology and new ideas are put into practice in medicine, art, construction, law, etc. It seems as though a Renaissance is taking place with the speed and variety at which new information is spreading, usually due to advances in technology.

In our field, working with SQL Server, we certainly see new ideas and enhancements taking place all the time. However there are also a number of core skills that evolve, but at a slower pace. For example, T-SQL grows with each new version of SQL Server, but the core language remains, and many people continue to use the knowledge they have had for years when writing code.

This week I'm curious if we can debate about, and compile, a list of core skills with T-SQL that we think someone ought to understand to be considered competent as a database developer. I'm asking:

What core skills should someone have with T-SQL?

I'll start the list, but feel free to add to it or give me your thoughts. I think someone ought to be able to understand these items and write code to solve problems that involve:

  • finding duplicate rows (grouping, joins)
  • returning aggregates of single or multiple columns (MAX, MIN, SUM, COUNT)
  • return aggregates in groups, or islands. (grouping and aggregates, windowing)
  • join multiple tables together on matching, multiple columns (joins)
  • find data in one table that doesn't have matches in another (outer joins)
  • filtering data (WHERE)
  • subqueries and complex CTE joins of data
  • create row numbers and join back to a table without numbers (APPLY)
  • pivoting data from rows to columns

That's a starting list from a number of questions I've seen, but feel free to add your own skills you think people need.

Total article views: 587 | Views in the last 30 days: 2
 
Related Articles
FORUM

Aggregating nvarchar(max) column

Aggregating multiple datatypes in a single column

FORUM

Stacked Column Chart - Incorrect Aggregate ???

I have an aggregate problem with a stacked column chart...

FORUM

Pivot with dynamic number of columns

Pivot with dynamic number of columns

FORUM

Aggregation

Confused about aggregation

FORUM

Picking up Oracle development skills

Need to duplicate SQL Server data warehousing skills into Oracle

Tags
career    
editorial    
friday poll    
t-sql    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones