Sql Server 2017 Developers Guide A Professional Guide To Designing And Developing Enterprise Database Applications(1st Edition)

Book details

Book Price $0 : Build Smarter And Efficient Database Application Systems For Your Organization With SQL Server 2017Key FeaturesExplore The Development Features Of SQL Server 2017 To Build Database ApplicationsWork With Temporal Tables To Get Information About Data Stored In A Table At Any Point Of TimeUse Adaptive Querying To Enhance The Performance Of Your QueriesBook DescriptionMicrosoft SQL Server 2017 Is A Milestone In Microsoft's Data Platform Timeline, As It Integrates The Power Of R And Python For Machine Learning And Containerization-based Deployment On Windows And Linux.This Book Starts With A Quick Introduction To The New Features Of SQL Server 2017 To Help You Get Up And Running With Its Latest Features. You’ll Be Introduced To The Enhancements In Transact-SQL And New Database Engine Capabilities Before Advancing To JSON Support. This Guide Will Also Take You Through Security Improvements And Enable You To Work Efficiently With Temporal Tables. You’ll Then Delve Into Advanced Topics Such As Query Store, Columnstore Indexes, And In-Memory OLTP. Toward The End Of The Book, You'll Delve Into R And Discover How To Use The R Language With Transact-SQL For Data Exploration And Analysis. You'll Also Learn How To Integrate Python Code Into SQL Server, Understand Graph Database Implementations, And Explore The Flexibility Of Containers For Development And Testing.By The End Of This Book, You’ll Have Learned How To Design Efficient High-performance Database Applications With SQL 2017 Easily.What You Will LearnExplore The Latest Development Features In SQL Server 2017Identify Opportunities For In-Memory OLTP TechnologyUse Columnstore Indexes For Storage And Performance ImprovementsExchange JSON Data Between Applications And SQL ServerEncrypt Or Mask Data Using New Security FeaturesControl Access To Data On Row LevelsDiscover The Potential Of R And Python IntegrationModel Complex Relationships With Graph Databases In SQL Server 2017Who This Book Is ForDatabase Developers And Solution Architects Looking To Design Efficient Database Applications Using SQL Server 2017 Will Find This Book Useful. Also, If You’re An Advanced Analysis Practitioner, Business Intelligence Developer, Or A Database Consultant Dealing With Performance Tuning, This Book Is For You.Basic Understanding Of Database Concepts And T-SQL Will Assist With Understanding Key Concepts Covered In This Book.Table Of ContentsIntroduction To SQL Server 2017 9Introduction To SQL Server 2017Review Of SQL Server Features For Developers 23Review Of SQL Server Features For DevelopersSQL Server Tools 75SQL Server ToolsTransact-SQL And Database Engine Enhancements 115Transact-SQL And Database Engine EnhancementsJSON Support In SQL Server 187JSON Support In SQL ServerStretch Database 241Stretch DatabaseTemporal Tables 289Temporal TablesTightening Security 353Tightening SecurityQuery Store 407Query StoreColumnstore Indexes 459Columnstore IndexesIntroducing SQL Server In-Memory OLTP 523Introducing SQL Server In-Memory OLTPIn-Memory OLTP Improvements In SQL Server 2017 557In-Memory OLTP Improvements In SQL Server 2017Supporting R In SQL Server 593Supporting R In SQL ServerData Exploration And Predictive Modeling With R 645Data Exploration And Predictive Modeling With RIntroducing Python 687Introducing PythonGraph Database 723Graph DatabaseContainers And SQL On Linux 767Containers And SQL On Linux See more