Introduction to SQL Server

What is a database?

A database is a warehouse that organizes, stores, and manages data in accordance with its data structure . is a  that is stored in a certain way, shared for multiple users, has the smallest possible redundancy , and is separate from the application.

SQL Server is a Microsoft company database product that Microsoft SQL Server originates from Sybase SQL Server.

SQL: Structured Query Language (structured query Language) abbreviation (pronunciation:/?es kju?? el/"S-q-l"), is a special purpose programming language , is a database query and programming language, For accessing data and querying, updating, and managing relational database systems , as well as the extension of database script files.

History:

SQL Server is a relational database management system. Originally developed jointly by Microsoft, Sybase and ashton-tate three companies, it was launched in 1988 with the first OS/2 release. After the launch of Windows NT, Microsoft and Sybase split up on SQL Server development, andMicrosoft migrated SQL Server to the Windows NT system, focusing on the development and promotion of SQL Server Version of Windows NT. Sybase is more focused on SQL Server applications on the Unⅸ operating system.

There are five main versions:

1. Enterprise Edition (SQL Server xxxx Enterprise Edition), Enterprise Edition is the most comprehensive version, supporting all functions to meet the business needs of large enterprises

2. Standard Edition (SQL Server xxxx standard Edition), which is suitable for small and medium enterprises, the price is superior to the Enterprise Edition.

3. Workgroup Edition (SQL Server xxxx Workgroup Edition), ideal for small businesses with no limits on size and user database

4. Development version (SQL Server xxxx Developer Edition), the development version covers all the features of the Enterprise Edition, but is only allowed as a development and testing system, not allowed as a production system

5. Free version (SQL Server XXXX Express), SQL Server Express is free, can be redistributed (subject to protocol), can also act as a client database and a base server database, known as the learning version

In addition to SQL, there are many other database products, such as Oracle (the market share is also relatively high), MYSQL (free database, small business and personal use more), DB2, Sybase and so on.

SQL Server Management Studio abbreviation: SSMS, which is an integrated environment for managing SQL Server infrastructure. You can open this tool by entering SSMS in Start-run.

Introduction to SQL Server