Create Database, Table in SQL| NOT NULL, Primary Key | Check Constraint | SQL Tutorial for Beginner

Описание

#SQL #datascience #Analytics #youtube
Hey guys, In this video we will see how to create a Database and a Table in SQL Server Management Studio.

CREATE DATABASE statement of SQL is used to create a database in a relational database. CREATE DATABASE is the first and the most simple command in SQL. All the tables reside inside the DATABASE only.

CREATE TABLE command is used to create a table inside any DATABASE. All the data resides inside a TABLE only.

we will also see how to use NOT NULL, Primary Key and Check constraints in different columns. Constraints can be specified when the table is created with the CREATE TABLE statement, or after the table is created with the ALTER TABLE statement.

SQL is a very important topic if you want to pursue your career in Data Science/Analytics. It helps you pull the data from the different databases and let you perform the analysis.
If you are an aspiring Data Scientist/Analyst , do follow this SQL playlist from the start.

If you guys have any doubt regarding SQL or Analytics field, feel free to contact me on:
LinkedIn: https://www.linkedin.com/in/chaitanya-kaul/
Telegram: https://t.me/datascience_mentoring