This course provides an introduction to databases and summarized the differences in the main database technologies. This course will also introduce you to Looker and how Looker scales as a modern data platform. In the lessons, you will build and maintain standard Looker data models and establish the foundation necessary to learn Looker's more advanced features.
Overview
Syllabus
- Introduction
- Course Overview
- Webinar Series - Pocket Guide to Databases
- Introduction to Databases
- Transactional Databases
- Analytical Databases
- The Future of Database Technology
- The Modern Data (BI) Platform
- Why Looker as a Data Platform
- The Modern Data Platform
- Moving Beyond BI with a Modern Data Platform
- Intro to Looker Platform
- Log in to Looker
- What is Looker? A Technical Demo
- What is LookML
- Looker Terminology and Overview
- Looker's Paradigm Shift
- How Looker Writes SQL
- Getting Started with Development and LookML
- Development Mode
- The Looker Integrated Development Environment
- Git Branching
- Quiz: Getting Started with Development
- Fundamentals of Writing LookML
- Add New Views
- Quiz: LookML Fundamentals
- Creating Dimensions and Measures in LookML
- String Dimensions
- Number Dimensions
- Timeframes
- Duration Dimensions
- Yesno Dimensions
- Tier Dimensions
- Geographic Dimensions
- Knowledge Check: Creating Dimensions Using LookML
- Counts and Counts Distinct
- Sums and Averages
- Enhancing the User Experience
- Additional Field Parameters
- Drill Fields and Sets
- Creating and Filtering Explores
- Introduction to Explores
- Symmetric Aggregates
- Filtering Explores
- Look ML Best Practices
- LookML Best Practices
- Achieving Fluency: Writing Effective LookML
- Technical Demo: Database to Dashboard
- Differences Between LookML Files
- Introduction
- Reference Material
- Quiz: LookML Object Relationships
- Objects and Files
- Quiz: Objects and Files
- Explores and Explores
- Models and Projects
- Quiz: Models and Projects
- (Optional) Built to Last: Scalable Model Development
- Conclusion
- Conclusion
- Conclusion
- Your Next Steps
- Course Badge