top of page
Data Analysis

Game Analysis With SQL

This course gives a full introduction to SQL for data analysis and focuses specifically on SQL data analysis techniques used in mobile and computer video games.

4 Weeks
16 hrs Of Instruction

 

Next Course:     
August 2024

What You'll Learn

Game Analytics Database Setup: How to Install a local MySQL database server, setup tables and load course data. How to install an SQL client tool (DBEAVER) for querying and accessing the data. How to validate your database installation.   


Data Collection, Storage & Access: How is game event data captured and stored. Which cloud and storage technology is best suited to which type of game analysis.  Example data capture service and data load utility in action for a popular word game. 


SELECTing Data:  How to create tables with the CREATE TABLEs statement. How the SELECT statement works. How to use various result set filtering and limiting functions. How to use the database dictionary to understand database and table structures.


Functions & Operators:  SQL math and string functions. Comparative and logical operators. The fundamental functions and operators used for complex data analysis in gaming. 


Dates & Times: Data types and their differences. Conversion from one data type to another? How to manipulate time and dates with INTERVALs. Time difference functions, date addition and date subtraction. Common date and time conversion examples used in game analysis. 

 

The CASE Statement: How to use the CASE statement to transform and re-classify game data. How to PIVOT and rotate data for analysis and reporting. Several examples of CASE statement usage, common in mobile game analysis. 


Joining & Aggregating Data: Why is joining and aggregating data important. The GROUP BY statement. How to combine data from multiple tables efficiently. Use of different SQL join types. 


Common Game Metrics:  TOP 10 gaming metrics by category. The SQL coding required to generate each metric from raw data.   

Capstone Project: Capstone project requirements. Capstone project template and recommended approach. How to utilize assignments and course work for your capstone project. 


Success strategies

Game Analysis With SQL

This course gives a full introduction to SQL for data analysis and focuses specifically on SQL data analysis techniques used in mobile and computer video games.

4 Weeks
16 hrs Of Instruction

Next Course:

August 2024

This Course Includes

  • Office Hours With Instructor, Schedulable Instructor 1-On-1s

  • 16 Hours of Instruction Delivered Over 8 Lessons

  • Downloadable Lesson Slides, Downloadable SQL and Python code

  • Lesson Assignments, Lesson Quizzes, In-Class Exercises

  • Final Course Quiz, Capstone Project For Analytics Portfolio

  • Certificate Of Completion, Digital Certificate Credentials

Course Content

LESSON 01: Data Collection Storage & Access


  • Course Overview & Structure

  • How Is Game Data Collected & Accessed

  • Databases & Tables

  • MySQL Database Setup

  • DBeaver SQL Client Setup

  • Loading Data

  • Database Validation

  • Lesson Quiz & Assignment

LESSON 05: The CASE Statement


  • CASE Statement Overview

  • Classification

  • PIVOTIng Data

  • Examples In Gaming

  • In-Class Exercise

  • Lesson Quiz & Assignment

LESSON 02: SELECTing Data


  • CREATE Table Statement

  • The Select Statement

  • Filtering Data Part I

  • Filtering Data Part II

  • The Database Dictionary

  • Lesson Quiz & Assignment

LESSON 06: Joining & Aggregating Data


  • Why Join & Aggregate Data?

  • GROUP BY Statement

  • Efficient Aggregation

  • Joining Tables

  • Examples In Gaming

  • In-Class Exercise

  • Lesson Quiz & Assignment


LESSON 03: Functions & Operators


  • Logical Operators

  • Comparative Operators

  • Math Functions

  • String Functions

  • In-Class Exercise

  • Lesson Quiz & Assignment


LESSON 07: Common Game Metrics - Part I


  • Overview Of Top 10 Metrics

  • Acquisition

  • Engagement 

  • Capstone Project - Part I

  • In-Class Exercise

  • Lesson Quiz & Assignment

LESSON 04: Dates & Times


  • Not My Types

  • Dates & Times Overview

  • Manipulating Dates

  • Date & Time Conversion

  • Examples In Gaming

  • In-Class Exercise

  • Lesson Quiz & Assignment


LESSON 08: Common Game Metrics - Part II


  • Retention

  • Monetization

  • In-Class Exercise

  • Capstone Project - Part II

  • Final Course Quiz


Requirements

  • This course is a fundamental and introductory course in SQL and does not have any requirements for previous experience in relational databases, coding, or SQL. 

  • Learners will need to be able to install MySQL and DBEaver software and associated drivers on a Windows or Mac computer to be able to access the course data.

Description

This course gives an introduction to SQL for product analytics, with a specific focus on gaming analytics for mobile, PC and console games. This course will cover the basics of the SQL query language, including creating tables, selecting data, functions and operators and aggregating data through summarization and table joins. 


This course is intended for anyone who is not familiar with or has limited knowledge of SQL and would like to learn effective ways to use it in a client database server setup to understand game analysis techniques. 

In addition, this course will use approximately 2GB of simulated and real game data to illustrate how metrics used in gaming are created from raw data using the SQL language. 


This course features several assignments and quizzes to ensure that learners develop a full understanding of the course materials, are able to complete their capstone project and are eligible for a course completion certificate with distinction.


bottom of page