SQL preparation

  1. Queries
  2. Stored procedure
  3. Data modeling
  4. Creating objects
  5. Indexes
  6. Views
  7. Primary and foreign keys
  8. Constraints
  9. Trigger
  10. Reviewing execution plans for optimization
  11. Data flow diagram
  12. ETL for collecting in multiple formats
  13. Report writing