mcAfee-secured website

Course name Databases Courses SQL From Intermediate to Advanced Level: SQL From Intermediate to Advanced Level

SQL From Intermediate to Advanced Level Video Course

SQL From Intermediate to Advanced Level Video Course is developed by Databases Courses Professionals to help you pass the SQL From Intermediate to Advanced Level exam.

You Will Learn:

Was 21.99 USD
Now 19.99 USD

Description

This course will improve your knowledge and skills required to pass SQL From Intermediate to Advanced Level exam.

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