Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For Edureka Microsoft SQL Server training curriculum, Visit our Website: bit.ly/3IhZXL5 Use code "TH-cam20" to get Flat 20% Off on this training. The following topics are covered in this video: 2:00 What is RDBMS? 2:54 Normalization in DBMS 3:44 Normalization Types in DBMS 10:00 Data Types in SQL ***Database Commands*** 17:03 Create Database Objects 25:04 Alter Table Statements 30:47 Drop Table Statements 32:05 Various Constraints 57:54 Creating Views ***Table Commands*** 1:02:18 Insert Statements 1:07:47 Insert - As- Select Statement 1:13:58 Update Statements 1:20:05 Delete Statements 1:22:47 Select Statement 1:28:01 Select Statement: Alias 1:31:39 Select Statement: Distinct Values 1:32:49 Sorting 1:36:20 Filtering ***Comparison Operators*** 1:45:29 NOT IN 1:45:58 IN 1:48:10 Symbols 1:49:21 Example 1:29:29 LIKE 1:52:37 CASE Expression ***Joins*** 1:56:23 Joins 1:57:15 Self-Join 1:58:36 Inner Join 2:14:24 Left outer Join 2:19:46 Right outer Join 2:24:32 Full outer join 2:28:12 Cross Join ***Functions*** 2:34:17 SQL Built-in Functions 2:37:20 Conversion Function 2:42:16 Logical Functions 2:48:44 Math Function 2:54:45 Aggregate Functions 3:02:28 String Functions 3:09:00 Date & Time Functions 3:11:55 Custom Functions 3:19:01 Stored Procedure 3:43:44 User Defined Functions 4:02:57 Triggers
This video is awesome for learning, all the topics are covered with full details and examples. Could you please upload the same kind of Detailed video for SSIS ? Thanks in Advance
Great course. Very well explained. However, the explanation for data types and how and when to use each of those, could be better, because complete beginners who have never worked with data types will have a hard time understanding it.
This is an excellent video session… !!!! Thanks to edureka for continous efforts to offer such a wonder presentation… And I request you to share the PPT and source code which will be great to have for training… Thanks again…!!!
We are happy that Edureka is helping you learn better ! We are happy to have learners like you :) Please share your mail id to share the data sheets :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Excellent tutorial to Learn SQL ...... And the Instructor is doing owsm job ....Well ...explained sir .... please make detailed this type of tutorial on ORACLE ... ❤️❤️❤️❤️🌹
It is great to know that our contents are helping you learn better and learn easy ! We are super glad to know and have learners like you with us. We'll definitely take your suggestion to the team and create content on this ! Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Hello Edurekha team, Amazing course content and very easy to understant from scratch. It will be more helpful if its possible to get this PPT for further learning process Thank you
Thanks for showing interest in Edureka kindly visit the channel for more videos our content creators are eagerly waiting for your suggestion to make new videos on your interest :) DO subscribe for the video update
Hi Prakruthi, unfortunately we do not share any presentations that are part of the video. Here is a link: bit.ly/2KIMkdR that might help you in referencing, cheers :)
Hey:) Thank you so much for your sweet words :) Really means a lot ! Glad to know that our content/courses is making you learn better :) Our team is striving hard to give the best content. Keep learning with us -Team Edureka :) Don't forget to like the video and share it with maximum people:) Do subscribe the channel:)
Thank you edureka for sharing this wonderful SQL video, this help me too clear all my problems which I had faced . I hope that you can also share ppt and all other sheets related to the videos, Lot of thank you........
Hi ! Good to know that our videos are helping you to learn better :) Please share your mail id to share the data sheets :)We’ll update you soon . Do subscribe the channel for more updates : )
Hi EdurekaTeam! Thank you for such great content and excellent explanation. It would be really helpful for the revision if you could please provide us with the PPT and Source Code.
Glad you liked it ! We are glad to have learners like you. Please do share your mail id so that we can send the notes or source codes. Do subscribe our channel and hit that bell icon to never miss any video from our channel
Thanks to edureka for continous efforts to offer such a wonder presentation… And I request you to share the PPT and source code which will be great to have for training… Thanks again
Good to know our contents and videos are helping you learn better . We are glad to have you with us ! Please share your mail id to send the data sheets to help you learn better :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Hey:) Thank you so much for your sweet words :) Really means a lot ! Glad to know that our content/courses is making you learn better :) Our team is striving hard to give the best content. Keep learning with us -Team Edureka :) Don't forget to like the video and share it with maximum people:) Do subscribe the channel:)
Thank you for your review : ) We are glad that you found our videos /contents useful . We are also trying our best to further fullqfill your requirements and enhance your expirence :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Good to know our contents and videos are helping you learn better . We are glad to have you with us ! Please share your mail id to send the data sheets to help you learn better :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Hi Rahul, here is a link: bit.ly/3ohIk2Q that might help you gain better insights. Also, if you are looking for a advanced level certification course, kindly visit: bit.ly/3rTlr80 or reach us on our toll-free number 08035068110 for more details. Happy learning :)
Hi Shivaraj, the basic difference is SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system. Oracle SQL Developer is an Integrated development environment for working with SQL in Oracle databases. MySQL on the other hand, is an open-source relational database management system. Hope this is helpful.
Thank you for your review : ) We are glad that you found our videos /contents useful . We are also trying our best to further fulfill your requirements and enhance your expirence :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thanks for showing interest in Edureka kindly visit the channel for more videos our content creators are eagerly waiting for your suggestion to make new videos on your interest :) DO subscribe for the video update
Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Great to see that our videos and contents are making you perform better and understand better :) We are glad that you've enjoyed your learning experience with us .Thank you for being a part of Edureka's team:) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Hi Amit, thanks for the appreciating our efforts! We are glad that you liked our tutorials. Do subscribe to our channel and stay connected with us. Cheers!
Thank you so much for the review ,we appreciate your efforts : ) We are glad that you have enjoyed your learning experience with us .Thank You for being a part of our Edureka team : ) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thanks for showing interest in Edureka kindly visit the channel for more videos our content creators are eagerly waiting for your suggestion to make new videos on your interest :) DO subscribe for the video update
Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
We are glad to have learners like you. Please do share your mail id so that we can send the notes or source codes. Do subscribe our channel and hit that bell icon to never miss an video from our channel
We are super happy that Edureka is helping you learn better. Your support means a lot to us and it motivated us to create even better learning content and courses experience for you . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For Edureka Microsoft SQL Server training curriculum, Visit our Website: bit.ly/3IhZXL5 Use code "TH-cam20" to get Flat 20% Off on this training. The following topics are covered in this video:
2:00 What is RDBMS?
2:54 Normalization in DBMS
3:44 Normalization Types in DBMS
10:00 Data Types in SQL
***Database Commands***
17:03 Create Database Objects
25:04 Alter Table Statements
30:47 Drop Table Statements
32:05 Various Constraints
57:54 Creating Views
***Table Commands***
1:02:18 Insert Statements
1:07:47 Insert - As- Select Statement
1:13:58 Update Statements
1:20:05 Delete Statements
1:22:47 Select Statement
1:28:01 Select Statement: Alias
1:31:39 Select Statement: Distinct Values
1:32:49 Sorting
1:36:20 Filtering
***Comparison Operators***
1:45:29 NOT IN
1:45:58 IN
1:48:10 Symbols
1:49:21 Example
1:29:29 LIKE
1:52:37 CASE Expression
***Joins***
1:56:23 Joins
1:57:15 Self-Join
1:58:36 Inner Join
2:14:24 Left outer Join
2:19:46 Right outer Join
2:24:32 Full outer join
2:28:12 Cross Join
***Functions***
2:34:17 SQL Built-in Functions
2:37:20 Conversion Function
2:42:16 Logical Functions
2:48:44 Math Function
2:54:45 Aggregate Functions
3:02:28 String Functions
3:09:00 Date & Time Functions
3:11:55 Custom Functions
3:19:01 Stored Procedure
3:43:44 User Defined Functions
4:02:57 Triggers
This video is awesome for learning, all the topics are covered with full details and examples. Could you please upload the same kind of Detailed video for SSIS ? Thanks in Advance
This really helps! I'm a complete beginner who sees an Msql screen for the very first time, but even I can understand your explanation!
Best video I have ever watched ! It covered all the topics in an appropriate manner .
It’s was brief and quick learning of sql commands . Very nice course to prepare for interviews . Thankyou !!
Great course. Very well explained. However, the explanation for data types and how and when to use each of those, could be better, because complete beginners who have never worked with data types will have a hard time understanding it.
Great suggestion! :) Will definitely take into consideration.
EXCELLENT TUTORIAL, Kindly also make a detail tutorial on Oracle
Awesome explanation. Anyone can easily learn through this video . Thanku ☺️
Thanks to the Anil. This session helped me in revising and restoring all the concepts of SQL. Excellent!!!
Thank you for your tutorial!
I successfully established SQL and PLC connection!
One of the best Session to start up with, would kindly Request you to share the syntax and the example code document which was used in this video
Thank you so much.
You explained here allot of things.✌️
This is an excellent video session… !!!! Thanks to edureka for continous efforts to offer such a wonder presentation… And I request you to share the PPT and source code which will be great to have for training… Thanks again…!!!
We are happy that Edureka is helping you learn better ! We are happy to have learners like you :) Please share your mail id to share the data sheets :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
What is the meaning of scema_name
That u have included as (dbo. )In stored procedures 3:25:15
Can u explain me this sir ..
Appreciate this fantastic session! Thank You...
Great, Covered each and every concept I have read in a full semester:)
Excellent tutorial to Learn SQL ...... And the Instructor is doing owsm job ....Well ...explained sir .... please make detailed this type of tutorial on ORACLE ... ❤️❤️❤️❤️🌹
It is great to know that our contents are helping you learn better and learn easy ! We are super glad to know and have learners like you with us. We'll definitely take your suggestion to the team and create content on this ! Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Love, love, love this girl. She is extraordinary teacher
Hello Edurekha team, Amazing course content and very easy to understant from scratch. It will be more helpful if its possible to get this PPT for further learning process
Thank you
Glad to hear our contents are helping you ! Please provide your mail id to share the data sheet :) We’ll update you soon
It's really going to help for basic learniners...aweee very good explanation
Thank you 😊 Glad it was helpful!
knowledgeable video thanku bro.. i want more video from your side...
Thanks for showing interest in Edureka kindly visit the channel for more videos our content creators are eagerly waiting for your suggestion to make new videos on your interest :) DO subscribe for the video update
Thank you so much sir !!
edureka was awesome sharing the information and this channel is the best for online learning platform , teaching was good and with clear cut examples
Dear Trainer,
Teaching was well and gud.
Can I get this PPT?
Just for recall the things quickly.
Hi Prakruthi, unfortunately we do not share any presentations that are part of the video. Here is a link: bit.ly/2KIMkdR that might help you in referencing, cheers :)
Bro you are just pro you completed all the points in sql worth watching
Easy to learn, Crystal clear and time saving! Thanks a lot!
Hey:) Thank you so much for your sweet words :) Really means a lot ! Glad to know that our content/courses is making you learn better :) Our team is striving hard to give the best content. Keep learning with us -Team Edureka :) Don't forget to like the video and share it with maximum people:) Do subscribe the channel:)
It’s has really helped me understand well on SQL ,thanks allot
You're Welcome 😊 Glad it was helpful! Keep learning with us..
Thank you edureka for sharing this wonderful SQL video, this help me too clear all my problems which I had faced . I hope that you can also share ppt and all other sheets related to the videos, Lot of thank you........
Hi ! Good to know that our videos are helping you to learn better :) Please share your mail id to share the data sheets :)We’ll update you soon . Do subscribe the channel for more updates : )
Instructor is awesome. Best tutorial I have come across👏
best video , thank you so much , keep up the good work ❤
Glad you liked it!
Each and every topic covered very well along with good examples. Thanks for sharing the such beautiful video to us.
Thank you for you time in giving a feedback :) We are glad that you are learning from our videos! Stay connected with our channel :)
You are doing very good job Edureka.. many thanks! :)
Like a gem to see this video
Hatss off
Helped me a lot to understand those concept.. Thank you
Hi EdurekaTeam! Thank you for such great content and excellent explanation. It would be really helpful for the revision if you could please provide us with the PPT and Source Code.
Glad you liked it ! We are glad to have learners like you. Please do share your mail id so that we can send the notes or source codes. Do subscribe our channel and hit that bell icon to never miss any video from our channel
very helpful course for reviewing. Thank you.
You're welcome 🤗 Glad it was helpful!
Awesome tutorial thank you 🙏🏻👍🤩
Thanks to edureka for continous efforts to offer such a wonder presentation… And I request you to share the PPT and source code which will be great to have for training… Thanks again
Good to know our contents and videos are helping you learn better . We are glad to have you with us ! Please share your mail id to send the data sheets to help you learn better :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
when we split the data in the second normal form will it not violate the first normal form?
what a wonderful explanation of all the diff component of SQL. Thank you sir!!!
Thanks to edureka team for this DBMS series 😊
Thanks to you :) Keep learning with us !!!
Very helpful.....,Thankyou.
You are a good teacher. Thank you for sharing such a thorough video.
Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
This is incredible video session for all other tutorial .In this session tells clearly topic wise ......thank you so much sir for ur time!!!!
Hey:) Thank you so much for your sweet words :) Really means a lot ! Glad to know that our content/courses is making you learn better :) Our team is striving hard to give the best content. Keep learning with us -Team Edureka :) Don't forget to like the video and share it with maximum people:) Do subscribe the channel:)
Excellent video. All the concepts are explained perfectly.Thanks for sharing!
Thank you very much. Instructor is excellent ..
done full course from here
Topics are very well framed and explanation was very nice.👍👍
Thank you for your review : ) We are glad that you found our videos /contents useful . We are also trying our best to further fullqfill your requirements and enhance your expirence :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Really thank you so much fr this learned many concepts which i dont know as a fresher
Thank you so much. well explained
wow excelent teaching ....thank u sir:)
You are most welcome
An excellent tutorial👏worth to watch😍
awesome course! Thank you so much edureka!
Amazing video session, just loved it.
Glad you enjoyed it!
I am very thankful for such a nice course.
appreciate this video!!!!
thank you so much...
Thanks for the nice video.Can you share the hard copy?Thanks
Good to know our contents and videos are helping you learn better . We are glad to have you with us ! Please share your mail id to send the data sheets to help you learn better :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thanks... please upload complete oracle tutorial...
Helpful video :) Please make full length video on c .....
very very useful thank u
Nice SQL video for the beginner. Plz suggest the database designing or Advance SQL concept videos
Hi Rahul, here is a link: bit.ly/3ohIk2Q that might help you gain better insights. Also, if you are looking for a advanced level certification course, kindly visit: bit.ly/3rTlr80 or reach us on our toll-free number 08035068110 for more details. Happy learning :)
Sir please tell me difference between sql, Oracle sql, MySQL i am have so much confusions here 😭
Hi Shivaraj, the basic difference is SQL is a domain-specific language used in programming and designed for managing data held in a relational database management system, or for stream processing in a relational data stream management system.
Oracle SQL Developer is an Integrated development environment for working with SQL in Oracle databases.
MySQL on the other hand, is an open-source relational database management system.
Hope this is helpful.
Tq so much edureka....seach a wonderful video uppoloding ....🙏
Thank you so much for this course
You are very welcome
Compared to other channels this video is best
Thank you for your review : ) We are glad that you found our videos /contents useful . We are also trying our best to further fulfill your requirements and enhance your expirence :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thank you 🙏 for this great explanation 🔥
Is this enough tutorial for freshers please tell me friends
Very informative and very compact. Helped me to refresh my SQL knowledge. Thank you Edureka
Great tutorial.thank you
Thank you so much for such a good tutorial
Thanks for this tutorial... Just to be informed that in unique we can enter more than one null because null is not defined please check☺️
Thanks for showing interest in Edureka kindly visit the channel for more videos our content creators are eagerly waiting for your suggestion to make new videos on your interest :) DO subscribe for the video update
Thanks for giving valuable content 👍👍
Good To know our vedios are helping you learn better :) Stay connected with us and keep learning ! Do subscribe the channel for more updates : )
Thankqq so much for this video sir
Most welcome Glad you liked it !!!
Thank-you!!
It is really good video which gave basic of SQl. Could you pl provide few queries, would like to try an dcreate query using this knowledge.
Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Exellent tutorial for beginners
what is the difference between drop and delete commands?
really good explanation and your having oracle dba course vedios please share me
Great to see that our videos and contents are making you perform better and understand better :) We are glad that you've enjoyed your learning experience with us .Thank you for being a part of Edureka's team:) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thank you. You are awsome
Thank you sir
nice tutorial for beginners thanks edureka for such a amazing course
Hi Amit, thanks for the appreciating our efforts! We are glad that you liked our tutorials. Do subscribe to our channel and stay connected with us. Cheers!
This is a very good brief lecture before going to interview thank you so much ❤️
Thank you so much for the review ,we appreciate your efforts : ) We are glad that you have enjoyed your learning experience with us .Thank You for being a part of our Edureka team : ) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thank you very much I got lot of sql knowledge by this video.Please make a video for Java 8 also.thank you
Thanks for showing interest in Edureka kindly visit the channel for more videos our content creators are eagerly waiting for your suggestion to make new videos on your interest :) DO subscribe for the video update
Thank you edureka for giving deep description about SQL. please can you share PPT to prepare.
Thanks for showing interest in edureka! Kindly share your mail id for us to share the datasheet/ source code :) Do subscribe for more videos & updates
How to insert values into single column which is created newly
Gained a good amt of knowledge
TQ for helping you are doing really great where no one can do tq a lot
Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Thanks to Edureka, I can't expect this type of tutorial to be free for everyone, or can you share the slide? I
We are glad to have learners like you. Please do share your mail id so that we can send the notes or source codes. Do subscribe our channel and hit that bell icon to never miss an video from our channel
Keep the good work coming.
Thank You 😊 Keep learning with us!!
Awesome work👏✊👍. Helped alot
Ty
Awesome Explanation.
Can you please provide us with the PPT and Source Code it would be helpful for revision....
Hi great to hear from you :) please share your mail id ! so that we can share the data sheet with you :)Do subscribe the channel for more updates : )
Excellent Course by EDUREKA .request you to share the PPT and source code which will be great to have for training… Thanks again…!!!
Hi please share your mail id to share the data sheet :) We'll Update you soon ! Do Subscribe the channel to keep updated
Nice explanations i have never seen this type of voice clearance and knowledge exploration. Thank you.
We are super happy that Edureka is helping you learn better. Your support means a lot to us and it motivated us to create even better learning content and courses experience for you . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
Good explanation it would be helpful if you share PPT slides to prepare for interview
As soon as possible
this SQL is very important to your skill update so I like this you tube
Way of presentation and explaining way very nice sir..
If possible please share ppt.
Thanks for showing interest in Edureka! Kindly share your mail id for us to share the datasheet/ source code :) Do subscribe for more videos & updates
I can't able to use the MONEY keyword in my MySQL Workbench tool, it showing an error what should I use instead of MONEY keyword, Sir.
Awesome efforts u have given sir 🙂
Thank You! Please can u provide us the notes of this course?
You're welcome 😊 Glad it was helpful!!! Keep learning with us..
Thanks very much...very helpful work and nice video...please keep doing..Thanks Alot.
Thanks for the compliment! We are glad you loved the video. Do subscribe, like and share to stay connected with us. Cheers :)