SQL Server

SQL Server course is offered by MIS Infotech. SQL Server is software (A Relational Database Management System) developed by Microsoft. It is also called MS SQL Server. It is implemented from the specification of RDBMS.

Outline:

• 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
• SS Create Table
• SS Delete Table
• SS Insert Data
• SS Update Data
• SS Delete Data
• SS Delete TOP
• Aggregate Function
• SS MIN Function
• SS MAX Function
• SS SUM Function
• SS AVG Function
• SS COUNT Function
• SQL Server Operators
• SS Comparison Operator
• SS UNION Operator
• SS 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
• SS Primary Keys
• Enable Primary Key
• DIsable Primary Key
• Drop Primary Key
• SS Foreign Keys
• Enable Foreign Key
• Disable Foreign Key
• Drop Foreign Key
• SQL Server Advance
• Create View
• Backup Database
• Restore Database