Learning SQL on SQL Server 2005

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