Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction to SAP HANA
- Overview of SAP HANA
- Key features and benefits
- Use cases and applications
- SAP HANA vs. 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 modeling capabilities
- Creating database artifacts
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 optimization
- Database management
- Query execution and analysis
- Backup and recovery operations
Data Modeling in SAP HANA
- Introduction to Data Modeling
- 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 modeling
- 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 authorization
- Data encryption and protection
- Encryption methods
- Data masking and anonymization
Performance Tuning and Optimization
- Performance monitoring
- Key performance indicators (KPIs)
- Monitoring tools and techniques
- Performance tuning strategies
- Indexing and partitioning
- Query optimization
- Memory and resource management
- Best practices for performance optimization
- Regular maintenance tasks
- Analyzing and resolving performance bottlenecks
Summary and Next Steps
Requirements
- Basic understanding of databases
- Basic knowledge of IT infrastructure and enterprise applications
Audience
- Database administrators
- IT professionals
14 Hours
Delivery Options
Private Group Training
Our identity is rooted in delivering exactly what our clients need.
- Pre-course call with your trainer
- Customisation of the learning experience to achieve your goals -
- Bespoke outlines
- Practical hands-on exercises containing data / scenarios recognisable to the learners
- Training scheduled on a date of your choice
- Delivered online, onsite/classroom or hybrid by experts sharing real world experience
Private Group Prices RRP from €4560 online delivery, based on a group of 2 delegates, €1440 per additional delegate (excludes any certification / exam costs). We recommend a maximum group size of 12 for most learning events.
Contact us for an exact quote and to hear our latest promotions
Public Training
Please see our public courses
