- What is Data Base?
Ans: A database is an organized collection of data, generally stored and accessed electronically from a computer system. Where databases are more complex they are often developed using formal design and modeling techniques.
2. What is SQL?
Ans: SQL stands for Structured Query Language. It is used for storing and managing data in relational database management system (RDMS). It is a standard language for Relational Database System. … All the RDBMS like MySQL, Informix, Oracle, MS Access and SQL Server use SQL as their standard database language.
— — — — — — — — — — — — — — — — — — — — — — — — — — — — — — —
Today we will talk about Basic query of Data Base…
- SELECT * FROM EMPLOYEES;
This query is used for take out the list of Employees. Example given below.
SQL> SELECT * FROM EMPLOYEES;
EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
------------------------- -------------------- --------- ---------- ----------
COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
-------------- ---------- -------------
100 Steven King
SKING 515.123.4567 17-JUL-87 AD_PRES 24000
90
101 Neena Kochhar
NKOCHHAR 515.123.4568 21-SEP-89 AD_VP 17000
100 90EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
------------------------- -------------------- --------- ---------- ----------
COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
-------------- ---------- -------------
102 Lex De Haan
LDEHAAN 515.123.4569 13-JAN-93 AD_VP 17000
100 90
103 Alexander Hunold
AHUNOLD 590.423.4567 03-JAN-90 IT_PROG 9000EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
------------------------- -------------------- --------- ---------- ----------
COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
-------------- ---------- -------------
102 60
104 Bruce Ernst
BERNST 590.423.4568 21-MAY-91 IT_PROG 6000
103 60
107 Diana LorentzEMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
------------------------- -------------------- --------- ---------- ----------
COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
-------------- ---------- -------------
DLORENTZ 590.423.5567 07-FEB-99 IT_PROG 4200
103 60
124 Kevin Mourgos
KMOURGOS 650.123.5234 16-NOV-99 ST_MAN 5800
100 50EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
------------------------- -------------------- --------- ---------- ----------
COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
-------------- ---------- -------------
141 Trenna Rajs
TRAJS 650.121.8009 17-OCT-95 ST_CLERK 3500
124 50
142 Curtis Davies
CDAVIES 650.121.2994 29-JAN-97 ST_CLERK 3100
124 50EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
------------------------- -------------------- --------- ---------- ----------
COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
-------------- ---------- -------------
143 Randall Matos
RMATOS 650.121.2874 15-MAR-98 ST_CLERK 2600
124 50
144 Peter Vargas
PVARGAS 650.121.2004 09-JUL-98 ST_CLERK 2500EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
------------------------- -------------------- --------- ---------- ----------
COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
-------------- ---------- -------------
124 50
149 Eleni Zlotkey
EZLOTKEY 011.44.1344.429018 29-JAN-00 SA_MAN 10500
.2 100 80
174 Ellen AbelEMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
------------------------- -------------------- --------- ---------- ----------
COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
-------------- ---------- -------------
EABEL 011.44.1644.429267 11-MAY-96 SA_REP 11000
.3 149 80
176 Jonathon Taylor
JTAYLOR 011.44.1644.429265 24-MAR-98 SA_REP 8600
.3 149 80EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
------------------------- -------------------- --------- ---------- ----------
COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
-------------- ---------- -------------
178 Kimerely Grant
KGRANT 011.44.1644.429263 24-MAY-99 SA_REP 7000
.15 149
200 Jennifer Whalen
JWAHLEN 515.123.4444 17-SEP-87 AD_ASST 4400
101 10EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
------------------------- -------------------- --------- ---------- ----------
COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
-------------- ---------- -------------
201 Michael Hartstein
MHARTSTE 515.123.5555 17-FEB-96 MK_MAN 13000
100 20
202 Pat Fay
PFAY 603.123.6666 17-AUG-97 MK_REP 6000EMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
------------------------- -------------------- --------- ---------- ----------
COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
-------------- ---------- -------------
201 20
205 Shelley Higgins
SHIGGINS 515.123.8080 07-JUN-94 AC_MGR 12000
101 110
206 William GietzEMPLOYEE_ID FIRST_NAME LAST_NAME
----------- -------------------- -------------------------
EMAIL PHONE_NUMBER HIRE_DATE JOB_ID SALARY
------------------------- -------------------- --------- ---------- ----------
COMMISSION_PCT MANAGER_ID DEPARTMENT_ID
-------------- ---------- -------------
WGIETZ 515.123.8181 07-JUN-94 AC_ACCOUNT 8300
205 110
Note: This table is small given by the Medium. So sequences may be not in correct manner but when you run in your data base it will be in manner. If it is not in manner then write a query given below.
SQL> SET LINESIZE 240;2. SELECT * FROM REGIONS;
This query is used to take out the region present in the Data Base. Example given below.
SQL> SELECT * FROM REGIONS;
REGION_ID REGION_NAME
---------- -------------------------
1 Europe
2 Americas
3 Asia
4 Middle East and Africa3. SELECT * FROM LOCATIONS;
This query is used for take out locations present in the Data Base. Example given below.
SQL> SELECT * FROM LOCATIONS;
LOCATION_ID STREET_ADRESS POSTAL_CODE CITY STATE_PROVINCE CO
----------- ---------------------------------------- ------------ ------------------------------ ------------------------- --
1400 2014 Jabberwocky Rd 26192 Southlake Texas US
1500 2011 Interiors Blvd 99236 South San Francisco California US
1700 2004 Charade Rd 98199 Seattle Washington US
1800 460 Bloor St. W. ON M5S 1X8 Toronto Ontario CA
2500 Magdalen Centre, The Oxford Science Park OX9 9ZB Oxford Oxford UK4. SELECT * FROM COUNTRIES;
This query is used for take out the countries present in the Data Base. Example given below.
SQL> SELECT * FROM COUNTRIES;
CO COUNTRY_NAME REGION_ID
-- ---------------------------------------- ----------
CA Canada 2
DE Germany 1
UK United Kingdom 1
US United States of America 25. SELECT * FROM DEPARTMENTS;
This query is used for take out the departments present in the Data Base. Example given below.
SQL> SELECT * FROM DEPARTMENTS;
DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID
------------- ------------------------------ ---------- -----------
10 Administration 200 1700
20 Marketing 201 1800
50 Shiping 124 1500
60 IT 103 1400
80 Sales 149 2500
90 Executive 100 1700
110 Accounting 205 1700
190 Contracting 1700Note: This all tables are inter connected with each other. So this table are used in whole SQL DATABASE in further chapters too.
So this are the basic query of SQL Data Base. In next chapter we will learn about another query which will join this table together as per user demand.
Guys I am using Oracle data base 12g. you can use what you want but I suggest to use oracle version 12g or 11g. for installation link is given below .
if you don’t want to install and practice in online debugger so for that oracle has provide a live SQL so you can use that for that link is given below .
https://livesql.oracle.com/apex/f?p=590:1000:0
If any doubt Regarding this chapter write in comment section or Write DM in my Instagram id “ oye_itz_yash ” .