Beginning SQL Server 2005 Programming 1st Edition by Robert Vieira ISBN 0764584332 978-0764584336
Original price was: $50.00.$35.00Current price is: $35.00.
Beginning SQL Server 2005 Programming 1st Edition by Robert Vieira – Ebook PDF Instant Download/Delivery:0764584332, 978-0764584336
Full download Beginning SQL Server 2005 Programming 1st Edition after payment
Product details:
ISBN 10: 0764584332
ISBN 13: 978-0764584336
Author: Robert Vieira
- After a quick primer on database design basics and the SQL query language (for those programmers who may be building their first database application), this book provides an overview of SQL Server itself, which has been dramatically redesigned with the 2005 release
- Once readers have grasped the fundamentals of database design and SQL concepts, they will then learn how to implement those concepts with Microsoft SQL Server 2005
- Addresses creating and changing tables, managing keys, database normalization, writing scripts, working with stored procedures, programming with XML, and using SQL Server reporting and data transformation services
- The companion Web site provides all of the code found in the book
Table of contents:
Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?
Chapter 2: Tools of the Trade.
Chapter 3: The Foundation Statements of T-SQL.
Chapter 4: JOINs.
Chapter 5: Creating and Altering Tables.
Chapter 6: Constraints.
Chapter 7: Adding More to Our Queries.
Chapter 8: Being Normal: Normalization and Other Basic Design Issues.
Chapter 9: SQL Server Storage and Index Structures.
Chapter 10: Views.
Chapter 11: Writing Scripts and Batches.
Chapter 12: Stored Procedures.
Chapter 13: User Defined Functions.
Chapter 14: Transactions and Locks.
Chapter 15: Triggers.
Chapter 16: A Brief XML Primer.
Chapter 17: Reporting for Duty, Sir!: A Look At Reporting Services.
Chapter 18: Getting Integrated With Integration Services.
Chapter 19: Playing Administrator.
People also search for:
sql server 2005 backward compatibility components
sql server 2005 bc
sql server 2005 backward compatibility components download
sql server 2005 backup database
sql server 2005 business intelligence development studio download