舉報 
會員
SQL Server on Linux
最新章節：
Conclusion
ThisbookisfortheLinuxuserswhowanttolearnSQLServerontheirfavoriteLinuxdistributions.Itisnotimportantifyouareexperienceddatabaseuserorabeginneraswearestartingfromscratch.However,itisrecommendedthatyouhavebasicknowledgeaboutrelationalmodels.Moreadvancedreaderscanpickthechaptersoftheirinterestandstudyspecifictopicsimmediately.UsersfromWindowsplatformcanalsobenefitfromthisbooktoexpandtheirfrontiersandbecomeequallyefficientonbothplatforms.
目錄(168章)
倒序
- 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
- Installation procedure
- Summary
- Installation and Configuration
- Bash really quick start
- SQL Server installation on openSUSE
- SQL Server installation on Kubuntu
- Summary
- 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)
- Summary
- 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
- Summary
- 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
- Summary
- 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
- Summary
- Backup and Recovery Operations
- SQL Server recovery models
- Simple recovery model
- Full recovery model
- Bulk-logged recovery model
- How transaction log works
- Elements of backup strategy
- Who can create backups?
- Backup media
- Types of backup
- Full database backups
- Transaction log backups
- Differential backups
- Backup and restore
- Summary
- User Management
- Authentication process
- Authorization process
- Accessing SQL Server resources
- Server-level permissions
- Database-level permissions
- Schema separation
- Summary
- Implementing Data Protection
- Crash course in cryptography
- Symmetric cryptography
- Asymmetric cryptography
- What is a key?
- SQL Server cryptographic elements
- T-SQL functions
- Certificates
- Service Master Key
- Database master key
- Transparent Data Encryption
- Backup encryption
- Symmetric encryption
- Row-level security
- Dynamic data masking
- Summary
- Indexing
- Indexing concepts
- Accessing the data
- Index structure
- Single and composite indexes
- Ascending and descending indexes
- Clustered index
- What is a heap
- Non-clustered index
- Unique indexes
- Columnstore index
- Summary
- In-Memory OLTP
- Elements of performance
- The good
- The bad
- The ugly
- What is In-Memory OLTP?
- In-Memory OLTP quick start
- How to create memory-optimized tables?
- What is natively compiled stored procedure?
- Summary
- Beyond SQL Server
- Query store
- Temporal tables
- Mssql-scripter tool
- DBFS tool
- DBeaver – third party tool
- Summary
- Conclusion 更新時間：2021-07-02 20:24:43
推薦閱讀
- Apache Spark 2.x Machine Learning Cookbook
- 深入淺出Prometheus：原理、應用、源碼與拓展詳解
- OpenNI Cookbook
- 微信小程序入門指南
- Babylon.js Essentials
- Learning Splunk Web Framework
- Java EE Web應用開發基礎
- iOS開發項目化入門教程
- Getting Started with React VR
- Tableau Dashboard Cookbook
- Java高手是怎樣煉成的：原理、方法與實踐
- Ubuntu Server Cookbook
- LabVIEW數據采集（第2版）
- Build Your Own PaaS with Docker
- Visual C++網絡編程教程（Visual Studio 2010平臺）
- C#網絡程序開發（第二版）
- 數據庫基礎與應用實驗教程：Visual FoxPro 6.0
- Python游戲編程項目開發實戰
- Cloud Native Python
- Android性能優化之道：從底層原理到一線實踐
- 響應式編程實戰：構建彈性、可伸縮、事件驅動的分布式系統
- XML程序設計案例教程
- Python 3 Text Processing with NLTK 3 Cookbook
- Java應用架構設計：模塊化模式與OSGi
- Heroku Cookbook
- Natural Language Processing with TensorFlow
- 餐飲管理與經營全案：互聯網思維創新餐飲管理和運營模式
- ASP.NET從入門到精通（第2版）
- Python：Advanced Guide to Artificial Intelligence
- C# 5 First Look
