更新时间：2021-07-02 20:24:43
cover
Title Page
Copyright
SQL Server on Linux
Credits
About the Author
About the Reviewer
www.PacktPub.com
Why subscribe?
Customer Feedback
Preface
What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support
Downloading the example code
Errata
Piracy
Questions
Linux Distributions
Supported Linux distributions
openSUSE
Installation procedure
Kubuntu
Summary
Installation and Configuration
Bash really quick start
SQL Server installation on openSUSE
SQL Server installation on Kubuntu
SQL Server Basics
Overview of SQL Server
Client-server architecture concepts
SQL Server components
How it works on Linux
SQL Server objects
System databases
Database objects
SQL Server data types
SQL/T-SQL basics
History of SQL/TSQL
Types of SQL statements
DDL - Data Definition Language
DCL - Data Control Language
DML - Data Manipulation Language
Working environments and tools
sqlcmd
bcp
Visual Studio code
SQL Server Management Studio (SSMS)
Database in the Sandbox
DDL statements
Creating a new database
Creating new tables
DML statements
Data manipulation
Changing table definition
Dropping a table
Creating other database objects
Creating views
Creating stored procedures
Creating triggers
Sample Databases
Relational database concepts
Normalization
First normal form
Second normal form
Third normal form
Northwind database
Pubs database
AdventureWorks database
Installing AdventureWorks
WideWorldImporters database
A Crash Course in Querying
Retrieving and filtering data
Retrieving data from a table
String functions
Exercise
Filtering data
Comparison operators
String comparison
Logical operators
Working with NULL values
Manipulating query output
Overview of aggregate functions
Aggregate functions and NULL values
GROUP BY clause
HAVING clause
JOIN operators
INNER JOIN
OUTER JOIN
Multiple joins
Backup and Recovery Operations
