Course Content
1. MS SQL SERVER DEVELOPMENT
0/12
1.1 Introduction to Basic Database Concepts
1.2 Introduction to SQL Server
1.3 DDL and DML Statements
1.4 Working with Queries (DQL)
1.5 Aggregate Functions
1.6 Joins and Set Operations
1.7 Implementing Views
1.8 Transact-SQL (T-SQL)
1.9 Stored Procedures
1.10 Working with Cursors
1.11 Transaction and Error Handling
1.12 Triggers
MS SQL Server Development
  • Using functions in Queries
  • Count, Sum, Min, Max, Avg Group By and Having Clause
  • Using Group By with Rollup and Cube
Previous
Next