SRI NARMADA IT TRAINING

Microsoft SQL Server Course Content


  • Introduction to Basic Database Concepts
  • E-R Modeling and Diagram
  • Normalization
  • Introduction to SQL Server
  • Introduction to SQL
  • DDL and DML Statements
  • Working with Queries (DQL)
  • Aggregate Functions
  • Joins and Set Operations
  • Implementation of Data Integrity
  • Working with Constraints
  • Implementating Views
  • Data Control Language(DCL)
  • Working with Indexes
  • Writing Transact-SQL (T-SQL)
  • Working with Stored Procedures and Functions
  • Implementating Triggers
  • Working with cursors
  • Transact Control Language (TCL)
  • Backup and Restore
  • Advance Features