Learning SQL on SQL Server 2005

Learning SQL on SQL Server 2005
ISBN-10
1449390897
ISBN-13
9781449390891
Category
Computers
Pages
352
Language
English
Published
2006-04-26
Publisher
"O'Reilly Media, Inc."
Authors
Sikha Saha Bagui, Richard Walsh Earp

Description

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.

Get the book

Amazon.com
Amazon.com
Search the book
eBay.com
eBay.com
Search the book

Other editions

Similar books

  • Beginning T-SQL with Microsoft SQL Server 2005 and 2008
    Beginning T-SQL with Microsoft SQL Server 2005 and 2008
    By Paul Turley, Dan Wood

    ... varchar(25) NULL ,FirstName varchar(25) NULL ,Position varchar(25)NULL); INSERT SlateGravel VALUES ('Flintstone', ... is stored in a casesensitive collation searching for “flint%” will not return strings beginning with “Flint.

  • Essential SQL on SQL Server 2008
    Essential SQL on SQL Server 2008
    By Sikha Bagui, Richard Earp

    This book provides readers with a very systematic approach to learning SQL using SQL Server.

  • Programming SQL Server 2005: Prepare for Deeper SQL Server Waters
    Programming SQL Server 2005: Prepare for Deeper SQL Server Waters
    By Bill Hamilton

    The book can be used as a primer by developers with little experience with SQL Server, as a ramp up to the new programming models for SQL Server 2005 for more experienced programmers, or as background and primer to specific concepts.

  • A Developer's Guide to SQL Server 2005
    A Developer's Guide to SQL Server 2005
    By Bob Beauchemin, Dan Sullivan

    "I come from a T-SQL background, so when I first laid my eyes on SQL Server 2005, I was shocked--and then, I was scared! I didn't have a CLR or...

  • Beginning SQL Server 2005 Administration
    Beginning SQL Server 2005 Administration
    By Paul Turley, Chris Leiter, Dan Wood

    SQL Server Integration Services (SSIS) is Microsoft's new enterprise class data Extract, Transform, and Load (ETL) tool. SSIS is a completely new product built from the ashes of SQL Server 2000's Data Transformation Services (DTS).

  • Professional Microsoft SQL Server 2008 Programming
    Professional Microsoft SQL Server 2008 Programming
    By Robert Vieira

    This book assumes that you have some experience with SQL Server and are at an intermediate to advanced level. The orientation of the book is highly developer focused.

  • Learn SQL Server Administration in a Month of Lunches
    Learn SQL Server Administration in a Month of Lunches
    By Don Jones

    Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the Book Microsoft SQL Server is used by millions of businesses, ranging in size from Fortune 500s to small shops worldwide.

  • Beginning Transact-SQL with SQL Server 2000 and 2005
    Beginning Transact-SQL with SQL Server 2000 and 2005
    By Paul Turley

    This book provides you with a comprehensive introduction to the T-SQL language and shows you how it can be used to work with both the SQL Server 2000 and 2005 releases.

  • Mastering Microsoft SQL Server 2005
    Mastering Microsoft SQL Server 2005
    By Mike Gunderloy, Joseph L. Jorden, David W. Tschanz

    ... EXEC sp_addumpdevice 'disk', 'Test_Backup', 'c:\Test_Backup.dat' BACKUP DATABASE TEST TO Test_Backup Ira-mama . '"li 3w Q ---~ I filo» 3mm 9mm Duh-Isl In' IMWITGIJ _ 'Eva —W i i _ we .9; : - 'Bi: “'1 in on' (W 'Mnngms'wnm cum 0.

  • SQL Server 2005 Bible
    SQL Server 2005 Bible
    By Paul Nielsen

    The following code from the CHA2_Convert.sql script links to the CHA1_Customers.mdb Access database so SQL Server can retrieve the data and populate the SQL Server tables: EXEC sp_addlinkedserver 'CHA1_Customers', 'Access 2003', ...