Home  |  My Account  |  Shopping Cart (0 items)   
   
Login/Signup  |  Help  |  Contact Us  
Search for Books:       Advanced Search
Advance Search Cancel
Title : Author :
From Date To Date
Publisher : ISBN Number :
Category : Price : From To

Learning SQL on SQL Server 2005-Richard Earp, Sikha Bagui
Learning SQL on SQL Server 2005  Review
by Richard Earp, Sikha Bagui (Author)
Customer Reviews (0) | Write a Review
Publisher : Oreilly
Publish date : 26-Apr-2006
Category : SQL
Mediatype : Books
Binding : Paperback
Availability : InStock, Order now ships within 2-3 business days
List Price :   Rs. 599
Greenleaf Price :  Rs. 599
You Save :  Rs. 0
ISBN : 9780596102159 / Indian ISBN 13: 9788181283733
Pages : 342
Book is out of stock !
Book Summary : Learning SQL on SQL Server 2005
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.

About the Author
Dr. Sikha Bagui is an Assistant Professor in the Computer Science Department at the University of West Florida in Pensacola. She and Richard Walsh Earp have teamed up to write "Learning SQL: A Step-By-Step Guide using Oracle" and "Learning SQL: A Step-By-Step Guide using Access" for Addison-Wesley, and "Conceptual Database Design Using ER Diagrams" for CRC Press. Dr. Bagui and Richard Earp have also collaborated on several articles for academic journals in their field, and have designed an introductory database course.
Help
Contact Us
Payments
Shipping & Returns
Help & FAQ
Policies
Terms of Use
Security
Privacy
About Us
Blog
Careers
About us
Misc
Home
Affiliate
e-Gift Voucher
Book List
Author List
Search for Books :
© 2013 Greenleaf Bookshop. One Stop Shop for all your Books, Audio Books,CBT's, DVD's