SAP HANA Introduction Training Course

Introduction to SAP HANA

• Overview of SAP HANA
• Key features and benefits
• Use cases and applications
• SAP HANA versus traditional databases
• In-memory computing
• Real-time processing
• Comparison with other database systems

SAP HANA Architecture

• Overview of the architecture and key components
• SAP HANA deployment options
• On-premise
• Cloud (SAP HANA Cloud)
• Hybrid deployments
• SAP HANA sizing and scalability
• Hardware requirements
• Scale-up and scale-out strategies

SAP HANA Development Tools

• Overview of development tools
• Installation and setup
• Navigating the interface
• Basic functionalities and features
• SAP Web IDE for SAP HANA
• Introduction and setup
• Development and modelling capabilities
• Creating database artefacts

SAP HANA Administration Tools

• Overview of Administration Tools
• SAP HANA Cockpit
• SAP HANA Database Explorer
• SAP HANA Studio (Administration perspective)
• SAP HANA Cockpit
• Installation and setup
• System monitoring and administration
• Performance analysis and optimisation
• Database management
• Query execution and analysis
• Backup and recovery operations

Data Modelling in SAP HANA

• Introduction to Data Modelling
• Concept and importance
• Types of data models in SAP HANA
• Creating models in SAP HANA
• Attribute views
• Analytic views
• Calculation views
• Best practices for data modelling
• Performance considerations
• Naming conventions and documentation

Data Provisioning in SAP HANA

• Introduction to data provisioning
• Overview of data provisioning methods
• ETL (Extract, Transform, Load) processes
• Data provisioning tools
• SAP HANA Smart Data Integration (SDI)
• SAP HANA Smart Data Access (SDA)
• SAP Data Services
• Configuring data provisioning
• Setting up connections
• Data integration and transformation

SAP HANA Security and User Management

• Security overview
• Importance of security in SAP HANA
• Security features and capabilities
• User and role management
• Creating and managing users
• Defining roles and privileges
• Authentication and authorisation
• Data encryption and protection
• Encryption methods
• Data masking and anonymisation

Performance Tuning and Optimisation

• Performance monitoring
• Key performance indicators (KPIs)
• Monitoring tools and techniques
• Performance tuning strategies
• Indexing and partitioning
• Query optimisation
• Memory and resource management
• Best practices for performance optimisation
• Regular maintenance tasks
• Analysing and resolving performance bottlenecks

Summary and Next Steps