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...
-
1:07:06
Mike Rowe
18 days agoThe Fight For America's Heartland | Salena Zito #442 | The Way I Heard It
30.3K47 -
2:43:30
TimcastIRL
6 hours agoSouth Park Goes FULL CHARLIE KIRK, Latest Episode ROASTS Trump Again | Timcast IRL
218K90 -
LIVE
SpartakusLIVE
7 hours agoThe Return of the KING of Content
372 watching -
10:05
MattMorseTV
10 hours ago $6.53 earnedHe actually did it...
60.5K24 -
1:32:39
Anthony Rogers
1 day agoEpisode 376 - Todd Schowalter
32.9K -
3:42:07
megimu32
6 hours agoOTS: Movie Tie-In Games + Remakes: Let’s Play Memory Lane
46.8K6 -
1:15:06
Adam Does Movies
13 hours ago $1.02 earnedTalking Movies + Ask Me Anything - LIVE
32K8 -
1:17:18
Glenn Greenwald
1 day agoWhat are CBS News' Billionaire Heirs Doing with Bari Weiss? With Ryan Grim on the Funding Behind It; Europe Capitulates to Trump Again | SYSTEM UPDATE #494
116K83 -
1:43:49
RiftTV
8 hours agoCNN Calls Black NY Shooter WHITE, Cincinnati FATIGUE | The Rift | Guest: Braeden Sorbo, 2Protects1
55.4K17 -
4:21:04
LumpyPotatoX2
9 hours agoKilling Floor 3: Rampage & Chaos - #RumbleGaming
21K1