Ms SQL Server - Training Course
MS SQL Server Training course provide you with technical
skills required to implement a database solution with
Microsoft SQL Server Client/Server database management
system. Our training course reflects the significant
and practical issues of database design and important
features that SQL Server provides for implementers and
developers in the Transact-SQL language. Our class is
a hands-on database exercise that allows you to practice
or demonstrate a particular concept or skill. Our class
also covers information about the networking configuration
necessary to complete and manage database.
Days : 4 days
TIME : 9:00 till 17:00 (Overtime Expected).
INCLUDE: Free parking + 2 Snack meals and beverages.
Disk support to trainee.
EQUIP: Computer at least Pentium II as well real
SERVER.
CLASS COVERING DETAILS & CONTENTS OF:
-
Managing Transaction and Locks
Introduction to transaction and Locks
Managing Transaction
Microsoft SQL Server Locking
Managing Locks
-
Implementing Views
What is a view?
Advantages of views
Defining views
Modifying data through views
Performance considerations
-
Implementing Stored Procedures
Introduction to Stored procedures
Creating executing and modifying Stored procedure
Using parameters in Stored procedures
Executing extended Stored procedures
Handing error messages
Performance Considerations
-
Leveraging SQL Server Functions.
String Function
Aggregate Functions
Mathematical Functions
Date/Time Functions
System Procedures
-
Implementing Triggers
What is a Trigger?
Defining Triggers
Example of Triggers
Performance Considerations
-
Working with Distributed Transactions
Setting up a distributed environment
Querying a linked server
Executing a stored procedure on a linked Server
Modifying distributed data
-
Building a COM-based, N-Tier Application
Building 3-Tiered Distributed Applications
N-Tier Architecture Challenges
Business Requirements
Application Functions
Application Data
Business Rules
Business Object Model
Application Layers
The Data Model
|
