80

A SQL Dojo is a meeting where a bunch of developers, DBA and SYSPROGS get together to work on a number of SQL challenges. They are there to have fun and to engage in a group effort in order to improve their skills in a non-competitive, collaborative, fun environment. The goal is to have practical hands-on experience within a group of peers, learning a specific technical skill and having some fun.

The exercise is considered successful when it is completed within allocated time AND audience can repeat the exercise at home by themselves. At the end of the dojo the participants receive, a working solution by dojo leaders, which might not correspond to the solution the participants came up with, but is also working.
Teams will code a couple of SQL PL programs, deploy them, and test them to completion.

This covers many standards, guidelines every IT department should have for SQL programming. This covers many of the efficiencies/inefficiencies of the SQL code. This cover many of the ‘Do not code this way’, ‘Code this way’ examples. This is a great start for developers to know possible SQL issues.Great SQL examples throughout.

This covers many SQL tuning standards/guidelines and best practices. This covers Do’s and Don’t’s of coding, stage 1 and stage 2 predicates, indexable and non-indexable predicates, statistics, design, new SQL features and more…