Oracle SQL Tutorial | Oracle DBA | Oracle SQL for Beginners | Great Learning
ฝัง
- เผยแพร่เมื่อ 27 ส.ค. 2021
- 🔥1000+ Free Courses With Free Certificates: www.mygreatlearning.com/acade...
With the amount of data increasing exponentially by the day, its management becomes extremely crucial, and that's where SQL enters! Data in its raw form is more often than not incomprehensible and requires to be organized to be made sense of. SQL involves the organization, manipulation, retrieval and storage of data in relational databases. Here is the Oracle SQL Tutorial For Beginners to help you take that first step to learn SQL right from scratch! Technology is taking the world by storm, and a variety of its disciplines have evolved in this era of information! One such field is Structured Query Language, better known in its abbreviated form SQL, a programming language used to manage data in Database Management Systems.
🏁 Topics Covered:
00:01:25 Agenda
00:05:20 Introduction
00:21:42 Creation of Table
00:29:59 Oracle Setup and Installation
00:48:38 Relational Model
01:00:03 Miscellaneous topics
01:19:53 Operators as keywords
01:30:22 Functions
01:44:21 Clauses
01:57:55 Nested Query
02:09:25 Joins
02:48:55 SQL Commands
03:14:36 Database Objects
03:26:13 Summary
🔥 Free SQL Courses With Free Certificates:
Oracle SQL course, Register Now: glacad.me/3MPqCPK
✔ My SQL Basics course: glacad.me/3DX1rWU
✔ SQL Interview Questions and Answers: www.mygreatlearning.com/acade...
✔ SQL Projects for Beginners: www.mygreatlearning.com/acade...
✔ SQL for Data Science: www.mygreatlearning.com/acade...
✔ SQL with Python: www.mygreatlearning.com/acade...
✔ Advanced SQL: www.mygreatlearning.com/acade...
⚡ About Great Learning Academy:
Visit Great Learning Academy to get access to 1000+ free courses with free certificate on Data Science, Data Analytics, Digital Marketing, Artificial Intelligence, Big Data, Cloud, Management, Cybersecurity, Software Development, and many more. These are supplemented with free projects, assignments, datasets, quizzes. You can earn a certificate of completion at the end of the course for free. www.mygreatlearning.com/acade
⚡ About Great Learning:
With more than 5.4 Million+ learners in 170+ countries, Great Learning, a part of the BYJU'S group, is a leading global edtech company for professional and higher education offering industry-relevant programs in the blended, classroom, and purely online modes across technology, data and business domains. These programs are developed in collaboration with the top institutions like Stanford Executive Education, MIT Professional Education, The University of Texas at Austin, NUS, IIT Madras, IIT Bombay & more.
#oraclesql #oracledatabase #oracledatabasetutorial
Register and get a free Certificate for the course: glacad.me/3MPqCPK
🔹Topics Covered
00:01:25 Agenda
00:05:20 Introduction
00:21:42 Creation of Table
00:29:59 Oracle Setup and Installation
00:48:38 Relational Model
01:00:03 Miscellaneous topics
01:19:53 Operators as keywords
01:30:22 Functions
01:44:21 Clauses
01:57:55 Nested Query
02:09:25 Joins
02:48:55 SQL Commands
03:14:36 Database Objects
03:26:13 Summary
PLEASE SHARE THE PPT OF THESE CLASS IF POSSIBLE.
From the topic joins can we write query like.....SELECT NAME,GENDER,AGE,SALARY FROM EMPLOYEE WHERE EMP_ID IN(SELECT EMP_ID FROM EMOLOYEE)=(SELECT EMP_ID FROM EMP_DEPT);
can we get answer for the above satetement also??? reply please....
2)From the topic joins can we write query like...SELECT EMP_ID FROM STU_DEPT WHERE USN IN(SELECT USN FROM STUDENT)= USN IN(SELECT USN FROM STU_DEPT);
can we get answer for the above statement??? reply please brother...
Learners please thumbs up Quick Reference Guide for this Oracle Tutorial
01:25 Agenda
05:20 Introduction
17:30 DBMS fields and values
19:00 field names become column names of table
21:30 values become rows of table
22:22 Query CREATE TABLE
27:07 INSERT INTO
00:29:59 Oracle Setup and Installation
35:00 password for both SYS and SYSTEM
36:22 initial error
37:00 correction of initial error
38:00 Application Express
38:18 Create Workspace
39:29 SQL Workshop
41:00 SQL Workshop - Object Browser - repo for all Tables - Tables - Tables Name - Table schema - Data - indexes - Model - Constraints - Grants - Statistics - UI Defaults - Triggers - Dependencies - SQL
43:13 SQL Workshop - Create Object - Select Object Type - Table - View - Index - Sequence - Type - Package - Procedure - Function -
46:56 Tables - click on Table name - Data - Insert Row
48:38 Relational Model
53:00 keywords
57:47 Foreign Key
1:00:35 Projection
1:02:44 Selection
1:04:22 Case Sensitivity is only applicable for values in Rows or Records or Tuples
1:07:37 Data Types
1:08:18 Difference between varchar and varchar2
1:09:19 NUMBER data type has p which stands for Precision and s for Scale
1:10:00 Date
1:10:10 Operators
1:13:10 Precedence of Operators
1:17:44 Dual Table
1:18:48 DESC TableName shows Description of Table
1:22:00 Precedence of Relational Operators
1:22:44 BETWEEN AND
1:23:23 NOT BETWEEN AND
1:24:24 in operator
1:25:25 LIKE
1:27:07 percentage sign means zero or more characters
1:27:27 underscore means single character
1:28:08 IS NULL operator
1:29:00 Logical Operator
1:30:30 Functions
1:37:00 LPAD vs RPAD
1:38:00 ROUND vs TRUNC
1:39:00 NVL
1:39:25 NVL2
1:39:55 month_between two date
1:40:25 ADD_MONTHS
1:40:44 NEXT_DAY
1:41:06 NULLIF
1:42:00 TO_CHAR is used to format
1:43:17 COUNT
1:44:22 CLAUSES
1:46:46 ORDER BY clause in ascending order puts NULL values at last rows of a column
1:46:56 GROUP BY clause
1:52:30 difference between GROUP BY clause and HAVING clause 1:55:11 AGGREGATE functions can NOT be used after WHERE clause and therefore HAVING clause is used
1:54:14 HAVING example
1:56:30 sequence of clauses
1:57:57 NESTED Query
2:05:55 Match values from Column of Nested Query
2:09:30 Joins
2:14:07 Types of Joins
2:17:21 inner join
2:21:07 Left Join
2:24:11 Right Join
2:27:55 Full Join
2:32:00 NATURAL Join
2:35:15 CROSS join
2:38:13 SELF Join
2:43:43 Select from multiple tables without join
2:44:34 Join multiple tables with conditions
2:45:45 join 3 tables
2:49:00 SQL commands
2:49:19 C of CRUD in DDL and UD of CRUD in DML
2:50:00 DDL applicable on Table
2:57:27 DROP vs TRUNCATE
2:58:58 DML
3:02:02 DELETE vs TRUNCATE
3:02:40 DCL
3:07:14 DCL Revoke
3:08:08 List Users in Oracle DB
3:09:29 TCL COMMIT
3:11:11 TCL ROLLBACK
3:14:36 DB Objects - Table - View - Sequence - index - Synonym
3:12:12 ROLL BACK TO SAVE POINT nameofSavepoint
3:17:13 VIEW
3:19:23 SEQUENCE
3:20:10 cycle vs nocycle
3:20:55 usage of Sequence in example
3:21:44 index - single - multiple - unique
3:22:22 create unique index nameOfindex
3:23:23 when indexes are not used
3:24:14 table containing indexes
3:24:40 Synonym
3:25:25 Synonym is temporary
Where is the link to download this guide or where is the link to beautify the video?
you are awesome
great job😊
Wow thank you ✌️
Gajab level ka dedication hai bhai
Great explanation, it covered 7 weeks of my college's sql lectures in just 4 hours. Really helped me alot, all thanks to this guy.👍🏻
excatly bro.same thing here;
This a perfect lecture for the beginners... if you still don't understand don't panic just try it again and again you will understand for sure.. all the best to everyone.
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
literally the best video on sql.... covering every imp and basic topics with lots of example....thanks
1:52:30 difference between GROUP BY clause and HAVING clause 1:55:11 AGGREGATE functions can NOT be used after WHERE clause and therefore HAVING clause is used
Excellent teaching skills with very great explanation and examples!!!Thankyou for the Video!!!
You are very talented. You have structured all the subjects in a very simple way to introduce us to the sophisticated topic. Extraordinary method!
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Thank you for making my IT journey so easy
I’ll keep in my mind who helped me at my struggling times after I became successful
It is one of the best courses available on youtube. If you are a beginner, then you go for it! I am also learning from this channel. neat way of explanation.
Excellent! Can you please explain the topic Constraints in SQL that you have not covered in this session?
Very clear explanation sir. Thank you so much for this full tutorial ✨✨
Thanks for you clear video about oracle Ritwik, it will be very useful to the beginner .
U can understand amrutha
Thank you so much for teaching in very easy way.... I understood all the SQL topics now
Ritwik, I have gone through this tutorial. You have completed all content for beginners. Many thanks for this course
Yes you are soo right.👍👍
Thank you. You explain everything more than my college teacher. Appreciate 👍
Great. Im a mechanical engineer. I didn't know anything on Oracle or even IT. U relieved me lot today as i'm looking for a new journey in the platform.
Thanks man...cause of you ..i revised my most of topics...well explained and done ✌️✌️🔥
1:09:19 NUMBER data type has p which stands for Precision and s for Scale
My project's deadline is in 8 hours.. I got some coffee, wish me luck! This content is really easy to understand and also helpful. (it''s midnight currently)
Very neat and clean, very informative, very well explained. Thanks a ton.
Thank you so much for the tutorial! Really helped me undertsand the sql joins easily.
Make a full tutorial on power apps please...Great learning makes learning smooth💯💥
Thank you so much. All the topics explained so well👍
Beautiful way of teaching 👏🏼 I love it
Excellent course I have sharpened my Oracle SQL coding.
A very interactive lesson.. thanks so much
Thank you sir I get lots of information from this video as a beginner.
I saw starting few minutes of the video , the way you teaches is awesome, easy to understand I REQUEST YOU TO PLEASE MAKE A VIDEO ON ORACLE EPM IN PLANNING AND NARRATIVE REPORTING…pleaseeee
Very informative sir, after a long time, for the first time was able to continue the video TO END on SQL without skiping or moving to other channel for SQL..
Thanks a lot for sharing your knowledge. Excellent webinar. I learned a lot from your video.
this is very useful for both beginners and when you want to brush up the sql skills
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Dear Sir, it's a really great tutorial. Can you give us the software driver for installation?
Great explanation ever! I've gained more knowledge. Thanks!
You taught it so perfect.! Amazing 👏
Thank you sir you taught us very easy and understandable:)Thanks to Great Learning:)
Deeppp0l9re
thankyou so much for this very very clear explanation!!
1:04:22 Case Sensitivity is only applicable for values in Rows or Records or Tuples
The way u explained... very clear
Great video...very well explained.....thank you so much for the video @greatlearning...
At 01:52:20, I think the question should be, why do we have a 'HAVING' clause when we already have a 'WHERE' clause instead of 'GROUP BY'. And at 01:55:39 "HAVING" clause should be after "GROUP BY".
Marvelous work gentlemen. Sample database is slightly different for me so needed to pause to try to create like tables to yours. Not hard to do but others may also have had to do this.
thanks for everything u did for us. The lesson was so helpful.
Many Thanks. This is one of the best Courses I have found which is very helpful for all levels. I will use it as a reference for any future Queries. Please Keep it Safe and don't delete in the future.
just PERFECT ! , thank you
1:30:23 Functions
1:44:21 clauses
Admire your patience and ease of explaining intricate details .. awesome😊👌
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Thank you sir thanks a lot i got more confidence towards my future .sir you are just awesome
Great explanation sir. Thanks a lot.
Thank you for this full course
We need these kind of topics more
1:46:46 ORDER BY clause in ascending order puts NULL values at last rows of a column
Much needed course 👌
Sir thank you for this fantastic content. And you English is fabulous sir.
2:49:19 C of CRUD in DDL and UD of CRUD in DML
Very useful indeed .. Thank you V much for making things simpler :)
Thanks .I would like to know when to use logical and when to use LIKE keyword
You are teaching very advanced topics
Thank you very much, Sir.... for the learnings I gained...
Ritwik, can you please provide slides of this course. I am a beginner. Trying to learn DBA
Thank You Very Much Its Very Helpful.
28:33 as u said the dbms will check the datatype first, as AMAN is a varchar2 not number so if i miss out the first field it will put 0 by default. So what if the table name is Topper List and the second field is not varchar2, lets say the First field is ID number as it was and the second field is Rank Number(500)?
Thank you very much, Mate. Learnt lots of things.
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
It's is very usefull and easily understood thanks for all
Nice info..
Need full PLSQL tutorial
41:00 SQL Workshop - Object Browser - repo for all Tables - Tables - Tables Name - Table schema - Data - indexes - Model - Constraints - Grants - Statistics - UI Defaults - Triggers - Dependencies - SQL
Hi bro can u please tell me
I need work support for SQL psql developer. is it possible?
does order of precedence depend on the software we are using?
2:02:49 Can we use GROUP BY & ORDER BY clauses in Subquery. Please clarify, I got confused
bro your explanation is just amazing
Excellent teaching. Thanks a lot
Great Video brother. I completed this video at 1.5x. Very Helpful!!! kudos!!!
Very nicely explained course
Perfect method
2:05:55 Match values from Column of Nested Query
does anyone has issue with logging credentials ? because sys and root doesn't work for me
after running exe file, i could find shortcut for Oracle DB on desktop, when tried to run got the error, in your video you have changed percentage but not sure how you got 3 zeros, though i remove percentage and add 3 zeros , i am still getting error , please need help
Let's go, this is the top notch database according to PYPL top DB's🥳🥳🥳🥳
With it being Sept 2023- are you able to download and use the Oracle 19c for Windows or Oracle database 21c in conjunction with this ?
3:14:36 DB Objects - Table - View - Sequence - index - Synonym
Great tutorial in just 3.5 hours.
i dont see the 11g version, which one should i go for for practicing?
Really great learning 👍😊
but pls for relational table, what about making a value display under another field of table.
Sir it is a great tutorial for beginners. Thank you sir...
But you have left the concept called constraints..
Anyway the teaching skills were great.and your knowledge too...❤.
Hi , where is "get started" in 21c or the weblink for opening home web page as stated in the video? Do let me know if I am missing something. thanks.
I am using Mac, having a problem finding a right version for Express Edition, pls assist. Thank you
Very useful session bro....
@greatlearning how do i access the STUD table that I created in SQL Command Line under user STUDENT? Where do I give the user STUDENT credentials?
Bhai I have dought in insert command, as it is not inserting all values but it is accepting one by one .
when I try to insert all the values it shows an identifier(" Invalid identifier").
Great learning indeed 💯
Hello sir .. Is there any function that gets the column data type from a query(result set),as like in SQL have sys.dm_exec_describe_first_result_set. Any Solution..
Which software is more useful my sql and oracle??
Hello Brother. Do we need to lo in from your oracle profile Ritwik in order to have access to the tables? I cant see table Student on which you are working.
great clear explanation about database concepts
can you provide download link for oracle 11g express edition
Thank you so much!
In the first insert statement % was missing for Aman's marks but table shows %. when I tried to use % in insert, it didnt work.
Best video for SQL and Oracle 👏
Thank you sir for making Oracle e
is there any difference in the installation process between 18c and 11g? Thanks
Amazing!! Explanation