Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For Edureka MySQL DBA training curriculum, Visit our Website: bit.ly/2B5EwLJ
What is the difference between DELETE and TRUNCATE statements 1:!8 What are the different subsets of SQL 2:06 What do you mean by DBMS> What are its different types 3:32 What do you mean by table and field in SQL 4:57 What are joins in SQL 5:44 What is the difference between CHAR and VARCHAR2 datatype in SQL 6:00 What are constraint 7:48 What is the difference between SQL and mySQL? 9:28 What is unique key? 10:22 What is foreign key? 10:22 What is data integrity 11:25 What is the difference between Clustered and Non-clustered index in SQL? 11:57 Write a SQL query to display the current date 13:04 Different types of joins 14:10 Denormalization 15:36 Entities and Relationships 16:15 Indexes 17:36 DIfferent Types of Indexes 18:26 Normalization and its advantage 19:23 Differences between Drop and Truncate 20:09 Different Types of Normalization 20:55 What is ACID 25:05 Trigger in SQL 26:03 Different Operators of SQL 27:20 NULL value vs zero or blank space 27:31 CROSS JOIN VS NATURAL JOIN 28:07 Subquery 28:37 Different types of subqueries 29:28 List Ways of get the count of records in table 30:08 Write SQL query to find names of employees that begin with "A" Write SQL query to get the third highest salary of an employee from employee table Group functions in SQL 32:10 What is Relationship and types of relationships 32:38 How to insert NULL values in a column when inserting data 33:40 Explain BETWEEN vs IN with an example Why are SQL functions used 34:59 What is the need of MERGE statement 35:17 What is recursive stored procedure 35:40 What is CLAUSE 36:08 HAVING CLAUSE vs WHERE CLAUSE 36:40 List ways of Dynamic SQL 37:20 Levels of constraints 37:46 Fetch common record from two tables 38:00 List Case manipulation functions 38:49 Different set operators 40:06 ALIAS command 41:10 What are aggregate and scalar functions 41:47 Fetch alternate (ODD/EVEN) records from a table 42:26 Name the operator which is used in query for pattern matching 43:22 Unique records from a table 44:22 Fetch first five letters from a string 44:43 Main difference between SQL and PL/SQL 45:33 What is a view 46:20 What are views used for 47:00 What is stored procedure 47:11 Advantages and Disadvantages of Stored Procedures 47:57 List all types of user-defined functions 48:36 Collation 48:44 Types of Collation Sensitivity 49:09 Local vs Global variables 49:27 Auto increment 50:07 Data warehouse 50:47 Authentication modes in SQL servers 50:57 STUFF and REPLACE function 51:56
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:)
This very helpful. Thanks a lot! It would be great if it has the concepts of CTE, temp table, and their differences, try-catch block, stored procedures vs functions, sql profiler, and execution plan.
Hi, I have attended the interview, got a lots of questions so please help me out in this regard. Queries 1. When have to create a clustered index and nonclustered index in a table ? 2. When have to use union or joins? 3. Why use views? 4. When have to use cursors? Give an live example with data 5. How many Max columns can be created in a table at a time ? 6. What is difference between decimal and float Please reply..!!
Hi, You can find the answers for all these questions here: www.edureka.co/blog/mysql-tutorial/. And you can also refer to this: www.edureka.co/blog/sql-commands
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 : )
It was a very helpful video for me..to brush up my knowledge about sql.. I hope I'll pass my interview regarding sql...thank u so much..lots of respect..
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 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 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 : )
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 : )
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 : )
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 !
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 : ) 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:)
Hi Narayana, thanks for watching the video. We will process your request as soon as possible. Do subscribe to our channel and stay connected with us. 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 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 : )
You're welcome 😊 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 : )
Thanks for the appreciation. We are delighted to see learners like you on-board with us. Do subscribe, like and share to stay connected with us. 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 : )
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 for appreciating our efforts. We are glad that our video was of great help to you. Do subscribe to our channel and stay connected with us. Cheers!
Thanks for the compliment! We are glad that our video was of great help to you. Do give this video a thumbs up and subscribe to the channel for more amazing content.
Hey Abhijit, thank you for appreciating our efforts! We are glad you loved the video. Do give this video a thumbs up and subscribe to the channel for more amazing content. Cheers!
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 : )
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 : )
You're welcome! Glad to help you :) 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 : )
Just as much info as needed for every question. No more, no less. And so many questions are really common in interviews. Thanks a lot for sharing such useful knowledge!
Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For Edureka MySQL DBA training curriculum, Visit our Website: bit.ly/2B5EwLJ
It's really useful for preparing interview
What is the difference between DELETE and TRUNCATE statements 1:!8
What are the different subsets of SQL 2:06
What do you mean by DBMS> What are its different types 3:32
What do you mean by table and field in SQL 4:57
What are joins in SQL 5:44
What is the difference between CHAR and VARCHAR2 datatype in SQL 6:00
What are constraint 7:48
What is the difference between SQL and mySQL? 9:28
What is unique key? 10:22
What is foreign key? 10:22
What is data integrity 11:25
What is the difference between Clustered and Non-clustered index in SQL? 11:57
Write a SQL query to display the current date 13:04
Different types of joins 14:10
Denormalization 15:36
Entities and Relationships 16:15
Indexes 17:36
DIfferent Types of Indexes 18:26
Normalization and its advantage 19:23
Differences between Drop and Truncate 20:09
Different Types of Normalization 20:55
What is ACID 25:05
Trigger in SQL 26:03
Different Operators of SQL 27:20
NULL value vs zero or blank space 27:31
CROSS JOIN VS NATURAL JOIN 28:07
Subquery 28:37
Different types of subqueries 29:28
List Ways of get the count of records in table 30:08
Write SQL query to find names of employees that begin with "A"
Write SQL query to get the third highest salary of an employee from employee table
Group functions in SQL 32:10
What is Relationship and types of relationships 32:38
How to insert NULL values in a column when inserting data 33:40
Explain BETWEEN vs IN with an example
Why are SQL functions used 34:59
What is the need of MERGE statement 35:17
What is recursive stored procedure 35:40
What is CLAUSE 36:08
HAVING CLAUSE vs WHERE CLAUSE 36:40
List ways of Dynamic SQL 37:20
Levels of constraints 37:46
Fetch common record from two tables 38:00
List Case manipulation functions 38:49
Different set operators 40:06
ALIAS command 41:10
What are aggregate and scalar functions 41:47
Fetch alternate (ODD/EVEN) records from a table 42:26
Name the operator which is used in query for pattern matching 43:22
Unique records from a table 44:22
Fetch first five letters from a string 44:43
Main difference between SQL and PL/SQL 45:33
What is a view 46:20
What are views used for 47:00
What is stored procedure 47:11
Advantages and Disadvantages of Stored Procedures 47:57
List all types of user-defined functions 48:36
Collation 48:44
Types of Collation Sensitivity 49:09
Local vs Global variables 49:27
Auto increment 50:07
Data warehouse 50:47
Authentication modes in SQL servers 50:57
STUFF and REPLACE function 51:56
THANK YOU SO MUCH FOR THIS VIDEO . I ONLY STUDIED FROM YOUR VIDEO FOR MY INTERVIEW AT FEDEX AND I'VE GOT DESIRED JOB ROLE . 💟💟💟💟💟💟💟💟💟
Question No 52 : To fetch the first 5 characters from a string is not RIGHT() function it should be LEFT() Function
Gone through all the questions. Feeling more confident now, Thanks edureka for the amazing content 🙂
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:)
I have an interview tomorrow. Thanks a lot. It was really helpful!
We are glad that our video was of great help to you. Do subscribe to our channel and stay connected with us. Cheers :)
Thanks a lot helped me create notes and brushing up ! Kudos to you guys
For creating this type of content on SQL you deserve salute thank you very much mam
Wow! thank you so much, just finished reviewing and studying this questions. I'll put them to use now.
Damn!
This was more productive session than a college lecture
Thanks for this video. It recalled all my concepts and helped me to clear one telephonic round..
Thank you for the video. Sharp answers. Great for interview preparation
Thank you zillion times! Really helped me for the preparation of the Associate Software Developer interview!
Thanks for the video. Very helpful. I'm amazed by this girl .. She literally spoke non-stop . :D
This very helpful. Thanks a lot! It would be great if it has the concepts of CTE, temp table, and their differences, try-catch block, stored procedures vs functions, sql profiler, and execution plan.
Hi, thank you for your wonderful suggestion, we have considered your feedback and will work on it. Do subscribe to our channel for updates, cheers :)
Thank you so much. This session is really helped me allot.
This video was helpful. A review of execution plans would be helpful.
Hi,
I have attended the interview, got a lots of questions so please help me out in this regard.
Queries
1. When have to create a clustered index and nonclustered index in a table ?
2. When have to use union or joins?
3. Why use views?
4. When have to use cursors? Give an live example with data
5. How many Max columns can be created in a table at a time ?
6. What is difference between decimal and float
Please reply..!!
Hi, You can find the answers for all these questions here: www.edureka.co/blog/mysql-tutorial/. And you can also refer to this: www.edureka.co/blog/sql-commands
extreamly useful for me as I am preparing for placement , and yes Happy new Year
Very helpful video , well explained and very good collection of interview questions , Thankyou 🙏
Nice, God job you did in this video. First Time I saw complete video of SQL.
Happy with this video 👍
Got so much of clarity on SQL Related questions and Answers.Thanks for the effort.
Good To know our videos are helping you learn better :) Stay connected with us and keep learning ! Do subscribe the channel for more updates : )
Wow amazing I found all valuable questions and whole syllabus is covered... Thanks alot! 👏👏👍
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 : )
I loved the Edureka tutorials by Sahiti. She explains so well and to the point. Springboot tutorial also quite good.
Hey Rachana, thanks for appreciating our efforts. We are glad you loved the video. Do subscribe to our channel and stay connected with us. Cheers!
It was a very helpful video for me..to brush up my knowledge about sql..
I hope I'll pass my interview regarding sql...thank u so much..lots of respect..
You are welcome👍
We're glad we could be of help. It's very encouraging to know that you found our content useful.
Whao ! Great!! It really helps a lot. Can the pdf format of the questions and answers be provided? Thanks a bunch!
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 : )
you guys are really doing great job.
in normalization, 1 NF, why did we remove the column "Category" from table and never used it later?
Thank you for great session which really helps for beginners 👍🏻
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 for this video. Helped me clear a round. Almost every question asked was covered in this video. Great work!
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 : )
This video is pure gold, thank you so much team for putting this together.
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 this! I just finished a coding camp and wanted to review everything about sql and its alllll here. Thanks :)
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 : )
Gone through all the questions. Amazing content as well as explanation😃
Thank you😊 Glad you liked it!! Keep learning with us..
Well explanation for interview preparation on SQL. Thank you.
very good explanation...i had more confident on sql by saw this video thanks a lot...🙂
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 !
Thank you so much it was very helpful
Amazing energy level, Thanks for crisp and clear presentation
Very good and useful.Good explanation madam.Thank you so much......
You are most welcome !! Glad you liked it !!
feeling more confident thanks Edureka🙂🥰
You are welcome 🙂 Glad it was helpful!!! Keep learning with us...
Really helpful and very well explained. Thanks a lot!
Very very helpful................Thanks a ton
Awesome work Guys!! ❤️❤️Loved it!! 👍💐
Thanks for helping us interview preparation
Whoever watching this video,
I am telling you this could be the productive 53:44 of your life...
This is such a great video and informative. I appreciate your fast and quick simple explanation. Keep it up .....Best of luck. Thank you
Thank you for the tutorial, it is very helpful
I have SSMS installed
Can I get a pdf of this tutorial so I can practice sql with complex commands
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
I should have watched this yesterday:-)
Non stop interview questions 😀
Very attentive session, thanks for this video
You're welcome 😊 Glad it was helpful!! Keep learning with us
Can we convert a date to char in oracle and if so,what would be the syntax...🤔🤔🤔
🏆🏆🏆🏆🏆thanks
Timeline 33:38 , NULL values can also be inserted via DEFAULT constraint !
Five star for your energetic and Superb explanation🙏
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 : )
Really great tutorial. Your explaining speed is little fast only
Please upload the more video related sql queries interview questions... Like 32:10..
Very nice video.. only.speed was a problem..It was too fast. Thank you!
Very knowledgeable and correct video for sql interviews 👍👍
Amazing very valuable and helpful video thnx for sharing
Very detailed and comprehensive.
Thank you so much Mam. Good bless u :)
Really helpful and made me more confident.
Great to hear!
Amazing energy level and content.... Thanks for making this video and helping out lacs of ppl.
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:)
Please post the experienced interview questions also...
Hi Narayana, thanks for watching the video. We will process your request as soon as possible. Do subscribe to our channel and stay connected with us. Cheers!
These ques are really helpful
Can you please share the pdf of these ques
All things covered in this session were useful
Awesome training videos. Good job guys
Thank you!!!!! It is really really helpful.
Awesome! Thanks
You're welcome 😊 Glad you liked it!!
It's deeply helpful for SQL server study
Glad it was helpful!!
Amazing 😊
Only 5 mins to explain normalization with its type ... hatss off ..
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:)
Can you please share interview questions for a PL/SQL developer with 1-2 years of experience?
The way you are explained is 💯 understable and perfect mam....
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 a lot edureka 💙
what is fixit length and what is schema what is synonyms
THANKS A LOT FOR SUCH A WONDERFUL EXPALANATION...I DID WELL IN THE INTERVIEW
You're welcome 😊 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 : )
Thanks for share this!!! Blessings!
Such a helpful video for SQL Interview, thank you so much!
Good To know our videos are helping you learn better :) Stay connected with us and keep learning ! Do subscribe the channel for more updates : )
Big thanks from Minsk! I have a bad english, but understand what you mean!!! Good luck for you chanel)
Thanks for the appreciation. We are delighted to see learners like you on-board with us. Do subscribe, like and share to stay connected with us. Cheers!
Hi, firstly I really thank you for videos. I am very grateful you. Hopefully you are the best in your carrier which is bigger than your imagination
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 : )
Hello ma'am can we have questions for the interview of a business analyst trainee
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 this video
You are so welcome!
Thank you edureka team..
Really very nice video. I have attended several interviews and ii got most of the question from this Video.
Thanks a lot
Thank you for appreciating our efforts. We are glad that our video was of great help to you. Do subscribe to our channel and stay connected with us. Cheers!
Very helpful and clear explanation, thank you so much.
Well done and very helpful -thank you for putting this together!
Thanks for the compliment! We are glad that our video was of great help to you. Do give this video a thumbs up and subscribe to the channel for more amazing content.
Very nice explanation covered most of the important topics and that too in a less time frame Thanks..!!
Hey Abhijit, thank you for appreciating our efforts! We are glad you loved the video. Do give this video a thumbs up and subscribe to the channel for more amazing content. Cheers!
Nice video
Superfast orator...🤣🤣👌👌...quite helpful
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 : )
great work
Thank you! 😊
Thanks alote for good explanation please send me all note about java selenium and. SQL
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 : )
How can show the 5 th row of the table plz share statement in sql
Really helpful!
Thank you so Much. very Helpful
You're welcome! Glad to help you :) 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 : )
Great!!! Thanks a lot for sharing this
Such great content.!! Where will I get this pdf ?
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 : )
Awesome Interview resources....Thank you
Hi Abiodun. thank you. Do subscribe to our channel and stay tuned for more informative resources to ace in your career. Happy learning :)
I need a snowflake developer interview questions
Tq ma'am
Just as much info as needed for every question. No more, no less. And so many questions are really common in interviews.
Thanks a lot for sharing such useful knowledge!
Hi Anton, thank you for your valuable feedback. Happy learning :)