SQL Basic in hindi || create, update, delete, insert || sql for beginner in hindi

Описание: Don't forget to tag our Channel...!
#sqlintroduction
#sqlfullcourse
#oracledatabase
#oracle
#sql
#sqlddlcommand
#sqldmlcommand
#sqldqlcommand
#sqltclcommand
#ddlcommands
#dmlcommands
#dqlcommands
#tclcommands
#oraclesql
#oracle11g
#ask4help
#LearnCoding

|| Content ||
1. voice 🔊 :- Omkar
2. writer ✍ :- Omkar
__________________________________________________________

If you found this video valuable, give it a like.
If you know someone who needs to see it, share it.
If you have questions ask below in comment section.
Add it to a playlist if you want to watch it later.
___________________________________________________________
Sql theory question and answer for interview purpose on MySQL, Oracle, SQL Server, PostGre, etc.
sql,mysql,learn sql,sql course,sql basics,postgresql,select,mysql course,sql tutorial,sql beginner,learning sql,mysql tutorial,how to use sql,free sql course,sql full course,sql introduction,how to learn sql,sql for beginners,ssms,kevin stratvert sql,microsoft sql server,rdbms,learn,sql beginner tutorial,learn sql for beginners,oracle,basics,sql course for beginners,course,sql tutorial for beginners,sql server management studio,tutorial,microsoftsql interview questions pdf,oracle sql interview questions,amazon sql interview questions,common sql interview questions,it interview questions,sql technical interview questions,sql interview questions and answers,sql interview questions for testers,sql interview questions for data analyst,it technical interview questions,sql interview questions for business analyst,structured query language interview questions sql developer,oracle sql developer,sql developer for beginners,oracle sql developer tutorial,oracle sql developer for beginners,sql developer tutorial for beginners,oracle sql developer tutorial for beginners,sql tutorial,sql full course,sql tutorial for beginners,oracle database for beginners,oracle database architecture,oracle database,oracle database tutorial,oracle sql,oracle database tutorial for beginners,morioh,oracle,database
_________________________________________________________________________________________________
Copy and paste this into your sql:-
_________________________________________________________________________________________________drop database scott;
CREATE DATABASE SCOTT ;
USE SCOTT;
DROP TABLE IF EXISTS emp;
CREATE TABLE emp
(
empno decimal(4,0) NOT NULL,
ename varchar(10) default NULL,
job varchar(9) default NULL,
mgr decimal(4,0) default NULL,
hiredate date default NULL,
sal decimal(7,2) default NULL,
comm decimal(7,2) default NULL,
deptno decimal(2,0) default NULL
);
DROP TABLE IF EXISTS dept;
CREATE TABLE dept (
deptno decimal(2,0) default NULL,
dname varchar(14) default NULL,
loc varchar(13) default NULL
);
INSERT INTO emp VALUES
('7369','SMITH','CLERK','7902','1980-12-17','800.00',NULL,'20');
INSERT INTO emp VALUES
('7499','ALLEN','SALESMAN','7698','1981-02-20','1600.00','300.00','30');
INSERT INTO emp VALUES
('7521','WARD','SALESMAN','7698','1981-02-22','1250.00','500.00','30');
INSERT INTO emp VALUES
('7566','JONES','MANAGER','7839','1981-04-02','2975.00',NULL,'20');
INSERT INTO emp VALUES
('7654','MARTIN','SALESMAN','7698','1981-09-28','1250.00','1400.00','30');
INSERT INTO emp VALUES
('7698','BLAKE','MANAGER','7839','1981-05-01','2850.00',NULL,'30');
INSERT INTO emp VALUES
('7782','CLARK','MANAGER','7839','1981-06-09','2450.00',NULL,'10');
INSERT INTO emp VALUES
('7788','SCOTT','ANALYST','7566','1982-12-09','3000.00',NULL,'20');
INSERT INTO emp VALUES
('7839','KING','PRESIDENT',NULL,'1981-11-17','5000.00',NULL,'10');
INSERT INTO emp VALUES
('7844','TURNER','SALESMAN','7698','1981-09-08','1500.00','0.00','30');
INSERT INTO emp VALUES
('7876','ADAMS','CLERK','7788','1983-01-12','1100.00',NULL,'20');
INSERT INTO emp VALUES
('7900','JAMES','CLERK','7698','1981-12-03','950.00',NULL,'30');
INSERT INTO emp VALUES
('7902','FORD','ANALYST','7566','1981-12-03','3000.00',NULL,'20');
INSERT INTO emp VALUES
('7934','MILLER','CLERK','7782','1982-01-23','1300.00',NULL,'10');
INSERT INTO dept VALUES ('10','ACCOUNTING','NEW YORK');
INSERT INTO dept VALUES ('20','RESEARCH','DALLAS');
INSERT INTO dept VALUES ('30','SALES','CHICAGO');
INSERT INTO dept VALUES ('40','OPERATIONS','BOSTON');
EMP & DEPT
Tuesday, 23 June 2020 2:32 PM
CREATE DATABASE SCOTT ;
USE SCOTT;
DROP TABLE IF EXISTS emp;
CREATE TABLE emp
(
empno decimal(4,0) NOT NULL,
ename varchar(10) default NULL,
job varchar(9) default NULL,
mgr decimal(4,0) default NULL,
hiredate date default NULL,
sal decimal(7,2) default NULL,
comm decimal(7,2) default NULL,
deptno decimal(2,0) default NULL
);
DROP TABLE IF EXISTS dept;
CREATE TABLE dept (
deptno decimal(2,0) default NULL,
dname varchar(14) default NULL,
loc varchar(13) default NULL
);
INSERT INTO emp VALUES
('7369','SMITH','CLERK','7902','1980-12-17','800.00',NULL,'20');
INSERT INTO emp VALUES
('7499','ALLEN','SALESMAN','7698','1981-02-20','1600.00','300.00','30');
INS