|
Free ebooks
 Free database ebooks SQL Wiley - SQL Server 2005 Bible
|
||||||||
 Part I: Laying the FoundationIf SQL Server is the box, and developing is thinking inside the box, then the first part of this ebook is an introduction to the box. This isn’t the obligatory “introduction to normalization” view of database design. Part I is a current, comprehensive, principle-driven view of information architecture and an introduction to the technologies of SQL Server. Part II: Manipulating Data with Select If SQL Server is the box, then Part II is about being one with the box. It begins by exploring the basic logical query flow, and quickly digs deeper into topics such as relational division, correlated subqueries, set-difference queries, and distributed queries. I’ve devoted ten chapters to the select command because understanding the multiple options and creative techniques available with queries is key to becoming a successful SQL Server developer, DBA, or architect. Please don’t assume that Part II is only for beginners. These ten chapters present the core power of SQL. Part VI explores optimization, and it’s tempting to go there for optimization ideas. However, the second strategy of optimization theory is using good set-based code, so here are ten chapters on how to optimize your database by writing better queries. Part III: Developing with SQL Server If SQL Server is the box, then Part III is all about thinking inside the box, and moving the processing as close to the data as possible. Part III opens with DDL commands (create, alter, and drop), and progresses through nine chapters that dig deeper into Transact-SQL. The conclusion of the T-SQL chapters brings it all together with the data abstraction layer. SQL Server’s list of technologies keeps growing, so the remainder of Part III explores the .NET common language runtime (CLR), SQL Server Mobile, Service Broker, XML, XQuery, Web Services, and InfoPath. Go ahead, unleash the programmer within and have fun. There’s a whole world of developer possibilities with SQL Server 2005. Part IV: Enterprise Data Management If SQL Server is the box, then Part IV is about keeping the box running smoothly, day after day, because this part is all about the enterprise DBA role. While SQL Server is more automated than ever before, and Microsoft sometimes makes the error of presenting SQL Server as the database that doesn’t require a DBA, the truth is that it takes diligent work to keep a production database up 24 hours a day, 7 days a week, 365 days a year. Part V: Business Intelligence If SQL Server is the box, then Part V is about coaxing every secret out of the box. The whole process of analyzing historical and current data both today and in the future is the proactive side of IT, collectively called business intelligence (BI). In the past three releases of SQL Server, Microsoft has been steadily growing SQL Server’s BI services, and SQL Server 2005 brings to fruition years of planning and development. From the enterprise-grade ETL tool to the rich and easy to build cubes, to the slick reporting interface, SQL Server 2005 is more than ready to help you conquer your BI requirements. The chapters in this part show you how. Part VI: Optimization Strategies If SQL Server is the box, then Part VI is about making the box fly. This book opens with the Information Architecture Principle, which states that information must be made readily available. Optimization theory explains the dependencies between various optimization techniques. This final part puts optimization theory into action with practical optimization strategies. Part VII: Appendixes The appendixes provide some lookup information that applies to nearly every chapter: SQL Server specifications and details of the book’s sample databases. Download ebook for SQL:SQL Server 2005 Bible
|
| More free ebooks | |