Please use this identifier to cite or link to this item:
http://localhost/handle/Hannan/1596
Full metadata record
| DC Field | Value | Language |
|---|---|---|
| dc.contributor.author | Bartholomew, Daniel ; | en_US |
| dc.date.accessioned | 2013 | en_US |
| dc.date.accessioned | 2020-05-17T08:30:06Z | - |
| dc.date.available | 2020-05-17T08:30:06Z | - |
| dc.date.issued | 2017 | en_US |
| dc.identifier.isbn | 9781484231203 ; (electronic bk.) ; | en_US |
| dc.identifier.isbn | 1484231201 ; (electronic bk.) ; | en_US |
| dc.identifier.isbn | 9781484231197 ; | en_US |
| dc.identifier.uri | http://localhost/handle/Hannan/1596 | - |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | Ohio Library and Information Network ; | en_US |
| dc.description | Available to OhioLINK libraries ; | en_US |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | Print version: ; Bartholomew, Daniel ; MariaDB and MySQL Common Table Expressions and Window Functions Revealed ; Berkeley, CA : Apress,c2017 ; 9781484231197 ; | en_US |
| dc.description.statementofresponsibility | Daniel Batholomew | en_US |
| dc.description.tableofcontents | ""Contents at a Glance""; ""Contents""; ""About the Author""; ""About the Technical Reviewer""; ""Acknowledgments""; ""Introduction""; ""Syntax""; ""Part I: Common Table Expressions""; ""Chapter 1: Basics of Common Table Expressions""; ""Before We Begin""; ""What Are Common Table Expressionse""; ""Basic CTE Syntax""; ""The Motivation for CTEs""; ""Temporary""; ""Readable""; ""Using in One or Many Places""; ""Permissions""; ""Nesting""; ""Multiplexing""; ""Recursion""; ""Summary""; ""Chapter 2: Non-recursive Common Table Expressions""; ""Before We Begin"" ; | en_US |
| dc.description.tableofcontents | ""Using CTEs for Year-over-Year Comparisons""""Comparing Individuals Against Their Group""; ""Translating Subqueries into CTEs""; ""Summary""; ""Chapter 3: Recursive Common Table Expressions""; ""Before We Begin""; ""Recursive CTE Syntax""; ""Adding Numbers""; ""Calculating Fibonacci Numbers""; ""Looking Up Ancestors in a Tree""; ""Finding All Possible Destinations""; ""Finding All Possible Paths""; ""Summary""; ""Part II: Window Functions""; ""Chapter 4: Basics of Window Functions""; ""What Is a functione""; ""Window Function Syntax""; ""Partition Definition Syntax"" ; | en_US |
| dc.description.tableofcontents | ""Order Definition Syntax""""Frame Definition Syntax""; ""WINDOW Clause Syntax""; ""Window Functions Reference""; ""AVG()""; ""BIT_AND()""; ""BIT_OR()""; ""BIT_XOR()""; ""COUNT()""; ""CUME_DIST()""; ""DENSE_RANK()""; ""FIRST_VALUE()""; ""LAG()""; ""LAST_VALUE()""; ""LEAD()""; ""NTH_VALUE()""; ""NTILE""; ""PERCENT_RANK()""; ""RANK()""; ""ROW_NUMBER()""; ""SUM()""; ""Summary""; ""Chapter 5: Recognizing Opportunities for Window Functions""; ""Partitioning and Ordering Results""; ""Maintaining a Running Total""; ""Ranking Rows in a Result Set""; ""Summary"" ; | en_US |
| dc.description.tableofcontents | ""Chapter 6: Window Functions in Practice""""Before We Begin""; ""Working with Time-Series Data""; ""Using Multiple Window Functions at Once""; ""Graphing Time-Series Results""; ""Analyzing Fruit Sales""; ""Fruit Sales Within a Single Store""; ""Comparing Fruit Sales Across All Stores""; ""Summary""; ""Chapter 7: Combining Window Functions and CTEs""; ""Before We Begin""; ""Compute the Average Time Between Days with Precipitation""; ""Adding a Primary Key Column""; ""Finding Gaps and Islands""; ""Gaps""; ""Islands""; ""Summary"" ; | en_US |
| dc.format.extent | 1 online resource (116 p.) ; | en_US |
| dc.publisher | Apress, | en_US |
| dc.relation.haspart | 9781484231203.pdf | en_US |
| dc.subject | MySQL (Electronic resource) ; | en_US |
| dc.subject | Querying (Computer science) ; | en_US |
| dc.title | MariaDB and MySQL common table Expressions and Window functions revealed | en_US |
| dc.type | Book | en_US |
| dc.publisher.place | Berkeley, CA : | en_US |
| dc.classification.lc | QA76.9.D3 ; | en_US |
| Appears in Collections: | مهندسی فناوری اطلاعات | |
Files in This Item:
| File | Description | Size | Format | |
|---|---|---|---|---|
| 9781484231203.pdf | 2.36 MB | Adobe PDF |  Preview File |
Full metadata record
| DC Field | Value | Language |
|---|---|---|
| dc.contributor.author | Bartholomew, Daniel ; | en_US |
| dc.date.accessioned | 2013 | en_US |
| dc.date.accessioned | 2020-05-17T08:30:06Z | - |
| dc.date.available | 2020-05-17T08:30:06Z | - |
| dc.date.issued | 2017 | en_US |
| dc.identifier.isbn | 9781484231203 ; (electronic bk.) ; | en_US |
| dc.identifier.isbn | 1484231201 ; (electronic bk.) ; | en_US |
| dc.identifier.isbn | 9781484231197 ; | en_US |
| dc.identifier.uri | http://localhost/handle/Hannan/1596 | - |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | Ohio Library and Information Network ; | en_US |
| dc.description | Available to OhioLINK libraries ; | en_US |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | Print version: ; Bartholomew, Daniel ; MariaDB and MySQL Common Table Expressions and Window Functions Revealed ; Berkeley, CA : Apress,c2017 ; 9781484231197 ; | en_US |
| dc.description.statementofresponsibility | Daniel Batholomew | en_US |
| dc.description.tableofcontents | ""Contents at a Glance""; ""Contents""; ""About the Author""; ""About the Technical Reviewer""; ""Acknowledgments""; ""Introduction""; ""Syntax""; ""Part I: Common Table Expressions""; ""Chapter 1: Basics of Common Table Expressions""; ""Before We Begin""; ""What Are Common Table Expressionse""; ""Basic CTE Syntax""; ""The Motivation for CTEs""; ""Temporary""; ""Readable""; ""Using in One or Many Places""; ""Permissions""; ""Nesting""; ""Multiplexing""; ""Recursion""; ""Summary""; ""Chapter 2: Non-recursive Common Table Expressions""; ""Before We Begin"" ; | en_US |
| dc.description.tableofcontents | ""Using CTEs for Year-over-Year Comparisons""""Comparing Individuals Against Their Group""; ""Translating Subqueries into CTEs""; ""Summary""; ""Chapter 3: Recursive Common Table Expressions""; ""Before We Begin""; ""Recursive CTE Syntax""; ""Adding Numbers""; ""Calculating Fibonacci Numbers""; ""Looking Up Ancestors in a Tree""; ""Finding All Possible Destinations""; ""Finding All Possible Paths""; ""Summary""; ""Part II: Window Functions""; ""Chapter 4: Basics of Window Functions""; ""What Is a functione""; ""Window Function Syntax""; ""Partition Definition Syntax"" ; | en_US |
| dc.description.tableofcontents | ""Order Definition Syntax""""Frame Definition Syntax""; ""WINDOW Clause Syntax""; ""Window Functions Reference""; ""AVG()""; ""BIT_AND()""; ""BIT_OR()""; ""BIT_XOR()""; ""COUNT()""; ""CUME_DIST()""; ""DENSE_RANK()""; ""FIRST_VALUE()""; ""LAG()""; ""LAST_VALUE()""; ""LEAD()""; ""NTH_VALUE()""; ""NTILE""; ""PERCENT_RANK()""; ""RANK()""; ""ROW_NUMBER()""; ""SUM()""; ""Summary""; ""Chapter 5: Recognizing Opportunities for Window Functions""; ""Partitioning and Ordering Results""; ""Maintaining a Running Total""; ""Ranking Rows in a Result Set""; ""Summary"" ; | en_US |
| dc.description.tableofcontents | ""Chapter 6: Window Functions in Practice""""Before We Begin""; ""Working with Time-Series Data""; ""Using Multiple Window Functions at Once""; ""Graphing Time-Series Results""; ""Analyzing Fruit Sales""; ""Fruit Sales Within a Single Store""; ""Comparing Fruit Sales Across All Stores""; ""Summary""; ""Chapter 7: Combining Window Functions and CTEs""; ""Before We Begin""; ""Compute the Average Time Between Days with Precipitation""; ""Adding a Primary Key Column""; ""Finding Gaps and Islands""; ""Gaps""; ""Islands""; ""Summary"" ; | en_US |
| dc.format.extent | 1 online resource (116 p.) ; | en_US |
| dc.publisher | Apress, | en_US |
| dc.relation.haspart | 9781484231203.pdf | en_US |
| dc.subject | MySQL (Electronic resource) ; | en_US |
| dc.subject | Querying (Computer science) ; | en_US |
| dc.title | MariaDB and MySQL common table Expressions and Window functions revealed | en_US |
| dc.type | Book | en_US |
| dc.publisher.place | Berkeley, CA : | en_US |
| dc.classification.lc | QA76.9.D3 ; | en_US |
| Appears in Collections: | مهندسی فناوری اطلاعات | |
Files in This Item:
| File | Description | Size | Format | |
|---|---|---|---|---|
| 9781484231203.pdf | 2.36 MB | Adobe PDF | Preview File |
Full metadata record
| DC Field | Value | Language |
|---|---|---|
| dc.contributor.author | Bartholomew, Daniel ; | en_US |
| dc.date.accessioned | 2013 | en_US |
| dc.date.accessioned | 2020-05-17T08:30:06Z | - |
| dc.date.available | 2020-05-17T08:30:06Z | - |
| dc.date.issued | 2017 | en_US |
| dc.identifier.isbn | 9781484231203 ; (electronic bk.) ; | en_US |
| dc.identifier.isbn | 1484231201 ; (electronic bk.) ; | en_US |
| dc.identifier.isbn | 9781484231197 ; | en_US |
| dc.identifier.uri | http://localhost/handle/Hannan/1596 | - |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | Ohio Library and Information Network ; | en_US |
| dc.description | Available to OhioLINK libraries ; | en_US |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | en_US | |
| dc.description | Print version: ; Bartholomew, Daniel ; MariaDB and MySQL Common Table Expressions and Window Functions Revealed ; Berkeley, CA : Apress,c2017 ; 9781484231197 ; | en_US |
| dc.description.statementofresponsibility | Daniel Batholomew | en_US |
| dc.description.tableofcontents | ""Contents at a Glance""; ""Contents""; ""About the Author""; ""About the Technical Reviewer""; ""Acknowledgments""; ""Introduction""; ""Syntax""; ""Part I: Common Table Expressions""; ""Chapter 1: Basics of Common Table Expressions""; ""Before We Begin""; ""What Are Common Table Expressionse""; ""Basic CTE Syntax""; ""The Motivation for CTEs""; ""Temporary""; ""Readable""; ""Using in One or Many Places""; ""Permissions""; ""Nesting""; ""Multiplexing""; ""Recursion""; ""Summary""; ""Chapter 2: Non-recursive Common Table Expressions""; ""Before We Begin"" ; | en_US |
| dc.description.tableofcontents | ""Using CTEs for Year-over-Year Comparisons""""Comparing Individuals Against Their Group""; ""Translating Subqueries into CTEs""; ""Summary""; ""Chapter 3: Recursive Common Table Expressions""; ""Before We Begin""; ""Recursive CTE Syntax""; ""Adding Numbers""; ""Calculating Fibonacci Numbers""; ""Looking Up Ancestors in a Tree""; ""Finding All Possible Destinations""; ""Finding All Possible Paths""; ""Summary""; ""Part II: Window Functions""; ""Chapter 4: Basics of Window Functions""; ""What Is a functione""; ""Window Function Syntax""; ""Partition Definition Syntax"" ; | en_US |
| dc.description.tableofcontents | ""Order Definition Syntax""""Frame Definition Syntax""; ""WINDOW Clause Syntax""; ""Window Functions Reference""; ""AVG()""; ""BIT_AND()""; ""BIT_OR()""; ""BIT_XOR()""; ""COUNT()""; ""CUME_DIST()""; ""DENSE_RANK()""; ""FIRST_VALUE()""; ""LAG()""; ""LAST_VALUE()""; ""LEAD()""; ""NTH_VALUE()""; ""NTILE""; ""PERCENT_RANK()""; ""RANK()""; ""ROW_NUMBER()""; ""SUM()""; ""Summary""; ""Chapter 5: Recognizing Opportunities for Window Functions""; ""Partitioning and Ordering Results""; ""Maintaining a Running Total""; ""Ranking Rows in a Result Set""; ""Summary"" ; | en_US |
| dc.description.tableofcontents | ""Chapter 6: Window Functions in Practice""""Before We Begin""; ""Working with Time-Series Data""; ""Using Multiple Window Functions at Once""; ""Graphing Time-Series Results""; ""Analyzing Fruit Sales""; ""Fruit Sales Within a Single Store""; ""Comparing Fruit Sales Across All Stores""; ""Summary""; ""Chapter 7: Combining Window Functions and CTEs""; ""Before We Begin""; ""Compute the Average Time Between Days with Precipitation""; ""Adding a Primary Key Column""; ""Finding Gaps and Islands""; ""Gaps""; ""Islands""; ""Summary"" ; | en_US |
| dc.format.extent | 1 online resource (116 p.) ; | en_US |
| dc.publisher | Apress, | en_US |
| dc.relation.haspart | 9781484231203.pdf | en_US |
| dc.subject | MySQL (Electronic resource) ; | en_US |
| dc.subject | Querying (Computer science) ; | en_US |
| dc.title | MariaDB and MySQL common table Expressions and Window functions revealed | en_US |
| dc.type | Book | en_US |
| dc.publisher.place | Berkeley, CA : | en_US |
| dc.classification.lc | QA76.9.D3 ; | en_US |
| Appears in Collections: | مهندسی فناوری اطلاعات | |
Files in This Item:
| File | Description | Size | Format | |
|---|---|---|---|---|
| 9781484231203.pdf | 2.36 MB | Adobe PDF | Preview File |