Loading...

DW664G – IBM Big SQL for Administrators (v5.0)

Home / DW664G – IBM Big SQL for Administrators (v5.0)

This course is designed to introduce the student to some of the additional capabilities and the administration of IBM Big SQL. IBM Big SQL allows you to access your HDFS data by providing a logical view to it. You can use the same SQL that was developed for your data warehouse data on your HDFS data. This course covers Big SQL security using row and column access controls, impersonation, and data federation. The course also covers some of the best practices, performance tuning, and monitoring techniques, YARN integration and also includes an optional unit to explore a Big SQL installation.

Course Outline:

Course Outline:

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

Course Audience & Prerequisites:

Audience:

- Administrators, Developers

Prerequisites:

- Basic Linux knowledge
- Basic SQL knowledge
- Working knowledge with big data and Hadoop technologies

Course Offerings:

Instructor Led In Classroom

Newcomp can directly deliver  IBM Business Analytics courses for Business Intelligence, Performance Management, and IBM Advanced Analytics through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.

Self Paced

Students can receive the same high-quality training, with the same courseware at their own speed and schedule with SPVC.  Individuals with busy schedules can complete a course over a 30-day timeframe at a lower price than in-class or ILO courses. Please note that there is no live interaction with an instructor in this format.

  • Course Outline
  • Course Audience & Prerequisites
  • Course Offerings
  • Related Courses

Course Outline:

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

Audience:

- Administrators, Developers

Prerequisites:

- Basic Linux knowledge
- Basic SQL knowledge
- Working knowledge with big data and Hadoop technologies

Instructor Led In Classroom

Newcomp can directly deliver  IBM Business Analytics courses for Business Intelligence, Performance Management, and IBM Advanced Analytics through the use of in-class training facilities.

Currently,  in-class courses are offered in Markham, Ottawa, Vancouver, Halifax, and Edmonton. Please note that classes can be added to new areas based on demand.

Instructor Led Online

Students receive the same quality as an in-class course, with a live instructor and the ability to participate in hands-on labs through real-life examples

ILOs help cut costs by reducing time and travel as they can be taken from home or the office and require only the use of a computer, high-speed wired internet and a headset.

Self Paced

Students can receive the same high-quality training, with the same courseware at their own speed and schedule with SPVC.  Individuals with busy schedules can complete a course over a 30-day timeframe at a lower price than in-class or ILO courses. Please note that there is no live interaction with an instructor in this format.