Beginner Database Design & SQL Programming Using Microsoft SQL Server 2016

Overview

SQL Server 2016 database design & SQL programming book is an essential guide for building a bright career in Information Technology. It is sufficient to master this SQL Server 2016 book to know SQL Server 2005/2008/2012/2014 since the book has frequent version references.

The relational database is a marvelous invention (thanks to IBM staff) of Computer Science to organize and manipulate data in a logical way.

The SQL (Structured Query Language) is equally magical invention which allows us to work with data - 10 rows or 10 billion rows - at ease.

SQL Server 2016 is the latest and best RDBMS (Relational Database Management System) from Microsoft with a host of new enhancements.

Upon mastering this book you can launch a rewarding career in SQL Server database design and programming. Good Luck!

Contents at a Glance
SQL Server 2016 New Features
CHAPTER 1: SQL Server Sample & System Databases
CHAPTER 2: Installing SQL Server 2016
CHAPTER 3: Structure of the SELECT Statement
CHAPTER 4: SQL Server Management Studio
CHAPTER 5: Basic Concepts of Client-Server Computing
CHAPTER 6: Fundamentals of Relational Database Design
CHAPTER 7: Normal Forms & Database Normalization
CHAPTER 8: Functional Database Design
CHAPTER 9: Advanced Database Design Concepts
CHAPTER 10: New Programming Features in SS 2012 & 2014
CHAPTER 11: JOINing Tables with INNER & OUTER JOINs
CHAPTER 12: Basic SELECT Statement Syntax & Examples
CHAPTER 13: Subqueries in SELECT Statements
CHAPTER 14: SELECT INTO Table Creation & Population
CHAPTER 15: Modify Data - INSERT, UPDATE, DELETE & MERGE
CHAPTER 16: The Magic of Transact-SQL Programming
CHAPTER 17: Exporting & Importing Data
APPENDIX A: Job Interview Questions
APPENDIX B: Job Interview Answers

Read More