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
