Download Advanced SQL Queries in Oracle and SQL Server [2013, ENG] Torrent

Advanced SQL Queries in Oracle and SQL Server [2013, ENG]

01.Analytic Functions - Part 1

01.Course Introduction.wmv	WMV	4.11 MB
02.Introduction to Part I.wmv	WMV	1.55 MB
03.What are Analytic Functions.wmv	WMV	7.98 MB
04.Motivational Examples.wmv	WMV	10.9 MB
05.PARTITION BY Clause.wmv	WMV	2.66 MB
06.PARTITION BY Examples.wmv	WMV	9.34 MB
07.RATIO_TO_REPORT Function.wmv	WMV	6.25 MB
08.Summary.wmv	WMV	733.03 KB

02.Analytic Functions - Part 2

01.Introduction to Part II.wmv	WMV	1.46 MB
02.ORDER BY Clause.wmv	WMV	3.19 MB
03.ROW_NUMBER Function.wmv	WMV	4.86 MB
04.LISTAGG Function.wmv	WMV	6.09 MB
05.LEAD and LAG Functions.wmv	WMV	5.12 MB
06.LEAD and LAG Examples 1.wmv	WMV	5.97 MB
07.LEAD and LAG Examples 2.wmv	WMV	5.2 MB
08.RANK and DENSE_RANK Functions.wmv	WMV	6.9 MB
09.FIRST_VALUE and LAST_VALUE Functions.wmv	WMV	6.17 MB
10.Summary.wmv	WMV	586.44 KB

03.Analytic Functions - Part 3

04.Analytic Functions - Part 4

01.Introduction to Part IV.wmv	WMV	1.76 MB
02.KEEP Clause.wmv	WMV	8.15 MB
03.KEEP Clause Examples.wmv	WMV	7.95 MB
04.Statistics-Related Analytic Functions.wmv	WMV	4.76 MB
05.MEDIAN Function and Examples.wmv	WMV	2.61 MB
06.NTILE Function and Examples.wmv	WMV	7.07 MB
07.CUME_DIST Function and Examples.wmv	WMV	5.5 MB
08.PERCENT_RANK Function and Examples.wmv	WMV	4.26 MB
09.PERCENTILE_DISC Function and Examples.wmv	WMV	6.25 MB
10.PERCENTILE_CONT Function and Examples.wmv	WMV	4.38 MB
11.Summary.wmv	WMV	366.37 KB

05.Extensions to GROUP BY

01.Introduction.wmv	WMV	6.34 MB
02.A Comment about SQL Server 2005.wmv	WMV	1.96 MB
03.A Warning about Temporary Space.wmv	WMV	3.87 MB
04.Motivational Example.wmv	WMV	6.68 MB
05.GROUPING SETS.wmv	WMV	5.95 MB
06.ROLLUP.wmv	WMV	7.41 MB
07.CUBE.wmv	WMV	5.03 MB
08.Composite Columns.wmv	WMV	3.8 MB
09.Using Multiple Extensions.wmv	WMV	5.54 MB
10.GROUPING Function.wmv	WMV	8.18 MB
11.GROUPING_ID Function.wmv	WMV	5.41 MB
12.GROUP_ID Function.wmv	WMV	5.26 MB
13.Summary.wmv	WMV	1.15 MB

06.The WITH Clause - Part 1

01.Introduction to Part I.wmv	WMV	3.17 MB
02.Non-Recursive WITH Clause.wmv	WMV	10.61 MB
03.Non-Recursive WITH Syntax.wmv	WMV	2.21 MB
04.CREATE TABLE and The WITH Clause.wmv	WMV	1.16 MB
05.Using Previously Defined WITH Clauses.wmv	WMV	4.26 MB
06.Summary.wmv	WMV	486.68 KB

07.The WITH Clause - Part 2

01.Introduction to Part II.wmv	WMV	6.41 MB
02.Recursive WITH Clause.wmv	WMV	13.4 MB
03.Anchor and Recursive Queries.wmv	WMV	7.95 MB
04.Recursive WITH Example #1.wmv	WMV	15.21 MB
05.Recursive WITH Example #2.wmv	WMV	9.68 MB
06.Recursive WITH Example #3.wmv	WMV	6.86 MB
07.MAXRECURSION Option.wmv	WMV	2.7 MB
08.SEARCH and SET Options.wmv	WMV	9.74 MB
09.Cycle Option and Summary.wmv	WMV	6.81 MB

08.The PIVOT and UNPIVOT Features

01.Introduction.wmv	WMV	3.39 MB
02.Vintage Data Transposition Introduction.wmv	WMV	882.79 KB
03.Vintage Data Transposition Columns to Rows.wmv	WMV	9.31 MB
04.Vintage Data Transposition Rows to Columns.wmv	WMV	4.58 MB
05.Modern Data Transposition Introduction.wmv	WMV	759.57 KB
06.Modern Data Transposition Columns to Rows.wmv	WMV	12.93 MB
07.Modern Data Transposition Rows to Columns.wmv	WMV	8.07 MB
08.Oracle-Specific Extensions.wmv	WMV	3.43 MB
09.Multi-Column PIVOT Introduction.wmv	WMV	1.78 MB
10.Oracle Extension to IN Function.wmv	WMV	4.4 MB
11.Multi-Column PIVOT Examples.wmv	WMV	3.68 MB
12.Summary.wmv	WMV	366.38 KB

09.The MERGE Statement

01.Introduction.wmv	WMV	8.66 MB
02.Reminder of Old Friends.wmv	WMV	4.08 MB
03.Life without The MERGE Statement.wmv	WMV	1.92 MB
04.MERGE Syntax.wmv	WMV	6.34 MB
05.MERGE Example.wmv	WMV	3.96 MB
06.Additional Conditions.wmv	WMV	2.53 MB
07.DELETE and Summary.wmv	WMV	4.35 MB

10.PARTITION BY-RIGHT OUTER JOIN

ZIP

2.95 MB

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
Udemy - Master SQL - Beginner to Advanced + Interview Questions Posted by freecoursewb in Other Posted in Other 6 2.7 GB 6 months ago freecoursewb	Size 2.7 GB	Files 43	Age 6 months ago	Seeds 6	Leechs 7	Source
Udemy - SQL Querying For Beginners - From Basics To Advanced Data Posted by freecoursewb in Other Posted in Other 9 873.4 MB 8 months ago freecoursewb	Size 873.4 MB	Files 27	Age 8 months ago	Seeds 9	Leechs 2	Source
Udemy - SQL for Data Analysis - Beginner to Advanced Posted by freecoursewb in Other Posted in Other 10 2.2 GB 11 months ago freecoursewb	Size 2.2 GB	Files 118	Age 11 months ago	Seeds 10	Leechs 0	Source
SQL for Data Analysis - Advanced SQL Querying Techniques (2025) Posted by freecoursewb in Other Posted in Other 5 3 GB 1 year ago freecoursewb	Size 3 GB	Files 97	Age 1 year ago	Seeds 5	Leechs 1	Source
Udemy - Mastering Sql - From Fundamentals To Advanced Queries Posted by freecoursewb in Other Posted in Other 8 675.4 MB 2 years ago freecoursewb	Size 675.4 MB	Files 13	Age 2 years ago	Seeds 8	Leechs 20	Source

Advanced SQL Queries in Oracle and SQL Server [2013, ENG]

Tracker name
http://bt2.t-ru.org/ann?magnet
http://bt1.t-ru.org/ann
http://bt2.t-ru.org/ann
http://bt4.t-ru.org/ann
udp://tracker.opentrackr.org:1337
udp://open.stealth.si:80/announce
udp://tracker.torrent.eu.org:451/announce
udp://exodus.desync.com:6969
udp://open.demonii.com:1337/announce
udp://tracker.coppersurfer.tk:6969
udp://p4p.arenabg.com:1337
udp://tracker.internetwarriors.net:1337