作者：Sikha Bagui, Richard Earp
出版日期：April 26, 2006
出版社：O'Reilly
页数：342
ISBN：ISBN-10: 0596102151 ISBN-13: 978-0596102159
文件格式：CHM


Product 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, thedramatic rise in the popularity of relational databases and multi-userdatabases has fueled a healthy demand for application developers andothers who can write SQL code efficiently and correctly.If you’re newto databases, or need a SQL refresher, “Learning SQL on SQL Server2005″ is an ideal step-by-step introduction to this database querytool, with everything you need for programming SQL using Microsoft’sSQL Server 2005-one of the most powerful and popular database enginesused today. Plenty of books explain database theory. This guide letsyou apply the theory as you learn SQL. You don’t need prior databaseknowledge, or even prior computer knowledge.Based on a popular university-level course designed by authorsSikha Saha Bagui and Richard Walsh Earp, “Learning SQL on SQL Server2005″ starts with very simple SQL concepts, and slowly builds into morecomplex query development. Every topic, concept, and idea comes withexamples of code and output, along with exercises to help you gainproficiency 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 correlatedsubqueries, as well asindexes and constraints that can be added to tables in SQL Server 2005
Whether you’re an undergraduate computer science or MIS student, aself-learner who has access to the new Microsoft database, or work foryour company’s IT department, “Learning SQL on SQL Server 2005″ willget you up to speed on SQL in no time.
About the Author
Dr. Sikha Bagui is an Assistant Professor in the Computer ScienceDepartment at the University of West Florida in Pensacola. She andRichard Walsh Earp have teamed up to write “Learning SQL: AStep-By-Step Guide using Oracle” and “Learning SQL: A Step-By-StepGuide using Access” for Addison-Wesley, and “Conceptual Database DesignUsing ER Diagrams” for CRC Press. Dr. Bagui and Richard Earp have alsocollaborated on several articles for academic journals in their field,and have designed an introductory database course.