If you're new to the database, or need a SQL refresher, Learning SQL on SQL Server 2005 is the ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft SQL Server 2005 database engine-one of the most powerful and popular use today. You do not need prior database knowledge, or even prior computer knowledge. Based on the popular level university courses are designed by authors Sikha Saha Bagui and Richard Walsh Earp, Learning SQL on SQL Server 2005 starts with very simple SQL concepts, and slowly build into a more complex query development. With this book you will learn: Beginning SQL commands, such as how and where to type an SQL query, and how to create, fill, alter and delete tables How to adjust settings for SQL Server 2005 and about the functions of SQL Server 2005's About joins, a mechanism common database to combine tables Query development, 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 a table in SQL Server 2005 Are you an undergraduate computer science or MIS student, student-self who have access to new Microsoft database, or working for your company's IT department, Learning SQL on SQL Server 2005 will keep you up to speed on SQL in no time.