Pluralsight Com - Combining and Filtering Data with MariaDB (2019 ENG)
File List
| File | Size |
|---|---|
| 00. Course Overview/00_01. Course Overview.mp4 | 2.77 MB |
| 01. Aggregating Results with GROUP BY/01_01. Introduction.mp4 | 1.18 MB |
| 01. Aggregating Results with GROUP BY/01_02. GROUP BY.mp4 | 3.92 MB |
| 01. Aggregating Results with GROUP BY/01_03. Common Aggregate Functions.mp4 | 1.66 MB |
| 01. Aggregating Results with GROUP BY/01_04. Demo - Common Aggregate Functions - Avg.mp4 | 21.91 MB |
| 01. Aggregating Results with GROUP BY/01_05. Demo - Common Aggregate Functions - Sum, Min, Max, Count.mp4 | 22.75 MB |
| 01. Aggregating Results with GROUP BY/01_06. Summary.mp4 | 1.85 MB |
| 02. Manipulating String and Numeric Column Fields/02_01. Introduction.mp4 | 1.19 MB |
| 02. Manipulating String and Numeric Column Fields/02_02. Manipulating String and Numbers.mp4 | 1.79 MB |
| 02. Manipulating String and Numeric Column Fields/02_03. Demo - Manipulating String Data.mp4 | 32.65 MB |
| 02. Manipulating String and Numeric Column Fields/02_04. Demo - Manipulating Numeric Data.mp4 | 22.34 MB |
| 02. Manipulating String and Numeric Column Fields/02_05. Summary.mp4 | 1.91 MB |
| 03. Using Common Table Expressions for Efficiency/03_01. Introduction.mp4 | 1.42 MB |
| 03. Using Common Table Expressions for Efficiency/03_02. Common Table Expressions (CTEs).mp4 | 4.58 MB |
| 03. Using Common Table Expressions for Efficiency/03_03. Demo - Non-recursive CTE.mp4 | 21.64 MB |
| 03. Using Common Table Expressions for Efficiency/03_04. Demo - Recursive CTE.mp4 | 34.45 MB |
| 03. Using Common Table Expressions for Efficiency/03_05. Summary.mp4 | 1.45 MB |
| 04. Combining Data from Two or More Tables using Joins/04_01. Introduction.mp4 | 1.51 MB |
| 04. Combining Data from Two or More Tables using Joins/04_02. SQL Join.mp4 | 1.86 MB |
| 04. Combining Data from Two or More Tables using Joins/04_03. Inner Join.mp4 | 3.85 MB |
| 04. Combining Data from Two or More Tables using Joins/04_04. Demo - Inner Join.mp4 | 30.83 MB |
| 04. Combining Data from Two or More Tables using Joins/04_05. Left Outer Join.mp4 | 2.71 MB |
| 04. Combining Data from Two or More Tables using Joins/04_06. Right Outer Join.mp4 | 2.47 MB |
| 04. Combining Data from Two or More Tables using Joins/04_07. Demo - Outer Join.mp4 | 20.62 MB |
| 04. Combining Data from Two or More Tables using Joins/04_08. Cross Join.mp4 | 2.94 MB |
| 04. Combining Data from Two or More Tables using Joins/04_09. Demo - Cross Join.mp4 | 8.26 MB |
| 04. Combining Data from Two or More Tables using Joins/04_10. Summary.mp4 | 1.91 MB |
| 05. Limiting Results with Windowing Functions/05_01. Introduction.mp4 | 2.61 MB |
| 05. Limiting Results with Windowing Functions/05_02. Window Functions.mp4 | 4.14 MB |
| 05. Limiting Results with Windowing Functions/05_03. Window Function Syntax.mp4 | 1.66 MB |
| 05. Limiting Results with Windowing Functions/05_04. Demo - Ranking Window Function.mp4 | 45.73 MB |
| 05. Limiting Results with Windowing Functions/05_05. Demo - Value Window Function.mp4 | 28.88 MB |
| 05. Limiting Results with Windowing Functions/05_06. Demo - Aggregate Window Function.mp4 | 27.08 MB |
| 05. Limiting Results with Windowing Functions/05_07. Summary.mp4 | 1.87 MB |
| 06. Combining Results Set of Multiple SELECT with UNION/06_01. Introduction.mp4 | 1.73 MB |
| 06. Combining Results Set of Multiple SELECT with UNION/06_02. UNION Queries.mp4 | 5.51 MB |
| 06. Combining Results Set of Multiple SELECT with UNION/06_03. Demo - Basics of UNION Queries.mp4 | 19.17 MB |
| 06. Combining Results Set of Multiple SELECT with UNION/06_04. Demo - Real World Scenario for UNION Statement.mp4 | 19.97 MB |
| 06. Combining Results Set of Multiple SELECT with UNION/06_05. Summary.mp4 | 2.15 MB |
| 07. Summary/07_01. Summary.mp4 | 6.46 MB |
| Exercise_Files/Combining-Filtering-Data-MariaDB.zip | 3.41 MB |
| Exercise_Files/Sakila-DB.zip | 712.32 KB |
| Exercise_Files/subtitles_EN.zip | 100.88 KB |
Trackers
No trackers found.