SQL Server Developer Online Training

SQL Server Developer Online Training

SQL Server Developer Online Training

SQL Server Developer Online Training Course Content :

Chapter 1: SQL SERVER OVERVIEW

Chapter 2: USING MANAGEMENT STUDIO

Chapter 3: DESIGNING RELATIONAL DATABASES

Selecting Data

Chapter 1: WORKING WITH SINGLE TABLE QUERIES

Chapter 2: MERGING DATA WITH JOINS & UNIONS

Chapter 3: WORKING WITH SUBQUERIES

Chapter 4: AGGREGATING DATA

Chapter 5: USING FULL-TEXT SEARCH

Chapter 6: SELECTING DATA THROUGH VIEW

Chapter 7: DISTRIBUTED QUERIES

Chapter 8: MODIFYING DATA

Part 3: Developing Sulutions

Chapter 1: T-SQL & STORED PROCEDURES

Chapter 2: TRIGGERS & AUDIT TRAILS;

Chapter 3: USER-DEFINED FUNCTIONS

Chapter 4: INDEXING FOR PERFORMANCE

Chapter 5: TRANSACTIONS, LOCKING & BLOCKING

Chapter 6: INTRODUCTION TO OPTIMIZATION THEORY