Name Pluralsight.com - Combining and Filtering Data with MariaDB (2019 ENG)

File Type video

Size 427.55MB

UpdateDate 2024-10-19

hash *****7DE397557AB245FC8FEE8D754A37618455

Hot 1

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