MS SQL Server Course Details

MS SQL Server is a relational database management system (RDBMS) developed by Microsoft. This product is built for the basic function of storing retrieving data as required by other applications. It can be run either on the same computer or on another across a network. This tutorial explains some basic and advanced concepts of SQL Server such as how to create and restore data, create login and backup, assign permissions, etc.

Syllabus

 MS SQL Server
• MS SQL Server - Overview
• MS SQL Server – Editions
• MS SQL Server – Installation
• MS SQL Server – Architecture
• MS SQL Server – Managment Studio
• MS SQL Server – Login Database
• MS SQL Server - Create Database
• MS SQL Server - Select Database
• MS SQL Server - Drop Database
• MS SQL Server - Creating Backups
• MS SQL Server - Restoring Databases
• MS SQL Server - Create Users
• MS SQL Server - Assign Permissions
• MS SQL Server - Monitor Database
• MS SQL Server - Services
• MS SQL Server - HA Technologies
• MS SQL Server - Reporting services
• MS SQL Server - Execution Plans
• MS SQL Server - Integration Services
• MS SQL Server - Analysis Services

Last modified: Friday, 29 July 2016, 2:22 AM