SQL For Non Technical
Tough job for a functional or business analyst is to understand the nuance of Database.
It is not that much complex which is generally thought, i came across about this from most of my colleagues and fellow students on this.
Following is my approach for this.
- Get clarity on the capabilities of Database – Architecture, Types of Databases, Versions, Providers
- Get information on Database Objects like : Tables, View, Synonyms, Triggers, Indexes, Materialized Views
- Understand about Schema in DB
- Start with writing your simple select query , based on your area of functional expertise.
- For Ex: If you are from Finance – Start with finding the tables of Journals
- For Ex: If you are from Procurement : Start with find the tables of Suppliers, Purchase Orders
- Don’t worry about the complex joins , which you generally see in the SQL Queries, it all goes well and it is not complex
- In SQL – try to get clarity on : SELECT, FROM WHERE, GROUP , HAVING ORDER – Make sure you understand when to use what and how the result vary based on this
- I will post a video on this and update the link at the earliest, Please provide your inputs…if you have any other thoughts.
Comments |0|
Category: Database