Beginning T-SQL with Microsoft SQL Server 2005 and 2008
Published on 11. February 2011
676 pages
978-0-470-44049-0 (ISBN)
Description
If you've not programmed with Transact-SQL, this book is for you.It begins with an overview of SQL Server query operations and tools used with T-SQL, and covers both the 2005 and 2008 releases of SQL Server query tools and the query editor. The book then moves to show you how to design and build applications of increasing complexity. Other important tasks covered include full text indexing, optimizing query performance, and application design and security considerations. The companion website also provides all of the code examples from the book.
More details
Other editions
Additional editions
Paul Turley | Dan Wood
Beginning T-SQL with Microsoft SQL Server 2005 and 2008
Book
12/2008
Wrox Press
Unfortunately, price unknown
Article exhausted; check different version
Persons
Paul Turley (Vancouver, WA) is a Manager of SpecializedServices for Hitachi Consulting Education Services. Paul managesthe Business Intelligence training team and teaches classes forcompanies throughout the world on Microsoft SQL Servertechnologies. He works with companies to architect and build BI andreporting solutions. He has been developing business databasesolutions since 1991 for companies like Microsoft, Disney, Nike,and Hewlett - Packard. He has been a Microsoft Certified Trainersince 1996 and holds several industry certifications, includingMCTS and MCITP for BI, MCSD, MCDBA, MSF Practitioner, and ITProject+.
Paul has authored and co - authored several books and courses ondatabase, business intelligence, and application developmenttechnologies. He is the lead courseware developer for the HitachiConsulting courses: SQL Server 2008 Business Intelligence Solutionsand SQL Server 2008 Reporting Services Solutions. Books include theprior edition of this book, the 2008, 2005 and 2000 editions ofProfessional SQL Server Reporting Services , BeginningSQL Server 2005 Administration , Beginning Access 2002VBA , Data Warehousing with SQL Server 2000 AnalysisServices , and Professional Access 2000 Programming-- all from Wrox. He is also a contributing author for SQLServer 2005 Integration Services Step by Step from MicrosoftPress.
Dan Wood (Silverdale, WA) is the senior databaseadministrator for Avalara, a sales tax compliance company, where heboth administers and develops database solutions for severalenterprise applications that handle global address validation, taxrate calculation, and sales tax remittance for e - commerce and ERPclients. He has been working with SQL Server as a DBA, consultant,and trainer since 1999. Dan was a contributing author onBeginning Transact - SQL with SQL Server 2000 and 2005 andthe lead author of Beginning SQL Server Administration ,both from Wrox.
Content
Introduction.
Chapter 1: Introducing T-SQL and Data Management Systems.
Chapter 2: SQL Server Fundamentals.
Chapter 3: SQL Server Tools.
Chapter 4: Introducing the T-SQL Language.
Chapter 5: Data Retrieval.
Chapter 6: SQL Functions.
Chapter 7: Aggregation and Grouping.
Chapter 8: Multi-Table Queries.
Chapter 9: Advanced Queries and Scripting.
Chapter 10: Transactions.
Chapter 11: Advanced Capabilities.
Chapter 12: T-SQL Programming Objects.
Chapter 13: Creating and Managing Database Objects.
Chapter 14: Analyzing and Optimizing Query Performance.
Chapter 15: T-SQL in Applications and Reporting.
Appendix A: Command Syntax Reference.
Appendix B: System Variables and Functions Reference.
Appendix C: System Stored Procedure Reference.
Appendix D: Information Schema Views Reference.
Appendix E: FileStream Objects and Syntax.
Appendix F: Answers to Exercises.
Index.
