Learning SQL on SQL server 2005 / Sikha Saha Bagui and Richard Walsh Earp.

Format:

Book

Author/Creator:

Bagui, Sikha, 1964- author.

Earp, Richard, 1940- author.

Language:

English

Subjects (All):

SQL server.

SQL (Computer program language).

Database design.

Database management.

Physical Description:

1 online resource (672 p.)

Edition:

1st edition

Place of Publication:

Beijing, [China] : O'Reilly Media, 2010.

Language Note:

English

System Details:

text file

Summary:

<div> 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, <i>Learning SQL on SQL Server 2005</i> is an ideal step-by-step introduction to this database query tool, with everything you need for

Contents:

Learning SQL on SQL Server 2005; Preface; Why This Book?; SQL and SQL Server; Audience and Coverage; A Few Notes About SQL Server 2005 Installation; Conventions Used in This Book; Using Code Examples; How to Contact Us; Acknowledgments; 1. Starting Microsoft SQL Server 2005; Starting Microsoft SQL Server 2005 and SQL Server 2005's Management Studio; Creating a Database in Microsoft SQL Server 2005; Objects in the Student_course Database; Default Tables in the Student_course Database; Default System Databases; The Query Editor; Opening the Query Editor by Right-Clicking

Opening the Query Editor Using the New Query ButtonOpening or Activating the Database Using USE; Creating Tables Using the Load Script; Viewing Table Definitions; Modifying Table Definitions; Modifying Column Definitions; Modifying the Table Definition Directly; Viewing Table Data; Deleting a Table; Deleting a Database; Entering a SQL Query or Statement; Parsing a Query; Executing a Query; Color Coding; Saving a Query; Displaying the Results; Viewing Results in Grid Form; Viewing Results in Text Form; Saving Results to File; Stopping Execution of a Long Query; Viewing Error Messages

Printing the Query and ResultsCustomizing SQL Server 2005; The Environment tab; The Source Control Tab; The Text Editor Tab; The Query Execution Tab; The Query Results Tab; The Designer Tab; Summary; Review Questions; Exercises; 2. Beginning SQL Commands in SQL Server; Displaying Data with the SELECT Statement; SELECT without the FROM; Displaying or Selecting Columns from a Table; Displaying or SELECTing One Column from a Table; Displaying or SELECTing More than One Column from a Table; Displaying or SELECTing All Columns of a Table; ORDER BY; ORDER BY and NULLs

Ascending and Descending OrderOrdering Within an Order; Displaying or SELECTing Rows or Tuples from a Table; Filtering with WHERE; The AND Operator; The OR Operator; The BETWEEN Operator; Negating the BETWEEN Operator; The COUNT Function; IS NULL; IS NOT NULL; The ROWCOUNT Function; Using Aliases; Column Aliases; Table Aliases; Table Aliases Used as Table Qualifiers; Synonyms; Adding Comments to SQL Statements; Some Conventions for Writing SQL Statements; A Few Notes About SQL Server 2005 Syntax; Summary; Review Questions; Exercises; 3. Creating, Populating, Altering, and Deleting Tables

Data Types in SQL Server 2005Numeric Data Types; Integer data types; Decimal data types; Character Data Types; The CHAR data type; The VARCHAR data type; The TEXT data type; The NCHAR data type; The NVARCHAR data type; Unicode character strings; Selecting the character data types; Date and Time Data Types; Miscellaneous Data Types; The BINARY data type; The IMAGE data type; The BIT data type; The monetary data types; The TABLE data type; The SQL_VARIANT data type; The UNIQUEIDENTIFIER data type; The XML data type; Selecting Data Types; Creating a Table; Inserting Values into a Table

Using INSERT INTO .. VALUES

Notes:

Includes index.

Description based on print version record.

ISBN:

9781449390891

1449390897

OCLC:

68941023