Microsoft SQL Server is a Relational Database Management System. In today's world almost every application developed for any enterprise has some data access technology. SQL Server, along with ADO.NET provides an excellent platform for designing and developing database driven applications.
SQL Server is not only an RDBMS to store data, there are various other factors which a developer/administrator must keep in mind while developing applications using SQL Server. Some of these are Administration, database maintenance, manageability, availability, security, performance etc.
Our specially designed courses help you to cover all of these aspects. Customzed courses are also available for Intermediate and Advanced users.
In this course, you will learn about general database administration, T-SQL Programming, Reporting and Integration Services.
|Name of the Topic||Duration|
|SQL Server Course structure - Total course duration: 72 hours|
|Overview of the Database Objects||2 hours|
|Basic T-SQL||10 hours|
|Creating and Modifying Table Structure||2 hours|
|Data Binding and Rich Data Controls||8 hours|
|Themes and Master Pages||4 hours|
|Reusability with User controls and Custom controls||10 hours|
|Database Design and Normalization||8 hours|
|Stored Procedures and Triggers||16 hours|
|User Defined Functions||2 hours|
|Storage and Index Structures||4 hours|
|Transactions and Locks||4 hours|
|Introduction to SSRS||4 hours|
|Introduction to SSIS||4 hours|
|Basic Administration||4 hours|