0
  • Home
  • MS SQL Server Tutorial

MS SQL Server Tutorial for Beginners: Learn in 7 Days

Training Summary

SQL Server is a leading Relational Database Management System by Microsoft. This course teaches you basic to advance level concepts of SQL Server

What should I know?

The online guide is designed for beginners with little or no SQL Server experience. But knowledge of SQL is a plus

Course Syllabus

  • Tutorial
  • What is SQL Server? Introduction, History, Editions, Instances
  • Tutorial
  • SQL Server Architecture Explained: Named Pipes, Optimizer, Buffer Manager
  • Tutorial
  • SQL Server Management Studio (SSMS): What is, Install, Versions
  • Tutorial
  • SQL Server Database: Create, Alter, Drop, Restore
  • Tutorial
  • SQL Server DataTypes: Varchar, Numeric, Date Time [T-SQL Examples]
  • Tutorial
  • SQL Server Variable: Declare, Set, Select, Global,Local [TSQL Examples]
  • Tutorial
  • SQL Server Table: CREATE, ALTER, DROP [T-SQL Examples]
  • Tutorial
  • SQL Server IF…ELSE Statement: T-SQL Example
  • Tutorial
  • CASE statement in SQL Server: T-SQL Example
  • Tutorial
  • SQL Server SUBSTRING() Function: T-SQL Example
  • Tutorial
  • SQL SERVER JOINS Tutorial: INNER, LEFT, RIGHT , OUTER
  • Tutorial
  • Create Login, User, assign Permission: SQL Server Tutorial
  • Tutorial
  • SSIS Tutorial for Beginners: What is, Architecture, Best Practices
  • Tutorial
  • Top 40 SSIS Interview Questions and Answers
  • Tutorial
  • SQL Server Reporting Services (SSRS) Tutorial for Beginners
  • Tutorial
  • Top 20 SSRS Interview Questions & Answers
  • Tutorial
  • SSAS Tutorial: Architecture, Cube, Types (Tabular vs Multidimensional)
  • Tutorial
  • Top 50 SQL Server Interview Questions & Answers