Querying MS SQL Training Online | Designing Database Structure

http://tiny.cc/qubkwx Save 50% at DbSchema
www.simplilearn.com/os-and-databases/querying-microsoft-sql-server-2012-certification-training?utm_campaign=Designing-Database-Structure-ZqvSKYmU38Q&utm_medium=SC&utm_source=youtube Designing Database Structure Determining business requirements is one of the absolute most important steps in any kind of database design project and actually in any kind of project especially at T projects and you will see questions about this on the exam. It is to get now there are some project management faces some of the problem out there on the internet but it's kind of funny but what makes it funny is it's all too real we've all been a part of these projects. Just kind of somewhere along the way go awry and we can usually traced back to the business requirements phase. The main project management Phases: 1. Wild enthusiasm, including doughnuts at each meeting. 2. Mild disillusionment no more doughnuts 3. General confusion 4. Uncontrolled panic 5. Punishment of the innocent & cancellation of the project 6. Promotion of the non-participants Determining Business Requirements First Step: Determining requirements are what exactly is this particular database supposed to do what problem are we trying to solve how many people are involved all those sorts of things to everybody agrees on these requirements however they don't agree on how to actually get to the end of the road with these things in a meaningful way just give me some highlights here watch for these on the exam interview key stakeholders key stakeholders. Anybody in the chain that's involved with the data that are key stakeholders. We need to interview them and see what's important but they consider important data what features they consider important what aspects of this database to they consider important those sorts of things you can also conduct focus groups with future users of the database find out from them what's most important what do you need what do you have to have do your job how are you running this business what data are you using how do you measure that day that you can even schedule brainstorming sessions for end user input lot of different ways but the bottom line is you want to find out exactly what it is that you're trying to solve what specific set of problems you trying to design for solving into this particular database right then you want to produce a very specific requirements document. Watch full video to learn more For more updates on courses and tips follow us on: - Facebook : https://www.facebook.com/Simplilearn - Twitter: https://twitter.com/simplilearn Get the android app: http://bit.ly/1WlVo4u Get the iOS app: http://apple.co/1HIO5J0