SQL Server Database Engine For Beginners

SQL Server Database Engine For Beginners

Learn how to connect to Database Engine ,Build and run T-SQL Statements

What you’ll learn

  • Installing SQL Server
  • Installing SQL Server Management Studio (SSMS)
  • Connecting to Database Engine
  • Writing Transact -SQL Statements
  • Create a database
  • Create a table
  • Insert rows into table
  • Query table
  • Updating Database Records
  • Delete Rows
  • Truncate Table
  • Drop Table
  • Drop Database
  • Explore Basic Navigation in Database Engine Tuning Advisor
  • Tuning a workload
  • Viewing tuning recommendations
  • View tuning reports

Requirements

  • No knowledge Prerequisites
  • Your System must have SQL Server Installed. The course covers this.
  • Your System must have SQL Server Management Studio Installed. The course covers this.

Who this course is for:

  • Beginners to Microsoft SQL Server

Tags:

Tutorial Bar
Logo