SQL Server for Beginners Part-I

• This is a gentle introduction to SQL(Structured Query Language) is a standard programming language specifically designed for storing, retrieving, managing or manipulating the data inside a relational database management system (RDBMS).
• SQL server is a leading database management system by Microsoft.Microsoft SQL Server is the most user friendly of all RDBMS’ the extremely popular, greatly used database framework.

The SQL server run on different operating systems like Windows, Linux etc.

SQL Server Edition:

1. SQL Server Express
2. SQL Server Enterprise
3. SQL Server Developer

SQL Server Express:

If you only want to learn how to use SQL Server, then Express is for you.

• This is also a free version but with the limited set of features with no business intelligence applications with limited size(size upto 10gb only). Only one concurrent user can access the database at a time.
• The multiple users can not access the database simultaneously. It is used for small scale application.

SQL Server Express Benefits:

1. Free- One of the important advantage of SQL Server Express is that it is free.
2. Scalabiliy- Express is not limited to a single user, anyone can use it .
3. Security- SQL Server Express there is the option of free online backup that will help to protect your valuable business data.

SQL Server Enterprise:

• SQL Server Enterprise includes everything in the Standard edition,also has a additional features. SQL Server Enterprise gives a money.
• SQL Server Enterprise mainly used for the production. So we have to install latest version of Developer edition.
• The Enterprise edition of SQL Server competes against enterprise-oriented systems like Oracle Database and MySQL.

SQL Server Enterprise Benefits:

1. Free version available for development or the educational industry with minimum limitations.
2. Easy to configure
3. Dynamic resource allocation(changing demand and infrastructure) is provide
4. Reduced complexity
5. Maximum database size is 524 PB(Petabyte)

SQL Server Developer:

• SQL Server Developer edition is fully featured edition as compare to express edition.It can not be used for the production. SQL Server Developer is an ideal choice for people who build SQL Server(develop) and test applications.
• It is ideal for learning small server data-driven applications.
• It is the best choice for independent software vendors, developers and client applications.

SQL Server Developer Benefits:

1. Build, test, and demo apps in non-production environments
2. Usually it is used for development and testing.
3. Free to use
4. All Enterprise Edition features available

To better understand this concept please do watch the below video.It will resolve your all doubts: