02 Creating Database | Designing Database Solutions with Microsoft SQL Server 2019

In this video, Joed Goh demonstrates how to create a database in MS SQL Server 2019. He explains some of the configuration options, files and file system, table design and data types, common error message that you may encounter, and how to edit and retrieve data stored in a table.

Table of Contents:
00:00 Introduction
02:12 Creating a Database
04:54 Configuration Options
09:50 Creating Table
11:30 Data Types
20:32 Adding Records
23:26 Saving changes is not permitted error
26:27 Scripting a database table

PLAYLISTS:
Designing Database Solutions with Microsoft SQL Server 2019

Android App Development in Kotlin

Embedded Systems using Arduino Uno

Data Structures and Algorithms using C#

[dimosthenisminas]

Fantastic tutorial. You give all the information needed, not just executing a simple task. Greetings from Greece!

[Busisiwe]

Thanks my guy, I've really learnt a lot, all the way from South Africa

[PrinceKumar-lmd]

Thank you for this knowledgeable content.

[joegodindata]

Unchecking that box in the Tools section was such an epic tip. Thank you for that. I don't plan to use it much at all, but when creating a database from scratch in a practice environment it would've been useful for my IDENTITY column that it didn't let me edit to auto-update +1 with each new record so I had to drop all of my tables and then recreate them manually. They had no data, so it's not like it would've broken anything in the DB. Thanks again.

[sandramuzambi]

The tutorial was great and so easy to comprehend