SQL Server Database Implementation Syllabus Content

Duration: 30 hours

  • Basic Database Concepts
  • Normalization
  • Introduction to SQL Server
  • Creating Database and Tables
  • DDL, DML, DCL Statements
  • DQL Statements
  • Working with aggregate functions
  • Working with Joins
  • Working with Sub Queries
  • Implementing Views
  • Implanting Data Integrity and Constraints
  • Writing Scripts using Transact-SQL (T-SQL)
  • Indexing
  • Dynamic SQL
  • Implementing Stored Procedures
  • Implementing User Defined Functions
  • Implementing Triggers
  • Working with Cursors
  • Backup and Restore Databases
  • Exporting and Importing

Visit:  http://www.MonsterCourses.com

for more details. Or call UK: +44 702 409 4077 / USA: +1 772 777 1557