All basic and advanced topics of  .Net/SQL Server including the following:

.Net Framework


OOPS

ADO.NET

ASP.NET

SQL Server

Remoting, Web services, and WCF

WPF and Silverlight

LINQ and Entity Framework.

Design Patterns, UML, Estimation and Project Management.

Ajax

Reports

Threading

XML

NET Interoperability

Windows and Workflow Foundation

SQL Server


Introduction to Databases & Microsoft SQL Server

Database Design

System Infrastructures

Advanced Querying

Modifying Data

Transactions and Locks

Writing Procedural Code with Transact-SQL

SQL Server object hierarchy.

Transaction Logs.

Schemas and Database Objects.

Systems Tables and Systems Views

Data Types.

Using Filestream and File Tables.

Working with Spatial Data.

Data Compression.

Indexes and Statistics.

Table Constraints.

Partitioning

Advanced Programming in SQL Server.

User-defined functions.

Stored Procedures.

Triggers.

XML

Programming on Multiple Instances.

Advanced Programming Technologies.

Managing a SQL Server Environment.

Backup and recovery.

SQL Server Security.

Using Encryption.

Automation in SQL Server.

Monitoring and Troubleshooting.

Availability and Scalability Solutions.

Implementing Replication.

Full-text search

Service Broker.

Designing the datawarehouse.

Transferring data with SQL server

SQL server analysis services

The reporting layer.