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.
Amazon SimpleDB developer guide [[electronic resource] ] : scale your application's database on the cloud using Amazon SimpleDB / / Prabhakar Chaganti, Rich Helms
| Amazon SimpleDB developer guide [[electronic resource] ] : scale your application's database on the cloud using Amazon SimpleDB / / Prabhakar Chaganti, Rich Helms |
| Autore | Chaganti Prabhakar |
| Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise, 2010 |
| Descrizione fisica | 1 online resource (252 p.) |
| Disciplina |
005.75
005.7585 |
| Altri autori (Persone) | HelmsRich |
| Soggetto topico |
Web services
Cloud computing Database management |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-282-62408-3
9786612624087 1-84719-735-3 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; Table of Contents; Preface; Chapter 1: Getting to Know SimpleDB; Experimenting with SimpleDB; How does SimpleDB work?; Domain; Item; Attributes; Values; How do I interact with SimpleDB?; How is SimpleDB priced?; Free tier; Why should I use SimpleDB?; Make your applications simpler to architect; Build flexibility into your applications; Create high-performance web applications; Take advantage of lower costs; Scale your applications on demand; Architect for the cloud; Summary; Chapter 2: Getting Started with SimpleDB
Creating an AWS accountEnabling SimpleDB service for AWS account; Query API and authentication; SimpleDB libraries; SDBtool - Firefox plugin; Sample outline - performing basic operations; Basic operations with Java; Exploring SimpleDB with Java; Creating a domain with Java; Listing domains with Java; Manipulating items with Java; Deleting a domain with Java; Basic operations with PHP; Exploring SimpleDB with PHP; Creating a domain with PHP; Listing domains with PHP; Manipulating items with PHP; Deleting a domain with PHP; Basic operations with Python; Introducing boto Exploring SimpleDB with PythonCreating a domain with Python; Retrieving a domain with Python; Creating items with Python; Summary; Chapter 3: SimpleDB versus RDBMS; No normalization; No joins; No schemas; Simpler SQL; Only strings; Eventual consistency; Flash: February 24, 2010-consistent read added; Scalability; Low maintenance; Advantages of the SimpleDB model; Disadvantages of the SimpleDB model; Summary; Chapter 4: The SimpleDB Data Model; Domains; Domains with Java; Domains with PHP; Domains with Python; Exploring the metadata for a domain and costs; Retrieving domain metadata Retrieving domain metadata with JavaRetrieving domain metadata with PHP; Retrieving domain metadata with Python; Components of a domain's metadata; SimpleDB domain constraints; Items; Adding attributes to an item with Java; Adding attributes to an item with PHP; Adding attributes to an item with Python; Constraints on SimpleDB items; Attributes; Attributes with Java; Attributes with PHP; Attributes with Python; Constraints on SimpleDB item attributes; Values; Storing multiple values in a single attribute with Java; Storing multiple values in a single attribute with PHP Storing multiple values in a single attribute with PythonConstraints on values of a SimpleDB item; Consistent Read and Conditional Put / Delete announcement; ConsistentRead = true for getAttributes and Select; Conditional Put / Delete; Summary; Chapter 5: Data Types; What is lexicographical comparison?; Storing numeric values; Storing numeric values with Java; Storing numeric values with PHP; Storing numeric values with Python; Storing date values; Storing date values with Java; Storing date values with PHP; Storing date values with Python; Storing Boolean values Storing Boolean values with Java |
| Record Nr. | UNINA-9910459648103321 |
Chaganti Prabhakar
|
||
| Birmingham, U.K., : Packt Enterprise, 2010 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Amazon SimpleDB developer guide : scale your application's database on the cloud using Amazon SimpleDB / / Prabhakar Chaganti, Rich Helms
| Amazon SimpleDB developer guide : scale your application's database on the cloud using Amazon SimpleDB / / Prabhakar Chaganti, Rich Helms |
| Autore | Chaganti Prabhakar |
| Pubbl/distr/stampa | Birmingham, United Kingdom : , : Packt Enterprise, , 2010 |
| Descrizione fisica | 1 online resource (252 pages) |
| Disciplina |
005.75
005.7585 |
| Altri autori (Persone) | HelmsRich |
| Soggetto topico |
Web services
Cloud computing Database management |
| ISBN |
1-282-62408-3
9786612624087 1-84719-735-3 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; Table of Contents; Preface; Chapter 1: Getting to Know SimpleDB; Experimenting with SimpleDB; How does SimpleDB work?; Domain; Item; Attributes; Values; How do I interact with SimpleDB?; How is SimpleDB priced?; Free tier; Why should I use SimpleDB?; Make your applications simpler to architect; Build flexibility into your applications; Create high-performance web applications; Take advantage of lower costs; Scale your applications on demand; Architect for the cloud; Summary; Chapter 2: Getting Started with SimpleDB
Creating an AWS accountEnabling SimpleDB service for AWS account; Query API and authentication; SimpleDB libraries; SDBtool - Firefox plugin; Sample outline - performing basic operations; Basic operations with Java; Exploring SimpleDB with Java; Creating a domain with Java; Listing domains with Java; Manipulating items with Java; Deleting a domain with Java; Basic operations with PHP; Exploring SimpleDB with PHP; Creating a domain with PHP; Listing domains with PHP; Manipulating items with PHP; Deleting a domain with PHP; Basic operations with Python; Introducing boto Exploring SimpleDB with PythonCreating a domain with Python; Retrieving a domain with Python; Creating items with Python; Summary; Chapter 3: SimpleDB versus RDBMS; No normalization; No joins; No schemas; Simpler SQL; Only strings; Eventual consistency; Flash: February 24, 2010-consistent read added; Scalability; Low maintenance; Advantages of the SimpleDB model; Disadvantages of the SimpleDB model; Summary; Chapter 4: The SimpleDB Data Model; Domains; Domains with Java; Domains with PHP; Domains with Python; Exploring the metadata for a domain and costs; Retrieving domain metadata Retrieving domain metadata with JavaRetrieving domain metadata with PHP; Retrieving domain metadata with Python; Components of a domain's metadata; SimpleDB domain constraints; Items; Adding attributes to an item with Java; Adding attributes to an item with PHP; Adding attributes to an item with Python; Constraints on SimpleDB items; Attributes; Attributes with Java; Attributes with PHP; Attributes with Python; Constraints on SimpleDB item attributes; Values; Storing multiple values in a single attribute with Java; Storing multiple values in a single attribute with PHP Storing multiple values in a single attribute with PythonConstraints on values of a SimpleDB item; Consistent Read and Conditional Put / Delete announcement; ConsistentRead = true for getAttributes and Select; Conditional Put / Delete; Summary; Chapter 5: Data Types; What is lexicographical comparison?; Storing numeric values; Storing numeric values with Java; Storing numeric values with PHP; Storing numeric values with Python; Storing date values; Storing date values with Java; Storing date values with PHP; Storing date values with Python; Storing Boolean values Storing Boolean values with Java |
| Record Nr. | UNINA-9910784936103321 |
|
Chaganti Prabhakar
|
||
| Birmingham, United Kingdom : , : Packt Enterprise, , 2010 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Amazon SimpleDB developer guide : scale your application's database on the cloud using Amazon SimpleDB / / Prabhakar Chaganti, Rich Helms
| Amazon SimpleDB developer guide : scale your application's database on the cloud using Amazon SimpleDB / / Prabhakar Chaganti, Rich Helms |
| Autore | Chaganti Prabhakar |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Birmingham, United Kingdom : , : Packt Enterprise, , 2010 |
| Descrizione fisica | 1 online resource (252 pages) |
| Disciplina |
005.75
005.7585 |
| Altri autori (Persone) | HelmsRich |
| Soggetto topico |
Web services
Cloud computing Database management |
| ISBN |
9786612624087
9781282624085 1282624083 9781847197351 1847197353 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; Table of Contents; Preface; Chapter 1: Getting to Know SimpleDB; Experimenting with SimpleDB; How does SimpleDB work?; Domain; Item; Attributes; Values; How do I interact with SimpleDB?; How is SimpleDB priced?; Free tier; Why should I use SimpleDB?; Make your applications simpler to architect; Build flexibility into your applications; Create high-performance web applications; Take advantage of lower costs; Scale your applications on demand; Architect for the cloud; Summary; Chapter 2: Getting Started with SimpleDB
Creating an AWS accountEnabling SimpleDB service for AWS account; Query API and authentication; SimpleDB libraries; SDBtool - Firefox plugin; Sample outline - performing basic operations; Basic operations with Java; Exploring SimpleDB with Java; Creating a domain with Java; Listing domains with Java; Manipulating items with Java; Deleting a domain with Java; Basic operations with PHP; Exploring SimpleDB with PHP; Creating a domain with PHP; Listing domains with PHP; Manipulating items with PHP; Deleting a domain with PHP; Basic operations with Python; Introducing boto Exploring SimpleDB with PythonCreating a domain with Python; Retrieving a domain with Python; Creating items with Python; Summary; Chapter 3: SimpleDB versus RDBMS; No normalization; No joins; No schemas; Simpler SQL; Only strings; Eventual consistency; Flash: February 24, 2010-consistent read added; Scalability; Low maintenance; Advantages of the SimpleDB model; Disadvantages of the SimpleDB model; Summary; Chapter 4: The SimpleDB Data Model; Domains; Domains with Java; Domains with PHP; Domains with Python; Exploring the metadata for a domain and costs; Retrieving domain metadata Retrieving domain metadata with JavaRetrieving domain metadata with PHP; Retrieving domain metadata with Python; Components of a domain's metadata; SimpleDB domain constraints; Items; Adding attributes to an item with Java; Adding attributes to an item with PHP; Adding attributes to an item with Python; Constraints on SimpleDB items; Attributes; Attributes with Java; Attributes with PHP; Attributes with Python; Constraints on SimpleDB item attributes; Values; Storing multiple values in a single attribute with Java; Storing multiple values in a single attribute with PHP Storing multiple values in a single attribute with PythonConstraints on values of a SimpleDB item; Consistent Read and Conditional Put / Delete announcement; ConsistentRead = true for getAttributes and Select; Conditional Put / Delete; Summary; Chapter 5: Data Types; What is lexicographical comparison?; Storing numeric values; Storing numeric values with Java; Storing numeric values with PHP; Storing numeric values with Python; Storing date values; Storing date values with Java; Storing date values with PHP; Storing date values with Python; Storing Boolean values Storing Boolean values with Java |
| Record Nr. | UNINA-9911091888803321 |
|
Chaganti Prabhakar
|
||
| Birmingham, United Kingdom : , : Packt Enterprise, , 2010 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Amazon SimpleDB developer guide : scale your application's database on the cloud using Amazon SimpleDB / / Prabhakar Chaganti, Rich Helms
| Amazon SimpleDB developer guide : scale your application's database on the cloud using Amazon SimpleDB / / Prabhakar Chaganti, Rich Helms |
| Autore | Chaganti Prabhakar |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | Birmingham, United Kingdom : , : Packt Enterprise, , 2010 |
| Descrizione fisica | 1 online resource (252 pages) |
| Disciplina |
005.75
005.7585 |
| Altri autori (Persone) | HelmsRich |
| Soggetto topico |
Web services
Cloud computing Database management |
| ISBN |
9786612624087
9781282624085 1282624083 9781847197351 1847197353 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Cover; Copyright; Credits; About the Authors; About the Reviewers; Table of Contents; Preface; Chapter 1: Getting to Know SimpleDB; Experimenting with SimpleDB; How does SimpleDB work?; Domain; Item; Attributes; Values; How do I interact with SimpleDB?; How is SimpleDB priced?; Free tier; Why should I use SimpleDB?; Make your applications simpler to architect; Build flexibility into your applications; Create high-performance web applications; Take advantage of lower costs; Scale your applications on demand; Architect for the cloud; Summary; Chapter 2: Getting Started with SimpleDB
Creating an AWS accountEnabling SimpleDB service for AWS account; Query API and authentication; SimpleDB libraries; SDBtool - Firefox plugin; Sample outline - performing basic operations; Basic operations with Java; Exploring SimpleDB with Java; Creating a domain with Java; Listing domains with Java; Manipulating items with Java; Deleting a domain with Java; Basic operations with PHP; Exploring SimpleDB with PHP; Creating a domain with PHP; Listing domains with PHP; Manipulating items with PHP; Deleting a domain with PHP; Basic operations with Python; Introducing boto Exploring SimpleDB with PythonCreating a domain with Python; Retrieving a domain with Python; Creating items with Python; Summary; Chapter 3: SimpleDB versus RDBMS; No normalization; No joins; No schemas; Simpler SQL; Only strings; Eventual consistency; Flash: February 24, 2010-consistent read added; Scalability; Low maintenance; Advantages of the SimpleDB model; Disadvantages of the SimpleDB model; Summary; Chapter 4: The SimpleDB Data Model; Domains; Domains with Java; Domains with PHP; Domains with Python; Exploring the metadata for a domain and costs; Retrieving domain metadata Retrieving domain metadata with JavaRetrieving domain metadata with PHP; Retrieving domain metadata with Python; Components of a domain's metadata; SimpleDB domain constraints; Items; Adding attributes to an item with Java; Adding attributes to an item with PHP; Adding attributes to an item with Python; Constraints on SimpleDB items; Attributes; Attributes with Java; Attributes with PHP; Attributes with Python; Constraints on SimpleDB item attributes; Values; Storing multiple values in a single attribute with Java; Storing multiple values in a single attribute with PHP Storing multiple values in a single attribute with PythonConstraints on values of a SimpleDB item; Consistent Read and Conditional Put / Delete announcement; ConsistentRead = true for getAttributes and Select; Conditional Put / Delete; Summary; Chapter 5: Data Types; What is lexicographical comparison?; Storing numeric values; Storing numeric values with Java; Storing numeric values with PHP; Storing numeric values with Python; Storing date values; Storing date values with Java; Storing date values with PHP; Storing date values with Python; Storing Boolean values Storing Boolean values with Java |
| Record Nr. | UNINA-9911138613003321 |
| Chaganti Prabhakar | ||
| Birmingham, United Kingdom : , : Packt Enterprise, , 2010 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Analytic SQL in SQL server 2014/2016 / / Riadh Ghlala ; series editor Jean-Charles Pomerol
| Analytic SQL in SQL server 2014/2016 / / Riadh Ghlala ; series editor Jean-Charles Pomerol |
| Autore | Ghlala Riadh |
| Pubbl/distr/stampa | London, England : , : ISTE : , : Wiley, , [2019] |
| Descrizione fisica | 1 online resource (172 pages) |
| Disciplina | 005.7585 |
| ISBN |
1-119-64927-7
1-119-64954-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910555119603321 |
|
Ghlala Riadh
|
||
| London, England : , : ISTE : , : Wiley, , [2019] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Analytic SQL in SQL server 2014/2016 / / Riadh Ghlala ; series editor Jean-Charles Pomerol
| Analytic SQL in SQL server 2014/2016 / / Riadh Ghlala ; series editor Jean-Charles Pomerol |
| Autore | Ghlala Riadh |
| Pubbl/distr/stampa | London, England : , : ISTE : , : Wiley, , [2019] |
| Descrizione fisica | 1 online resource (172 pages) |
| Disciplina | 005.7585 |
| ISBN |
1-119-64927-7
1-119-64954-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910830705203321 |
|
Ghlala Riadh
|
||
| London, England : , : ISTE : , : Wiley, , [2019] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Analytics optimization with columnstore indexes in Microsoft SQL Server : optimizing OLAP workloads / / Edward Pollack
| Analytics optimization with columnstore indexes in Microsoft SQL Server : optimizing OLAP workloads / / Edward Pollack |
| Autore | Pollack Edward (Database administrator) |
| Edizione | [[First edition].] |
| Pubbl/distr/stampa | New York, New York : , : Apress L. P., , [2022] |
| Descrizione fisica | 1 online resource (285 pages) : illustrations |
| Disciplina | 005.7585 |
| Soggetto topico |
Client/server computing
Database management |
| ISBN | 1-4842-8048-2 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 1. Introduction to Analytic Data in a Transactional Database 2. Transactional vs. Analytic Workloads 3. What are Columnstore Indexes? 4. Columnstore Index Architecture 5. Columnstore Compression 6. Columnstore Metadata 7. Batch Execution 8. Bulk Loading Data 9. Delete and Update Operations 10. Segment and Rowgroup Elimination 11. Partitioning 12. Non-Clustered Columnstore Indexes on Rowstore Tables 13. Non-Clustered Rowstore Indexes on Columnstore Tables 14. Columnstore Index Maintenance 15. Columnstore Index Performance |
| Record Nr. | UNINA-9910548185003321 |
|
Pollack Edward (Database administrator)
|
||
| New York, New York : , : Apress L. P., , [2022] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
App inventor 2 con database MySQL : gestione remota dei dati / by Antonio Taccetti
| App inventor 2 con database MySQL : gestione remota dei dati / by Antonio Taccetti |
| Autore | Taccetti, Antonio |
| Pubbl/distr/stampa | Firenze, : [s.n.], 2016 |
| Descrizione fisica | 71 p. ; 28 cm |
| Disciplina |
005.75
005.7585 |
| ISBN | 9781533270962 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | ita |
| Record Nr. | UNISANNIO-NAP0772985 |
|
Taccetti, Antonio
|
||
| Firenze, : [s.n.], 2016 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. del Sannio | ||
| ||
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 | ||
| ||