top of page
Data Analysis

Course Overview: Game Analysis With SQL

This webinar gives an overview of the Game Analysis With SQL courses and is useful if you are considering taking an SQL course and want to learn more about what is covered.

Single Session
1 hr Seminar

 

Next Course:     
​
Every Two Weeks

What You'll Learn

How Data Is Collected & Accessed: How is game event data captured and stored. Which cloud and storage technology is best suited to which type of game analysis.


Databases & Tables: What are databases. What are tables. How is data structured when it's stored in a database. 


The SELECT statement: The syntax and structure of a SELECT statement. How the SELECT statement is used to access data through client tools. What are the different types of SQL language. 


Functions & Operators: What are the main functions and operators in SQL. Which functions and operators are common in game data analysis. 


Joining Tables: Different ways we can join data using SQL. What are indexes. How we use indexes to improve SQL join performance and efficiency. 


Common Game Metrics: Common game metrics and where they are used with respect to acquisition, engagement, retention and monetization. 


Capstone Project: What is a capstone project. Why a capstone project is a key part of Extent Insights’ learning path. How a capstone project can help you build a game analytics portfolio.


Career Development: Skills a game analyst needs. Game analyst learning path at Extent Insights. How professional development can help you in your career. 

Success strategies

Course Overview: Game Analysis With SQL

This webinar gives an overview of the Game Analysis With SQL courses and is useful if you are considering taking an SQL course and want to learn more about what is covered.

Single Session
1 hr Seminar

Next Course:

Every Two Weeks

This Course Includes

  • 1.5-hour Live Webinar With Instructor

  • A Downloadable Slide Presentation

  • Questions & Answers In Live Webinar Session

Course Content

1. Introduction

  • About Your Instructor

  • Instructor Experience

  • Extent Insights Introduction

  • Overview Of Webinar

  • Why Is SQL So Important?


6. Joining Tables

  • Why Do We Need To Join Data?

  • Types Of Joins

  • Indexes (Indices)

2. How Data Is Collected & Accessed

  • What Is Telemetry?

  • What Is A Data Lake?

  • Which Data Is Best For Analysis?

  • Why Use SQL For Game Analytics?

7. Common Game Metrics

  • Common Game Metrics

  • SQL For Engagement & Retention

  • SQL For Monetization

  • Using SQL To Combine Metrics

3. Databases & Tables

  • What Is A Database?

  • What Is A Table?

  • An Overview Of Different Data Types


8. Capstone Project: 

  • What Is A Capstone Project?

  • Building An Analytics Portfolio


4. The SELECT statement

  • What Is SQL?

  • Using SQL To Access Data

  • What Does This Look LIke In Practice?

  • What Are The Different Types Of SQL?

  • The SELECT Statement Syntax

  • How To Query Tables & Columns

9. Professional Development

  • Game Analytics Learning Path

  • Extent Insights Course Structure

  • Modular Learning

  • Every Class Earns A Digital Certificate


5. Functions & Operators

  • What Are Functions?

  • What Are Operators?

  • String Functions

  • Aggregate Functions

10. Questions & Answers


Requirements

  • This informational webinar is designed to help you understand the structure and content of the Game Analytics SQL course. 

  • No prior experience with gaming, SQL or data analysis is required for this webinar.

Description

This informational webinar gives an overview of the game analysis with SQL courses offered by Extent Insights. You’ll learn about game data (telemetry), how it’s collected and how recent database technologies allow vast data storage for easy and efficient access and analysis. 


In addition, you’ll learn about some components of the SQL language used in data analysis, such as the SELECT statement, functions and operators and how tables are structured and joined. 


Finally, you’ll learn more about how Extent Insights builds capstone projects into each SQL course so learners can build out their own game analytics portfolio and increase their chances of establishing successful careers in game analytics. 


The last part of this webinar will be a questions and answers session for anything related to the gaming industry, game analytics, or both, which will give you a related discussion with the instructor and other webinar attendees.


bottom of page