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.Â
This Course Includes
1.5-hour Live Webinar With Instructor
A Downloadable Slide Presentation
Questions & Answers In Live Webinar Session
Course Content
1. Introduction
| 6. Joining Tables
|
2. How Data Is Collected & Accessed
| 7. Common Game Metrics
|
3. Databases & Tables
| 8. Capstone Project:Â
|
4. The SELECT statement
| 9. Professional Development
|
5. Functions & Operators
| 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.