Unity + SQL Databases Player Management Leaderboards + More!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction and About this Course

Lecture 2: Meet Your Instructor / My Teaching Methodolgy

Lecture 3: Is this Course Right for You? More Course Details

Lecture 4: Course Overview, Sections and 'Flow' of each section.

Lecture 5: Quick Note About Video Speed

Chapter 2: SQL Database Basics

Lecture 1: Overview of SQL

Lecture 2: Installing MAMP

Lecture 3: phpMyAdmin Overview/ Database and Table Set Up

Lecture 4: Changing Table Structure If Needed

Lecture 5: Inserting Information Into Our Table

Lecture 6: Reading/Selecting Information from Our Table

Lecture 7: Updating Information In Our Table

Lecture 8: Deleting Information From Our Table

Chapter 3: PHP Scripting Basics

Lecture 1: Overview of PHP + Visual Studio Code Installation

Lecture 2: Echo Statements and Variables with PHP

Lecture 3: If Statements with PHP

Lecture 4: Getting Info Back From Our Database with PHP

Chapter 4: Unity Web Requests / Unity Networking Basics

Lecture 1: Basic Unity Networking Get Requests

Lecture 2: Basic Unity Post Requests

Chapter 5: Unity CRUDs / User Management

Lecture 1: Basic Project set up + Create User Part 1 (UI Element Set Up)

Lecture 2: Create User Part 2 (Front End Scripting Work)

Lecture 3: Create User Part 3 (Networking Requests)

Lecture 4: Create user Part 4 (Server Side Scripting)

Lecture 5: Create Player Part 5 (Server Error Handling)

Lecture 6: Create Player Part 6(Basic Sanitization and Filtering of User Input)

Lecture 7: Create Player Part 7 (App Security with Connecting To Our Server (App Password))

Lecture 8: Create Player Part 8 (Hashing User Passwords)

Lecture 9: Login Player Part 1 (UI Set Up)

Lecture 10: Login Player Part 2 (UI Scripting)

Lecture 11: Login Player Part 3 (Player Prefab + Current Player Script)

Lecture 12: Login Player Part 4 (Network Requests Set Up)

Lecture 13: Login Player Part 5 (Server Script)

Lecture 14: Login Player Part 6 (Handling Server Response Codes)

Lecture 15: Login Player Part 7 (Assigning Player Info in Scene)

Lecture 16: Login Player Part 8 (Signing Out Player)

Lecture 17: Assigning Player Info In Scene

Lecture 18: Updating Player Score Part 1 (Front End Scripting)

Lecture 19: Updating Player Score Part 2 (Server Scripting)

Lecture 20: Update Player Result Error Talk

Chapter 6: Unity Leaderboard

Lecture 1: Leaderboard UI Set Up Part 1

Lecture 2: Leaderboard UI Set Up Explanation

Lecture 3: Leaderboard UI Set Up Part 2 (Prefab Set Up)

Lecture 4: Leaderboard Front End Scripting

Lecture 5: Leaderboard Server Scripting

Lecture 6: SimpleJSON Script

Lecture 7: Using Simple JSON

Lecture 8: Sorting Players By High Score

Lecture 9: Giving Players Rankings In Our Leaderboards

Lecture 10: Search Function Part 1

Lecture 11: Search Function Part 2

Lecture 12: Search Function Part 3

Lecture 13: Search Function Part 4

Lecture 14: Testing our App!

Chapter 7: Cloud Deployment ** BONUS **

Lecture 1: Intro to Cloud Deployment

Lecture 2: Launching EC2 Server

Lecture 3: Configuring our Server with a LAMP stack + phpMyAdmin

Lecture 4: Setting Up Our Table in Database

Lecture 5: File Transfer to Server with WinSCP

Lecture 6: Script Fixing for server.

Lecture 7: Setting Up SSL with our Cloud Server

Lecture 8: Fixing Unity Scripts to send information to our cloud server

Lecture 9: Final Testing For our App and Cloud Database/Server!

Chapter 8: Conclusion + Bonus!

Lecture 1: Project ZIP For Reference

Lecture 2: Conclusion + Where to go from here

Lecture 3: Thank you!