Beschreibung
LEAD MS SQL SERVER DEVELOPER
Required Skills - VB-ASP-Design, Estimation, RM, proposal and RFP response, N-tier architecture, Ajax,Web 2.0, MTS
Essential Skills - VB-ASP-Design, Estimation, RM, proposal and RFP response, N-tier architecture, Ajax,Web 2.0, MTS
Additional Skills - SQL Server T-SQL Programming
Database Programming Basics: Ability to understand and implement Declaring Variables, Building Blocks, Control Structures, Explicit Cursors, Handling Exceptions, Creating Procedures, Creating Functions, Creating Database Triggersand Transaction Management.
Adv Database Programming: Ability to understand and implement Dynamic SQL Usage, Programming with locks and isolations and Working with Temporary Tables
Adv Database Programming: Advanced Transact-SQL constructs, Business logic with stored procedures, Creating user-defined functions(UDF), Formulating triggers, Integrating XML with Transact-SQL,Transactions in T-SQL, Transferring data to and from SQL Server.
Tools Level 1 Usage Adv Database Programming: Ability to Tune T-SQL Applications for Performance, Advanced Query concepts, Adv Stored Procedure Programming, DTS Programming
Understanding of Database Migration Process
Understanding of Database Upgrade