Description
At Sixe Engineering we have been providing official IBM training around the world for over 12 years. Get the best training from our specialists in Europe. We have important discounts and offers for two or more students.
Course details
| IBM course code: DW664G | Category: IBM BigInsights / BigInsights SQL |
| Delivery: Online & on-site** | Course length in days: 0.8 |
Target audience
• Administrators, Developers
Desired Prerequisites:
• Basic Linux knowledge
• Basic SQL knowledge
• Working knowledge with big data and Hadoop technologies
Instructors
The great majority of the IBM courses we offer are taught directly by our engineers. This is the only way we can guarantee the highest quality. We complement all the training with our own materials and laboratories, based on our experience during the deployments, migrations and courses that we have carried out during all these years.
Added value
Our courses are deeply role oriented. To give an example, the needs for technology mastery are different for developer teams and for the people in charge of deploying and managing the underlying infrastructure. The level of previous experience is also important and we take it very seriously. That is why beyond (boring) commands and tasks, we focus on solving the problems that arise in the day to day of each team. Providing them with the knowledge, competencies and skills required for each project. In addition, our documentation is based on the latest version of each product.
Agenda and course syllabus
1: Managing the Big SQL Server
• Configure the Big SQL Server
• Configure the Big SQL Scheduler
• List the registries for compiler and runtime performance improvement
• Backup and restore Big SQL
2: Configuring Big SQL security
• Configure authentication for Big SQL
• Manage security with Apache Ranger
• Enable SSL encryption
• Configure authorization of Big SQL objects
• Configure impersonation with Big SQL
3: Data federation with Big SQL
• Configure wrappers, servers, user mappings and nicknames for data federation
4: Using statistical data to improve Big SQL performance
• Understand the Big SQL data access plan
• Use Big SQL statistics to improve query performance
5: Monitoring Big SQL
• Use the Big SQL query interface
• Monitor the performance of read and write access
6: Big SQL and YARN integration
• Configure Big SQL and YARN integration through Apache Slider
7: Troubleshooting Big SQL
• Troubleshoot common problems and understand the known resolutions
Exploring Big SQL installation (Optional)
• Explore Big SQL installation
Do you need to adapt this syllabus to your needs? Are you interested in other courses? Ask us without obligation.
Locations for on-site delivery
- Austria: Vienna
- Belgium: Brussels, Ghent
- Denmark: Cophenhagen
- Estonia: Tallinn
- Finland: Helsinki
- France: Paris, Marseille, Lyon
- Germany: Berlin, Munich, Cologne, Hamburg
- Greece: Athens, Thessaloniki
- Italy: Rome
- Louxemburg: Louxembourg (city)
- Netherlands: Amsterdam
- Norway: Oslo
- Portugal: Lisbon, Braga, Porto, Coimbra
- Slovakia: Bratislava
- Slovenia: Bratislava
- Spain: Madrid, Sevilla, Valencia, Barcelona, Bilbao, Málaga
- Sweden: Stockholm
- Turkey: Ankara
- United Kingdom: London
