SQL Server on Linux

Bring the performance and security of SQL Server to Linux
Preview in Mapt

SQL Server on Linux

Jasmin Azemović

Bring the performance and security of SQL Server to Linux

Quick links: > What will you learn?> Table of content

Mapt Subscription
FREE
$29.99/m after trial
eBook
$22.40
RRP $31.99
Save 29%
Print + eBook
$39.99
RRP $39.99
What do I get with a Mapt Pro subscription?
  • Unlimited access to all Packt’s 5,000+ eBooks and Videos
  • Early Access content, Progress Tracking, and Assessments
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the Mapt reader
$0.00
$22.40
$39.99
$29.99 p/m after trial
RRP $31.99
RRP $39.99
Subscription
eBook
Print + eBook
Start 14 Day Trial

Frequently bought together


SQL Server on Linux Book Cover
SQL Server on Linux
$ 31.99
$ 22.40
Linux: Powerful Server Administration Book Cover
Linux: Powerful Server Administration
$ 79.99
$ 56.00
Buy 2 for $35.00
Save $76.98
Add to Cart

Book Details

ISBN 139781788291804
Paperback222 pages

Book Description

Microsoft's launch of SQL Server on Linux has made SQL Server a truly versatile platform across different operating systems and data-types, both on-premise and on-cloud.

This book is your handy guide to setting up and implementing your SQL Server solution on the open source Linux platform. You will start by understanding how SQL Server can be installed on supported and unsupported Linux distributions. Then you will brush up your SQL Server skills by creating and querying database objects and implementing basic administration tasks to support business continuity, including security and performance optimization. This book will also take you beyond the basics and highlight some advanced topics such as in-memory OLTP and temporal tables.

By the end of this book, you will be able to recognize and utilize the full potential of setting up an efficient SQL Server database solution in your Linux environment.

Table of Contents

Chapter 1: Linux Distributions
Supported Linux distributions
openSUSE
Installation procedure
Kubuntu
Summary
Chapter 2: Installation and Configuration
Bash, really quick start
SQL Server installation on openSUSE
SQL Server installation on Kubuntu
Summary
Chapter 3: SQL Server Basics
Overview of SQL Server
How it works on Linux
SQL Server objects
SQL/T-SQL basics
Working environments and tools
Summary
Chapter 4: Database in the Sandbox
DDL statements
DML statements
Summary
Chapter 5: Sample Databases
Relational database concepts
Normalization
Northwind database
Pubs database
AdventureWorks database
WideWorldImporters database
Summary
Chapter 6: A Crash Course in Querying
Retrieving and filtering data
Overview of aggregate functions
JOIN operators
Summary
Chapter 7: Backup and Recovery Operations
SQL Server recovery models
How transaction log works
Elements of backup strategy
Backup and restore
Summary
Chapter 8: User Management
Authentication process
Authorization process
Accessing SQL Server resources
Schema separation
Summary
Chapter 9: Implementing Data Protection
Crash course in cryptography
Transparent Data Encryption
Backup encryption
Symmetric encryption
Row-level security
Dynamic data masking
Summary
Chapter 10: Indexing
Indexing concepts
Clustered index
What is a heap
Non-clustered index
Columnstore index
Summary
Chapter 11: In-Memory OLTP
Elements of performance
What is In-Memory OLTP?
Summary
Chapter 12: Beyond SQL Server
Query store
Temporal tables
Mssql-scripter tool
DBFS tool
DBeaver – third party tool
Summary
Conclusion

What You Will Learn

  • Install and set up SQL Server CTP 2.x on Linux
  • Create and work with database objects using SQL Server on Linux
  • Configure and administer SQL Server on Linux-based systems
  • Create and restore database back-ups
  • Protect sensitive data using the built-in cryptographic features
  • Optimize query execution using indexes
  • Improve query execution time by more than 10x using in-memory OLTP
  • Track row-versioning using temporal tables

Authors

Table of Contents

Chapter 1: Linux Distributions
Supported Linux distributions
openSUSE
Installation procedure
Kubuntu
Summary
Chapter 2: Installation and Configuration
Bash, really quick start
SQL Server installation on openSUSE
SQL Server installation on Kubuntu
Summary
Chapter 3: SQL Server Basics
Overview of SQL Server
How it works on Linux
SQL Server objects
SQL/T-SQL basics
Working environments and tools
Summary
Chapter 4: Database in the Sandbox
DDL statements
DML statements
Summary
Chapter 5: Sample Databases
Relational database concepts
Normalization
Northwind database
Pubs database
AdventureWorks database
WideWorldImporters database
Summary
Chapter 6: A Crash Course in Querying
Retrieving and filtering data
Overview of aggregate functions
JOIN operators
Summary
Chapter 7: Backup and Recovery Operations
SQL Server recovery models
How transaction log works
Elements of backup strategy
Backup and restore
Summary
Chapter 8: User Management
Authentication process
Authorization process
Accessing SQL Server resources
Schema separation
Summary
Chapter 9: Implementing Data Protection
Crash course in cryptography
Transparent Data Encryption
Backup encryption
Symmetric encryption
Row-level security
Dynamic data masking
Summary
Chapter 10: Indexing
Indexing concepts
Clustered index
What is a heap
Non-clustered index
Columnstore index
Summary
Chapter 11: In-Memory OLTP
Elements of performance
What is In-Memory OLTP?
Summary
Chapter 12: Beyond SQL Server
Query store
Temporal tables
Mssql-scripter tool
DBFS tool
DBeaver – third party tool
Summary
Conclusion

Book Details

ISBN 139781788291804
Paperback222 pages
Read More

Read More Reviews

Recommended for You

Linux: Powerful Server Administration Book Cover
Linux: Powerful Server Administration
$ 79.99
$ 56.00
MySQL Admin Cookbook Book Cover
MySQL Admin Cookbook
$ 29.99
$ 21.00
JavaScript by Example Book Cover
JavaScript by Example
$ 27.99
$ 19.60
Administering SQL Server on Linux [Video] Book Cover
Administering SQL Server on Linux [Video]
$ 124.99
$ 106.25
Getting Started with SQL Server on Linux [Video] Book Cover
Getting Started with SQL Server on Linux [Video]
$ 124.99
$ 106.25
SQL Server 2017 Administrator's Guide Book Cover
SQL Server 2017 Administrator's Guide
$ 43.99
$ 30.80