This book is a really great beginners guide for core SQL Server 2012, and it also does a great job of introducing new features introduced in SQL Server 2012. What I mean by core is that topics like Master Data Services and Data Quality Services are not introduced. That is not a bad thing. By limiting the scope of the book, the author was able to better the topics that are included.
I wanted this book because I like having a book about the basics close by. I am not in SQL Server everyday and when I find myself needing to go back to it, I not only want books on the advanced features nearby, I want the basics also.
The book covers all the basics you need to know to get up and running quickly. After a really nice introduction where the author covers the new 2012 features and where they are covered in the book, they have a nice overview of relational databases and detailed coverage of the installation process.
The book is broken into five parts. I have listed the parts and the chapters in each below. The titles of the chapters show the topics covered.
Part I: Basic Concepts and Installation Chapter 1. Relational Database Systems: An Introduction Chapter 2. Planning the Installation and Installing SQL Server Chapter 3. SQL Server Management Studio
Part II: Transact-SQL Language Chapter 4. SQL Components Chapter 5. Data Definition Language Chapter 6. Queries Chapter 7. Modification of a Table's Contents Chapter 8. Stored Procedures and User-Defined Functions Chapter 9. System Catalog Chapter 10. Indices Chapter 11. Views Chapter 12. Security System of the Database Engine Chapter 13. Concurrency Control Chapter 14. Triggers
Part III: SQL Server: System Administration Chapter 15. System Environment of the Database Engine Chapter 16. Backup, Recovery, and System Availability Chapter 17. Automating System Administration Tasks Chapter 18. Data Replication Chapter 19. Query Optimizer Chapter 20. Performance Tuning
Part IV: SQL Server and Business Intelligence Chapter 21. Business Intelligence: An Introduction Chapter 22. SQL Server Analysis Services Chapter 23. Business Intelligence and Transact-SQL Chapter 24. SQL Server Reporting Services Chapter 25. Optimizing Techniques for Relational Online Analytical Processing
Part V: Beyond Relational Data Chapter 26. SQL Server and XML Chapter 27. Spatial Data Chapter 28. SQL Server Full-Text Search
The author has a great writing style and really explains things clearly making good use of diagrams, code samples, and tables. I mention that because I have seen books that don't.
The author has made all the scripts, sample database, and exercise solutions available. The author also makes use of the AdventureWorks and AdventureWorksDW database. I thought is was strange they didn't use the AdventureWorks2012 and the AdventureWorksDW2012 version available on CodePlex, but that was probably because they weren't available at the time the book was written.
Like I said at the beginning if the review, this is a beginners book, just like the title states. You won't find coverage of topics like cursors, buy you will find all the basics are covered.
All in all I highly recommend this book as the starting point for anyone looking to learn SQL Server 2012
Coca-Cola’s Google powered digital signage system lays the groundwork for a more valuable connection between Coke and its customers. Digital signs pair software with high-resolution displays so that a message can be changed instantly based on what the operator wants to communicat...
The question before companies today is not whether to become intelligent, it’s a question of how and how fast. The key is to adopt and deploy an intelligent application strategy while simultaneously preparing to scale that intelligence. In her session at 21st Cloud Expo, Sangeeta...
Bert Loomis was a visionary. This general session will highlight how Bert Loomis and people like him inspire us to build great things with small inventions. In their general session at 19th Cloud Expo, Harold Hannon, Architect at IBM Bluemix, and Michael O'Neill, Strategic Busin...
DX World EXPO, LLC, a Lighthouse Point, Florida-based startup trade show producer and the creator of "DXWorldEXPO® - Digital Transformation Conference & Expo" has announced its executive management team. The team is headed by Levent Selamoglu, who has been named CEO. "Now is the ...
Companies are harnessing data in ways we once associated with science fiction. Analysts have access to a plethora of visualization and reporting tools, but considering the vast amount of data businesses collect and limitations of CPUs, end users are forced to design their structu...
Your registrations includes: Golden Pass Delegates will receive full conference access on October 20-22, 2008 including: Lunch and Coffee Breaks, Collectible Bag and Archives of all sessions on DVD. Includes access to all Conference Sessions including the Technical Sessions, Exhibits, Keynotes, Vendor Technology Presentations, and Power Panels.
AJAXWorld offers the undisputed best platform to position your company as a leading vendor in the fast-emerging marketplace for AJAX and Enterprise Web 2.0.
Who Should Attend?
• CTOs & VPs of Engineering
• Directors of Technology
• Sr. User Interface Architects
• Front-End Engineers
• VCs & Industry Analysts
• Directors of Business Development
• Software Engineers
• Senior Architects
• Application Programmers & Software Developers
• Project Managers
• Web Programmers & Designers
• Companies & Organizations that need to stay in front of the latest Web technology
AJAXWorld Security Bootcamp
Introducing at AJAXWorld RIA Conference 2008 West the world's first-ever full, one-day immersive "AJAX Security Bootcamp" - led by one of the world's foremost AJAX security experts and teachers, HP's Billy Hoffman.