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. Each topic is explained using examples for easy understanding.
To go ahead with this tutorial, familiarity with database concepts is preferred. It is good to have SQL Server installed on your computer, as it might assist you in executing the examples yourself and get to know how it works.
To go ahead with this tutorial, familiarity with database concepts is preferred. It is good to have SQL Server installed on your computer, as it might assist you in executing the examples yourself and get to know how it works.
- About SQL Server
- SQL Server Editions
- SQL Server Management Studio (SSMS)
- SQL Server - Create a Database
- SQL Server - Create a Table
- SQL Server - Adding Data
- SQL Server - Drop Database
- SQL Server - Creating Backups
- SQL Server - Stored Procedures
- SQL Server - Views
- SQL Server - Assign Permissions
- SQL Server - Monitor Database
- SQL Server - Restoring Databases
- SQL Server - Query Designer
- SQL Server - User Logins
- SQL Server - Server Roles
- SQL Server - Database Schemas
- SQL Server - Linked Servers
- SQL Server Integration Services (SSIS)
- SQL Server Summary
- SQL Server Functions
- SQL Server Topics:
- Join
- Dates
- Stored Procedures
- Index
- NULLs
- MERGE
- Create View
- Aggregate Functions
No comments:
Post a Comment