© 2017 by awari.com.au

  • Black Twitter Icon
  • Black LinkedIn Icon

April 26, 2016

Hey all, how many times have you been data profiling and had the question, what data has been duplicated data in a table ?

It's pretty easy to find out quickly using the HAVING clause with the GROUP BY statement.

Below is an example query that you can use to do this, just replace the table and columns to suit your data requirements.

Code ...

-- This query wil...

April 20, 2016


Just released today 21 Apr 16 , a FREE course for getting started with writing SQL queries.


The course will get the ab-initio student up to speed with writing SQL queries.


The course is delivered using SQL Server 2014 express , so the student does not need to spend any $ and the SQL is all standard ANSI SQL with is transferrable knowledge to other SQL ba...

April 7, 2016

My apologies for taking so long to add this next post , but my SQL course development work took up all of my time and I just did not even think about my blog, so remiss of me!


Anyway, time to rectify this ....


In this post , I will outline the repository architecture , note that this architecture is designed for single or multi tenancy applications, hence...

Hey everyone, 


I have released my new course for those that want to understand and use SQL for data analytics in their day to day data discovery tasks, yep cheap to enroll but the value is worth $1000's !


I built the course to cover those gnarly topics that seem to go unanswered such as how to use the APPLY statement, so many blogs ask what is the use of...

Please reload

The Blog

February 19, 2017

Please reload