Day 2 - Oracle SQL for Beginners |Oracle SQL Tutorial | Oracle SQL for Beginners | SQL for beginners
HTML-код
- Опубликовано: 28 сен 2024
- #JUSTIN#ORACLE#SQL#TAMIL#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers#oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers
========================================================
🌕Want to join WhatsApp Group? (Only technical discussion, no spam messages, no promotion msg)
📌chat.whatsapp....
🌕For more details contact me on WhatsApp (+91 7010080468) or below link
wa.link/m4lat0
========================================================
📌 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
• SQL tutorial TAMIL | ...
📌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 SQL Day 2 - SQL Types DDL, DML, DRL, DCL, TCL
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
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
Hi
Thank you for your detailed class on SQL. Really useful and very easy to learn SQL from your video
Glad to hear that
Hello! Hope you are doing well. I recently started with this playlist and I must say it is really helpful for developing our concepts from scratch even for a newbie. I have a query though as there are so many various statements, what is the possible way to memorize it? Or is there even the need to memorize it or just understanding it is enough?
Thank you sir for your clear explanation, please do upload the remaining sessions sir..
Sure I will
sir which software are u using
Explanation is good but it doesn't feel like for the Beginniers
Thanks for your feedback, Please let me know your pain points.
I will try to accommodate in the future session. I will try my level best.
Your way of explaination are good but i am a fresher to sql,so bit difficult to understand like you used modify, set, where, and used alter with dml statments as well no guidence were given before when we should use alter as statment and before which statment like i thought it is only used for altering structure but it is used for altering data as well..
Can we insert multiple rows in a single insert command?
Thank you very much Sir.
You are most welcome
Thank you Sir..
Most welcome
Google drive link not exist. Can you provide the notes Sir
good explanation sir
Thanks and welcome
while doing alter table customer drop column city m getting error as below: Error report -
ORA-12988: cannot drop column from table owned by SYS. how do i resolve?
I think you are dropping from system owned meta data tables. don't drop the column.
you can drop your own table column only, not with admin tables.
Hi sir,
Could you please upload SQL scenario based questions and answers
Okay. I ll do. Keep watching my channel
Hello sir please upload rest of the sessions like tamil
Sure I will do
Why don't you start up a new company...... your videos are very effective and good explanation
Thank you, Your wish will come true soon.
I am great fan of you sir
Hi sir
I have tried to download the notes but I can't download.
Sorry, the file you have requested does not exist. When I click on link It's showing like this
nicitacademy.com/interview-questions/
Thank you sir......😊
Most welcome
*Which are common errors for insert into statement Oracle sql?*
Some common errors that can occur with an INSERT INTO statement in Oracle SQL:
1. *Syntax errors*: Missing or incorrect keywords, parentheses, or commas.
2. *Data type mismatch*: Trying to insert a value with a data type that doesn't match the column's data type.
3. *Column name errors*: Misspelling or incorrect column names.
4. *Primary key violations*: Trying to insert a duplicate value into a column with a primary key constraint.
5. *Foreign key violations*: Trying to insert a value that doesn't exist in the referenced table.
6. *Check constraint violations*: Trying to insert a value that doesn't meet the condition specified in a check constraint.
7. *Not null constraint violations*: Trying to insert a null value into a column with a not null constraint.
8. *Invalid values*: Trying to insert invalid values, such as a string into a date column.
9. *Inserting too many values*: Trying to insert more values than there are columns.
10. *Inserting too few values*: Trying to insert fewer values than there are columns.
11. *Using incorrect quotes*: Using single quotes instead of double quotes for column names.
12. *Using reserved keywords*: Using Oracle reserved keywords as column names without proper quoting.
13. *Invalid use of subqueries*: Using a subquery that returns more than one row or column.
14. *Trigger errors*: Errors caused by triggers firing during the insert operation.
15. *Privilege errors*: Lack of necessary privileges to perform the insert operation.
These are just some of the common errors that can occur with an INSERT INTO statement in Oracle SQL.
Hai where I can get the notes and where to download.? Can anyone help me?
See the description of this video. There is a link. Download it
Really very simple and useful vedio
Hello sir, There is no notes pinned in description section. If the notes is provided it would be truely helpful. Thanks
updated, please check now
Thank you Chandra for your educative videos. I learnt Oracle basics from the scratch... as a self-learner.
Wonderful! Keep watching my channel.
How to join watsapp group
hi sir please do full vedios on etl sraging course
Where is the link for day wise notes you show in the video. Because the google drive notes link seems little different
Please check the description
Yes I have but it is not same as the day wise notes you refer in the video could we please get those notes ?
If i drop a table can rollback again
No, we can't rollback. Drop is a DDL command.
Once dropped, we can't rollback.
Only DML statements can be rolled back.
Thank you very much sir.. which is really help us so much. Crore thanks to you.
You are most welcome. Keep watching my channel and practice. Like and share my videos.
Sql common interview ques. Videos podunga sir.
Will upload soon
Tq so much it's very helpful sir
Most welcome
Thank you very much sir...
Most welcome
Where I can get notes