Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition

Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition

4.25 (4 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 2 business days
When will my order arrive?


Up-to-date Microsoft SQL Server 2016 skills made easy! Get up and running on Microsoft SQL Server 2016 in no time with help from this thoroughly revised, practical resource. The book offers thorough coverage of SQL management and development and features full details on the newest business intelligence, reporting, and security features. Filled with new real-world examples and hands-on exercises, Microsoft SQL Server 2016: A Beginner's Guide, Sixth Edition, starts by explaining fundamental relational database system concepts. From there, you will learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis and BI tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial. * Revised from the ground up to cover the latest version of SQL Server * Ideal both as a self-study guide and a classroom textbook * Written by a prominent professor and best-selling author
show more

Product details

  • Paperback | 896 pages
  • 185 x 236 x 46mm | 1,311g
  • McGraw-Hill Education - Europe
  • McGraw Hill Higher Education
  • London, United States
  • English
  • 6th edition
  • 100 Illustrations, unspecified
  • 1259641791
  • 9781259641794
  • 74,817

About Dusan Petkovic

Dusan Petkovic (Rosenheim, Germany) is a professor in the computer science department at the Polytechnic in Rosenheim, Germany. He is the best-selling author of 5 editions of SQL Server: A Beginner's Guide and has authored numerous articles for SQL Server Magazine and technical papers for Embarcadero.
show more

Table of contents

Part 1: Basic ConceptsChapter 1: Relational Database Systems: An IntroductionChapter 2: Planning the Installation and Installing SQL ServerChapter 3: SQL Server Management StudioPart 2: Transact-SQL LanguageChapter 4: SQL ComponentsChapter 5: Data Definition LanguageChapter 6: QueriesChapter 7: Modification of a Table's ContentsChapter 8: Stored Procedures and User-Defined FunctionsChapter 9: System CatalogChapter 10: IndicesChapter 11: ViewsChapter 12: Security System of the Database EngineChapter 13: Concurrency ControlChapter 14: TriggersPart 3: System AdministrationChapter 15: System Environment of the Database EngineChapter 16: Backup, Recovery and System AvailabilityChapter 17: Automating System AdministrationChapter 18: Data ReplicationChapter 19: Query OptimizerChapter 20: Performance TuningChapter 21: In-Memory OLTPPart 4: SQL Server and Business IntelligenceChapter 22: Business Intelligence: An IntroductionChapter 23: SQL Server Analysis ServicesChapter 24: Business Intelligence and Transact-SQLChapter 25: SQL Server Reporting ServicesChapter 26: Optimizing Techniques for Data WarehousingChapter 27: Columnstore IndicesPart 5: Beyond Relational DataChapter 28: XML and JSON SupportChapter 29: Spatial and Temporal DataChapter 30: SQL Server Full-Text Search
show more

Rating details

4 ratings
4.25 out of 5 stars
5 50% (2)
4 25% (1)
3 25% (1)
2 0% (0)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X