Скачать или смотреть How to Create a Database in SQL with Management Studio

Learn how to create a database using SQL code on SQL Server Management Studio.

SQL is the language used for creating tables and objects in a Relational Database. In this video I'll show you how to create a basic database with one schema and one table based on an Entity Relationship Diagram (ERD).

Code repository is linked below.

Useful links
Code sample: https://github.com/thecodebiteschanne...
Official Microsoft page about CREATE TABLE: https://docs.microsoft.com/en-us/sql/...


Topics:
00:00 Intro
00:10 Getting started
00:25 ERD diagram and table description
00:36 Connect to your database
00:47 Open the New Query editor
00:53 CREATE TABLE statement
01:35 USE TABLE statement
01:27 The GO separator
01:57 CREATE SCHEMA statement
02:35 CREATE TABLE statement
03:15 Columns and data types
03:37 Add an auto-incremental PRIMARY KEY column (IDENTITY column)
04:30 Columns that store textual data (NVARCHAR)
05:34 Columns that store a date without a time stamp (DATE)
05:52 Columns that store a date with a time stamp (DATETIME)
06:14 Columns that store ON (1) or OFF (0) values (BIT)
06:35 Finish the CREATE TABLE statement
06:51 Run and test your script
07:06 Verify your database objects in the object explorer
07:36 Thank you and Subscribe!