Welcome To Eazygurus

SQL Server

Course Name        :   SQL SERVER – Microsoft Technology
Duration                 :  35 hrs

STUDENTS ENROLLED

    • DBMS & RDBMS
    • What is SQL server
    • Introduction to SQL Server 2008R2
    • Tools of SQL Server 2008R2
    • Management studio
    • System databases
    • Database Creation
    • Authentications
      • Windows
      • SQL Server
    • Data types
    • TSQL Introduction
    • Data Definition language
    • Data Manipulation Language
    • Data Retrieval Language
    • Commit & Rollback
    • Buffer Management
    • Operators
    • Functions
      • Number Functions
      • Character Functions
      • Date time Functions
      • Aggregate Functions
    • Clauses
      • Group By
      • Having
      • Order by
    • Set Operators
    • Joins
      • Inner Join
      • Outer Join(3)
      • Cross join
    • Sub Queries
    • Copying table concept
    • Constraints
      • Primary key
      • Unique
      • Foreign key
      • Check Constraint
      • Not Null
    • Views
    • Indexes & B tree Structure & Execution Plan
    • Synonyms
    • Profiler
    • Introduction to Programming
    • Batches and Basic programs
    • Else, While
    • Cursors
    • User Defined Functions
    • Stored Procedures
    • Edit & Recompile SP’s
    • Triggers

    Key Benefits:

    • Exposure to real time scenarios.
    • Training in an enterprise highly focused in recruitment.
    • Resume Preparation and Interview Tips
    • Q & A, Mock Interview.

    Course Curriculum

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 2 weeks, 4 days

    Advanced Course Search

    Total It Training Portal © Eazygurus. All rights reserved.