Getting started with .NET and MVC Videos

We have compiled most frequently asked .NET Interview Questions which will help you with different expertise levels.

Getting started with .NET and MVC Videos

Every time I update my edition, I always want to do something crazy for my readers. Here’s one awesome gift you get with this book. Learn .NET and MVC for free. With this book, you will get a DVD (Digital Video/Versatile Disk) which has the below videos which help you to learn .NET and MVC absolutely free. So enjoy the video series created by me personally. Below is the complete list of video indexes.

Learn .NET in 60 days

(Day 1 )Lab 1: Creating your first program (Day 1) Lab 2: Creating your first program (Day 1) Lab 3: Integer DataType (Day 1) Lab 4: Exception Handling (Day 1) Lab 5: IF Condition, Return Try/Catch (Day 2) Lab 6: Commenting (Day 2) Lab 7: For Loop (Day 2) Lab 8: Simple calculator program (Day 3 )Lab 9: Creating Your First Application (Day 3) Lab 10: Creating the Customer Screen (Day 4) Lab 11: Displaying Customer Screen (Day 4) Lab 12: Multiple Document Interface(MDI) (Day 5) Lab 13: Classes & Objects (Day 6) Lab 14: Getting Data from SQL Server (Day 7) Lab 15: Inserting data into SQL Server (Day 7) Lab 16: Connection string in App.config (Day 8) Lab 17: Delete Functionality

(Day 9) Lab 18: Update Functionality (Day 9) Lab 19: 2 Tier Architecture (Day 10) Lab 20: Creating a Web application (Day 10) Lab 21: Connect app to DAL (Day 11 and 12) Lab 22: Insert, Update and Delete (Day 13) Lab 23: Implementing 3 Tier Architecture (Day 14) Lab 24: Security (Day 15) Lab 25: Web Security (Day 16) Lab 26: REGEX (Day 17) Lab 27: Improving Database Design (Day 18) Lab 28:1 to many relationship (Day 19) Lab 29:1 to Many(lnsert) (Day 20) Lab 30:1 to Many(Select and Delete) (Day 21) Lab 31:1 to Many(Update) (Day 22) Lab 32: Stored Procedure Day 23 to Day 60: Project

Learn MVC Step-by-Step

Learn MVC 5 Step-by-Step Lab 1: Simple Hello world. Lab 2: Explain MVC Routing. Lab 3: Explain ViewData, ViewBag, TempData, and Session. Lab 4: Explain Model and Strongly typed views. Lab 5: Explain Model Binders.

 

It’s very important during interview to be clear about what position you are targeting. Depending on what positions you are targeting the interviewer shoots you questions. Example if,you are looking for a project manager position you will be asked around 20% technical questions and 80% management.

Note: In small scale software house and mid scale software companies there are chances where they expect 
a PM to be very much technical. But in big software houses the situations are very much different, interview 
are conducted according to positions.... Unless the interviewer changes the rule.

Figure 22,1 shows a general hierarchy across most IT companies.

Note: There are many small and medium software companies which do not follow this hierarchy 
and they have there own adhoc way of defining positions in the company.

So why is the need of hierarchy in a interview.

“Interview is a contract between the employer and candidate to achieve specific goals. ”

So employer is looking for a suitable candidate and candidate looks for a better career. Normally in interviews, the employer is very clear about what type of candidate he/she is looking for. However, 90% times the candidate is not clear about the positions he/she is looking for.

How many times it has happened with you that you have given a whole interview and when you mentioned the position you are looking for…pat comes the answer, “ we do not have any requirements for this position”. So be clarified about the position right from when you start the interview.

Following are the number of years of experience according to position.

• Junior engineers are especially freshers and work under software engineers.
• Software engineers have around 1 to 2 years of experience. Interviewer expects software engineers to be technically at a medium level.
• Senior Software Engineers have around 2 to 4 years of experience. Interviewer expects them to technically be very strong.
• Project leads should handle majority technical aspect of project and should have around 4 to 8 years of experience. They are also indirect architect of the project. Interviewer expects them to be technically strong so that they can drive the architecture part of the project. Interviewer also expects them to have people management skills.
• Project Manager are expected to be around 40% technically strong and should have experience above 10 years plus. But they are more interviewed from aspect of project management, client interaction, people management, proposal preparation, etc.

So now judge where you stand, and where you want to go

Resume Preparation Guidelines

First impression the last impression

Note: A sample resume is provided in “SampleResume” folder.

Before even the interviewer meets you he will first meet your resume. Interviewer looking at your resume is almost a 20% interview happening without you knowing it. I was always a bad guy when it comes to resume preparation. But when I looked at my friends resume they where really good. Now that I am writing series of book on interviews I thought this will be a good point to put in. You can happily skip it if you are confident about your resume. There is no hard and fast rule that you have to follow the same pattern but just see if these all check list are attended.

• Use plain text when you are sending resumes through e-mail. For instance you sent your resume using Microsoft Word and what if the interviewer is using Linux he will never be able to read your resume. You cannot be sure both wise, you sent your resume in Word 2000 and the guy has Word 97…uuhhh.
• Attach a covering letter it reaily impresses and makes you look traditionally formal. Yes, even if you are sending your CV through e-mail send a covering letter.

Check list of content you should have in your resume:

• Start with an objective or summary, for instance, “Working as a Senior Database administrator for more than 4 years. Implemented quality Web-based application. Follow the industry’s best practices and adhered to and implemented processes, which enhanced the quality of technical delivery. Pledge to deliver the best technical solutions to the industry.”
• Specify your Core strengths at the start of the resume by which the interviewer can make a quick decision are you eligible for the position. For example:

o Looked after data mining and data warehousing department independently. Played a major role in query optimization.
o Worked extensively in database design and ER (Entity Relationship) diagram implementation.
o Well versed with CMMI (Capability Maturity Model Integration) process and followed it extensively in projects.
o Looking forward to work in a project manager or senior manager position.

This is also a good position to specify your objective or position which makes it clear to the interviewer that should he call you for an interview. For instance, if you are looking for senior positions specify it explicitly ‘looking for this job profile’. Any kind of certification like MCP (Microsoft Certified Professional), MCSD (Microsoft Certified Systems Engineer), etc., you can make it visible in this section.

Once you have specified briefly your goals and what you have done its time to specify what type of technology you have worked with. For instance RDBMS (Relational Database Management System), Tools, Languages, Web servers, process (Six sigma, CMMI).

• After that you can make a run-through of your experience company-wise that is what company you have worked with, year/month joining and year/month left. This will give an overview to the interviewer what type of companies you have associated your self.

Now its time to mention all the projects you have worked on till now. The best is to start in descending order that is from your current project and go backward. For every project try to put these things:

• Project Name / Client name (It’s sometimes unethical to mention the client’s name; I leave it to the readers).
• A number of team members.
• The timespan of the project.
• Tools, language, RDBMS, and technology were used to complete the project.
• Brief summary of the project.

Senior people who have huge experience will tend to increase their CV (Curriculum Vitae) by putting in summary for all projects. The best for them is to just put descriptions of the first three projects in descending manner and rest they can say verbally during the interview. I have seen my CV above 15 pages… I doubt who can read it.

• Finally comes your education and personal details.
• Trying for onsite, do not forget to mention your passport number.
• Some guys tend to make their CV large and huge. I think an optimal size should be no more than 4 to 5 pages.
• Do not mention your salary in your CV. You can talk about it during an interview with HR (Human Resources) or the interviewer.
• When you are writing your summary for the project make it effective by using verbs like managing a team of 5 members, architected the project from start to finish, etc. It brings huge weight.
• This is essential to take 4 to 5 Xerox copies of your resume you will need it now and then.
• Just in case take at least 2 passport photos with you. You can escape it but many times you will need it.
• Carry all your current office documents especially your salary slips and joining letter.

Salary Negotiation

Ok, that’s what we all do it for MONEY… not everyone but still, money means a lot. This is probably the weakest area for techno-savvy guys. They are not good negotiators. I have seen so many guys at the first instance they will smile and say “NEGOTIABLE SIR”.

So here are some points:

1. Do a study of what is the salary trend? For instance, have some kind of baseline. For example, what is the salary trend on the number of years of experience? Discuss this with your friends out.

2. Do not mention your expected salary on the resume?

3. Let the employer first make the salary offer. Try to delay the salary discussion till the end.

4. If they say what you expect? Come with a figure with a little higher-end and say negotiable. Remember never say negotiable on something which you have aimed, HR persons will always bring it down. So negotiate on AIMED SALARY plus something extra.

5. The normal trend is that they look at your current salary and add a little it so that they can pull you in. Do your homework my salary is this much and I expect this much so whatever it is now I will not come below this.

6. Do not be harsh during salary negotiations.

7. It’s good to aim high. For instance, I want 1 billion dollars/month but at the same time be realistic.

8. Some companies have those hidden costs attached in salary clarify it rather than be surprised at the first salary package.

9. Many of the companies add extra performance compensation in your basic which can be surprising at times. So have a detailed breakdown. The best is to discuss on-hand salary rather than NET or CTC (Cost to Company).

10. Talk with the employer about what frequency does the hike happens.

11. Take everything in writing, go back to your house, and have a look once with a cool head is the offer worth of what your current employer is giving.

12. Do not forget once you have a job in hand you can come back to your current employer for negotiation.

13. Remember the worst part is cribbing after joining the company that your colleague is getting more. So be careful while interview or be sportive to be a good negotiator in the next interview.

14. One very important thing is that the best negotiation ground is not the new company where you are going but the old company which you are leaving. So once you have offered on hand get back to your old employee and show them the offer and then make your next move. It’s my experience that negotiating with the old employer is easy than the new one….Frankly if approached properly rarely anyone will say no as you have spent quite an amount of time with them. Just do not be aggressive or egoistic that you have an offer on hand.

15. Top of all some time some things are worth above money: JOB SATISFACTION. So whatever you negotiate if you think you can get the JOB SATISFACTION aspect on higher grounds go for it. I think it’s worth more than money.

Applicable to Only India
Years of experience	Amount in Rupees CTC (Monthly)
Freshers 1 to 2 yrs 4 to 6 6 to 8 8 to 10 yrs 10 to 15 yrs 15 yrs and above	15000 to 20000 25000 to 30000 40000 to 60000 60000 to 70000 70000 to 90000 90000 to 110000110000 and above. Mostly depends on negotiations.

 

Note: The Indian salary card is as per India mega cities like Mumbai, Pune, Banglore, Chennai, 
Hyderabad, Delhi, etc. For mid size cities like Lucknow, Nagpur, Ahmedabad, Amritsar, etc., the CTC will be 15% less.

Applicable to US Only
Years of experience.	Amount in Dollars (Yearly)
Fresher’s 2 to 4 yrs 4 to 6 yrs 6 to 8 yrs 8 to 12 yrs 12 and above	45000 to 55000 55000 to 60000 60000 to 65000 70000 to 80000 80000 to 90000 Depends on negotiations

 

 Note: For big cities like NY, Chicago, California state and down town cities the US rated card will be 10% higher.

The scorecard shown above is completely derived from the author’s experience and interaction he had in his circle. It is not an approved scorecard by any authorized body as such and should be taken only as a benchmark to measure your success. Also, note that these rates are applicable for medium and large software companies. Small company rate cards are very irregular and governed by a single owner of the company. So the above rate card is not applicable for small companies. Many people do get mind-blowing salaries even with small experience which again the scorecard does not reflect.

Points to rememberPoints to remember

• One of the first questions asked during the interview is “Can you say something about yourself?
• Can you describe yourself and what you have achieved till now?
• Why do you want to leave your current company?
• Where do you see yourself after three years?
• What are your positive and negative points?
• How much do you rate yourself in .NET and SQL Server in one out of ten?
• Are you looking for onsite opportunities? (Be careful do not show your desperation of abroad journeys).
• Why have you changed so many jobs? (Prepare a decent answer do not blame companies and individuals for your frequent change).
• Never talk for more than 1 minute straight during the interview.
• Have you worked with the previous version of SQL Server?
• Would you be interested in a full-time Database Administrator job?
• Do not mention client names in the resume. If asked say that it’s confidential which brings ahead ^ qualities like honesty
• When you make your resume keep your recent projects at the top.
• Find out what the employer is looking for by asking him questions at the start of the interview and I best is before going to the interview. For example if a company has projects on server products employers’ will be looking for BizTalk, CMS (Content Management System), experts.
• Can you give a brief about your family background?
• As you are fresher do you think you can really do this job?
• Have you heard about our company? Say five points about our company? Just read at least once what company you are going for?
• Can you describe the best project you have worked with?
• Do you work on Saturday and Sunday?
• Which is the biggest team size you have worked with?
• Can you describe the current project you have worked with?
• How much time will you need to join our organization? What’s the notice period for your current company?
• What certifications have you cleared?
• Do you have passport size photos, all academic mark sheets, previous companies’ employment letters, last month’s salary slip, passport, and other necessary documents?
• What is the most important thing that motivates you?
• Why do you want to leave the previous organization?
• Which type of job gives you the greatest satisfaction?
• What is the type of environment you are looking for?
• Do you have experience in project management?
• Do you like to work as a team or as an individual?
• Describe the best project manager you have worked with?
• Why should I hire you?
• Have you been ever fired or forced to resign?
• Can you explain some important points that you have learned from your past project experiences?
• Have you gone through some unsuccessful projects, if yes can you explain why did the project fail?
• Will you be comfortable with the location shift? If you have personal problems say no right at the first .stage…. or else within two months you have to read my book again. ;
• Do you work late nights? The best answer is if there is a project deadline yes. Do not show that it’s your culture to work during nights.
• Any special achievements in your life till now…tall your best project which you have done best in your career.
• Any plans of opening your own software company…Beware do not start pouring your Bill Gate’s
  dream to him can create a wrong impression.

Question 1.
Website references for .NET, ASP.NET, and SQL reading
Answer:
When it comes to interviewing preparation there is no end. Below are some sites which come in very handy for further interview preparation.

www.codeproject.com: This site is owned by Mr. Chris Maunder and has some finest articles on Microsoft programming technologies. I personally write articles on this site a lot.

www.stackoverflow.com: When it comes to programming this site is a savior. Short answers and solutions make it the number one solution site for programmers.

www.dotnetfunda.com: This site belongs to my dearest friend Mr. SheoNarayan and is one the oldest i and finest sites when it comes to .NET and Microsoft technologies.

www.itorian.com/: This site is run by Mr. Abhi Kumar Matsya who is a Microsoft ASP.NET MVP (Model View Presenter) and has some finest articles around ASP.NET and MVC. Do not miss his site it also has lectured in Hindi for programming.

HTTP: //www.kunal-chowdhurv.com/: Started by Mr. Kunal Chowdhury who is a Microsoft MVP (Windows Platform Development). This site has articles around Windows Phone, Silverlight, and Windows 8.

HTTP: //mavurtendulkar.com/: This site comes from Mr. Mayur Tendulkar who is from Pune a Microsoft ^ MVP in windows phone development. We call him the Xamarin guy. If you are looking at mobile development using Microsoft technologies his site is worth a visit.

HTTP: //poojabaraskar.com/: Driven by a young girl Pooja Baraskar this site talks about IOT (Internet ‘ of Things), Gaming and Windows Apps blog. \

HTTP: //csharppulse.Blogspot.in/: This site belongs Mr. Akhil Mittal who resides in Noida and is one ‘ of the very much knows authors on Codeproject and C# corner.

HTTP: //codepattern.net/Bloa/: This site is run by Mr Anil Kumar who is a C# corner MVP and wites ‘ mostly on Microsoft programming technologies.

HTTP: //www.jeanpaulva.com/: This is run by Mr. Jean Paul who is a Microsoft MVP and working as an architect for the past 15 years. The SharePoint and design pattern section of this site is worth looking at. HTTP: //www.f5debug.net/: This is site is run by Mr. Kathik who is a Microsoft ASP.NET MVP. Azure, ‘ Windows phone, and MSBI (Microsoft Business Intelligence) articles are nicely written on this site. –

HTTP: //gaurav-arora.com/: Started by Mr. Gaurav Arora who is from Noida. The articles section of this site has nice articles on C#, Visual Studio, and. NET.

HTTPs: //vivekcek.wordpress.com/: Mr. Vivek who hails from Trivandrum has started this site. It has a nice collection of Azure, C#, .NET, and design pattern sections. This is the only site I saw a dedicated section for TPL (Task Parallel Library).

HTTP: //www.dotnetjalps.com/: Mr. Jalpesh Vadgama who is a Microsoft MVP has started this blog has great articles and videos around C#, ASP.NET, Visual Studio, Architecture, and so on.

HTTP: //www.techmixing.com/: Started by Mr. Vivek Johari Sir, this site talks mostly on SQL Server. . Worth a visit.