Page Tools:

Essential SQL on SQL Server 2008

Author(s): Dr. Sikha Bagui, Associate Professor of Computer Science, University of West Florida
Dr. Richard Earp
Details:
  • ISBN-13: 9780763781385
  • Paperback    394 pages      © 2011
Price: $42.95 US List
Add to Cart

This book, written for readers who have little or no previous experience with databases, SQL, or SQL Server, provides a very systematic approach to learning SQL (Structured Query Language) using SQL Server. Each chapter is written in a step-by-step manner and has examples that can be run using SQL Server. Using the sample tables and data provided, the reader of this book will be able to do all the examples to experience hands-on SQL programming in SQL Server. The text also presents a series of exercises at the end of the chapters to help readers gain proficiency with SQL.

With this book you will learn: 

  • Beginning SQL commands – how to retrieve and manipulate data using the simple SELECT statement.
  • How to customize SQL Server 2008’s settings and about SQL Server 2008’s functions.
  • How to create, alter, populate and delete tables.
  • About joins, a common database mechanism for combining tables.
  • Query development, the use of views and other derived structures.
  • Simple set operations.
  • About aggregate functions.
  • How to write subqueries and correlated subqueries.
  • How to create and use indexes and constraints.
  • Transaction processing.

Features & Benefits

  • Starts with simple SQL concepts and progresses to more complex query development in SQL Server
  • Includes exercises at the end of every chapter to help readers practice and gain proficiency with SQL
  • Includes a glossary and index of important terms and functions
  • Presents examples of code that can be run using SQL Server and explains the SQL concepts from a problem solving perspective
     

Applicable Courses

Can serve as a stand-alone book for the study of SQL/SQL Server, or as a supplement to a database concepts textbook.

Appropriate for introductory database courses including Database Systems, Administering SQL Server Database, Database Concepts, SQL Server DBMS Administration and Database Design.

Chapter 1: Starting Microsoft SQL Server 2008
Chapter 2: Beginning SQL Commands in SQL Server
Chapter 3: Creating, Populating, Altering and Deleting Tables
Chapter 4: Joins
Chapter 5: Functions
Chapter 6: Query Development and Derived Structures
Chapter 7: Set Operations
Chapter 8: Joins versus Subqueries
Chapter 9: Aggregation and GROUP BY A SELECT in modified BNF
Chapter 10: Correlated Subqueries
Chapter 11: Indexes and Constraints on Tables
Appendix 1
Appendix 2
Glossary of Terms
Function Glossary
Index

Dr. Sikha Bagui-Associate Professor of Computer Science, University of West Florida

Dr. Sikha Saha Bagui is an associate professor in the Department of Computer Science at the University of West Florida. She teaches a variety of computer science and database courses, and her research areas of concentration are database design, web databases, data mining, and statistical computing. Dr. Bagui has published many journal articles and co-authored several books with Dr. Earp including Practical Guide to using SQL in Oracle.

Dr. Richard Earp

Dr. Richard Walsh Earp is a former chair of and former associate professor in the Department of Computer Science and former dean of the College of Science and Technology at the University of West Florida in Pensacola. Dr. Earp was also an instructor with Learning Tree International and worked for Computer Sciences Corporation at the Naval Air Station in Pensacola as a database consultant after his retirement from academia. He has co-authored several books with Dr. Bagui.

Additional Titles by this Author

The following instructor resources are available to qualified instructors for download

ISBN-13: 9780763781385

Answers to In-Text Questions