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
About Lesson
  • Introduction to stored procedures
  • Benefits of Stored Procedures
  • Creating, Executing Modifying, Dropping
  • Input–Output and Optional Parameters
  • Working with Dynamic SQL
Previous
Next