SQL From Intermediate to Advanced Level Video Course

Curriculum For This Course

• 1. Software Installation 1 Videos 00:16:29
  • Having The Database with Oracle VirtualBox 16:29
• 2. Introducing Database Objects 2 Videos 00:15:57
  • Introducing Database Objects and Reaching Another User's Objects 09:34
  • Reaching Another User's Objects 06:21
• 3. Data Dictionary Views 10 Videos 00:45:40
  • What Are Data Dictionary Views? 01:15
  • What Is There In Data Dictionary Views? 01:12
  • Dictionary Table 03:18
  • Differences Between USER, ALL, DBA, V$ Prefixes 01:31
  • USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views 09:13
  • USER_TABLES View 05:11
  • USER_TAB_COLUMNS View 05:04
  • User Constraints View 09:47
  • USER_CONS_COLUMNS View 05:29
  • USER_TAB_COMMENTS & USER_COL_COMMENTS Views 03:42
• 4. Creating, Using and Managing Sequences 8 Videos 00:30:54
  • What is a Sequence and Why is It Used For? 01:27
  • Creating Sequences 06:42
  • Modifying Sequences 02:48
  • Dropping Sequences 01:23
  • Using Sequences 09:08
  • Using Sequences As a Default Value 04:30
  • Sequence Caching 02:28
  • User Sequences 02:29
• 5. Creating, Using and Analyzing Synonyms 4 Videos 00:15:52
  • What Is a Synonym and Why Is It Used For? 02:32
  • Creating & Dropping Synonyms 07:03
  • Using Synonyms 02:34
  • Analyzing USER_SYNONYMS 03:43
• 6. Understanding Indexes 8 Videos 00:41:50
  • What is an Index and Why is It Used For? 02:43
  • Types of Indexes 02:19
  • Creating Indexes 07:47
  • Creating Index on Table Creation 07:44
  • Function Based Indexes 04:32
  • Multiple Indexes With Same Columns 09:04
  • Dropping Indexes 02:52
  • USER_INDEXES and USER_IND_COLUMNS Views 04:03
• 7. Managing Views 10 Videos 00:51:33
  • What is a View and Why Is It Used For? 02:52
  • Types Of Views 01:58
  • Creating Simple Views 12:17
  • Creating Complex Views 04:35
  • Modifying Views 03:37
  • Analyzing User Views 03:20
  • Performing DML Operations with Views 06:41
  • Using WITH CHECK OPTION Clause 10:54
  • Preventing DML Operations on A View 02:22
  • Dropping Views 02:02
• 8. Materialized Views 7 Videos 00:42:56
  • What is a Materialized View and Why is it Used For? 05:02
  • Creating Materialized Views Part 1 06:32
  • Creating Materialized Views Part 2 04:54
  • Complex Materialized Views 03:50
  • Types of Refreshing Materialized Views 09:53
  • Refreshing Materialized Views Manually 10:31
  • Scheduling Periodic Refresh of Materialized Views 01:40
• 9. Using Advanced Subqueries 12 Videos 01:11:20
  • Using Subqueries as a Source 05:40
  • Scalar Subqueries 09:11
  • Multiple Column Subqueries 07:21
  • Correlated Subqueries 04:10
  • EXISTS Operator 05:16
  • NOT EXISTS Operator 04:56
  • Using WITH Clause 06:31
  • Using Recursive WITH Clause 05:33
  • Inserting Data By Using a Subquery as a Target 07:06
  • Manipulating Data by Using "WITH CHECK OPTION" Keyword 06:24
  • Correlated Delete 02:23
  • Correlated Update 06:15
• 10. Advanced Data Manipulations 12 Videos 01:09:51
  • Using DEFAULT Keyword on Insert And Update Statements 05:45
  • Multitable Insert Statements 01:20
  • Unconditional Insert Statements 06:31
  • Conditional Insert Statements 08:07
  • Conditional Insert First Statements 05:21
  • Pivoting Insert 04:28
  • Merging Data 10:03
  • Flashback Operations 11:06
  • Purge Operations 04:02
  • Tracking Changes In Data In a Particular Time 01:28
  • FLASHBACK Query 06:31
  • FLASHBACK VERSIONS Query 04:57
• 11. Constraints (Controlling Schema Objects) 10 Videos 00:60:22
  • Adding Constraints 07:21
  • Removing Constraints 03:51
  • On Delete CASCADE & On Delete SET NULL 09:35
  • Cascading Constraints 03:57
  • Renaming Constraints 02:40
  • Disabling Constraints 03:02
  • Enabling Constraints 02:34
  • Status Of Constraints 03:04
  • Deferring Constraints 13:48
  • Creating Temporary Tables 10:28
• 12. Administering User Privileges and Roles 10 Videos 00:49:46
  • What Are Privileges And Why Are They Used For? 02:46
  • Creating A User 03:55
  • System Privileges 03:58
  • Granting System Privileges 07:07
  • What is A Role and Why is It Used For? 04:28
  • Changing The User Password 05:05
  • Object Privileges 02:02
  • Granting Object Privileges 10:29
  • Revoking Object Privileges 03:13
  • Searching For Privileges in Data Dictionary Views 06:44
• 13. Hierarchical Queries (Tree Structure) 6 Videos 00:25:08
  • Understanding Hierarchical Retrieval 02:48
  • Generating Hierarchical Queries 03:12
  • Walking On The Tree (Bottom to Up - Up to Down) 07:12
  • Ranking Rows (Using LEVEL Pseudocolumn) 04:06
  • Formatting Tree Structure (LEVEL & LPAD) 03:59
  • Pruning Branches Of a Tree 03:51
• 14. Generating Dynamic SQL Scripts 1 Videos 00:06:07
  • Generating Scripts By Using Data Dictionary Views 06:04
• 15. Regular Expressions 9 Videos 00:57:24
  • What is Regular Expressions and Why and Where Do We Use Them? 02:22
  • What Are Metacharacters? 13:37
  • Regular Expression Functions 02:34
  • Using REGEXP_LIKE() function 04:45
  • Using REGEXP_REPLACE() Function 10:18
  • Using REGEXP_SUBSTR() Function 08:34
  • Using REGEXP_INSTR() Function 06:11
  • Using REGEXP_COUNT() Function 04:00
  • Using REGEX in Constraints 04:59
• 16. Analytical SQL Functions (New Videos: Sep, 2017) 9 Videos 01:05:46
  • What are the Analytic Functions? 12:34
  • ROW_NUMBER Analytic Function 04:22
  • RANK and DENSE_RANK Analytic Functions 04:51
  • LEAD & LAG Analytic Functions (Next & Previous Values) 08:13
  • Windowing Clause in Analytic Functions - Part 1 10:56
  • Windowing Clause in Analytic Functions - Part 2 09:16
  • INTERVAL Keyword In Analytic Functions 04:26
  • FIRST_VALUE and LAST_VALUE Analytic Functions.. 06:46
  • Selecting Top-N Rows with Analytic Functions 04:22