560 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Wise Owl coding standards for T-SQL (the SQL dialect used in SQL Server)
Part one of a three-part series of blogs
A blog setting out an approach to coding in SQL to ensure consistently high standards across your organisation.
Life is easier if everyone uses the same conventions!
Example: you're only able to read this because a) you understand English and b) you use an Internet browser which interprets the near-universal markup language HTML.
The aim of this blog is to lay down sensible guidelines for how to write SQL, so that everyone in your organisation can speak the same language in the same way! I've divided the blog into two parts:
How to write queries to select data from tables (broadly corresponding with our introduction to SQL course).
Programming in SQL
How to write stored procedures, CTEs and other more advanced SQL programming constructs (broadly corresponding with our advanced SQL course).
You can download and run this script if you want to try out any of the example queries yourself (they're based on a simple database of 459 momentous events in history).
|Parts of this blog|
25 Aytoun Street