Description
SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft.
Similar to other RDBMS software, SQL Server is built on top of SQL, a standard programming language for interacting with the relational databases. SQL server is tied to Transact-SQL, or T-SQL, the Microsoft's implementation of SQL that adds a set of proprietary programming constructs.
Database Ee
The core component of the SQL Server is the Database Ee. The Database Ee consists of a relational ee that processes queries and a storage ee that manages database files, pages, pages, index, etc. The database objects such as stored procedures, views, and triggers are also created and executed by the Database Ee.
Relational Ee
The Relational Ee contains the components that detee the best way to execute a query. The relational ee is also known as the query processor. The relational ee requests data from the storage ee based on the input query and processed the results.
Some tasks of the relational ee include querying processing, memory management, thread and task management, buffer management, and distributed query processing.
SQL Server has four primary editions that have different bundled services and tools. Two editions are available free of charge
SQL Server Developer edition for use in database development and testing.
SQL Server Expression for small databases with the size up to 10 GB of disk storage capacity.
For larger and more critical applications, SQL Server offers the Enterprise edition that includes all SQL server's features.
SQL Server Standard Edition has partial feature sets of the Enterprise Edition and limits on the Server regarding the numbers of processor core and memory that can be configured.
Who this course is for
Bners to Microsoft SQL Server