SQL Server

This SQL Server training teaches developers all the Transact-SQL skills they need to create database objects like Tables, Views, Stored procedures & Functions and triggers in SQL Server. Gives idea about writing Queries & Sub-queries, working with Joins, etc. As well as database management skills like backup, restore, etc.

Module

  • Introduction To SQL Server
  • TSQL
  • SQL Statement
    • DDL
    • DML
    • DQL
  • Build-in Function
    • Scalar Functions
    • Numeric Functions
    • Character Functions
    • Conversion Functions
    • Date Functions
    • Aggregate Functions
  • Set Operators
  • Joins
  • Sub Queries
  • Index
  • Security
    • Login Creation
    • SQL Server Authenticated Login
    • Windows Authenticated Login
    • User Creation
    • Granting Permissions
    • Revoking Permissions
  • Stored Procedure
  • Function
  • Cursor

Quick Contact

Other Courses