Beginner SQL Programming Using Microsoft SQL Server 2016 - Softcover

Toth M.A. M.PHIL., Kalman

Softcover

ISBN 10: 1535311762 ISBN 13: 9781535311762

Publisher: CreateSpace Independent Publishing Platform, 2016

Synopsis

Live the American dream! Earn from $100,000 to $200,000 as a database software developer. Advance your career with SQL Server 2016 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. 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.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: New Programming Features in SS 2012 & 2014CHAPTER 6: JOINing Tables with INNER & OUTER JOINsCHAPTER 7: Basic SELECT Statement Syntax & ExamplesCHAPTER 8: Subqueries in SELECT StatementsCHAPTER 9: SELECT INTO Table Creation & PopulationCHAPTER 10: Modify Data - INSERT, UPDATE, DELETE & MERGECHAPTER 11: The Magic of Transact-SQL ProgrammingCHAPTER 12: Exporting & Importing DataAPPENDIX A: Job Interview QuestionsAPPENDIX B: Job Interview AnswersINDEX for Beginner SQL Programming Using Microsoft SQL Server 2016392

About this title

About the Author

Kalman Toth has been working with relational database technology since 1990 . His relational database career since then includes database design, database development, database administration, OLAP architecture and Business Intelligence development. Applications included enterprise-level general ledger & financial accounting, bond funds auditing, stock market feeds processing, broker-dealer firm risk management, derivative instruments analytics, consumer ecommerce database management for online dating, personal finance, physical fitness, diet and health. He has designed over 20 databases. His MSDN forum participation in the Transact-SQL and SQL Server Tools was rewarded with the Microsoft Community Contributor award in 2011 and 2012. Kalman has a Master of Arts degree in Physics from Columbia University and a Master of Philosophy degree in Computing Science also from. Accessibility: kalmantoth@gmail.com .

Edition details

• Publisher: CreateSpace Independent Publishing Platform
• Publication date: 2016
• ISBN 10: 1535311762
• ISBN 13: 9781535311762
• Binding: Paperback
• Language: English
• Number of pages: 424