Essential SQL on SQL Server 2008
By: Bagui, Dr. Sikha
.
Contributor(s): Earp, Dr. Richa.
Material type: 
BookPublisher: USA : Jones & Bartlett Learning, 2009Edition: 1st ed.Description: 394 p.ISBN: 076378138X (paperback); 9780763781385 (paperback).Subject(s): Computer Science, SQL Server 2008 Computer softwareDDC classification: 005.7585 Bagui 24586 1/e 2010 Computer.Science Summary: 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 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 book 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 processi
| Item type | Current location | Collection | Call number | Status | Date due | Barcode | Item holds |
|---|---|---|---|---|---|---|---|
Books
|
UVAS Library Computer Science | Social Science | 005.7585 Bagui 24586 1/e 2010 Computer.Science (Browse shelf) | Available | 24586 |
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 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 book 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 processi
There are no comments for this item.