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
