by Jasmin Azemović | Released October 2017 | ISBN: 9781788836135

Install, Configure, and Manage Database with SQL Server on Linux to bring high security for your data and TransactionsAbout This VideoInstall, configure, and fine-tune your database application for maximum performanceAn easy-to-follow guide to implementing various SQL Server CTP 2.x offerings on Linux — from installation to administrationWrite efficient queries on SQL Server samplesDesign and administer your SQL Server solution on the open-source Linux platformIn DetailMicrosoft'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. Show and hide more

1. Chapter 1 : Linux Distributions
   • The Course Overview 00:03:42
   • Supported Linux Distributions 00:02:26
   • Installing openSUSE 00:07:03
   • Installing Kububtu 00:05:53
2. Chapter 2 : Installation and Configuration
   • Bash, Really Quick Start 00:05:32
   • SQL Server Installation on openSUSE 00:07:52
   • SQL Server Installation on Kubuntu 00:06:38
3. Chapter 3 : SQL Server Basics
   • Overview of SQL Server 00:03:48
   • SQL Server Objects 00:04:02
   • SQL/T-SQL Basics 00:02:05
   • Working Environments and Tools 00:04:45
4. Chapter 4 : Database in the Sandbox
   • DDL Statements 00:07:32
   • DML Statements 00:12:42
5. Chapter 5 : Sample Databases
   • Normalization 00:04:41
   • Northwind and Pubs Databases 00:02:30
   • AdventureWorks Database 00:03:41
6. Chapter 6 : A Crash Course in Querying
   • Retrieving Data 00:06:51
   • Filtering Data 00:09:59
   • Overview of Aggregate Functions 00:05:29
   • JOIN Operators 00:08:24
Show and hide more