1. Performance capacity report 2. Lock /block and long running session 3. SQL – Joins, Union 4. Unix commands – shell scripting 5. Redshift security features – IAM ,VPC etc 6. Vaccum , analyze for better query performance 7. Data Share 8. Query Planning (EXPLAIN Plan) 9. Roles and User management 10. Concurrency scaling 11. Indexing 12. DRR – Disatster recovery planning 13. Serverless Amazon