SQL Tutorial 2- DDL/DML, Data Type, Create, Insert, Primary Key

Learn SQL, Introduction to DML/DDL, a series for Beginners. Create Table, not null, primary key, data type, insert data and select from the table. #sql, #rdbms, #table, #amitchandakda.

Definition Source: Google Search, Wikipedia, IBM, W3School

00:00 Introduction
01:45 Introduction to DML/DDL
04:30 Data Types
08:00 Basic Create, Insert, and select

Last Video:
Part 1: SQL Tutorial- Database Concepts, Install SQL Server: Beginners Course: https://youtu.be/ThCZYuYAbnY

SQL Server Data Types
https://learn.microsoft.com/en-us/sql/t-sql/data-types/data-types-transact-sql?view=sql-server-ver16

Oracle Data Types
https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsds/supported-data-types.html#GUID-97B7A932-E1CC-4557-97E8-62142847450A

MySQL Data Types
https://dev.mysql.com/doc/refman/8.0/en/data-types.html

PostgreSQL Data Types
https://www.postgresql.org/docs/current/datatype.html

SQL Used in Part 2

create table demo1(
id int);

select * from demo1;

insert into demo1
values(1) ;

select * from demo1;

insert into demo1
values(2) ;

select * from demo1;

insert into demo1
values(null) ;

select * from demo1;

select count(*) from demo1;

select count(1) from demo1;

insert into demo1
values(3) ;

select * from demo1;

insert into demo1
values(3) ;

select * from demo1;

-- --------------------------------------
create table demo2(
id int not null);

select * from demo2;

insert into demo2
values(1) ;
--
insert into demo2
values(2) ;
insert into demo2
values(2) ;

select * from demo2;

insert into demo2
values(null) ;

select * from demo2;

insert into demo2
values('3') ;

select * from demo2;

insert into demo2
values('A') ;

select * from demo2;
-- --------------------------------------
create table demo3(
id int primary key);

select * from demo3;

insert into demo3
values(1) ;

select * from demo3;

insert into demo3
values(2) ;

select * from demo3;

insert into demo3
values(2) ;

select * from demo3;

insert into demo3
values(null) ;

select * from demo3;

-- --------------------------------------
create table demo4(
id int unique);

select * from demo4;

insert into demo4
values(1) ;

select * from demo4;

insert into demo4
values(1) ;

select * from demo4;

insert into demo4
values(null) ;

select * from demo4;

insert into demo4
values(null) ;

select * from demo4;

insert into demo4
values(2) ;

select * from demo4;

create table demo_tab1(
id int primary key,
name varchar(50)
);

insert into demo_tab1 values (1, 'Amit') ;

insert into demo_tab1 values (1, 'Amit') ;

insert into demo_tab1 values ('A', 'Amit') ;

insert into demo_tab1 values ( 'Sumit',2) ;

insert into demo_tab1 values ( 2,'Sumit') ;

select * from demo_tab1;

insert into demo_tab1 values ( null,'Sumit') ;

insert into demo_tab1 values ( 3,'Sumit') ;

select * from demo_tab1;

insert into demo_tab1 values ( 3,'Sumit','Amit') ;

insert into demo_tab1 (name, id) values ('Ajay',4) ;

select * from demo_tab1;

insert into demo_tab1 (id,name ) values (5,'Vijay') ;

select * from demo_tab1;

insert into demo_tab1 (id ) values (6) ;

select * from demo_tab1;

insert into demo_tab1 (id,name ) values (7,null) ;

select * from demo_tab1;
create table demo_tab2(
id int primary key,
name varchar(50) ,
dob datetime2
);
insert into demo_tab2 values (1, 'Amit', '2022-01-01') ;

select * from demo_tab2;

-~-~~-~~~-~~-~-
Please watch: "Microsoft Power BI Tutorial For Beginners✨ | Power BI Full Course 2023 | Learn Power BI"
https://www.youtube.com/watch?v=cN8AO3_vmlY
-~-~~-~~~-~~-~-

Видео SQL Tutorial 2- DDL/DML, Data Type, Create, Insert, Primary Key канала Learn Microsoft Fabric, Power BI, SQL Amit Chandak