SQL Server

SQL Server on Mac

SQL Server is now available on the Mac (starting from SQL Server 2017). Here you'll find everything to get SQL Server up and running on your Mac, from installing Docker, to installing a management tool such as sql-cli and SQL Operations Studio.

SQL Server 2017 Tutorial

Explores the new features introduced in SQL Server 2017, and demonstrates how to create databases using SQL Operations Studio (SQLOPS). Best of all, virtually all the steps in this tutorial can be done whether you're running Windows, Linux, or Mac!

SQL Server 2016 Tutorial

This tutorial uses SQL Server 2016. It explains what SQL Server 2016 is and how to use it.

You should have a basic knowledge of relational database management systems and how they work.

SQL Server 2014 Tutorial

SQL Server 2014 is the predecessor of SQL Server 2016.

Covers similar topics to the 2016 tutorial, but using SQL Server 2014.

SQL Server 2008 Tutorial

This tutorial uses SQL Server 2008.

If you're still using SQL Server 2008, this is the tutorial for you.

SQL Server 2000 Tutorial

This SQL Server 2000 tutorial was written a really long time ago!

Check out what SQL Server used to look like. Or if you're still using SQL Server 2000... maybe it's time to think about an upgrade!

Database Tutorial

This database tutorial is aimed at beginners. It explains basic database concepts.

Access Tutorial

Microsoft Access tutorial for beginners. Step-by-step, plenty of screenshots. Create a database with forms, reports, and more.

SQL Tutorial

SQL is the standard language for querying databases. Learn the basics here.

MySQL Tutorial

Learn how to use the world's most popular open source database management system.

Neo4j Tutorial

Neo4j is a graph database management system. It is ideal for storing relational/connected data.

SQLite is the world's most distributed database management system. It is used in web browsers, mobile phones, tablets, computer software, and more. Chances are, it's already installed on your system.

MongoDB is a NoSQL database management system. It uses a document model to store data. Data is stored as JSON/BSON documents. These documents are semi-structured, and represent the flexible schema of the database.

SQL Server is now available on the Mac (starting from SQL Server 2017). This tutorial outlines all steps you need to do, from installing Docker, to installing a management tool such as sql-cli and SQL Operations Studio.

Full list of system error messages that you may potentially encounter when working with SQL Server 2017. This is a long list — so long in fact, that it's separated across 36 pages!