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 "RUclips20" 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 : )
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:)
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
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 : )
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 :)
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 : )
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 : )
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 : )
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:)
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 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 :)
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 : )
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 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 : )
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 : )
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 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 for your review on our channel Great to hear that Edureka is helping you learn better . We’ll strive to make even better learning contents/courses in the future ! Do subscribe the channel for more updates : )
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.
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 : )
Hey there :) We are glad to have you with us :) and more glad to have learners like you with us ! We are happy to share the source code ,please do drop your mail id to share the same :) 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
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
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 "RUclips20" 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
Thanks to the Anil. This session helped me in revising and restoring all the concepts of SQL. Excellent!!!
Awesome explanation. Anyone can easily learn through this video . Thanku ☺️
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 : )
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
Appreciate this fantastic session! Thank You...
Thank you so much sir !!
Great, Covered each and every concept I have read in a full semester:)
edureka was awesome sharing the information and this channel is the best for online learning platform , teaching was good and with clear cut examples
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:)
Love, love, love this girl. She is extraordinary teacher
It's really going to help for basic learniners...aweee very good explanation
Thank you 😊 Glad it was helpful!
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
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
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 :)
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 ..
Thanks to edureka team for this DBMS series 😊
Thanks to you :) Keep learning with us !!!
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 : )
You are doing very good job Edureka.. many thanks! :)
Awesome tutorial thank you 🙏🏻👍🤩
Instructor is awesome. Best tutorial I have come across👏
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 :)
best video , thank you so much , keep up the good work ❤
Glad you liked it!
It’s has really helped me understand well on SQL ,thanks allot
You're Welcome 😊 Glad it was helpful! Keep learning with us..
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 : )
Like a gem to see this video
Hatss off
Helped me a lot to understand those concept.. Thank you
what a wonderful explanation of all the diff component of SQL. Thank you sir!!!
Very helpful.....,Thankyou.
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 : )
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 : )
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:)
thank you so much...
Thank you so much. well explained
awesome course! Thank you so much edureka!
An excellent tutorial👏worth to watch😍
very helpful course for reviewing. Thank you.
You're welcome 🤗 Glad it was helpful!
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
Bro you are just pro you completed all the points in sql worth watching
appreciate this video!!!!
Excellent video. All the concepts are explained perfectly.Thanks for sharing!
Thank you very much. Instructor is excellent ..
Amazing video session, just loved it.
Glad you enjoyed it!
I am very thankful for such a nice course.
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 : )
wow excelent teaching ....thank u sir:)
You are most welcome
when we split the data in the second normal form will it not violate the first normal form?
very very useful thank u
Really thank you so much fr this learned many concepts which i dont know as a fresher
Thank-you!!
Tq so much edureka....seach a wonderful video uppoloding ....🙏
Great tutorial.thank you
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 :)
Thank you so much for this course
You are very welcome
Thank you 🙏 for this great explanation 🔥
Helpful video :) Please make full length video on c .....
Thank you sir
Thank you. You are awsome
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 : )
Thank you so much for such a good tutorial
Exellent tutorial for beginners
Thankqq so much for this video sir
Most welcome Glad you liked it !!!
done full course from here
Very informative and very compact. Helped me to refresh my SQL knowledge. Thank you Edureka
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 : )
Thanks... please upload complete oracle tutorial...
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 : )
Is this enough tutorial for freshers please tell me friends
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 : )
Awesome work👏✊👍. Helped alot
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 : )
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 : )
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
Keep the good work coming.
Thank You 😊 Keep learning with us!!
Ty
Gained a good amt of knowledge
thank you very much
thank you!!!!!
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
what is the difference between drop and delete commands?
Great explanation 😊...
Thank you so much for your review on our channel Great to hear that Edureka is helping you learn better . We’ll strive to make even better learning contents/courses in the future ! Do subscribe the channel for more updates : )
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.
Good explanation it would be helpful if you share PPT slides to prepare for interview
As soon as possible
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 : )
thanks it was very much helpful superb video
You are most welcome.
Can you provide a link to the ppts for better understanding in the upcoming future?
Hey there :) We are glad to have you with us :) and more glad to have learners like you with us ! We are happy to share the source code ,please do drop your mail id to share the same :) 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 : )
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 : )
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
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
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 :)
Hi Edureka! Great content would you be able to send the PPT over so I can take notes directly on the slides? Many thanks!
Kindly drop your mail id so that we can send the datasets
How to insert values into single column which is created newly