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
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.
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.
Hello, How to write query to insert all the data from one table to another. As we have student name n roll no in one table and marks in another. So I need all this in single table.. And also I dont need to make this table to be created as u showed, but I want it to write as a command in sql workshop and then RUN.. At 4:32-35 u made through table which i dont want. U want it through command Hope u understand my question
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
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)
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.
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.
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..
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...❤.
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".
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
having clause can be used with aggregate functions . It is the main reason behind its existence. It helps in filtering out w.r.t aggregate functions. let me know if i am wrong @greatlearning
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.
Excellent explaining sir. I have a doubt that when i connect to database using sql command line then it is asking user id and password when i was entering password it is not taking(freezing) sir why?
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)?
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
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.
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
🔥 Get your free certificate of completion for the Introduction to SQL course, Register Now: glacad.me/3Eygmar
Hello,
How to write query to insert all the data from one table to another.
As we have student name n roll no in one table and marks in another.
So I need all this in single table..
And also I dont need to make this table to be created as u showed, but I want it to write as a command in sql workshop and then RUN..
At 4:32-35 u made through table which i dont want. U want it through command
Hope u understand my question
Do a video how to create a point of sales using oracle sql
PPT kaise millegaaa sir?
Its not showing chapters (Time stamp)
Please write 00:00:00
in description firstly in chapters
literally the best video on sql.... covering every imp and basic topics with lots of example....thanks
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
Thanks for you clear video about oracle Ritwik, it will be very useful to the beginner .
U can understand amrutha
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
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)
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.
Excellent teaching skills with very great explanation and examples!!!Thankyou for the Video!!!
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.
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..
Very useful indeed .. Thank you V much for making things simpler :)
Ritwik, I have gone through this tutorial. You have completed all content for beginners. Many thanks for this course
Yes you are soo right.👍👍
Excellent course I have sharpened my Oracle SQL coding.
Great Video brother. I completed this video at 1.5x. Very Helpful!!! kudos!!!
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...❤.
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?
Thank you. You explain everything more than my college teacher. Appreciate 👍
Thank you so much for teaching in very easy way.... I understood all the SQL topics now
Today my infosys interview questions
1. Nth no from table
2. High salary in query
3. Self join , Inner join
4. Primary key
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".
Very clear explanation sir. Thank you so much for this full tutorial ✨✨
Thanks for this amazing clear cut lecture🙏🙏
Thank you so much for the tutorial! Really helped me undertsand the sql joins easily.
Order of precedence of mathematic operators are not * / + -, It is paranthesis followed by * and / from left to right and - and + from left to right
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
Excellent! Can you please explain the topic Constraints in SQL that you have not covered in this session?
Thanks man...cause of you ..i revised my most of topics...well explained and done ✌️✌️🔥
Best video for SQL and Oracle 👏
You are teaching very advanced topics
Very neat and clean, very informative, very well explained. Thanks a ton.
Do you have any video on Procedures, basically how to undestand any big sp
This video is Very helpful,
Thanks
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
I was complet your course for this course
Great explanation ever! I've gained more knowledge. Thanks!
1:09:19 NUMBER data type has p which stands for Precision and s for Scale
Thank you very much, Sir.... for the learnings I gained...
THANK YOU FOR MAKING IT EASY TO UNDERSTAND, YOU MUST TEACH MY LECTURER.
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
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
Sir thank you for this fantastic content. And you English is fabulous sir.
Hi sir. Can you please make video that how we can use oracle in mac M1. With SQL developer.
Thanku sir ,you saved my sem
having clause can be used with aggregate functions . It is the main reason behind its existence. It helps in filtering out w.r.t aggregate functions. let me know if i am wrong @greatlearning
Thanks a lot for sharing your knowledge. Excellent webinar. I learned a lot from your video.
1:30:23 Functions
1:44:21 clauses
Thank you sir I get lots of information from this video as a beginner.
Explanation is very clear and well.
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Wow! Zakir Khan also knows how to teach sql.
Thank You Very Much Its Very Helpful.
It's a great lecture. Thank you! 🥰
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
Thanks .I would like to know when to use logical and when to use LIKE keyword
Dear Sir, it's a really great tutorial. Can you give us the software driver for installation?
Make a full tutorial on power apps please...Great learning makes learning smooth💯💥
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.
Superb explanation 💗
bro your explanation is just amazing
Great video thanks!!
Hi we are glad that you liked our Content Please do subscribe to our Channel for Similar & Awesome Content
3:14:36 DB Objects - Table - View - Sequence - index - Synonym
for your help 1:20:00
Select Roll_no , name ,age from student where age = 20 ;
thanks for everything u did for us. The lesson was so helpful.
just PERFECT ! , thank you
Excellent video brother. I am not able to see this Student information on my oracle. How can I get it?
Hi, what's have you changed to start the application? Can you put here?
T q for giving slow andgood notes.can I get notes.once again tq
Thank you Ritwik and the channel!
great clear explanation about database concepts
Excellent explaining sir. I have a doubt that when i connect to database using sql command line then it is asking user id and password when i was entering password it is not taking(freezing) sir why?
17:30 DBMS fields and values
2:43:43 Select from multiple tables without join
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)?
Beautiful way of teaching 👏🏼 I love it
It's is very usefull and easily understood thanks for all
Thank you 🙏 sir 😊😊
Excellent teaching. Thanks a lot
Which software is more useful my sql and oracle??
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 ?
You taught it so perfect.! Amazing 👏
Great tutorial in just 3.5 hours.
One request can you please provide the materials from this lecture
please It is very much needed
2:02:49 Can we use GROUP BY & ORDER BY clauses in Subquery. Please clarify, I got confused
Thank you sir you taught us very easy and understandable:)Thanks to Great Learning:)
Deeppp0l9re
43:13 SQL Workshop - Create Object - Select Object Type - Table - View - Index - Sequence - Type - Package - Procedure - Function -
A very interactive lesson.. thanks so much
1:08:18 Difference between varchar and varchar2
Excellent course. Thanks for share.
Great explanation
thanks sir for the this useful content
Let's go, this is the top notch database according to PYPL top DB's🥳🥳🥳🥳
What an explaination, suprb yar, great work
is there any difference in the installation process between 18c and 11g? Thanks
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
thankyou so much for this very very clear explanation!!
Is this all we got to learn about Oracle? Or there is lot more?
2:49:19 C of CRUD in DDL and UD of CRUD in DML
1:39:55 month_between two date