Oracle SQL for Beginners | SQL Complete Tutorial for Beginners | SQL Full Course | SQL Tutorial
Vložit
- čas přidán 16. 06. 2024
- #oracle#sqlinterviewquestions#sqlinterviewquestionsandanswers#SQLTutorialForBeginners #SQLFullCourse #SQLCourseForBeginners #SQL #LearnSQLForBeginners #SQLForBeginners #SQLTutorial #SQLCourse #SQLTraining #LearnSQLIn7Hours #sqlstructuredquerylanguage
=====================================================================
📢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/GdkGpLKfwYN...
🌕For Live PLSQL training 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...
Chapters:
=========
0:00 Introduction
1:00 Oracle 21C Installation, How to import HR Schema in Oracle 21C
20:46 test failed IO error the network adapter could not establish the connection oracle
23:09 Day 1 Oracle SQL tutorial for beginners, how to create table in SQL, alter table in SQL
46:46 Day 2 DDL, DML, DRL, TCL, DCL in Oracle SQL
01:20:06 Constraints in Oracle, Primary key, foreign key, Not null, check constraints, Unique
01:50:10 Day 4 - Select statement in Oracle
02:25:08 Single row functions in Oracle SQL
03:26:38 Joins in Oracle SQL, Left outer join in SQL
04:09:48 Aggregate functions in Oracle SQL, min, max, sum, avg, count, group by, having
04:58:09 Subqueries in Oracle SQL
05:53:13 SET operators in Oracle SQL
06:23:37 Analytical or Window Functions in SQL
06:59:30 Oracle SQL quizzes, Oracle SQL interview questions and answers for experienced
-----------------------------------------------------------------------------------
📌 Oracle SQL - Complete tutorial Playlist
• Oracle SQL Tutorial - ...
*****************************************************************************************************
📌 Oracle SQL - Complete tutorial Playlist - ENGLISH
• Oracle SQL Tutorial - ...
*****************************************************************************************************
📌 Oracle SQL Day wise Video: ENGLISH
Oracle SQL Tutorial - Day 1 - • Oracle SQL Day 1|Oracl...
Oracle SQL Tutorial - Day 2 - • Day 2 - Oracle SQL for...
Oracle SQL Tutorial - Day 3 - • Day 3 - Oracle SQL for...
Oracle SQL Tutorial - Day 4 - • Day 4 - Oracle SQL for...
Oracle SQL Tutorial - Day 5 - • Day 5 - Oracle SQL for...
Oracle SQL Tutorial - Day 6 - • Day 6 - Oracle SQL for...
Oracle SQL Tutorial - Day 7 - • Day 7 - Aggregate Func...
Oracle SQL Tutorial - Day 8 - • Day 8 - Sub queries in...
Oracle SQL Tutorial - Day 9 - • Day 9 - SET Operators ...
Oracle SQL Tutorial - Day 10 - • Day 10 - Analytical | ...
**********************************************************************************
📌 Oracle SQL Full Course in 6 hours - TAMIL
• SQL tutorial TAMIL | ...
📌Oracle SQL Day wise Video: TAMIL (Playlist)
********************************************************************************************
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 for beginners,
sql interview questions,
sql interview questions for data analyst,
sql interview questions for business analyst,
sql interview questions for freshers
Oracle SQL Day 1 - Introduction to Oracle
drive.google.com/file/d/1Dn9c...
Oracle SQL Day 2 - SQL Types DDL, DML, DRL, DCL, TCL
drive.google.com/file/d/19Tvb...
Oracle SQL Day 3 - Constraints in Oracle
drive.google.com/file/d/1x6b8...
Oracle SQL Day 4 - SELECT Statements in Oracle
drive.google.com/file/d/16Ma6...
Oracle SQL Day 5 - Single Row Functions in Oracle
drive.google.com/file/d/1ML6M...
Oracle SQL Day 6 - Joins in Oracle
drive.google.com/file/d/1HE3j...
Oracle SQL Day 7 - Aggregate Functions in Oracle
drive.google.com/file/d/17DzH...
Oracle SQL Day 8 - Sub Queries in Oracle
drive.google.com/file/d/1B039...
Oracle SQL Day 9 - SET Operators in Oracle
drive.google.com/file/d/1OAA2...
Oracle SQL Day 10 - Analytical Functions in Oracle
drive.google.com/file/d/16Slb...
======
Audio track credit:
Believe Music
*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
I think Views and Indexes not covered...? i need views and indexes..
I think Views and Indexes not covered...? i need views and indexes..
Nicita i have some questions to ask.?
Hi Sir I am almost half way of this video tutorial. Thanks a lot. Do you offer certification? How much does it cost?
How can count total vowel of emp first name,.... Can you help me
Thank you for your generosity and effort. You have described in simple English and hope you will continue this in future. Wish to learn PL/SQL in English. Best of luck !!
Thank you, I will create more videos.
Keep watching my channel.
one of the best lecture on oracle sql in YT, thank you tutor :)
Wow, thank you! Keep watching my channel.
Awesome video!! You have covered every basic topic..Thank you from the bottom of my heart Sir!!
Thanks
This video is useful for beginners . Kindly update the notes in description link .
Thanks for making the video.
Fantastic class I have watched here. Very impressive, attractive teaching with interview questions. Salute gentle man👏👏
Thank you so much, Keep watching my channel.
Thank You Very Much For For Providing the Detailed SQL Explanation.
Glad it was helpful!
Thank you so so much sir and for wounderfull video sir.
Most welcome
Best tutorial till now. Your way of teaching simply awesome and clarifying every topic. Thanks for the video. Plz continue in English, im form Andhra Pradesh. Plz Try to make lessons on NOSQL Cassandra.
Thank You!
Thanks a ton, Sure I will do.
Thank u very much sir, very much appreciation for your hard work 🥰, Have a wonderful year😊
Thank you.
Thanks much Sir, this is what i was looking for 👍👍
Welcome 👍 Keep watching my channel.
when we think of any question during the session the very next moment the answer will be given:)...very well covering the concept.Thank you :)
Excellent
This tutorial is really impressive. thanks to the tutor.
You're welcome!
I found this tutorial very informative and useful, thanks for uploading. 🙏🙏
Glad it was helpful!
Excellent class, Presentation is very nice. Thank you sir
Thanks 🙏
Thank you so much Sir. All concepts get cleared now.
All the best
thank you so much,
it's very useful and neatly explained about installation and its problems
You are welcome
Superb presentation, almost everything is covered 👌. Thank you Sir 😊
Thanks 🙏
Kindly sir update the links for notes of subqueries and set operators, The video is wonderful, concepts have been defined in wonderful and simple way. Salute you.
would you please upload the notes of the same as they are not available till now as the spread sheet doesn't open
Thank yo so much sir, iam very impressive your sql class, so much of intrest watching vedios🤝👏
Thanks 🙏 Keep watching my channel
Thank you so much sir we are waiting this
You are most welcome.
thank you sir i interest learning sql increase because you teaching in tamil tune .you r teaching is easy to understand thank u sir
Thanks and welcome
sir, thank you so so much, I learned from scratch about oracle sql, I wish you all the happiness in your life. Keep up the great work sir.
Thanks, you too! Keep watching my channel, refer to your friends.
Thank you so much sir, your explanation is too good.
Thanks 🙏
Hats off Sir
U r efforts are great love ❤ u so much sir
Thank you so much 😀
Sir.Thank you for wonderful video on sql. please upload the notes also..ASAP
sir.yaar dislike pottalam kavalai padathinga .unga hard work kana palan nichayama kidaikum .so keep doing on post video sir. thevai irukiravanga vanthu learn pannikitum sir.dislike oduravangala pathi kavalai padathinga sir.😊
I have completed it in 10 days thank you very much.
Great job!
Please complete this as well.
czcams.com/video/yukL9vRalVo/video.html
Thank you so much, I'm really learn from your video and I thought it is best video for HTML on CZcams I got it .
Glad it was helpful!
hi, the links for the notes (Subqueries in Oracle SQL and SET operators in Oracle SQL) are not working. Can you please upload your notes so I can practice? Also, SQL quizzes and interview questions are not available. Thank you for everything.
I have seen alot of sql courses but this is the
Best ever video till now❤.
Thanks 🙏. Keep watching my channel.
@@NICITACADEMY eagerly waiting for PL/SQL
Goodjob👏
Thank you! Cheers!
Awesome video 👍
Thank you 👍
Thanks a lot Chandra. I am ETL tester & PowerBI developer with 2 YOE. I have completed this 7 hours course in one go in full night without taking any break to refresh my skills.I had this on my bucket list for many months. I got to know many things which I encountered before which I didn't understand like Implicit methods and Oracle functions. Great content. It's really useful for beginners and experienced as well.❤
Awesome, Great job! Keep watching my channel.
Thanks for the wonderful feedback.
Lots of doubts in correlated subquery , now cleared.
Its wonderful to hear from you. Keep watching my channel.
@@NICITACADEMY definitely bro 🤜, keep rocking always and put more videos.
Nice explanation... thank you
Thanks. Keep watching my channel
Awesome Course Sir ! i learned sql in 2 days need to practice , now i m ready to solve the competitive questions
thanks a lot
Thanks, Keep watching my channel.
@@NICITACADEMY pl/sql course ?
I will upload
@@NICITACADEMY i am waiting sir
Thank you for the amazing video 🙏
Glad you enjoyed it!
Thank You So much Sir
Most welcome
Great explanation sir
Thanks and welcome
We need to have some of our developers watch this!
Thank you. Glad it was helpful. Keep watching my channel.
I will post more videos.
Kudos to your efforts 😇
Thanks
Thq so much sir
Welcome
Entha topic studies related Ah search panuna unga channel name tha sir example sql nicit 😅 the way you are teaching we can understand very clear sir hatsoff ♥️♥️♥️♥️♥️♥️
Thank You, Keep watching my channel.
great explanation of the course...how do i get to the notes and practices like you said? Thanks
Sir you are best teacher ❣️
Thanks a ton
Thankyou Sir very good explaining
Most welcome
Thank you sir 🙏
Most welcome
Excellent Explanation🤗🥰💓✌👃👃🤩
Thank you 🙂
Thanks you sir for Videos, please make video on Stored procedure in SQL or oracle
Noted. Keep watching my channel
Sir, Could you please upload the notes. would be really helpful for me and many other students.
Hi Sir, very good conceptual explanation, I have a doubt at video time - 2hr:22mint , it is told that when salary of 10K is given to 4 employees, we have to sort the result set based on second column i.e hire date in seniority basis. By default a column is being sorted in ascending order. But here it's sorted in descending order according to you on seniority basis. If suppose ,hire date is mentioned in descending order then the result is correct but which is not mentioned. Can you clarify my doubt sir please?
thanx u so much nic it academy...
Most welcome
HI sir,
Thank you for this.
Please kindly share the note. that will be very helpful to memories this concept.
Amazing Explanation ❤
Thank you! 🙂
Tnq
nice thank you, you earned a subscriber
Thanks for the sub!
Tq..for sharing your knowledge sir. But it is an complete sql (or) only basics?
Thank u sir. Where are indexes and views tutorial??
Hello Sir It would be helpful if u share the notes here.. As there is no notes in description as u mentioned.
Hi Nic good morning Here in description there is no documents availabe for day 9, and 10. IN day 10 that is day 8 notes is available , Kindly update there no document available for instring and substirng and day 7 also updated the joins document. Please check once again and update
Thank You
You're welcome
Thanks!
Welcome!
Great work. Thank you. When can we expect PL/SQL full tutorial like this ?
I am working on it. I ll add soon
@@NICITACADEMY Thanks Sir!
Super
Thanks
hi. while creating new connection i gets network adapter error. i tried your steps to solve but, nothing happens .error is same and am not able to create new connection
Hello sir,can u explain realtime project also
Hi sir your explanation was amazing and also we want power bi course plz make it
Please check, Its already uploaded. I will upload more videos on Power BI.
czcams.com/video/-N6DT8fJS8I/video.html
Hi sir, Thank you for video, please make video on stored procedure in Oracle database 😮
courses.nicitacademy.com/
NYC sir super explanation but can i apply for fresher by this knowledge
Hi Sir,
I cannot see views and indexes in this tutorial, any other video for views and indexes ??
Thanks for giving this video..if we can use oracle live sql with your presentation script, it helps a lot
please check the description
@@NICITACADEMY please add more big data videos
Hello Sir,just like this video create one video on Oracle plsql.Thanks in advance.
Sure
what's the path you want to insert from linux or what is the steps I am using a docker on Mac computer
hi thank u for such technical videos, i want pdf format of SQL
HI ARUN SIR,
can u please give detail explanation about plsql...
Please upload sql product support job roles and responsibility s
Also pls cover synonymous, pseudo column, sequences and indexes
Noted, Sure. I will post soon.
thanks for the clear explanation, could you please provide the scripts you have used during explanation
Have you completed this course if yes then is it worth it?
i am unable to see the session notes in description,
pls share me the link
Hi can we point foreign key references one primary key which are two primary keys in one table ?
After executing HR schema in SQL developer its showing HR user does not exists and it was not created any one. can you suggest what to do here:(
can you please explain why exactly do we have to do the installation process in such complicated way and the whole cut paste of the hr folder..
❤️
Hi Sir, Where can I find notes which you're using ?
Hello Sir Thank You So Much For This Video, One more request to you can you please provide us the notes of sql..
Please join my live training sessions for complete sessions and details
Hey there, god bless your efforts in this channel.
As a newbie sql learner i have general enquiry.
What is the major difference between Oracle database and mysql database.
Is there any advantages i need to consider before choosing to work on one of them.
Thanks for taking care of this.
Hi, Thanks for your wishes.
MySQL is open source DB, and Oracle is Paid DB server.
But SQL is almost same for both DBs. So please start learning Oracle SQL.
Thank you very much cheif for this tutorial can u kindly make sql oracle DAB and how can we go about writing the oracle exam and where can we start from in writing the exam.
Noted
Keep watching my Channel. Thanks
Sir,
How to derive only bottom half or second half records of the table.?
Hello Sir,
Thank you for your videos, is there a video on PLSQL.
Yes, soon
Nice
Can u post advance concept of sql
Yes, soon
sir can you provide link for notes of the course please?
Hlw sir.. Glad to see your hardworking videos! Can I ask you some ideas and queries?
Sir, I am a mechanical engg.. I have no single idea in IT sector..pls suggest me how to become Oracle DBA to get IT jobs.. Is it enough to learn from your videos? Pls suggest me
Thanks for your valuable feedback.
This is the course for Oracle Developer, who work on the queries.
for DBA, you need to learn admin related stuff, server, access, user, performance, storage, migration, etc.
How can i download the notes which are shown in txt format during the lectures?
Hi,i need the tutorial on datastage
Sir i have small request please upload on views and indexs
I am creating it, I will post soon. keep watching my channel.
My name is oracle omg im so happy that my name is on the title
Interesting
Bro. Thanks for the videos. I didn't find triggers and packages in these videos. What are they ??
I will add
Hi Sir, Very helpful Oracle SQL video. Thank you !!
Pls try to make Informatica pc scenario based and interview questions videos.
Okay sure
sir, this sql is used used as data science after python we able learn SQL is that it is?