Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
SQL Server on Linux

You're reading from   SQL Server on Linux Configuring and administering your SQL Server solution on Linux

Arrow left icon
Product type Paperback
Published in Aug 2017
Publisher Packt
ISBN-13 9781788291804
Length 222 pages
Edition 1st Edition
Languages
Tools
Arrow right icon
Author (1):
Arrow left icon
Jasmin Azemović Jasmin Azemović
Author Profile Icon Jasmin Azemović
Jasmin Azemović
Arrow right icon
View More author details
Toc

Table of Contents (13) Chapters Close

Preface 1. Linux Distributions 2. Installation and Configuration FREE CHAPTER 3. SQL Server Basics 4. Database in the Sandbox 5. Sample Databases 6. A Crash Course in Querying 7. Backup and Recovery Operations 8. User Management 9. Implementing Data Protection 10. Indexing 11. In-Memory OLTP 12. Beyond SQL Server

Pubs database

The hall of fame would not be complete if I did not mention the Pubs (http://www.microsoft.com/en-us/download/details.aspx?id=23654) sample database. If sales are not good enough for you, then publishing is the right choice. Here you can find authors, titles, publishers, and other entities regarding a publishing business:

Figure 5-2. Pubs database relational schema

Objects and table attribute names are a less clear, because the author of this database sample has preferred the use of short words, qty, au_lname, highqty, and so on. However, with 11 tables it is quite simple and easy to understand.

You can download this sample at http://www.microsoft.com/en-us/download/details.aspx?id=23654. Pubs originated from Accent SQL Server 2000, but it can be used for practicing SQL and DBA tasks.

In Chapter 7, Backup Operations, we will learn how to restore those databases...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €18.99/month. Cancel anytime