{ "item_title" : "SQL Server 2016 Design & Programming", "item_author" : [" Kalman Toth M. a. M. Phil "], "item_description" : "Live the American dreamEarn 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. Live Life Smart, Agile, Brilliant & Happy ", "item_img_path" : "https://covers2.booksamillion.com/covers/bam/1/53/511/236/1535112360_b.jpg", "price_data" : { "retail_price" : "39.95", "online_price" : "39.95", "our_price" : "39.95", "club_price" : "39.95", "savings_pct" : "0", "savings_amt" : "0.00", "club_savings_pct" : "0", "club_savings_amt" : "0.00", "discount_pct" : "10", "store_price" : "" } }

Overview

Customers Also Bought

Details