| Description: |
Udemy - The Complete Oracle SQL Bootcamp
Last updated: 1/2026
Are you a student ready to learn SQL for your lessons? Do you want to get a better job? Are you bored with watching a lot of stuff, but could not learn anything? Do you think you know SQL, but you cannot write SQL codes? Are you looking for a really professional course? Then this is the course you are looking for. You are in the right place! In this course, all the subjects are explained in professional order. If you are new to SQL, no problem! You can easily learn all the details of SQL. If you already know SQL and want to improve, this course explains all the details including all of the subjects. After completing this course, you will learn all that you need to know. If you don't see something in this course, it means you really don't need to know it for now. Coding can be learned with coding. A course that has no example is not a course at all. And there are hundreds and hundreds of codes in this course.
Requirements:
- Nothing more than a working computer; all PC, Mac or Linux, etc. users are all welcome.
- No previous programming experience is required!
- No paid tools are required!
|
| Files: |
-
010 Option 2 Downloading And Installing Oracle Database.mp4
196.1 MB
-
001 What is a Database_en.srt
9.1 KB
-
002 Why Oracle Database.mp4
39.3 MB
-
002 Why Oracle Database_en.srt
8.9 KB
-
003 What is a Table.mp4
14.9 MB
-
003 What is a Table_en.srt
4.1 KB
-
004 UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).mp4
22.1 MB
-
004 UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)_en.srt
5.9 KB
-
005 Download-the-Working-Document.url
106 bytes
-
005 The Working Document (Course Slide for Course Participants).html
3.4 KB
-
005 The-Complete-Oracle-SQL-Bootcamp-Student-Guide-2026.pdf
153.7 MB
-
006 Oracle-Database-SQL-Certified-Associate-1Z0-071-Exam-Dump-1.pdf
576.6 KB
-
006 Oracle-Database-SQL-Certified-Associate-1Z0-071-Exam-Dump-2.pdf
2.0 MB
-
006 Oracle-Database-SQL-Fundamentals-1Z0-061-Exam.pdf
2.9 MB
-
006 Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples).html
3.6 KB
-
006 SQL-Cheatsheet-Oracle-Master.pdf
3.6 MB
-
007 What is a Relational Database (RDBMS).mp4
54.5 MB
-
007 What is a Relational Database (RDBMS)_en.srt
9.0 KB
-
008 Entity Relationship Logic in Databases.mp4
22.4 MB
-
008 Entity Relationship Logic in Databases_en.srt
4.4 KB
-
009 What is Pluggable Database.mp4
12.1 MB
-
009 What is Pluggable Database_en.srt
3.8 KB
-
010 Introduction to Database Objects.mp4
119.1 MB
-
010 Introduction to Database Objects_en.srt
15.2 KB
-
011 HR-Schema-Relationship.png?43858?v=1.05
233.1 KB
-
011 The Sample (HR) Schema Used in This Course.mp4
47.3 MB
-
011 The Sample (HR) Schema Used in This Course_en.srt
8.7 KB
-
012 What is SQL.mp4
17.4 MB
-
012 What is SQL_en.srt
6.0 KB
-
013 Quiz (Database Concepts).html
24.2 KB
-
external-links.txt
121 bytes
-
001 About the Database Installation.mp4
48.6 MB
-
001 About the Database Installation_en.srt
5.0 KB
-
002 The Ways to Get a Database.mp4
100.9 MB
-
002 The Ways to Get a Database_en.srt
20.0 KB
-
003 Option 1 Downloading Oracle Database 23ai The Virtual Machine Image (.ova) File.mp4
16.6 MB
-
003 Option 1 Downloading Oracle Database 23ai The Virtual Machine Image (.ova) File_en.srt
3.4 KB
-
004 Option 1 Downloading and Installing VirtualBox.mp4
35.6 MB
-
004 Option 1 Downloading and Installing VirtualBox_en.srt
3.7 KB
-
005 Option 1 Getting Started with VirtualBox Setup and Configuration.mp4
23.7 MB
-
005 Option 1 Getting Started with VirtualBox Setup and Configuration_en.srt
7.4 KB
-
006 Option 1 Configuring SQL Developer for the Virtual Machine.mp4
64.7 MB
-
006 Option 1 Configuring SQL Developer for the Virtual Machine_en.srt
15.4 KB
-
007 Option 1 Using SQL Developer with Virtual Machines.mp4
39.9 MB
-
007 Option 1 Using SQL Developer with Virtual Machines_en.srt
6.2 KB
-
008 Option 1 How to Install the Virtual Box on Mac OS X.html
6.4 KB
-
009 Important Note.html
3.3 KB
-
001 What is a Database.mp4
72.3 MB
-
010 Option 2 Downloading And Installing Oracle Database_en.srt
22.0 KB
-
010 Oracles-Official-Website.url
108 bytes
-
011 Option 2 Unlocking the HR Schema.mp4
18.1 MB
-
011 Option 2 Unlocking the HR Schema_en.srt
9.0 KB
-
011 -Oracle-Master-Training-Scripts-to-Unlock-the-HR-Schema.pdf
230.8 KB
-
012 Option 2 Configuring and Using the SQL Developer.mp4
146.1 MB
-
012 Option 2 Configuring and Using the SQL Developer_en.srt
25.4 KB
-
013 Installation-Code.txt
1.3 KB
-
013 Option 2 Installing Sample Schemas in Oracle Database.mp4
93.4 MB
-
013 Option 2 Installing Sample Schemas in Oracle Database_en.srt
8.6 KB
-
014 HR-Schema-Create-Code.sql
70.3 KB
-
014 Option 2 HR Schema Create Code (if you could not get the HR user in other ways).html
72.9 KB
-
015 Option 3 Using Oracle Live SQL.mp4
23.2 MB
-
015 Option 3 Using Oracle Live SQL_en.srt
8.3 KB
-
016 Option 3 Oracle Live SQL Limitations.html
3.3 KB
-
017 SQL Statements Used in This Course.mp4
43.8 MB
-
017 SQL Statements Used in This Course_en.srt
5.8 KB
-
018 Don't Forget to Leave a Rating!.html
2.8 KB
-
external-links.txt
118 bytes
-
export_sample_schemas.par
125 bytes
-
EXPORTED_SAMPLE_SCHEMAS.DMP
56.5 MB
-
exported_sample_schemas.log
11.1 KB
-
import.log
7.3 KB
-
import_sample _schemas.par
143 bytes
-
001 Oracle Data Types.mp4
55.4 MB
-
001 Oracle Data Types_en.srt
7.9 KB
-
002 What is a NULL Value.mp4
25.8 MB
-
002 What is a NULL Value_en.srt
5.9 KB
-
003 DESCRIBE Command.mp4
29.8 MB
-
003 DESCRIBE Command_en.srt
5.0 KB
-
004 INFORMATION Command.mp4
29.7 MB
-
004 INFORMATION Command_en.srt
9.8 KB
-
005 INFORMATION Command (Code Samples).html
2.8 KB
-
005 INFORMATION-Command-Code-Samples.sql
450 bytes
-
006 SQL Statement Basics.mp4
102.7 MB
-
006 SQL Statement Basics_en.srt
14.7 KB
-
007 SQL Statement Basics (Code Samples).html
2.6 KB
-
007 SQL-Statement-Basics-Code-Samples.sql
385 bytes
-
008 Oracle Error Messages.mp4
35.1 MB
-
008 Oracle Error Messages_en.srt
7.5 KB
-
009 Oracle Error Messages (Code Samples).html
2.7 KB
-
009 Oracle-Error-Messages-Code-Samples.sql
458 bytes
-
010 Using SELECT Statements.mp4
24.3 MB
-
010 Using SELECT Statements_en.srt
7.6 KB
-
011 Using SELECT Statements (Code Samples).html
2.8 KB
-
011 Using-SELECT-Statements-Code-Samples.sql
512 bytes
-
012 Using Column Aliases.mp4
26.5 MB
-
012 Using Column Aliases_en.srt
8.3 KB
-
013 CODE Using Column Aliases.html
2.9 KB
-
013 Using-Column-Aliases-Code-Samples.sql
695 bytes
-
014 Quote (Q) Operator.mp4
39.2 MB
-
014 Quote (Q) Operator_en.srt
9.8 KB
-
015 Quote (Q) Operator (Code Samples).html
3.0 KB
-
015 Quote-Q-Operator-Code-Samples.sql
741 bytes
-
016 DISTINCT and UNIQUE Operator.mp4
55.2 MB
-
016 DISTINCT and UNIQUE Operator_en.srt
8.6 KB
-
017 DISTINCT and UNIQUE Operators (Code Samples).html
3.0 KB
-
017 DISTINCT-and-UNIQUE-Operators-Code-Samples.sql
747 bytes
-
018 Write a SQL Query that Returns All the Possible Product Status Values.html
5.1 KB
-
019 Coding Exercise 1 Solution.html
2.8 KB
-
020 Concatenation Operators.mp4
46.4 MB
-
020 Concatenation Operators_en.srt
9.2 KB
-
021 Concatenation Operators (Code Samples).html
3.0 KB
-
021 Concatenation-Operators-Code-Samples.sql
795 bytes
-
022 Arithmetic Expressions and NULL Values.mp4
65.4 MB
-
022 Arithmetic Expressions and NULL Values_en.srt
11.9 KB
-
023 Arithmetic Expressions and NULL Values (Code Samples).html
3.0 KB
-
023 Arithmetic-Opertors-and-NULL-values-Code-Samples.sql
771 bytes
-
024 Write a SQL Query to Calculate New Salaries.html
5.5 KB
-
025 Quiz (Retrieving Data).html
23.4 KB
-
026 Coding Exercise 2 Solution.html
3.0 KB
-
001 Using WHERE Clause.mp4
19.7 MB
-
001 Using WHERE Clause_en.srt
5.2 KB
-
002 Using WHERE Clause (Code Samples).html
2.7 KB
-
002 Using-WHERE-Clause-Code-Samples.sql
457 bytes
-
003 Write a SQL Query to Fetch the Employees Working as Sales Managers.html
5.2 KB
-
004 Comparison Operators.mp4
59.8 MB
-
004 Comparison Operators_en.srt
7.5 KB
-
005 Comparison Operators (Code Samples).html
2.9 KB
-
005 Comparison-Operators-Code-Samples.sql
616 bytes
-
006 BETWEEN … AND Operator.mp4
38.0 MB
-
006 BETWEEN … AND Operator_en.srt
6.5 KB
-
007 BETWEEN...AND Operator (Code Samples).html
2.8 KB
-
007 BETWEEN.AND-Operator-Code-Samples.sql
556 bytes
-
008 IN Operator.mp4
31.6 MB
-
008 IN Operator_en.srt
11.3 KB
-
009 IN Operator (Code Samples).html
2.9 KB
-
009 IN-Operator-Code-Samples.sql
723 bytes
-
010 Type a SQL Query which Returns the Employees who Work as Sales People.html
5.6 KB
-
011 LIKE Operator.mp4
35.2 MB
-
011 LIKE Operator_en.srt
13.0 KB
-
012 LIKE Operator (Code Samples).html
3.0 KB
-
012 LIKE-Operator-Code-Samples.sql
777 bytes
-
013 Return all the managers based on their job titles.html
5.3 KB
-
014 IS NULL Operator.mp4
24.9 MB
-
014 IS NULL Operator_en.srt
6.9 KB
-
015 IS NULL Operator (Code Samples).html
2.7 KB
-
015 IS-NULL-Operator-Code-Samples.sql
501 bytes
-
016 Logical Operators (AND, OR, NOT).mp4
89.7 MB
-
016 Logical Operators (AND, OR, NOT)_en.srt
15.2 KB
-
017 Logical Operators (Code Samples).html
2.8 KB
-
017 Logical-Operators-Code-Samples.sql
571 bytes
-
018 Return Managers Who Earn Less Than $10,000.html
5.6 KB
-
019 Rules of Precedence.mp4
37.8 MB
-
019 Rules of Precedence_en.srt
11.5 KB
-
020 Rules of Precedence (Code Samples).html
3.2 KB
-
020 Rules-of-Precedence-Code-Samples.sql
1009 bytes
-
021 A Challenging Exercise on the Rules of Precedence.html
5.5 KB
-
022 SQL-Quiz-by-Oracle-Master-Training.pdf
3.3 MB
-
023 Quiz (Restricting Data).html
28.3 KB
-
001 ORDER BY Clause.mp4
143.8 MB
-
001 ORDER BY Clause_en.srt
18.3 KB
-
002 ORDER BY Clause (Code Samples).html
3.2 KB
-
002 ORDER-BY-Clause-Code-Samples.sql
1.0 KB
-
003 ASC and DESC Operators.mp4
54.7 MB
-
003 ASC and DESC Operators_en.srt
11.5 KB
-
004 ASC and DESC Operators (Code Samples).html
3.4 KB
-
004 ASC-and-DESC-Operators-Code-Samples.sql
1.2 KB
-
005 It's Time Order the Rows.html
5.5 KB
-
006 NULLS FIRST and NULLS LAST Operators.mp4
18.3 MB
-
006 NULLS FIRST and NULLS LAST Operators_en.srt
4.8 KB
-
007 NULLS FIRST and NULLS LAST Operators (Code Samples).html
3.1 KB
-
007 NULLS-FIRST-and-NULLS-LAST-Operators-Code-Samples.sql
795 bytes
-
008 ROWNUM & ROWID in SQL.mp4
93.8 MB
-
008 ROWNUM & ROWID in SQL_en.srt
14.7 KB
-
009 ROWNUM & ROWID in SQL (Code Samples).html
3.0 KB
-
009 ROWNUM-and-ROWID-in-SQL-Code-Samples.sql
782 bytes
-
010 Oracle FETCH Clause.mp4
47.7 MB
-
010 Oracle FETCH Clause_en.srt
17.9 KB
-
011 Oracle FETCH Clause (Code Samples).html
3.3 KB
-
011 Oracle-FETCH-Clause-Code-Samples.sql
1.1 KB
-
012 Bring the Second Top 10 Orders.html
5.6 KB
-
013 Quiz (Sorting Data).html
23.7 KB
-
001 What is a Substitution Variable.mp4
56.2 MB
-
001 What is a Substitution Variable_en.srt
17.4 KB
-
002 What is a Substitution Variable (Code Samples).html
3.2 KB
-
002 What-is-a-Substitution-Variable-Code-Samples.sql
875 bytes
-
003 Double Ampersand (&&) and DEFINE & UNDEFINE Commands.mp4
127.1 MB
-
003 Double Ampersand (&&) and DEFINE & UNDEFINE Commands_en.srt
21.0 KB
-
004 Double Ampersand (&&) and DEFINE & UNDEFINE Commands (Code Samples).html
3.3 KB
-
004 Double-Ampersand-and-DEFINE-UNDEFINE-Commands-Code-Samples.sql
976 bytes
-
005 ACCEPT and PROMPT Commands.mp4
47.6 MB
-
005 ACCEPT and PROMPT Commands_en.srt
9.1 KB
-
006 ACCEPT and PROMPT Commands (Code Samples).html
3.0 KB
-
006 ACCEPT-and-PROMPT-Commands-Code-Samples.sql
779 bytes
-
007 SET VERIFY ON SET VERIFY OFF Commands.mp4
49.2 MB
-
007 SET VERIFY ON SET VERIFY OFF Commands_en.srt
8.8 KB
-
008 SET VERIFY ON-OFF Commands(Code Samples).html
2.8 KB
-
008 SET-VERIFY-ON-OFF-Commands-Code-Samples.sql
567 bytes
-
001 Single Row Functions.mp4
106.3 MB
-
001 Single Row Functions_en.srt
18.3 KB
-
002 Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functions.mp4
69.5 MB
-
002 Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functions_en.srt
20.3 KB
-
003 Case Conversion (LOWER, UPPER, INITCAP) Functions (Code Samples).html
3.4 KB
-
003 Case-Conversion-LOWER-UPPER-INITCAP-Functios-Code-Samples.sql
1.1 KB
-
004 Character Functions - Character Manipulation Functions (Part 1).mp4
64.7 MB
-
004 Character Functions - Character Manipulation Functions (Part 1)_en.srt
18.8 KB
-
005 Character Manipulation Functions (Part 1) (Code Samples).html
5.5 KB
-
005 Character-Manipulation-Functions-Part-1-Code-Samples.sql
3.2 KB
-
006 Character Functions - Character Manipulation Functions Part 2 (INSTR Function).mp4
57.2 MB
-
006 Character Functions - Character Manipulation Functions Part 2 (INSTR Function)_en.srt
15.2 KB
-
007 Character Manipulation Functions Part 2 (INSTR Function) (Code Samples).html
3.2 KB
-
007 Character-Manipulation-Functions-Part-2-INSTR-Function-Code-Samples.sql
929 bytes
-
008 Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions).mp4
103.4 MB
-
008 Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)_en.srt
31.1 KB
-
009 Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions) (Code Samples).html
4.3 KB
-
009 Character-Functions-Part-3-TRIM-LTRIM-RTRIM-Functions-Code-Samples.sql
2.0 KB
-
010 Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions).mp4
84.7 MB
-
010 Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)_en.srt
16.6 KB
-
011 Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions) (Code Samples).html
3.4 KB
-
011 Character-Functions-Part-4-REPLACE-LPAD-RPAD-Functions-Code-Samples.sql
1.0 KB
-
012 Numeric Functions.mp4
67.4 MB
-
012 Numeric Functions_en.srt
24.0 KB
-
012 Oracle-Numeric-Functions.url
110 bytes
-
013 Numeric Functions (Code Samples).html
2.9 KB
-
013 Numeric-Functions-Code-Samples.sql
646 bytes
-
014 Nested Functions.mp4
82.5 MB
-
014 Nested Functions_en.srt
21.2 KB
-
015 Nested Functions (Code Samples).html
3.1 KB
-
015 Nested-Functions-Code-Samples.sql
840 bytes
-
016 Date Values & Date Formats in Oracle.mp4
166.6 MB
-
016 Date Values & Date Formats in Oracle_en.srt
34.3 KB
-
017 Date Functions & Arithmetic Operations on Dates.mp4
138.4 MB
-
017 Date Functions & Arithmetic Operations on Dates_en.srt
24.0 KB
-
018 Date Functions & Arithmetic Operations on Dates (Code Samples).html
3.3 KB
-
018 Date-Functions-Arithmetic-Operations-on-Dates-Code-Samples.sql
1011 bytes
-
019 Date Manipulation Functions in SQL.mp4
84.9 MB
-
019 Date Manipulation Functions in SQL_en.srt
27.7 KB
-
020 Date Manipulation Functions in SQL (Code Samples).html
3.4 KB
-
020 Date-Manipulation-Functions-Code-Samples.sql
1.1 KB
-
021 Quiz (Single-Row Functions).html
23.8 KB
-
external-links.txt
120 bytes
-
001 Conversion Functions.mp4
70.9 MB
-
001 Conversion Functions_en.srt
16.3 KB
-
002 Conversion Functions (Code Samples).html
3.0 KB
-
002 Conversion-Functions-Code-Samples.sql
785 bytes
-
003 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1).mp4
135.1 MB
-
003 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)_en.srt
23.0 KB
-
004 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1) (Code Samples).html
5.2 KB
-
004 TO-CHAR-TO-DATE-TO-NUMBER-Functions-Part-1-Code-Samples.sql
2.9 KB
-
005 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).mp4
116.3 MB
-
005 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)_en.srt
21.7 KB
-
006 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2) (Code Samples).html
3.4 KB
-
006 TO-CHAR-TO-DATE-TO-NUMBER-Functions-Part-2-Code-Samples.sql
1.1 KB
-
007 Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions.mp4
137.4 MB
-
007 Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions_en.srt
28.0 KB
-
008 Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions (Code Samples).html
3.2 KB
-
008 Null-Related-NVL-NVL2-NULLIF-COALESCE-Functions-Code-Samples.sql
896 bytes
-
009 Quiz (Conversion Functions).html
25.5 KB
-
001 Oracle Conditional Expressions CASE Expressions.mp4
137.9 MB
-
001 Oracle Conditional Expressions CASE Expressions_en.srt
32.0 KB
-
002 Oracle Conditional Expressions CASE Expressions (Code Samples).html
4.5 KB
-
002 Oracle-Conditional-Expressions-CASE-Expressions-Code-Samples.sql
2.2 KB
-
003 Oracle Conditional Expressions DECODE Function.mp4
52.2 MB
-
003 Oracle Conditional Expressions DECODE Function_en.srt
12.5 KB
-
004 Oracle Conditional Expressions DECODE Function (Code Samples).html
3.2 KB
-
004 Oracle-Conditional-Expressions-DECODE-Function-Code-Samples.sql
956 bytes
-
005 Quiz (Conditional Expressions).html
25.3 KB
-
001 Group Functions.mp4
45.1 MB
-
001 Group Functions_en.srt
12.3 KB
-
002 AVG Function.mp4
36.8 MB
-
002 AVG Function_en.srt
13.6 KB
-
003 AVG Function (Code Samples).html
2.9 KB
-
003 AVG-Function-Code-Samples.sql
701 bytes
-
004 COUNT Function.mp4
20.1 MB
-
004 COUNT Function_en.srt
9.3 KB
-
005 COUNT Function (Code Samples).html
2.7 KB
-
005 COUNT-Function-Code-Samples.sql
445 bytes
-
006 Write a SQL query returning the number of married male customers.html
5.3 KB
-
007 MAX Function.mp4
33.8 MB
-
007 MAX Function_en.srt
6.0 KB
-
008 MAX Function (Code Samples).html
2.6 KB
-
008 MAX-Function-Code-Samples.sql
410 bytes
-
009 MIN Function.mp4
14.7 MB
-
009 MIN Function_en.srt
5.9 KB
-
010 MIN Function (Code Samples).html
2.7 KB
-
010 MIN-Function-Code-Samples.sql
446 bytes
-
011 SUM Function.mp4
25.6 MB
-
011 SUM Function_en.srt
5.2 KB
-
012 SUM Function (Code Samples).html
2.7 KB
-
012 SUM-Function-Code-Samples.sql
461 bytes
-
013 LISTAGG Function.mp4
35.6 MB
-
013 LISTAGG Function_en.srt
13.8 KB
-
014 LISTAGG Function (Code Samples).html
4.0 KB
-
014 LISTAGG-Function-Code-Samples.sql
1.8 KB
-
015 Overview Of Group Functions.mp4
12.8 MB
-
015 Overview Of Group Functions_en.srt
5.4 KB
-
016 Overview Of Group Functions (Code Samples).html
2.8 KB
-
016 Overview-of-Group-Functions-Code-Samples.sql
595 bytes
-
017 Quiz (Group Functions).html
23.3 KB
-
001 GROUP BY Clause (Part 1).mp4
63.8 MB
-
001 GROUP BY Clause (Part 1)_en.srt
23.6 KB
-
002 GROUP BY Clause (Part 1) (Code Samples).html
3.4 KB
-
002 GROUP-BY-Clause-Part-1-Code-Samples.sql
1.2 KB
-
003 Type a SQL Query Returning the Number of Distinct Job ID Values for Each Department.html
5.4 KB
-
004 GROUP BY Clause (Part 2).mp4
96.9 MB
-
004 GROUP BY Clause (Part 2)_en.srt
16.8 KB
-
005 GROUP BY Clause (Part 2) (Code Samples).html
3.2 KB
-
005 GROUP-BY-Clause-Part-2-Code-Samples.sql
999 bytes
-
006 HAVING Clause.mp4
36.8 MB
-
006 HAVING Clause_en.srt
11.4 KB
-
007 HAVING Clause (Code Samples).html
3.3 KB
-
007 HAVING-Clause-Code-Samples.sql
1.1 KB
-
008 Type an SQL Query that Returns Departments with More Than 10 Employees.html
5.2 KB
-
009 Nested Group Functions.mp4
31.9 MB
-
009 Nested Group Functions_en.srt
6.0 KB
-
010 Nested Group Functions (Code Samples).html
2.8 KB
-
010 Nested-Group-Functions-Code-Samples.sql
532 bytes
-
011 Quiz (Grouping Data).html
26.7 KB
-
001 What is a Join & Oracle SQL Join Types.mp4
64.3 MB
-
001 What is a Join & Oracle SQL Join Types_en.srt
11.1 KB
-
002 Creating a Join.mp4
12.2 MB
-
002 Creating a Join_en.srt
4.6 KB
-
003 Natural Join.mp4
70.6 MB
-
003 Natural Join_en.srt
13.8 KB
-
004 Natural Join (Code Samples).html
2.8 KB
-
004 Natural-Join-Code-Samples.sql
572 bytes
-
005 Join with the USING Clause.mp4
26.7 MB
-
005 Join with the USING Clause_en.srt
7.8 KB
-
006 Join with the USING Clause (Code Samples).html
2.7 KB
-
006 Join-with-the-USING-Clause-Code-Samples.sql
498 bytes
-
007 Handling Ambiguous Column Names.mp4
66.8 MB
-
007 Handling Ambiguous Column Names_en.srt
15.2 KB
-
008 Handling Ambiguous Column Names (Code Samples).html
4.0 KB
-
008 Handling-Ambiguous-Column-Names-Code-Samples.sql
1.7 KB
-
009 Inner Join & Join with the ON Clause.mp4
27.2 MB
-
009 Inner Join & Join with the ON Clause_en.srt
9.2 KB
-
010 Inner Join & Join with the ON Clause (Code Samples).html
3.6 KB
-
010 Inner-Join-Join-with-the-ON-Clause-Code-Samples.sql
1.3 KB
-
011 Write a SQL Query Returning the Distribution of Orders Based on the Gender and Order Mode.html
6.4 KB
-
012 Multiple Join Operations.mp4
120.3 MB
-
012 Multiple Join Operations_en.srt
16.3 KB
-
013 Multiple Join Operations (Code Samples).html
4.1 KB
-
013 Multiple-Join-Operations-Code-Samples.sql
1.8 KB
-
014 Restricting Joins.mp4
27.4 MB
-
014 Restricting Joins_en.srt
4.9 KB
-
015 Restricting Joins (Code Samples).html
3.3 KB
-
015 Restricting-Joins-Code-Samples.sql
1.0 KB
-
016 Self Join.mp4
30.8 MB
-
016 Self Join_en.srt
8.3 KB
-
017 Self Join (Code Samples).html
3.2 KB
-
017 Self-Join-Code-Samples.sql
968 bytes
-
018 Non-Equijoins (Joining Unequal Tables).mp4
90.3 MB
-
018 Non-Equijoins (Joining Unequal Tables)_en.srt
19.0 KB
-
018 NonEquiJoins-Source-Code.sql
1.6 KB
-
019 Non-Equijoins (Joining Unequal Tables) (Code Samples).html
3.2 KB
-
019 Non-Equijoins-Joining-Unequal-Tables-Code-Samples.sql
945 bytes
-
020 OUTER JOINS.mp4
54.2 MB
-
020 OUTER JOINS_en.srt
11.5 KB
-
021 OUTER JOINS (Code Samples).html
2.8 KB
-
021 OUTER-JOINS-Code-Samples.sql
599 bytes
-
022 LEFT OUTER JOIN (LEFT JOIN).mp4
63.1 MB
-
022 LEFT OUTER JOIN (LEFT JOIN)_en.srt
18.0 KB
-
023 LEFT OUTER JOIN (LEFT JOIN) (Code Samples).html
3.3 KB
-
023 LEFT-OUTER-JOIN-LEFT-JOIN-Code-Samples.sql
1.0 KB
-
024 RIGHT OUTER JOIN (RIGHT JOIN).mp4
70.2 MB
-
024 RIGHT OUTER JOIN (RIGHT JOIN)_en.srt
12.1 KB
-
025 RIGHT OUTER JOIN (RIGHT JOIN) (Code Samples).html
3.9 KB
-
025 RIGHT-OUTER-JOIN-RIGHT-JOIN-Code-Samples.sql
1.6 KB
-
026 FULL OUTER JOIN (FULL JOIN).mp4
16.3 MB
-
026 FULL OUTER JOIN (FULL JOIN)_en.srt
5.3 KB
-
027 FULL OUTER JOIN (FULL JOIN) (Code Samples).html
2.8 KB
-
027 FULL-OUTER-JOIN-Code-Samples.sql
561 bytes
-
028 Cross Join (Cartesian Product Cross Product).mp4
162.2 MB
-
028 Cross Join (Cartesian Product Cross Product)_en.srt
26.4 KB
-
029 Cross Join (Cartesian Product Cross Product) (Code Samples).html
4.4 KB
-
029 Cross-Join-Cartesian-Product-Cross-Product-Code-Samples.sql
2.1 KB
-
030 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1).mp4
124.2 MB
-
030 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1)_en.srt
19.1 KB
-
031 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2).mp4
85.3 MB
-
031 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2)_en.srt
23.7 KB
-
032 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3).mp4
67.4 MB
-
032 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3)_en.srt
14.9 KB
-
033 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Code Samples).html
6.5 KB
-
033 Oracles-Old-Style-Join-Syntax-ANSI-vs-Non-ANSI-Joins-Code-Samples.sql
4.1 KB
-
034 Source-Code-Differences-Between-All-Types-of-Joins.sql
2.6 KB
-
034 The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins.mp4
106.5 MB
-
034 The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins_en.srt
21.0 KB
-
035 Differences Between Inner Joins-Outer Joins, Equijoins-Non-Equijoins (Code).html
5.0 KB
-
035 The-Differences-Between-The-Inner-Joins-Outer-Joins-Equijoins-Non-Equijoins-Code-Samples.sql
2.6 KB
-
036 Which Join Type Should You Use.mp4
13.2 MB
-
036 Which Join Type Should You Use_en.srt
5.7 KB
-
037 Entity-Relationship Models in DBMS - How to Use Them with Joins.mp4
140.6 MB
-
037 Entity-Relationship Models in DBMS - How to Use Them with Joins_en.srt
27.0 KB
-
038 Quiz (Joining Multiple Tables).html
34.0 KB
-
001 Using Subqueries.mp4
56.4 MB
-
001 Using Subqueries_en.srt
11.1 KB
-
002 Using Subqueries (Code Samples).html
2.8 KB
-
002 Using-Subqueries-Code-Samples.sql
573 bytes
-
003 Return the Employees who Work in the Same Department with Douglas.html
5.4 KB
-
004 Single Row Subqueries.mp4
135.8 MB
-
004 Single Row Subqueries_en.srt
19.7 KB
-
005 Single Row Subqueries (Code Samples).html
4.4 KB
-
005 Single-Row-Subqueries-Code-Samples.sql
2.2 KB
-
006 Multiple Row Subqueries.mp4
104.3 MB
-
006 Multiple Row Subqueries_en.srt
28.0 KB
-
007 Multiple Row Subqueries (Code Samples).html
4.5 KB
-
007 Multiple-Row-Subqueries-Code-Samples.sql
2.3 KB
-
008 Multiple Column Subqueries.mp4
52.2 MB
-
008 Multiple Column Subqueries_en.srt
24.8 KB
-
009 Multiple Column Subqueries (Code Samples).html
4.1 KB
-
010 Using Subqueries as a Table.mp4
65.0 MB
-
010 Using Subqueries as a Table_en.srt
11.4 KB
-
011 Using Subqueries as a Table (Code Samples).html
3.4 KB
-
011 Using-Subqueries-as-a-Table-Code-Samples.sql
1.2 KB
-
012 SCALAR Subqueries.mp4
69.1 MB
-
012 SCALAR Subqueries_en.srt
22.1 KB
-
013 SCALAR Subqueries (Code Samples).html
3.8 KB
-
013 SCALAR-Subqueries-Code-Samples.sql
1.5 KB
-
014 Correlated Subqueries.mp4
110.6 MB
-
014 Correlated Subqueries_en.srt
21.9 KB
-
015 Correlated Subqueries (Code Samples).html
4.4 KB
-
015 CORRELATED-Subqueries-Code-Samples.sql
2.1 KB
-
016 EXISTS Operator & Semijoins.mp4
49.1 MB
-
016 EXISTS Operator & Semijoins_en.srt
17.4 KB
-
017 EXISTS Operator & Semijoins (Code Samples).html
3.1 KB
-
017 EXISTS-Operator-Semijoins-Code-Samples.sql
852 bytes
-
018 Write a SQL Query to Find the Customers who Paid over 100000 for One Order.html
6.0 KB
-
019 NOT EXISTS Operator.mp4
39.1 MB
-
019 NOT EXISTS Operator_en.srt
9.0 KB
-
020 NOT EXISTS Operator (Sample Codes).html
3.0 KB
-
020 NOT-EXISTS-Operator-Code-Samples.sql
746 bytes
-
021 Quiz (Using Subqueries).html
27.5 KB
-
001 Introduction to SET Operators in Oracle SQL.mp4
119.5 MB
-
001 Introduction to SET Operators in Oracle SQL_en.srt
23.2 KB
-
002 RETIRED-EMPLOYEES-Table-Create-Code.sql
1.1 KB
-
002 UNION and UNION ALL Operators.mp4
121.0 MB
-
002 UNION and UNION ALL Operators_en.srt
20.8 KB
-
003 UNION and UNION ALL Operators (Code Samples).html
3.2 KB
-
003 UNION-and-UNION-ALL-Operators-Code-Samples.sql
986 bytes
-
004 INTERSECT Operator.mp4
11.5 MB
-
004 INTERSECT Operator_en.srt
4.4 KB
-
005 INTERSECT Operator (Code Samples).html
2.7 KB
-
005 INTERSECT-Operator-Code-Samples.sql
495 bytes
-
006 MINUS Operator.mp4
18.2 MB
-
006 MINUS Operator_en.srt
5.5 KB
-
007 MINUS Operator (Code Samples).html
3.1 KB
-
007 MINUS-Operator-Code-Samples.sql
915 bytes
-
008 Matching Unmatched Queries in SET Operations.mp4
27.2 MB
-
008 Matching Unmatched Queries in SET Operations_en.srt
8.6 KB
-
009 Matching Unmatched Queries in SET Operations (Code Samples).html
3.0 KB
-
009 Matching-Unmatched-Queries-in-SET-Operations-Code-Samples.sql
744 bytes
-
010 Using the ORDER BY Clause with SET Operators.mp4
37.0 MB
-
010 Using the ORDER BY Clause with SET Operators_en.srt
10.8 KB
-
011 Using the ORDER BY Clause with SET Operators (Code Samples).html
5.2 KB
-
011 Using-the-ORDER-BY-Clause-with-SET-Operators-Code-Samples.sql
2.9 KB
-
012 Combining Multiple Queries Using the SET Operators.mp4
39.4 MB
-
012 Combining Multiple Queries Using the SET Operators_en.srt
8.4 KB
-
012 Source-Code-Combining-Multiple-Queries-Using-the-SET-Operators.sql
2.5 KB
-
013 Combining Multiple Queries Using the SET Operators (Code Samples).html
4.3 KB
-
013 Combining-Multiple-Queries-Using-the-SET-Operators-Code-Samples.sql
1.9 KB
-
014 Quiz (Set Operators).html
24.6 KB
-
001 Data Definition Language (DDL).mp4
15.4 MB
-
001 Data Definition Language (DDL)_en.srt
6.3 KB
-
002 Naming Rules & Naming Conventions in Oracle.mp4
79.8 MB
-
002 Naming Rules & Naming Conventions in Oracle_en.srt
16.1 KB
-
003 CREATE TABLE Statement.mp4
33.0 MB
-
003 CREATE TABLE Statement_en.srt
13.1 KB
-
004 CREATE TABLE Statement (Code Samples).html
3.2 KB
-
004 CREATE-TABLE-Statement-Code-Samples.sql
985 bytes
-
005 CREATE TABLE AS SELECT (CTAS) Statement in Oracle.mp4
105.1 MB
-
005 CREATE TABLE AS SELECT (CTAS) Statement in Oracle_en.srt
17.0 KB
-
006 CREATE TABLE AS SELECT (CTAS) Statement in Oracle (Code Samples).html
3.6 KB
-
006 CREATE-TABLE-AS-SELECT-CTAS-Statement-in-Oracle.sql
1.3 KB
-
007 ALTER TABLE Statement.mp4
159.9 MB
-
007 ALTER TABLE Statement_en.srt
25.9 KB
-
008 ALTER TABLE Statement (Code Samples).html
3.6 KB
-
008 ALTER-TABLE-Statement-Code-Samples.sql
1.3 KB
-
009 Marking Columns Unused (Using The SET UNUSED Clause).mp4
26.7 MB
-
009 Marking Columns Unused (Using The SET UNUSED Clause)_en.srt
12.7 KB
-
010 Marking Columns Unused (Using The SET UNUSED Clause) (Code Samples).html
2.9 KB
-
010 Marking-Columns-Unused-Using-The-SET-UNUSED-Clause-Code-Samples.sql
604 bytes
-
011 READ-ONLY Tables in SQL.mp4
47.4 MB
-
011 READ-ONLY Tables in SQL_en.srt
10.2 KB
-
012 READ-ONLY Tables in SQL (Code Samples).html
2.8 KB
-
012 READ-ONLY-Tables-in-SQL-Code-Samples.sql
598 bytes
-
013 DROP TABLE Statement.mp4
32.0 MB
-
013 DROP TABLE Statement_en.srt
12.4 KB
-
014 DROP TABLE Statement (Code Samples).html
2.9 KB
-
014 DROP-TABLE-Statement-Code-Samples.sql
704 bytes
-
015 TRUNCATE TABLE Statement.mp4
35.4 MB
-
015 TRUNCATE TABLE Statement_en.srt
14.7 KB
-
016 TRUNCATE TABLE Statement (Code Samples).html
3.0 KB
-
016 TRUNCATE-TABLE-Statement-Code-Samples.sql
799 bytes
-
017 COMMENT Statement.mp4
70.2 MB
-
017 COMMENT Statement_en.srt
13.6 KB
-
018 COMMENT Statement (Code Samples).html
3.2 KB
-
018 COMMENT-Statement-Code-Samples.sql
943 bytes
-
019 RENAME Statement.mp4
23.0 MB
-
019 RENAME Statement_en.srt
7.9 KB
-
020 RENAME Statement (Code Samples).html
2.8 KB
-
020 RENAME-Statement-Code-Samples.sql
606 bytes
-
021 Quiz (Data Definition Language).html
23.1 KB
-
001 Data Manipulation Language (DML).mp4
19.0 MB
-
001 Data Manipulation Language (DML)_en.srt
7.9 KB
-
002 INSERT Statement (Part 1).mp4
64.3 MB
-
002 INSERT Statement (Part 1)_en.srt
20.2 KB
-
003 INSERT Statement (Part 1) (Code Samples).html
3.8 KB
-
003 INSERT-Statement-Part-1-Code-Samples.sql
1.2 KB
-
004 INSERT Statement (Part 2).mp4
180.9 MB
-
004 INSERT Statement (Part 2)_en.srt
27.1 KB
-
005 INSERT Statement (Part 2) (Code Samples).html
3.8 KB
-
005 INSERT-Statement-Part-2-Code-Samples.sql
1.5 KB
-
006 Multitable Insert Statements.mp4
16.8 MB
-
006 Multitable Insert Statements_en.srt
4.6 KB
-
007 Unconditional Insert Statements (INSERT ALL Statements).mp4
70.3 MB
-
007 Unconditional Insert Statements (INSERT ALL Statements)_en.srt
15.1 KB
-
008 Unconditional Insert Statements (INSERT ALL Statements) (Code Samples).html
3.8 KB
-
008 Unconditional-Insert-Statements-INSERT-ALL-Statements-Code-Samples.sql
1.5 KB
-
009 Conditional INSERT ALL Statements.mp4
125.6 MB
-
009 Conditional INSERT ALL Statements_en.srt
19.0 KB
-
010 Conditional INSERT ALL Statements (Code Samples).html
5.0 KB
-
010 Conditional-INSERT-ALL-Statements-Code-Samples.sql
2.7 KB
-
011 Conditional INSERT FIRST Statements.mp4
43.8 MB
-
011 Conditional INSERT FIRST Statements_en.srt
9.0 KB
-
012 Conditional INSERT FIRST Statements (Code Samples).html
3.6 KB
-
012 Conditional-INSERT-FIRST-Statements-Code-Samples.sql
1.3 KB
-
013 Pivoting Insert.mp4
80.7 MB
-
013 Pivoting Insert_en.srt
13.7 KB
-
014 Pivoting Insert (Code Samples).html
3.8 KB
-
014 Pivoting-Insert-Code-Samples.sql
1.6 KB
-
015 UPDATE Statement.mp4
106.4 MB
-
015 UPDATE Statement_en.srt
15.9 KB
-
016 UPDATE Statement (Code Samples).html
3.2 KB
-
016 UPDATE-Statement-Code-Samples.sql
955 bytes
-
017 DELETE Statement.mp4
40.9 MB
-
017 DELETE Statement_en.srt
6.5 KB
-
018 DELETE Statement (Code Samples).html
2.9 KB
-
018 DELETE-Statement-Code-Samples.sql
641 bytes
-
019 MERGE Statement.mp4
160.6 MB
-
019 MERGE Statement_en.srt
28.6 KB
-
020 MERGE Statement (Code Samples).html
4.3 KB
-
020 MERGE-Statement-Code-Samples.sql
2.0 KB
-
021 (TCL) Transaction Control Language & TCL Commands.mp4
43.7 MB
-
021 (TCL) Transaction Control Language & TCL Commands_en.srt
9.4 KB
-
022 (TCL) Transaction Control Language & TCL Commands (Code Samples).html
2.7 KB
-
022 -TCL-Transaction-Control-Language-TCL-Commands-Code-Samples.sql
412 bytes
-
023 COMMIT and ROLLBACK Statements.mp4
105.7 MB
-
023 COMMIT and ROLLBACK Statements_en.srt
18.1 KB
-
024 COMMIT and ROLLBACK Statements (Code Samples).html
3.0 KB
-
024 COMMIT-and-ROLLBACK-Statements-Code-Samples.sql
747 bytes
-
025 Row Lock in Oracle.mp4
27.1 MB
-
025 Row Lock in Oracle_en.srt
12.5 KB
-
026 Row Lock in Oracle (Code Samples).html
3.0 KB
-
026 Row-Lock-in-Oracle-Code-Samples.sql
746 bytes
-
027 SAVEPOINT Statement.mp4
63.6 MB
-
027 SAVEPOINT Statement_en.srt
19.9 KB
-
028 SAVEPOINT Statement (Code Samples).html
3.2 KB
-
028 SAVEPOINT-Statement-Code-Samples.sql
981 bytes
-
029 FOR UPDATE Statement.mp4
156.0 MB
-
029 FOR UPDATE Statement_en.srt
24.0 KB
-
030 FOR UPDATE Statement (Code Samples).html
3.8 KB
-
030 FOR-UPDATE-Statement-Code-Samples.sql
1.6 KB
-
031 Quiz (Data Manipulation Language).html
23.5 KB
-
001 FLASHBACK Operations (Part 1).mp4
74.5 MB
-
001 FLASHBACK Operations (Part 1)_en.srt
18.3 KB
-
002 FLASHBACK Operations (Part 2).mp4
168.5 MB
-
002 FLASHBACK Operations (Part 2)_en.srt
23.6 KB
-
003 FLASHBACK Operations (Part 2) (Code Samples).html
3.5 KB
-
003 FLASHBACK-Operations-Part-2-Code-Samples.sql
1.2 KB
-
004 PURGE Operations.mp4
87.5 MB
-
004 PURGE Operations_en.srt
14.3 KB
-
005 PURGE Operations (Code Samples).html
3.1 KB
-
005 PURGE-Operations-Code-Samples.sql
842 bytes
-
006 Tracking Changes In Data In a Particular Time.mp4
118.5 MB
-
006 Tracking Changes In Data In a Particular Time_en.srt
19.2 KB
-
007 Tracking Changes In Data In a Particular Time (Code Samples).html
3.5 KB
-
007 Tracking-Changes-In-Data-In-a-Particular-Time-Code-Samples.sql
1.2 KB
-
008 Quiz (Flashback Technologies).html
26.5 KB
-
001 What is a Constraint Oracle Constraint Types.mp4
40.9 MB
-
001 What is a Constraint Oracle Constraint Types_en.srt
11.4 KB
-
002 NOT NULL Constraint.mp4
24.1 MB
-
002 NOT NULL Constraint_en.srt
9.5 KB
-
003 NOT NULL Constraint (Code Samples).html
3.0 KB
-
003 NOT-NULL-Constraint-Code-Samples.sql
760 bytes
-
004 UNIQUE Constraint.mp4
139.7 MB
-
004 UNIQUE Constraint_en.srt
34.0 KB
-
005 UNIQUE Constraint (Code Samples).html
4.1 KB
-
005 UNIQUE-Constraint-Code-Samples.sql
1.8 KB
-
006 PRIMARY KEY Constraint.mp4
72.0 MB
-
006 PRIMARY KEY Constraint_en.srt
17.1 KB
-
007 PRIMARY KEY Constraint (Code Samples).html
3.7 KB
-
007 PRIMARY-KEY-Constraint-Code-Samples.sql
1.4 KB
-
008 FOREIGN KEY Constraint (Part 1).mp4
123.2 MB
-
008 FOREIGN KEY Constraint (Part 1)_en.srt
19.5 KB
-
009 FOREIGN KEY Constraint (Part 2).mp4
69.8 MB
-
009 FOREIGN KEY Constraint (Part 2)_en.srt
14.4 KB
-
010 FOREIGN KEY Constraint (Code Samples).html
5.5 KB
-
010 FOREIGN-KEY-Constraint-Code-Samples.sql
3.3 KB
-
011 The ON DELETE CASCADE ON DELETE SET NULL Clause.mp4
64.8 MB
-
011 The ON DELETE CASCADE ON DELETE SET NULL Clause_en.srt
12.2 KB
-
012 The ON DELETE CASCADE ON DELETE SET NULL Clause (Code Samples).html
4.3 KB
-
012 The-ON-DELETE-CASCADE-ON-DELETE-SET-NULL-Clause-Code-Samples.sql
2.0 KB
-
013 CHECK Constraint.mp4
31.3 MB
-
013 CHECK Constraint_en.srt
11.7 KB
-
014 CHECK Constraint (Code Samples).html
3.3 KB
-
014 CHECK-Constraint-Code-Samples.sql
1.0 KB
-
015 Adding Constraints via ALTER TABLE Statements.mp4
79.1 MB
-
015 Adding Constraints via ALTER TABLE Statements_en.srt
16.2 KB
-
016 Adding Constraints via ALTER TABLE Statements (Code Samples).html
3.4 KB
-
016 Adding-Constraints-via-ALTER-TABLE-Statements-Code-Samples.sql
1.1 KB
-
017 Dropping (Removing) Constraints.mp4
41.9 MB
-
017 Dropping (Removing) Constraints_en.srt
9.2 KB
-
018 Dropping (Removing) Constraints (Code Samples).html
3.3 KB
-
018 Dropping-Removing-Constraints-Code-Samples.sql
1018 bytes
-
019 Cascading Constraints in Oracle.mp4
51.7 MB
-
019 Cascading Constraints in Oracle_en.srt
8.3 KB
-
020 Cascading Constraints in Oracle (Code Samples).html
3.4 KB
-
020 Cascading-Constraints-in-Oracle-Code-Samples.sql
1.1 KB
-
021 Renaming Constraints.mp4
11.9 MB
-
021 Renaming Constraints_en.srt
5.1 KB
-
022 Renaming Constraints (Code Samples).html
2.7 KB
-
022 Renaming-Constraints-Code-Samples.sql
446 bytes
-
023 Disabling Constraints.mp4
68.9 MB
-
023 Disabling Constraints_en.srt
14.6 KB
-
024 Disabling Constraints (Code Samples).html
3.4 KB
-
024 Disabling-Constraints-Code-Samples.sql
1.2 KB
-
025 Enabling Constraints.mp4
36.8 MB
-
025 Enabling Constraints_en.srt
8.0 KB
-
026 Enabling Constraints (Code Samples).html
2.8 KB
-
026 Enabling-Constraints-Code-Samples.sql
573 bytes
-
027 Status of Constraints.mp4
65.9 MB
-
027 Status of Constraints_en.srt
13.9 KB
-
028 Status of Constraints (Code Samples).html
3.5 KB
-
028 Status-of-Constraints-Code-Samples.sql
1.2 KB
-
029 Deferring Constraints (Part 1).mp4
56.5 MB
-
029 Deferring Constraints (Part 1)_en.srt
14.1 KB
-
030 Deferring Constraints (Part 2).mp4
61.2 MB
-
030 Deferring Constraints (Part 2)_en.srt
13.4 KB
-
031 Deferring Constraints (Code Samples).html
3.2 KB
-
031 Deferring-Constraints-Code-Samples.sql
932 bytes
-
032 Quiz (Constraints).html
24.9 KB
-
001 What is a View and What is it Used for.mp4
21.7 MB
-
001 What is a View and What is it Used for_en.srt
6.9 KB
-
002 View Types in Oracle.mp4
6.7 MB
-
002 View Types in Oracle_en.srt
3.8 KB
-
003 Creating Simple Views.mp4
49.5 MB
-
003 Creating Simple Views_en.srt
17.1 KB
-
004 Creating Simple Views (Code Samples).html
3.4 KB
-
004 Creating-Simple-Views-Code-Samples.sql
1.2 KB
-
005 Creating Complex Views.mp4
11.1 MB
-
005 Creating Complex Views_en.srt
4.1 KB
-
006 Creating Complex Views (Code Samples).html
2.8 KB
-
006 Creating-Complex-Views-Code-Samples.sql
562 bytes
-
007 Modifying Views.mp4
15.0 MB
-
007 Modifying Views_en.srt
5.8 KB
-
008 Modifying Views (Code Samples).html
2.9 KB
-
008 Modifying-Views-Code-Samples.sql
643 bytes
-
009 Performing DML Operations with Views.mp4
81.3 MB
-
009 Performing DML Operations with Views_en.srt
12.8 KB
-
010 Performing DML Operations with Views (Code Samples).html
4.2 KB
-
010 Performing-DML-Operations-with-Views-Code-Samples.sql
1.9 KB
-
011 Using the WITH CHECK OPTION Clause in SQL.mp4
39.6 MB
-
011 Using the WITH CHECK OPTION Clause in SQL_en.srt
12.6 KB
-
012 Using the WITH CHECK OPTION Clause in SQL (Code Samples).html
4.1 KB
-
012 Using-the-WITH-CHECK-OPTION-Clause-in-SQL-Code-Samples.sql
1.8 KB
-
013 Using the WITH READ ONLY Clause on Views.mp4
13.0 MB
-
013 Using the WITH READ ONLY Clause on Views_en.srt
5.0 KB
-
014 Using the WITH READ ONLY Clause on Views (Code Samples).html
3.0 KB
-
014 Using-the-WITH-READ-ONLY-Clause-on-Views-Code-Samples.sql
746 bytes
-
015 Dropping Views.mp4
15.7 MB
-
015 Dropping Views_en.srt
8.1 KB
-
016 Dropping Views (Code Samples).html
2.7 KB
-
016 Dropping-Views-Code-Samples.sql
510 bytes
-
017 Quiz (Views).html
23.1 KB
-
001 What are Data Dictionary Views in Oracle.mp4
17.2 MB
-
001 What are Data Dictionary Views in Oracle_en.srt
7.3 KB
-
002 The Dictionary View.mp4
45.0 MB
-
002 The Dictionary View_en.srt
9.9 KB
-
003 The Dictionary View (Code Samples).html
2.7 KB
-
003 The-Dictionary-View-Code-Samples.sql
492 bytes
-
004 Difference Between USER, ALL, DBA and V$ Prefixes.mp4
14.1 MB
-
004 Difference Between USER, ALL, DBA and V$ Prefixes_en.srt
5.9 KB
-
005 USER_OBJECTS, ALL_OBJECTS and DBA_OBJECTS Views.mp4
73.7 MB
-
005 USER_OBJECTS, ALL_OBJECTS and DBA_OBJECTS Views_en.srt
10.6 KB
-
006 USER_OBJECTS, ALL_OBJECTS and DBA_OBJECTS Views (Code Samples).html
2.8 KB
-
006 USER-OBJECTS-ALL-OBJECTS-and-DBA-OBJECTS-Views-Code-Samples.sql
475 bytes
-
007 USER_TABLES Data Dictionary View.mp4
21.0 MB
-
007 USER_TABLES Data Dictionary View_en.srt
6.3 KB
-
008 USER_TABLES Data Dictionary View (Code Samples).html
2.7 KB
-
008 USER-TABLES-Data-Dictionary-View-Code-Samples.sql
444 bytes
-
009 USER_TAB_COLUMNS Data Dictionary View.mp4
24.3 MB
-
009 USER_TAB_COLUMNS Data Dictionary View_en.srt
9.7 KB
-
010 USER_TAB_COLUMNS Data Dictionary View (Code Samples).html
2.8 KB
-
010 USER-TAB-COLUMNS-Data-Dictionary-View-Code-Samples.sql
500 bytes
-
011 USER_CONSTRAINTS Data Dictionary View.mp4
45.1 MB
-
011 USER_CONSTRAINTS Data Dictionary View_en.srt
13.9 KB
-
012 USER_CONSTRAINTS Data Dictionary View (Code Samples).html
2.7 KB
-
012 USER-CONSTRAINTS-Data-Dictionary-View-Code-Samples.sql
432 bytes
-
013 USER_CONS_COLUMNS Data Dictionary View.mp4
46.6 MB
-
013 USER_CONS_COLUMNS Data Dictionary View_en.srt
7.6 KB
-
014 USER_CONS_COLUMNS Data Dictionary View (Code Samples).html
3.5 KB
-
014 USER-CONS-COLUMNS-Data-Dictionary-View-Code-Samples.sql
1.3 KB
-
015 USER_VIEWS Data Dictionary View.mp4
12.5 MB
-
015 USER_VIEWS Data Dictionary View_en.srt
5.2 KB
-
016 USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views.mp4
49.0 MB
-
016 USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views_en.srt
8.7 KB
-
017 USER_TAB_COMMENTS and USER_COL_COMMENTS Data Dictionary Views (Code Samples).html
3.0 KB
-
017 USER-TAB-COMMENTS-and-USER-COL-COMMENTS-Data-Dictionary-Views-Code-Samples.sql
672 bytes
-
018 Quiz (Data Dictionary Views).html
23.1 KB
-
001 What is a Sequence.mp4
11.3 MB
-
001 What is a Sequence_en.srt
4.6 KB
-
002 Creating Sequences.mp4
34.4 MB
-
002 Creating Sequences_en.srt
13.9 KB
-
003 Creating Sequences (Code Samples).html
2.7 KB
-
003 Creating-Sequences-Code-Samples.sql
512 bytes
-
004 Modifying Sequences.mp4
17.9 MB
-
004 Modifying Sequences_en.srt
6.4 KB
-
005 Modifying Sequences (Code Samples).html
2.9 KB
-
005 Modifying-Sequences-Code-Samples.sql
655 bytes
-
006 Dropping Sequences.mp4
4.0 MB
-
006 Dropping Sequences_en.srt
2.2 KB
-
007 Using Sequences.mp4
77.0 MB
-
007 Using Sequences_en.srt
14.7 KB
-
008 Using Sequences (Code Samples).html
3.0 KB
-
008 Using-Sequences-Code-Samples.sql
761 bytes
-
009 Using Sequences as a Default Value.mp4
39.0 MB
-
009 Using Sequences as a Default Value_en.srt
8.7 KB
-
010 Using Sequences as a Default Value (Code Samples).html
2.9 KB
-
010 Using-Sequences-as-a-Default-Value-Code-Samples.sql
682 bytes
-
011 Sequence Caching.mp4
7.9 MB
-
011 Sequence Caching_en.srt
4.3 KB
-
012 The User_Sequences View.mp4
27.5 MB
-
012 The User_Sequences View_en.srt
4.9 KB
-
013 IDENTITY-Column-Source-Code.txt
2.0 KB
-
013 Oracle IDENTITY Column (Part 1).mp4
50.7 MB
-
013 Oracle IDENTITY Column (Part 1)_en.srt
12.5 KB
-
014 Oracle IDENTITY Column (Part 2).mp4
53.6 MB
-
014 Oracle IDENTITY Column (Part 2)_en.srt
18.6 KB
-
015 Oracle IDENTITY Column (Code Samples).html
3.7 KB
-
015 Oracle-IDENTITY-Column-Code-Samples.sql
1.4 KB
-
016 Quiz (Sequences).html
26.5 KB
-
001 What is a Synonym.mp4
11.2 MB
-
001 What is a Synonym_en.srt
6.3 KB
-
002 Creating, Using, and Dropping Synonyms.mp4
80.1 MB
-
002 Creating, Using, and Dropping Synonyms_en.srt
25.4 KB
-
003 Creating, Using, and Dropping Synonyms (Code Samples).html
3.2 KB
-
003 Creating-Using-and-Dropping-Synonyms-Code-Samples.sql
982 bytes
-
004 Analyzing The USER_SYNONYMS View.mp4
18.2 MB
-
004 Analyzing The USER_SYNONYMS View_en.srt
7.1 KB
-
005 Analyzing The USER_SYNONYMS View (Code Samples).html
2.7 KB
-
005 Analyzing-The-USER-SYNONYMS-View-Code-Samples.sql
464 bytes
-
006 Quiz (Synonyms).html
21.7 KB
-
001 What is an Index in SQL.mp4
125.5 MB
-
001 What is an Index in SQL_en.srt
22.0 KB
-
002 Index Types in SQL.mp4
76.3 MB
-
002 Index Types in SQL_en.srt
19.2 KB
-
003 How to Create Indexes (Part 1).mp4
36.9 MB
-
003 How to Create Indexes (Part 1)_en.srt
12.3 KB
-
004 How to Create Indexes (Part 1) (Code Samples).html
2.8 KB
-
004 How-to-Create-Indexes-Part-1-Code-Samples.sql
533 bytes
-
005 How to Create Indexes (Part 2).mp4
43.1 MB
-
005 How to Create Indexes (Part 2)_en.srt
13.3 KB
-
006 How to Create Indexes (Part 2) (Code Samples).html
3.1 KB
-
006 How-to-Create-Indexes-Part-2-Code-Samples.sql
804 bytes
-
007 How to Create Indexes While Table Creation.mp4
54.9 MB
-
007 How to Create Indexes While Table Creation_en.srt
19.0 KB
-
008 How to Create Indexes While Table Creation (Code Samples).html
5.7 KB
-
008 How-to-Create-Indexes-While-Table-Creation-Code-Samples.sql
3.4 KB
-
009 How to Remove (Drop) Indexes.mp4
13.4 MB
-
009 How to Remove (Drop) Indexes_en.srt
4.1 KB
-
010 How to Remove (Drop) Indexes (Code Samples).html
2.6 KB
-
010 How-to-Remove-Drop-Indexes-Code-Samples.sql
340 bytes
-
011 Function-Based Indexes.mp4
52.9 MB
-
011 Function-Based Indexes_en.srt
9.9 KB
-
012 Function-Based Indexes (Code Samples).html
3.3 KB
-
012 Function-Based-Indexes-Code-Samples.sql
1.0 KB
-
013 Multiple Indexes on the Same Columns & Invisible Indexes.mp4
68.6 MB
-
013 Multiple Indexes on the Same Columns & Invisible Indexes_en.srt
20.0 KB
-
014 Multiple Indexes on the Same Columns & Invisible Indexes (Code Samples).html
3.7 KB
-
014 Multiple-Indexes-on-the-Same-Columns-Invisible-Indexes-Code-Samples.sql
1.3 KB
-
015 Analyzing the USER_INDEXES and USER_IND_COLUMNS Views.mp4
55.1 MB
-
015 Analyzing the USER_INDEXES and USER_IND_COLUMNS Views_en.srt
9.5 KB
-
016 Analyzing the USER_INDEXES and USER_IND_COLUMNS Views (Code Samples).html
2.9 KB
-
016 Analyzing-USER-INDEXES-and-USER-IND-COLUMNS-Views-Code-Samples.sql
630 bytes
-
017 How to Modify (Alter) Indexes.mp4
77.5 MB
-
017 How to Modify (Alter) Indexes_en.srt
14.9 KB
-
018 Altering-Indexes-Code-Samples.sql
1.4 KB
-
018 How to Modify (Alter) Indexes (Code Samples).html
3.6 KB
-
019 Quiz (Indexes).html
35.1 KB
-
001 What are Privileges in SQL.mp4
50.7 MB
-
001 What are Privileges in SQL_en.srt
7.3 KB
-
002 How to Create a User in Oracle Database (Part 1).mp4
39.0 MB
-
002 How to Create a User in Oracle Database (Part 1)_en.srt
12.3 KB
-
003 How to Create a User in Oracle Database (Part 2).mp4
74.4 MB
-
003 How to Create a User in Oracle Database (Part 2)_en.srt
16.3 KB
-
004 How to Create a User in Oracle Database (Code Samples).html
3.0 KB
-
004 How-to-Create-a-User-in-Oracle-Database-Code-Samples.sql
707 bytes
-
005 Changing Database Users' Passwords in Oracle Database.mp4
19.7 MB
-
005 Changing Database Users' Passwords in Oracle Database_en.srt
7.6 KB
-
006 Changing Users' Passwords in Oracle Database (Code Samples).html
2.7 KB
-
006 Changing-Users-Passwords-in-Oracle-Database-Code-Samples.sql
372 bytes
-
007 Granting System Privileges.mp4
122.8 MB
-
007 Granting System Privileges_en.srt
22.6 KB
-
008 Granting System Privileges (Code Samples).html
3.0 KB
-
008 Granting-System-Privileges-Code-Samples.sql
714 bytes
-
009 Roles and PUBLIC (Part 1).mp4
41.8 MB
-
009 Roles and PUBLIC (Part 1)_en.srt
15.4 KB
-
010 Roles and PUBLIC (Code Samples).html
3.3 KB
-
011 Roles and PUBLIC (Part 2).mp4
71.2 MB
-
011 Roles and PUBLIC (Part 2)_en.srt
19.7 KB
-
012 Granting Object Privileges.mp4
93.9 MB
-
012 Granting Object Privileges_en.srt
20.8 KB
-
013 Granting Object Privileges (Code Samples).html
3.5 KB
-
013 Granting-Object-Privileges-Code-Samples.sql
1.2 KB
-
014 Definer's Rights and Invoker's Rights (Part 1).mp4
84.3 MB
-
014 Definer's Rights and Invoker's Rights (Part 1)_en.srt
19.4 KB
-
015 Definer's Rights and Invoker's Rights (Part 2).mp4
46.8 MB
-
015 Definer's Rights and Invoker's Rights (Part 2)_en.srt
19.7 KB
-
016 Definer's Rights and Invoker's Rights (Code Samples).html
4.8 KB
-
016 Definers-Rights-and-Invokers-Rights-Code-Samples.sql
2.5 KB
-
017 Revoking Privileges and Roles (Part 1).mp4
43.5 MB
-
017 Revoking Privileges and Roles (Part 1)_en.srt
9.7 KB
-
018 Revoking Privileges and Roles (Part 2).mp4
71.1 MB
-
018 Revoking Privileges and Roles (Part 2)_en.srt
14.0 KB
-
019 Revoking Privileges and Roles (Code Samples).html
3.7 KB
-
019 Revoking-Privileges-and-Roles-Code-Samples.sql
1.4 KB
-
020 Searching Privileges Using Data Dictionary Views.html
2.9 KB
-
020 Searching-Privileges-Using-Data-Dictionary-Views.pdf
401.6 KB
-
021 Quiz (Privileges & Roles).html
32.6 KB
-
022 Good News!.html
2.8 KB
-
001 Appendix 1 Oracle Database 12c Installation into Your Computer.mp4
44.9 MB
-
001 Appendix 1 Oracle Database 12c Installation into Your Computer_en.srt
12.1 KB
-
001 Oracles-Official-Website.url
47 bytes
-
002 Appendix 2 How to Unlock the HR Schema in the Oracle Database 12c.html
5.3 KB
-
003 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp4
51.5 MB
-
003 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c_en.srt
12.3 KB
-
004 Appendix 4 How to Uninstall Oracle Database.html
4.2 KB
-
005 How to Enroll in Oracle 1Z0-071 SQL Associate Certification Exam.html
4.2 KB
-
external-links.txt
57 bytes
-
001 Code-Samples.pdf
84.1 KB
-
002 SQL Cheatsheet.html
3.1 KB
-
002 SQL-Cheatsheet-By-Database-Masters-Training.pdf
3.5 MB
-
003 Oracle-Database-SQL-Certified-Associate-1Z0-071-Exam-Dump-1.pdf
576.6 KB
-
003 Oracle-Database-SQL-Certified-Associate-1Z0-071-Exam-Dump-2.pdf
2.0 MB
-
003 Oracle-Database-SQL-Fundamentals-1Z0-061-Exam-1.pdf
2.9 MB
-
003 Oracle-Database-SQL-Fundamentals-1Z0-061-Exam-2.pdf
1.6 MB
-
003 SQL Certification Exam Samples.html
3.4 KB
-
004 Bonus Lecture.html
4.8 KB
|
Discussion