Background Whilst I do most of my SQL editing using using an Open Source SQL editing tool, there are some online tools I use for SQL related tasks. I always keep privacy in mind so I never use these tools with sensitive data. Reasons for using these tools include: When I am not working on…Continue readingOnline SQL Tools I Use
Category: SQL
Categories
Formatting SQL to increase productivity
Background Formatted SQL is does not run any better than unformatted SQL. The database really couldn’t care less whether you put your commas before or after each field name. For your sanity and to be an effective SQL writer I advise that you follow some formatting guidelines. In this post I will share how I…Continue readingFormatting SQL to increase productivity
No matter how many reports and cubes you build you are always going to have users who need large extracts of raw data in CSV format. Typically this data is used for analysis using tools such as Tableau, R and MS Excel. In my experience large data extracts are done by an individuals part of…Continue readingThe Most Efficient Way to do Large SQL Data Extracts From Your BI Tool
SELECT statement I have worked with numerous non IT professionals including medical doctors, accountants, actuaries and accademics who have had to extract the data they need using SQL from relational databases. I firmly believe that if you understand the objective or bigger picture of a language term, you will be a more effective user of…Continue readingSQL: Introduction to SELECT statement, analogy for beginners
Categories
Syntactically better SQL CREATE statements
Debugging ETL SQL scripts can be frustrating because of the syntax used to create database objects. In this post I share some tips to write syntactically and functionally better SQL scripts that are particularly useful when using SQL for ETL. All syntax written for Sybase IQ 15.4. Historically to avoid object already exists type errors…Continue readingSyntactically better SQL CREATE statements