download скачать Free download скачать : Pluralsight - Querying Data with SQL from PostgreSQL
mp4 | Video: h264,1280X720 | Audio: AAC, 44.1 KHz
Genre:eLearning | Language: English | Size:1.16 GB

Files Included :

1  Course Overview.mp4 (3.27 MB)
MP4
1  Introducing the Course.mp4 (4.33 MB)
MP4
2  Setting up the Working Environment.mp4 (4.17 MB)
MP4
3  Installing PostgreSQL in a Docker Container.mp4 (11.41 MB)
MP4
4  Loading the Sample Database.mp4 (9.84 MB)
MP4
5  Module Summary.mp4 (856.46 KB)
MP4
1  Introduction to Creating Functions.mp4 (1.21 MB)
MP4
2  Creating Your First Function.mp4 (9 MB)
MP4
3  Adding Input Arguments and Return Types.mp4 (4.29 MB)
MP4
4  Working with Output Arguments.mp4 (6.03 MB)
MP4
5  Using Arguments in Function Calls.mp4 (4.68 MB)
MP4
6  Module Summary.mp4 (877.97 KB)
MP4
1  Introduction to PLpgSQL.mp4 (2.07 MB)
MP4
2  PLpgSQL Program Structure.mp4 (5.09 MB)
MP4
3  Defining and Using Variables.mp4 (7.64 MB)
MP4
4  Executing Queries in PLpgSQL.mp4 (9.36 MB)
MP4
5  Using Control Structures.mp4 (8.08 MB)
MP4
6  Iterating over Row Sets and More.mp4 (9.51 MB)
MP4
7  Writing Cursors for Iteration.mp4 (7.91 MB)
MP4
8  Building and Executing Dynamic Queries.mp4 (12.72 MB)
MP4
9  Summary.mp4 (1.79 MB)
MP4
1  Introduction and Overview.mp4 (2.05 MB)
MP4
2  Polymorphism in Object Oriented Programming.mp4 (2.03 MB)
MP4
3  Writing Ad Hoc Polymorphic Functions.mp4 (7.27 MB)
MP4
4  Using Subtype Polymorphism.mp4 (3.69 MB)
MP4
5  Creating Parametric Polymorphic Functions.mp4 (6.36 MB)
MP4
6  Writing Variadic Functions.mp4 (3.04 MB)
MP4
7  Avoiding Ambiguous Function Definitions.mp4 (2.3 MB)
MP4
8  Summary.mp4 (1.76 MB)
MP4
1  Introduction and Overview.mp4 (3.83 MB)
MP4
2  Implementing Permissions Using Double Abstraction.mp4 (2.59 MB)
MP4
3  Demo - Least Permissions and Double Abstraction.mp4 (4.18 MB)
MP4
4  Understanding Function Security Attributes.mp4 (2.5 MB)
MP4
5  Demo - Using Function Security Attributes.mp4 (10.1 MB)
MP4
6  Demo - Using Schemas.mp4 (8.8 MB)
MP4
7  Summary.mp4 (1.7 MB)
MP4
1  Introduction and Overview.mp4 (2.98 MB)
MP4
2  Demo 1 - Making False Assumptions.mp4 (6.89 MB)
MP4
3  Demo 2 - Ensuring Consistent Environment Settings.mp4 (4.86 MB)
MP4
4  Demo 3 - Preparing for Database Changes.mp4 (5.96 MB)
MP4
5  Demo 4 - Handling Errors.mp4 (6.66 MB)
MP4
6  Demo 5 - Error Handling for Concurrency Problems.mp4 (8.14 MB)
MP4
7  Module Summary.mp4 (2.04 MB)
MP4
1  Course Summary.mp4 (9.51 MB)
MP4
1   Course Overview.mp4 (3.62 MB)
MP4
1   Version Check.mp4 (517.2 KB)
MP4
2  Overview.mp4 (1014.51 KB)
MP4
3   Introduction to Data Types.mp4 (2.82 MB)
MP4
4   Concatenating Strings.mp4 (4.27 MB)
MP4
5   Trimming Fields.mp4 (3.83 MB)
MP4
6   Isolating Parts of a String.mp4 (6.12 MB)
MP4
7   Changing Cases or Characters.mp4 (2.18 MB)
MP4
8   Demo Applying String Functions.mp4 (6.88 MB)
MP4
9   Summary.mp4 (872.93 KB)
MP4
1   Overview.mp4 (954.66 KB)
MP4
2   Introduction to Numeric Data.mp4 (2.72 MB)
MP4
3  Arithmetic Operators.mp4 (3.73 MB)
MP4
4   Aggregate Functions.mp4 (4.48 MB)
MP4
5   Aggregate Functions in Action.mp4 (8.13 MB)
MP4
6   Filtering Aggregate Results.mp4 (3.81 MB)
MP4
7   Summary.mp4 (962 KB)
MP4
1   Overview.mp4 (1.45 MB)
MP4
2   Keys to the Relationship.mp4 (3 MB)
MP4
3   Inner Joins.mp4 (8.03 MB)
MP4
4  Table Aliases.mp4 (3.87 MB)
MP4
5   Outer Joins.mp4 (8.24 MB)
MP4
6   Full Joins.mp4 (3.01 MB)
MP4
7   Implementing Joins.mp4 (16.47 MB)
MP4
8   Summary.mp4 (1.55 MB)
MP4
1  Overview.mp4 (667.08 KB)
MP4
2   Concept of Set Theory.mp4 (1.8 MB)
MP4
3   Unions.mp4 (5.9 MB)
MP4
4   Intersections.mp4 (2.95 MB)
MP4
5   Exceptions.mp4 (4.06 MB)
MP4
6   Demo UNIONing Result Sets.mp4 (3.45 MB)
MP4
7   Summary.mp4 (1.02 MB)
MP4
1   Overview.mp4 (814.74 KB)
MP4
2   Defining Subqueries.mp4 (3.5 MB)
MP4
3   Subqueries and Joins.mp4 (3.37 MB)
MP4
4   Demo Writing a Subquery.mp4 (3.47 MB)
MP4
5   Correlated Subqueries.mp4 (6.14 MB)
MP4
6   Demo Correlated Subquery in Action.mp4 (4.79 MB)
MP4
7   Summary.mp4 (836.11 KB)
MP4
1   Overview.mp4 (1008.44 KB)
MP4
2   Defining CTEs.mp4 (2.2 MB)
MP4
3  CTEs and Subqueries.mp4 (2.08 MB)
MP4
4   Demo Using a CTE.mp4 (7.43 MB)
MP4
5   Recursive CTEs.mp4 (2.83 MB)
MP4
6   Summary.mp4 (732.5 KB)
MP4
1   Overview.mp4 (1.12 MB)
MP4
10   Summary.mp4 (1.08 MB)
MP4
2   Defining the Window.mp4 (2.13 MB)
MP4
3   Ranking and Numbering Rows.mp4 (5.94 MB)
MP4
4  Demo Applying Rank Functions.mp4 (8.22 MB)
MP4
5   Special Values and Reusing Windows.mp4 (5.44 MB)
MP4
6   Lagging and Leading.mp4 (2.51 MB)
MP4
7   Aggregate Window Functions.mp4 (2.78 MB)
MP4
8   Order of Evaluation.mp4 (2.52 MB)
MP4
9   Demo Lag and Window Function Calculation.mp4 (4.65 MB)
MP4
1   Overview.mp4 (620.17 KB)
MP4
10   Applying String Functions.mp4 (3.91 MB)
MP4
11  Summary.mp4 (406.81 KB)
MP4
2   Selecting Data to Explore.mp4 (1.47 MB)
MP4
3   Joining Tables.mp4 (1.68 MB)
MP4
4   Aggregating Results.mp4 (4.1 MB)
MP4
5   Applying Set Theory.mp4 (3.15 MB)
MP4
6   Using a Subquery.mp4 (2.47 MB)
MP4
7   Simplifying Queries with CTEs.mp4 (2.21 MB)
MP4
8   Correlating a Subquery.mp4 (3.71 MB)
MP4
9   Ranking our Results.mp4 (4.67 MB)
MP4
01  Module Introduction.mp4 (1.3 MB)
MP4
02  READ UNCOMMITTED.mp4 (1.4 MB)
MP4
03  READ COMMITTED.mp4 (5.36 MB)
MP4
04  READ COMMITTED - DEMO.mp4 (9.27 MB)
MP4
05  REPEATABLE READ.mp4 (2.76 MB)
MP4
06  REPEATABLE READ - DEMO.mp4 (5.03 MB)
MP4
07  Isolation Costs.mp4 (1.5 MB)
MP4
08  SERIALIZABLE.mp4 (2.81 MB)
MP4
09  Notice and Takeaway.mp4 (2.73 MB)
MP4
10  Module Review.mp4 (749.4 KB)
MP4
01  Module Introduction.mp4 (971.35 KB)
MP4
02  Syntax Conventions.mp4 (1.23 MB)
MP4
03  INSERT Syntax Overview.mp4 (2.42 MB)
MP4
04  Inserting Literal Values.mp4 (864.69 KB)
MP4
05  Code Demo - Inserting Literal Values.mp4 (5.55 MB)
MP4
06  Inserting Default Values.mp4 (1.73 MB)
MP4
07  Code Demo - Inserting Default Values.mp4 (3.62 MB)
MP4
08  Inserting a Query Result Set.mp4 (1.11 MB)
MP4
09  Code Demo - Inserting a Query Result Set.mp4 (2.41 MB)
MP4
10  Inserting Data through Views.mp4 (4.01 MB)
MP4
11  Code Demo - Inserting Data through Views.mp4 (2.08 MB)
MP4
12  Handling Conflicts.mp4 (2.82 MB)
MP4
13  Code Demo - Handling Conflicts.mp4 (4.75 MB)
MP4
14  Returning Data from INSERT.mp4 (1.72 MB)
MP4
15  Code Demo - Returning Data from INSERT.mp4 (5.82 MB)
MP4
16  Module Review.mp4 (1.91 MB)
MP4
01  Module Introduction.mp4 (829.49 KB)
MP4
02  UPDATE Syntax.mp4 (2.85 MB)
MP4
03  Updating Column Values.mp4 (2.54 MB)
MP4
04  Code Demo - Updating Column Values.mp4 (5.07 MB)
MP4
05  Limiting the UPDATE Scope.mp4 (756.17 KB)
MP4
06  Code Demo - Limiting the UPDATE Scope.mp4 (6.21 MB)
MP4
07  Updating through Views.mp4 (653.74 KB)
MP4
08  Returning Data from UPDATE.mp4 (763.84 KB)
MP4
09  Code Demo - Returning Data from UPDATE.mp4 (4.4 MB)
MP4
10  Module Review.mp4 (737.84 KB)
MP4
1  Course Overview.mp4 (4.6 MB)
MP4
1  Module Introduction.mp4 (1003.65 KB)
MP4
2  TRUNCATE.mp4 (3.9 MB)
MP4
3  Deleting All Rows.mp4 (1.64 MB)
MP4
4  Large DELETE Optimizations.mp4 (7.1 MB)
MP4
5  Code Demo - Bulk Deletes - Part 1.mp4 (17.95 MB)
MP4
6  Code Demo - Bulk Deletes - Part 2.mp4 (23.59 MB)
MP4
7  Module Review.mp4 (615.84 KB)
MP4
1  Module Introduction.mp4 (682.63 KB)
MP4
2  Course Review.mp4 (8.93 MB)
MP4
3  Take Away.mp4 (3.5 MB)
MP4
4  Feedback.mp4 (1.14 MB)
MP4
5  Next Steps.mp4 (1.2 MB)
MP4
6  Additional Resources.mp4 (2.09 MB)
MP4
7  Thank You.mp4 (435.38 KB)
MP4
1  Version Check.mp4 (505.67 KB)
MP4
2  Module Introduction.mp4 (1.28 MB)
MP4
3  Data Definition Language (DDL).mp4 (1.82 MB)
MP4
4  Data Control Language (DCL).mp4 (2.08 MB)
MP4
5  Data Manipulation Language (DML).mp4 (1.68 MB)
MP4
6  Data Query Language (DQL).mp4 (1.42 MB)
MP4
7  Data Transaction Language (DTL).mp4 (1.48 MB)
MP4
8  Imperative Constructs.mp4 (2.47 MB)
MP4
9  Module Review.mp4 (747.76 KB)
MP4
1  Module Introduction.mp4 (973.59 KB)
MP4
2  Overview of Concurrency Conflicts.mp4 (5.07 MB)
MP4
3  ACID Properties Guarantees.mp4 (8.44 MB)
MP4
4  Isolation Implementation Paradigms.mp4 (10.17 MB)
MP4
5  Takeaway.mp4 (2.01 MB)
MP4
6  Module Review.mp4 (597.63 KB)
MP4
1  Module Introduction.mp4 (1.15 MB)
MP4
2  Lost Update.mp4 (2.74 MB)
MP4
3  Dirty Read.mp4 (2.9 MB)
MP4
4  Non-Repeatable Read.mp4 (2.27 MB)
MP4
5  Phantom Rows.mp4 (2.55 MB)
MP4
6  Module Review.mp4 (1.46 MB)
MP4
1  Module Introduction.mp4 (1014.48 KB)
MP4
2  Transaction Blocks.mp4 (2.23 MB)
MP4
3  Setting Transaction Properties.mp4 (3.62 MB)
MP4
4  Transaction Save Points.mp4 (2.57 MB)
MP4
5  DDL Transactions.mp4 (1.34 MB)
MP4
6  Demo - Using TCL.mp4 (12.8 MB)
MP4
7  Module Review.mp4 (728.18 KB)
MP4
1  Module Introduction.mp4 (661.18 KB)
MP4
2  DELETE Syntax.mp4 (1.97 MB)
MP4
3  Limiting DELETE Scope.mp4 (1.24 MB)
MP4
4  Code Demo - Limiting DELETE Scope.mp4 (11.03 MB)
MP4
5  Deleting through Views.mp4 (488.1 KB)
MP4
6  Code Demo - Deleting through Views.mp4 (2.39 MB)
MP4
7  Returning Data from DELETE.mp4 (1.3 MB)
MP4
8  Code Demo - Returning Data from DELETE.mp4 (3.27 MB)
MP4
9  Module Review.mp4 (852.59 KB)
MP4
01  Introducing Data Types in PostgreSQL.mp4 (4.18 MB)
MP4
02  Character Types.mp4 (4.08 MB)
MP4
03  Binary Types.mp4 (2.01 MB)
MP4
04  Numeric Types.mp4 (7.91 MB)
MP4
05  Date, Time, and Interval Types.mp4 (3.38 MB)
MP4
06  The Boolean Type.mp4 (1.16 MB)
MP4
07  Array Types.mp4 (2.03 MB)
MP4
08  The UUID Type.mp4 (1.83 MB)
MP4
09  The XML Type.mp4 (1.51 MB)
MP4
10  The JSON Type.mp4 (1.51 MB)
MP4
11  Range Types.mp4 (1.25 MB)
MP4
12  Module Summary.mp4 (772.29 KB)
MP4
1  Course Overview.mp4 (3.4 MB)
MP4
1  Introduction.mp4 (1.1 MB)
MP4
2  Viewing the Information Schema Views.mp4 (8.07 MB)
MP4
3  Using System Information Functions.mp4 (5.1 MB)
MP4
4  Exploring System Administration Functions.mp4 (3.75 MB)
MP4
5  Module Summary.mp4 (1.72 MB)
MP4
1  Course Summary.mp4 (10.92 MB)
MP4
1  Introducing the Course.mp4 (3.87 MB)
MP4
2  Setting up the Working Environment.mp4 (3.81 MB)
MP4
3  Installing PostgreSQL in a Docker Container.mp4 (10.29 MB)
MP4
4  Loading the Sample Database.mp4 (8.23 MB)
MP4
5  Module Summary.mp4 (841.42 KB)
MP4
1  Introducing Math Operators and Functions.mp4 (2.75 MB)
MP4
2  Using the Math Operators.mp4 (4.02 MB)
MP4
3  Working with the Scalar Functions.mp4 (6.28 MB)
MP4
4  Computing Trigonometric Values.mp4 (2.12 MB)
MP4
5  Aggregating Data.mp4 (4.06 MB)
MP4
6  Analyzing Data with Statistical Functions.mp4 (5.34 MB)
MP4
7  Converting and Formatting Numeric Data.mp4 (6.03 MB)
MP4
8  Module Summary.mp4 (1 MB)
MP4
1  Introduction and Overview.mp4 (2.6 MB)
MP4
2  Using ANSI Functions and Operators.mp4 (5.26 MB)
MP4
3  Using PostgreSQL Extensions.mp4 (6.98 MB)
MP4
4  Aggregating Textual Data.mp4 (4.53 MB)
MP4
5  Pattern Matching with ANSI Operators.mp4 (4.88 MB)
MP4
6  Matching Using Regular Expressions.mp4 (6.63 MB)
MP4
7  Searching Natural Language Documents.mp4 (6.86 MB)
MP4
8  Converting and Formatting Character Data.mp4 (6.82 MB)
MP4
9  Module Summary.mp4 (2.41 MB)
MP4
1  Introduction and Overview.mp4 (1.69 MB)
MP4
2  Building and Parsing Dates and Times.mp4 (5.21 MB)
MP4
3  Using Math Operators.mp4 (5.49 MB)
MP4
4  ANSI Functions and PostgreSQL Extensions.mp4 (5.32 MB)
MP4
5  Improving Accuracy with EPOC.mp4 (3.57 MB)
MP4
6  Converting and Formatting Dates and Times.mp4 (6.1 MB)
MP4
7  Module Summary.mp4 (1.31 MB)
MP4
1  Introduction and Overview.mp4 (2.37 MB)
MP4
2  A Motivating Example.mp4 (4.57 MB)
MP4
3  Understanding How Windowing Works.mp4 (1.95 MB)
MP4
4  Basic Windowing Syntax.mp4 (6.38 MB)
MP4
5  Ordering the Rows in a Window Frame.mp4 (6.88 MB)
MP4
6  Limiting the Rows to be Processed.mp4 (7.34 MB)
MP4
7  Reviewing the Full Syntax.mp4 (6.57 MB)
MP4
8  Module Summary.mp4 (1.68 MB)
MP4
1  Introduction and Overview.mp4 (2.31 MB)
MP4
2  Using the EXISTS Function.mp4 (10.09 MB)
MP4
3  Using the IN Function.mp4 (7 MB)
MP4
4  Using the ANY (SOME) Function.mp4 (5.38 MB)
MP4
5  Using the ALL Function.mp4 (1.86 MB)
MP4
6  Module Summary.mp4 (891.87 KB)
MP4
1  Introduction and Overview.mp4 (2.48 MB)
MP4
2  Constructing Arrays and Ranges.mp4 (5.08 MB)
MP4
3  Using Operators on Ranges and Arrays.mp4 (7.38 MB)
MP4
4  Specialized Range and Array Functions.mp4 (4.7 MB)
MP4
5  Array Comparisons Using IN, ALL, ANY and SOME.mp4 (2.98 MB)
MP4
6  Converting and Formatting Ranges and Arrays.mp4 (4.04 MB)
MP4
7  Module Summary.mp4 (1.07 MB)
MP4
1   Course Overview.mp4 (3.29 MB)
MP4
2   Version Check.mp4 (504.96 KB)
MP4
3   Overview.mp4 (1.8 MB)
MP4
4   Introduction to PostgreSQL.mp4 (2.21 MB)
MP4
5   Introduction to Relational Databases.mp4 (12.19 MB)
MP4
6  Summary.mp4 (563.83 KB)
MP4
10  Selecting Distinct Values.mp4 (5.9 MB)
MP4
11  Summary.mp4 (576.1 KB)
MP4
7  Overview.mp4 (2.16 MB)
MP4
8  Introduction to SELECT.mp4 (6.12 MB)
MP4
9   Explicit Selection.mp4 (6.58 MB)
MP4
12   Overview.mp4 (903.6 KB)
MP4
13  Introducing The WHERE Keyword.mp4 (2.4 MB)
MP4
14  Specific Conditions.mp4 (7.19 MB)
MP4
15   I LIKE Pattern Matching.mp4 (11.51 MB)
MP4
16  Null Values.mp4 (6.35 MB)
MP4
17  Putting It Together.mp4 (4.57 MB)
MP4
18  Operator Precedence.mp4 (4.94 MB)
MP4
19   Summary.mp4 (828.12 KB)
MP4
20  Overview.mp4 (1.08 MB)
MP4
21   Keys to the Relationship.mp4 (3.06 MB)
MP4
22  Inner Joins.mp4 (7.43 MB)
MP4
23  Table Aliases.mp4 (3.79 MB)
MP4
24  Outer Joins.mp4 (8.02 MB)
MP4
25  Full Joins.mp4 (2.8 MB)
MP4
26   Implementing Joins.mp4 (15.29 MB)
MP4
27   Summary.mp4 (1.51 MB)
MP4
28   Overview.mp4 (449.23 KB)
MP4
29  Sort Order.mp4 (3.52 MB)
MP4
30  Introduction to Aggregate Functions.mp4 (10.67 MB)
MP4
31  Filtering Aggregate Results.mp4 (3.82 MB)
MP4
32   Summary.mp4 (767.07 KB)
MP4
33   Summary.mp4 (9.35 MB)
MP4

 https://rapidgator.net/file/bad92f25d5a263911cd542e68ac17253/Pluralsight_-_Querying_Data_with_SQL_from_PostgreSQL.z01
https://rapidgator.net/file/4ca32136ea523645e803658e5890fd2a/Pluralsight_-_Querying_Data_with_SQL_from_PostgreSQL.zip

 https://ddownload.com/nxl6vipmse2b/Pluralsight_-_Querying_Data_with_SQL_from_PostgreSQL.z01
https://ddownload.com/n3ck9c4m9siv/Pluralsight_-_Querying_Data_with_SQL_from_PostgreSQL.zip

 https://nitroflare.com/view/4E0CC229BE3B1D9/Pluralsight_-_Querying_Data_with_SQL_from_PostgreSQL.z01
https://nitroflare.com/view/CE91C50FA2841A0/Pluralsight_-_Querying_Data_with_SQL_from_PostgreSQL.zip