Databse Administration Fundamentals - MS SQL Server

This event has passed

Why Attend

SQL Server is a leading Relational Database Management System by Microsoft. This course teaches you basic to advance level concepts of SQL Server. The course will give you a comprehensive insight into the infrastructure and architecture of SQL Server. This will allow you to fully understand the product that you are managing.

Event Date: 26/04/2023 – 28/04/2023

Request an In-House Proposal

Download 2026 Training Calendar

Overview
Course Outline

Course Syllabus

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