Learning SQL on SQL Server 2005


Publisher: O'Reilly
Author: Richard Earp
ISBN: 0596102151
Release Date: 01 April 2006

eBook Description
Anyone who interacts with today's modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly.

If you're new to databases, or need a SQL refresher, Learning SQL on SQL Server 2005 is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge.

Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, Learning SQL on SQL Server 2005 starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn:

  • Beginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tables
  • How to customize SQL Server 2005's settings and about SQL Server 2005's functions
  • About joins, a common database mechanism for combining tables
  • Query development, the use of views and other derived structures, and simple set operations
  • Subqueries, aggregate functions and correlated subqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005

Whether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company's IT department, Learning SQL on SQL Server 2005 will get you up to speed on SQL in no time.

Amazon.com

Learning SQL on SQL Server 2005

Related posts:

  1. Microsoft SQL Server 2005 Analysis Services (SQL Server Series) Publisher: SamsAuthor: ArrayISBN: 0672327821Release Date: 25 December 2006 eBook Description...
  2. Learning Windows Server 2003, Second Edition Publisher: O'ReillyAuthor: Jonathan HassellISBN: 0596101236Release Date: 01 February 2006 eBook...
  3. Microsoft SQL Server(TM) 2005: Database Essentials Step by Step (Step By Step (Microsoft)) Publisher: Microsoft PressAuthor: Solid Quality LearningISBN: 0735622078Release Date: 13 September...
  4. Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning) Publisher: Microsoft PressAuthor: Dejan SarkaISBN: 0735623139Release Date: 26 April 2006...
  5. Programming Microsoft SQL Server 2000 With XML (Pro-Developer) Publisher: Microsoft PressAuthor: Graeme MalcolmISBN: 0735613699Release Date: 30 June 2001...
  6. Learning Exchange Server 2003 Publisher: Addison-WesleyAuthor: William BoswellISBN: 032122874XRelease Date: 20 September 2004 eBook...
  7. Learning PHP & MySQL: Step-by-Step Guide to Creating Database-Driven Web Sites Publisher: O'ReillyAuthor: Jon PhillipsISBN: 0596514018Release Date: 21 August 2007 eBook...
  8. Learning PHP Data Objects Publisher: Packt PublishingAuthor: Dennis PoppelISBN: 1847192661Release Date: 01 August 2007...
  9. Learning PHP and MySQL Publisher: O'ReillyAuthor: Jon PhillipsISBN: 0596101104Release Date: 01 June 2006 eBook...
  10. Inside Microsoft® SQL Server(TM) 2005: Query Tuning and Optimization Publisher: Microsoft PressAuthor: Adam MachanicISBN: 0735621969Release Date: 26 September 2007...

Post a Comment | Trackback URI