Informatica PowerCenter Batch-25 Session-2 | Introduction to Oracle SQL | SQL Basics | SQL Tutorial

👉 Join Informatica IICS(IDMC) WhatsApp group: https://chat.whatsapp.com/KlCxKZZNqO7...

Raj Cloud Technologies Informatica PowerCenter Realtime online Training
👉 Join Informatica PowerCenter WhatsApp group: https://chat.whatsapp.com/FMcfXIJTbp9...


☎️ Contact: 8105296858
Website : https://rajinformatica.com/informatic...


ORACLE - SQL - STRUCTURED QUERY LANGUAGE
--------------------------------------------
DDL COMMANDS - DATA DEFINIATION LANGUAGE - CREATE , ALTER , DROP ,RENAME , TRUNCATE
DML COMMANDS - DATA MANIPULATION LANGUAGE- INSERT , UPDATE , DELETE
TCL COMMANDS - TRANSACTION CONTROL LANGUAGE - COMMIT , ROLLBACK
DQL COMMANDS - DATA QUERY LANGUAGE - SELECT
DCL COMMANDS - DATA CONTROL LANGUAGE - GRANT , REVOKE


TO WORK ON ABOVE ORACLE COMMANDS ,

YOU SHOULD INSTALL ORACLE SERVER 11G
YOU SHOULD INSTALL ORACLE SQL DEVELOPER.



1. create a schema in oracle sql developer.

CREATE USER OT_SRC_DEV15 IDENTIFIED BY admin;

GRANT ALL PRIVILEGES TO OT_SRC_DEV15;

GRANT DBA TO OT_SRC_DEV15;


2. CREATE A TABLE DEFINITION OR STRUCTURE OF THE TABLE.
CREATE TABLE STUDENTS
(
ST_ID NUMBER(3),
ST_NAME VARCHAR2(50),
MARKS NUMBER(5,2),
CITY VARCHAR2(100)
);




3. TO SEE THE DEFINITION OR STRUCTURE OF THE TABLE

DESC STUDENTS;


4. TO SEE THE DATA/ ROWS IN A TABLE
SELECT * FROM STUDENTS;

5. TO INSERT THE RECORDS/DATA INTO THE TABLE.
INSERT INTO STUDENTS(ST_ID,ST_NAME,MARKS,CITY) VALUES (1,'RAJ',99.95,'BNAGALORE');
INSERT INTO STUDENTS(ST_ID,ST_NAME,MARKS,CITY) VALUES (10,'RAM',100.1,'CHENNAI');
INSERT INTO STUDENTS(ST_ID,ST_NAME,MARKS,CITY) VALUES (150,'RAMYA',999.99,'MUMBAI');
INSERT INTO STUDENTS(ST_ID,ST_NAME,MARKS,CITY) VALUES (200,'DIVYA',0,'GOA');
INSERT INTO STUDENTS(ST_ID,ST_NAME,MARKS,CITY) VALUES (300,'JOHN',14,'PUNE');
INSERT INTO STUDENTS(ST_ID,ST_NAME,MARKS,CITY) VALUES (999,'RAJESH',200,'MYSORE');


6. HOW TO SAVE THE RECORDS FROM A TABLE ?
COMMIT;

7. How to see the count of the records?

Select count(*) from Students;

DDL- DATA DEFININATION LANGUAGE - CREATE , ALTER , DROP , RENAME , TRUNCATE
DML- DATA MANIPULATION LANGUAGE - INSERT , UPDATE , DELETE
TCL- TRANSACTION CONTROLM LANGUAGE - COMMIT , ROLLBACK
DQL- DATA QUERY LANGUAGE - SELECT



CREATE - TO CREATE A NEW TABLE
INSERT - TO INSERT THE NEW RECORD
COMMIT - TO SAVE THE RECORDS
SELECT - TO SEE THE RECORDS
DESC - TO SEE STR/DEF OF A TABLE
WHERE - TO SEARCH/FILTER THE RECORDS FROM A TABLE
COUNT(*) - TO SEE COUNT OF THE RECRODS FROM A TABLE.

ALTER
-----

Alter table Add - add the new columns to the table
Alter table drop - Remove the columns from a table
Alter table modify - Modify the datatypes in a table
Alter table rename - Rename the column names in a table.




1. How to create a schema called ot_src_dev2 ?
2. Configure the Schema OT_SRC_DEV2
3. Learn Basic SQL commands in Oracle
4. Create a table in oracle
5. How to see the records in a table ?
6. INSERT THE RECORDS INTO THE TABLE
7. Save the records into the table
8. How to See the structure/definition of a table?
9. see the count of records from a table
10.How to search the records from a table