2021.911 MicroStrategy Engines and SQL

  • Duration: 16 hours
  • Education Passes: Architect Pass

Understand how the MicroStrategy Engine develops Structured Query Language (SQL) to gather data in a variety of reporting scenarios. Learn methods for tuning and optimizing report performance using Very Large Database (VLDB) properties.

Products Covered

  • MicroStrategy Developer

Skills Gained

  • SQL analysis
  • SQL optimization techniques
  • Creating complex queries with SQL, using subqueries and intermediate tables
  • Understanding SQL behavior based on different objects on a report
  • Managing the report execution process in a BI environment

Topics Covered

  • Introduction to MicroStrategy engine
  • Basic optimizations
  • Templates
  • Metrics
  • Filters
  • Analytical Engine
  • Introduction to VLDB properties

Select a Class and Register

Course Type Date/Time Language
0000-00-00-00-01 On-demand Multi-language
2021-07-22-00-00 Jul 22, 2021 9:00 AM CET English
2021-10-25-00-00 Oct 25, 2021 9:00 AM CET English
2021-06-14-00-00 Jun 14, 2021 2:00 PM CDT English
2021-07-22-00-00 Jul 22, 2021 1:00 PM EDT English
2021-08-10-00-00 Aug 10, 2021 2:00 PM CDT English
2021-08-31-00-00 Aug 31, 2021 2:00 PM CDT English
2021-09-30-00-00 Sep 30, 2021 2:00 PM CDT English
2021-11-04-00-00 Nov 04, 2021 2:00 PM CDT English
2021-12-09-00-00 Dec 09, 2021 9:00 AM CST English
2021-08-26-00-00 Aug 26, 2021 9:00 AM ART Spanish

More course sessions coming soon...