SQL Server 2016 Design & Programming
No Customer Reviews
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. Live Life Smart, Agile, Brilliant & Happy
Format:Paperback
Language:English
ISBN:1535112360
ISBN13:9781535112369
Release Date:July 2016
Publisher:Createspace Independent Publishing Platform
Length:830 Pages
Weight:3.20 lbs.
Dimensions:1.6" x 7.4" x 9.7"
Customer Reviews
0 rating
Copyright © 2025 Thriftbooks.com
Terms of Use | Privacy Policy | Do Not Sell/Share My Personal Information | Cookie Policy | Cookie Preferences | Accessibility Statement
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
ThriftBooks ® and the ThriftBooks ® logo are registered trademarks of Thrift Books Global, LLC
