📁 SQL Interview Questions


Good SQL Queries Collection

Good SQL Queries Collection /* CREATE TABLE FOR DEPARTMENT */ CREATE TABLE DEPARTMENT ( “DEPT_ID” NUMBER, “DEPT_NAME” VARCHAR2(30), PRIMARY KEY (“DEPT_ID”) ) /* CREATE TABLE FOR EMP */ CREATE TABLE EMPLOYEE ( “EMP_ID” NUMBER, “MGR_ID” NUMBER, “DEPT_ID” NUMBER, “EMP_NAME” VARCHAR2(30), “SAL” NUMBER, “DOJ” DATE, PRIMARY KEY (“EMP_ID”) ENABLE, FOREIGN KEY (“MGR_ID”) REFERENCES EMPLOYEE (“EMP_ID”) ENABLE, FOREIGN KEY (“DEPT_ID”) REFERENCES DEPARTMENT (“DEPT_ID”) ENABLE ) /* INSERT STATEMENT FOR DEPARTMENT */ INSERT […]


Review Comments
default gravatar

I am a plsql developer. Intrested to move into bigdata.

Neetika Singh ITA

.

Next Batch Spark, Scala Training

  • Next Batch on Spark Developer Online Training starts around 26th of February. If any one interested to attend this batch please register by sending email to me on siv535@gmail.com or calling on +91-9704231873
  • Training Course Includes below topics:
  • Scala
  • Spark
  • Real Time projects
  • Contact For Job Support Also

Next Training Batch on Hadoop Starts on 21st Feb

  • Next Batch on Spark Developer Online Training starts around 21st of February. If any one interested to attend this batch please register by sending email to me on siv535@gmail.com or calling on +91-9704231873
  • Training Course Includes below topics:
  • HDFS
  • Mapreduce Essentials
  • Pig
  • Hive
  • Impala
  • Hbase
  • Sqoop
  • Flume
  • Oozie
  • 3 Real Time Projects