In this video we will aim to develop a general understanding of what a database is, and what tables are. I use a simple folder structure to explain the database to table relationships and spreadsheets to better explain tables themselves.
We will be creating our first database in this video...
----=== Downloadable Materials ===----
And for our table, here is the .SQL download link:
http://elricsims.com/youtube_downloads/LearnSQL/tblPerson_with_data.sql
----=== Table of Contents ===----
00:00 Introduction
00:26 Title / Logo
00:33 Database and Table Explanations
01:16 Hypothetical - Imagine not having a Database, why we use databases
02:38 Create our First Database (LearnSQL)
03:30 Create Table - Download File, Open it, Run it
05:25 View Table Data (Edit Top 20000)
06:00 Comparing a SQL Table to a Spreadsheet
06:27 Spreadsheet and SQL Editing Functionality Differences
08:47 Closing - Run Script Again to Undo Changes
09:28 Closing
09:48 Outro Card (Next video)
----=== Support Me ===----
Patreon: https://www.patreon.com/elricsims
Ko-Fi: https://ko-fi.com/elricsims
#LearnSQL #SQLForBeginners #SQL101
Download
0 formats
No download links available.
002 - Create/Learn About Database and Tables - Learn SQL From No Programming Experience | NatokHD