舉報 
會員
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
推薦閱讀
- DBA攻堅指南：左手Oracle，右手MySQL
- Angular UI Development with PrimeNG
- Rust編程：入門、實戰與進階
- Visual FoxPro程序設計習題集及實驗指導（第四版）
- C++從入門到精通（第5版）
- Java EE企業級應用開發教程（Spring+Spring MVC+MyBatis）
- MySQL程序員面試筆試寶典
- Visual FoxPro 6.0程序設計
- Sails.js Essentials
- ASP.NET Web API Security Essentials
- R語言數據挖掘：實用項目解析
- jQuery從入門到精通（微課精編版）
- 實戰Python網絡爬蟲
- Roslyn Cookbook
- 深入理解C++11：C++11新特性解析與應用
- Instant OpenCV for iOS
- C#多線程編程實戰
- The PHP Workshop
- 軟件測試（第2版）
- 思維黑客：讓大腦重裝升級的75個超頻用腦法
- KnockoutJS Web Development
- 強化學習：原理與Python實現
- Swift從入門到精通
- Jupyter for Data Science
- Mastering Numerical Computing with NumPy
- Python深度學習從零開始學
- OpenCV 4 with Python Blueprints
- Hadoop Backup and Recovery Solutions
- Android System Programming
- PhoneGap By Example
