Mam, still how many concepts in DBMS are left? If possible, can you please list them, i can refer those using other resources. I'm currently preparing for interviews, this would be a very great help for me
Hey! Study the basic Relational Algebric expressions with examples. Based on that you can get questions on SQL. How to select databases in SQL, select tables, modify, delete or store data in the tables. What if you need some data from 2 or more than 2 tables, which operation would you use? U must know the basic programming in SQL like SELECT, JOIN, etc and a basic understanding of how we query the databases in SQL
Normalization, data integrity and security, ACID properties, data warehousing, backup and recovery ka little knowledge will be helpful. I'm assuming you've done architecture and models, normalization. Some knowledge about NoSQL databases will also be helpful. If the time is short, brushing up the top layers of all of this will be enough. You must sound knowledgeable, they must know that you know some things about all of these.
درس جميل
Shukran
Mam, still how many concepts in DBMS are left? If possible, can you please list them, i can refer those using other resources. I'm currently preparing for interviews, this would be a very great help for me
Hey!
Study the basic Relational Algebric expressions with examples. Based on that you can get questions on SQL. How to select databases in SQL, select tables, modify, delete or store data in the tables. What if you need some data from 2 or more than 2 tables, which operation would you use? U must know the basic programming in SQL like SELECT, JOIN, etc and a basic understanding of how we query the databases in SQL
Normalization, data integrity and security, ACID properties, data warehousing, backup and recovery ka little knowledge will be helpful. I'm assuming you've done architecture and models, normalization.
Some knowledge about NoSQL databases will also be helpful.
If the time is short, brushing up the top layers of all of this will be enough. You must sound knowledgeable, they must know that you know some things about all of these.