Ideal for the database programmer or system DBA, Microsoft SQL Server 2000 Programming by Example is an excellent example-based tutorial on mastering today's SQL features. Packed with plenty of tips and tricks, this title will let most anyone do more with SQL Server.

While there are plenty of screen shots showing graphical SQL Server tools, the focus of this book is clearly on learning real command-line Transact-SQL (T-SQL). The authors provide a patient and very thorough tour of T-SQL with full coverage of both basic and advanced features. You'll learn how to define new tables, manage users in groups, and perform all kinds of queries. Standout material includes an excellent guide to SQL data types and how to choose the right one for your needs. When it comes to queries, the book does a great job of exploring all your options for joining relational data, as well as grouping data for more advanced reporting. True to its title, Microsoft SQL Server 2000 Programming by Example is filled with dozens of examples of SQL commands (and the results returned) so that you can try out this material for yourself and really learn the language thoroughly.

Later on, the authors turn toward server-side programming with a digestible guide to creating stored procedures and triggers. The book closes with an in-depth guide to the issues regarding cursors (for working with table data), transactions, and locking. Sections on bulk copy tools and the Microsoft Data Transformation Services (DTS) show how to move data around the enterprise. A final section of distributed queries and linked servers will help you work with different sources of data wherever it resides in your organization.

Despite some stilted writing, the comprehensive examples in this book make it a success. It will let anyone start using basic T-SQL for the first time, as well as teach more advanced readers to master the finer points of Microsoft databases. --Richard Dragan

Topics covered: History and introduction to Microsoft SQL Server In-depth Transact-SQL (T-SQL) tutorial (including T-SQL data types and flow control statements) Creating and modifying tables and views Creating queries with the SELECT statement Inserting, deleting, and updating data Using joins (inner, outer, and cross joins) Indexes (database optimization and index maintenance) Data integrity (constraints and foreign keys) Business logic with stored procedures (including error handling and security) Tutorial and tips for triggers (including nested and recursive triggers) User-Defined Functions (UDFs) Complex queries and subqueries Row-oriented processing with cursors (including SQL Server cursor types) Transactions in T-SQL (including basic ACID properties, isolation levels, and locks) Avoiding deadlocks Transferring data to and from SQL Server with bulk copy and Data Transformation Services (DTS) Databases in heterogeneous environments (distributed queries and linked servers) Using the SQL Query Analyzer


From Book News, Inc.
For readers with previous experience in any programming language and at least some background knowledge about logical database design. The guide provides the information needed to develop and maintain SQL Server applications, including XML functionality, and also prepares readers for one of the core exams of the Microsoft Certified Database Administrator certification.Copyright © 2004 Book News, Inc., Portland, OR


Book Description
SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples.


Book Info
A beginner to intermediate example-based guide to learning the fundamentals of SQL Server 2000 programming. The CD-ROM contains a 120-Day Enterprise Edition trial of SQL Server 2000. Includes everything from tips for understanding SQL to using the new Query Analyzer to create and test database objects. System requirements not listed. Softcover.


From the Publisher
SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples. Get up to speed on SQL Server 2000 and how to take full advantage of new features


From the Author
We decided to write this book to help developers to start learning how to program databases in SQL Server 2000. It is a book for beginners, and for developers with some experience, searching for some good advice on how to use Transact-SQL language to program databases. It contains more than 400 listings to help you practice every single feature. The book was born with SQL Server 2000, uses SQL Server 2000, and teaches SQL Server 2000. It is not a transition book, nor a new-features book, it is simply a SQL Server 2000 Programming book. It covers only programming topics, but it includes a comprehensive section on security, because we believe it is crucial for database developers. Perhaps you'd prefer to start reading the book from the end, where you can find an entire Appendix on how the new Query Analyzer 2000 works. If you have already some experience in database development, you will benefit from a comprehensive chapter on Indexes, a chapter on user-defined functions (the longest chapter in the book), and a complete chapter on concurrency, with lots of examples. You can visit the book website where you can read online an extra chapter on XML support in SQL Server 2000, only available in Internet, and you can download the examples source code for the entire book.


From the Back Cover
SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples.


About the Author
Carlos Eduardo Rojas is a program manager with Planeta Networks, an Internet company headquartered in Coral Gables, Florida that provides broadband applications to Internet service providers in Ibero-America. He specializes in the design of n-tier applications, database implementation, and administration of SQL Server databases. Prior to this role, he was a consultant and trainer with Manapro in Caracas, Venezuela, where he is originally from. Also, he has participated as a speaker in various TechNet conferences in Venezuela. Carlos earned a B.S. degree in Computer Science from University Simón Bolívar, Caracas, Venezuela. He is a Microsoft Certified Systems Engineer + Internet (MCSE+I), Microsoft Certified Database Administrator (MCDBA), Microsoft Certified Sales Specialist (MCSS), and has been awarded with the MVP (Most Valuable Professional) status on SQL Server. He is also a voting member and volunteer of PASS, the professional association for SQL Server. Carlos can be reached at carlos@sqlserverbyexample.com. Fernando G. Guerrero is a principal technologist and SQL Server product consultant in QA, United Kingdom. His main role involves IT training, course development, and internal mentoring. He writes for SQL Server Magazine (http://www.sqlmag.com), presented a session on SQL Server 2000 at TechEd 2000 Europe, and has accepted to speak at PASS2001, TechEd Europe 2001, VBUG 2001, VBITS 2001, VSLive, and SQL2THEMAX conferences during the year 2001. He is a Civil and Hydrologic Engineer with almost 20 years' experience in software development and design, in many cases applied to engineering environments. He holds seven Microsoft Professional Certifications, including MCSE+Internet, MCSD, MCDBA, MCT, and has been awarded with the MVP (Most Valuable Professional) status on SQL Server. He is also a voting member and volunteer of PASS, the professional association for SQL Server. His professional experience covers six years (1981–1987) as a lecturer in the Valencia's Polytechnic University (Spain, http://www.upv.es), where he was lecturing on surveying, photogrammetry, technical drawing, and applied numerical methods in the Civil Engineering School and the Agricultural Engineering School. He built his own software company in Spain, TOU S.A., focused on desktop publishing and graphical tools for the professional market, and was technical director in that company for four years (1987–1991). Before joining QA (Nov. 1998), he spent eight years (1991–1998) as an international consultant for a prestigious Spanish engineering firm (http://www.inypsa.es), living in different countries, designing, developing, and implementing information systems for projects financed by the World Bank, the European Union, and the European Investment Bank. Fernando can be reached at fernan@sqlserverbyexample.com.

FROM THE PUBLISHER

SQL Server 2000 Programming by Example provides clear and concise examples of basic programming techniques used in SQL Server 2000 primarily using Transact-SQL. Even if you're a complete novice to SQL Server 2000 programming, you will benefit by reading through the book's logical process. SQL Server 2000 is introduced and explored, database structure is designed and built, and finally a variety of programming techniques are studied and reviewed. If you are already familiar with SQL Server 2000 programming, you may use the book as a quick reference guide that provides plenty of pertinent examples.

SYNOPSIS

For readers with previous experience in any programming language and at least some background knowledge about logical database design. The guide provides the information needed to develop and maintain SQL Server applications, including XML functionality, and also prepares readers for one of the core exams of the Microsoft Certified Database Administrator certification. Annotation c. Book News, Inc., Portland, OR (booknews.com)

ACCREDITATION

Carlos Eduardo Rojas is a program manager with Planeta Networks, an Internet company headquartered in Coral Gables, Florida that provides broadband applications to Internet service providers in Ibero-America. He specializes in the design of n-tier applications, database implementation, and administration of SQL Server databases. Prior to this role, he was a consultant and trainer with Manapro in Caracas, Venezuela, where he is originally from. Also, he has participated as a speaker in various TechNet conferences in Venezuela. Carlos earned a B.S. degree in Computer Science from University Simó n Bolí var, Caracas, Venezuela. He is a Microsoft Certified Systems Engineer + Internet (MCSE+I), Microsoft Certified Database Administrator (MCDBA), Microsoft Certified Sales Specialist (MCSS), and has been awarded with the MVP (Most Valuable Professional) status on SQL Server. He is also a voting member and volunteer of PASS, the professional association for SQL Server. Carlos can be reached at carlos@sqlserverbyexample.com.

Fernando G. Guerrero is a principal technologist and SQL Server product consultant in QA, United Kingdom. His main role involves IT training, course development, and internal mentoring.

He writes for SQL Server Magazine ( sqlmag.com), presented a session on SQL Server 2000 at TechEd 2000 Europe, and has accepted to speak at PASS2001, TechEd Europe 2001, VBUG 2001, VBITS 2001, VSLive, and SQL2THEMAX conferences during the year 2001.

He is a Civil and Hydrologic Engineer with almost 20 years' experience in software development and design, in many casesapplied to engineering environments.

He holds seven Microsoft Professional Certifications, including MCSE+Internet, MCSD, MCDBA, MCT, and has been awarded with the MVP (Most Valuable Professional) status on SQL Server. He is also a voting member and volunteer of PASS, the professional association for SQL Server.

His professional experience covers six years (1981-1987) as a lecturer in the Valencia's Polytechnic University (Spain), where he was lecturing on surveying, photogrammetry, technical drawing, and applied numerical methods in the Civil Engineering School and the Agricultural Engineering School. He built his own software company in Spain, TOU S.A., focused on desktop publishing and graphical tools for the professional market, and was technical director in that company for four years (1987-1991).