Udemy - Oracle Database SQL Certified Associate 1Z0-071 (5.2024)

File Name

Size

01. Introduction/1. agenda - Copy.xlsx

15 kB

01. Introduction/1. Course Agenda.mp4

20 MB

01. Introduction/1. Course Agenda.vtt

6.9 kB

01. Introduction/2. chapter 1 hint.pdf

537 kB

01. Introduction/2. System Development Life Cycle & Database Definition.mp4

7.8 MB

01. Introduction/2. System Development Life Cycle & Database Definition.vtt

3.3 kB

01. Introduction/3. What is a Table.mp4

5.8 MB

01. Introduction/3. What is a Table.vtt

1.4 kB

01. Introduction/4. Data Models & ERM.mp4

54 MB

01. Introduction/4. Data Models & ERM.vtt

4.3 kB

01. Introduction/5. About Primary key & foreign key.mp4

18 MB

01. Introduction/5. About Primary key & foreign key.vtt

4.2 kB

01. Introduction/6. SQL and Types of SQL Statements.mp4

22 MB

01. Introduction/6. SQL and Types of SQL Statements.vtt

2.7 kB

01. Introduction/7. Oracle Database 12c Architecture.mp4

15 MB

01. Introduction/7. Oracle Database 12c Architecture.vtt

4.4 kB

01. Introduction/8. HR Schema in this Course.mp4

21 MB

01. Introduction/8. HR Schema in this Course.vtt

4.6 kB

02. Live SQL & Download Install/1. Oracle Live SQL No Installation for anything.vtt

8.8 kB

02. Live SQL & Download Install/1. Oracle Live SQL No Installation for anything.mp4

64 MB

02. Live SQL & Download Install/2. Oracle Live SQL limitation.html

873 B

02. Live SQL & Download Install/3. before you install oracle DB.html

609 B

02. Live SQL & Download Install/4. Downloading Oracle DB 12c.mp4

30 MB

02. Live SQL & Download Install/4. Downloading Oracle DB 12c.vtt

3.6 kB

02. Live SQL & Download Install/5. Installing Oracle DB 12c.mp4

50 MB

02. Live SQL & Download Install/5. Installing Oracle DB 12c.vtt

8.6 kB

02. Live SQL & Download Install/6. 18c express.pdf

174 kB

02. Live SQL & Download Install/6. About Oracle 18c express edition.html

261 B

02. Live SQL & Download Install/7. About oracle 11g express edition.html

537 B

03. Connecting to the Database/1. Connecting SYS using SQL plus & SQL Developer.mp4

39 MB

03. Connecting to the Database/1. Connecting SYS using SQL plus & SQL Developer.vtt

10 kB

03. Connecting to the Database/1. steps to unlock hr.sql

320 B

03. Connecting to the Database/2. if you do not remember the sys password.html

95 B

03. Connecting to the Database/3. Unlock HR Account Part 1.mp4

16 MB

03. Connecting to the Database/3. Unlock HR Account Part 1.vtt

4.1 kB

03. Connecting to the Database/4. Unlock HR Account Part 2.mp4

47 MB

03. Connecting to the Database/4. Unlock HR Account Part 2.vtt

9.7 kB

03. Connecting to the Database/5. ORA-01033 oracle initialization or shutdown in progress 12c.mp4

29 MB

03. Connecting to the Database/5. ORA-01033 oracle initialization or shutdown in progress 12c.vtt

3.3 kB

03. Connecting to the Database/6. ORA-65054 Cannot open a pluggable database in the desired mode.html

624 B

03. Connecting to the Database/7. Creating new pluggable database contains HR user.html

250 B

03. Connecting to the Database/7. Creating new pluggable database contains HR user.pdf

1021 kB

04. Retrieving data using the select statement/1. Capabilities of SQL select statement .pdf

168 kB

04. Retrieving data using the select statement/1. Navigate HR schema.mp4

79 MB

04. Retrieving data using the select statement/1. Navigate HR schema.vtt

6.4 kB

04. Retrieving data using the select statement/1. Retrieving data using the select statement.sql

2.3 kB

04. Retrieving data using the select statement/2. Capabilities of SQL SELECT Statements.mp4

41 MB

04. Retrieving data using the select statement/2. Capabilities of SQL SELECT Statements.vtt

6.9 kB

04. Retrieving data using the select statement/3. Arithmetic expressions and NULL values.mp4

35 MB

04. Retrieving data using the select statement/3. Arithmetic expressions and NULL values.vtt

5.2 kB

04. Retrieving data using the select statement/4. Column Alias, Concatenation , Distinct and DESCRIBE.mp4

62 MB

04. Retrieving data using the select statement/4. Column Alias, Concatenation , Distinct and DESCRIBE.vtt

12 kB

04. Retrieving data using the select statement/5. Important Notes in Select Statement.mp4

45 MB

04. Retrieving data using the select statement/5. Important Notes in Select Statement.vtt

4.9 kB

05. Restricting and Sorting Data/1. chapter 5 hints .pdf

199 kB

05. Restricting and Sorting Data/1. Restricting and Sorting Data.sql

8.0 kB

05. Restricting and Sorting Data/1. The WHERE Clause & Comparison Operators.mp4

102 MB

05. Restricting and Sorting Data/1. The WHERE Clause & Comparison Operators.vtt

13 kB

05. Restricting and Sorting Data/2. Using Between and IN Like Operators.vtt

11 kB

05. Restricting and Sorting Data/2. Using Between and IN Like Operators.mp4

42 MB

05. Restricting and Sorting Data/3. Using IS NULL NOT Not equal Operators.vtt

4.5 kB

05. Restricting and Sorting Data/3. Using IS NULL NOT Not equal Operators.mp4

18 MB

05. Restricting and Sorting Data/4. Logical Operators (AND OR NOT).mp4

54 MB

05. Restricting and Sorting Data/4. Logical Operators (AND OR NOT).vtt

8.1 kB

05. Restricting and Sorting Data/5. Order by Clause.mp4

55 MB

05. Restricting and Sorting Data/5. Order by Clause.vtt

7.8 kB

05. Restricting and Sorting Data/6. The FETCH Clause.mp4

66 MB

05. Restricting and Sorting Data/6. The FETCH Clause.vtt

7.6 kB

06. Substitution Variables/1. Substitution Variables.sql

3.0 kB

06. Substitution Variables/1. What is a Substitution Variables (&).mp4

29 MB

06. Substitution Variables/1. What is a Substitution Variables (&).vtt

7.3 kB

06. Substitution Variables/2. DEFINE UNDEFINE.vtt

5.0 kB

06. Substitution Variables/2. DEFINE UNDEFINE.mp4

15 MB

06. Substitution Variables/2. Substitution Variables.sql

3.0 kB

06. Substitution Variables/3. ACCEPT PROMPT.vtt

4.2 kB

06. Substitution Variables/3. ACCEPT PROMPT.mp4

18 MB

06. Substitution Variables/4. Double-Ampersand SET VERIFY SET DEFINE.vtt

6.9 kB

06. Substitution Variables/4. Double-Ampersand SET VERIFY SET DEFINE.mp4

18 MB

07. Using Single-Row Functions to Customize Output/1. 7.1-character functions.sql

3.2 kB

07. Using Single-Row Functions to Customize Output/1. 7.2-number functions.sql

1.2 kB

07. Using Single-Row Functions to Customize Output/1. 7.3-date functions.sql

3.5 kB

07. Using Single-Row Functions to Customize Output/1. chapter 7 hints.pdf

730 kB

07. Using Single-Row Functions to Customize Output/1. Single Row Function Introduction.mp4

32 MB

07. Using Single-Row Functions to Customize Output/1. Single Row Function Introduction.vtt

4.8 kB

07. Using Single-Row Functions to Customize Output/10. Nesting Functions.mp4

19 MB

07. Using Single-Row Functions to Customize Output/10. Nesting Functions.vtt

4.6 kB

07. Using Single-Row Functions to Customize Output/2. Character functions (Upper, Lower, Initcap ).mp4

17 MB

07. Using Single-Row Functions to Customize Output/2. Character functions (Upper, Lower, Initcap ).vtt

3.7 kB

07. Using Single-Row Functions to Customize Output/3. Character functions (concat, substr, length ).mp4

43 MB

07. Using Single-Row Functions to Customize Output/3. Character functions (concat, substr, length ).vtt

6.7 kB

07. Using Single-Row Functions to Customize Output/4. Character functions ( instr ).mp4

13 MB

07. Using Single-Row Functions to Customize Output/4. Character functions ( instr ).vtt

4.5 kB

07. Using Single-Row Functions to Customize Output/5. Character functions ( lpad, rpad , replace, trim).mp4

25 MB

07. Using Single-Row Functions to Customize Output/5. Character functions ( lpad, rpad , replace, trim).vtt

10 kB

07. Using Single-Row Functions to Customize Output/6. Number functions ( Round, Trunc, MOD ).mp4

36 MB

07. Using Single-Row Functions to Customize Output/6. Number functions ( Round, Trunc, MOD ).vtt

10 kB

07. Using Single-Row Functions to Customize Output/7. Date Functions ( Sysdate).mp4

54 MB

07. Using Single-Row Functions to Customize Output/7. Date Functions ( Sysdate).vtt

7.6 kB

07. Using Single-Row Functions to Customize Output/8. Date Functions ( months_between, add_months, next_day, last_day).mp4

33 MB

07. Using Single-Row Functions to Customize Output/8. Date Functions ( months_between, add_months, next_day, last_day).vtt

7.7 kB

07. Using Single-Row Functions to Customize Output/9. Date Functions ( round , trunc ).vtt

8.2 kB

07. Using Single-Row Functions to Customize Output/9. Date Functions ( round , trunc ).mp4

30 MB

08. Using Conversion Functions and Conditional Expressions/1. chapter 8 hints.pdf

578 kB

08. Using Conversion Functions and Conditional Expressions/1. chapter 8 part 1.sql

3.7 kB

08. Using Conversion Functions and Conditional Expressions/1. chapter 8 part 2.sql

3.9 kB

08. Using Conversion Functions and Conditional Expressions/1. Implicit Data Conversion VS Explicit.mp4

23 MB

08. Using Conversion Functions and Conditional Expressions/1. Implicit Data Conversion VS Explicit.vtt

6.5 kB

08. Using Conversion Functions and Conditional Expressions/2. TO_CHAR with dates.vtt

8.6 kB

08. Using Conversion Functions and Conditional Expressions/2. TO_CHAR with dates.mp4

58 MB

08. Using Conversion Functions and Conditional Expressions/3. TO_CHAR with numbers.vtt

14 kB

08. Using Conversion Functions and Conditional Expressions/3. TO_CHAR with numbers.mp4

65 MB

08. Using Conversion Functions and Conditional Expressions/4. TO_NUMBER , TO_DATE Functions.mp4

40 MB

08. Using Conversion Functions and Conditional Expressions/4. TO_NUMBER , TO_DATE Functions.vtt

7.8 kB

08. Using Conversion Functions and Conditional Expressions/5. nvl , nvl2 , nullif and coalesce Functions.vtt

11 kB

08. Using Conversion Functions and Conditional Expressions/5. nvl , nvl2 , nullif and coalesce Functions.mp4

39 MB

08. Using Conversion Functions and Conditional Expressions/6. The CASE Function.mp4

46 MB

08. Using Conversion Functions and Conditional Expressions/6. The CASE Function.vtt

10 kB

08. Using Conversion Functions and Conditional Expressions/7. The DECODE Function.mp4

26 MB

08. Using Conversion Functions and Conditional Expressions/7. The DECODE Function.vtt

6.3 kB

09. Reporting Aggregated Data Using the Group Functions/1. chapter 9 hints.pdf

566 kB

09. Reporting Aggregated Data Using the Group Functions/1. chapter 9.sql

3.9 kB

09. Reporting Aggregated Data Using the Group Functions/1. Group functions Introduction.mp4

16 MB

09. Reporting Aggregated Data Using the Group Functions/1. Group functions Introduction.vtt

6.7 kB

09. Reporting Aggregated Data Using the Group Functions/2. Group functions (sum, count, max, min, avg & more).mp4

21 MB

09. Reporting Aggregated Data Using the Group Functions/2. Group functions (sum, count, max, min, avg & more).vtt

9.1 kB

09. Reporting Aggregated Data Using the Group Functions/3. Group by Clause, Having Clause.mp4

28 MB

09. Reporting Aggregated Data Using the Group Functions/3. Group by Clause, Having Clause.vtt

11 kB

10. Displaying Data from multiple tables using joins/1. Before You Start, important notes.mp4

23 MB

10. Displaying Data from multiple tables using joins/1. Before You Start, important notes.vtt

5.0 kB

10. Displaying Data from multiple tables using joins/1. chapter 10 hints.pdf

1.2 MB

10. Displaying Data from multiple tables using joins/1. chapter 10 part 1.sql

1.7 kB

10. Displaying Data from multiple tables using joins/1. chapter 10 part 2.sql

3.7 kB

10. Displaying Data from multiple tables using joins/1. chapter 10 part 3.sql

6.1 kB

10. Displaying Data from multiple tables using joins/10. 1999 Syntax USING Clause.mp4

23 MB

10. Displaying Data from multiple tables using joins/10. 1999 Syntax USING Clause.vtt

3.4 kB

10. Displaying Data from multiple tables using joins/11. 1999 Syntax ON Clause.mp4

54 MB

10. Displaying Data from multiple tables using joins/11. 1999 Syntax ON Clause.vtt

7.8 kB

10. Displaying Data from multiple tables using joins/12. 1999 Syntax LeftRightfull Outer Join.mp4

22 MB

10. Displaying Data from multiple tables using joins/12. 1999 Syntax LeftRightfull Outer Join.vtt

8.2 kB

10. Displaying Data from multiple tables using joins/2. HR Tables Diagram, Joins Clarification.mp4

26 MB

10. Displaying Data from multiple tables using joins/2. HR Tables Diagram, Joins Clarification.vtt

6.1 kB

10. Displaying Data from multiple tables using joins/3. What is Cartesian product.mp4

34 MB

10. Displaying Data from multiple tables using joins/3. What is Cartesian product.vtt

5.1 kB

10. Displaying Data from multiple tables using joins/4. Old Joins Equijoin.mp4

25 MB

10. Displaying Data from multiple tables using joins/4. Old Joins Equijoin.vtt

8.5 kB

10. Displaying Data from multiple tables using joins/5. Old Joins nonEquijoins.mp4

30 MB

10. Displaying Data from multiple tables using joins/5. Old Joins nonEquijoins.vtt

8.3 kB

10. Displaying Data from multiple tables using joins/6. Old Joins outer join.mp4

21 MB

10. Displaying Data from multiple tables using joins/6. Old Joins outer join.vtt

8.5 kB

10. Displaying Data from multiple tables using joins/7. Old Joins Self Join and More Practices.mp4

50 MB

10. Displaying Data from multiple tables using joins/7. Old Joins Self Join and More Practices.vtt

9.7 kB

10. Displaying Data from multiple tables using joins/8. 1999 Syntax Cross Join (Cartesian product ).mp4

17 MB

10. Displaying Data from multiple tables using joins/8. 1999 Syntax Cross Join (Cartesian product ).vtt

3.6 kB

10. Displaying Data from multiple tables using joins/9. 1999 Syntax Natural Join.mp4

55 MB

10. Displaying Data from multiple tables using joins/9. 1999 Syntax Natural Join.vtt

7.0 kB

11. Using Subqueries to Solve Queries/1. chapter 11 hints.pdf

484 kB

11. Using Subqueries to Solve Queries/1. chapter 11 sql.sql

4.2 kB

11. Using Subqueries to Solve Queries/1. Single row Subqueries.mp4

21 MB

11. Using Subqueries to Solve Queries/1. Single row Subqueries.vtt

9.5 kB

11. Using Subqueries to Solve Queries/2. Multiple rows Subqueries.mp4

27 MB

11. Using Subqueries to Solve Queries/2. Multiple rows Subqueries.vtt

6.4 kB

11. Using Subqueries to Solve Queries/3. NULL values and Subqueries.mp4

31 MB

11. Using Subqueries to Solve Queries/3. NULL values and Subqueries.vtt

4.3 kB

11. Using Subqueries to Solve Queries/4. Exists and not Exists.mp4

18 MB

11. Using Subqueries to Solve Queries/4. Exists and not Exists.vtt

4.4 kB

12. Using the Set Operators/1. chapter 12 hints.pdf

469 kB

12. Using the Set Operators/1. chapter 12.sql

2.9 kB

12. Using the Set Operators/1. Overview (Union, union all, intersect, minus ).mp4

16 MB

12. Using the Set Operators/1. Overview (Union, union all, intersect, minus ).vtt

4.6 kB

12. Using the Set Operators/2. Practice (Union, union all, intersect, minus ).mp4

54 MB

12. Using the Set Operators/2. Practice (Union, union all, intersect, minus ).vtt

13 kB

13. Managing tables using DML Statments/1. chapter 13 hints.pdf

2.0 MB

13. Managing tables using DML Statments/1. chapter 13 part 1 insert.sql

3.6 kB

13. Managing tables using DML Statments/1. chapter 13 part 2 update.sql

2.2 kB

13. Managing tables using DML Statments/1. chapter 13 part 3 delete.sql

1.1 kB

13. Managing tables using DML Statments/1. Introduction to DML.mp4

17 MB

13. Managing tables using DML Statments/1. Introduction to DML.vtt

5.3 kB

13. Managing tables using DML Statments/1. lesson 13 last part.sql

6.3 kB

13. Managing tables using DML Statments/10. ROW Lock.mp4

11 MB

13. Managing tables using DML Statments/10. ROW Lock.vtt

3.8 kB

13. Managing tables using DML Statments/11. FOR UPDATE Clause.mp4

35 MB

13. Managing tables using DML Statments/11. FOR UPDATE Clause.vtt

8.6 kB

13. Managing tables using DML Statments/2. Insert Statement.mp4

74 MB

13. Managing tables using DML Statments/2. Insert Statement.vtt

14 kB

13. Managing tables using DML Statments/3. Inserting common errors.mp4

17 MB

13. Managing tables using DML Statments/3. Inserting common errors.vtt

4.5 kB

13. Managing tables using DML Statments/4. Update Statement.mp4

72 MB

13. Managing tables using DML Statments/4. Update Statement.vtt

14 kB

13. Managing tables using DML Statments/5. Delete Statement.mp4

37 MB

13. Managing tables using DML Statments/5. Delete Statement.vtt

12 kB

13. Managing tables using DML Statments/6. What is Database Transactions.mp4

21 MB

13. Managing tables using DML Statments/6. What is Database Transactions.vtt

4.3 kB

13. Managing tables using DML Statments/7. About Commit & Rollback.mp4

42 MB

13. Managing tables using DML Statments/7. About Commit & Rollback.vtt

6.1 kB

13. Managing tables using DML Statments/8. Practice ( Commit and rollback ).mp4

35 MB

13. Managing tables using DML Statments/8. Practice ( Commit and rollback ).vtt

11 kB

13. Managing tables using DML Statments/9. SAVEPOINT.mp4

21 MB

13. Managing tables using DML Statments/9. SAVEPOINT.vtt

4.6 kB

14. Introduction to Data Definition Language/1. chapter 14 hints.pdf

2.7 MB

14. Introduction to Data Definition Language/1. chapter 14 sql part 1.sql

6.1 kB

14. Introduction to Data Definition Language/1. chapter 14 sql part 2.sql

3.9 kB

14. Introduction to Data Definition Language/1. chapter 14 sql part 3.sql

357 B

14. Introduction to Data Definition Language/1. DDL & Naming Rules.mp4

26 MB

14. Introduction to Data Definition Language/1. DDL & Naming Rules.vtt

8.1 kB

14. Introduction to Data Definition Language/10. Create Table AS subquery.mp4

27 MB

14. Introduction to Data Definition Language/10. Create Table AS subquery.vtt

7.2 kB

14. Introduction to Data Definition Language/11. Alter Table Add Columns.mp4

48 MB

14. Introduction to Data Definition Language/11. Alter Table Add Columns.vtt

9.7 kB

14. Introduction to Data Definition Language/12. Alter Table Modify Columns.mp4

28 MB

14. Introduction to Data Definition Language/12. Alter Table Modify Columns.vtt

9.4 kB

14. Introduction to Data Definition Language/13. Alter Table Drop Columns.mp4

38 MB

14. Introduction to Data Definition Language/13. Alter Table Drop Columns.vtt

6.6 kB

14. Introduction to Data Definition Language/14. Alter Table Set Unused.mp4

17 MB

14. Introduction to Data Definition Language/14. Alter Table Set Unused.vtt

6.0 kB

14. Introduction to Data Definition Language/15. ALTER TABLE READ ONLY READ write.vtt

4.0 kB

14. Introduction to Data Definition Language/15. ALTER TABLE READ ONLY READ write.mp4

31 MB

14. Introduction to Data Definition Language/16. Drop Table.mp4

21 MB

14. Introduction to Data Definition Language/16. Drop Table.vtt

7.1 kB

14. Introduction to Data Definition Language/17. Rename Column Rename Table.vtt

3.5 kB

14. Introduction to Data Definition Language/17. Rename Column Rename Table.mp4

8.5 MB

14. Introduction to Data Definition Language/2. Data Types Part 1.mp4

37 MB

14. Introduction to Data Definition Language/2. Data Types Part 1.vtt

6.4 kB

14. Introduction to Data Definition Language/3. Data Types Part 2.mp4

35 MB

14. Introduction to Data Definition Language/3. Data Types Part 2.vtt

5.1 kB

14. Introduction to Data Definition Language/4. Creating Tables (without constraints).mp4

45 MB

14. Introduction to Data Definition Language/4. Creating Tables (without constraints).vtt

10 kB

14. Introduction to Data Definition Language/5. Types of constraints and why we use it.mp4

25 MB

14. Introduction to Data Definition Language/5. Types of constraints and why we use it.vtt

7.2 kB

14. Introduction to Data Definition Language/6. Creating Tables ( Column Level Constraints ).mp4

72 MB

14. Introduction to Data Definition Language/6. Creating Tables ( Column Level Constraints ).vtt

13 kB

14. Introduction to Data Definition Language/7. Creating Tables ( Table Level Constraints ).mp4

24 MB

14. Introduction to Data Definition Language/7. Creating Tables ( Table Level Constraints ).vtt

6.5 kB

14. Introduction to Data Definition Language/8. Constraints Guidelines.mp4

37 MB

14. Introduction to Data Definition Language/8. Constraints Guidelines.vtt

6.0 kB

14. Introduction to Data Definition Language/9. ON DELETE cascade ON DELETE set null.vtt

7.5 kB

14. Introduction to Data Definition Language/9. ON DELETE cascade ON DELETE set null.mp4

18 MB

15. Tips you Should know/1. chapter 15 tips.sql

6.6 kB

15. Tips you Should know/1. Tips you Should know Part 1.mp4

22 MB

15. Tips you Should know/1. Tips you Should know Part 1.vtt

6.1 kB

15. Tips you Should know/2. Tips you Should know Part 2.mp4

5.8 MB

15. Tips you Should know/2. Tips you Should know Part 2.vtt

2.9 kB

15. Tips you Should know/3. Tips you Should know Part 3.mp4

19 MB

15. Tips you Should know/3. Tips you Should know Part 3.vtt

6.7 kB

15. Tips you Should know/4. Tips you Should know Part 4.mp4

17 MB

15. Tips you Should know/4. Tips you Should know Part 4.vtt

5.0 kB

15. Tips you Should know/5. Tips you Should know Part 5.mp4

16 MB

15. Tips you Should know/5. Tips you Should know Part 5.vtt

4.9 kB

15. Tips you Should know/6. Tips you Should know Part 6.mp4

22 MB

15. Tips you Should know/6. Tips you Should know Part 6.vtt

6.3 kB

16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/1. About Exam 1Z0-061 Visiting Oracle Website.mp4

25 MB

16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/2. My recommendations.mp4

10 MB

16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/2. My recommendations.vtt

3.6 kB

16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/3. 1Z0-061 retires on 30, Nov 2019.html

454 B

17. Introduction to Data Dictionary Views/1. chapter 17 hints.pdf

1.4 MB

17. Introduction to Data Dictionary Views/1. chapter 17.sql

3.7 kB

17. Introduction to Data Dictionary Views/1. What is Data Dictionary Views.mp4

27 MB

17. Introduction to Data Dictionary Views/1. What is Data Dictionary Views.vtt

6.9 kB

17. Introduction to Data Dictionary Views/2. What is DICTIONARY.mp4

13 MB

17. Introduction to Data Dictionary Views/2. What is DICTIONARY.vtt

3.3 kB

17. Introduction to Data Dictionary Views/3. USER_OBJECTS ALL_OBJECTS.vtt

8.6 kB

17. Introduction to Data Dictionary Views/3. USER_OBJECTS ALL_OBJECTS.mp4

27 MB

17. Introduction to Data Dictionary Views/4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.vtt

6.1 kB

17. Introduction to Data Dictionary Views/4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.mp4

52 MB

17. Introduction to Data Dictionary Views/5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.mp4

21 MB

17. Introduction to Data Dictionary Views/5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.vtt

5.5 kB

17. Introduction to Data Dictionary Views/6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.mp4

66 MB

17. Introduction to Data Dictionary Views/6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.vtt

16 kB

17. Introduction to Data Dictionary Views/7. COMMENT ON TABLE COLUMN.vtt

5.3 kB

17. Introduction to Data Dictionary Views/7. COMMENT ON TABLE COLUMN.mp4

11 MB

18. Creating sequences, synonyms, and indexes/1. chapter 18 hints.pdf

1.2 MB

18. Creating sequences, synonyms, and indexes/1. chapter 18 part 1.sql

3.7 kB

18. Creating sequences, synonyms, and indexes/1. chapter 18 part 2.sql

622 B

18. Creating sequences, synonyms, and indexes/1. chapter 18 part 3.sql

3.3 kB

18. Creating sequences, synonyms, and indexes/1. Sequences Part 1.mp4

48 MB

18. Creating sequences, synonyms, and indexes/1. Sequences Part 1.vtt

5.7 kB

18. Creating sequences, synonyms, and indexes/2. Sequences Part 2.mp4

17 MB

18. Creating sequences, synonyms, and indexes/2. Sequences Part 2.vtt

6.2 kB

18. Creating sequences, synonyms, and indexes/3. Sequences Part 3.mp4

20 MB

18. Creating sequences, synonyms, and indexes/3. Sequences Part 3.vtt

9.0 kB

18. Creating sequences, synonyms, and indexes/4. Sequences Part 4.mp4

96 MB

18. Creating sequences, synonyms, and indexes/4. Sequences Part 4.vtt

15 kB

18. Creating sequences, synonyms, and indexes/5. Creating Synonyms.mp4

33 MB

18. Creating sequences, synonyms, and indexes/5. Creating Synonyms.vtt

5.7 kB

18. Creating sequences, synonyms, and indexes/6. Creating Indexes Part 1.mp4

107 MB

18. Creating sequences, synonyms, and indexes/6. Creating Indexes Part 1.vtt

18 kB

18. Creating sequences, synonyms, and indexes/7. Creating Indexes Part 2.mp4

60 MB

18. Creating sequences, synonyms, and indexes/7. Creating Indexes Part 2.vtt

8.2 kB

19. Creating Views/1. chapter 19 hints.pdf

772 kB

19. Creating Views/1. chapter 19.sql

4.6 kB

19. Creating Views/1. What is a View What is the benefits of Views.vtt

5.8 kB

19. Creating Views/1. What is a View What is the benefits of Views.mp4

31 MB

19. Creating Views/2. Creating Simple Views.mp4

49 MB

19. Creating Views/2. Creating Simple Views.vtt

8.1 kB

19. Creating Views/3. Creating Complex Views.mp4

29 MB

19. Creating Views/3. Creating Complex Views.vtt

8.6 kB

19. Creating Views/4. With READ ONLY With check option Force view.vtt

8.1 kB

19. Creating Views/4. With READ ONLY With check option Force view.mp4

28 MB

20. Managing Schema Objects/1. Adding constraints dropping constraints.vtt

17 kB

20. Managing Schema Objects/1. Adding constraints dropping constraints.mp4

79 MB

20. Managing Schema Objects/1. chapter 20 part 1.sql

4.8 kB

20. Managing Schema Objects/1. chapter 20 part 2.sql

2.6 kB

20. Managing Schema Objects/1. chapter 20 part 3.sql

3.1 kB

20. Managing Schema Objects/2. Rename Column Rename Constraint.vtt

3.5 kB

20. Managing Schema Objects/2. Rename Column Rename Constraint.mp4

11 MB

20. Managing Schema Objects/3. Enable Disable Constraints.vtt

7.5 kB

20. Managing Schema Objects/3. Enable Disable Constraints.mp4

29 MB

20. Managing Schema Objects/4. Understanding DEFERRABLE Constraints.mp4

50 MB

20. Managing Schema Objects/4. Understanding DEFERRABLE Constraints.vtt

3.7 kB

20. Managing Schema Objects/5. DEFERRABLE Constraints Exercises.mp4

26 MB

20. Managing Schema Objects/5. DEFERRABLE Constraints Exercises.vtt

11 kB

20. Managing Schema Objects/6. GLOBAL TEMPORARY TABLE.mp4

18 MB

20. Managing Schema Objects/6. GLOBAL TEMPORARY TABLE.vtt

5.2 kB

20. Managing Schema Objects/7. About SQLLoader.mp4

76 MB

20. Managing Schema Objects/7. About SQLLoader.vtt

11 kB

20. Managing Schema Objects/7. emp.csv

498 kB

20. Managing Schema Objects/8. External Tables Part 1.mp4

62 MB

20. Managing Schema Objects/8. External Tables Part 1.vtt

9.1 kB

20. Managing Schema Objects/9. External Tables Part 2.mp4

21 MB

20. Managing Schema Objects/9. External Tables Part 2.vtt

7.4 kB

21. Retrieving Data By Using Subqueries/1. chapter 21 hints.pdf

107 kB

21. Retrieving Data By Using Subqueries/1. chapter 21 part 1.sql

3.7 kB

21. Retrieving Data By Using Subqueries/1. chapter 21 part 2.sql

2.2 kB

21. Retrieving Data By Using Subqueries/1. chapter 21 part 3.sql

2.6 kB

21. Retrieving Data By Using Subqueries/1. Using the subquery as a source table.mp4

31 MB

21. Retrieving Data By Using Subqueries/1. Using the subquery as a source table.vtt

10 kB

21. Retrieving Data By Using Subqueries/2. Pairwise Non Pairwise Subqueries.mp4

43 MB

21. Retrieving Data By Using Subqueries/2. Pairwise Non Pairwise Subqueries.vtt

6.7 kB

21. Retrieving Data By Using Subqueries/3. Scalar Subquery Correlated Subquery.vtt

9.9 kB

21. Retrieving Data By Using Subqueries/3. Scalar Subquery Correlated Subquery.mp4

38 MB

21. Retrieving Data By Using Subqueries/4. Reminder of Exists Not Exists.vtt

5.1 kB

21. Retrieving Data By Using Subqueries/4. Reminder of Exists Not Exists.mp4

20 MB

21. Retrieving Data By Using Subqueries/5. WITH Clause.mp4

33 MB

21. Retrieving Data By Using Subqueries/5. WITH Clause.vtt

14 kB

22. Manipulating Data By Using Subqueries/1. chapter 22 hints.pdf

105 kB

22. Manipulating Data By Using Subqueries/1. chapter 22.sql

3.0 kB

22. Manipulating Data By Using Subqueries/1. Inserting Updating Deleting Using a subquery as a target.vtt

8.9 kB

22. Manipulating Data By Using Subqueries/1. Inserting Updating Deleting Using a subquery as a target.mp4

18 MB

22. Manipulating Data By Using Subqueries/2. Correlated Update Correlated Delete.vtt

9.7 kB

22. Manipulating Data By Using Subqueries/2. Correlated Update Correlated Delete.mp4

57 MB

23. Controlling User Access/1. chapter 23 hints.pdf

1.0 MB

23. Controlling User Access/1. chapter 23 part 1.sql

1.2 kB

23. Controlling User Access/1. chapter 23 part 2.sql

1.4 kB

23. Controlling User Access/1. chapter 23 part 3.sql

706 B

23. Controlling User Access/1. chapter 23 part 4.sql

466 B

23. Controlling User Access/1. chapter 23 part 5.sql

587 B

23. Controlling User Access/1. Database Security System Privileges & Roles.vtt

12 kB

23. Controlling User Access/1. Database Security System Privileges & Roles.mp4

60 MB

23. Controlling User Access/2. Database Security Object Privileges.vtt

9.0 kB

23. Controlling User Access/2. Database Security Object Privileges.mp4

32 MB

23. Controlling User Access/3. System Privileges & Privileges Practice 1.mp4

28 MB

23. Controlling User Access/3. System Privileges & Privileges Practice 1.vtt

11 kB

23. Controlling User Access/4. System Privileges & Privileges Practice 2.mp4

42 MB

23. Controlling User Access/4. System Privileges & Privileges Practice 2.vtt

11 kB

23. Controlling User Access/5. Creating ROLE Practice.mp4

46 MB

23. Controlling User Access/5. Creating ROLE Practice.vtt

13 kB

23. Controlling User Access/6. With Grant Option.mp4

19 MB

23. Controlling User Access/6. With Grant Option.vtt

8.6 kB

23. Controlling User Access/7. Drop user Statement.mp4

8.5 MB

23. Controlling User Access/7. Drop user Statement.vtt

3.9 kB

24. Manipulating Data/1. chapter 24 hints.pdf

548 kB

24. Manipulating Data/1. chapter 24 part 1.sql

3.4 kB

24. Manipulating Data/1. chapter 24 part 2.sql

2.3 kB

24. Manipulating Data/1. chapter 24 part 3.sql

2.0 kB

24. Manipulating Data/1. What is Data Warehouse.mp4

12 MB

24. Manipulating Data/1. What is Data Warehouse.vtt

3.2 kB

24. Manipulating Data/2. Explicit default value in insert & update statement.mp4

15 MB

24. Manipulating Data/2. Explicit default value in insert & update statement.vtt

4.6 kB

24. Manipulating Data/3. Copy rows from another table.mp4

9.3 MB

24. Manipulating Data/3. Copy rows from another table.vtt

3.4 kB

24. Manipulating Data/4. INSERT ALL statement INSERT FIRST.vtt

12 kB

24. Manipulating Data/4. INSERT ALL statement INSERT FIRST.mp4

58 MB

24. Manipulating Data/5. Another INSERT ALL Example & Notes.mp4

37 MB

24. Manipulating Data/5. Another INSERT ALL Example & Notes.vtt

6.5 kB

24. Manipulating Data/6. Creating Matrix Report Using PIVOT.mp4

30 MB

24. Manipulating Data/6. Creating Matrix Report Using PIVOT.vtt

7.7 kB

24. Manipulating Data/7. The Merge Statement.mp4

14 MB

24. Manipulating Data/7. The Merge Statement.vtt

6.4 kB

24. Manipulating Data/8. FLASHBACK Table & System change Number ( SCN).mp4

66 MB

24. Manipulating Data/8. FLASHBACK Table & System change Number ( SCN).vtt

11 kB

25. Managing Data in Different Time Zones/1. chapter 25 hints.pdf

280 kB

25. Managing Data in Different Time Zones/1. chapter 25.sql

5.2 kB

25. Managing Data in Different Time Zones/1. THE INTERVAL ( YEAR TO MONTH day TO second).vtt

6.4 kB

25. Managing Data in Different Time Zones/1. THE INTERVAL ( YEAR TO MONTH day TO second).mp4

21 MB

25. Managing Data in Different Time Zones/2. to_yminterval to_dsinterval.vtt

4.6 kB

25. Managing Data in Different Time Zones/2. to_yminterval to_dsinterval.mp4

13 MB

25. Managing Data in Different Time Zones/3. Extract function.mp4

6.1 MB

25. Managing Data in Different Time Zones/3. Extract function.vtt

2.5 kB

25. Managing Data in Different Time Zones/4. timestamp timestamp with time zone.vtt

5.4 kB

25. Managing Data in Different Time Zones/4. timestamp timestamp with time zone.mp4

25 MB

25. Managing Data in Different Time Zones/5. V$TIMEZONE_NAMES and some functions.mp4

50 MB

25. Managing Data in Different Time Zones/5. V$TIMEZONE_NAMES and some functions.vtt

9.9 kB

25. Managing Data in Different Time Zones/6. timestamp with local time zone.mp4

14 MB

25. Managing Data in Different Time Zones/6. timestamp with local time zone.vtt

4.7 kB

25. Managing Data in Different Time Zones/7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.vtt

3.9 kB

25. Managing Data in Different Time Zones/7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.mp4

20 MB

26. Exam 1Z0-071 for SQL Certified Associate/1. About the Exam 1Z0-071.mp4

26 MB

26. Exam 1Z0-071 for SQL Certified Associate/1. About the Exam 1Z0-071.vtt

6.6 kB

26. Exam 1Z0-071 for SQL Certified Associate/2. EXAM 1z0-071 Sample Questions.html

135 B

26. Exam 1Z0-071 for SQL Certified Associate/2. EXAM 1z0-071 sample.pdf

1.7 MB

27. Bonus Section/1. Using SELECT statement to create dynamic scripts.mp4

19 MB

27. Bonus Section/1. Using SELECT statement to create dynamic scripts.sql

357 B

27. Bonus Section/1. Using SELECT statement to create dynamic scripts.vtt

4.5 kB

27. Bonus Section/10. oracle 18c express edition part 3 ( sql developer ).mp4

20 MB

27. Bonus Section/10. oracle 18c express edition part 3 ( sql developer ).vtt

6.3 kB

27. Bonus Section/2. Installing oracle 11g express edition.mp4

40 MB

27. Bonus Section/2. Installing oracle 11g express edition.vtt

9.5 kB

27. Bonus Section/3. Rownum and rowid.mp4

22 MB

27. Bonus Section/3. Rownum and rowid.vtt

5.8 kB

27. Bonus Section/4. About PLSQL.mp4

91 MB

27. Bonus Section/4. About PLSQL.vtt

12 kB

27. Bonus Section/5. Understanding NULLS when used with ( IN NOT IN ).html

2.0 kB

27. Bonus Section/6. permanent solution for ORA-01033 oracle initialization or shutdown in progress.html

1.1 kB

27. Bonus Section/7. dbms_errlog.sql

480 B

27. Bonus Section/7. DML logs using package dbms_errlog.mp4

35 MB

27. Bonus Section/7. DML logs using package dbms_errlog.vtt

8.4 kB

27. Bonus Section/8. oracle 18c express edition part 1 (download and install ).mp4

42 MB

27. Bonus Section/8. oracle 18c express edition part 1 (download and install ).vtt

8.3 kB

27. Bonus Section/9. oracle 18c express edition part 2 (unlock hr ).mp4

32 MB

27. Bonus Section/9. oracle 18c express edition part 2 (unlock hr ).vtt

9.9 kB

28. What next it is time for PLSQL/1. 2018-01-10_08-06-36-522880710123fea4c18889023ddcb237.jpg

24 kB

28. What next it is time for PLSQL/1. Move your skills to PLSQL.html

1.1 kB

28. What next it is time for PLSQL/2. Move your skills to Oracle Analytic Functions In-Depth & Advanced Oracle SQL.html

749 B

28. What next it is time for PLSQL/3. Oracle Apex.html

2.8 kB