McTimothy Associates

This event has passed

DATABASE ADMINISTRATION FUNDAMENTAL (MS SQL Server )

Why Attend

$ 167.59

Event Date: 08/04/2020 – 10/04/2020

Total:

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

Other Courses