SQL Desing

Introduction to T-SQL Querying
Writing SELECT Queries
Querying Multiple Tables
Sorting and Filtering Data
Working with SQL Server 2012 Data Types
Using Built-In
Grouping and Aggregating Data
Using Subqueries
Using Table Expressions
Using Set Operators
Using Window Ranking, Offset and Aggregate Functions
Pivoting and Grouping Sets
Querying SQL Server
Executing Stored Procedures
Programming with T-SQL
Implementing Error Handling
Implementing Transactions
Improving Query Performance

MCSD Web Pack

MTA1:

Understanding core programming
Understanding object-oriented programming
Understanding general software development
Understanding .NET Framework concepts
Understanding namespaces and classes in the .NET Framework
Understanding .NET code compilation
Understanding I/O classes in the .NET Framework
Understanding security
Understanding .NET languages
Understanding memory management
  

MCTS: Microsoft Certified Technology Specialist:

Introduction to Entity Framework
Entity Framework modeling and persistence 
Understanding the Entity Data Model 
Understanding the ObjectContext class 
Development styles and different Entity Framework approaches 
Comparing the development styles 
The Database First approach 
The Model First approach 
The Code First approach 
Entity Framework Database First approach 
Entity Framework Model First approach 
Entity Framework Code First approach 
Performing CRUD operations using Entity Framework 
Choosing persistence approaches 
Entity Framework DB First – Managing Entity Relationships
Understanding database relationships
One-to-many relationship
One-to-one relationship 
Many-to-many relationship 
Entity Framework DB First – Performing Model Validations
Model validations using data annotations 
Summary
Entity Framework DB First – Inheritance Relationships between Entities
Domain modeling using inheritance in Entity Framework
The Table per Type inheritance 
The Table per Class Hierarchy inheritance
The Table per Concrete Class inheritance
Choosing the inheritance strategy
Entity Framework DB First – Using Views, Stored Procedures, and Functions
Using views, procedures, and functions 
Using Entity Framework with views
Using Entity Framework with stored procedures
Using Entity Framework with functions
Entity Framework Code First – Domain Modeling
and Managing Entity Relationships
Understanding the Entity Framework Code First approach 
Understanding the Code First conventions and configurations
Implementing Entity Framework Code First
Managing Entity relationships using the Code First approach
Inheritance with the Entity Framework Code First approach
Implementing the TPT inheritance
Implementing the TPH inheritance
Implementing the TPC inheritance
Entity Framework Code First – Managing Database Creation and Seeding Data
Querying the Entity Data Model – LINQ to Entities
Managing Concurrency Using Entity Framework
Managing Transactions Using Entity Framework

​

MTA2:

Programming web applications
Troubleshooting and debugging web applications
Working with client-side scripting
Configuring and deploying web applications
Manage the application life cycle
Build the user interface (UI) by using HTML5
Format the user interface by using Cascading Style Sheets (CSS)
Code by using JavaScript
 

Web Application:

Data Access Layer
LinQ to SQL Classes
Entity Framework
Web World Intro
MVC Introduction
Controllers
Views
Models
Forms and HTML Helpers
Data Annotations and Validation
Membership, Authorization,and Security
Ajax
Routing
Web Api
OWIN KATANA
Identity and Security
Bootstrap
WebAPI 2
Entity Framework 6
SignalR
Web Developer Tools and Visual Studio 2013