The Fictioning Horror Sale
 
 

Recently Viewed clear list


Original Essays | September 18, 2014

Lin Enger: IMG Knowing vs. Knowing



On a hot July evening years ago, my Toyota Tercel overheated on a flat stretch of highway north of Cedar Rapids, Iowa. A steam geyser shot up from... Continue »
  1. $17.47 Sale Hardcover add to wish list

    The High Divide

    Lin Enger 9781616203757

spacer
Qualifying orders ship free.
$32.00
Used Trade Paper
Ships in 1 to 3 days
Add to Wishlist
Qty Store Section
1 Beaverton Database- SQL

More copies of this ISBN

Learning SQL on SQL Server 2005:

by

Learning SQL on SQL Server 2005: Cover

 

Synopses & Reviews

Publisher Comments:

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, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly.

If you're new to databases, or need a SQL refresher, Learning SQL on SQL Server 2005 is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft's SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge.

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

Whether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company's IT department, Learning SQL on SQL Server 2005 will get you up to speed on SQL in no time.

Book News Annotation:

Bagui (University of West Florida, Pensacola) introduces basic SQL commands in Microsoft's SQL Server 2005 database engine, the creation of database tables, the insertion of values, joins for combining tables, functions, query development, views, and simple set operations. The textbook then moves on to subqueries, aggregate functions, correlated subqueries, indexes, and constraints.
Annotation 2006 Book News, Inc., Portland, OR (booknews.com)

Book News Annotation:

Bagui (University of West Florida, Pensacola) introduces basic SQL commands in Microsoft's SQL Server 2005 database engine, the creation of database tables, the insertion of values, joins for combining tables, functions, query development, views, and simple set operations. The textbook then moves on to subqueries, aggregate functions, correlated subqueries, indexes, and constraints. Annotation ©2006 Book News, Inc., Portland, OR (booknews.com)

Synopsis:

Anyone who needs to interact with today's modern databases needs to know SQL (Structured Query Language), the standard programming language for generating, manipulating, and retrieving information from a relational database. "Learning SQL on SQL Server 2005" offers a complete introduction to the language for those of you who need to learn Microsoft's SQL Server 2005. The book assumes no prior database knowledge, whether you work for your company's IT department, are an undergraduate computer science or MIS course student, or a self-learner who has access to the latest Microsoft database. "Learning SQL on SQL Server 2005" is based on the authors' introductory database course that uses SQL Server.

Synopsis:

Earp and Bagui offer a complete introduction to SQL (Structure Query Language), the standard programming language for generating, manipulating, and retrieving information from a relational database, for those who need to learn Microsoft's SQL Server 2005.

About the Author

Dr. Sikha Bagui is an Assistant Professor in the Computer Science Department at the University of West Florida in Pensacola. She and Richard Walsh Earp have teamed up to write "Learning SQL: A Step-By-Step Guide using Oracle" and "Learning SQL: A Step-By-Step Guide using Access" for Addison-Wesley, and "Conceptual Database Design Using ER Diagrams" for CRC Press. Dr. Bagui and Richard Earp have also collaborated on several articles for academic journals in their field, and have designed an introductory database course.

Table of Contents

DedicationPrefaceChapter 1: Starting Microsoft SQL Server 2005Chapter 2: Beginning SQL Commands in SQL ServerChapter 3: Creating, Populating, Altering, and Deleting TablesChapter 4: JoinsChapter 5: FunctionsChapter 6: Query Development and Derived StructuresChapter 7: Set OperationsChapter 8: Joins Versus SubqueriesChapter 9: Aggregation and GROUP BYChapter 10: Correlated SubqueriesChapter 11: Indexes and Constraints on TablesThe Student Database and Other Tables Used in This BookScript Used to Create the Student_course DatabaseGlossary of TermsImportant Commands and FunctionsColophon

Product Details

ISBN:
9780596102159
Author:
Bagui, Sikha Saha
Publisher:
O'Reilly Media
Author:
Earp, Richard
Author:
Bagui, Sikha
Author:
Earp, Richard Walsh
Subject:
Programming Languages - SQL
Subject:
Database management
Subject:
Database Management - SQL Server
Subject:
Sql (computer program language)
Subject:
Database design
Subject:
Data Processing - General
Subject:
Database Management - Database Mining
Subject:
Microsoft SQL Server;SQL;SQL Server;SQL Server book;SQL book;TSQL;Transact SQL
Subject:
CourseSmart Subject Description
Copyright:
Edition Description:
Print PDF
Publication Date:
20060506
Binding:
Paperback
Language:
English
Illustrations:
Y
Pages:
352
Dimensions:
9.19 x 7 x 0.8 in 1.25 lb

Other books you might like

  1. Microsoft SQL Server(tm) 2005... Used Trade Paper $18.95
  2. Teach Yourself Microsoft SQL Server... Used Trade Paper $21.00
  3. Programming SQL Server 2005 New Trade Paper $54.99
  4. Microsoft SQL Server(tm) 2005... Used Trade Paper $16.95
  5. Microsoft SQL Server(tm) 2005... Used Trade Paper $3.98
  6. Inside Microsoft SQL Server 2005:... Used Trade Paper $22.00

Related Subjects

Computers and Internet » Database » Applications
Computers and Internet » Database » SQL

Learning SQL on SQL Server 2005: Used Trade Paper
0 stars - 0 reviews
$32.00 In Stock
Product details 352 pages O'Reilly Media - English 9780596102159 Reviews:
"Synopsis" by , Anyone who needs to interact with today's modern databases needs to know SQL (Structured Query Language), the standard programming language for generating, manipulating, and retrieving information from a relational database. "Learning SQL on SQL Server 2005" offers a complete introduction to the language for those of you who need to learn Microsoft's SQL Server 2005. The book assumes no prior database knowledge, whether you work for your company's IT department, are an undergraduate computer science or MIS course student, or a self-learner who has access to the latest Microsoft database. "Learning SQL on SQL Server 2005" is based on the authors' introductory database course that uses SQL Server.
"Synopsis" by ,
Earp and Bagui offer a complete introduction to SQL (Structure Query Language), the standard programming language for generating, manipulating, and retrieving information from a relational database, for those who need to learn Microsoft's SQL Server 2005.
spacer
spacer
  • back to top
Follow us on...




Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.