We may earn an affiliate commission when you visit our partners.

Beginner SQL Programming Using Microsoft SQL Server 2016

Kalman Toth

Live the American dream! Earn from $100,000 to $200,000 as an SQL database developer and/or designer! 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 an equally magical invention that 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 GlanceSQL 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: New Programming Features in SS 2012 & 2014CHAPTER 11: JOINing Tables with INNER & OUTER JOINsCHAPTER 12: Basic SELECT Statement Syntax & ExamplesCHAPTER 13: Subqueries in SELECT StatementsCHAPTER 14: SELECT INTO Table Creation & PopulationCHAPTER 15: Modify Data - INSERT, UPDATE, DELETE & MERGECHAPTER 16: The Magic of Transact-SQL ProgrammingCHAPTER 17: Exporting & Importing DataAPPENDIX A: Job Interview QuestionsAPPENDIX B: Job Interview Answers

Live Life Active, Agile, Brilliant, Healthy & Happy!

Save this book

Create your own learning path. Save this book to your list so you can find it easily later.
Save

Share

Help others find this book page by sharing it with your friends and followers:
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser