Beginner SQL Programming Using Microsoft SQL Server 2016 - Brossura

Toth M.A. M.PHIL., Kalman

Brossura

ISBN 10: 1535311762 ISBN 13: 9781535311762

Casa editrice: CreateSpace Independent Publishing Platform, 2016

Riassunto

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

Dettagli dell?edizione

• Editore: CreateSpace Independent Publishing Platform
• Data di pubblicazione: 2016
• ISBN 10: 1535311762
• ISBN 13: 9781535311762
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero di pagine: 424