1:1 SQL Interview Session | Basics of SQL | SQL training | MySQL | IvyProSchool скачать в хорошем качестве

1:1 SQL Interview Session | Basics of SQL | SQL training | MySQL | IvyProSchool

Common SQL Interview Questions (Basic) are as follows: 1. How to import files in MySQL? 2. What is Normalization? 3. What is One to Many and Many to Many relationship? 4. Types of SQL statements? 5. How to find Unique names from a list? 6. Difference between where and having? 7. How to find second highest scorer? 8. Difference between Dense Rank and Rank? 9.How to find names containing single "e"? 10.Which Join would you prefer for a particular question? To watch the next level interview visit -    • 1 : 1 SQL Intermediate Interview Session |...   Learn Python with Ivy Pro School: https://www.youtube.com/playlist?list... Learn more about our Students Success Stories: https://www.youtube.com/playlist?list... Liked the video? Subscribe to Our Channel to get regular updates on amazing Data Science Industry Talks, Interviews, and Webinars. Want to take a Data Science Course with @IvyProSchool - visit us at http://bit.ly/39OOhgM or call us at 7676882222 0:00 Introduction 1:21 What have you done in MySQL database? 1:51 What kind of data have you imported? 2:06 Why did you choose MySQL? 2:42 Focus on DB Management Platform or Language? 3:10 What did you like and dislike about SQL? 4:38 Workbench/Command prompt to import files? 5:13 Normalization 6:55 Where should we place foreign key? 7:13 One to many relationship 10:46 Many to many relationship 14:43 Types of SQL statements 15:29 Examples of DDL & DML statements 19:37 Select statements 19:46 How to find unique names? 21:28 Difference between where and having? 22:04 2nd Highest Scorer 24:57 Dense Rank vs Rank 27:22 Names containing single 'e' 29:23 Joins