Day 7 - SQL in TAMIL | Oracle SQL Sub Queries TAMIL | SQL tutorial for beginners in Tamil

Подписаться 106 тыс.

Просмотров 16 тыс.

50% 1

#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 Playlist : sql tutorial for beginners in tamil
• Oracle SQL - தமிழில்
*********************************************************************************************
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...
**********************************************************************************************
Oracle PLSQL Training in Tamil - தமிழில்
• Oracle PLSQL Training ...
**********************************************************************************************
Oracle Installation - தமிழில்
• Oracle Installation - ...
**********************************************************************************************
Python in Tamil - பைத்தான் ரொம்ப ஈஸி - தமிழில்
• Python in Tamil - பைத்...
**********************************************************************************************
Informatica Training in Tamil தமிழில்
• Informatica Training -...
In this video, we’ll learn
oracle joins in tamil
oracle tutorial in tamil
oracle self join
oracle tamil
oracle joins
sql in tamil
oracle equi join
oracle cross join
sql joins tutorial
oracle natural join
sql joins with examples
oracle non equi join
oracle outer join
oracle full outer join
oracle left outer join
sql joins explained
sql joins
complete sql tutorial
oracle right outer join
sql for beginners tamil
oracle tutorial for beginners
sql programs tamil
oracle subquery in tamil,sub query in sql server tamil,oracle subquery tamil,oracle in tamil,sub query sql server tamil,oracle tutorial tamil,oracle tamil,oracle tutorial in tamil,sql server tutorial tamil,oracle tamil tutorial,sql server tips & tricks tamil,oracle subqueries,oracle subquery with insert,oracle subquery with update,oracle inline view,oracle subquery,oracle subquery with delete,oracle exists and not exists,oracle tutorial
oracle subquery in tamil
sub query in sql server tamil
oracle subquery tamil
oracle in tamil
sub query sql server tamil
oracle tutorial tamil
oracle tamil
oracle tutorial in tamil
sql server tutorial tamil
oracle tamil tutorial
sql server tips & tricks tamil
oracle subqueries,oracle subquery with insert
oracle subquery with update
oracle inline view
oracle subquery
oracle subquery with delete
oracle exists and not exists
oracle tutorial
oracle joins in tamil
oracle tutorial in tamil
oracle self join
oracle tamil
oracle joins
sql in tamil
oracle equi join
Oracle Interview questions:
==========
SQL Notes:
==========
drive.google.c...

Опубликовано:

5 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 53

@NICITACADEMY 2 года назад

*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 ru-vid.com/group/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF 📌*IICS demo session:* ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-C1zGVRFM3-A.html 📌*Informatica Full Course:* ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-V2FtZ_INmjg.html 📌*SQL Full Course:* ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iuvzjf7nU1I.html 📌*Informatica, IICS, and SQL playlist* 🌕 IICS Tutorial ENGLISH - Playlist ru-vid.com/group/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj 🌕 Informatica training in ENGLISH - Playlist ru-vid.com/group/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd 🌕 Informatica Interview Preparation - ENGLISH ru-vid.com/group/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d 🌕Oracle SQL - தமிழில் ru-vid.com/group/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4 🔵 Informatica training in தமிழில் - Playlist ru-vid.com/group/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3 🔵 Informatica Interview Preparation - TAMIL ru-vid.com/group/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD 🔵Unix for Informatica Developer ru-vid.com/group/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw 🌕Informatica Project videos ru-vid.com/group/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6 Please subscribe, Like, and comment. I will post more videos. Thanks

@yazhb4403 3 года назад

Clear explanation of topics in one video... Thank you sir👍

@NICITACADEMY 3 года назад

You're most welcome

@krishnanselvam786 3 года назад

Can you post upload total three videos to Perday 1.plsql developer procedure language 2.interview questions 3.performens tunning Please upload to every day three videos sir.

@krishnanselvam786 3 года назад

Nice clear and detailed explanation thank you so much sir.

@NICITACADEMY 3 года назад

So nice of you

@muhammadafridi3946 3 года назад

sir, I have submitted here answer of practice questions please rectify my answer 01. select count(emp_id) from employee; 02. select count(*) from employee GROUP BY city_name; 03. select count(*) from employee GROUP BY country; 04. select emp_id,count(*) from employee WHERE UPPER(country)='INDIA' GROUP BY emp_id; 05. select count(emp_id) from employee WHERE UPPER(country)='INDIA' GROUP BY emp_id HAVING count(emp_id) > 3; 06. select MIN(dob) from employee; 07. select MAX(dob) from employee; 08. select skillset,count(*) from employee GROUP BY skillset; 09. select emp_name,count(*) from employee GROUP BY emp_name; 10. select emp_id,count(*) from employee GROUP BY emp_id;

@NICITACADEMY 3 года назад

Very Good, Keep it up, Keep watching my channel.

@muhammadafridi3946 3 года назад

@@NICITACADEMY Sir, I am eagerly waiting oracle SQL videos from your channel

@pramanayak Год назад

9 and 10 th question - answers were not appropriate. could you pls re-check?

@pramanayak Год назад

9.Is there any employee with same name? select emp_name,count(*) from employee group by emp_name having count(*) >1; 10.Is there any duplicate employee_id? select employee_id,count(*) from employee group by employee_id having count(*) >1;

@m46thangaraj38 Год назад

06. To find youngest person, you have to use MAX(dob) not MIN(dob).

@purushoth5444 3 года назад

🙏

@sanjeevehandpicks Месяц назад

Sir 16:46 Could you please explain the below query? Please tell me the difference and Why SELECT DEPARTMENT_ID, SUM(SALARY) FROM EMPLOYEES GROUP BY DEPARTMENT_ID HAVING SALARY > 50000 Thanks

@krishnanselvam786 3 года назад

COULD YOU POST SUBRACTING VIDEO AS TO WHAT IS THE INDEX ORGANIZED TABLE SIR.

@krishnanselvam786 3 года назад

Please complete remaining 3 days sql vedios and dml merge and correlate subquery.......thank you sir.😊

@NICITACADEMY 3 года назад

I will try my best

@vickyraina1281 6 месяцев назад

Hi, good afternoon sir, In subqurey what is meant by scalar subqurey and inline view? Is this important or not in real time project?

@krishnanselvam786 3 года назад

COULD IT POST VIDEOS AS TO ANALYTICAL FUNCTION WITH DETAILS EXPLAINATION SIR. RANK() DENSE RANK() ROW_NUMBER() LEAD() LAG() LISTAGG() ROLLUP() CUBE() FIRST_VALUE() LAST_VALUE()...

@krishnanselvam786 3 года назад

when views topic videos upload that could you post as to materialized views topic step by step with details explanation ....

@cemanivannan27 3 года назад

please give me an excel file for sample data and notes also, it's made easy to practices us. I'm waiting for your reply.

@musicloverz802 2 года назад

Please upload answers for exercise questions

@arvinthbabukrishnamoorthy8599 Год назад

hello sir can u pls tell me where to access the attached excel sheet for practice.. i tried to get it from description of this video but i couldnt

@krishnanselvam786 3 года назад

When will you star plsql procedure language session sir.

@kranthikumargoalla2502 2 года назад

Hi Sir, Please upload the SQL videos in English. In english, only we have 6 videos.

@NICITACADEMY 2 года назад

Will upload soon

@krishnanselvam786 3 года назад

When will you start performance tunning session

@krishnanselvam786 3 года назад

When will you start interview questions session sir.

@krishnanselvam786 3 года назад

When will you post last two days videos and tomorrow video sir.

@vijisimely6917 Год назад

Where should i get queries ,to practice

@krishnanselvam786 3 года назад

What happens sir did not still come videos for the past two days vedios.

@mahalakshmi-wi4br 2 года назад

Can't found day 7 notes(I need subquery notes)

@yazhb4403 3 года назад

Sir waiting for session 8..

@muhammadafridi3946 3 года назад

Sir, i have one doubt please clarify can we use GROUP BY key word outside the aggregate and analytical functions in SQL QUERY ?

@NICITACADEMY 3 года назад

Yes we can use, depends on the scenario how we are writing the query(like sub query)

@muhammadafridi3946 3 года назад

Sir, I have one doubt in practice question 5 in question 5 can we put "count(emp_id) and having count(emp_id) >3" ? please explain me

@NICITACADEMY 3 года назад

Yes, we can use. Since it is PK, It will not have any null values. So count will match with count(*)

@muhammadafridi3946 3 года назад

@@NICITACADEMY sir, I have submitted here answer of practice questions please rectify my answer 01. select count(emp_id) from employee; 02. select count(*) from employee GROUP BY city_name; 03. select count(*) from employee GROUP BY country; 04. select emp_id,count(*) from employee WHERE UPPER(country)='INDIA' GROUP BY emp_id; 05. select count(emp_id) from employee WHERE UPPER(country)='INDIA' GROUP BY emp_id HAVING count(emp_id) > 3; 06. select MIN(dob) from employee; 07. select MAX(dob) from employee; 08. select skillset,count(*) from employee GROUP BY skillset; 09. select emp_name,count(*) from employee GROUP BY emp_name; 10. select emp_id,count(*) from employee GROUP BY emp_id;

@vinayakavini5334 3 года назад

No calls getting calls for plsql developer having 3.5 years.. I dont know this sql has future or not to survive in IT industry

@NICITACADEMY 3 года назад

Hi, It's depends on various factor, experience, company, notice period, your resume, skillset updated. So this Oracle is there in market for last 40+ years and they already moved to Cloud applications. We have lot of opening and check my video how to update resume, and in job portal. You will get the call as many as and also SQL is basic for all the cloud and edge computing. so have confident on learning, it will pay you as much as for your effort. Thanks.

@vinayakavini5334 3 года назад

@@NICITACADEMY hello sir please help to change my job. I got stuck in one company not able switch. I am confident in plsql. I dont what exact require in current situation

@vinayakavini5334 3 года назад

@@NICITACADEMY please share the link for updating the resume