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.
Advanced analytics with Transact-SQL : exploring hidden patterns and rules in your data / / Dejan Sarka
| Advanced analytics with Transact-SQL : exploring hidden patterns and rules in your data / / Dejan Sarka |
| Autore | Sarka Dejan |
| Pubbl/distr/stampa | [Place of publication not identified] : , : Apress, , [2021] |
| Descrizione fisica | 1 online resource (308 pages) |
| Disciplina | 005.7 |
| Soggetto topico |
Big data
Business intelligence - Data processing SQL (Computer program language) |
| ISBN | 1-4842-7173-4 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910495206103321 |
Sarka Dejan
|
||
| [Place of publication not identified] : , : Apress, , [2021] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Advanced MySQL 8 : discover the full potential of MySQL and ensure high performance of your database / / Eric Vanier, Birju Shah, Tejaswi Malepati
| Advanced MySQL 8 : discover the full potential of MySQL and ensure high performance of your database / / Eric Vanier, Birju Shah, Tejaswi Malepati |
| Autore | Vanier Eric |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham : , : Packt, , 2019 |
| Descrizione fisica | 1 online resource (286 pages) |
| Soggetto topico | SQL (Computer program language) |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910795316603321 |
|
Vanier Eric
|
||
| Birmingham : , : Packt, , 2019 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Advanced MySQL 8 : discover the full potential of MySQL and ensure high performance of your database / / Eric Vanier, Birju Shah, Tejaswi Malepati
| Advanced MySQL 8 : discover the full potential of MySQL and ensure high performance of your database / / Eric Vanier, Birju Shah, Tejaswi Malepati |
| Autore | Vanier Eric |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Birmingham : , : Packt, , 2019 |
| Descrizione fisica | 1 online resource (286 pages) |
| Soggetto topico | SQL (Computer program language) |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910807416103321 |
|
Vanier Eric
|
||
| Birmingham : , : Packt, , 2019 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Advanced SQL, 1999 [electronic resource] : understanding object-relational and other advanced features / Jim Melton
| Advanced SQL, 1999 [electronic resource] : understanding object-relational and other advanced features / Jim Melton |
| Autore | Melton, Jim, 1946- |
| Pubbl/distr/stampa | Amsterdam ; Boston, Mass. : Morgan Kaufmann Pub., c2003. |
| Descrizione fisica | xxviii, 563 p. : ill. ; 24 cm. |
| Disciplina | 005.75/65 |
| Collana | The Morgan Kaufmann series in data management systems |
| Soggetto topico |
SQL (Computer program language)
Object-oriented programming (Computer science) Relational databases |
| Soggetto genere / forma | Electronic books. |
| ISBN |
9781558606777
1558606777 |
| Formato | Risorse elettroniche  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Introduction to SQL:1999. User-Defined Types. Typed Tables. Routines and Routine Invocation. Foreign Servers and Foreign-Data Wrappers. Datalinks. OLAP. SQL/OLB and SQL/JRT. SQL/XML. SQL Multimedia and Application Package. A Look To The Future. Appendix: An SQL:1999 Example Using UDTs. The SQL:1999 Annexes. Relevant Standards Bodies. Status Codes. The SQL Standardization Process. |
| Record Nr. | UNISALENTO-991003248429707536 |
|
Melton, Jim, 1946-
|
||
| Amsterdam ; Boston, Mass. : Morgan Kaufmann Pub., c2003. | ||
| Risorse elettroniche | ||
| Lo trovi qui: Univ. del Salento | ||
| ||
Advanced standard SQL dynamic structured data modeling and hierarchical processing / / Michael M. David, Lee Fesperman
| Advanced standard SQL dynamic structured data modeling and hierarchical processing / / Michael M. David, Lee Fesperman |
| Autore | David Michael M. |
| Pubbl/distr/stampa | Boston : , : Artech House, , ©2013 |
| Descrizione fisica | 1 online resource (406 p.) |
| Disciplina | 005.7565 |
| Altri autori (Persone) |
FespermanLee
DavidMichael M |
| Collana | Artech House computing library |
| Soggetto topico |
SQL (Computer program language)
Data structures (Computer science) |
| Soggetto genere / forma | Electronic books. |
| ISBN | 1-60807-534-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Advanced Standard SQL Dynamic Structured Data Modeling and Hierarchical Processing; Contents; Preface; Introduction; Part I: The Basics of the RelationalJoin Operation; 1 Relational Join Introduction; 1.1 Standard Inner Join Review; 1.2 Problems with Relational Join Processing; 1.3 Outer Join Review; 1.4 Problems with Previous Outer Join Syntax; 1.5 Conclusion; 2 The Standard SQL Join Operation; 2.1 Standard SQL Join Syntax; 2.2 Standard SQL Join Operation; 2.3 Standard SQL Join Does Not Follow the Cartesian Product Model; 2.4 Determining Standard SQL Join Associativity and Commutativity.
2.5 What Outer Join Commutativity Is2.6 What Outer Join Associativity Is; 2.7 Hierarchictivity in Addition to Associativity and Commutativity; 2.8 Conclusion; 3 Standard SQL Join Types and Their Operation; 3.1 FULL Outer Join; 3.2 One-Sided Outer Join; 3.3 INNER Join; 3.4 CROSS Join; 3.5 UNION Join; 3.6 Intermixing Join Types; 3.7 Conclusion; 64. |
| Record Nr. | UNINA-9910465334403321 |
|
David Michael M.
|
||
| Boston : , : Artech House, , ©2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Advanced standard SQL dynamic structured data modeling and hierarchical processing / / Michael M. David, Lee Fesperman
| Advanced standard SQL dynamic structured data modeling and hierarchical processing / / Michael M. David, Lee Fesperman |
| Autore | David Michael M. |
| Pubbl/distr/stampa | Boston : , : Artech House, , ©2013 |
| Descrizione fisica | 1 online resource (406 p.) |
| Disciplina | 005.7565 |
| Altri autori (Persone) |
FespermanLee
DavidMichael M |
| Collana | Artech House computing library |
| Soggetto topico |
SQL (Computer program language)
Data structures (Computer science) |
| ISBN | 1-60807-534-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Advanced Standard SQL Dynamic Structured Data Modeling and Hierarchical Processing; Contents; Preface; Introduction; Part I: The Basics of the RelationalJoin Operation; 1 Relational Join Introduction; 1.1 Standard Inner Join Review; 1.2 Problems with Relational Join Processing; 1.3 Outer Join Review; 1.4 Problems with Previous Outer Join Syntax; 1.5 Conclusion; 2 The Standard SQL Join Operation; 2.1 Standard SQL Join Syntax; 2.2 Standard SQL Join Operation; 2.3 Standard SQL Join Does Not Follow the Cartesian Product Model; 2.4 Determining Standard SQL Join Associativity and Commutativity.
2.5 What Outer Join Commutativity Is2.6 What Outer Join Associativity Is; 2.7 Hierarchictivity in Addition to Associativity and Commutativity; 2.8 Conclusion; 3 Standard SQL Join Types and Their Operation; 3.1 FULL Outer Join; 3.2 One-Sided Outer Join; 3.3 INNER Join; 3.4 CROSS Join; 3.5 UNION Join; 3.6 Intermixing Join Types; 3.7 Conclusion; 64. |
| Record Nr. | UNINA-9910792279703321 |
|
David Michael M.
|
||
| Boston : , : Artech House, , ©2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Advanced standard SQL dynamic structured data modeling and hierarchical processing / / Michael M. David, Lee Fesperman
| Advanced standard SQL dynamic structured data modeling and hierarchical processing / / Michael M. David, Lee Fesperman |
| Autore | David Michael M. |
| Pubbl/distr/stampa | Boston : , : Artech House, , ©2013 |
| Descrizione fisica | 1 online resource (406 p.) |
| Disciplina | 005.7565 |
| Altri autori (Persone) |
FespermanLee
DavidMichael M |
| Collana | Artech House computing library |
| Soggetto topico |
SQL (Computer program language)
Data structures (Computer science) |
| ISBN | 1-60807-534-6 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Advanced Standard SQL Dynamic Structured Data Modeling and Hierarchical Processing; Contents; Preface; Introduction; Part I: The Basics of the RelationalJoin Operation; 1 Relational Join Introduction; 1.1 Standard Inner Join Review; 1.2 Problems with Relational Join Processing; 1.3 Outer Join Review; 1.4 Problems with Previous Outer Join Syntax; 1.5 Conclusion; 2 The Standard SQL Join Operation; 2.1 Standard SQL Join Syntax; 2.2 Standard SQL Join Operation; 2.3 Standard SQL Join Does Not Follow the Cartesian Product Model; 2.4 Determining Standard SQL Join Associativity and Commutativity.
2.5 What Outer Join Commutativity Is2.6 What Outer Join Associativity Is; 2.7 Hierarchictivity in Addition to Associativity and Commutativity; 2.8 Conclusion; 3 Standard SQL Join Types and Their Operation; 3.1 FULL Outer Join; 3.2 One-Sided Outer Join; 3.3 INNER Join; 3.4 CROSS Join; 3.5 UNION Join; 3.6 Intermixing Join Types; 3.7 Conclusion; 64. |
| Record Nr. | UNINA-9910814780503321 |
|
David Michael M.
|
||
| Boston : , : Artech House, , ©2013 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Automated policy-based asset cuing using SQLite / / Jesse Kovach and Robert Walker
| Automated policy-based asset cuing using SQLite / / Jesse Kovach and Robert Walker |
| Autore | Kovach Jesse B. |
| Pubbl/distr/stampa | Adelphi, MD : , : Army Research Laboratory, , 2011 |
| Descrizione fisica | 1 online resource (vi, 38 pages) : illustrations (some color) |
| Collana | ARL-TR |
| Soggetto topico |
Electronics in military engineering
SQL (Computer program language) Military art and science - Automation |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910702165503321 |
|
Kovach Jesse B.
|
||
| Adelphi, MD : , : Army Research Laboratory, , 2011 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Beginning SQL [[electronic resource] /] / Paul Wilton and John W. Colby
| Beginning SQL [[electronic resource] /] / Paul Wilton and John W. Colby |
| Autore | Wilton Paul <1969-> |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Indianapolis, IN, : Wiley, c2005 |
| Descrizione fisica | 1 online resource (521 p.) |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | ColbyJohn W. <1954-> |
| Collana | Wrox beginning guides. |
| Soggetto topico | SQL (Computer program language) |
| Soggetto genere / forma | Electronic books. |
| ISBN |
1-280-25346-0
9786610253463 0-7645-9632-2 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Beginning SQL; About the Authors; Credits; Contents; Acknowledgments; 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: Introduction to SQL; A Brief History of Databases; Structured Query Language (SQL); Database Creation; Creating, Altering, and Deleting Tables; Good Database Design; Creating the Example Database; Summary; Exercises; Chapter 2: Entering Information; Inserting New Data; Inserting Data into the Case Study Database; Updating Data; Deleting Data
SummaryExercises; Chapter 3: Extracting Information; The SELECT Statement; Logical Operators and Operator Precedence; Ordering Results with ORDER BY; Selecting Data from More Than One Table; Introducing NULL Data; Summary; Exercises; Chapter 4: Advanced Database Design; Normalization; Ensuring Data Validity with Constraints; Speeding Up Results with Indexes; Summary; Exercises; Chapter 5: Manipulating Data; Understanding SQL Arithmetic; Introducing String Functions; Converting Different Data Types; Re-examining NULL; Using INSERT INTO with the SELECT Statement; Summary; Exercises Chapter 6: Grouping and Aggregating DataGrouping Results; Summarizing and Aggregating Data; Using the HAVING Clause with GROUP BY Statements; Summary; Exercises; Chapter 7: Selecting Data from Different Tables; Joins Revisited; Combining Results Sets with the UNION Operator; Summary; Exercises; Chapter 8: Queries within Queries; Subquery Terminology; Subqueries in a SELECT List; Subqueries in the WHERE Clause; Operators in Subqueries; Correlated Subquery; Subqueries Used with Other Statements; Summary; Exercises; Chapter 9: Advanced Queries; Updating the Database; Tackling Difficult Queries Top Tips for Efficient QueriesSummary; Exercises; Chapter 10: Views; Introducing Views; Summary; Exercises; Chapter 11: Transactions; Introducing Transactions; Transaction Logs; Locks; Isolation Levels; Problem Examples; Revisiting the Example Code; Summary; Exercises; Chapter 12: SQL Security; Security Concepts; Summary; Exercises; Chapter 13: Database Tuning; Tuning Hardware; Tuning SQL; Tuning Tips; Summary; Exercises; Appendix A: Exercise Answers; Chapter 1; Chapter 2; Chapter 3; Chapter 4; Chapter 5; Chapter 6; Chapter 7; Chapter 8; Chapter 9; Chapter 10; Chapter 11; Chapter 12 Chapter 13Appendix B: Setting Up and Using the Five Database Systems; Installing and Using MySQL Version 4.1; Installing and Using IBM DB2; Installing and Using Microsoft Access XP; Installing and Using Microsoft SQL Server 2000; Installing and Using Oracle 10g; Appendix C: Initial Data Setup; Category Table; MemberDetails Table; Location Table; FavCategory Table; Films Table; Attendance Table; Index |
| Record Nr. | UNINA-9910457711903321 |
|
Wilton Paul <1969->
|
||
| Indianapolis, IN, : Wiley, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Beginning SQL [[electronic resource] /] / Paul Wilton and John W. Colby
| Beginning SQL [[electronic resource] /] / Paul Wilton and John W. Colby |
| Autore | Wilton Paul <1969-> |
| Edizione | [1st edition] |
| Pubbl/distr/stampa | Indianapolis, IN, : Wiley, c2005 |
| Descrizione fisica | 1 online resource (521 p.) |
| Disciplina | 005.75/65 |
| Altri autori (Persone) | ColbyJohn W. <1954-> |
| Collana | Wrox beginning guides. |
| Soggetto topico | SQL (Computer program language) |
| ISBN |
1-280-25346-0
9786610253463 0-7645-9632-2 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Beginning SQL; About the Authors; Credits; Contents; Acknowledgments; 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: Introduction to SQL; A Brief History of Databases; Structured Query Language (SQL); Database Creation; Creating, Altering, and Deleting Tables; Good Database Design; Creating the Example Database; Summary; Exercises; Chapter 2: Entering Information; Inserting New Data; Inserting Data into the Case Study Database; Updating Data; Deleting Data
SummaryExercises; Chapter 3: Extracting Information; The SELECT Statement; Logical Operators and Operator Precedence; Ordering Results with ORDER BY; Selecting Data from More Than One Table; Introducing NULL Data; Summary; Exercises; Chapter 4: Advanced Database Design; Normalization; Ensuring Data Validity with Constraints; Speeding Up Results with Indexes; Summary; Exercises; Chapter 5: Manipulating Data; Understanding SQL Arithmetic; Introducing String Functions; Converting Different Data Types; Re-examining NULL; Using INSERT INTO with the SELECT Statement; Summary; Exercises Chapter 6: Grouping and Aggregating DataGrouping Results; Summarizing and Aggregating Data; Using the HAVING Clause with GROUP BY Statements; Summary; Exercises; Chapter 7: Selecting Data from Different Tables; Joins Revisited; Combining Results Sets with the UNION Operator; Summary; Exercises; Chapter 8: Queries within Queries; Subquery Terminology; Subqueries in a SELECT List; Subqueries in the WHERE Clause; Operators in Subqueries; Correlated Subquery; Subqueries Used with Other Statements; Summary; Exercises; Chapter 9: Advanced Queries; Updating the Database; Tackling Difficult Queries Top Tips for Efficient QueriesSummary; Exercises; Chapter 10: Views; Introducing Views; Summary; Exercises; Chapter 11: Transactions; Introducing Transactions; Transaction Logs; Locks; Isolation Levels; Problem Examples; Revisiting the Example Code; Summary; Exercises; Chapter 12: SQL Security; Security Concepts; Summary; Exercises; Chapter 13: Database Tuning; Tuning Hardware; Tuning SQL; Tuning Tips; Summary; Exercises; Appendix A: Exercise Answers; Chapter 1; Chapter 2; Chapter 3; Chapter 4; Chapter 5; Chapter 6; Chapter 7; Chapter 8; Chapter 9; Chapter 10; Chapter 11; Chapter 12 Chapter 13Appendix B: Setting Up and Using the Five Database Systems; Installing and Using MySQL Version 4.1; Installing and Using IBM DB2; Installing and Using Microsoft Access XP; Installing and Using Microsoft SQL Server 2000; Installing and Using Oracle 10g; Appendix C: Initial Data Setup; Category Table; MemberDetails Table; Location Table; FavCategory Table; Films Table; Attendance Table; Index |
| Record Nr. | UNINA-9910784351503321 |
|
Wilton Paul <1969->
|
||
| Indianapolis, IN, : Wiley, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
