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:10
Russell Brand
3 hours agoHillary Clinton DEMANDS Free Speech CENSORSHIP CRACKDOWN – Rumble, X TARGETED! - SF469
75.8K232 -
3:02:32
Tate Speech by Andrew Tate
1 day agoEMERGENCY MEETING EPISODE 80 - WHY YOU LOSE
112K172 -
1:25:26
TheAlecLaceShow
3 hours agoGuest: Dr. Ben Carson | Butler Rally Interviews with Benny Johnson, Tim Pool + | The Alec Lace Show
4.38K6 -
19:23
Neil McCoy-Ward
2 hours ago🔥 Macron 'Preparing For War' As French Troops Given 10 Days To Reach Romania...
4.45K1 -
59:25
The Dan Bongino Show
5 hours agoThis Is Easily The Worst Interview I've Ever Seen (Ep. 2345) - 10/08/2024
599K4.64K -
1:04:20
The Rubin Report
3 hours agoWatch Kamala Get Visibly Angry as ‘60 Minutes’ Host Asks Unexpected Questions
62.3K60 -
2:03:05
Matt Kohrs
15 hours agoStock Market Open: NEW HIGHS INCOMING! || The MK Show
47.2K12 -
40:06
-
2:00:28
LFA TV
17 hours agoTIME FOR TAKEOVER! | LIVE FROM AMERICA 10.8.24 11am EST
53.3K56 -
1:04:02
2 MIKES LIVE
16 hours agoThe Mike Schwartz Show 10-08-2024
69.7K1