SQL Database Set-up | Kick-start SQL Practice
Krishna Kayaking ????
Big Data Engineer | AWS | Azure | Python | Spark | SQL | Databricks | YouTuber | Storyteller | Musician | 5k LinkedIn | 3k YT | 100k Insta
?? A new video on Setting up SQL | Kick-start SQL | SQL | DBeaver | SQLLite | DDL | DML | DQL?@TechieKrishnaKayking? ??
Watch the full video to get detailed insight on how to start your SQL
CHAPTERS
? Quiz
? Video Intro
? Screen - Download
? Database Set-up - SQL Lite
? Create Database
? DDL - Create Tables
? DML - Insert Data into the table
? Closing - sign off
/*?
DDL SCRIPTS
--------------
- EMPLOYEE TABLE | DEPT TABLE | BONUS | SALGRADE
- INSERT DUMMY DATA
*/
create table dept(
?deptno number(2,0),
?dname?varchar2(14),
?loc??varchar2(13),
?constraint pk_dept primary key (deptno)
);
create table emp(
?empno??number(4,0),
?ename??varchar2(10),
?job???varchar2(9),
?mgr???number(4,0),
?hiredate date,
?sal???number(7,2),
?comm???number(7,2),
?deptno??number(2,0),
?constraint pk_emp primary key (empno),
?constraint fk_deptno foreign key (deptno) references dept (deptno)
);
/*
create table bonus(
?ename varchar2(10),
?job??varchar2(9),
?sal??number,
?comm?number
);
create table salgrade(
?grade number,
?losal number,
?hisal number
);
*/
----##########################################
/*?
DML SCRIPTS
--------------
- EMPLOYEE TABLE | DEPT TABLE | BONUS | SALGRADE
- INSERT DUMMY DATA
*/
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');
?
insert into emp
values(
?7839, 'KING', 'PRESIDENT', null,
?'17-11-1981',
?5000, null, 10
);
insert into emp
values(
?7698, 'BLAKE', 'MANAGER', 7839,
?'1-5-1981',
?2850, null, 30
);
insert into emp
values(
?7782, 'CLARK', 'MANAGER', 7839,
?'9-6-1981',
?2450, null, 10
);
insert into emp
values(
领英推荐
?7566, 'JONES', 'MANAGER', 7839,
?'2-4-1981',
?2975, null, 20
);
insert into emp
values(
?7788, 'SCOTT', 'ANALYST', 7566,
?'13-JUL-87',
?3000, null, 20
);
insert into emp
values(
?7902, 'FORD', 'ANALYST', 7566,
?'3-12-1981',
?3000, null, 20
);
insert into emp
values(
?7369, 'SMITH', 'CLERK', 7902,
?'17-12-1980',
?800, null, 20
);
insert into emp
values(
?7499, 'ALLEN', 'SALESMAN', 7698,
?'20-2-1981',
?1600, 300, 30
);
insert into emp
values(
?7521, 'WARD', 'SALESMAN', 7698,
?'22-2-1981',
?1250, 500, 30
);
insert into emp
values(
?7654, 'MARTIN', 'SALESMAN', 7698,
?'28-9-1981',
?1250, 1400, 30
);
insert into emp
values(
?7844, 'TURNER', 'SALESMAN', 7698,
?'8-9-1981',
?1500, 0, 30
);
insert into emp
values(
?7876, 'ADAMS', 'CLERK', 7788,
?'13-JUL-87',
?1100, null, 20
);
insert into emp
values(
?7900, 'JAMES', 'CLERK', 7698,
?'3-12-1981',
?950, null, 30
);
insert into emp
values(
?7934, 'MILLER', 'CLERK', 7782,
?'23-1-1982',
?1300, null, 10
);
?
/*
insert into salgrade
values (1, 700, 1200);
insert into salgrade
values (2, 1201, 1400);
insert into salgrade
values (3, 1401, 2000);
insert into salgrade
values (4, 2001, 3000);
insert into salgrade
values (5, 3001, 9999);
*/
?
commit;
***********************
Follow me on Social Media - Krishna Kayaking -
LinkedIn - https://www.dhirubhai.net/in/krishnakayaking
Instagram - https://www.instagram.com/krishnakayaking/
FB - https://www.facebook.com/krishnakayaking/
Twitter - https://twitter.com/krishnakayaking
#data #video #sql #database #testing #job #career #video #database #video #youtube #krishnakayaking #techieKrishnaKayaking #TKK #techie #techies #ITlife #informationtechnology #engineering #career #careergrowth #education #testing #BigData #ETL #DWH #linkedin #crack #interviewpreparation #interviewpreparation #interview #experience #thankyou #jobs #podcast #learning #instagram #linkedin #facebook #krishnakayaking #techieKrishnaKayaking #TKK #techie #KRGD #Krsnarupa #community #writing #communication #gratitude #email #immediatejoining #unix #linux #like #share #project