Oracle SQL for Beginners | SQL Complete Tutorial for Beginners | SQL Full Course | SQL Tutorial
Vložit
- čas přidán 10. 10. 2023
- #oracle #sqlinterviewquestions #sqlinterviewquestionsandanswers #SQLTutorialForBeginners #SQLFullCourse #SQLCourseForBeginners #SQL #LearnSQLForBeginners #SQLForBeginners #SQLTutorial #SQLCourse #SQLTraining #LearnSQLIn7Hours #sqlstructuredquerylanguage
#no1trending #viral #informaticapowercenter
=====================================================================
📢Dear Techies,
🌕Complete PLSQL Tutorial available
courses.nicitacademy.com/
Do you want to join the SQL/PLSQL Interview preparation, job search Group?
🔵Please join the WhatsApp group for an update
chat.whatsapp.com/I3SxzqfouLF...
🌕For Live PLSQL training contact me on WhatsApp (+91 7010080468) or the below link
wa.link/m4lat0
📌 Oracle 21C Installation: with software: (How to import HR Schema in Oracle 21C)
• Oracle 21c installatio...
Chapters:
=========
00:00:00 Introduction to Oracle SQL
00:00:56 Oracle database installation - Oracle 11g Installation
00:14:38 Day 1 Oracle SQL tutorial for beginners, how to create a table in SQL, alter a table in SQL
00:38:09 Day 2 DDL, DML, DRL, TCL, DCL in Oracle SQL
01:11:31 Day 3 Constraints in Oracle, Primary key, foreign key, Not null, check constraints, Unique
01:41:36 Day 4 Select statement in Oracle SQL
02:16:34 Day 5 Single row functions in Oracle SQL
03:18:08 Day 6 Joins in Oracle SQL, Left outer join in SQL
04:01:21 Day 7 Aggregate functions in Oracle SQL, min, max, sum, avg, count, group by, having
04:49:47 Day 8 Sub queries in Oracle SQL
05:44:49 Day 9 SET operators in Oracle SQL
06:15:17 Day 10 Analytical or Window Functions in SQL
06:51:15 Day 11 Views in Oracle SQL, Materialized views in Oracle
08:03:18 Day 12 Indexes in Oracle SQL
08:47:39 Day 13 Merge statement in Oracle
09:12:13 Day 14 Regular Expression in Oracle
10:24:53 Day 15 Performance Tuning in Oracle SQL
12:03:06 Oracle SQL quizzes, Oracle SQL interview questions, and answers for experienced
12:18:08 Oracle 21C Installation on Windows machine
********************************************************************************************
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
SQL Notes - Click on Like button
===========================
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...
Notes - Merge statement in Oracle:
drive.google.com/file/d/1ZaKN...
Notes - Regular Expression in Oracle:
drive.google.com/file/d/1ZUQ7...
Views in Oracle:
drive.google.com/file/d/1WEoT...
Indexes in Oracle:
drive.google.com/file/d/1FR4n...
Performance Tuning in Oracle
drive.google.com/file/d/1xeN3...
drive.google.com/file/d/1yI8X...
=================
SQL Complete Notes:
=================
drive.google.com/file/d/11kKE...
Oracle 11g Installation 🔵 Software download link:
==========================================
📌 Oracle 11g - 64 bit version
drive.google.com/file/d/1KGvh...
📌 SQL Developer:
drive.google.com/file/d/1VsGa...
======
Audio track credit:
Believe Music
*Complete PLSQL/Informatica/IICS 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 or career guidance.
🌕 +91 7010080468 or WhatsApp 🌕 wa.link/m4lat0
*WhatsApp group:*
chat.whatsapp.com/KMN5pKoLGSu8PuFLxSouB0
Thanks,
NiC IT Academy
(Since 2014) - A decade of training excellence.
first link is not opening
Please check now
Thanks for your teaching and uploading the un-paid course on this channel.
You're very welcome!
Awesome Course Must watch for the intermediate level also.
Excellent
Thank you so much for the amazing content, like the content
Glad you enjoy it! Keep watching my channel.
Sir this crash course is awesome
Thanks for your efforts...
Thank you, Keep watching my channel.
Please watch fully and practice.
Excellent video. Thanks
You are welcome! Keep watching my channel.
Thank you very much Sir. Please keep making such videos 🙏
Sure 👍Thanks, Keep watching my channel.
best Video i ever watch on youtube for SQL,
best video loved it,Thank you Sir
You are most welcome
@@NICITACADEMY sir i have one doubt,While creating an backup table the constraints are not copying , can i solution for this
Thank you so muchh for this amazing class, it was necessary for me thank you
Glad it was helpful! Keep watching my channel.
Sir please start Data Analyst playlist from beginner level to advanced level with industry level projects
Make us job ready through that Data Analyst playlist sir 😊
Sure I will, Keep watching my channel.
Awesome explanation sir
Thanks and welcome. Keep watching my channel.
an amazing and simple way of teaching. More Power to you Sir ...
Thanks a ton
Thank you for your great lectures.
You are welcome!
Sir, thank you for your efforts.
It's my pleasure
Sir please make same kind of video or complete blast course on EXCEL, POWER BI, PYTHON (DATA ANALYTICS) 😊
Sure, I will do
It is helped me lot sir. with real time examples...... Thank you so much sir
You are most welcome
Very good video bro. Thanks for your efforts.
Thanks and welcome
Excellent 👌👍..
Thanks a lot 😊 Keep watching my channel. Please refer to your friends.
Awsm tutorial..
Thank you! Cheers!
lot of love sir perfect time you drop the golden gems 💎 ❤❤❤❤
Thank you. Keep watching fully.
@@NICITACADEMY lot of love sir i will be sharing this video to my all friend too .Can you please bring video on normalization tooo i have been struggling normalization . Your way of teaching is very great and helpful
Hi Manooj, Thanks, Please share it your friends group.
I will upload normalization and RDBMS basic concepts as well.
Thanks, Keep watching my channel.
Tysm air for this valuable course. 🙏 Kindly please make same long video or course for PLSQL. It will help us alot.plz 🙏 ASAP
Thanks
courses.nicitacademy.com/
Thanks A Lot n Lot's 🤝🤝🤝
Thank you too. Keep watching my channel and refer to your friends.
you can check other courses here.
courses.nicitacademy.com/courses
Finally 🎉
Thanks
can you please make a video regarding joins with real time project scenarios?
Sir make video for type handler in pl sql
Sir please Oracle DBA sessions
Sir, If possible please upload complete PL/SQL tutorial. Thanks for sharing this tutorial.
Please check here
courses.nicitacademy.com/courses
@@NICITACADEMY link is not working sir
Is oracle free to install for study
@@NICITACADEMY sir , link was not working...404 not found error message showing...
Please upload videos on PL/SQL
@@NICITACADEMYlink not working
sir, please upload snoflake tutorial playlist .
Sure I will do later.
Sir if possible please upload python full course
Please clarify..is this course enough for ETL testing?
Because in depth sql for etl..thank you
It should be enough if you are using any ETL tool
Will there be any problem, if I use the latest version of Oracle, which is 21c, instead of 11g ?
Hi Sir
I am fallowing your vedios in Informatica since long back and I got job in Singapore
Now I am working in Singapore
But actually I need to improve more to be strong technically in Informatica , PL/Sql and UNIX
Please suggest me
Congratulations, Please check here
courses.nicitacademy.com/
Sir, please make a video on how to install oracle 19c or 21 download. please guide me on this issue after oracle 19c installation. If I start SQLPlus with username and password then adapter issue is showing and if I go to services then I want to start oracle service, oracle is starting then error is showing that windows is local computer Could not start OracleServiceORCL. The system cannot find the file specified.
Sir please provide informatica complete tutorial
courses.nicitacademy.com/
Informatica -project video and Informatica projects -Join what is the difference
courses.nicitacademy.com/
sir, when will upload pl/sql video on youtube???
Please check here
courses.nicitacademy.com/
Hi sir please share complete plsql course
Sure I will
courses.nicitacademy.com/
Can i take this course, if I'm beginner for oracle?
Yes definitory, I have explained from scratch.
You can check our other courses here.
courses.nicitacademy.com/courses
What type of jobs can we find through Oracle SQL.....
For most of the technologies, SQL is basics.
please tell the name of the background music used in the beginning of this video..its very pleasant to hear
Hello sir isthis content enough to data analytics job or need to take paid course plz tell
Hi. When i created core in system schema and entered username and password but it showing un or pw is incorrect logon denied.
what should i do?
if core user already exist, please try below query in admin and try to connect again
alter user core identify by core account unlock;
Please watch my sessions, without skipping it. I explained it. Thanks
Before table backup the mobile no. was Number (10) you updated it with Number (9), then how did the 10-digit mobile number from backup gets inserted in the column.
Sir can u make power center videos
czcams.com/video/V2FtZ_INmjg/video.html
you can get complete training material here
courses.nicitacademy.com/courses
please upload PLSQL full course
Please check here
courses.nicitacademy.com/courses
When I am trying to practice merge dml command
I got error like ora-30926 : unable to get a stable set of rows in the source table
Could please tell me when we will get this kind of error
Sir this one is not working " Oracle 11g - 64 bit version " it says the destination file could not be created error 0x800704v7: the operation was canceled bye the user. please help. thks
Pls give 100 Informatica power center interview questions &answers in app
Yeah sure I will do. Please check here always.
courses.nicitacademy.com/courses
Sir can i download this in mac
Can you make complete plsql like this?
courses.nicitacademy.com/courses
Sir, can two schemas have same tables or tables with same names?
Yes, we can have.
Hello Sir, Unable to connect to Oracle database ,getting the following error. Listener refused the connection ORA -12505 .
default SID is 'xe' . please help .
sir is it only sql or oracle sql ?
Oracle is the Database, and SQL is the language to extract/manipulate the data from data base.
While unlock hr account i am getting HR doesn't exist -01918 error could u plz help me to getrid of this error
Hi sir
I have 3+ years career gap after my post graduation I learn sql course only any job Opportunities in IT sector with fresher.
Please reply sir
share the table data from excel its not in description
czcams.com/video/xPSbxrMe7VU/video.html
Sir plz upload python
Sure I will do. Keep watching my channel.
Where can I get that SQL developer folder?
czcams.com/video/Jrefk1hOJQg/video.html
this course is for tester or Developer?. For Tester is this course is benefits?
SQL is a mandatory skill set for most roles in development and testing.
can i get the notes for this course
Please check the description of this video.
courses.nicitacademy.com/courses
hr folder account locked showing
--execute this statement in system schema
alter user hr identified by hr account unlock;
SQL developer is not opening in my laptop
Please follow this video
czcams.com/video/xPSbxrMe7VU/video.html
any one help me about notes for above video
Notes are there in the description. Please check.
sir it's not there...the link is not working@@NICITACADEMY
@1:28:45 Not much clear. You just say use join but not explain about the statement "a.owner,...." how its work and what the parameters are.
for unlocking hr it showing hr user doesnot exist
Please check this video and import HR schema
czcams.com/video/xPSbxrMe7VU/video.html
or else, re-install Oracle 11g.
czcams.com/video/Jrefk1hOJQg/video.html
Sir only hiring 5 to 10 years experience candidate. Not hiring freshers.
Product based and start-up companies will hire Freshers with SQL knowledge, so keep learning
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
(CONNECTION_ID=ArV4YXikTsCS8IZ50hnoXg==) getting this error sir while connecting the SQLDeveloper to system & admin
could please give the SID = orcl while opening new connection
Can you upload this same video in Tamil sir?
I already posted it in TAMIL, please check below video. Keep weatching my channel.
czcams.com/video/d04g-tnAxSQ/video.html
Sir this is complete course??
Yes, this is complete SQL course with notes in the description
czcams.com/video/yukL9vRalVo/video.html
How to install Oracle 19c and SQLplus tool
Is it same as which your said in tutorial?
System admin and HR and core schema is whether inbuilt in Oracle database or user defined?
czcams.com/video/Jrefk1hOJQg/video.html
please follow this video
czcams.com/video/xPSbxrMe7VU/video.html
czcams.com/video/xPSbxrMe7VU/video.html