Microsoft SQL Server Online Training

                          Microsoft SQL Server Online Training 

1. SQL Server and Toolset

• ·         SQL Server Platform
• ·         Working with SQL Server Tools
• ·         Configuring SQL Server Services

2. Working Data Types

• ·         Using Data Types
• ·         Converting Data Types
• ·         Specialized Data Types

3. Designing and Implementing Tables

• ·         Designing Tables
• ·         Working with Schemas
• ·         Creating and Altering Tables

4. Ensuring Data Integrity through Constraints

• ·         Enforcing Data Integrity
• ·         Implementing Domain Integrity
• ·         Implementing Entity and Referential Integrity

5. Planning for SQL Server Indexing

• ·         Core Indexing Concepts
• ·         Data Types and Indexes
• ·         Single Column and Composite Indexes

6. Implementing Table Structures in SQL Server 2012

• ·         SQL Server Table Structures
• ·         Working with Clustered Indexes
• ·         Designing Effective Clustered Indexes

7. Reading SQL Server Execution Plans

• ·         Execution Plan Core Concepts
• ·         Common Execution Plan Elements
• ·         Working with Execution Plans

8. Improving Performance through Non-Clustered Indexes

• ·         Designing Effective Non-Clustered Indexes
• ·         Implementing Non-Clustered Indexes
• ·         Using the Database Engine Tuning Advisor

9. Designing and Implementing Views

• ·         Views
• ·         Creating and Managing Views
• ·         Performance Considerations for Views

10. Designing and Implementing Stored Procedures

• ·         Stored Procedures
• ·         Working with Stored Procedures
• ·         Implementing Parameterized Stored Procedures
• ·         Controlling Execution Context

11. Merging Data and Passing Tables

• ·         Using the MERGE Statement
• ·         Implementing Table Types
• ·         Using TABLE Types as Parameters

12. Designing and Implementing User-Defined Functions

• ·         Functions
• ·         Designing and Implementing Scalar Functions
• ·         Designing and Implementing Table-Valued Functions
• ·         Implementation Considerations for Functions
• ·         Alternatives to Functions

13. Creating Highly Concurrent SQL Server Applications

• ·         Transactions
• ·         Locks
• ·         Management of Locking
• ·         Transaction Isolation Levels

14. Handling Errors in T-SQL Code

• ·         T-SQL Error Handling
• ·         Implementing T-SQL Error Handling
• ·         Implementing Structured Exception Handling

15. Responding to Data Manipulation via Triggers

• ·         Designing DML Triggers
• ·         Implementing DML Triggers
• ·         Advanced Trigger Concepts

16. Implementing Managed Code in SQL Server 2012

• ·         SQL CLR Integration
• ·         Importing and Configuring Assemblies
• ·         Implementing SQL CLR Integration

17. Storing XML Data in SQL Server 

• ·         XML and XML Schemas
• ·         Storing XML Data and Schemas in SQL Server
• ·         Implementing the XML Data Type

18. Querying XML Data in SQL Server

• ·         Using the T-SQL for XML Statement
• ·         Starting with XQuery
• ·         Shredding XML

19. Working with SQL Server Spatial Data

• ·         Spatial Data
• ·         Working with SQL Server Spatial Data Types
• ·         Using Spatial Data in Applications

20. Working with Full-Text Indexes and Queries

• ·         Implementing a Full-Text Index
• ·         Implementing a Stoplist
• ·         Creating a Stored Procedure to Implement a Full-Text Search

Thanks,

Raja K

+91 9247360004