
Download App
>> | LShop | >> | Book | >> | Computing & Informat... | >> | Computer Programming... | >> | Beginning T-sql: Wit... |
ISBN
:
9788126519507
Publisher
:
Wiley India Pvt Ltd
Subject
:
Computer Programming / Software Development
Binding
:
paperback
Pages
:
672
Year
:
2009
₹
499.0
₹
444.0
Buy Now
Shipping charges are applicable for books below Rs. 101.0
View DetailsEstimated Shipping Time : 5-7 Business Days
View DetailsDescription
The book teaches beginners who have not yet programmed with Transact-SQL--more commonly referred to as T-SQL. Some familiarity with relational databases and basic SQL is expected, and some programming experience is helpful. The target audience includes database developers as well as business and data analysts, and power users. The book begins with an overview of SQL Server query operations and tools used with T-SQL. After a quick review of basic query language commands and syntax, the author quickly moves to show how to design and build applications of increasing complexity.
Author Biography
Paul Turley teaches business intelligence, database design, decision-support reporting, application development, and project management courses for Netdesk in Seattle. He's the lead author of Wrox Professional SQL Server 2005 Reporting Services, and other Wrox database titles. Dan Wood is the senior database administrator for Avalara, where he both administers and develops database solutions for several enterprise applications for e-commerce and ERP clients. He has been working with SQL Server as a DBA, consultant and trainer since 1999. Dan was a contributing author on Beginning Transact-SQL with SQL Server 2000 and 2005 and the lead author of Beginning SQL Server Administration, both from WROX press. Table of Contents 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: File Stream Objects and Syntax Appendix F: Answers to Exercises Index
Related Items
-
of
Beginning Sql Server 2005 Administration
Dan Wood Chris Leiter Paul Turley
Starts At
368.0
449.0
18% OFF
Professional Microsoft Sql Server 2008 Reporting Services
Paul Turley Thiago Silva Bryan C. Smith Ken Withee
Starts At
426.0
569.0
25% OFF
Microsoft Sql Server Reporting Services Recipes: For Designing Expert Reports
Robert M. Bruckner Paul Turley
Starts At
483.0
549.0
12% OFF
Beginning SQL Server 2008 for Developers: From Novice to Professional
Robin Dewson
Starts At
426.0
479.0
11% OFF
Beginning SQL Server 2005 for Developers: From Novice to Professional
Robin Dewson
Starts At
399.0
449.0
11% OFF
Microsoft Sql Server 2008 Internals
Kalen Delaney Paul S. Randal Kimberly L. Tripp Conor Cunningham Adam Machanic Ben Nevarez
Starts At
524.0
699.0
25% OFF
Professional Microsoft Sharepoint 2007 Reporting With Sql Server 2008 Reporting Services
Coskun Cavusoglu Jacob J. Sanford Reza Alirezaei
Starts At
527.0
599.0
12% OFF
Inside Microsoft Sql Server 2008:T-Sql Programming
Itzik Ben-Gan Dejan Sarka Roger Wolter Greg Low Ed Katibah Isaac Kunen Kalen Delaney
Starts At
615.0
699.0
12% OFF
Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services (With CD)
Brian Knight
Starts At
444.0
499.0
11% OFF
Professional Microsoft Sql Server 2008 Integration Services
Brian Knight Erik Veerman Grant Dickinson Douglas Hinson Darren Herbold
Starts At
486.0
649.0
25% OFF
Professional Microsoft Sql Server Analysis Services 2008 With Mdx
Sivakumar Harinath Matt Carroll Sethu Meenakshisundaram Robert Zare Denny Guang- Lee Yeu
Starts At
506.0
649.0
22% OFF
Professional Microsoft Sql Server 2012 Integration Services
Brian Knight Erik Veerman Jessica M. Moss Mike Davis Chris Rock
Starts At
554.0
749.0
26% OFF
Designing Concurrent, Distributed, and Real-Time Applications with UML
Hassan Gomaa
Starts At
6079.0
7999.0
24% OFF
Theoretical Aspects of Object-Oriented Programming: Types, Semantics, and Language Design (Foundations of Computing)
Carl A. Gunter
Starts At
12973.0
15085.0
14% OFF
Artificial Life VII: Proceedings of the Seventh International Conference on Artificial Life (Complex Adaptive Systems)
Mark Bedau
Starts At
6602.0
7677.0
14% OFF