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.
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 : )
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:)
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 : )
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 : )
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
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:)
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 : ) 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 : ) 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 : )
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 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 : )
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
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 : )
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
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 : )
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 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
Hey there :)Thank you so much : ) We are glad to be a part of your learning journey. Definitely ! We are glad to have learners like you .Drop your mail id in the comment section for us to share the data sheets or source codes :) Do subscribe our channel and hit that bell icon to never miss an video from our 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
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 : )
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 :)
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 : )
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 : )
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!
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 : )
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 : )
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 : )
We are very glad to hear that your a learning well with our contents :) continue to learn with us and don't forget to subscribe our channel so that you don't miss any updates !
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 .
Awesome explanation. Anyone can easily learn through this video . Thanku ☺️
It’s was brief and quick learning of sql commands . Very nice course to prepare for interviews . Thankyou !!
Thanks to the Anil. This session helped me in revising and restoring all the concepts of SQL. Excellent!!!
Thank you so much.
You explained here allot of things.✌️
EXCELLENT TUTORIAL, Kindly also make a detail tutorial on Oracle
Thank you for your tutorial!
I successfully established SQL and PLC connection!
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.
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
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 : )
Thank you so much sir !!
It's really going to help for basic learniners...aweee very good explanation
Thank you 😊 Glad it was helpful!
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...
Love, love, love this girl. She is extraordinary teacher
very very useful thank u
best video , thank you so much , keep up the good work ❤
Glad you liked 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 : )
An excellent tutorial👏worth to watch😍
Instructor is awesome. Best tutorial I have come across👏
Thank you for the great course, can you send the spread sheet that contains the material of the course?
Definitely !please share your mail id so we can send you the material . Do subscribe the channel and hit the bell icon to not to miss any notifictions
Great, Covered each and every concept I have read in a full semester:)
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:)
Very helpful.....,Thankyou.
appreciate this video!!!!
wow excelent teaching ....thank u sir:)
You are most welcome
edureka was awesome sharing the information and this channel is the best for online learning platform , teaching was good and with clear cut examples
Like a gem to see this video
Hatss off
Helped me a lot to understand those concept.. Thank you
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 : )
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 : )
when we split the data in the second normal form will it not violate the first normal form?
awesome course! Thank you so much edureka!
You are doing very good job Edureka.. many thanks! :)
Tq so much edureka....seach a wonderful video uppoloding ....🙏
Thank you so much. well explained
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 : )
Thank you so much for this course
You are very welcome
Thank you very much. Instructor is excellent ..
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 :)
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
Bro you are just pro you completed all the points in sql worth watching
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 : )
Awesome work👏✊👍. Helped alot
Excellent video. All the concepts are explained perfectly.Thanks for sharing!
I am very thankful for such a nice course.
Thank-you!!
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
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:)
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 : )
Keep the good work coming.
Thank You 😊 Keep learning with us!!
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 : )
what a wonderful explanation of all the diff component of SQL. Thank you sir!!!
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 : )
Is this enough tutorial for freshers please tell me friends
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 :)
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 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
Exellent tutorial for beginners
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
what is the difference between drop and delete commands?
Very nice explanation any hard copy is with u
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 : )
Thank you sir
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 : )
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
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
This course begins or intermediate level covered
Thanks Edureka for helping us... can you please provide us with the PPT
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 : )
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 : )
From where we can find the sample databases that you have used for this course ?
Awesome efforts u have given sir 🙂
Really thank you so much fr this learned many concepts which i dont know as a fresher
Thank you bro as well as prepare pl-sql video also
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
Helpful video :) Please make full length video on c .....
Thank you soo much....can you provide examples pdf.....
Hey there :)Thank you so much : ) We are glad to be a part of your learning journey. Definitely ! We are glad to have learners like you .Drop your mail id in the comment section for us to share the data sheets or source codes :) Do subscribe our channel and hit that bell icon to never miss an video from our 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
The Course was very helpfull. 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 : )
Thank you so much for such a good tutorial
Thanks... please upload complete oracle tutorial...
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 :)
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 : )
Got intuition about SQL. 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 : )
Very informative and very compact. Helped me to refresh my SQL knowledge. Thank you Edureka
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!
How to insert values into single column which is created newly
Great content💯. Con you plz provide the ppt.
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 : )
Thank You! Please can u provide us the notes of this course?
You're welcome 😊 Glad it was helpful!!! Keep learning with us..
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 : )
very nice learning and explanation. please share ppt and source code.
Glad to hear our contents are helping you ! Please provide your mail id to share the data sheet :) We’ll update you soon
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 :)
thank you!!!!!
Thanks 👍💐
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
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 : )
thank you very much
Thank you ❤
Thanks to edureka for continous efforts to offer such a wonder course
We are very glad to hear that your a learning well with our contents :) continue to learn with us and don't forget to subscribe our channel so that you don't miss any updates !
thanks it was very much helpful superb video
You are most welcome.
Great Tutorial.