Are you referring to learning the Agile database schema (like how BOMs work or the History tab works)?  This will require DB connection and basic SQL.  
Or are you referring to learning database maintenance, installation, backup, etc.?   For this, you can find Agile 9.3 documentation on Database Installation and Upgrade, among other information on the Oracle Knowledge Zone website.

I’m referring to Agile DB schema ,I know little about SQL .

Thanks a lot Matt for your detailed structure of learning procedure ,I will start with this today.

Thanks,
Surya

Hi Surya,

As Matt mentioned, you need to get accustomed to basic Oracle SQL to start with. Also wouldn’t recommend any Insert/Delete  statements, start with Select and then gradually to Update. 

Secondly if you have toad installed then connect to Agile-schema and load your schema browser. In Table column you can see some important tables such as Item, BOM, Manu_Parts,Page_Two,Page_Three etc.  You can see the view tab for basic pre-loaded views such as item_p2 or item_p2p3.

Also the other thing you need to understand how you fetch values for different data-types as it’s different for list/multi-list and fetching them from flex table is also bit complex. 

One thing i can recommend from my personal experience is start with simple queries to display an Item and It’s P2,P3 values and then proceed with others. 

Regards,
Arif

I’ll also add that everything in Agile is serialized by an ID number – therefore, you’ll have to teach yourself how to join tables so that way you can get something like the CHANGE_NUMBER field from the CHANGES table even though a different table you were wanting to work with, like the SIGNOFF table doesn’t have your ECO number itself but rather its serialized ID.

You can cross reference and find the objects serialized ID number via the navigator like so.  Notice in the bottom right circled blocks – the number 6000 is for Change Orders while the 7130770 is the serial number ID for the CN46530 that I’m highlighting.  

//this query gets you the column names and data type for every row field of a particular table.  Taking out the where statement should get you every table but you’ll need to add the table name column.  
“select column_name, data_type from user_tab_cols WHERE table_name = ‘ITEM_P2P3_QUERY'”);

Thanks Arif and Matt for your help.
Three years back when I was starting SDK Arif helped me to get started,now I am a Agile developer,this will surely help many beginners to set ball rolling.