Day 2 - SQL in TAMIL | Oracle SQL tutorial in TAMIL | SQL tutorial for beginners in Tamil
Вставка
- Опубліковано 6 жов 2024
- #JUSTIN#ORACLE#SQL#TAMIL#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers
=====================================================================
📢Dear Techies,
Do you want to join SQL/PLSQL Interview preparation, job search Group?
🔵Please join in the WhatsApp group for an update
chat.whatsapp....
🌕For Live PLSQL training contact me on WhatsApp (+91 7010080468) or below link
wa.link/m4lat0
🔵 It is Job based - Live online training session
🔵 100% Job assistance, Real time training.
🔵 Resume preparation, Interview preparation supported.
🔵 Project explanation, Mock interviews will be taken.
1. Interview preparation, mock interview taken
2. Low cost training
3. Job Assistance
4. Have 14+ yrs of IT Exp
5. Job Oriented Training
6. Life time video recording access
(📢📢Trainer: Chandra - A Tableau and Informatica certified Professional)
📌Having 14+ years of IT experience in Banking, Insurance and Retail domain
📌Taking Training last 8+ years
📌Handled corporate and Live training sessions
========================================================
Oracle SQL - Complete tutorial Playlist
• Oracle SQL - தமிழில்
*****************************************************************************************************
Oracle PL/SQL - Complete tutorial Playlist
• Oracle PLSQL Training ...
*****************************************************************************************************
Oracle SQL Day wise Video:
Oracle SQL in Tamil - Day 1 - • Day 1 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 2 - • Day 2 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 3 - • Day 3 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 4 - • Day 4 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 5 - • Day 5 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 6 - • Day 6 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 7 - • Day 7 - SQL in TAMIL |...
Oracle SQL in Tamil - Day 8 - • Day 8 - SQL in TAMIL |...
Oracle SQL in Tamil Day 9 - • Oracle SQL Analytical ...
Oracle SQL in Tamil Day 10 - • Views in Oracle SQL TA...
*****************************************************************************************
PLSQL Session 1:Indroduction
• Oracle pl sql tutorial...
PLSQL Session 2:DML Statement
• Session 2 - DML Statem...
PLSQL Session 3:IF and Case Statement
• PLSQL Session 3 - IF a...
PLSQL Session 4: Anchored datatype in PL/SQL %TYPE %ROWTYPE
• Anchored datatype in P...
PLSQL Session 6: Procedure
• Session 6 - Stored Pro...
***********************************************************************************************
#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers
**********************************************************************************************
In this video, we’ll learn
1) How to create table in SQL
2) Insert the record into table
3) Update the record
3) Add a column, drop a column
4) Modify the data length
5) Modify the data type of existing table
6) How to take backup of the table
7) Rename the table and column
8) Delete, Truncate and Drop
9) Delete, Truncate and Drop - differences
10) Savepoint with example
oracle sql tutorial for beginners
oracle sql tutorial in TAMIL
sql tutorial for beginners in tamil
sql tutorial for beginners
sql tutorial in tamil
how to create table in sql tamil
how to create table in oracle
sql in tamil
sql jobs in tamil
sql training in tamil
mysql in tamil
mysql install in tamil
sql interview questions and answers
sql interview questions and answers for freshers
sql joins with examples
sql joins interview questions
sql joins interview questions scenario based
sql joins interview questions and answers for experienced
sql joins interview questions and answers in tamil
SQL in Tamil
SQL interview questions and answers in Tamil
plsql tutorial oracle
pl sql videos in tamil
oracle pl sql tutorial in tamil
PL/SQL tutorial in tamil - Introduction
Oracle - Pl/SQL - Introduction
oracle pl sql tutorial in tamil
oracle pl sql full course
oracle pl sql real time projects
oracle real time scenarios
oracle pl sql tutorial for beginners
oracle pl sql interview questions
pl sql interview questions for 7 years experience
PL/SQL tutorial in tamil - Introduction
==========
SQL Notes:
==========
drive.google.c...
Complete 48 hours of Self-Paced Courses and Interview Questions Links:*
courses.nicitacademy.com/
Are you interested in joining my Live training? or Self-Paced course?
You can visit our website for more details.
www.nicitacademy.com/
Contact me for more details @ 🌕 wa.link/m4lat0
*WhatsApp group:*
chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0
Thanks,
NiC IT Academy
=======================================================================
🔵Oracle SQL Tutorial - English
ua-cam.com/play/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF.html
📌*IICS demo session:*
ua-cam.com/video/C1zGVRFM3-A/v-deo.html
📌*Informatica Full Course:*
ua-cam.com/video/V2FtZ_INmjg/v-deo.html
📌*SQL Full Course:*
ua-cam.com/video/iuvzjf7nU1I/v-deo.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj.html
🌕 Informatica training in ENGLISH - Playlist
ua-cam.com/play/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd.html
🌕 Informatica Interview Preparation - ENGLISH
ua-cam.com/play/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d.html
🌕Oracle SQL - தமிழில்
ua-cam.com/play/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4.html
🔵 Informatica training in தமிழில் - Playlist
ua-cam.com/play/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3.html
🔵 Informatica Interview Preparation - TAMIL
ua-cam.com/play/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD.html
🔵Unix for Informatica Developer
ua-cam.com/play/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw.html
🌕Informatica Project videos
ua-cam.com/play/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6.html
Please subscribe, Like, and comment. I will post more videos.
Thanks
Lucky that I found your videos sir. Very easy to understand. Clear and crisp explanation. I love the way to teach. You keep reminding us about the check points to keep in mind. Most teaching professionals would not do that. Great work sir. Thank you so much for this playlist. I am from a non-IT background. I am searching for a job as a Data Analyst. This will help me a lot through my learning journey. Thank you once again.
Thanks and welcome. Continue to complete all the SQL videos and start learning Informatica, It will take you for the next career path.
Keep learning.
@@NICITACADEMY Thank you sir. Yes I am planning to complete the complete SQL playlist as soon as possible. Also thank you for the suggestion sir.
thank you sir ... really understood
#assignment did using mysql database
drop table product;
create table product
(
prod_id varchar(50),
prod_name char(50),
manu_name date,
company_name char(50),
unit_price int not null,
category_name char(50)
);
insert into product values('E10','redmi','2000-04-01','xiomi',10000,'note 10');
select * from product;
alter table product
add external_storage int;
desc product;
alter table product
drop column company_name;
desc product;
alter table product
modify prod_name char(100);
desc product;
alter table product
rename to product_table;
select * from product_table;
alter table product_table
rename column unit_price to product_price;
desc product_table;
PL/SQL program
#anonnymous black full topic
#trigger full topic
#curser full topic
#stored procedure full topic
#functions full topic
#packags full topic video post pannunga sir.
very clear explantion sir good sir keep it up sir . your very easy to way of teach.
Thanks
No way sir unga Madiri no one teach. Simply superb and it should be go on.👍
Thanks. Keep watching.
Broo rmbhaa superaa puriyuthu broo...konjaa SQL developer fresher oda resume epdii irkaanuu slii oru video podungaa broo
well explained sir.. Thank you so much.. Please keep uploading videos.. waiting for your updated videos
Thank you, I will
Excellent, very interesting. Keepit up sir.ur Every word is examination and interview pointofview nice.
Many many thanks
Well explained sir!! Please keep posting videos it really helpful for us.
Thank you, I will
Very well explained sir.. Thank you so much.. Please keep uploading videos.. Great effort sir👍
Keep watching. Thank You.
nalla understand aaguthu bro, continue it bro
Sure, Please like the video and keep watching other videos
Plsql developer and production support video poduga
Sir have one doubt.VARCHAR2(3 CHAR)-this means what sir.can u please explain this when u free. when i create the table and given the datatype sql its showing in drop down.
It means varchar2(3)
@@NICITACADEMY thank 🙏 you sir.
Very good and clear cut explanation sir....tqsm 👌 👍....plz upload java collection framework sir🙏🙏
Thanks for your feedback, but I do not have much experience in Java. I will upload more Oracle and ETL videos.
@@NICITACADEMY kk sir kk🤗🤗
Rollback to b means b Ku next record la irundu last record Vara rollback aguma
up to 'B' it will be rolled back, just do practice, you will come to know.
Commands run panraduku shortcut solunga sir
Ctrl+enter
Thank you very very much.
You are welcome!
well explained.. keep rocking... it is very useful..
Thanks a lot
Could you post video SQL and plsql program video perday two videos podunga sir.
Keep rocking this is very useful
Thanks a lot
Really useful. Are you providing training session. I am interested to join
Hi, Thanks. Yes, Please contact @nicitacademy@gmail.com. I am handling it. Keep watching my channel.
No explain for Merge cammand
I will post separate video for Merge. Keep watching.
Superb..... Explanation.... Great Job....
Thanks a lot
1.ithu oru Fron-end App-la order complete aanathu.
atha customer-la manula delete panna mudiyala
athai nan 'Database'-la delete pannanum.
2.எனக்கு ஒரு table-ல particular old column-அ delete பண்ண சொல்லறாங்க அப்ப column-மட்டும் delete-ஆகுமா இல்ல அந்த column-த்தோட தொடர்புடைய எல்லா row-வும் delete ஆகுமா .
3.அப்படி delete பண்ணனும்னா எப்படி query use பண்றது plz update .
4.I mean oru 100 old ID-nu solranga particulara athai mattum epadi delete panrathu.
Could you explaine CONDITIONAL EXPREESSION(CASE,DECASE)
Sure I will post. Keep watching my channel
@@NICITACADEMY thank you sir.
WOW..WELL EXPLAINED SIR
Thanks and welcome. Keep watching.
42:41 How to change the length of PRODID Column. Could any one help me please
Good initiative bro.
Thanks a ton
Sir Got an error while insert into datas like product_Id,name,etc..,(
Error starting at line : 17 in command -
insert into Product
(Product_Id,Product_Name,Manu_Date,company_name,unit_Price,Category_Name)
Values(37001,'Bingo',to_date('01/20/2024','mm/dd/yyyy'),'ITC',1752,'Snacks')
Error report -
ORA-01950: no privileges on tablespace 'USERS') Kindly do the needful
Sir is there any mobile sites to workout oracle ? Because i dont have a laptop.
livesql.oracle.com/apex/f?p=590:1000
Sir all the topics are well explained but can you please tell about the difference between truncate and drop function because both are DDL statement and both will delete the table and cannot rollback then why it has both name?
Thanks, I have posted the video already on this topic. Kindly check in SQL Playlist.
Truncate is a DDL command whereas Delete is a DML command
Similarly , truncate will delete entire data in the table whereas delete command can Delete entire data as well as partial data using Where clause
In Truncate rollback can't be achieved whereas in Delete we can rollback
Truncate will not delete the column names. It is like having a blue print of the table with no data in it. Drop will delete the whole table. After Truncate, you can still view the table. But no data will be there. After Drop, you cannot view the table. It will be gone forever.
Why did not still come yesterday video sir.
I need to learn plsql...This oracle sql and plsql are same ??
Plsql will have Procedural language, SP, Function, package, trigger, collections, cursor, etc.. SQL is base for all.
@@NICITACADEMY thank u sir..
@@NICITACADEMY Can I go for Oracle sql..is this related to plsql
Yeah, First learn SQL and Practice more, then go for PLSQL... watch my channel, SQL in 6 hours, that is more than enough. Keep watching.
Exhalent sir
Sir SQL + plsql rendume kandippa learn pannanuma Ila SQL full ah terinjale job Ku ok va
Only SQL also fine but you need to be very very strong. PLSQL we can learn quickly if you know SQL very well.
Tanks a lot sir
If I want to change the column name with out mention the table it is possible
Great
Tq so much
Welcome 😊
ORA-01950: no privileges on tablespace 'USERS' error keeping show bro how to solve
Please watch my Oracle 21C installation video. You can install without issues.
hello sir ,
table product created
but
query results not showing sir
can u pls tell me where is icon of query results?
Enable to query result windows in view.
@@NICITACADEMY sir cant get it.
Sir would like to join a course for informatica etl do you take sessions if so kindly let me know about the payment details and the time slot .
Yes, sure. Please contact @nicitacademy@gmail.com
Datastage videos podunga
Sorry DataStage I do not have experience. I will try my level best. Keep watching my channel.
Thanks
Welcome. Thanks Kiruba for your Thanks. Keep watching my channel.
ORA-12988: cannot drop column from table owned by SYS
12988. 00000 - "cannot drop column from table owned by SYS"
*Cause: An attempt was made to drop a column from a system table.
*Action: This action is not allowed
Please advise.
why you want to drop system tables?
I am working as sys@xe is that wrong
Hi, can we get whatsapp group link. Link in description is not working.
I will check and update
I need to learn plsql...This oracle sql and plsql are same ??