Day 3 - Oracle SQL for Beginners |Oracle SQL Tutorial | Oracle SQL for Beginners | SQL for beginners
Вставка
- Опубліковано 7 лют 2025
- #JUSTIN#ORACLE#SQL#TAMIL#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers
========================================================
Self-Paced course: courses.nicita...
⏬ Like the video and comment if you have questions
👉WhatsApp group for SQL/PLSQL discussion✅
chat.whatsapp....
🌕For Live training contact me on WhatsApp (+91 7010080468) or below link
wa.link/m4lat0
✅SQL Tutorial Full course with notes
• Master Oracle SQL in 2...
(📢Trainer: Chandra - A Tableau and Informatica, AWS Certified Professional)
📌Having 16+ years of IT experience in Banking, Insurance, and Retail domain
📌Handling corporate and Live training sessions last 10 years
========================================================
📌 Oracle 21C Installation: with software: (How to import HR Schema in Oracle 21C)
• Oracle 21c installatio...
Oracle 11g Installation:
• Oracle 11g Installatio...
==========================================================================
🔵Oracle SQL Tutorial - English
• Oracle SQL Tutorial - ...
🌕Oracle SQL - தமிழில்
• Oracle SQL - தமிழில்
📌 Oracle SQL Day wise Video: ENGLISH
Oracle SQL Day 1 - Introduction to Oracle - • Oracle SQL Day 1|Oracl...
Oracle SQL Day 2 - SQL Types DDL, DML, DRL, DCL, TCL - • Day 2 - Oracle SQL for...
Oracle SQL Day 3 - Constraints in Oracle - • Day 3 - Oracle SQL for...
Oracle SQL Day 4 - SELECT Statements in Oracle - • Day 4 - Oracle SQL for...
Oracle SQL Day 5 - Single Row Functions in Oracle - • Day 5 - Oracle SQL for...
Oracle SQL Day 6 - Joins in Oracle - • Day 6 - Oracle SQL for...
Oracle SQL Day 7 - Aggregate Functions in Oracle - • Day 7 - Aggregate Func...
Oracle SQL Day 8 - Sub Queries in Oracle - • Day 8 - Sub queries in...
Oracle SQL Day 9 - SET Operators in Oracle - • Day 9 - SET Operators ...
Oracle SQL Day 10 - Analytical Functions in Oracle - • Day 10 - Analytical | ...
Oracle SQL Day 11 - Views in Oracle - • Views in Oracle | Norm...
Oracle SQL Day 12 - Indexes in Oracle - • Index in Oracle | Norm...
Oracle SQL Day 13 - Regular Expression - • Oracle SQL Tutorial - ...
**********************************************************************************
📌 Oracle SQL Full Course in 6 hours - TAMIL
• Master SQL in 6 Hours ...
📌Oracle SQL Day wise Video: TAMIL
-----------------------------------
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 Interview questions:
sql interview questions and answers,
sql server interview questions and answers,
sql questions and answers,sql interview questions for testers,
sql interview questions for freshers,sql interview questions pdf,
sql interview questions for beginners,sql interview questions,
sql interview questions for data analyst,
sql interview questions youtube,
sql interview questions for business analyst,
sql interview questions for experienced,
interview questions sql,
oracle interview questions,
sql interview questions,
top 50 oracle interview questions,
oracle interview questions ,
oracle pl sql interview questions and answers,
intermediate level sql interview questions,
oracle dba interview questions and answers,
top 50 oracle interview questions ,
oracle interview questions for experienced,
interview questions sql,
sql interview questions and answers,
sql interview questions for freshers,
sql interview preparation
==========
SQL Notes:
==========
⏬Oracle Day 03 - Constraints
drive.google.c...
✅SQL Tutorial Full course
• Master Oracle SQL in 2...
✅Oracle 11g Installation: • Oracle 11g Installatio...
✅Oracle 21C Installation: • Oracle 21c installatio...
*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
I really don't know how to say thank you.
These tutorials are really helpful.😍😍😍
You're welcome 😊Keep watching my channel.
it's wonderful tell you that i learned Oracle SQL only Watching this Series
thank you so sir 👌
You are most welcome
Crystal clear explanation sir.. thankyou .. well done
You are welcome. Thanks for your feedback. Keep watching my channel.
Thank you sir.... Woow ....per day two videos that's it what I expect from you sir....keep rocking...sir...😊
Most welcome 😊. I am also trying to upload more videos.
@@NICITACADEMY nice sir.....keep rocking sir....😊
you are life saver sir😇..
Thanks, keep watching my channel.
I am a student of you sir in intellipaat for informatica.. I am addicted to your teaching. Keep rocking.
All the best. Keep watching.
I am going through your daily videos, the concepts are loaded with wealth of information which is very difficult to learn if not practically worked. BTW I am preparing to relaunch my career so I know the depth of knowledge in it.
Please do advance SQL concepts videos. Thank you.
Thanks a lot for ur wonderful videos.
Thanks and Welcome. Keep watching my channel.
@@NICITACADEMY definitely 👍👍
Will ask doubts also..
Dear Sir,
Lecture note is not available in google drive. You are doing an amazing work. Thank you very much
Available here: nicitacademy.com/interview-questions/
Thank you very much sir...
Nice video 👍👍
Thank you 👍
unable to download the SQL notes which you have shared in the description. It shows Sorry, the file you have requested does not exist.
nicitacademy.com/interview-questions/
Hi Sir
Thanks for making video records for us.
do we get all the recorded videos
Yes, please check playlist
sir how do we practice it ? you have given so many information and do we need to type entire sql code and check how this constraints work ?
Please check the description, go to my Oracle installation video. Install oracle 11g or 21C and start practicing it.
I can't able to find the notepad links of the practice notes. Can you please guide where can i find those?
please check the description, I have already attached SQL notes.
select * from all_constraints where owner='HR' and table_name='CUSTOMER';
i am not getting any results showing blank
where are you running this query? ADMIN schema or HR schema?
Sir Please complete all the topics.. we need all the topics.
Sure I will upload.
I am not able to get the notes as tried opening link but content is not available
Ok sir but If Multi primary keys available in one table, we will accept or not?
It will accept, That is composite Primary key. I have explained. please watch full video in the playlist.
@@NICITACADEMY okay, thank you
In your honesty opinion, how long should it take to learn SQL to a functional level for someone starting out from ground 0 who is putting in good study time?
Good question. As per my view, it will take 1 month to master SQL. Please start watching my SQL videos regularly and most importantly practice.
Install Oracle database and practice.
You'll see the transformation after some time.
day 3 notes is not updated in the notes link.. Thanks
where can i get assignments
need to work on your assignments if possible let me know where can i find the assignments for this topic
Hi sir!!! Realy grt content ur providing!!
I got one error that is
I have created one schema named 'mydata' .
Select *from all_constraints where owner ='mydata' and table_name='customer'
For this I'm getting empty table..!!
Any solution for this plsss!!???
As I have explained in my video, Oracle is case sensitive. make use of lower() or upper().
Hi sir,
I'm getting the column names as query result but the list of constraints are not showing to me.. please solve this problem. Thank you
Please solve my problem sir..if possible
Where will I get excercise files..pls reply
Oracle will support ON UPDATE CASCADE constraint or not?
Yes, It will support.
CASCADE: Delete or update the row from the parent table and automatically delete or update the matching rows in the child table. Both ON DELETE CASCADE and ON UPDATE CASCADE are supported. Between two tables, do not define several ON UPDATE CASCADE clauses that act on the same column in the parent table or in the child table.
sir please upload more SQL videos
Sure. I ll do. Keep watching my channel
create table customer
(
cust_id number(8) primary key,
cust_name varchar2(25) not null,
mobile number(10) unique check (length(mobile_no)=10),
age number(3) check(age>=18),
city_id number(4) references city(city_id)
);
Error report -
ORA-02438: Column check constraint cannot reference other columns
02438. 00000 - "Column check constraint cannot reference other columns"
*Cause: attempted to define a column check constraint that references
another column.
*Action: define it as a table check constriant.
Mobile and mobile_no... Column name is different.. correct it
Please send me the notes for key constraints
The link has Day 2 notes instead of Day 3 Notes. Can you please check and provide link for Day 3 Notes please
Hi sir Please upload SQL continue videos plzzzzzzzzzzzzzz
Sure I will
In description you gave again day 2 notes only, please add day 3 notes
Day 2 notes has the queries which I took in this session. Kindly check and practice.
Am getting no rows selected when I tried to see all constraints
What can be the reason sir
Did u get the solution bro!!???
Here use owner='hr' why we use this
Owner='HR' is the schema(user) name.
Please watch Day - 01 session, I explained.
Sir please upload all the topics in English ASAP 🙏
Sure, I will do.
Hi Sir..please share link for Day3 notes file
Okay, I will update
@@NICITACADEMY Hi..Your explanation is good..I am starting to watch videos one by one ..I didn't find constraints notes..pls forward..TYSM..
Can not able to get notes
nicitacademy.com/interview-questions/