0789724499,Microsoft SQL Server 2000 Programming by Example with CDROM,Microsoft,SQL,Server,2000,Programming,by,Example,with,CDROM,buy,book,books,purchase,read,Fernando Guerrero,Carlos Eduardo Rojas
Books
Books
Sign In | View Cart Cart | Wish List | Help
ToysHealthPersonalAdultBaby
ToysHealthPersonalAdultBaby
Home & Garden
Checkout Now »
Cart Cart Cart
0 Items
Cart
100% Safe and Private!
Search     for:    

Books
Browse All Topics    New Releases    Coming Soon

All Topics > Computers & Internet > Microsoft > Development > SQL Server
 
Browse similar subjects

Shipping

All orders
shipped by
airmail!

Click here for our
Shipping Policies!

 


Quotations

"He can compress the most words into the smallest ideas of any man I ever met."

  - Abraham Lincoln

(1809 - 1865)

 

 

Microsoft SQL Server 2000 Programming by Example with CDROM

 
  by Fernando Guerrero, Carlos Eduardo Rojas
 
 
 Take A Trip Around The Word
Take A Trip Around The Word
Product
Take A Trip Around The Word
Take A Trip Around The Word
Take A Trip Around The Word
  
  
  
Take A Trip Around The Word
Take A Trip Around The Word 


ZIN Product Number: 10265059

 
eBay (last 12 months)
Auctions: 78
Price Range: $0.04 - 0.09
 
Craigslist (last 12 months)
Classifieds: 20
Price Range: $0.04 - 0.09
 
Amazon Used (last 12 months)
Auctions: 90
Price Range: $0.09 - 0.04
 
ZooScape (last 12 months)
Auctions: 0
Price Range: N/A
 
 
Google listings (non-affiliate) 128
MSN listings (non-affiliate) 46
Yahoo listings (non-affiliate) 40
 


 FastFind Line
Inverse Black Hole
By the Numbers
By the Numbers
Cover To Cover
Cover to Cover
Reader's Corner
Reader's Corner
Behind the Pen
Behind the Pen
Table of Contents
Table of Contents
Related Reading
Related Reading
Inverse Black Hole
FastFind Line
 
 
By The Numbers
 Product Details

  Format: Paperback, 792 pages
  Edition: BK&CD-ROM
  Publisher: Que
  ISBN: 0789724499
  Release Date: Jan 4, 2001


 
 
Cover to Cover
 In Brief
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)

 
 
 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.

 
 
The Reader's Corner
  Product Review
 
 Be the first to rate this book!     Number of Reviews: 0
 
 
 
Behind the Pen
 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).

Before joining QA (Nov. 1998), he spent eight years (1991-1998) as an international consultant for a prestigious Spanish engineering firm ( 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.



 
 
Table of Contents
 
Introduction1
1Relational Database Management Systems and SQL Server7
2Elements of Transact-SQL59
3Working with Tables and Views91
4Querying and Modifying Data121
5Querying Multiple Tables: JOINs159
6Optimizing Access to Data: Indexes187
7Enforcing Data Integrity239
8Implementing Business Logic: Programming Stored Procedures295
9Implementing Complex Processing Logic: Programming Triggers329
10Enhancing Business Logic: User-Defined Functions (UDF)389
11Using Complex Queries and Statements463
12Row-Oriented Processing: Using Cursors507
13Maintaining Data Consistency: Transactions and Locks553
14Transferring Data to and from SQL Server617
15Working with Heterogeneous Environments: Setting Up Linked Servers665
AUsing SQL Server Instances703
BUsing SQL Query Analyzer721
Index749


 
 
Related Reading
 Find similiar books in these subject areas:

All Topics > Computers & Internet > Microsoft > Development > SQL Server
All Topics > Computers & Internet > Databases > Database Management Systems
All Topics > Computers & Internet > Databases > Specific Databases > SQL > General
All Topics > Computers & Internet > Databases > General
All Topics > Computers & Internet > General


 
 
 People like you also bought:

SQL Server 2000 Developer's Guide, by Michael Otey

Sams Teach Yourself Microsoft SQL Server 2000 in 21 Days with CDROM, by Richard Waymire

Microsoft SQL Server 2000 DBA Survival Guide with CDROM, by Mark Spenik

Professional SQL Server 2000 XML, by Paul J. Burke

The Guru's Guide to Transact-SQL, by Ken Henderson

Professional SQL Server 2000 Programming, by Robert Vieira

Microsoft SQL Server 2000unleashed, by Ray Rankins

Admin911: SQL Server 2000, by Brian Knight

 
 
 Keywords
Relational databases, Client/server computing, Computer Books: General, Relational Databases, Sql (Programming Language), Programming Languages - SQL, Computer Bks - Data Base Management, Computers, Database Management - SQL Server, Database Management - General

 
 
 FastFind Line
Inverse Black Hole
By the Numbers
By the Numbers
Cover To Cover
Cover to Cover
Reader's Corner
Reader's Corner
Behind the Pen
Behind the Pen
Table of Contents
Table of Contents
Related Reading
Related Reading
Inverse Black Hole
FastFind Line
 
 


Make $1 per sale -
Link to ZooScape.com!


About Us   |   Our Policies   |   Your Cart   |   Contact Us   |   Help
ZooScape.com

Copyright 1995 - 2009 - ZooScape.com
 
ZooScape.com