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 SQL Server Reporting Services [[electronic resource] /] / by Kathi Kellenberger
| Beginning SQL Server Reporting Services [[electronic resource] /] / by Kathi Kellenberger |
| Autore | Kellenberger Kathi |
| Edizione | [1st ed. 2016.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2016 |
| Descrizione fisica | 1 online resource (338 p.) |
| Disciplina | 004 |
| Soggetto topico |
Database management
Data mining Database Management Data Mining and Knowledge Discovery |
| ISBN | 1-4842-1990-2 |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | Introduction -- Part I: Getting Started -- 1. Getting Started -- 2. Using the Wizard to Create Your First Reports.- -- Part II: Report Development -- 3. Understanding Data Sources and Datasets -- 4. Working with Tables, Controls, and Report Sections.-5. Adding Grouping Levels to Reports -- 6. Making Reports Dynamic -- 7. Bringing Data to Life Visually -- Part III: Deploying Reports -- 8. Publishing Reports -- 9. Securing Your Reports -- 10. Using Report Builder -- 11. Where to Go from Here. |
| Record Nr. | UNINA-9910254752903321 |
Kellenberger Kathi
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2016 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Beginning T-SQL : a step-by-step approach / / Kathi Kellenberger; Lee Everest
| Beginning T-SQL : a step-by-step approach / / Kathi Kellenberger; Lee Everest |
| Autore | Kellenberger Kathi |
| Edizione | [Fourth edition.] |
| Pubbl/distr/stampa | Berkeley, California : , : Apress, , [2021] |
| Descrizione fisica | 1 online resource (XXIX, 706 p. 350 illus.) |
| Disciplina | 005.7565 |
| Soggetto topico |
Database management
Microsoft .NET Framework Microsoft software |
| ISBN | 1-4842-6606-4 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 1. Getting Started -- 2. Exploring Database Concepts -- 3. Writing Simple SELECT Queries -- 4. Using Built-In Functions and Expressions -- 5. Joining Tables -- 6. Building on Subqueries, Common Table Expressions, and Unions -- 7. Grouping and Summarizing Data -- 8. Discovering Windowing Functions -- 9. Advanced WHERE Clauses -- 10. Manipulating Data -- 11. Managing Transactions -- 12. Understanding T-SQL Programming Logic -- 13. Implementing Logic in the Database -- 14. Expanding on Data Type Concepts -- 15. Working with XML and JSON -- 16. Writing Advanced Queries -- 17.Where to Go Next? -- Appendix A: SQL Server for Linux and macOS -- Appendix B: Using SSMS -- Appendix C: SQL Notebooks. |
| Record Nr. | UNINA-9910483129403321 |
|
Kellenberger Kathi
|
||
| Berkeley, California : , : Apress, , [2021] | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Beginning T-SQL [[electronic resource] /] / by Kathi Kellenberger, Scott Shaw
| Beginning T-SQL [[electronic resource] /] / by Kathi Kellenberger, Scott Shaw |
| Autore | Kellenberger Kathi |
| Edizione | [3rd ed. 2014.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 |
| Descrizione fisica | 1 online resource (480 p.) |
| Disciplina |
004
005.74 |
| Collana | The expert's voice in SQL server |
| Soggetto topico |
Database management
Data structures (Computer science) Database Management Data Structures and Information Theory |
| ISBN | 1-4842-0046-2 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents at a Glance; Chapter 1: Getting Started; Installing SQL Server Express Edition; Installing Books Online; Using Books Online; Using SQL Server Management Studio; Launching SQL Server Management Studio; Installing the Sample Databases; Get Started with SSMS; Summary; Chapter 2: Exploring Database Concepts; What Is SQL Server?; Databases in the Cloud; Service vs. Application; Database as Container; Data Is Stored in Tables; Data Types; Normalization; Understanding Indexes; Database Schemas; Summary; Chapter 3: Writing Simple SELECT Queries; Using the SELECT Statement
Selecting a Literal ValueRetrieving from a Table; Generating a Select-List; Mixing Literals and Column Names; Filtering Data; Adding a WHERE Clause; Using WHERE Clauses with Alternate Operators; Using BETWEEN; Using BETWEEN with NOT; Filtering on Date and Time; Using WHERE Clauses with Two Predicates; Using the IN Operator; Working with NULL; Sorting Data; Thinking About Performance; Taking Advantage of Indexes; Viewing Execution Plans; Summary; Answers to the Exercises; Solutions to Exercise 3-1: Using the SELECT Statement; Solutions to Exercise 3-2: Filtering Data Solutions to Exercise 3-3: Using WHERE Clauses with Two PredicatesSolutions to Exercise 3-4: Working with NULL; Solutions to Exercise 3-5: Sorting Data; Chapter 4: Using Built-In Functions and Expressions; Expressions Using Operators; Concatenating Strings; Concatenating Strings and NULL; CONCAT; ISNULL and COALESCE; Concatenating Other Data Types to Strings; Using Mathematical Operators; Using String Functions; RTRIM and LTRIM; LEFT and RIGHT; LEN and DATALENGTH; CHARINDEX; SUBSTRING; CHOOSE; REVERSE; UPPER and LOWER; REPLACE; Nesting Functions; Using Date and Time Functions GETDATE and SYSDATETIMEDATEADD; DATEDIFF; DATENAME and DATEPART; DAY, MONTH, and YEAR; CONVERT; FORMAT; DATEFROMPARTS; EOMONTH; Using Mathematical Functions; ABS; POWER; SQUARE and SQRT; ROUND; RAND; Logical Functions and Expressions; The CASE Expression; Simple CASE; Searched CASE; Listing a Column as the Return Value; IIF; COALESCE; Administrative Function s; Using Functions in the WHERE and ORDER BY Clauses; The TOP Keyword; Thinking About Performance; Summary; Answers to the Exercises; Solutions to Exercise 4-1: Expressions Using Operators Solutions to Exercise 4-2: Using Mathematical OperatorsSolution to Exercise 4-3: Using Functions; Solution to Exercise 4-4: Using Date and Time Functions; Solution to Exercise 4-5: Using Mathematical Functions; Solution to Exercise 4-6: Using Logical and System Functions; Solution to Exercise 4-7: Using Functions in the WHERE and ORDER BY Clauses; Chapter 5: Joining Tables; Using INNER JOIN; Joining Two Tables; Avoiding an Incorrect Join Condition; Joining on a Different Column Name; Joining on More Than One Column; Joining Three or More Tables; Using OUTER JOIN; Using LEFT OUTER JOIN Using RIGHT OUTER JOIN |
| Record Nr. | UNINA-9910300660203321 |
|
Kellenberger Kathi
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2014 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Expert T-SQL Window Functions in SQL Server [[electronic resource] /] / by Kathi Kellenberger, Clayton Groom
| Expert T-SQL Window Functions in SQL Server [[electronic resource] /] / by Kathi Kellenberger, Clayton Groom |
| Autore | Kellenberger Kathi |
| Edizione | [1st ed. 2015.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 |
| Descrizione fisica | 1 online resource (140 p.) |
| Disciplina |
004
005.13 005.74 |
| Collana | Expert's Voice in SQL Server |
| Soggetto topico |
Database management
Programming languages (Electronic computers) Database Management Programming Languages, Compilers, Interpreters |
| ISBN | 1-4842-1103-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Contents at a Glance; Chapter 1: Looking Through the Window; Discovering Window Functions; Thinking About the Window; Understanding the OVER Clause; Dividing Windows with Partitions; Uncovering Special Case Windows; Summary; Chapter 2: Discovering Ranking Functions; Using ROW_NUMBER; Understanding RANK and DENSE_RANK; Dividing Data with NTILE; Solving Queries with Ranking Functions; Deduplicating Data; Finding the First N Rows of Every Group; Solving the Islands Problem; Solving the Bonus Problem; Summary; Chapter 3: Summarizing with Window Aggregates; Using Window Aggregates
Adding Window Aggregates to Aggregate QueriesUsing Window Aggregates to Solve Common Queries; The Percent of Sales Problem; The Partitioned Table Problem; Creating Custom Window Aggregate Functions; Summary; Chapter 4: Tuning for Better Performance; Using Execution Plans; Using STATISTICS IO; Understanding the Performance Implications of Window Aggregates; Indexing to Improve the Performance of Window Functions; Performing Time Comparisons; Summary; Chapter 5: Calculating Running and Moving Aggregates; Adding ORDER BY to Window Aggregates; Calculating Moving Totals and Averages Solving Queries Using Accumulating AggregatesThe Last Good Value Problem; The Subscription Problem; Summary; Chapter 6: Adding Frames to the Window; Understanding Framing; Applying Frames to Running and Moving Aggregates; Measuring Performance; Understanding the Logical Difference Between ROWS and RANGE; Summary; Chapter 7: Taking a Peek at Another Row; Understanding LAG and LEAD; Understanding FIRST_VALUE and LAST_ VALUE; Using the Offset Functions to Solve Queries; The Year-Over-Year Growth Calculation; The Gaps Problem; Comparing Performance; LAG and LEAD Performance FIRST_VALUE and LAST_VALUE PERFORMANCESummary; Chapter 8: Understanding Statistical Functions; Using PERCENT_RANK and CUME_ DIST; Using PERCENTILE_CONT and PERCENTILE_ DISC; Comparing Statistical Functions to Older Methods; Summary; Chapter 9: Time Range Calculations and Trends; Putting It All Together; Percent of Parent; Period-to-Date Calculations; Averages, Moving Averages, and Rate-of-Change; Same Period Prior Year; Difference and Percent Difference; Moving Totals and Simple Moving Averages; Rate-of-Change Calculations; Summary; Index; Contents; About the Authors About the Technical ReviewerAcknowledgments; Author's Note |
| Record Nr. | UNINA-9910300643303321 |
|
Kellenberger Kathi
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Expert T-SQL Window Functions in SQL Server 2019 : The Hidden Secret to Fast Analytic and Reporting Queries / / by Kathi Kellenberger, Clayton Groom, Ed Pollack
| Expert T-SQL Window Functions in SQL Server 2019 : The Hidden Secret to Fast Analytic and Reporting Queries / / by Kathi Kellenberger, Clayton Groom, Ed Pollack |
| Autore | Kellenberger Kathi |
| Edizione | [2nd ed. 2019.] |
| Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2019 |
| Descrizione fisica | 1 online resource (221 pages) |
| Disciplina | 005.7565 |
| Soggetto topico |
Database management
Programming languages (Electronic computers) Microsoft software Microsoft .NET Framework Database Management Programming Languages, Compilers, Interpreters Microsoft and .NET |
| ISBN | 1-4842-5197-0 |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto | 1. Looking through the Window -- 2. Discovering Ranking Functions.-3. Summarizing with Window Aggregates -- 4. Calculating Running and Moving Aggregates -- 5. Adding Frames to the Window -- 6. Taking a Peek at Another Row -- 7. Understanding Statistical Functions -- 8. Tuning for Better Performance -- 9. Hitting a Home Run with Gaps, Islands, and Streaks -- 10. Time Range Calculations -- 11. Time Trend Calculations. |
| Record Nr. | UNINA-9910349524803321 |
|
Kellenberger Kathi
|
||
| Berkeley, CA : , : Apress : , : Imprint : Apress, , 2019 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||