Day 7 - SQL in TAMIL | Oracle SQL Sub Queries TAMIL | SQL tutorial for beginners in Tamil
HTML-код
- Опубликовано: 10 сен 2021
- #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.com/Gjv1mone1bd...
🌕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.com/file/d/11kKE...
*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
ruclips.net/p/PLsphD3EpR7F9mmtY2jBt_O8Q9XmvrhQEF
📌*IICS demo session:*
ruclips.net/video/C1zGVRFM3-A/видео.html
📌*Informatica Full Course:*
ruclips.net/video/V2FtZ_INmjg/видео.html
📌*SQL Full Course:*
ruclips.net/video/iuvzjf7nU1I/видео.html
📌*Informatica, IICS, and SQL playlist*
🌕 IICS Tutorial ENGLISH - Playlist
ruclips.net/p/PLsphD3EpR7F9sqnL3R0jeETHP08Touklj
🌕 Informatica training in ENGLISH - Playlist
ruclips.net/p/PLsphD3EpR7F9HtxQHfoRAStSWAuF7zBfd
🌕 Informatica Interview Preparation - ENGLISH
ruclips.net/p/PLsphD3EpR7F-z_PFoL-uFc9_4DEnYsR3d
🌕Oracle SQL - தமிழில்
ruclips.net/p/PLsphD3EpR7F-u4Jjp_3fYgLSsKwPPTEH4
🔵 Informatica training in தமிழில் - Playlist
ruclips.net/p/PLsphD3EpR7F8dOIX6bhpv3fnZ8Io_WrH3
🔵 Informatica Interview Preparation - TAMIL
ruclips.net/p/PLsphD3EpR7F8MoCdaGFY_xO7mMfT3fvnD
🔵Unix for Informatica Developer
ruclips.net/p/PLsphD3EpR7F8jeo31oVNJ0yG9AaD-5_jw
🌕Informatica Project videos
ruclips.net/p/PLsphD3EpR7F98r1Mp4QGT9iYmTNwyzPa6
Please subscribe, Like, and comment. I will post more videos.
Thanks
Clear explanation of topics in one video... Thank you sir👍
You're most welcome
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.
Nice clear and detailed explanation thank you so much sir.
So nice of you
COULD YOU POST SUBRACTING VIDEO AS TO WHAT IS THE INDEX ORGANIZED TABLE SIR.
🙏
Please upload answers for exercise questions
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
when views topic videos upload that could you post as to materialized views topic step by step with details explanation ....
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.
Hi, good afternoon sir, In subqurey what is meant by scalar subqurey and inline view? Is this important or not in real time project?
Please complete remaining 3 days sql vedios and dml merge and correlate subquery.......thank you sir.😊
I will try my best
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()...
When will you star plsql procedure language session sir.
When will you start performance tunning session
What happens sir did not still come videos for the past two days vedios.
When will you start interview questions session sir.
Sir waiting for session 8..
When will you post last two days videos and tomorrow video sir.
Where should i get queries ,to practice
Can't found day 7 notes(I need subquery notes)
Hi Sir,
Please upload the SQL videos in English. In english, only we have 6 videos.
Will upload soon
Sir,
i have one doubt please clarify
can we use GROUP BY key word outside the aggregate and analytical functions in SQL QUERY ?
Yes we can use, depends on the scenario how we are writing the query(like sub query)
corelated sub Query soluga bro
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
Yes, we can use. Since it is PK, It will not have any null values. So count will match with count(*)
@@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;
Sir, Im not getting the default employees, departments, locations table for practice. Can you pls guide me to get the table pls
please install oracle 11g, or watch my 21c installation video and import HR schema for practice.
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;
Very Good, Keep it up, Keep watching my channel.
@@NICITACADEMY
Sir, I am eagerly waiting oracle SQL videos from your channel
9 and 10 th question - answers were not appropriate. could you pls re-check?
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;
06. To find youngest person, you have to use MAX(dob) not MIN(dob).
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
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.
@@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
@@NICITACADEMY please share the link for updating the resume
Why sir did not come vedios for the past two days
I ll post soon.
@@NICITACADEMY thank you sir
sir ithula excel tables enga iruku
Hi, Please create the tables and practice.
ok sir
Sir 3r max salary query pls send
🙏