Course Content
Subtitle Guide – Hướng dẫn thêm phụ đề
0/1
Set up subtitle for video – Hướng dẫn thêm phụ đề
01 – Course Introduction
0/3
Download Resource Files
001 Introduction
01:23
002 UDEMY 101 How to Use Udemy +Some Useful Tips
05:01
02 – Software Installation
0/26
Download Resource Files
001 About the Database Installation
03:02
002 The Ways to Get a Database_part1
07:25
002 The Ways to Get a Database_part2
07:25
003 Option 1 Installing VMware and VirtualBox on Windows_part1
03:47
003 Option 1 Installing VMware and VirtualBox on Windows_part2
03:47
006 Option 1 Downloading Virtual Machine Image(If the previous lecture didn’t work)
04:11
007 Option 1 Configuring the VMware Virtualization Software_part1
04:09
007 Option 1 Configuring the VMware Virtualization Software_part2
04:09
008 Option 1 Configuring the Oracle VirtualBox Virtualization Software
06:46
009 Option 1 Configuring SQL Developer inside of the Virtual Machine
13:02
011 What is Pluggable Database (Multitenant Architecture)
03:14
012 Option 2 Downloading And Installing the Oracle Database_part1
04:34
012 Option 2 Downloading And Installing the Oracle Database_part2_part1
02:17
012 Option 2 Downloading And Installing the Oracle Database_part2_part2
02:17
012 Option 2 Downloading And Installing the Oracle Database_part3
04:34
012 Option 2 Downloading And Installing the Oracle Database_part4
04:34
013 Option 2 Unlocking the HR Schema
07:34
014 Option 2 Configuring and Using the SQL Developer_part1_part1
03:42
014 Option 2 Configuring and Using the SQL Developer_part1_part2
03:42
014 Option 2 Configuring and Using the SQL Developer_part2
07:24
014 Option 2 Configuring and Using the SQL Developer_part3
07:24
015 Option 2 Installing Sample Schemas in Oracle Database_part1
03:52
015 Option 2 Installing Sample Schemas in Oracle Database_part2
03:52
017 Option 3 Using Oracle Live SQL
07:40
019 The Sample (HR) Schema Used in This Course
07:23
03 – Introducing Database Objects
0/3
Download Resource Files
001 Introducing Database Objects and Reaching Another User’s Objects
09:37
002 Reaching Another User’s Objects
06:20
04 – Data Dictionary Views
0/12
Download Resource Files
001 What Are Data Dictionary Views
01:15
002 What Is There In Data Dictionary Views
01:12
003 Dictionary Table
03:18
004 Differences Between USER ALL DBA V$ Prefixes
01:30
005 USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views
09:13
006 USER_TABLES View
05:11
007 USER_TAB_COLUMNS View
05:04
008 User Constraints View_part1
04:54
008 User Constraints View_part2
04:53
009 USER_CONS_COLUMNS View
05:28
010 USER_TAB_COMMENTS & USER_COL_COMMENTS Views
03:42
05 – Creating, Using and Managing Sequences
0/9
Download Resource Files
001 What is a Sequence and Why is It Used For
01:27
002 Creating Sequences
06:42
003 Modifying Sequences
02:47
004 Dropping Sequences
01:23
005 Using Sequences
09:08
006 Using Sequences As a Default Value
04:30
007 Sequence Caching
02:28
008 User Sequences
02:29
06 – Creating, Using and Analyzing Synonyms
0/5
Download Resource Files
001 What Is a Synonym and Why Is It Used For
02:32
002 Creating & Dropping Synonyms
07:03
003 Using Synonyms
02:34
004 Analyzing USER_SYNONYMS
03:43
07 – Understanding Indexes
0/9
Download Resource Files
001 What is an Index and Why is It Used For
02:43
002 Types of Indexes
02:32
003 Creating Indexes
08:02
004 Creating Index on Table Creation
07:43
005 Function Based Indexes
04:52
006 Multiple Indexes With Same Columns
09:04
007 Dropping Indexes
02:51
008 USER_INDEXES and USER_IND_COLUMNS Views
04:03
08 – Managing Views
0/13
Download Resource Files
001 What is a View and Why Is It Used For
03:04
002 Types Of Views
01:58
003 Creating Simple Views_part1
06:12
003 Creating Simple Views_part2
06:12
004 Creating Complex Views
04:35
005 Modifying Views
03:37
006 Analyzing User Views
03:20
007 Performing DML Operations with Views
06:52
008 Using WITH CHECK OPTION Clause_part1
05:33
008 Using WITH CHECK OPTION Clause_part2
05:33
009 Preventing DML Operations on A View
02:22
010 Dropping Views
02:14
09 – Materialized Views
0/9
Download Resource Files
001 What is a Materialized View and Why is it Used For
05:13
002 Creating Materialized Views Part 1
06:32
003 Creating Materialized Views Part 2
04:54
004 Complex Materialized Views
03:50
005 Types of Refreshing Materialized Views
10:02
006 Refreshing Materialized Views Manually_part1
05:19
006 Refreshing Materialized Views Manually_part2
05:19
007 Scheduling Periodic Refresh of Materialized Views
01:48
10 – Using Advanced Subqueries
0/13
Download Resource Files
001 Using Subqueries as a Source
05:56
002 Scalar Subqueries
09:11
003 Multiple Column Subqueries
07:21
004 Correlated Subqueries
04:18
005 EXISTS Operator
05:16
006 NOT EXISTS Operator
04:56
007 Using WITH Clause
06:31
008 Using Recursive WITH Clause
05:33
009 Inserting Data By Using a Subquery as a Target
07:06
010 Manipulating Data by Using WITH CHECK OPTION Keyword
06:24
011 Correlated Update
06:15
012 Correlated Delete
02:33
11 – Advanced Data Manipulations
0/14
Download Resource Files
001 Using DEFAULT Keyword on Insert And Update Statements
05:59
002 Multitable Insert Statements
01:20
003 Unconditional Insert Statements
06:31
004 Conditional Insert Statements
08:06
005 Conditional Insert First Statements
05:21
006 Pivoting Insert
04:28
007 Merging Data
10:03
008 Flashback Operations_part1
05:33
008 Flashback Operations_part2
05:33
009 Purge Operations
04:02
010 Tracking Changes In Data In a Particular Time
01:28
011 FLASHBACK Query
06:31
012 FLASHBACK VERSIONS Query
04:57
12 – Constraints (Controlling Schema Objects)
0/12
Download Resource Files
001 Adding Constraints
07:25
002 Removing Constraints
03:51
003 On Delete CASCADE & On Delete SET NULL
09:35
004 Cascading Constraints
03:57
005 Renaming Constraints
02:39
006 Disabling Constraints
03:02
007 Enabling Constraints
02:34
008 Status Of Constraints
03:04
009 Deferring Constraints_part1
06:54
009 Deferring Constraints_part2
06:54
010 Creating Temporary Tables
10:28
13 – Administering User Privileges and Roles
0/12
Download Resource Files
001 What Are Privileges And Why Are They Used For
02:46
002 Creating A User
03:55
003 System Privileges
03:58
004 Granting System Privileges
07:07
005 What is A Role and Why is It Used For
04:28
006 Changing The User Password
05:05
007 Object Privileges
02:02
008 Granting Object Privileges_part1
05:15
008 Granting Object Privileges_part2
05:15
009 Revoking Object Privileges
03:13
010 Searching For Privileges in Data Dictionary Views
06:44
14 – Hierarchical Queries (Tree Structure)
0/7
Download Resource Files
001 Understanding Hierarchical Retrieval
02:48
002 Generating Hierarchical Queries
03:12
003 Walking On The Tree (Bottom to Up – Up to Down)
07:12
004 Ranking Rows (Using LEVEL Pseudocolumn)
04:06
005 Formatting Tree Structure (LEVEL & LPAD)
03:59
006 Pruning Branches Of a Tree
03:51
15 – Generating Dynamic SQL Scripts
0/2
Download Resource Files
001 Generating Scripts By Using Data Dictionary Views
06:07
16 – Regular Expressions
0/10
Download Resource Files
001 What is Regular Expressions and Why and Where Do We Use Them
02:27
002 What Are Metacharacters
13:37
003 Regular Expression Functions
02:34
004 Using REGEXP_LIKE() function
04:44
005 Using REGEXP_REPLACE() Function
10:18
006 Using REGEXP_SUBSTR() Function
08:34
007 Using REGEXP_INSTR() Function
06:12
008 Using REGEXP_COUNT() Function
04:00
009 Using REGEX in Constraints
05:00
17 – SQL Analytic Functions
0/10
Download Resource Files
001 What are the Analytic Functions
12:34
002 ROW_NUMBER Analytic Function
04:22
003 RANK and DENSE_RANK Analytic Functions
04:51
004 LEAD & LAG Analytic Functions (Next & Previous Values)
08:13
005 Windowing Clause in Analytic Functions – Part 1
10:56
006 Windowing Clause in Analytic Functions – Part 2
09:16
007 INTERVAL Keyword In Analytic Functions
04:27
008 FIRST_VALUE and LAST_VALUE Analytic Functions
06:46
009 Selecting Top-N Rows with Analytic Functions
04:22
18 – Appendix + Conclusion
0/3
Download Resource Files
001 Appendix 1 Oracle Database 12c Installation into Your Computer
08:58
003 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c
09:54
Advanced SQL : The Ultimate Guide (2024)
About Lesson

Please follow the instructions at the following link to add subtitles 

[ Các bạn làm theo chỉ dẫn ở link sau để thêm phụ đề cho bài giảng]

 

Set up Subtitle for video

https://freestudy247.com/set-up-subtitle-for-video/

Join the conversation
Previous
Next

Please contact me via telegram

DMCA.com Protection Status