Microsoft SQL Server 2000 Programming by Example (Paperback) ~ C... Cover Art

Microsoft SQL Server 2000 Programming by Example (Paperback)

By: Carlos Eduardo Rojas (Author) and Fernando G. Guerrero (Author)


List Price: $59.99
Current Price: $53.99
You Save: $6.00 (10%)
Download eBook

Search Inside


Also available from:

Provider Name Price From Rent
1   Skyo $10.96 Rent

Provider Name Price From Condition Buy
1   Alibris $35.33 New Buy
2   Biblio $45.98 New Buy
3   Informit $47.99 New Buy
 
4   Biblio $1.00 Used Buy

Ebook Download

  • Editions available from:

Product Description


Run a Quick Search on "Microsoft SQL Server 2000 Programming by Example" by Carlos Eduardo Rojas and Fernando G. Guerrero to Browse Related Products:

Browse more products related to "Microsoft SQL Server 2000 Programming by Example"

Browse more products related to "Carlos Eduardo Rojas and Fernando G. Guerrero"


Product note

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

Short Desription

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.


If You Enjoy "Microsoft SQL Server 2000 Programming by Example (Paperback)", May We Also Recommend:

 [Microsoft SQL Server 2000 DBA Survival Guide (2nd Edition) (Pape... Cover Art
Microsoft SQL Server 2000 DBA Survival Guide (2nd Edition) (Paperback) ~ Mark Spenik (Author) and Orryn...
 ]
 [GSEC GIAC Security Essential Certification Exam Preparation Cour... Cover Art
GSEC GIAC Security Essential Certification Exam Preparation Course in a Book for Passing the GSEC Certified Exam - The How To Pass on Your First Try Certification Study Guide (Paperback) ~ William Manning (Author)
 ]
 [Professional SQL Server 2000 DTS (Data Transformation Services) ... Cover Art
Professional SQL Server 2000 DTS (Data Transformation Services) (Programmer to Programmer) (Paperback) ~ Mark Chaffin (Author)
 ]
 [A Developer's Guide to SQL Server 2005 (Paperback) ~ Bob Beauche... Cover Art
A Developer's Guide to SQL Server 2005 (Paperback) ~ Bob Beauchemin (Author) and Da...
 ]
 [SQL Server 2005 Reporting Services in Action: Revised edition of... Cover Art
SQL Server 2005 Reporting Services in Action: Revised edition of Microsoft Reporting Services in Action (Paperback) ~ Teo Lachev (Author)
 ]
 [Handbook on Ontologies (International Handbooks on Information S... Cover Art
Handbook on Ontologies (International Handbooks on Information Systems) (Hardcover) ~ Steffen Staab (Author) and Rud...
 ]
 [SCJP Sun Certified Programmer for Java 6 Exam 310-065 Certificat... Cover Art
SCJP Sun Certified Programmer for Java 6 Exam 310-065 Certification Exam Preparation Course in a Book for Passing the SCJP Sun Certified Programmer for ... on Your First Try Certification Study Guide (Paperback) ~ William Manning (Author)
 ]
 [Sams Teach Yourself Mysql in 21 Days (Paperback) ~ Tony Butcher ... Cover Art
Sams Teach Yourself Mysql in 21 Days (Paperback) ~ Tony Butcher (Author)
 ]
 [CCIE Cisco Certified Internetwork Expert Wireless Certification ... Cover Art
CCIE Cisco Certified Internetwork Expert Wireless Certification Exam Preparation Course in a Book for Passing the CCIE Exam - The How to Pass on Your (Paperback) ~ William Manning (Author)
 ]
 [MCDST Microsoft Certified Desktop Support Technician Certificati... Cover Art
MCDST Microsoft Certified Desktop Support Technician Certification Exam Preparation Course in a Book for Passing the MCDST Microsoft Certified Desktop ... on Your First Try Certification Study Guide (Paperback) ~ William Manning (Author)
 ]

Customer Reviews for "Microsoft SQL Server 2000 Programming by Example (Paperback)" by Carlos Eduardo Rojas (Author) ...

There are no customer reviews yet. Be the first to write a review!

Submit your Review




Explore More Great Tower Sales & Specials



Tower.com Sales, Promotions & Special Features

Tower.com Sales & Boutiques

  • Tower Essentials Sale
    Visit the Essentials Sale for a wide selection and huge savings on your favorite music, DVD, Blu-ray and Books.
  • Great Gift Ideas
    Tower has Great Gift Ideas and Huge Savings on Your Favorite Music, CDs, DVDs, Books and More at Prices that Make Giving A Breeze!

Interact with Tower.com