<?xml version="1.0" encoding="utf-8" ?>
<!DOCTYPE FL_Course SYSTEM "https://www.flane.de/dtd/fl_course095.dtd"><?xml-stylesheet type="text/xsl" href="https://portal.flane.ch/css/xml-course.xsl"?><course productid="33335" language="en" source="https://portal.flane.ch/swisscom/en/xml-course/google-lddd" lastchanged="2025-09-30T15:50:35+02:00" parent="https://portal.flane.ch/swisscom/en/xml-courses"><title>Looker Developer Deep Dive</title><productcode>LDDD</productcode><vendorcode>GO</vendorcode><vendorname>Google</vendorname><fullproductcode>GO-LDDD</fullproductcode><version>1.0</version><objective>&lt;ul&gt;
&lt;li&gt;Customize and incrementally refresh SQL and native derived tables&lt;/li&gt;&lt;li&gt;Incorporate Liquid for dynamic SQL, formatting, templated filters, and parameters in Looker&lt;/li&gt;&lt;li&gt;Use extends and refinements in Looker to modularize and organize your LookML&lt;/li&gt;&lt;li&gt;Troubleshoot LookML code and improve performance&lt;/li&gt;&lt;li&gt;Apply Looker best practices to your LookML projects&lt;/li&gt;&lt;li&gt;Manage Looker deployments using DevOps practices&lt;/li&gt;&lt;li&gt;Embed Looker content into web applications&lt;/li&gt;&lt;/ul&gt;</objective><essentials>&lt;p&gt;Completion of the &amp;ldquo;Developing Data Models with LookML&amp;rdquo; course or the equivalent experience in using LookML for development in Looker.&lt;/p&gt;</essentials><audience>&lt;p&gt;Looker Developers who want to learn how to get the most out of LookML, leveraging features like Liquid, aggregate tables, modular LookML files, Looker DevOps, and embedding their Looker content.&lt;/p&gt;</audience><outline>&lt;h4&gt;Module 1 - Looker Admin and LookML Fundamentals&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Looker Review&lt;/li&gt;&lt;li&gt;Roles and User Attributes&lt;/li&gt;&lt;li&gt;Connecting to a Database&lt;/li&gt;&lt;li&gt;LookML Review&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 2 - Diving Deeper into Derived Tables&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Understanding Derived Tables&lt;/li&gt;&lt;li&gt;Adding Persistence&lt;/li&gt;&lt;li&gt;Refreshing Incrementally&lt;/li&gt;&lt;li&gt;PDTs and Performance&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 3 - Creating Dynamic LookML with Liquid&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Core Liquid Concepts and Syntax&lt;/li&gt;&lt;li&gt;Custom Links, Drills, and Formatting&lt;/li&gt;&lt;li&gt;Templated Filters, Parameters and Dynamic SQL&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 4 - Creating Modular LookML&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Extensions&lt;/li&gt;&lt;li&gt;Refinements&lt;/li&gt;&lt;li&gt;Manifests and Localization&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 5 - Testing, Debugging and DevOps&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Leverage your IDE&lt;/li&gt;&lt;li&gt;Debugging and Common Errors&lt;/li&gt;&lt;li&gt;Data Tests&lt;/li&gt;&lt;li&gt;Looker and DevOps&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 6 - Looker Best Practices&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Looker Best Practices&lt;/li&gt;&lt;li&gt;Improving Performance&lt;/li&gt;&lt;/ul&gt;&lt;h4&gt;Module 7 - Embedded Looker Analytics&lt;/h4&gt;&lt;ul&gt;
&lt;li&gt;Explore Embedded Looker Options&lt;/li&gt;&lt;li&gt;Using Private and SSO Embedding&lt;/li&gt;&lt;/ul&gt;</outline><objective_plain>- Customize and incrementally refresh SQL and native derived tables
- Incorporate Liquid for dynamic SQL, formatting, templated filters, and parameters in Looker
- Use extends and refinements in Looker to modularize and organize your LookML
- Troubleshoot LookML code and improve performance
- Apply Looker best practices to your LookML projects
- Manage Looker deployments using DevOps practices
- Embed Looker content into web applications</objective_plain><essentials_plain>Completion of the “Developing Data Models with LookML” course or the equivalent experience in using LookML for development in Looker.</essentials_plain><audience_plain>Looker Developers who want to learn how to get the most out of LookML, leveraging features like Liquid, aggregate tables, modular LookML files, Looker DevOps, and embedding their Looker content.</audience_plain><outline_plain>Module 1 - Looker Admin and LookML Fundamentals


- Looker Review
- Roles and User Attributes
- Connecting to a Database
- LookML Review
Module 2 - Diving Deeper into Derived Tables


- Understanding Derived Tables
- Adding Persistence
- Refreshing Incrementally
- PDTs and Performance
Module 3 - Creating Dynamic LookML with Liquid


- Core Liquid Concepts and Syntax
- Custom Links, Drills, and Formatting
- Templated Filters, Parameters and Dynamic SQL
Module 4 - Creating Modular LookML


- Extensions
- Refinements
- Manifests and Localization
Module 5 - Testing, Debugging and DevOps


- Leverage your IDE
- Debugging and Common Errors
- Data Tests
- Looker and DevOps
Module 6 - Looker Best Practices


- Looker Best Practices
- Improving Performance
Module 7 - Embedded Looker Analytics


- Explore Embedded Looker Options
- Using Private and SSO Embedding</outline_plain><duration unit="d" days="2">2 days</duration><pricelist><price country="US" currency="USD">1495.00</price><price country="IT" currency="EUR">1300.00</price><price country="GB" currency="EUR">1300.00</price><price country="DE" currency="EUR">1300.00</price><price country="CH" currency="CHF">1700.00</price><price country="AT" currency="EUR">1300.00</price><price country="SE" currency="EUR">1300.00</price><price country="FR" currency="EUR">1550.00</price></pricelist><miles/></course>