[FreeCourseSite.com] Udemy - The Complete Oracle SQL Bootcamp (2022)

File Name

Size

0. Websites you may like/[CourseClub.Me].url

122 B

0. Websites you may like/[FreeCourseSite.com].url

127 B

0. Websites you may like/[GigaCourse.Com].url

49 B

01 - Database Concepts/001 What is a Database.mp4

69 MB

01 - Database Concepts/001 What is a Database_en.vtt

8.3 kB

01 - Database Concepts/002 Why Oracle Database.mp4

62 MB

01 - Database Concepts/002 Why Oracle Database_en.vtt

8.1 kB

01 - Database Concepts/003 What is a Table.mp4

38 MB

01 - Database Concepts/003 What is a Table_en.vtt

3.7 kB

01 - Database Concepts/004 UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).mp4

18 MB

01 - Database Concepts/004 UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip)_en.vtt

5.4 kB

01 - Database Concepts/005 Download-the-Working-Document.url

106 B

01 - Database Concepts/005 The Working Document (Course Slide).html

1.1 kB

01 - Database Concepts/006 Oracle-Database-12c-Database-SQL-1Z0-071-Exam-2016-07-12.pdf

574 kB

01 - Database Concepts/006 Oracle-Database-12c-Database-SQL-1Z0-071-Exam-2018-06-30.pdf

2.1 MB

01 - Database Concepts/006 Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam-04.03.2017.pdf

1.6 MB

01 - Database Concepts/006 SQL-Cheatsheet-Oracle-Master.pdf

3.6 MB

01 - Database Concepts/006 Special Gifts for Our Students!(SQL Cheatsheet & SQL Certification Exam Samples).html

1.3 kB

01 - Database Concepts/007 What is a Relational Database (RDBMS).mp4

52 MB

01 - Database Concepts/007 What is a Relational Database (RDBMS)_en.vtt

8.1 kB

01 - Database Concepts/008 Entity Relationship Logic in Databases.mp4

21 MB

01 - Database Concepts/008 Entity Relationship Logic in Databases_en.vtt

4.0 kB

01 - Database Concepts/009 What is Pluggable Database.mp4

8.7 MB

01 - Database Concepts/009 What is Pluggable Database_en.vtt

3.4 kB

01 - Database Concepts/010 Introduction to Database Objects.mp4

112 MB

01 - Database Concepts/010 Introduction to Database Objects_en.vtt

14 kB

01 - Database Concepts/011 HR-Schema-Relationship.png

233 kB

01 - Database Concepts/011 The Sample (HR) Schema Used in This Course.mp4

45 MB

01 - Database Concepts/011 The Sample (HR) Schema Used in This Course_en.vtt

7.9 kB

01 - Database Concepts/012 What is SQL.mp4

45 MB

01 - Database Concepts/012 What is SQL_en.vtt

5.4 kB

01 - Database Concepts/external-links.txt

121 B

02 - Software Download & Installation/001 About the Database Installation.mp4

50 MB

02 - Software Download & Installation/001 About the Database Installation_en.vtt

4.6 kB

02 - Software Download & Installation/002 The Ways to Get a Database.mp4

67 MB

02 - Software Download & Installation/002 The Ways to Get a Database_en.vtt

19 kB

02 - Software Download & Installation/003 Download-Oracle-Virtualbox.url

65 B

02 - Software Download & Installation/003 Download-VMware-Workstation-Player.url

109 B

02 - Software Download & Installation/003 Option 1 Installing VMware and VirtualBox on Windows.mp4

66 MB

02 - Software Download & Installation/003 Option 1 Installing VMware and VirtualBox on Windows_en.vtt

7.9 kB

02 - Software Download & Installation/004 Option 1 How to Install the Virtual Box on Mac OS X.html

4.0 kB

02 - Software Download & Installation/005 Download-Virtual-Machine-Image.url

91 B

02 - Software Download & Installation/005 Option 1 Downloading Virtual Machine Image.mp4

29 MB

02 - Software Download & Installation/005 Option 1 Downloading Virtual Machine Image_en.vtt

4.3 kB

02 - Software Download & Installation/006 Option 1 Configuring the VMware Virtualization Software.mp4

72 MB

02 - Software Download & Installation/006 Option 1 Configuring the VMware Virtualization Software_en.vtt

8.9 kB

02 - Software Download & Installation/007 Option 1 Configuring the Oracle VirtualBox Virtualization Software.mp4

46 MB

02 - Software Download & Installation/007 Option 1 Configuring the Oracle VirtualBox Virtualization Software_en.vtt

7.6 kB

02 - Software Download & Installation/008 Option 1 Configuring SQL Developer inside of the Virtual Machine.mp4

70 MB

02 - Software Download & Installation/008 Option 1 Configuring SQL Developer inside of the Virtual Machine_en.vtt

15 kB

02 - Software Download & Installation/009 Important Note.html

639 B

02 - Software Download & Installation/010 Option 2 Downloading And Installing Oracle Database.mp4

167 MB

02 - Software Download & Installation/010 Option 2 Downloading And Installing Oracle Database_en.vtt

19 kB

02 - Software Download & Installation/010 Oracles-Official-Website.url

108 B

02 - Software Download & Installation/011 HR-Schema-Create-Code.sql

70 kB

02 - Software Download & Installation/011 Option 2 HR Schema Create Code (if you could not get the HR user in other ways).html

71 kB

02 - Software Download & Installation/012 -Oracle-Master-Training-Scripts-to-Unlock-the-HR-Schema.pdf

231 kB

02 - Software Download & Installation/012 Option 2 Unlocking the HR Schema.mp4

17 MB

02 - Software Download & Installation/012 Option 2 Unlocking the HR Schema_en.vtt

8.1 kB

02 - Software Download & Installation/013 Option 2 Configuring and Using the SQL Developer.mp4

137 MB

02 - Software Download & Installation/013 Option 2 Configuring and Using the SQL Developer_en.vtt

23 kB

02 - Software Download & Installation/014 Installation-Code.txt

1.3 kB

02 - Software Download & Installation/014 Option 2 Installing Sample Schemas in Oracle Database.mp4

90 MB

02 - Software Download & Installation/014 Option 2 Installing Sample Schemas in Oracle Database_en.vtt

7.5 kB

02 - Software Download & Installation/014 sample-schemas.zip

14 MB

02 - Software Download & Installation/015 Option 3 Using Oracle Live SQL.mp4

19 MB

02 - Software Download & Installation/015 Option 3 Using Oracle Live SQL_en.vtt

7.5 kB

02 - Software Download & Installation/016 Option 3 Oracle Live SQL Limitations.html

1.1 kB

02 - Software Download & Installation/017 SQL Statements Used in This Course.mp4

39 MB

02 - Software Download & Installation/017 SQL Statements Used in This Course_en.vtt

5.3 kB

02 - Software Download & Installation/018 Don't Forget to Leave a Rating!.html

622 B

02 - Software Download & Installation/external-links.txt

431 B

03 - Retrieving Data/001 Oracle Data Types.mp4

53 MB

03 - Retrieving Data/001 Oracle Data Types_en.vtt

6.9 kB

03 - Retrieving Data/002 What is a NULL Value.mp4

36 MB

03 - Retrieving Data/002 What is a NULL Value_en.vtt

5.2 kB

03 - Retrieving Data/003 DESCRIBE Command.mp4

28 MB

03 - Retrieving Data/003 DESCRIBE Command_en.vtt

4.4 kB

03 - Retrieving Data/004 INFORMATION Command.mp4

28 MB

03 - Retrieving Data/004 INFORMATION Command_en.vtt

8.4 kB

03 - Retrieving Data/005 SQL Statement Basics.mp4

73 MB

03 - Retrieving Data/005 SQL Statement Basics_en.vtt

13 kB

03 - Retrieving Data/006 Oracle Error Messages.mp4

27 MB

03 - Retrieving Data/006 Oracle Error Messages_en.vtt

6.6 kB

03 - Retrieving Data/007 Using SELECT Statements.mp4

23 MB

03 - Retrieving Data/007 Using SELECT Statements_en.vtt

6.2 kB

03 - Retrieving Data/008 CODE Using SELECT Statements.html

219 B

03 - Retrieving Data/009 Using Column Aliases.mp4

25 MB

03 - Retrieving Data/009 Using Column Aliases_en.vtt

7.1 kB

03 - Retrieving Data/010 CODE Using Column Aliases.html

402 B

03 - Retrieving Data/011 Quote (Q) Operator.mp4

37 MB

03 - Retrieving Data/011 Quote (Q) Operator_en.vtt

8.4 kB

03 - Retrieving Data/012 DISTINCT and UNIQUE Operator.mp4

53 MB

03 - Retrieving Data/012 DISTINCT and UNIQUE Operator_en.vtt

7.5 kB

03 - Retrieving Data/013 Concatenation Operators.mp4

30 MB

03 - Retrieving Data/013 Concatenation Operators_en.vtt

7.4 kB

03 - Retrieving Data/014 Arithmetic Expressions and NULL Values.mp4

62 MB

03 - Retrieving Data/014 Arithmetic Expressions and NULL Values_en.vtt

9.8 kB

04 - Restricting Data/001 Using WHERE Clause.mp4

19 MB

04 - Restricting Data/001 Using WHERE Clause_en.vtt

4.4 kB

04 - Restricting Data/002 Comparison Operators.mp4

56 MB

04 - Restricting Data/002 Comparison Operators_en.vtt

6.1 kB

04 - Restricting Data/003 BETWEEN … AND Operator.mp4

25 MB

04 - Restricting Data/003 BETWEEN … AND Operator_en.vtt

5.3 kB

04 - Restricting Data/004 IN Operator.mp4

30 MB

04 - Restricting Data/004 IN Operator_en.vtt

9.5 kB

04 - Restricting Data/005 LIKE Operator.mp4

78 MB

04 - Restricting Data/005 LIKE Operator_en.vtt

12 kB

04 - Restricting Data/006 IS NULL Operator.mp4

20 MB

04 - Restricting Data/006 IS NULL Operator_en.vtt

5.0 kB

04 - Restricting Data/007 Logical Operators (AND, OR, NOT).mp4

86 MB

04 - Restricting Data/007 Logical Operators (AND, OR, NOT)_en.vtt

13 kB

04 - Restricting Data/008 Rules of Precedence.mp4

36 MB

04 - Restricting Data/008 Rules of Precedence_en.vtt

10 kB

04 - Restricting Data/009 SQL-Quiz-by-Oracle-Master-Training.pdf

3.3 MB

05 - Sorting Data/001 ORDER BY Clause.mp4

135 MB

05 - Sorting Data/001 ORDER BY Clause_en.vtt

15 kB

05 - Sorting Data/002 ASC and DESC Operators.mp4

51 MB

05 - Sorting Data/002 ASC and DESC Operators_en.vtt

9.8 kB

05 - Sorting Data/003 NULLS FIRST and NULLS LAST Operators.mp4

15 MB

05 - Sorting Data/003 NULLS FIRST and NULLS LAST Operators_en.vtt

4.2 kB

05 - Sorting Data/004 ROWNUM & ROWID in SQL.mp4

88 MB

05 - Sorting Data/004 ROWNUM & ROWID in SQL_en.vtt

13 kB

05 - Sorting Data/005 Oracle FETCH Clause.mp4

61 MB

05 - Sorting Data/005 Oracle FETCH Clause_en.vtt

12 kB

06 - Using Substitution Variables/001 What is a Substitution Variable.mp4

54 MB

06 - Using Substitution Variables/001 What is a Substitution Variable_en.vtt

15 kB

06 - Using Substitution Variables/002 Double Ampersand (&&) and DEFINE & UNDEFINE Commands.mp4

117 MB

06 - Using Substitution Variables/002 Double Ampersand (&&) and DEFINE & UNDEFINE Commands_en.vtt

18 kB

06 - Using Substitution Variables/003 ACCEPT and PROMPT Commands.mp4

45 MB

06 - Using Substitution Variables/003 ACCEPT and PROMPT Commands_en.vtt

7.9 kB

06 - Using Substitution Variables/004 SET VERIFY ON SET VERIFY OFF Commands.mp4

41 MB

06 - Using Substitution Variables/004 SET VERIFY ON SET VERIFY OFF Commands_en.vtt

7.7 kB

07 - Single-Row Functions/001 Single Row Functions.mp4

85 MB

07 - Single-Row Functions/001 Single Row Functions_en.vtt

12 kB

07 - Single-Row Functions/002 Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios.mp4

56 MB

07 - Single-Row Functions/002 Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios_en.vtt

14 kB

07 - Single-Row Functions/003 Character Functions - Character Manipulation Functios (Part 1).mp4

62 MB

07 - Single-Row Functions/003 Character Functions - Character Manipulation Functios (Part 1)_en.vtt

13 kB

07 - Single-Row Functions/004 Character Functions - Character Manipulation Functions Part 2 (INSTR Function).mp4

41 MB

07 - Single-Row Functions/004 Character Functions - Character Manipulation Functions Part 2 (INSTR Function)_en.vtt

10 kB

07 - Single-Row Functions/005 Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions).mp4

99 MB

07 - Single-Row Functions/005 Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions)_en.vtt

21 kB

07 - Single-Row Functions/006 Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions).mp4

78 MB

07 - Single-Row Functions/006 Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions)_en.vtt

12 kB

07 - Single-Row Functions/007 Numeric Functions.mp4

55 MB

07 - Single-Row Functions/007 Numeric Functions_en.vtt

17 kB

07 - Single-Row Functions/007 Oracle-Numeric-Functions.url

110 B

07 - Single-Row Functions/008 Nested Functions.mp4

78 MB

07 - Single-Row Functions/008 Nested Functions_en.vtt

16 kB

07 - Single-Row Functions/009 Date Values & Date Formats in Oracle.mp4

160 MB

07 - Single-Row Functions/009 Date Values & Date Formats in Oracle_en.vtt

26 kB

07 - Single-Row Functions/010 Date Functions & Arithmetic Operations on Dates.mp4

128 MB

07 - Single-Row Functions/010 Date Functions & Arithmetic Operations on Dates_en.vtt

18 kB

07 - Single-Row Functions/011 Date Manipulation Functions in SQL.mp4

81 MB

07 - Single-Row Functions/011 Date Manipulation Functions in SQL_en.vtt

21 kB

07 - Single-Row Functions/external-links.txt

120 B

08 - Conversion Functions/001 Conversion Functions.mp4

47 MB

08 - Conversion Functions/001 Conversion Functions_en.vtt

12 kB

08 - Conversion Functions/002 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1).mp4

74 MB

08 - Conversion Functions/002 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1)_en.vtt

17 kB

08 - Conversion Functions/003 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).mp4

109 MB

08 - Conversion Functions/003 TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2)_en.vtt

17 kB

08 - Conversion Functions/004 Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions.mp4

133 MB

08 - Conversion Functions/004 Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions_en.vtt

22 kB

09 - Conditional Expressions/001 Oracle Conditional Expressions CASE Expressions.mp4

131 MB

09 - Conditional Expressions/001 Oracle Conditional Expressions CASE Expressions_en.vtt

24 kB

09 - Conditional Expressions/002 Oracle Conditional Expressions DECODE Function.mp4

49 MB

09 - Conditional Expressions/002 Oracle Conditional Expressions DECODE Function_en.vtt

10 kB

10 - Group Functions/001 Group Functions.mp4

56 MB

10 - Group Functions/001 Group Functions_en.vtt

8.7 kB

10 - Group Functions/002 AVG Function.mp4

30 MB

10 - Group Functions/003 COUNT Function.mp4

16 MB

10 - Group Functions/003 COUNT Function_en.vtt

6.8 kB

10 - Group Functions/004 MAX Function.mp4

32 MB

10 - Group Functions/004 MAX Function_en.vtt

4.7 kB

10 - Group Functions/005 MIN Function.mp4

14 MB

10 - Group Functions/005 MIN Function_en.vtt

4.8 kB

10 - Group Functions/006 SUM Function.mp4

9.0 MB

10 - Group Functions/006 SUM Function_en.vtt

3.9 kB

10 - Group Functions/007 LISTAGG Function.mp4

34 MB

10 - Group Functions/007 LISTAGG Function_en.vtt

10 kB

10 - Group Functions/008 Overview Of Group Functions.mp4

12 MB

10 - Group Functions/008 Overview Of Group Functions_en.vtt

4.1 kB

11 - Grouping Data/001 GROUP BY Clause (Part 1).mp4

52 MB

11 - Grouping Data/001 GROUP BY Clause (Part 1)_en.vtt

16 kB

11 - Grouping Data/002 GROUP BY Clause (Part 2).mp4

84 MB

11 - Grouping Data/002 GROUP BY Clause (Part 2)_en.vtt

12 kB

11 - Grouping Data/003 HAVING Clause.mp4

35 MB

11 - Grouping Data/003 HAVING Clause_en.vtt

8.8 kB

11 - Grouping Data/004 Nested Group Functions.mp4

14 MB

11 - Grouping Data/004 Nested Group Functions_en.vtt

4.6 kB

12 - Joining Multiple Tables/001 What is a Join & Oracle SQL Join Types.mp4

60 MB

12 - Joining Multiple Tables/001 What is a Join & Oracle SQL Join Types_en.vtt

7.7 kB

12 - Joining Multiple Tables/002 Creating a Join.mp4

12 MB

12 - Joining Multiple Tables/002 Creating a Join_en.vtt

3.2 kB

12 - Joining Multiple Tables/003 Natural Join.mp4

67 MB

12 - Joining Multiple Tables/003 Natural Join_en.vtt

10 kB

12 - Joining Multiple Tables/004 Join with the USING Clause.mp4

26 MB

12 - Joining Multiple Tables/004 Join with the USING Clause_en.vtt

5.8 kB

12 - Joining Multiple Tables/005 Handling Ambiguous Column Names.mp4

45 MB

12 - Joining Multiple Tables/005 Handling Ambiguous Column Names_en.vtt

11 kB

12 - Joining Multiple Tables/006 Inner Join & Join with the ON Clause.mp4

26 MB

12 - Joining Multiple Tables/006 Inner Join & Join with the ON Clause_en.vtt

7.0 kB

12 - Joining Multiple Tables/007 Multiple Join Operations.mp4

112 MB

12 - Joining Multiple Tables/007 Multiple Join Operations_en.vtt

12 kB

12 - Joining Multiple Tables/008 Restricting Joins.mp4

15 MB

12 - Joining Multiple Tables/008 Restricting Joins_en.vtt

3.4 kB

12 - Joining Multiple Tables/009 Self Join.mp4

30 MB

12 - Joining Multiple Tables/009 Self Join_en.vtt

6.0 kB

12 - Joining Multiple Tables/010 Non-Equijoins (Joining Unequal Tables).mp4

87 MB

12 - Joining Multiple Tables/010 Non-Equijoins (Joining Unequal Tables)_en.vtt

13 kB

12 - Joining Multiple Tables/010 NonEquiJoins-Source-Code.sql

1.6 kB

12 - Joining Multiple Tables/011 OUTER JOINS.mp4

31 MB

12 - Joining Multiple Tables/011 OUTER JOINS_en.vtt

8.4 kB

12 - Joining Multiple Tables/012 LEFT OUTER JOIN (LEFT JOIN).mp4

60 MB

12 - Joining Multiple Tables/012 LEFT OUTER JOIN (LEFT JOIN)_en.vtt

13 kB

12 - Joining Multiple Tables/013 RIGHT OUTER JOIN (RIGHT JOIN).mp4

46 MB

12 - Joining Multiple Tables/013 RIGHT OUTER JOIN (RIGHT JOIN)_en.vtt

8.5 kB

12 - Joining Multiple Tables/014 FULL OUTER JOIN (FULL JOIN).mp4

16 MB

12 - Joining Multiple Tables/014 FULL OUTER JOIN (FULL JOIN)_en.vtt

3.9 kB

12 - Joining Multiple Tables/015 Cross Join (Cartesian Product Cross Product).mp4

150 MB

12 - Joining Multiple Tables/015 Cross Join (Cartesian Product Cross Product)_en.vtt

18 kB

12 - Joining Multiple Tables/016 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1).mp4

115 MB

12 - Joining Multiple Tables/016 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1)_en.vtt

14 kB

12 - Joining Multiple Tables/017 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2).mp4

69 MB

12 - Joining Multiple Tables/017 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2)_en.vtt

16 kB

12 - Joining Multiple Tables/018 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3).mp4

65 MB

12 - Joining Multiple Tables/018 Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3)_en.vtt

11 kB

12 - Joining Multiple Tables/019 Source-Code-Differences-Between-All-Types-of-Joins.sql

2.6 kB

12 - Joining Multiple Tables/019 The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins.mp4

101 MB

12 - Joining Multiple Tables/019 The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins_en.vtt

15 kB

12 - Joining Multiple Tables/020 Which Join Type Should You Use.mp4

10 MB

12 - Joining Multiple Tables/020 Which Join Type Should You Use_en.vtt

4.1 kB

12 - Joining Multiple Tables/021 Entity-Relationship Models in DBMS - How to Use Them with Joins.mp4

73 MB

12 - Joining Multiple Tables/021 Entity-Relationship Models in DBMS - How to Use Them with Joins_en.vtt

18 kB

13 - Using Subqueries/001 Using Subqueries.mp4

49 MB

13 - Using Subqueries/001 Using Subqueries_en.vtt

7.9 kB

13 - Using Subqueries/002 Single Row Subqueries.mp4

127 MB

13 - Using Subqueries/002 Single Row Subqueries_en.vtt

14 kB

13 - Using Subqueries/003 Multiple Row Subqueries.mp4

98 MB

13 - Using Subqueries/003 Multiple Row Subqueries_en.vtt

18 kB

13 - Using Subqueries/004 Multiple Column Subqueries.mp4

64 MB

13 - Using Subqueries/004 Multiple Column Subqueries_en.vtt

18 kB

13 - Using Subqueries/005 Using Subqueries as a Table.mp4

60 MB

13 - Using Subqueries/005 Using Subqueries as a Table_en.vtt

8.3 kB

13 - Using Subqueries/006 SCALAR Subqueries.mp4

57 MB

13 - Using Subqueries/006 SCALAR Subqueries_en.vtt

16 kB

13 - Using Subqueries/007 Correlated Subqueries.mp4

75 MB

13 - Using Subqueries/007 Correlated Subqueries_en.vtt

15 kB

13 - Using Subqueries/008 EXISTS Operator & Semijoins.mp4

47 MB

13 - Using Subqueries/008 EXISTS Operator & Semijoins_en.vtt

12 kB

13 - Using Subqueries/009 NOT EXISTS Operator.mp4

37 MB

13 - Using Subqueries/009 NOT EXISTS Operator_en.vtt

6.4 kB

14 - Working with the Oracle SET Operators/001 Introduction to SET Operators in Oracle SQL.mp4

113 MB

14 - Working with the Oracle SET Operators/001 Introduction to SET Operators in Oracle SQL_en.vtt

16 kB

14 - Working with the Oracle SET Operators/002 Source-Code-UNION-and-UNION-ALL-SET-Operators.sql

1.0 kB

14 - Working with the Oracle SET Operators/002 UNION and UNION ALL Operators.mp4

65 MB

14 - Working with the Oracle SET Operators/002 UNION and UNION ALL Operators_en.vtt

15 kB

14 - Working with the Oracle SET Operators/003 INTERSECT Operator.mp4

7.4 MB

14 - Working with the Oracle SET Operators/003 INTERSECT Operator_en.vtt

3.1 kB

14 - Working with the Oracle SET Operators/004 MINUS Operator.mp4

15 MB

14 - Working with the Oracle SET Operators/004 MINUS Operator_en.vtt

4.0 kB

14 - Working with the Oracle SET Operators/005 Matching Unmatched Queries in SET Operations.mp4

22 MB

14 - Working with the Oracle SET Operators/005 Matching Unmatched Queries in SET Operations_en.vtt

6.2 kB

14 - Working with the Oracle SET Operators/006 Using the ORDER BY Clause with SET Operators.mp4

30 MB

14 - Working with the Oracle SET Operators/006 Using the ORDER BY Clause with SET Operators_en.vtt

7.4 kB

14 - Working with the Oracle SET Operators/007 Combining Multiple Queries Using the SET Operators.mp4

27 MB

14 - Working with the Oracle SET Operators/007 Combining Multiple Queries Using the SET Operators_en.vtt

6.1 kB

14 - Working with the Oracle SET Operators/007 Source-Code-Combining-Multiple-Queries-Using-the-SET-Operators.sql

2.5 kB

15 - Data Definition Language (DDL) Statements/001 Data Definition Language (DDL).mp4

15 MB

15 - Data Definition Language (DDL) Statements/001 Data Definition Language (DDL)_en.vtt

4.3 kB

15 - Data Definition Language (DDL) Statements/002 Naming Rules & Naming Conventions in Oracle.mp4

85 MB

15 - Data Definition Language (DDL) Statements/002 Naming Rules & Naming Conventions in Oracle_en.vtt

12 kB

15 - Data Definition Language (DDL) Statements/003 CREATE TABLE Statement.mp4

65 MB

15 - Data Definition Language (DDL) Statements/003 CREATE TABLE Statement_en.vtt

9.3 kB

15 - Data Definition Language (DDL) Statements/004 CREATE TABLE AS SELECT (CTAS) Statement in Oracle.mp4

103 MB

15 - Data Definition Language (DDL) Statements/004 CREATE TABLE AS SELECT (CTAS) Statement in Oracle_en.vtt

12 kB

15 - Data Definition Language (DDL) Statements/005 ALTER TABLE Statement.mp4

156 MB

15 - Data Definition Language (DDL) Statements/005 ALTER TABLE Statement_en.vtt

18 kB

15 - Data Definition Language (DDL) Statements/006 Marking Columns Unused (Using The SET UNUSED Clause).mp4

67 MB

15 - Data Definition Language (DDL) Statements/006 Marking Columns Unused (Using The SET UNUSED Clause)_en.vtt

9.3 kB

15 - Data Definition Language (DDL) Statements/007 READ-ONLY Tables in SQL.mp4

47 MB

15 - Data Definition Language (DDL) Statements/007 READ-ONLY Tables in SQL_en.vtt

7.0 kB

15 - Data Definition Language (DDL) Statements/008 DROP TABLE Statement.mp4

51 MB

15 - Data Definition Language (DDL) Statements/008 DROP TABLE Statement_en.vtt

8.8 kB

15 - Data Definition Language (DDL) Statements/009 TRUNCATE TABLE Statement.mp4

67 MB

15 - Data Definition Language (DDL) Statements/009 TRUNCATE TABLE Statement_en.vtt

10 kB

15 - Data Definition Language (DDL) Statements/010 COMMENT Statement.mp4

73 MB

15 - Data Definition Language (DDL) Statements/010 COMMENT Statement_en.vtt

9.6 kB

15 - Data Definition Language (DDL) Statements/011 RENAME Statement.mp4

38 MB

15 - Data Definition Language (DDL) Statements/011 RENAME Statement_en.vtt

5.7 kB

16 - Data Manipulation Language (DML) Statements/001 Data Manipulation Language (DML).mp4

42 MB

16 - Data Manipulation Language (DML) Statements/001 Data Manipulation Language (DML)_en.vtt

5.3 kB

16 - Data Manipulation Language (DML) Statements/002 INSERT Statement (Part 1).mp4

85 MB

16 - Data Manipulation Language (DML) Statements/002 INSERT Statement (Part 1)_en.vtt

14 kB

16 - Data Manipulation Language (DML) Statements/003 INSERT Statement (Part 2).mp4

168 MB

16 - Data Manipulation Language (DML) Statements/003 INSERT Statement (Part 2)_en.vtt

19 kB

16 - Data Manipulation Language (DML) Statements/004 Multitable Insert Statements.mp4

22 MB

16 - Data Manipulation Language (DML) Statements/004 Multitable Insert Statements_en.vtt

3.2 kB

16 - Data Manipulation Language (DML) Statements/005 Unconditional Insert Statements (INSERT ALL Statements).mp4

49 MB

16 - Data Manipulation Language (DML) Statements/005 Unconditional Insert Statements (INSERT ALL Statements)_en.vtt

11 kB

16 - Data Manipulation Language (DML) Statements/006 Conditional INSERT ALL Statements.mp4

116 MB

16 - Data Manipulation Language (DML) Statements/006 Conditional INSERT ALL Statements_en.vtt

13 kB

16 - Data Manipulation Language (DML) Statements/007 Conditional INSERT FIRST Statements.mp4

30 MB

16 - Data Manipulation Language (DML) Statements/007 Conditional INSERT FIRST Statements_en.vtt

6.5 kB

16 - Data Manipulation Language (DML) Statements/008 Pivoting Insert.mp4

75 MB

16 - Data Manipulation Language (DML) Statements/008 Pivoting Insert_en.vtt

9.8 kB

16 - Data Manipulation Language (DML) Statements/009 UPDATE Statement.mp4

46 MB

16 - Data Manipulation Language (DML) Statements/009 UPDATE Statement_en.vtt

12 kB

16 - Data Manipulation Language (DML) Statements/010 DELETE Statement.mp4

38 MB

16 - Data Manipulation Language (DML) Statements/010 DELETE Statement_en.vtt

4.5 kB

16 - Data Manipulation Language (DML) Statements/011 MERGE Statement.mp4

148 MB

16 - Data Manipulation Language (DML) Statements/011 MERGE Statement_en.vtt

20 kB

16 - Data Manipulation Language (DML) Statements/012 (TCL) Transaction Control Language & TCL Commands.mp4

18 MB

16 - Data Manipulation Language (DML) Statements/012 (TCL) Transaction Control Language & TCL Commands_en.vtt

6.5 kB

16 - Data Manipulation Language (DML) Statements/013 COMMIT and ROLLBACK Statements.mp4

101 MB

16 - Data Manipulation Language (DML) Statements/013 COMMIT and ROLLBACK Statements_en.vtt

13 kB

16 - Data Manipulation Language (DML) Statements/014 Row Lock in Oracle.mp4

26 MB

16 - Data Manipulation Language (DML) Statements/014 Row Lock in Oracle_en.vtt

9.6 kB

16 - Data Manipulation Language (DML) Statements/015 SAVEPOINT Statement.mp4

61 MB

16 - Data Manipulation Language (DML) Statements/015 SAVEPOINT Statement_en.vtt

14 kB

16 - Data Manipulation Language (DML) Statements/015 SAVEPOINT-Statement.sql

897 B

16 - Data Manipulation Language (DML) Statements/016 FOR UPDATE Statement.mp4

146 MB

16 - Data Manipulation Language (DML) Statements/016 FOR UPDATE Statement_en.vtt

17 kB

17 - Constraints/001 What is a Constraint Oracle Constraint Types.mp4

28 MB

17 - Constraints/001 What is a Constraint Oracle Constraint Types_en.vtt

7.8 kB

17 - Constraints/002 NOT NULL Constraint.mp4

23 MB

17 - Constraints/002 NOT NULL Constraint_en.vtt

6.9 kB

17 - Constraints/003 UNIQUE Constraint.mp4

133 MB

17 - Constraints/003 UNIQUE Constraint_en.vtt

24 kB

17 - Constraints/004 PRIMARY KEY Constraint.mp4

58 MB

17 - Constraints/004 PRIMARY KEY Constraint_en.vtt

12 kB

17 - Constraints/005 FOREIGN KEY Constraint (Part 1).mp4

108 MB

17 - Constraints/005 FOREIGN KEY Constraint (Part 1)_en.vtt

14 kB

17 - Constraints/006 FOREIGN KEY Constraint (Part 2).mp4

66 MB

17 - Constraints/006 FOREIGN KEY Constraint (Part 2)_en.vtt

11 kB

17 - Constraints/007 The ON DELETE CASCADE ON DELETE SET NULL Clause.mp4

38 MB

17 - Constraints/007 The ON DELETE CASCADE ON DELETE SET NULL Clause_en.vtt

8.6 kB

17 - Constraints/008 CHECK Constraint.mp4

30 MB

17 - Constraints/008 CHECK Constraint_en.vtt

8.7 kB

17 - Constraints/009 Adding Constraints via ALTER TABLE Statements.mp4

74 MB

17 - Constraints/009 Adding Constraints via ALTER TABLE Statements_en.vtt

12 kB

17 - Constraints/010 Dropping (Removing) Constraints.mp4

28 MB

17 - Constraints/010 Dropping (Removing) Constraints_en.vtt

6.7 kB

17 - Constraints/011 Cascading Constraints in Oracle.mp4

41 MB

17 - Constraints/011 Cascading Constraints in Oracle_en.vtt

5.8 kB

17 - Constraints/012 Renaming Constraints.mp4

11 MB

17 - Constraints/012 Renaming Constraints_en.vtt

3.7 kB

17 - Constraints/013 Disabling Constraints.mp4

65 MB

17 - Constraints/013 Disabling Constraints_en.vtt

11 kB

17 - Constraints/014 Enabling Constraints.mp4

35 MB

17 - Constraints/014 Enabling Constraints_en.vtt

5.9 kB

17 - Constraints/015 Status of Constraints.mp4

44 MB

17 - Constraints/015 Status of Constraints_en.vtt

9.9 kB

17 - Constraints/016 Deferring Constraints (Part 1).mp4

54 MB

17 - Constraints/016 Deferring Constraints (Part 1)_en.vtt

10 kB

17 - Constraints/017 Deferring Constraints (Part 2).mp4

58 MB

17 - Constraints/017 Deferring Constraints (Part 2)_en.vtt

9.9 kB

18 - Database Views/001 What is a View and What is it Used for.mp4

21 MB

18 - Database Views/001 What is a View and What is it Used for_en.vtt

5.0 kB

18 - Database Views/002 View Types in Oracle.mp4

6.4 MB

18 - Database Views/002 View Types in Oracle_en.vtt

2.6 kB

18 - Database Views/003 Creating Simple Views.mp4

47 MB

18 - Database Views/003 Creating Simple Views_en.vtt

13 kB

18 - Database Views/004 Creating Complex Views.mp4

8.5 MB

18 - Database Views/004 Creating Complex Views_en.vtt

3.2 kB

18 - Database Views/005 Modifying Views.mp4

14 MB

18 - Database Views/005 Modifying Views_en.vtt

4.3 kB

18 - Database Views/006 Performing DML Operations with Views.mp4

76 MB

18 - Database Views/006 Performing DML Operations with Views_en.vtt

9.5 kB

18 - Database Views/007 Using the WITH CHECK OPTION Clause in SQL.mp4

32 MB

18 - Database Views/007 Using the WITH CHECK OPTION Clause in SQL_en.vtt

9.1 kB

18 - Database Views/008 Using the WITH READ ONLY Clause on Views.mp4

12 MB

18 - Database Views/008 Using the WITH READ ONLY Clause on Views_en.vtt

3.5 kB

18 - Database Views/009 Dropping Views.mp4

15 MB

18 - Database Views/009 Dropping Views_en.vtt

5.9 kB

18 - Database Views/010 Good News!.html

594 B

19 - Appendix/001 Appendix 1 Oracle Database 12c Installation into Your Computer.mp4

44 MB

19 - Appendix/001 Appendix 1 Oracle Database 12c Installation into Your Computer_en.vtt

8.4 kB

19 - Appendix/001 Oracles-Official-Website.url

47 B

19 - Appendix/002 Appendix 2 How to Unlock the HR Schema in the Oracle Database 12c.html

3.1 kB

19 - Appendix/003 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp4

49 MB

19 - Appendix/003 Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c_en.vtt

8.9 kB

19 - Appendix/external-links.txt

57 B

20 - Conclusion/001 Conclusion.mp4

1.3 MB

20 - Conclusion/001 Conclusion_en.vtt

51 B

20 - Conclusion/002 Code-Samples.pdf

84 kB

20 - Conclusion/003 SQL Cheatsheet.html

923 B

20 - Conclusion/003 SQL-Cheatsheet-Oracle-Master.pdf

3.6 MB

20 - Conclusion/004 Oracle-Database-12c-Database-SQL-1Z0-071-Exam-2016-07-12.pdf

574 kB

20 - Conclusion/004 Oracle-Database-12c-Database-SQL-1Z0-071-Exam-2018-06-30.pdf

2.1 MB

20 - Conclusion/004 Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam-04.03.2017.pdf

1.6 MB

20 - Conclusion/004 Oracle-Database-12c-SQL-Fundamentals-1Z0-061-Exam-18.06.2017.pdf

6.8 MB

20 - Conclusion/004 SQL Certification Exam Samples.html

1.2 kB

20 - Conclusion/005 Bonus Lecture.html

2.6 kB