[FreeCourseLab.com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071

Creation Time	Sept. 15, 2024, 6:55 p.m.
Last Access Time	Sept. 19, 2024, 12:42 a.m.
File Size	3.4 GB
Keywords	12c Database Associate - Udemy 1Z0-071 SQL Oracle FreeCourseLab com Certified
Total Requests	3
Total Files	415
Magnet Link	Please wait ...
	Download (Magnet Link) Play (Watch Online)

27. Bonus Section/7. DML logs using package dbms_errlog.mp4 90.2 MB
18. Creating sequences, synonyms, and indexes/6. Creating Indexes Part 1.mp4 41.9 MB
5. Restricting and Sorting Data/1. The WHERE Clause & Comparison Operators.mp4 39.7 MB
10. Displaying Data from multiple tables using joins/1. Before You Start, important notes.mp4 38.6 MB
3. Connecting to the Database/4. Unlock HR Account Part 2.mp4 38.4 MB
17. Introduction to Data Dictionary Views/6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.mp4 38.3 MB
27. Bonus Section/2. Installing oracle 11g express edition.mp4 36.9 MB
20. Managing Schema Objects/1. Adding constraints dropping constraints.mp4 36.5 MB
2. Live SQL & Download Install/1. Oracle Live SQL No Installation for anything.mp4 35.9 MB
20. Managing Schema Objects/7. About SQLLoader.mp4 34.9 MB
13. Managing tables using DML Statments/4. Update Statement.mp4 33.6 MB
13. Managing tables using DML Statments/5. Delete Statement.mp4 33.2 MB
13. Managing tables using DML Statments/2. Insert Statement.mp4 33.2 MB
18. Creating sequences, synonyms, and indexes/4. Sequences Part 4.mp4 33.1 MB
21. Retrieving Data By Using Subqueries/5. WITH Clause.mp4 32.9 MB
14. Introduction to Data Definition Language/6. Creating Tables ( Column Level Constraints ).mp4 32.2 MB
3. Connecting to the Database/1. Connecting SYS using SQL plus & SQL Developer.mp4 31.6 MB
27. Bonus Section/4. About PLSQL.mp4 31.5 MB
23. Controlling User Access/5. Creating ROLE Practice.mp4 30.5 MB
9. Reporting Aggregated Data Using the Group Functions/3. Group by Clause, Having Clause.mp4 30.1 MB
8. Using Conversion Functions and Conditional Expressions/6. The CASE Function.mp4 30.1 MB
4. Retrieving data using the select statement/4. Column Alias, Concatenation , Distinct and DESCRIBE.mp4 29.9 MB
26. Exam 1Z0-071 for SQL Certified Associate/2. Some helpful websites contains exams Dumps.mp4 29.9 MB
4. Retrieving data using the select statement/1. Navigate HR schema.mp4 29.6 MB
7. Using Single-Row Functions to Customize Output/6. Number functions ( Round, Trunc, MOD ).mp4 29.0 MB
8. Using Conversion Functions and Conditional Expressions/3. TO_CHAR with numbers.mp4 28.9 MB
5. Restricting and Sorting Data/2. Using Between and IN Like Operators.mp4 28.3 MB
24. Manipulating Data/4. INSERT ALL statement INSERT FIRST.mp4 28.3 MB
5. Restricting and Sorting Data/5. Order by Clause.mp4 28.1 MB
8. Using Conversion Functions and Conditional Expressions/5. nvl , nvl2 , nullif and coalesce Functions.mp4 28.0 MB
24. Manipulating Data/8. FLASHBACK Table & System change Number ( SCN).mp4 27.8 MB
5. Restricting and Sorting Data/6. The FETCH Clause.mp4 27.7 MB
12. Using the Set Operators/2. Practice (Union, union all, intersect, minus ).mp4 26.8 MB
10. Displaying Data from multiple tables using joins/9. 1999 Syntax Natural Join.mp4 26.2 MB
13. Managing tables using DML Statments/8. Practice ( Commit and rollback ).mp4 26.0 MB
23. Controlling User Access/4. System Privileges & Privileges Practice 2.mp4 25.8 MB
22. Manipulating Data By Using Subqueries/2. Correlated Update Correlated Delete.mp4 25.7 MB
18. Creating sequences, synonyms, and indexes/7. Creating Indexes Part 2.mp4 25.7 MB
2. Live SQL & Download Install/4. Installing Oracle DB 12c.mp4 25.6 MB
5. Restricting and Sorting Data/4. Logical Operators (AND OR NOT).mp4 25.6 MB
7. Using Single-Row Functions to Customize Output/5. Character functions ( lpad, rpad , replace, trim).mp4 25.4 MB
10. Displaying Data from multiple tables using joins/5. Old Joins nonEquijoins.mp4 24.5 MB
6. Substitution Variables/1. What is a Substitution Variables (&).mp4 24.4 MB
23. Controlling User Access/1. Database Security System Privileges & Roles.mp4 24.3 MB
4. Retrieving data using the select statement/5. Important Notes in Select Statement.mp4 23.8 MB
21. Retrieving Data By Using Subqueries/1. Using the subquery as a source table.mp4 23.5 MB
7. Using Single-Row Functions to Customize Output/7. Date Functions ( Sysdate).mp4 23.3 MB
23. Controlling User Access/3. System Privileges & Privileges Practice 1.mp4 23.1 MB
21. Retrieving Data By Using Subqueries/3. Scalar Subquery Correlated Subquery.mp4 22.8 MB
10. Displaying Data from multiple tables using joins/12. 1999 Syntax LeftRightfull Outer Join.mp4 22.5 MB
14. Introduction to Data Definition Language/11. Alter Table Add Columns.mp4 22.4 MB
23. Controlling User Access/2. Database Security Object Privileges.mp4 22.4 MB
21. Retrieving Data By Using Subqueries/4. Reminder of Exists Not Exists.mp4 22.2 MB
16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/1. About Exam 1Z0-061 Visiting Oracle Website.mp4 22.1 MB
14. Introduction to Data Definition Language/4. Creating Tables (without constraints).mp4 22.0 MB
20. Managing Schema Objects/5. DEFERRABLE Constraints Exercises.mp4 21.9 MB
20. Managing Schema Objects/8. External Tables Part 1.mp4 21.8 MB
19. Creating Views/3. Creating Complex Views.mp4 21.8 MB
20. Managing Schema Objects/3. Enable Disable Constraints.mp4 21.5 MB
8. Using Conversion Functions and Conditional Expressions/2. TO_CHAR with dates.mp4 21.4 MB
4. Retrieving data using the select statement/2. Capabilities of SQL SELECT Statements.mp4 21.3 MB
1. Introduction/8. HR Schema in this Course.mp4 21.3 MB
11. Using Subqueries to Solve Queries/1. Single row Subqueries.mp4 21.3 MB
1. Introduction/1. Course Agenda.mp4 21.1 MB
10. Displaying Data from multiple tables using joins/6. Old Joins outer join.mp4 20.9 MB
14. Introduction to Data Definition Language/1. DDL & Naming Rules.mp4 20.7 MB
3. Connecting to the Database/5. ORA-01033 oracle initialization or shutdown in progress 12c.mp4 20.6 MB
19. Creating Views/4. With READ ONLY With check option Force view.mp4 20.5 MB
10. Displaying Data from multiple tables using joins/4. Old Joins Equijoin.mp4 20.4 MB
22. Manipulating Data By Using Subqueries/1. Inserting Updating Deleting Using a subquery as a target.mp4 20.3 MB
8. Using Conversion Functions and Conditional Expressions/7. The DECODE Function.mp4 20.3 MB
10. Displaying Data from multiple tables using joins/11. 1999 Syntax ON Clause.mp4 20.3 MB
10. Displaying Data from multiple tables using joins/7. Old Joins Self Join and More Practices.mp4 20.0 MB
20. Managing Schema Objects/4. Understanding DEFERRABLE Constraints.mp4 19.9 MB
7. Using Single-Row Functions to Customize Output/9. Date Functions ( round , trunc ).mp4 19.8 MB
7. Using Single-Row Functions to Customize Output/8. Date Functions ( months_between, add_months, next_day, last_day).mp4 19.6 MB
13. Managing tables using DML Statments/11. FOR UPDATE Clause.mp4 19.4 MB
17. Introduction to Data Dictionary Views/4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.mp4 19.3 MB
14. Introduction to Data Definition Language/12. Alter Table Modify Columns.mp4 19.3 MB
19. Creating Views/2. Creating Simple Views.mp4 19.2 MB
8. Using Conversion Functions and Conditional Expressions/4. TO_NUMBER , TO_DATE Functions.mp4 19.1 MB
25. Managing Data in Different Time Zones/5. V$TIMEZONE_NAMES and some functions.mp4 19.1 MB
24. Manipulating Data/5. Another INSERT ALL Example & Notes.mp4 18.8 MB
13. Managing tables using DML Statments/7. About Commit & Rollback.mp4 18.8 MB
27. Bonus Section/1. Using SELECT statement to create dynamic scripts.mp4 18.8 MB
14. Introduction to Data Definition Language/10. Create Table AS subquery.mp4 18.6 MB
25. Managing Data in Different Time Zones/1. THE INTERVAL ( YEAR TO MONTH day TO second).mp4 18.6 MB
1. Introduction/4. Data Models & ERM.mp4 18.5 MB
14. Introduction to Data Definition Language/9. ON DELETE cascade ON DELETE set null.mp4 18.5 MB
26. Exam 1Z0-071 for SQL Certified Associate/1. About the Exam 1Z0-071.mp4 18.4 MB
18. Creating sequences, synonyms, and indexes/3. Sequences Part 3.mp4 18.3 MB
17. Introduction to Data Dictionary Views/3. USER_OBJECTS ALL_OBJECTS.mp4 18.3 MB
10. Displaying Data from multiple tables using joins/3. What is Cartesian product.mp4 18.2 MB
14. Introduction to Data Definition Language/13. Alter Table Drop Columns.mp4 18.2 MB
23. Controlling User Access/6. With Grant Option.mp4 18.0 MB
7. Using Single-Row Functions to Customize Output/3. Character functions (concat, substr, length ).mp4 17.9 MB
9. Reporting Aggregated Data Using the Group Functions/2. Group functions (sum, count, max, min, avg & more).mp4 17.9 MB
18. Creating sequences, synonyms, and indexes/5. Creating Synonyms.mp4 17.8 MB
2. Live SQL & Download Install/3. Downloading Oracle DB 12c.mp4 17.8 MB
14. Introduction to Data Definition Language/14. Alter Table Set Unused.mp4 17.8 MB
14. Introduction to Data Definition Language/8. Constraints Guidelines.mp4 17.8 MB
21. Retrieving Data By Using Subqueries/2. Pairwise Non Pairwise Subqueries.mp4 17.7 MB
18. Creating sequences, synonyms, and indexes/1. Sequences Part 1.mp4 17.6 MB
11. Using Subqueries to Solve Queries/2. Multiple rows Subqueries.mp4 17.6 MB
20. Managing Schema Objects/9. External Tables Part 2.mp4 17.1 MB
14. Introduction to Data Definition Language/15. ALTER TABLE READ ONLY READ write.mp4 17.1 MB
24. Manipulating Data/6. Creating Matrix Report Using PIVOT.mp4 17.1 MB
6. Substitution Variables/3. ACCEPT PROMPT.mp4 17.0 MB
18. Creating sequences, synonyms, and indexes/2. Sequences Part 2.mp4 16.8 MB
13. Managing tables using DML Statments/6. What is Database Transactions.mp4 16.8 MB
8. Using Conversion Functions and Conditional Expressions/1. Implicit Data Conversion VS Explicit.mp4 16.7 MB
7. Using Single-Row Functions to Customize Output/1. Single Row Function Introduction.mp4 16.5 MB
17. Introduction to Data Dictionary Views/1. What is Data Dictionary Views.mp4 16.3 MB
27. Bonus Section/3. Rownum and rowid.mp4 16.3 MB
14. Introduction to Data Definition Language/5. Types of constraints and why we use it.mp4 16.3 MB
15. Tips you Should know/1. Tips you Should know Part 1.mp4 16.3 MB
4. Retrieving data using the select statement/3. Arithmetic expressions and NULL values.mp4 16.3 MB
14. Introduction to Data Definition Language/2. Data Types Part 1.mp4 16.1 MB
3. Connecting to the Database/3. Unlock HR Account Part 1.mp4 16.0 MB
11. Using Subqueries to Solve Queries/3. NULL values and Subqueries.mp4 15.9 MB
14. Introduction to Data Definition Language/16. Drop Table.mp4 15.7 MB
15. Tips you Should know/6. Tips you Should know Part 6.mp4 15.7 MB
9. Reporting Aggregated Data Using the Group Functions/1. Group functions Introduction.mp4 15.6 MB
1. Introduction/7. Oracle Database 12c Architecture.mp4 15.3 MB
16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/2. My recommendations.mp4 15.2 MB
7. Using Single-Row Functions to Customize Output/10. Nesting Functions.mp4 15.0 MB
17. Introduction to Data Dictionary Views/7. COMMENT ON TABLE COLUMN.mp4 14.9 MB
17. Introduction to Data Dictionary Views/5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.mp4 14.8 MB
15. Tips you Should know/3. Tips you Should know Part 3.mp4 14.8 MB
1. Introduction/2. System Development Life Cycle & Database Definition.mp4 14.7 MB
14. Introduction to Data Definition Language/7. Creating Tables ( Table Level Constraints ).mp4 14.7 MB
10. Displaying Data from multiple tables using joins/8. 1999 Syntax Cross Join (Cartesian product ).mp4 14.6 MB
13. Managing tables using DML Statments/3. Inserting common errors.mp4 14.6 MB
1. Introduction/5. About Primary key & foreign key.mp4 14.5 MB
20. Managing Schema Objects/6. GLOBAL TEMPORARY TABLE.mp4 14.2 MB
23. Controlling User Access/7. Drop user Statement.mp4 13.9 MB
7. Using Single-Row Functions to Customize Output/2. Character functions (Upper, Lower, Initcap ).mp4 13.7 MB
6. Substitution Variables/4. Double-Ampersand SET VERIFY SET DEFINE.mp4 13.5 MB
1. Introduction/6. SQL and Types of SQL Statements.mp4 13.4 MB
11. Using Subqueries to Solve Queries/4. Exists and not Exists.mp4 13.4 MB
14. Introduction to Data Definition Language/3. Data Types Part 2.mp4 13.4 MB
6. Substitution Variables/2. DEFINE UNDEFINE.mp4 13.4 MB
19. Creating Views/1. What is a View What is the benefits of Views.mp4 13.2 MB
10. Displaying Data from multiple tables using joins/10. 1999 Syntax USING Clause.mp4 12.7 MB
10. Displaying Data from multiple tables using joins/2. HR Tables Diagram, Joins Clarification.mp4 12.7 MB
25. Managing Data in Different Time Zones/7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.mp4 12.2 MB
24. Manipulating Data/7. The Merge Statement.mp4 12.2 MB
13. Managing tables using DML Statments/9. SAVEPOINT.mp4 12.1 MB
5. Restricting and Sorting Data/3. Using IS NULL NOT Not equal Operators.mp4 11.9 MB
15. Tips you Should know/4. Tips you Should know Part 4.mp4 11.9 MB
25. Managing Data in Different Time Zones/6. timestamp with local time zone.mp4 11.8 MB
12. Using the Set Operators/1. Overview (Union, union all, intersect, minus ).mp4 11.7 MB
15. Tips you Should know/5. Tips you Should know Part 5.mp4 11.5 MB
7. Using Single-Row Functions to Customize Output/4. Character functions ( instr ).mp4 11.5 MB
13. Managing tables using DML Statments/1. Introduction to DML.mp4 10.9 MB
25. Managing Data in Different Time Zones/4. timestamp timestamp with time zone.mp4 10.9 MB
24. Manipulating Data/2. Explicit default value in insert & update statement.mp4 10.7 MB
13. Managing tables using DML Statments/10. ROW Lock.mp4 10.6 MB
17. Introduction to Data Dictionary Views/2. What is DICTIONARY.mp4 10.5 MB
25. Managing Data in Different Time Zones/2. to_yminterval to_dsinterval.mp4 9.3 MB
14. Introduction to Data Definition Language/17. Rename Column Rename Table.mp4 9.2 MB
24. Manipulating Data/1. What is Data Warehouse.mp4 9.2 MB
24. Manipulating Data/3. Copy rows from another table.mp4 8.6 MB
20. Managing Schema Objects/2. Rename Column Rename Constraint.mp4 8.4 MB
1. Introduction/3. What is a Table.mp4 6.7 MB
15. Tips you Should know/2. Tips you Should know Part 2.mp4 5.4 MB
25. Managing Data in Different Time Zones/3. Extract function.mp4 4.9 MB
14. Introduction to Data Definition Language/1.1 chapter 14 hints.pdf.pdf 2.7 MB
13. Managing tables using DML Statments/1.1 chapter 13 hints.pdf.pdf 2.0 MB
26. Exam 1Z0-071 for SQL Certified Associate/3.1 EXAM 1z0-071 sample.pdf.pdf 1.7 MB
17. Introduction to Data Dictionary Views/1.2 chapter 17 hints.pdf.pdf 1.4 MB
10. Displaying Data from multiple tables using joins/1.4 chapter 10 hints.pdf.pdf 1.2 MB
18. Creating sequences, synonyms, and indexes/1.3 chapter 18 hints.pdf.pdf 1.2 MB
23. Controlling User Access/1.2 chapter 23 hints.pdf.pdf 1.0 MB
3. Connecting to the Database/7.1 Creating new pluggable database contains HR user.pdf.pdf 1021.4 KB
19. Creating Views/1.2 chapter 19 hints.pdf.pdf 772.5 KB
7. Using Single-Row Functions to Customize Output/1.2 chapter 7 hints.pdf.pdf 730.4 KB
8. Using Conversion Functions and Conditional Expressions/1.2 chapter 8 hints.pdf.pdf 578.3 KB
9. Reporting Aggregated Data Using the Group Functions/1.2 chapter 9 hints.pdf.pdf 565.7 KB
24. Manipulating Data/1.3 chapter 24 hints.pdf.pdf 548.1 KB
1. Introduction/2.1 chapter 1 hint.pdf.pdf 537.2 KB
20. Managing Schema Objects/7.1 emp.csv.csv 498.1 KB
11. Using Subqueries to Solve Queries/1.1 chapter 11 hints.pdf.pdf 483.9 KB
12. Using the Set Operators/1.1 chapter 12 hints.pdf.pdf 469.3 KB
25. Managing Data in Different Time Zones/1.2 chapter 25 hints.pdf.pdf 279.7 KB
5. Restricting and Sorting Data/1.2 chapter 5 hints .pdf.pdf 199.4 KB
4. Retrieving data using the select statement/1.1 Capabilities of SQL select statement .pdf.pdf 167.5 KB
21. Retrieving Data By Using Subqueries/1.3 chapter 21 hints.pdf.pdf 106.8 KB
22. Manipulating Data By Using Subqueries/1.1 chapter 22 hints.pdf.pdf 105.1 KB
18. Creating sequences, synonyms, and indexes/6. Creating Indexes Part 1.vtt 17.1 KB
20. Managing Schema Objects/1. Adding constraints dropping constraints.vtt 16.3 KB
17. Introduction to Data Dictionary Views/6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.vtt 15.6 KB
1. Introduction/1.1 agenda - Copy.xlsx.xlsx 14.6 KB
18. Creating sequences, synonyms, and indexes/4. Sequences Part 4.vtt 14.5 KB
13. Managing tables using DML Statments/2. Insert Statement.vtt 14.2 KB
8. Using Conversion Functions and Conditional Expressions/3. TO_CHAR with numbers.vtt 13.7 KB
13. Managing tables using DML Statments/4. Update Statement.vtt 13.7 KB
5. Restricting and Sorting Data/1. The WHERE Clause & Comparison Operators.vtt 13.1 KB
21. Retrieving Data By Using Subqueries/5. WITH Clause.vtt 13.1 KB
12. Using the Set Operators/2. Practice (Union, union all, intersect, minus ).vtt 12.8 KB
23. Controlling User Access/5. Creating ROLE Practice.vtt 12.8 KB
14. Introduction to Data Definition Language/6. Creating Tables ( Column Level Constraints ).vtt 12.3 KB
27. Bonus Section/4. About PLSQL.vtt 11.8 KB
23. Controlling User Access/1. Database Security System Privileges & Roles.vtt 11.5 KB
4. Retrieving data using the select statement/4. Column Alias, Concatenation , Distinct and DESCRIBE.vtt 11.5 KB
24. Manipulating Data/4. INSERT ALL statement INSERT FIRST.vtt 11.5 KB
8. Using Conversion Functions and Conditional Expressions/5. nvl , nvl2 , nullif and coalesce Functions.vtt 11.4 KB
20. Managing Schema Objects/7. About SQLLoader.vtt 11.4 KB
20. Managing Schema Objects/5. DEFERRABLE Constraints Exercises.vtt 11.2 KB
23. Controlling User Access/4. System Privileges & Privileges Practice 2.vtt 11.1 KB
13. Managing tables using DML Statments/5. Delete Statement.vtt 11.0 KB
9. Reporting Aggregated Data Using the Group Functions/3. Group by Clause, Having Clause.vtt 10.8 KB
5. Restricting and Sorting Data/2. Using Between and IN Like Operators.vtt 10.6 KB
24. Manipulating Data/8. FLASHBACK Table & System change Number ( SCN).vtt 10.6 KB
8. Using Conversion Functions and Conditional Expressions/6. The CASE Function.vtt 10.5 KB
13. Managing tables using DML Statments/8. Practice ( Commit and rollback ).vtt 10.5 KB
7. Using Single-Row Functions to Customize Output/6. Number functions ( Round, Trunc, MOD ).vtt 10.3 KB
3. Connecting to the Database/1. Connecting SYS using SQL plus & SQL Developer.vtt 10.3 KB
7. Using Single-Row Functions to Customize Output/5. Character functions ( lpad, rpad , replace, trim).vtt 10.2 KB
23. Controlling User Access/3. System Privileges & Privileges Practice 1.vtt 10.1 KB
25. Managing Data in Different Time Zones/5. V$TIMEZONE_NAMES and some functions.vtt 9.8 KB
21. Retrieving Data By Using Subqueries/3. Scalar Subquery Correlated Subquery.vtt 9.8 KB
3. Connecting to the Database/4. Unlock HR Account Part 2.vtt 9.7 KB
14. Introduction to Data Definition Language/4. Creating Tables (without constraints).vtt 9.7 KB
10. Displaying Data from multiple tables using joins/7. Old Joins Self Join and More Practices.vtt 9.5 KB
22. Manipulating Data By Using Subqueries/2. Correlated Update Correlated Delete.vtt 9.4 KB
14. Introduction to Data Definition Language/11. Alter Table Add Columns.vtt 9.4 KB
27. Bonus Section/2. Installing oracle 11g express edition.vtt 9.3 KB
14. Introduction to Data Definition Language/12. Alter Table Modify Columns.vtt 9.2 KB
21. Retrieving Data By Using Subqueries/1. Using the subquery as a source table.vtt 9.2 KB
11. Using Subqueries to Solve Queries/1. Single row Subqueries.vtt 9.1 KB
9. Reporting Aggregated Data Using the Group Functions/2. Group functions (sum, count, max, min, avg & more).vtt 9.1 KB
20. Managing Schema Objects/8. External Tables Part 1.vtt 8.9 KB
18. Creating sequences, synonyms, and indexes/3. Sequences Part 3.vtt 8.9 KB
23. Controlling User Access/2. Database Security Object Privileges.vtt 8.9 KB
2. Live SQL & Download Install/1. Oracle Live SQL No Installation for anything.vtt 8.8 KB
2. Live SQL & Download Install/4. Installing Oracle DB 12c.vtt 8.6 KB
8. Using Conversion Functions and Conditional Expressions/2. TO_CHAR with dates.vtt 8.6 KB
19. Creating Views/3. Creating Complex Views.vtt 8.6 KB
22. Manipulating Data By Using Subqueries/1. Inserting Updating Deleting Using a subquery as a target.vtt 8.5 KB
17. Introduction to Data Dictionary Views/3. USER_OBJECTS ALL_OBJECTS.vtt 8.3 KB
13. Managing tables using DML Statments/11. FOR UPDATE Clause.vtt 8.3 KB
7. Using Single-Row Functions to Customize Output/9. Date Functions ( round , trunc ).vtt 8.2 KB
19. Creating Views/2. Creating Simple Views.vtt 8.2 KB
10. Displaying Data from multiple tables using joins/5. Old Joins nonEquijoins.vtt 8.2 KB
27. Bonus Section/7. DML logs using package dbms_errlog.vtt 8.2 KB
5. Restricting and Sorting Data/4. Logical Operators (AND OR NOT).vtt 8.1 KB
19. Creating Views/4. With READ ONLY With check option Force view.vtt 8.0 KB
10. Displaying Data from multiple tables using joins/12. 1999 Syntax LeftRightfull Outer Join.vtt 8.0 KB
5. Restricting and Sorting Data/1.1 Restricting and Sorting Data.sql.sql 8.0 KB
10. Displaying Data from multiple tables using joins/6. Old Joins outer join.vtt 8.0 KB
23. Controlling User Access/6. With Grant Option.vtt 7.9 KB
10. Displaying Data from multiple tables using joins/4. Old Joins Equijoin.vtt 7.9 KB
18. Creating sequences, synonyms, and indexes/7. Creating Indexes Part 2.vtt 7.9 KB
8. Using Conversion Functions and Conditional Expressions/4. TO_NUMBER , TO_DATE Functions.vtt 7.8 KB
5. Restricting and Sorting Data/5. Order by Clause.vtt 7.8 KB
7. Using Single-Row Functions to Customize Output/8. Date Functions ( months_between, add_months, next_day, last_day).vtt 7.7 KB
7. Using Single-Row Functions to Customize Output/7. Date Functions ( Sysdate).vtt 7.6 KB
14. Introduction to Data Definition Language/1. DDL & Naming Rules.vtt 7.6 KB
5. Restricting and Sorting Data/6. The FETCH Clause.vtt 7.6 KB
10. Displaying Data from multiple tables using joins/11. 1999 Syntax ON Clause.vtt 7.6 KB
20. Managing Schema Objects/3. Enable Disable Constraints.vtt 7.4 KB
6. Substitution Variables/1. What is a Substitution Variables (&).vtt 7.3 KB
14. Introduction to Data Definition Language/9. ON DELETE cascade ON DELETE set null.vtt 7.3 KB
24. Manipulating Data/6. Creating Matrix Report Using PIVOT.vtt 7.2 KB
20. Managing Schema Objects/9. External Tables Part 2.vtt 7.2 KB
14. Introduction to Data Definition Language/16. Drop Table.vtt 7.1 KB
16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/1. About Exam 1Z0-061 Visiting Oracle Website.vtt 7.0 KB
14. Introduction to Data Definition Language/5. Types of constraints and why we use it.vtt 7.0 KB
14. Introduction to Data Definition Language/10. Create Table AS subquery.vtt 7.0 KB
4. Retrieving data using the select statement/2. Capabilities of SQL SELECT Statements.vtt 6.9 KB
6. Substitution Variables/4. Double-Ampersand SET VERIFY SET DEFINE.vtt 6.9 KB
1. Introduction/1. Course Agenda.vtt 6.9 KB
10. Displaying Data from multiple tables using joins/9. 1999 Syntax Natural Join.vtt 6.9 KB
17. Introduction to Data Dictionary Views/1. What is Data Dictionary Views.vtt 6.7 KB
7. Using Single-Row Functions to Customize Output/3. Character functions (concat, substr, length ).vtt 6.7 KB
21. Retrieving Data By Using Subqueries/2. Pairwise Non Pairwise Subqueries.vtt 6.6 KB
15. Tips you Should know/3. Tips you Should know Part 3.vtt 6.6 KB
15. Tips you Should know/1.1 chapter 15 tips.sql.sql 6.6 KB
8. Using Conversion Functions and Conditional Expressions/1. Implicit Data Conversion VS Explicit.vtt 6.5 KB
4. Retrieving data using the select statement/1. Navigate HR schema.vtt 6.4 KB
26. Exam 1Z0-071 for SQL Certified Associate/1. About the Exam 1Z0-071.vtt 6.4 KB
25. Managing Data in Different Time Zones/1. THE INTERVAL ( YEAR TO MONTH day TO second).vtt 6.4 KB
9. Reporting Aggregated Data Using the Group Functions/1. Group functions Introduction.vtt 6.4 KB
14. Introduction to Data Definition Language/2. Data Types Part 1.vtt 6.3 KB
13. Managing tables using DML Statments/1.4 lesson 13 last part.sql.sql 6.3 KB
24. Manipulating Data/7. The Merge Statement.vtt 6.3 KB
14. Introduction to Data Definition Language/13. Alter Table Drop Columns.vtt 6.3 KB
11. Using Subqueries to Solve Queries/2. Multiple rows Subqueries.vtt 6.2 KB
8. Using Conversion Functions and Conditional Expressions/7. The DECODE Function.vtt 6.2 KB
24. Manipulating Data/5. Another INSERT ALL Example & Notes.vtt 6.1 KB
10. Displaying Data from multiple tables using joins/1.3 chapter 10 part 3.sql.sql 6.1 KB
14. Introduction to Data Definition Language/1.4 chapter 14 sql part 1.sql.sql 6.1 KB
14. Introduction to Data Definition Language/7. Creating Tables ( Table Level Constraints ).vtt 6.1 KB
18. Creating sequences, synonyms, and indexes/2. Sequences Part 2.vtt 6.0 KB
15. Tips you Should know/6. Tips you Should know Part 6.vtt 6.0 KB
17. Introduction to Data Dictionary Views/4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.vtt 6.0 KB
15. Tips you Should know/1. Tips you Should know Part 1.vtt 6.0 KB
26. Exam 1Z0-071 for SQL Certified Associate/2. Some helpful websites contains exams Dumps.vtt 6.0 KB
13. Managing tables using DML Statments/7. About Commit & Rollback.vtt 5.9 KB
10. Displaying Data from multiple tables using joins/2. HR Tables Diagram, Joins Clarification.vtt 5.8 KB
14. Introduction to Data Definition Language/14. Alter Table Set Unused.vtt 5.7 KB
27. Bonus Section/3. Rownum and rowid.vtt 5.7 KB
14. Introduction to Data Definition Language/8. Constraints Guidelines.vtt 5.7 KB
18. Creating sequences, synonyms, and indexes/5. Creating Synonyms.vtt 5.7 KB
19. Creating Views/1. What is a View What is the benefits of Views.vtt 5.7 KB
18. Creating sequences, synonyms, and indexes/1. Sequences Part 1.vtt 5.3 KB
25. Managing Data in Different Time Zones/1.1 chapter 25.sql.sql 5.2 KB
4. Retrieving data using the select statement/3. Arithmetic expressions and NULL values.vtt 5.2 KB
17. Introduction to Data Dictionary Views/5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.vtt 5.2 KB
13. Managing tables using DML Statments/1. Introduction to DML.vtt 5.2 KB
14. Introduction to Data Definition Language/3. Data Types Part 2.vtt 5.2 KB
25. Managing Data in Different Time Zones/4. timestamp timestamp with time zone.vtt 5.2 KB
17. Introduction to Data Dictionary Views/7. COMMENT ON TABLE COLUMN.vtt 5.1 KB
21. Retrieving Data By Using Subqueries/4. Reminder of Exists Not Exists.vtt 5.1 KB
13. Managing tables using DML Statments/9. SAVEPOINT.vtt 5.0 KB
6. Substitution Variables/2. DEFINE UNDEFINE.vtt 5.0 KB
15. Tips you Should know/4. Tips you Should know Part 4.vtt 5.0 KB
20. Managing Schema Objects/6. GLOBAL TEMPORARY TABLE.vtt 5.0 KB
4. Retrieving data using the select statement/5. Important Notes in Select Statement.vtt 4.9 KB
10. Displaying Data from multiple tables using joins/1. Before You Start, important notes.vtt 4.9 KB
10. Displaying Data from multiple tables using joins/3. What is Cartesian product.vtt 4.8 KB
20. Managing Schema Objects/1.1 chapter 20 part 1.sql.sql 4.8 KB
7. Using Single-Row Functions to Customize Output/1. Single Row Function Introduction.vtt 4.8 KB
15. Tips you Should know/5. Tips you Should know Part 5.vtt 4.7 KB
1. Introduction/8. HR Schema in this Course.vtt 4.6 KB
19. Creating Views/1.1 chapter 19.sql.sql 4.6 KB
7. Using Single-Row Functions to Customize Output/10. Nesting Functions.vtt 4.6 KB
5. Restricting and Sorting Data/3. Using IS NULL NOT Not equal Operators.vtt 4.5 KB
24. Manipulating Data/2. Explicit default value in insert & update statement.vtt 4.5 KB
7. Using Single-Row Functions to Customize Output/4. Character functions ( instr ).vtt 4.5 KB
25. Managing Data in Different Time Zones/6. timestamp with local time zone.vtt 4.5 KB
13. Managing tables using DML Statments/3. Inserting common errors.vtt 4.5 KB
25. Managing Data in Different Time Zones/2. to_yminterval to_dsinterval.vtt 4.4 KB
1. Introduction/7. Oracle Database 12c Architecture.vtt 4.4 KB
27. Bonus Section/1. Using SELECT statement to create dynamic scripts.vtt 4.3 KB
11. Using Subqueries to Solve Queries/3. NULL values and Subqueries.vtt 4.3 KB
1. Introduction/4. Data Models & ERM.vtt 4.3 KB
11. Using Subqueries to Solve Queries/4. Exists and not Exists.vtt 4.2 KB
12. Using the Set Operators/1. Overview (Union, union all, intersect, minus ).vtt 4.2 KB
11. Using Subqueries to Solve Queries/1.2 chapter 11 sql.sql.sql 4.2 KB
6. Substitution Variables/3. ACCEPT PROMPT.vtt 4.2 KB
1. Introduction/5. About Primary key & foreign key.vtt 4.2 KB
13. Managing tables using DML Statments/6. What is Database Transactions.vtt 4.1 KB
3. Connecting to the Database/3. Unlock HR Account Part 1.vtt 4.1 KB
14. Introduction to Data Definition Language/1.3 chapter 14 sql part 2.sql.sql 3.9 KB
9. Reporting Aggregated Data Using the Group Functions/1.1 chapter 9.sql.sql 3.9 KB
23. Controlling User Access/7. Drop user Statement.vtt 3.9 KB
14. Introduction to Data Definition Language/15. ALTER TABLE READ ONLY READ write.vtt 3.9 KB
8. Using Conversion Functions and Conditional Expressions/1.3 chapter 8 part 2.sql.sql 3.9 KB
13. Managing tables using DML Statments/10. ROW Lock.vtt 3.9 KB
25. Managing Data in Different Time Zones/7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.vtt 3.8 KB
17. Introduction to Data Dictionary Views/1.1 chapter 17.sql.sql 3.7 KB
10. Displaying Data from multiple tables using joins/1.1 chapter 10 part 2.sql.sql 3.7 KB
7. Using Single-Row Functions to Customize Output/2. Character functions (Upper, Lower, Initcap ).vtt 3.7 KB
21. Retrieving Data By Using Subqueries/1.1 chapter 21 part 1.sql.sql 3.7 KB
8. Using Conversion Functions and Conditional Expressions/1.1 chapter 8 part 1.sql.sql 3.7 KB
18. Creating sequences, synonyms, and indexes/1.1 chapter 18 part 1.sql.sql 3.7 KB
13. Managing tables using DML Statments/1.5 chapter 13 part 1 insert.sql.sql 3.6 KB
2. Live SQL & Download Install/3. Downloading Oracle DB 12c.vtt 3.6 KB
10. Displaying Data from multiple tables using joins/8. 1999 Syntax Cross Join (Cartesian product ).vtt 3.6 KB
20. Managing Schema Objects/2. Rename Column Rename Constraint.vtt 3.6 KB
20. Managing Schema Objects/4. Understanding DEFERRABLE Constraints.vtt 3.5 KB
16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/2. My recommendations.vtt 3.5 KB
7. Using Single-Row Functions to Customize Output/1.3 7.3-date functions.sql.sql 3.5 KB
24. Manipulating Data/1.4 chapter 24 part 1.sql.sql 3.4 KB
10. Displaying Data from multiple tables using joins/10. 1999 Syntax USING Clause.vtt 3.3 KB
3. Connecting to the Database/5. ORA-01033 oracle initialization or shutdown in progress 12c.vtt 3.3 KB
1. Introduction/2. System Development Life Cycle & Database Definition.vtt 3.3 KB
24. Manipulating Data/3. Copy rows from another table.vtt 3.3 KB
18. Creating sequences, synonyms, and indexes/1.2 chapter 18 part 3.sql.sql 3.3 KB
7. Using Single-Row Functions to Customize Output/1.1 7.1-character functions.sql.sql 3.2 KB
14. Introduction to Data Definition Language/17. Rename Column Rename Table.vtt 3.2 KB
17. Introduction to Data Dictionary Views/2. What is DICTIONARY.vtt 3.1 KB
20. Managing Schema Objects/1.2 chapter 20 part 3.sql.sql 3.1 KB
24. Manipulating Data/1. What is Data Warehouse.vtt 3.0 KB
22. Manipulating Data By Using Subqueries/1.2 chapter 22.sql.sql 3.0 KB
6. Substitution Variables/1.1 Substitution Variables.sql.sql 3.0 KB
6. Substitution Variables/2.1 Substitution Variables.sql.sql 3.0 KB
12. Using the Set Operators/1.2 chapter 12.sql.sql 2.9 KB
1. Introduction/6. SQL and Types of SQL Statements.vtt 2.7 KB
15. Tips you Should know/2. Tips you Should know Part 2.vtt 2.7 KB
21. Retrieving Data By Using Subqueries/1.4 chapter 21 part 3.sql.sql 2.6 KB
20. Managing Schema Objects/1.3 chapter 20 part 2.sql.sql 2.6 KB
25. Managing Data in Different Time Zones/3. Extract function.vtt 2.4 KB
24. Manipulating Data/1.1 chapter 24 part 2.sql.sql 2.3 KB
4. Retrieving data using the select statement/1.2 Retrieving data using the select statement.sql.sql 2.3 KB
21. Retrieving Data By Using Subqueries/1.2 chapter 21 part 2.sql.sql 2.2 KB
13. Managing tables using DML Statments/1.2 chapter 13 part 2 update.sql.sql 2.2 KB
24. Manipulating Data/1.2 chapter 24 part 3.sql.sql 2.0 KB
27. Bonus Section/5. Understanding NULLS when used with ( IN NOT IN ).html 1.9 KB
10. Displaying Data from multiple tables using joins/1.2 chapter 10 part 1.sql.sql 1.7 KB
23. Controlling User Access/1.3 chapter 23 part 2.sql.sql 1.4 KB
1. Introduction/3. What is a Table.vtt 1.4 KB
28. What next it is time for PLSQL/1. Move your skills to PLSQL.html 1.3 KB
7. Using Single-Row Functions to Customize Output/1.4 7.2-number functions.sql.sql 1.2 KB
23. Controlling User Access/1.1 chapter 23 part 1.sql.sql 1.2 KB
13. Managing tables using DML Statments/1.3 chapter 13 part 3 delete.sql.sql 1.1 KB
27. Bonus Section/6. permanent solution for ORA-01033 oracle initialization or shutdown in progress.html 942 bytes
2. Live SQL & Download Install/2. Oracle Live SQL limitation.html 714 bytes
23. Controlling User Access/1.4 chapter 23 part 3.sql.sql 706 bytes
28. What next it is time for PLSQL/2. Move your skills to Oracle Analytic Functions In-Depth & Advanced Oracle SQL.html 702 bytes
18. Creating sequences, synonyms, and indexes/1.4 chapter 18 part 2.sql.sql 622 bytes
23. Controlling User Access/1.5 chapter 23 part 5.sql.sql 587 bytes
3. Connecting to the Database/6. ORA-65054 Cannot open a pluggable database in the desired mode.html 573 bytes
27. Bonus Section/7.1 dbms_errlog.sql.sql 480 bytes
2. Live SQL & Download Install/5. About oracle 11g express edition.html 478 bytes
23. Controlling User Access/1.6 chapter 23 part 4.sql.sql 466 bytes
14. Introduction to Data Definition Language/1.2 chapter 14 sql part 3.sql.sql 357 bytes
27. Bonus Section/1.1 Using SELECT statement to create dynamic scripts.sql.sql 357 bytes
3. Connecting to the Database/1.1 steps to unlock hr.sql.sql 320 bytes
3. Connecting to the Database/7. Creating new pluggable database contains HR user.html 211 bytes
[FreeCourseLab.com].url 126 bytes
26. Exam 1Z0-071 for SQL Certified Associate/3. EXAM 1z0-071 Sample Questions.html 96 bytes
3. Connecting to the Database/2. if you do not remember the sys password.html 52 bytes

[FreeCourseLab.com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071

File List

Download Torrent

Related Resources

Copyright Infringement