Learning SQL on SQL server 2005
<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 data...
| Otros Autores: | , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Beijing, [China] :
O'Reilly Media
2010.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627230706719 |
Tabla de Contenidos:
- 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
