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-03-22-30-00 Mar 22, 2021 9:30 AM CET English
2021-03-22-00-00 Mar 22, 2021 3:00 PM CDT English
2021-03-29-00-00 Mar 29, 2021 8:00 AM AEST English
2021-03-29-00-00 Mar 29, 2021 9:00 AM CET French
2021-04-06-00-00 Apr 06, 2021 3:00 PM CDT English
2021-05-10-00-00 May 10, 2021 3:00 PM CDT English
2021-05-31-00-00 May 31, 2021 10:00 AM CET English
2021-04-26-00-00 Apr 26, 2021 10:00 AM ART English

More course sessions coming soon...