Other
[ FreeCourseWeb com ] Udemy - The Advanced SQL Course 2021
Torrent info
Torrent Files List
Get Bonus Downloads Here.url (Size: 2.80 GB) (Files: 323)
Get Bonus Downloads Here.url
~Get Your Files Here !
01 Introduction & Course Set Up
001 Course Overview & Prerequisite Knowledge.en.srt
001 Course Overview & Prerequisite Knowledge.mp4
002 Oracle APEX Account Set Up.en.srt
002 Oracle APEX Account Set Up.mp4
003 Oracle APEX Overview.en.srt
003 Oracle APEX Overview.mp4
004 Dataset Installation (Automatic).en.srt
004 Dataset Installation (Automatic).mp4
005 (Optional) Manual Data Installation.html
006 Data Model Slides.pptx
006 Dataset Overview.en.srt
006 Dataset Overview.mp4
007 Dual Table.en.srt
007 Dual Table.mp4
008 Understanding Explain Plans In Oracle.en.srt
008 Understanding Explain Plans In Oracle.mp4
02 Data Cleansing And Manipulation
001 Section Overview.html
002 Coalesce and NVL.en.srt
002 Coalesce and NVL.mp4
003 Trim and Pad.en.srt
003 Trim and Pad.mp4
004 Greatest and Least.en.srt
004 Greatest and Least.mp4
005 Pivoting Tables.en.srt
005 Pivoting Tables.mp4
006 Unpivoting Tables.en.srt
006 Unpivoting Tables.mp4
007 Assignment Question 1.html
008 Assignment Question 1 Solution.en.srt
008 Assignment Question 1 Solution.mp4
009 Assignment Question 1 Solution (SQL Code).html
010 Assignment Question 2.html
010 COALESCE and NVL.pptx
011 Assignment Question 2 Solution.en.srt
011 Assignment Question 2 Solution.mp4
011 TRIM and PAD.pptx
012 Assignment Question 2 Solution (SQL Code).html
012 GREATEST and LEAST.pptx
013 PIVOT.pptx
014 UNPIVOT.pptx
03 Regular Expressions (RegEx)
001 Section Overview.html
002 Regular Expressions And Metacharacters.en.srt
002 Regular Expressions And Metacharacters.mp4
003 Pattern Matching With The '.' '+' '_' '_' Metacharacters.en.srt
003 Pattern Matching With The '.' '+' '_' '_' Metacharacters.mp4
004 Pattern Matching With The '_d' and '_w' Metacharacters.en.srt
004 Pattern Matching With The '_d' and '_w' Metacharacters.mp4
005 Pattern Matching With Intervals, Lists and Groups.en.srt
005 Pattern Matching With Intervals, Lists and Groups.mp4
006 Pattern Matching Continued.en.srt
006 Pattern Matching Continued.mp4
007 Introduction To RegEx Functions In Oracle.en.srt
007 Introduction To RegEx Functions In Oracle.mp4
008 REGEXP_LIKE & Assignment Questions.en.srt
008 REGEXP_LIKE & Assignment Questions.mp4
009 REGEXP_INSTR & Assignment Questions.en.srt
009 REGEXP_INSTR & Assignment Questions.mp4
010 REGEXP_SUBSTR & Assignment Questions.en.srt
010 REGEXP_SUBSTR & Assignment Questions.mp4
011 REGEXP_REPLACE & Assignment Questions.en.srt
011 REGEXP_REPLACE & Assignment Questions.mp4
012 Class Metacharacters.en.srt
012 Class Metacharacters.mp4
013 Concluding Thoughts On RegEx.en.srt
013 Concluding Thoughts On RegEx.mp4
014 Useful External Resources.html
022 Regular Expressions and Metacharacters.pptx
023 Pattern Matching 1.pptx
024 Pattern Matching 2.pptx
025 Pattern Matching 3.pptx
026 Pattern Matching 4.pptx
028 REGEXP_LIKE.pptx
029 REGEXP_INSTR.pptx
030 REGEXP_SUBSTR.pptx
031 REGEXP_REPLACE.pptx
04 Analytical (Window) Functions
001 Section Overview.html
002 Introduction to Analytical Functions.en.srt
002 Introduction to Analytical Functions.mp4
003 An Introduction To The Over Clause.en.srt
003 An Introduction To The Over Clause.mp4
004 The Over Clause - Partition By.en.srt
004 The Over Clause - Partition By.mp4
005 The Over Clause - Order By.en.srt
005 The Over Clause - Order By.mp4
006 An Introduction To Window Frames.en.srt
006 An Introduction To Window Frames.mp4
007 Window Frame - Rows.en.srt
007 Window Frame - Rows.mp4
008 Window Frame - Range.en.srt
008 Window Frame - Range.mp4
009 Window Frame - Default Behaviour.en.srt
009 Window Frame - Default Behaviour.mp4
010 Quick Note on Window Frames.en.srt
010 Quick Note on Window Frames.mp4
011 Main Types Of Window Functions.en.srt
011 Main Types Of Window Functions.mp4
012 Aggregate Functions - SUM, AVG, MAX, MIN and COUNT.en.srt
012 Aggregate Functions - SUM, AVG, MAX, MIN and COUNT.mp4
013 Analytical Functions - LAG, LEAD, NTILE and NTH_VALUE.en.srt
013 Analytical Functions - LAG, LEAD, NTILE and NTH_VALUE.mp4
014 Ranking Functions - ROW_NUMBER, RANK and DENSE_RANK.en.srt
014 Ranking Functions - ROW_NUMBER, RANK and DENSE_RANK.mp4
015 Distribution Functions - PERCENT_RANK and CUME_DIST.en.srt
015 Distribution Functions - PERCENT_RANK and CUME_DIST.mp4
016 Order of Execution.en.srt
016 Order of Execution.mp4
017 Practice Scenario Walkthrough 1.en.srt
017 Practice Scenario Walkthrough 1.mp4
018 Practice Scenario Walkthrough 2.en.srt
018 Practice Scenario Walkthrough 2.mp4
019 Practice Scenario Walkthrough 3.en.srt
019 Practice Scenario Walkthrough 3.mp4
020 Practice Scenario Walkthrough 4.en.srt
020 Practice Scenario Walkthrough 4.mp4
021 Assignment Data Preparation.en.srt
021 Assignment Data Preparation.mp4
022 Assignment Data Preparation (SQL Code).html
023 Assignment Question 1.html
024 Assignment Question 1 Solution.en.srt
024 Assignment Question 1 Solution.mp4
025 Assignment Question 1 Solution (SQL Code).html
026 Assignment Question 2.html
027 Assignment Question 2 Solution.en.srt
027 Assignment Question 2 Solution.mp4
028 Assignment Question 2 Solution (SQL Code).html
029 Assignment Question 3.html
030 Assignment Question 3 Solution.en.srt
030 Assignment Question 3 Solution.mp4
031 Assignment Question 3 Solution (SQL Code).html
032 BONUS (Running Totals)_ Assignment Question 4.html
033 BONUS (Running Totals)_ Assignment Question 4 Solution (SQL Code).html
036 Intro to Analytical Functions.pptx
038 Partition By.pptx
039 Order By.pptx
040 Window Frames.pptx
041 Window Frames - Rows.pptx
042 Window Frames - Range.pptx
043 Window Frames - Default.pptx
045 Types of Window Functions.pptx
047 Analytical Functions - LAG, LEAD, NTILE, NTH_VALUE.pptx
048 Ranking Functions.pptx
049 Distribution Functions.pptx
050 Order of Operations.pptx
05 Group By Extensions
001 Section Overview.html
002 Introduction To Group By Extensions.en.srt
002 Introduction To Group By Extensions.mp4
003 ROLLUP.en.srt
003 ROLLUP.mp4
004 CUBE.en.srt
004 CUBE.mp4
005 Quick Video On Why I Am Using NVL().en.srt
005 Quick Video On Why I Am Using NVL().mp4
006 GROUPING_ID Function.en.srt
006 GROUPING_ID Function.mp4
007 Grouping Sets.en.srt
007 Grouping Sets.mp4
008 Combining Columns.en.srt
008 Combining Columns.mp4
009 Useful External Resources.html
010 Assignment Question 1.html
011 Assignment Question 1 Solution.en.srt
011 Assignment Question 1 Solution.mp4
012 Assignment Question 1 Solution (SQL Code).html
013 Assignment Question 2.html
014 Assignment Question 2 Solution.en.srt
014 Assignment Question 2 Solution.mp4
015 Assignment Question 2 Solution (SQL Code).html
016 Assignment Question 3.html
017 Assignment Question 3 Solution.en.srt
017 Assignment Question 3 Solution.mp4
018 Assignment Question 3 Solution (SQL Code).html
069 Extensions To Group By Introduction.pptx
070 ROLLUP.pptx
071 CUBE.pptx
073 GROUPING_ID.pptx
074 Grouping Sets.pptx
075 Composite Columns.pptx
06 Hierarchical Queries
001 Section Overview.html
002 Introduction To Hierarchical Queries.en.srt
002 Introduction To Hierarchical Queries.mp4
003 The Connect By & Start With Clauses.en.srt
003 The Connect By & Start With Clauses.mp4
004 The Level Pseudocolumn.en.srt
004 The Level Pseudocolumn.mp4
005 CONNECT_BY_ROOT & SYS_CONNECT_BY_PATH.en.srt
005 CONNECT_BY_ROOT & SYS_CONNECT_BY_PATH.mp4
006 Ordering Your Hierarchical Query Results.en.srt
006 Ordering Your Hierarchical Query Results.mp4
007 Formatting Your Hierarchical Query.en.srt
007 Formatting Your Hierarchical Query.mp4
008 Filtering Your Results.en.srt
008 Filtering Your Results.mp4
009 Hierarchical Query Processing.html
010 Assignment Question 1.html
011 Assignment Question 1 Solution.en.srt
011 Assignment Question 1 Solution.mp4
012 Assignment Question 1 Solution (SQL Code).html
013 Assignment Question 2.html
014 Assignment Question 2 Solution.en.srt
014 Assignment Question 2 Solution.mp4
015 Assignment Question 2 Solution (SQL Code).html
016 Assignment Question 3.html
017 Assignment Question 3 Solution.en.srt
017 Assignment Question 3 Solution.mp4
018 Assignment Question 3 Solution (SQL Code).html
019 Assignment Question 4.html
020 Assignment Question 4 Solution.en.srt
020 Assignment Question 4 Solution.mp4
021 Assignment Question 4 Solution (SQL Code).html
087 Heirarchical Queries (HQ).pptx
088 Connect By Prior and Start With.pptx
089 LEVEL.pptx
090 Connect By Root and Connect By Path.pptx
091 Order By Siblings.pptx
07 Correlated Subqueries And Common Table Expressions (CTEs)
001 Section Overview.html
002 Recap On Subqueries.en.srt
002 Recap On Subqueries.mp4
003 Correlated Subqueries, Where Exists And Where Not Exists.en.srt
003 Correlated Subqueries, Where Exists And Where Not Exists.mp4
004 Common Table Expressions (CTEs).en.srt
004 Common Table Expressions (CTEs).mp4
005 Recursive CTEs.en.srt
005 Recursive CTEs.mp4
006 Assignment Question 1.html
007 Assignment Question 1 Solution.en.srt
007 Assignment Question 1 Solution.mp4
008 Assignment Question 1 Solution (SQL Code).html
009 Assignment Question 2.html
010 Assignment Question 2 Solution.en.srt
010 Assignment Question 2 Solution.mp4
011 Assignment Question 2 Solution (SQL Code).html
012 Assignment Question 3.html
013 Assignment Question 3 Solution.en.srt
013 Assignment Question 3 Solution.mp4
014 Assignment Question 3 Solution (SQL Code).html
108 Recap on Subqueries.pptx
109 Correlated Subqueries.pptx
110 CTE.pptx
111 Recursive CTE.pptx
08 Materialized Views
001 Section Overview.html
002 Quick Recap On Views.en.srt
002 Quick Recap On Views.mp4
003 What Are Materialized Views_.en.srt
003 What Are Materialized Views_.mp4
004 Syntax.en.srt
004 Syntax.mp4
005 Simple And Complex Materialized Views.en.srt
005 Simple And Complex Materialized Views.mp4
006 Refresh Types.en.srt
006 Refresh Types.mp4
007 On Commit _ On Demand.en.srt
007 On Commit _ On Demand.mp4
008 Manually Refreshing Your Materialized View.en.srt
008 Manually Refreshing Your Materialized View.mp4
009 Build Deferred.en.srt
009 Build Deferred.mp4
010 Query Rewrite.en.srt
010 Query Rewrite.mp4
011 Converting An Existing Table Into A Materialized View.en.srt
011 Converting An Existing Table Into A Materialized View.mp4
012 Additional Guidance.en.srt
012 Additional Guidance.mp4
013 Useful Links And Resources.html
124 Materialized Views - Syntax.pptx
125 Simple vs Complex MVs.pptx
126 MV - Refresh Types.pptx
127 On Commit vs On Demand.pptx
128 Manual Refresh Procedures.pptx
131 On Prebuilt Table.pptx
09 Appendix_ Manual Dataset Installation (Optional)
001 Countries Dataset Installation (Manual).en.srt
001 Countries Dataset Installation (Manual).mp4
002 Employees (EMP_DEPT) Dataset Installation (Manual).en.srt
002 Employees (EMP_DEPT) Dataset Installation (Manual).mp4
003 Customer Orders Dataset Installation (Manual).en.srt
003 Customer Orders Dataset Installation (Manual).mp4
Countries
DDL Script
Countries DDL.sql
DS_Store
Data file
eba_countries.xml
eba_country_intermediates.xml
eba_country_organizations.xml
eba_country_regions.xml
eba_country_sub_regions.xml
Customer Orders
DDL Script
Customer Orders DDL.sql
DS_Store
DS_Store
Data File
customers.xml
order_items.xml
orders.xml
products.xml
stores.xml
Employees
DDL Script
Employees DDL.sql
DS_Store
Data File
dept.xml
emp.xml
__MACOSX
Countries
DDL Script
_Countries DDL.sql
Data file
_eba_countries.xml
_eba_country_intermediates.xml
_eba_country_organizations.xml
_eba_country_regions.xml
_eba_country_sub_regions.xml
_.DS_Store
_DDL Script
Customer Orders
DDL Script
_.DS_Store
_Customer Orders DDL.sql
Data File
_customers.xml
_order_items.xml
_orders.xml
_products.xml
_stores.xml
_.DS_Store
_DDL Script
_Data File
Employees
DDL Script
_Employees DDL.sql
Data File
_dept.xml
_emp.xml
_.DS_Store
_DDL Script
_Data File
_Countries
_Customer Orders
_Employees
Bonus Resources.txt
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [ FreeCourseWeb com ] Udemy - The Advanced SQL Course 2021 Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
