SQL Training Topics

• SQL
• Special commands
• select @@version
• Exercises
• How much stock do i have of each item?
• How much stock did i have as at some specific date? per item
• How old is my stock?
• what is the total cost of my items?
• what is the total cost of my items? by type
• What would my total sales be if i sold all my items?
• what would my profit be if i sold all my items?
• What is my profit margin?
• what is the average age of all of my stock?
• 
  
• Create Unposted InvTrx Table
• Combine Posted and Unposted inventory
• 
  
• How much stock do i have of each item?
• How old is my stock?
• How much stock did i have as at some specific date?
• what is the total cost of my items?
• what is the total cost of my items? by Type
• What would my total sales be if i sold all my items?
• what would my profit be if i sold all my items?
• What is my profit margin?
• 
  
• What % of total stock value is this item?