SQL Server 2016 Design & Programming - Softcover

Reseña del editor

Live the American dream! Earn from $100,000 to $200,000 as a database professional. Advance your career with SQL Server 2016 database design and T-SQL programming. When you will learn this book, you will also know SQL Server 2005/2008/2012/2014 since the book has frequent version references. Design your own relational database and develop your own Transact-SQL code for querying, modifying, managing & administering data in Microsoft SQL Server 2016. You will learn data management both through visual interface and writing T-SQL scripts, stored procedures, user-defined functions & triggers.Chapters at a glance:SQL Server 2016 New FeaturesCHAPTER 1: SQL Server Sample & System DatabasesCHAPTER 2: Installing SQL Server 2016CHAPTER 3: Structure of the SELECT StatementCHAPTER 4: SQL Server Management StudioCHAPTER 5: Basic Concepts of Client-Server ComputingCHAPTER 6: Fundamentals of Relational Database DesignCHAPTER 7: Normal Forms & Database NormalizationCHAPTER 8: Functional Database DesignCHAPTER 9: Advanced Database Design ConceptsCHAPTER 10: The Art of Database DesignCHAPTER 11: New Programming Features in SS 2012 & 2014CHAPTER 12: JOINing Tables with INNER & OUTER JOINsCHAPTER 13: Basic SELECT Statement Syntax & ExamplesCHAPTER 14: Subqueries in SELECT StatementsCHAPTER 15: SELECT INTO Table Creation & PopulationCHAPTER 16: Modify Data - INSERT, UPDATE, DELETE & MERGECHAPTER 17: The Magic of Transact-SQL ProgrammingCHAPTER 18: Exporting & Importing DataCHAPTER 19: Maintaining Data Integrity in the EnterpriseCHAPTER 20: Query & Stored Procedure OptimizationCHAPTER 21: Advanced T-SQL Programming TopicsCHAPTER 22: In-Memory OLTPAPPENDIX A: Job Interview QuestionsAPPENDIX B: Job Interview AnswersINDEX of SQL Server 2016 Design & Programming