SQL From Intermediate to Advanced Level Certification Video Training Course
The complete solution to prepare for for your exam with SQL From Intermediate to Advanced Level certification video training course. The SQL From Intermediate to Advanced Level certification video training course contains a complete set of videos that will provide you with thorough knowledge to understand the key concepts. Top notch prep including Databases Courses SQL From Intermediate to Advanced Level exam dumps, study guide & practice test questions and answers.
SQL From Intermediate to Advanced Level Certification Video Training Course Exam Curriculum
Software Installation
Introducing Database Objects
Data Dictionary Views
Creating, Using and Managing Sequences
Creating, Using and Analyzing Synonyms
Understanding Indexes
Managing Views
Materialized Views
Using Advanced Subqueries
Advanced Data Manipulations
Constraints (Controlling Schema Objects)
Administering User Privileges and Roles
Hierarchical Queries (Tree Structure)
Generating Dynamic SQL Scripts
Regular Expressions
Analytical SQL Functions (New Videos: Sep, 2017)
Software Installation
-
16:29
1. Having The Database with Oracle VirtualBox
Introducing Database Objects
-
09:34
1. Introducing Database Objects and Reaching Another User's Objects
-
06:21
2. Reaching Another User's Objects
Data Dictionary Views
-
01:15
1. What Are Data Dictionary Views?
-
01:12
2. What Is There In Data Dictionary Views?
-
03:18
3. Dictionary Table
-
01:31
4. Differences Between USER, ALL, DBA, V$ Prefixes
-
09:13
5. USER_OBJECTS, ALL_OBJECTS, DBA_OBJECTS Views
-
05:11
6. USER_TABLES View
-
05:04
7. USER_TAB_COLUMNS View
-
09:47
8. User Constraints View
-
05:29
9. USER_CONS_COLUMNS View
-
03:42
10. USER_TAB_COMMENTS & USER_COL_COMMENTS Views
Creating, Using and Managing Sequences
-
01:27
1. What is a Sequence and Why is It Used For?
-
06:42
2. Creating Sequences
-
02:48
3. Modifying Sequences
-
01:23
4. Dropping Sequences
-
09:08
5. Using Sequences
-
04:30
6. Using Sequences As a Default Value
-
02:28
7. Sequence Caching
-
02:29
8. User Sequences
Creating, Using and Analyzing Synonyms
-
02:32
1. What Is a Synonym and Why Is It Used For?
-
07:03
2. Creating & Dropping Synonyms
-
02:34
3. Using Synonyms
-
03:43
4. Analyzing USER_SYNONYMS
Understanding Indexes
-
02:43
1. What is an Index and Why is It Used For?
-
02:19
2. Types of Indexes
-
07:47
3. Creating Indexes
-
07:44
4. Creating Index on Table Creation
-
04:32
5. Function Based Indexes
-
09:04
6. Multiple Indexes With Same Columns
-
02:52
7. Dropping Indexes
-
04:03
8. USER_INDEXES and USER_IND_COLUMNS Views
Managing Views
-
02:52
1. What is a View and Why Is It Used For?
-
01:58
2. Types Of Views
-
12:17
3. Creating Simple Views
-
04:35
4. Creating Complex Views
-
03:37
5. Modifying Views
-
03:20
6. Analyzing User Views
-
06:41
7. Performing DML Operations with Views
-
10:54
8. Using WITH CHECK OPTION Clause
-
02:22
9. Preventing DML Operations on A View
-
02:02
10. Dropping Views
Materialized Views
-
05:02
1. What is a Materialized View and Why is it Used For?
-
06:32
2. Creating Materialized Views Part 1
-
04:54
3. Creating Materialized Views Part 2
-
03:50
4. Complex Materialized Views
-
09:53
5. Types of Refreshing Materialized Views
-
10:31
6. Refreshing Materialized Views Manually
-
01:40
7. Scheduling Periodic Refresh of Materialized Views
Using Advanced Subqueries
-
05:40
1. Using Subqueries as a Source
-
09:11
2. Scalar Subqueries
-
07:21
3. Multiple Column Subqueries
-
04:10
4. Correlated Subqueries
-
05:16
5. EXISTS Operator
-
04:56
6. NOT EXISTS Operator
-
06:31
7. Using WITH Clause
-
05:33
8. Using Recursive WITH Clause
-
07:06
9. Inserting Data By Using a Subquery as a Target
-
06:24
10. Manipulating Data by Using "WITH CHECK OPTION" Keyword
-
02:23
11. Correlated Delete
-
06:15
12. Correlated Update
Advanced Data Manipulations
-
05:45
1. Using DEFAULT Keyword on Insert And Update Statements
-
01:20
2. Multitable Insert Statements
-
06:31
3. Unconditional Insert Statements
-
08:07
4. Conditional Insert Statements
-
05:21
5. Conditional Insert First Statements
-
04:28
6. Pivoting Insert
-
10:03
7. Merging Data
-
11:06
8. Flashback Operations
-
04:02
9. Purge Operations
-
01:28
10. Tracking Changes In Data In a Particular Time
-
06:31
11. FLASHBACK Query
-
04:57
12. FLASHBACK VERSIONS Query
Constraints (Controlling Schema Objects)
-
07:21
1. Adding Constraints
-
03:51
2. Removing Constraints
-
09:35
3. On Delete CASCADE & On Delete SET NULL
-
03:57
4. Cascading Constraints
-
02:40
5. Renaming Constraints
-
03:02
6. Disabling Constraints
-
02:34
7. Enabling Constraints
-
03:04
8. Status Of Constraints
-
13:48
9. Deferring Constraints
-
10:28
10. Creating Temporary Tables
Administering User Privileges and Roles
-
02:46
1. What Are Privileges And Why Are They Used For?
-
03:55
2. Creating A User
-
03:58
3. System Privileges
-
07:07
4. Granting System Privileges
-
04:28
5. What is A Role and Why is It Used For?
-
05:05
6. Changing The User Password
-
02:02
7. Object Privileges
-
10:29
8. Granting Object Privileges
-
03:13
9. Revoking Object Privileges
-
06:44
10. Searching For Privileges in Data Dictionary Views
Hierarchical Queries (Tree Structure)
-
02:48
1. Understanding Hierarchical Retrieval
-
03:12
2. Generating Hierarchical Queries
-
07:12
3. Walking On The Tree (Bottom to Up - Up to Down)
-
04:06
4. Ranking Rows (Using LEVEL Pseudocolumn)
-
03:59
5. Formatting Tree Structure (LEVEL & LPAD)
-
03:51
6. Pruning Branches Of a Tree
Generating Dynamic SQL Scripts
-
06:04
1. Generating Scripts By Using Data Dictionary Views
Regular Expressions
-
02:22
1. What is Regular Expressions and Why and Where Do We Use Them?
-
13:37
2. What Are Metacharacters?
-
02:34
3. Regular Expression Functions
-
04:45
4. Using REGEXP_LIKE() function
-
10:18
5. Using REGEXP_REPLACE() Function
-
08:34
6. Using REGEXP_SUBSTR() Function
-
06:11
7. Using REGEXP_INSTR() Function
-
04:00
8. Using REGEXP_COUNT() Function
-
04:59
9. Using REGEX in Constraints
Analytical SQL Functions (New Videos: Sep, 2017)
-
12:34
1. What are the Analytic Functions?
-
04:22
2. ROW_NUMBER Analytic Function
-
04:51
3. RANK and DENSE_RANK Analytic Functions
-
08:13
4. LEAD & LAG Analytic Functions (Next & Previous Values)
-
10:56
5. Windowing Clause in Analytic Functions - Part 1
-
09:16
6. Windowing Clause in Analytic Functions - Part 2
-
04:26
7. INTERVAL Keyword In Analytic Functions
-
06:46
8. FIRST_VALUE and LAST_VALUE Analytic Functions..
-
04:22
9. Selecting Top-N Rows with Analytic Functions
About SQL From Intermediate to Advanced Level Certification Video Training Course
SQL From Intermediate to Advanced Level certification video training course by prepaway along with practice test questions and answers, study guide and exam dumps provides the ultimate training package to help you pass.
Do you have some SQL knowledge but think that it is not enough? Would you like to increase your professional value right from the comfort of your home? This course is designed to advance you to a higher level. New skills will help you go further and become a real SQL master. Among other benefits, this video guide will help you pass the Oracle exams and receive an Oracle certification.
All the topics are explained thoroughly. The lectures are delivered without any useless information. What does this course cover? It teaches database objects, sequences, analytical functions, materialized views, data dictionary views, hierarchical retrieval. Advanced data manipulation and advanced subqueries are also included. In total, the training consists of 119 lectures. 16 sections are dedicated to the main topics. For example, you will start with software installation and then learn database objects. 10 lectures are compiled to explain data dictionary views. Then, you will know how to make, use, and manage sequences. 4 lectures are designed to teach how to create and use synonyms. There is a block of lectures that cover views management so that you will understand how to make complex and simple views, perform DML operations with views, analyze user views, and so on. Among other things, regular expressions and dynamic SQL scripts are also covered. As you can see, the course is very informative and detailed.
With the course, you will become a real SQL expert. This will allow you to achieve great success in the field, increase your career prospects and salary.
Prepaway's SQL From Intermediate to Advanced Level video training course for passing certification exams is the only solution which you need.
Pass Databases Courses SQL From Intermediate to Advanced Level Exam in First Attempt Guaranteed!
Get 100% Latest Exam Questions, Accurate & Verified Answers As Seen in the Actual Exam!
30 Days Free Updates, Instant Download!
Student Feedback
Can View Online Video Courses
Please fill out your email address below in order to view Online Courses.
Registration is Free and Easy, You Simply need to provide an email address.
- Trusted By 1.2M IT Certification Candidates Every Month
- Hundreds Hours of Videos
- Instant download After Registration
A confirmation link will be sent to this email address to verify your login.
Please Log In to view Online Course
Registration is free and easy - just provide your E-mail address.
Click Here to Register
