Learn Complete Database Management System (DBMS). SQl (Structured Query Language). This is perfectly designed for Job Interview preparation. How to write SQL Queries. Simple and easy explanation for all SQL and DBMS concepts. Simple and to the point course for SQL Beginners. Learn SQL and DBMS in Hindi. New questions and answers are getting uploaded daily. You can subscribe the channel and click on bell icon to get notifications for the same.
Curated by: Coding Glitz (78 videos)
Top 50 Must prepare SQL interview questions and answers are discussed here in Hindi. This covers all the major SQL topics and all the concepts in SQL. In Truncate where condition cannot be used. Please ignore the typo in slide. ------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------- LinkedIn: www.linkedin.com/in/biplabparida Please like & share the video. Subscribe the Channel to keep watching interesting videos helpful for your career growth: https://youtube.com/channel/UCaoCTb7FoUYOo9R8r_X9YHg?sub_confirmation=1 -------------------------------------------------------------------------------------------- Learn SQL in 30 mins: https://youtu.be/cQCQXCW2qwA -------------------------------------------------------------------------------------------- Checkout different playlists: PLSQL Tutorial : https://youtube.com/playlist?list=PLKVxK2jv1oA-LwzbMlOFZS-CgbucH5OhQ Learn SQL for Beginners : https://www.youtube.com/playlist? list=PLKVxK2jv1oA9Ow28rg__JaBWjJQtoPyu6 SQL Interview Questions and answers: https://www.youtube.com/playlist?list=PLKVxK2jv1oA_t7KqNfdUgNC9x54vymFbb -------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------- Checkout Important videos : Top 30 SQL Queries Interview Questions and Answers : https://youtu.be/sa6_kqlglLs Top 50 SQL Concepts Interview Questions and Answers : https://youtu.be/UZAqMAzCZss Employee earning maximum salary in each department query : https://youtu.be/Q9bIOBds0lo How to delete duplicate rows from any table (2 different solutions): https://youtu.be/0Drirbci1fM How to find Nth highest salary (3 different solutions): https://youtu.be/lphtqFZ-iQc Tricky SQL Queries Part1 : https://youtu.be/-JwSWMm0E40 Basics of Database : https://youtu.be/xRte0DGB5KM SQL OPERATORS : https://youtu.be/VXDk8jXJN3Y AGGREGATE FUNCTION: https://youtu.be/SpvTUjPfV20 GROUP BY : https://youtu.be/tF_SU_5QXuU Solve any Date related query : https://youtu.be/a5N995aY9Fo How to use Substring : https://youtu.be/-O--KRzobas How to practice SQL Queries in local / Install Database in local : https://youtu.be/2RLyGa9dr8A IT Jobs without Coding : https://youtu.be/zTHRaNRxtXc -------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------- You can directly go to individual questions on clicking on the timestamp : What is DBMS ? 02:50 Why do we use DBMS and not files systems? 03:14 What is RDBMS? 03:37 Different data base management systems other than RDBMS? 4:11 What is Entity integrity? 05:11 What is referential Integrity? 05:20 What is Domain Integrity? 05:42 What are Constraints in SQL? 06:36 What are the various levels of constraints? 06:52 How can you select unique records from a table? 07:10 What is a Primary Key? 07:36 What is a Foreign Key? 08:24 List the different types of relationships in SQL? 09:00 What are the Different Types of SQL Commands? 09:48 What is DDL Command? 10:16 What is DML Command? 10:35 What is DCL Command? 10:56 What is TCL Command? 11:13 Difference between Delete, Drop and Truncate? 11:41 In Truncate where condition cannot be used. Please ignore the typo in slide Are NULL values same as that of zero or a blank space? 13:46 What is the Difference between NVL and NVL2? 14:12 Difference between UNION and UNION ALL? 14:52 What is an Alias ? 15:09 What is a Join? List its different types. 15:36 What is a Self-Join? 17:00 What are the different type of operators available in SQL? 17:23 Difference between CHAR and VARCHAR2 datatype in SQL? 17:44 What is Normalization? 18:19 Advantages of Normalization? 18:59 What are the Different Normal Forms? : 19:43 What is functional Dependency? 19:28 What is Denormalization? : 20:10 What are the differences between OLTP and OLAP? 20:33 What is a Subquery? What are its types? 22:19 What are some common clauses used with SELECT query in SQL? 22:31 What is the difference between ‘HAVING’ CLAUSE and a ‘WHERE’ CLAUSE? 22:37 What are Aggregate and Scalar functions? 22:57 What is a View? 23:42 What are Views used for? 23:59 What do you understand by query optimization? 24:11 What do you mean by “Trigger” in SQL? 24:44 What is a Stored Procedure? 25:07 What are the advantages of a Stored Procedure ? 25:26 List all the types of user-defined functions? 25:54 What is a synonym? 26:03 What are the different types of synonyms? 26:17 What is the usage of synonyms? 26:49 How do you store pictures in a database? 26:31 What is the difference between CLOB and BLOB? 27:31 What are different Anomalies in SQL? 27:56 Subscribe : https://youtube.com/channel/UCaoCTb7FoUYOo9R8r_X9YHg?sub_confirmation=1