MS SQL Server

Description

IT Pros and Developers, take our free, on-demand SQL Server courses – and take your skills to a whole new level. With our selection of SQL training opportunities, you can learn how to implement and manage database solutions, migrate to the cloud with the ability to scale on demand, work with powerful reporting features, and see how SQL Server integrates with SharePoint. Plus, because our SQL Server online training is available on your schedule, you can take classes when, where, and how it suits you best.

MS SQL Server Course content

SQL Server

• What is SQL Server
• Install Visual Studio
• Install SQL Server
• SS Management Studio
• SS Datatypes

DB Operations

• SS Login Database
• SS Create Database
• SS Select Database

SQL Server Database

• Create Table
• Delete Table
• Insert Data
• Update Data
• Delete Data
• Delete TOP

Aggregate Function

• MIN Function
• MAX Function
• SUM Function
• AVG Function
• COUNT Function

SQL Server Operation

• Comparison Operator
• UNION Operator
• INTERSECT Operator
• IN Operator
• NOT Operator
• BETWEEN Operator
• IS NULL Operator
• IS NOT NULL Operator
• LIKE Operator
• EXIST Operator

SQL Server Clauses

• DISTINCT Clause
• GROUP BY Clause

SQL Server Keys

• Primary Keys
• Enable Primary Key
• Disable Primary Key
• Drop Primary Key
• Foreign Keys
• Enable Foreign Key
• Disable Foreign Key
• Drop Foreign Key

SQL Server Advance

• Create View
• Backup Database
• Restore Database