Overview

Earn $120-160K as a database architect or senior SQL developer! Learn the latest and best design features of SQL Server 2016. This book has frequent version references, so you will be up-to-date with SQL Server 2005/2008/2012/2014. Design databases with confidence that are properly structured, reliable, high performance and flexible, even in e-commerce and other web applications. Contents at a glance: SQL Server 2016 New Features CHAPTER 1: SQL Server Sample & System Databases CHAPTER 2: Structure of the SELECT Statement CHAPTER 3: SQL Server Management Studio CHAPTER 4: Basic Concepts of Client-Server Computing CHAPTER 5: Fundamentals of Relational Database Design CHAPTER 6: Normal Forms & Database Normalization CHAPTER 7: Functional Database Design CHAPTER 8: Advanced Database Design Concepts CHAPTER 9: The Art of Database Design CHAPTER 10: Basic SELECT Statement Syntax & Examples CHAPTER 11: Maintaining Data Integrity in the Enterprise CHAPTER 12: In-Memory OLTP APPENDIX A: Job Interview Questions APPENDIX B: Job Interview Answer