| Beginner Database Design & SQL Programming Using Microsoft SQL Server 2016 Contributor(s): Toth M. a. M. Phil, Kalman (Author) |
|
 |
ISBN: 153500861X ISBN-13: 9781535008617 Publisher: Createspace Independent Publishing Platform OUR PRICE: $21.80 Product Type: Paperback Published: June 2016 |
| Additional Information |
| BISAC Categories: - Computers | Programming Languages - Sql |
| Physical Information: 1.24" H x 7.44" W x 9.69" (2.39 lbs) 616 pages |
| Descriptions, Reviews, Etc. |
| Publisher Description: 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 |