How to Create Database Tables Using SQL and HeidiSQL

Discover the power of SQL as we guide you through the process of building a robust database table from scratch in our latest video tutorial. Gain valuable insights into defining columns, setting primary keys, and establishing relationships between tables with foreign keys.
We will also look at how to do the same tasks utilizing the HeidiSQL tool, so you can learn how to utilize tools to make your life easier, when they are available to you.

-- Video Chapters --
00:00 - Introduction
00:08 - Review of Last Video
00:39 - Reviewing our ERD
00:57 - Creating a Table with SQL
01:37 - How I name tables
02:05 - Setting Field Constraints
02:44 - Selecting a Case for your Names
03:08 - Defining a VarChar
03:46 - Writing Code that's easier to read
05:01 - Phone Number - Number or Text
07:36 - Fixing the No Database Selected
08:27 - Verifying the Table is created
08:59 - Creating a Table with HeidiSQL Tools
10:28 - Date Time fields
10:59 - Using "Real" Numbers (Decimal Values)
11:54 - Enum data type
12:23 - Creating a Timestamp
13:52 - Create Primary Key
14:11 - Creating a Foreign Key
15:11 - Generated Create SQL Code
15:43 - Saving the Table Design to Create It
16:01 - Creating Tables with another tool
16:52 - What's Next