Learn SQL Server: Introduction
With this article, we start a series of posts that will be introducing
Microsoft SQL Server. These posts will be talking about the major features
of SQL Server, as well as provide the necessary knowledge in order to start
working with this powerful data platform.
SQL Server is a Relational Database Management System (RDBMS). A RDBMS is a Database Management System (DBMS) based on the relational model which was invented by E. F. Codd.
A database is an organized collection of data. This collection may include tables, functions, views, stored procedures, queries, and more. The data is organized in such a way that based on the relational model, each tables can have primary keys as well as foreign keys that reference other tables and so on.
SQL Server has many powerful features with which you can do just about anything that has to do with data management. That is why SQL Server is one of the leading data platforms worldwide.
Currently, at the time of writing, the SQL Server versions that are officially supported by Microsoft are:
• SQL Server 2008 R2 (End of Extended Support: Jul 9 2019)
• SQL Server 2012 (End of Extended Support: Jul 12 2022)
• SQL Server 2014 (End of Extended Support: Jul 9 2024)
• SQL Server 2016 (End of Extended Support: Jul 14 2026)
The easiest way to get started with SQL Server is to download and install SQL Server Express Edition and SQL Server Management Studio.
By installing SQL Server Express Edition you will end up having the database engine of SQL Server up and running and ready to accept connections.
With SQL Server Management Studio you will be able to connect to the SQL Server Database Engine and create databases, tables, as well as other database objects.
Subsequent posts in this series will include:
- A step-by-step tutorial on how to install SQL Server Express Edition and SQL Server Management Studio
- Examples of using SQL Server Management Studio
- T-SQL examples like: sql insert, sql join , and other sql queries
- Comparison of SQL Server versions (i.e. compare SQL Server 2008R2 with SQL Server 2012, SQL Server 2014 and SQL Server 2016)
- Comparison of SQL Server editions (i.e. standard edition vs enterprise edition vs express edition, etc.)