I have a cousin who was a skilled, talented artist in high school. Whenever he was painting a portrait, he would be playing his favorite rock band and be singing and dancing along … all at the same time!
One thing led to another, and his “artistic skills flourished into an entrepreneurial side business” and he started selling his portraits to supermarket chains!
Then it was time for college and his parents insisted on him choosing a career like “building engineering” that promised a stable income with lots of growth potentials vs. that of an entrepreneurial artist.
While a fair amount of the work that goes into creating, maintaining or optimizing databases is hidden from decision makers, the work that goes into creating reports is immediately visible to management and so, must be given a good deal of attention.
This post is written as a guide for creating SQL based reports. It helps ensure that high quality, valid, reliable reports are created by report writers.
After reading this post, you would have a formal process for creating SQL reports and a step by step guide for reporting on data contained in AS400, Oracle, SQL Server, Microsoft Access or some other database platform.
You always want to make sure that the training programs your attend match your career interests and aspirations, right? … so pay close attention to what I am about to say next.
Effectiveness of Traditional Class Room Training
Late last year I was mentoring, coaching and training a software development team. One of the members of the team had paid more than $6,000 (Six Thousand USD) for a class-room based training & certification program.
To fund the training which required an upfront, full payment, he raided his savings account and took on additional debt.
The database developer job, data analyst job or report writer job are related job roles that may be performed by the same person depending on how the size of the organization.
In most organizations, the business analyst or software developer starts out performing all three types of jobs. As demand multiplies and the individual begins to feel overwhelmed, the jobs are split … and as time goes … into the three (3) different type of jobs.
For this reason, anyone performing the duties of a business analyst, software developer, database analyst, report writer or database developer needs to have a strong understanding of each of these job responsibilities as well as the areas of overlap.