📘 S/4HANA & HANA Database Administration Training Curriculum

Duration: 12 Weeks | Total Sessions: 34 | Frequency: 3 Sessions per Week (last week 4 sessions)

Week 1: Foundations (3 Sessions)

1️⃣ Introduction to SAP S/4HANA – Architecture & Deployment Options
2️⃣ SAP HANA Overview – In-Memory, Row vs Column Store, Persistence
3️⃣ Sizing for S/4HANA & HANA – Quick Sizer, T-Shirt Sizing, Best Practices

Week 2: HANA Installation & Configuration (3 Sessions)

4️⃣ HANA Installation – Prerequisites & Steps (Linux-based)
5️⃣ SAP HANA Cockpit Installation & Configuration
6️⃣ SAP HANA Post-Installation Activities (License, Parameters, Secure Setup)

Week 3: HANA Database Administration Basics (3 Sessions)

7️⃣ User & Role Management in HANA
8️⃣ HANA Memory Management & Workload Concepts
9️⃣ Backup & Recovery Fundamentals (Complete, Delta, Log Backups)

Week 4: Advanced HANA Operations (3 Sessions)

🔟 Backup Strategy & Scheduling (Automation & Retention Policies)
1️⃣1️⃣ Table Partitioning & Delta Merge in HANA
1️⃣2️⃣ HANA Performance Monitoring – SQL Analyzer, Expensive Statements, Traces

Week 5: S/4HANA Administration Basics (3 Sessions)

1️⃣3️⃣ Instance Start/Stop in Linux (sapcontrol, sidadm)
1️⃣4️⃣ S/4HANA Client Administration – New Client Copy Tools (SCCLN, SCC9)
1️⃣5️⃣ User Administration & Authorizations in S/4HANA

Week 6: Transport & Change Management (3 Sessions)

1️⃣6️⃣ Transport Management System (TMS) Setup & Configuration
1️⃣7️⃣ Transport Execution & Monitoring
1️⃣8️⃣ Transport Administration & Troubleshooting

Week 7: Workload & Job Administration (3 Sessions)

1️⃣9️⃣ Workload Administration – Monitoring Transactions (ST03N, ST06)
2️⃣0️⃣ Background Job Administration – Scheduling, Monitoring, Troubleshooting
2️⃣1️⃣ Spool & Update Administration

Week 8: System Refresh & Upgrade (3 Sessions)

2️⃣2️⃣ S/4HANA System Refresh – Steps & Best Practices
2️⃣3️⃣ S/4HANA Upgrade using SUM (Software Update Manager)
2️⃣4️⃣ Post-Upgrade Checks & Troubleshooting

Week 9: High Availability & Security (3 Sessions)

2️⃣5️⃣ SAP HANA High Availability – Host Auto-Failover, Standby Nodes
2️⃣6️⃣ Enqueue Replication Server (ERS) for S/4HANA HA
2️⃣7️⃣ Security – Roles, Authorizations, SSL, Secure Network Communication (SNC)

Week 10: Fiori Administration (3 Sessions)

2️⃣8️⃣ SAP Fiori Activation – Task Lists & Deployment Options
2️⃣9️⃣ Fiori Post-Activation Steps – Catalogs, Groups, Authorizations
3️⃣0️⃣ Fiori Troubleshooting & Monitoring

Week 11: Troubleshooting & Daily Operations (3 Sessions)

3️⃣1️⃣ System Monitoring – Logs, Traces, Dumps, Alerts
3️⃣2️⃣ Troubleshooting Common Issues (Lock Entries, Update Errors, Queues)
3️⃣3️⃣ Performance Tuning – Memory, Buffer, ICM, and DB Optimizations

Week 12: Project & Interview Preparation (4 Sessions)

3️⃣4️⃣ Real-World Project Simulation (System Refresh + Transport + Fiori Setup)

• Backup & Recovery Drill in HANA

• Performance Troubleshooting Case Study

• Interview-Specific Questions & Answers (SAP Basis + HANA + S/4HANA Admin)

✅ By the End of Training, Learners Will:

• Install, configure, and administer S/4HANA & HANA DB.

• Manage memory, workload, jobs, transports, client copy, and upgrades.

• Perform system refresh, HA/ERS setup, backup strategy & performance tuning.

• Activate & troubleshoot Fiori apps.

• Be interview-ready with real-world troubleshooting scenarios & Q&A.