Web Net Guru tries to create tutorial of SQL server for beginner also which is helpful for experienced as well , with practical examples.
Table of Contents
In Microsoft SQL Server basics, SQL Server stands for Structured query language which is developed by Microsoft. Before the relational database, data is going to store in text files and logs files, which was very hectic and tedious job for software to read and write the data for large applications.
The SQL Server gives the facility to store data in multiple tables and rows with the relationship so SQL server called as relational database. SQL Server store data in rows and columns format which is straightforward to read and understand.
Find the below image which explain the SQL server basics architecture.
In above list SQL Server and My SQL are popular because both are Microsoft product, and they are straightforward to use. In this section, we are focusing on SQL Server.
There are two type of SQL Server authentications
In window authentication SQL server not required the user name and password to open the server or database. Most of the time windows authentication accessed by the DBA (Database Administrator) to create the database and to give the access to the third user or developer. If you see in the below image, it will show the server name and rest it will disable. It takes the server name, which given by user on time of installation of SQL Server.
For More details find the below image with SQL Server windows authentications example.
In SQL Server authentication SQL Server required the user name and password along with the server name. While working on large application it happens that DBA creates the separate login and give the read/write access to developer, so respected developer can see only assigned database not rest of the databases (Example : Multiple databases can have on one server, and it is possible that developer need to access only one database and rest of the databases should not visible to him).
For More details find the below image with SQL Server authentications example.
This was some SQL Server Basic for beginner.Now get started to learn SQL step by step examples.