Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Beginning Microsoft SQL Server 2012 Programming [[electronic resource]]
| Beginning Microsoft SQL Server 2012 Programming [[electronic resource]] |
| Autore | Atkinson Paul (Software engineer) |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | New York, : Wiley, 2012 |
| Descrizione fisica | 1 online resource (866 p.) |
| Disciplina |
004.36
005.7585 |
| Altri autori (Persone) | VieiraRobert |
| Soggetto topico |
Client/server computing
Database management Relational databases SQL server Engineering & Applied Sciences Computer Science |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-283-94101-5
1-118-22388-8 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Beginning: Microsoft® SQL Server® 2012 Programming; Credits; About The Authors; About The Technical Editor; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need To Use This Book; Conventions; Source Code; Errata; P2P.wrox.com; Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?; An Overview of Database Objects; The Database Object; The Transaction Log; The Most Basic Database Object: Table; Filegroups; Diagrams; Views; Stored Procedures; User-Defined Functions; Sequences; Users and Roles; Rules; Defaults
User-Defined Data TypesFull-Text Catalogs; SQL Server Data Types; NULL Data; SQL Server Identifiers for Objects; What Gets Named?; Rules for Naming; Summary; Chapter 2: Learning the Tools of the Trade; Getting Help with Books Online; SQL Server Configuration Manager; Service Management; Network Configuration; The Protocols; On to the Client; SQL Server Management Studio; Getting Started with the Management Studio; Interacting Through the Query Window; SQL Server Data Tools (formerly BIDS); SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS) SQL Server Analysis Services (SSAS)Bulk Copy Program (BCP); SQL Server Profiler; sqlcmd; PowerShell; Summary; Chapter 3: The Foundation Statements of T-SQL; Getting Started with a Basic SELECT Statement; The SELECT Statement and FROM Clause; The WHERE Clause; ORDER BY; Aggregating Data Using the GROUP BY Clause; Placing Conditions on Groups with the HAVING Clause; Outputting XML Using the FOR XML Clause; Making Use of Hints Using the OPTION Clause; The DISTINCT and ALL Predicates; Adding Data with the INSERT Statement; Multirow Inserts; The INSERT INTO . . . SELECT Statement Changing What You've Got with the UPDATE StatementThe DELETE Statement; Summary; Chapter 4: Joins; Combining Table Data with JOINs; Selecting Matching Rows with INNER JOIN; How an INNER JOIN Is Like a WHERE Clause; Retrieving More Data with OUTER JOIN; The Simple OUTER JOIN; Dealing with More Complex OUTER JOINs; Seeing Both Sides with FULL JOINs; Understanding CROSS JOINs; Exploring Alternative Syntax for Joins; An Alternative INNER JOIN; An Alternative OUTER JOIN; An Alternative CROSS JOIN; Stacking Results with UNION; Summary; Chapter 5: Creating and Altering Tables Object Names in SQL ServerSchema Name (aka Ownership); The Database Name; Naming by Server; Reviewing the Defaults; The CREATE Statement; CREATE DATABASE; Building a Database; CREATE TABLE; The ALTER Statement; ALTER DATABASE; ALTER TABLE; The DROP Statement; Using the GUI Tool; Creating a Database Using the Management Studio; Backing into the Code: Creating Scripts with the Management Studio; Summary; Chapter 6: Keys and Constraints; Types of Constraints; Domain Constraints; Entity Constraints; Referential Integrity Constraints; Constraint Naming; Key Constraints; Primary Key Constraints Foreign Key Constraints |
| Record Nr. | UNINA-9910461589803321 |
Atkinson Paul (Software engineer)
|
||
| New York, : Wiley, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Beginning Microsoft SQL Server 2012 Programming [[electronic resource]]
| Beginning Microsoft SQL Server 2012 Programming [[electronic resource]] |
| Autore | Atkinson Paul (Software engineer) |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | New York, : Wiley, 2012 |
| Descrizione fisica | 1 online resource (866 p.) |
| Disciplina |
004.36
005.7585 |
| Altri autori (Persone) | VieiraRobert |
| Soggetto topico |
Client/server computing
Database management Relational databases SQL server Engineering & Applied Sciences Computer Science |
| ISBN |
1-283-94101-5
1-118-22388-8 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Beginning: Microsoft® SQL Server® 2012 Programming; Credits; About The Authors; About The Technical Editor; Acknowledgments; Contents; Introduction; Who This Book Is For; What This Book Covers; How This Book Is Structured; What You Need To Use This Book; Conventions; Source Code; Errata; P2P.wrox.com; Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?; An Overview of Database Objects; The Database Object; The Transaction Log; The Most Basic Database Object: Table; Filegroups; Diagrams; Views; Stored Procedures; User-Defined Functions; Sequences; Users and Roles; Rules; Defaults
User-Defined Data TypesFull-Text Catalogs; SQL Server Data Types; NULL Data; SQL Server Identifiers for Objects; What Gets Named?; Rules for Naming; Summary; Chapter 2: Learning the Tools of the Trade; Getting Help with Books Online; SQL Server Configuration Manager; Service Management; Network Configuration; The Protocols; On to the Client; SQL Server Management Studio; Getting Started with the Management Studio; Interacting Through the Query Window; SQL Server Data Tools (formerly BIDS); SQL Server Integration Services (SSIS); SQL Server Reporting Services (SSRS) SQL Server Analysis Services (SSAS)Bulk Copy Program (BCP); SQL Server Profiler; sqlcmd; PowerShell; Summary; Chapter 3: The Foundation Statements of T-SQL; Getting Started with a Basic SELECT Statement; The SELECT Statement and FROM Clause; The WHERE Clause; ORDER BY; Aggregating Data Using the GROUP BY Clause; Placing Conditions on Groups with the HAVING Clause; Outputting XML Using the FOR XML Clause; Making Use of Hints Using the OPTION Clause; The DISTINCT and ALL Predicates; Adding Data with the INSERT Statement; Multirow Inserts; The INSERT INTO . . . SELECT Statement Changing What You've Got with the UPDATE StatementThe DELETE Statement; Summary; Chapter 4: Joins; Combining Table Data with JOINs; Selecting Matching Rows with INNER JOIN; How an INNER JOIN Is Like a WHERE Clause; Retrieving More Data with OUTER JOIN; The Simple OUTER JOIN; Dealing with More Complex OUTER JOINs; Seeing Both Sides with FULL JOINs; Understanding CROSS JOINs; Exploring Alternative Syntax for Joins; An Alternative INNER JOIN; An Alternative OUTER JOIN; An Alternative CROSS JOIN; Stacking Results with UNION; Summary; Chapter 5: Creating and Altering Tables Object Names in SQL ServerSchema Name (aka Ownership); The Database Name; Naming by Server; Reviewing the Defaults; The CREATE Statement; CREATE DATABASE; Building a Database; CREATE TABLE; The ALTER Statement; ALTER DATABASE; ALTER TABLE; The DROP Statement; Using the GUI Tool; Creating a Database Using the Management Studio; Backing into the Code: Creating Scripts with the Management Studio; Summary; Chapter 6: Keys and Constraints; Types of Constraints; Domain Constraints; Entity Constraints; Referential Integrity Constraints; Constraint Naming; Key Constraints; Primary Key Constraints Foreign Key Constraints |
| Record Nr. | UNINA-9910790275803321 |
|
Atkinson Paul (Software engineer)
|
||
| New York, : Wiley, 2012 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||