Home Home
sitemap Sitemap
contactus ContactUs
Feedback
search Search
spacer
spacer
company Services
spacer
Products Training Clients
spacer Careers
spacer
spacer
courses Courses
VB .Net
ASP.NET ASP.NET
C#.NEt
SQL Server 2005
SQL Server 2005 BizTalk Server 2006
SQL Server 2005 Java & J2EE
SQL Server 2005 WebLogic Portal
Testing Tools
materials Materials
schedules Schedules
 
 SQL SERVER 2005
 
1. IINTRODUCTION TO SQL SERVER
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Major features
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Limits
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Editions
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Installing SQL Server
2. BASICS OF DATABASE DESIGN
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Normalization
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Denormalization
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Tools for Normalization in SQL Server
3. BUILDING A DATABASE
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Introducing SQL Server Management Studio
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Databases
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Tables
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Indexes
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Relations
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Using T-SQL to build and alter objects
4. T-SQL BASICS
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools What is SQL?
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Reading syntax diagrams
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Identifiers
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Datatypes
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Operators
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Wild cards
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Variables
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Functions
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Using sqlcmd
5. SELECT QUERIES
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools The SELECT clause
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools The FROM clause
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools The WHERE clause
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Using Joins
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools ORDER BY
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools GROUP BY and HAVING
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools TOP N and TOP N%
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools OVER
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Full-text search
6. ACTION QUERIES
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools DELETE
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools TRUNCATE TABLE
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools UPDATE
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools INSERT
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools SELECT INTO
7. LOCKING AND SHOWPLANNING
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools What is Locking?
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Monitoring and tuning Locking
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Deadlocks
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Application Locks
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Tuning Queries with ShowPlan
8. VIEWS, STORED PROCEDURES AND FUNCTIONS
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Partitioning and Joining Tables with Views
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Updateable views
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Indexed Views
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Information Schema Views
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Catalog Views
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Stored Procedures
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Functions
9. ADVANCED TRANSACT-SQL
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Transactions
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Distributed Transactions
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Rowset Functions
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Ranking Functions
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Cursors
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Structured Error Handling
10. XML and SQL Server
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Using FOR XML
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Using XQuery
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools HTTP SOAP access to data
11. TRIGGERS
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools INSERT triggers
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools DELETE triggers
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools UPDATE triggers
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools INSTEAD OF triggers
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Recursive triggers
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools DDL triggers
12. REPLICATION
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Replication Models
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Setting up Replication
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Snapshot publishing
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Transaction publishing
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Merge publications
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Monitoring replication
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Heterogeneous replication
13. .NET INSIDE OF SQL SERVER
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Understanding .NET and the CLR
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Using CLR objects in SQL Server
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Using the Sql namespace
14. SMO and RMO Programming
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools What is SMO?
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools The SMO Object Model
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Sample SMO tasks
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Sample RMO tasks
15. Analysis Services
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Understanding Analysis Services
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Introducing BIDS
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Creating a Data Cube
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Exploring a Data Cube
16. SQL Server Integration Services
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools SSIS Architecture
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools SSIS Tasks
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools SSIS in action
17. Notification Services
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools The Notification Services Architecture
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Using Notification Services
18. Reporting Services
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools The Reporting Services Architecture
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Building Reports
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Managing Reporting Services
19. Service Broker
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools The Service Broker Architecture
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Using Service Broker
20. Security and SQL Server
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Security modes and authentication
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Fixed server roles
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Database user accounts
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Permissions
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Database roles
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Ownership chains
  VB .Net, ASP.NET,  C#.NET, VB, ASP, SQL Server 2005, Testing Tools Functions
21. Conclusion



 
     
 
 

 

     
spacer
spacer
     © Marstek Solutions, LLC. All Rights Reserved. Privacy Statement | Terms