Following are the most asked questions covered in Part 1 videos of MySQL Interview Q&A -

• Question 1 : Explain Normalization & Denormalization?
• Question 2 : Explain 1st,2nd and 3rd Normal Form in MYSQL Database Normalization?
• Question 3 : Primary Key vs Foreign Key?
• Question 4 : Primary Key vs Candidate Key vs Unique Key?
• Question 5 : What is a trigger? How you can create a trigger in MYSQL?
• Question 6 : Explain Transactions and How to Implement it in MYSQL?
• Question 7 : What is an index? How can an index be declared in MYSQL?
• Question 8 : What is the view? How can you create and drop view in MYSQL?
• Question 9 : Explain Inner Join?
• Question 10 : Explain Left Join?
• Question 11 : Explain Right Join?
• Question 12 : Explain Cross Join?
• Question 13 : MYSQL Union vs Union All?
• Question 14 : What are MYSQL Aliases?
• Question 15 : Explain MYSQL Subquery?
• Question 16 : Blob vs Text data types in MYSQL?
• Question 17 : CHAR vs VARCHAR data types?
• Question 18 : What are the differences between InnoDB and MyISAM engines?
• Question 19 : What are some of the common MYSQL COMMANDS?
• Question 20 : What are aggregate functions in MYSQL?