Learn SQL Server: Introduction

SQLEBooks.com
Share on Facebook0Share on Google+0Tweet about this on TwitterShare on LinkedIn0Share on Reddit0Pin on Pinterest0
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.)

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)

Loading...


 

Recommended eBooks on SQL Server:

Tuning SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Tuning SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Administering SQL Server: eBook by SQL Server MVP Artemakis Artemiou
Administering SQL Server: eBook by SQL Server MVP Artemakis Artemiou



About artemakis 4 Articles
Artemakis Artemiou is a Senior SQL Server Architect, Author, Software Developer and a Microsoft Data Platform MVP. He has over 15 years of experience in the IT industry in various roles. Among other, via his initiative SQLEBooks.com, Artemakis authors and publishes eBooks on different topics on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Additionally he is the founder of the SQLArtBits initiative that aims to provide the technical community with simple, yet powerful and high-quality SQL Server tools. Currently, the highlights of these tools are DBA Security Advisor and In-Memory OLTP Simulator. Artemakis's official website can be found at aartemiou.com. Artemakis's blogs can be found at: SQLNetHub.com and TechHowTos.com.