Premium Only Content

Unreal & SQL Databases - Part 4 - Relational DB Primer
Getting down to the basics of setting up a new SQLite database, creating some tables, making relationships, and querying for data.
Chat about gamedev on Discord:
https://discord.gg/jjy2aJ3hj9
Links to websites:
SQLite Docs: https://www.sqlite.org/docs.html
SQLite Tutorial .net: https://www.sqlitetutorial.net/
Links to software:
DBBrowser: https://sqlitebrowser.org/
Jetbrains Rider: https://www.jetbrains.com/rider/
DBSchema: https://dbschema.com/
SQLite shell (part of the standard SQLite downloads): https://www.sqlite.org/download.html
Chapters
0:00 Introduction
0:29 Relational Databases - Your Way
1:06 Creating a SQLite Database
1:35 Naming the Project
2:01 Making a New DB file
2:21 Introducing TABLES
3:03 Making the 'Background' Table
4:03 Primary Keys (PK)
4:48 SQLite INT PK = Autonumber
5:37 Making the 'CharacterClass' Table
6:33 Relating 'CharacterClass' to 'Background'
8:45 Making the 'WeaponType' Table
9:15 One To Many Relationships
9:53 Many To Many Relationships
11:01 Relating 'WeaponType' and 'CharacterClass'
12:14 A Note About Naming Tables
13:34 SELECT Query 1
14:45 SELECT Query 2
16:46 Helpful Websites
17:12 Recap
18:53 SELECT Query 3
19:41 Relationships & Queries
20:39 Query JOINS
21:51 Dont Get Overwhelmed
22:32 What Would Be Useful to YOU?
22:57 Next Time...
-
LIVE
Times Now World
2 days agoWorld News LIVE | Maduro Dares Trump, Says China Is Now World’s Top Power Not US
175 watching -
1:39:58
Gary Cardone
2 hours ago $0.45 earnedLIVE With Gary Cardone
1.19K -
LIVE
Major League Fishing
3 days agoLIVE Tackle Warehouse Invitationals Championship, Day 3
179 watching -
2:15:06
Game On!
19 hours ago $20.32 earnedNFL Week 1 Wise Guy Round Table BEST BETS!
113K2 -
4:08:14
EXPBLESS
4 hours agoNew Game + On Elden Ring 🔥JOIN UP
8.17K -
12:11
Nikko Ortiz
1 day agoCrashout 6 Rumble
61K8 -
LIVE
Midnight In The Mountains
6 hours agoGaming w/ PER·SE·VER·ANCE | Sunday Funday Split Screen Gameplay BL3
111 watching -
24:39
GritsGG
20 hours agoINSANE Ranked Game on Warzone!
42.9K3 -
LIVE
MrR4ger
1 day agoTHE HELL IS THIS? - HELL IS US / PSYOP SUNDAY LETS WORSHIP THE DEVIL TOGETER
77 watching -
4:27:16
Joe Donuts Live
6 hours ago🟢 Squashing Bugs Like They Owe Me V-Bucks!
12.9K