+91- 84000 84111
Summer Training Program 2017
WebGangesedu

SQL Server


About Course
    The course offers a powerful way of managing the database information.The Training provides a way to create databases, generating transaction over different sql servers.

Course Objectives
    At the end of the training course, students will be able to:
  • Create databases and tables manually and programmatically
  • Perform insertion,deletion,updation on tables
  • Perform simple and complex queries
  • Create Views, Stored Procedures, Functions, Triggers, Cursors, Indexes, etc.

Prerequisites
    No prerequisites for learning sql server

Syllabus Overview
  • Basic Database Concepts
  • Normalization
  • Introducton to SQL Server
  • Creating Database and Tables
  • DDL, DML, DCL Statements
  • DQL Statements
  • Working with aggregate functions
  • Working with Joins
  • Working with Sub Queries
  • Query Assignments
  • Implementing Views
  • Implenting Data Integrity and Constraints
  • Writing Scripts using Transact-SQL(T-SQL)
  • Dynamic SQL
  • Implementing Stored Procedures
  • Implementing User Defined Functions
  • Implementing Triggers
  • Working with Cursors

Software Download Links
Read more ›
Close
Select Your Training Location

Type your e-mail address and we'll send you new password

Submit