PostgreSQL Functions Playbook

سرفصل های دوره

Most programming languages come with built-in functions and SQL is no exception. In this course, you'll learn about the ANSI SQL functions and operators implemented by PostgreSQL and a good portion of the of those unique to this popular system.

1. Course Overview

1. Course Overview

2. Introducing Built In Functions in PostgreSQL

1. Introducing the Course

2. Setting up the Working Environment

3. Installing PostgreSQL in a Docker Container

4. Loading the Sample Database

5. Module Summary

03. Understanding Data Types

01. Introducing Data Types in PostgreSQL

02. Character Types

03. Binary Types

04. Numeric Types

05. Date, Time, and Interval Types

06. The Boolean Type

07. Array Types

08. The UUID Type

09. The XML Type

10. The JSON Type

11. Range Types

12. Module Summary

4. Doing Math with Operators and Functions

1. Introducing Math Operators and Functions

2. Using the Math Operators

3. Working with the Scalar Functions

4. Computing Trigonometric Values

5. Aggregating Data

6. Analyzing Data with Statistical Functions

7. Converting and Formatting Numeric Data

8. Module Summary

5. Handling Character Data with String Functions and Operators

1. Introduction and Overview

2. Using ANSI Functions and Operators

3. Using PostgreSQL Extensions

4. Aggregating Textual Data

5. Pattern Matching with ANSI Operators

6. Matching Using Regular Expressions

7. Searching Natural Language Documents

8. Converting and Formatting Character Data

9. Module Summary

6. Time Travel with Date and Time Functions

1. Introduction and Overview

2. Building and Parsing Dates and Times

3. Using Math Operators

4. ANSI Functions and PostgreSQL Extensions

5. Improving Accuracy with EPOC

6. Converting and Formatting Dates and Times

7. Module Summary

7. Calculating Values over Row Groups Using Windowing Functions

1. Introduction and Overview

2. A Motivating Example

3. Understanding How Windowing Works

4. Basic Windowing Syntax

5. Ordering the Rows in a Window Frame

6. Limiting the Rows to be Processed

7. Reviewing the Full Syntax

8. Module Summary

8. Controlling Results with Subquery and Conditional Functions

1. Introduction and Overview

2. Using the EXISTS Function

3. Using the IN Function

4. Using the ANY (SOME) Function

5. Using the ALL Function

6. Module Summary

9. Using Array and Range Functions

1. Introduction and Overview

2. Constructing Arrays and Ranges

3. Using Operators on Ranges and Arrays

4. Specialized Range and Array Functions

5. Array Comparisons Using IN, ALL, ANY and SOME

6. Converting and Formatting Ranges and Arrays

7. Module Summary

10. Digging into Metadata with System Information and Administration Functions

1. Introduction

2. Viewing the Information Schema Views

3. Using System Information Functions

4. Exploring System Administration Functions

5. Module Summary

11. Course Summary

1. Course Summary

139,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight