Скачать с ютуб How to Create a Database in SQL with Management Studio в хорошем качестве

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!