Beginning Transact-SQL with SQL Server 2000 and 2005

Beschreibung

Beginning Transact-SQL with SQL Server 2000 and 2005 Transact-SQL is a powerful implementation of the ANSI standardSQL database query language. In order to build effective databaseapplications, you must gain a thorough understanding of thesefeatures. This book provides you with a comprehensive introductionto the T-SQL language and shows you how it can be used to work withboth the SQL Server 2000 and 2005 releases. Beginning with an overview of the SQL Server query operationsand tools that are used with T-SQL, the author goes on to explainhow to design and build applications of increasing complexity. Bygaining an understanding of the power of the T-SQL language, you'llbe prepared to meet the ever-increasing demands of programming. What you will learn from this book * How T-SQL provides you with the means to create tools formanaging hundreds of databases * Various programming techniques that use views and storedprocedures * Ways to optimize query performance * How to create databases that will be an essential foundation toapplications you develop later Who this book is for This book is for database developers and administrators who havenot yet programmed with Transact-SQL. Some familiarity withrelational databases and basic SQL is helpful, and some programmingexperience is helpful. Wrox Beginning guides are crafted to make learningprogramming languages and technologies easier than you think,providing a structured, tutorial format that will guide you throughall the techniques involved.

Autor*in

Paul Turley

Themen in »Beginning Transact-SQL with SQL Server 2000 and 2005«

Computer Science Database & Data Warehousing Technologies Datenbanken u. Data Warehousing Informatik SQL

Stimmen zu »Beginning Transact-SQL with SQL Server 2000 and 2005«

Details

Link teilen