Topics to be familiarized to become a Team Lead/Project Lead


General

1. Software Development Life Cycle(SDLC).

2. Knowledge about the current project.

• Technical and domain knowledge.
• Architectural Design.
• Interesting issues resolved.
• Failures and reasons.
• Achievements. 

3. Design Patterns (Various design patterns and where to use)

4. VSS or CVS Management - Administration.

5. Cost and time estimation (Function Point Analysis, COCOMO, Empirical model etc.,)

6. Improving the ASP.Net Web site performance.

• Perfmon.exe tool.
• Http Compression, Gzip Compression
• Caching
• Database tuning.
• Load testing, Stress testing
• Others 

7. Mental Ability

• Go through the project leader, team leader and project manager interview questions 

8. Microsoft Office Project 2003 or 2007 (.mpp file)

• Creating, allocating date and time for resources.
• Finding the approximate build, release dates. 

9.Reporting and Charting tools (you should know atleast one reporting tool)

• Crystal Reports
• Flex
• Microsoft Charting Controls 

10. OO Modeling

• UML (Practice all nine diagrams)
• DB design - ER diagrams. 

11. Most important Microsoft Excel ( You will be mostly working on this, when you become a manager)

• Formulae.
• Shortcuts
• Pivot tables
• Lining the sheets
• Filter, Custom filters etc., 

.Net and Related

1. Basic dot net and other technical knowledge.

2. AppDomain, Http Handlers, Http Modules etc.,

3. Web site life cycle and ASP.Net page Life Cycle.

• What happens when a web site name typed in browser?
• (IE -> http.sys -> w3wp.exe -> aspnet_isapi.dll -> HttpApplication -> HttpModules -> HttpHandlers -> Asp.Net Page Life Cycle.) - Explain the full story. Code Project Explanation 

4. Advanced or latest technical skills

• Jquery
• LINQ
• Ajax
• Different between .net frameworks 2.0, 3.0 and 3.5, 4.0

5. Microsoft Visual Studio 2008 and Framework 3.5

• WPF, WCF, WWF related questions
• 3.5 related questions
• Silverlight 

6. Web services and WCF

• In and Out of Web Services.
• Comparison between Web Services and WCF. 

SQL Server

1. SQL Server Basic.

• Index, transaction, ACID properties etc.,
• MSDTC internals.
• Database restore, backup, permission etc., 

2. SQL Server Advanced.

• Database mirroring, replication, etc., 

3. Performance Tuning

• Execution Plan
• Profiler
• Database Engine Tuning Advisor
• SQL statistic tables etc., 

4. Different between SQL Server versions 2000, 2005 and 2008

5. SSIS, SSRS etc.,