Torrent Downloads » Other » [FreeCourseLab com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071
Other
[FreeCourseLab com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071
Torrent info
Torrent Files List
1. Introduction (Size: 3.39 GB) (Files: 415)
1. Introduction
1. Course Agenda.mp4
1. Course Agenda.vtt
1.1 agenda - Copy.xlsx.xlsx
2. System Development Life Cycle & Database Definition.mp4
2. System Development Life Cycle & Database Definition.vtt
2.1 chapter 1 hint.pdf.pdf
3. What is a Table.mp4
3. What is a Table.vtt
4. Data Models & ERM.mp4
4. Data Models & ERM.vtt
5. About Primary key & foreign key.mp4
5. About Primary key & foreign key.vtt
6. SQL and Types of SQL Statements.mp4
6. SQL and Types of SQL Statements.vtt
7. Oracle Database 12c Architecture.mp4
7. Oracle Database 12c Architecture.vtt
8. HR Schema in this Course.mp4
8. HR Schema in this Course.vtt
10. Displaying Data from multiple tables using joins
1. Before You Start, important notes.mp4
1. Before You Start, important notes.vtt
1.1 chapter 10 part 2.sql.sql
1.2 chapter 10 part 1.sql.sql
1.3 chapter 10 part 3.sql.sql
1.4 chapter 10 hints.pdf.pdf
10. 1999 Syntax USING Clause.mp4
10. 1999 Syntax USING Clause.vtt
11. 1999 Syntax ON Clause.mp4
11. 1999 Syntax ON Clause.vtt
12. 1999 Syntax LeftRightfull Outer Join.mp4
12. 1999 Syntax LeftRightfull Outer Join.vtt
2. HR Tables Diagram, Joins Clarification.mp4
2. HR Tables Diagram, Joins Clarification.vtt
3. What is Cartesian product.mp4
3. What is Cartesian product.vtt
4. Old Joins Equijoin.mp4
4. Old Joins Equijoin.vtt
5. Old Joins nonEquijoins.mp4
5. Old Joins nonEquijoins.vtt
6. Old Joins outer join.mp4
6. Old Joins outer join.vtt
7. Old Joins Self Join and More Practices.mp4
7. Old Joins Self Join and More Practices.vtt
8. 1999 Syntax Cross Join (Cartesian product ).mp4
8. 1999 Syntax Cross Join (Cartesian product ).vtt
9. 1999 Syntax Natural Join.mp4
9. 1999 Syntax Natural Join.vtt
11. Using Subqueries to Solve Queries
1. Single row Subqueries.mp4
1. Single row Subqueries.vtt
1.1 chapter 11 hints.pdf.pdf
1.2 chapter 11 sql.sql.sql
2. Multiple rows Subqueries.mp4
2. Multiple rows Subqueries.vtt
3. NULL values and Subqueries.mp4
3. NULL values and Subqueries.vtt
4. Exists and not Exists.mp4
4. Exists and not Exists.vtt
12. Using the Set Operators
1. Overview (Union, union all, intersect, minus ).mp4
1. Overview (Union, union all, intersect, minus ).vtt
1.1 chapter 12 hints.pdf.pdf
1.2 chapter 12.sql.sql
2. Practice (Union, union all, intersect, minus ).mp4
2. Practice (Union, union all, intersect, minus ).vtt
13. Managing tables using DML Statments
1. Introduction to DML.mp4
1. Introduction to DML.vtt
1.1 chapter 13 hints.pdf.pdf
1.2 chapter 13 part 2 update.sql.sql
1.3 chapter 13 part 3 delete.sql.sql
1.4 lesson 13 last part.sql.sql
1.5 chapter 13 part 1 insert.sql.sql
10. ROW Lock.mp4
10. ROW Lock.vtt
11. FOR UPDATE Clause.mp4
11. FOR UPDATE Clause.vtt
2. Insert Statement.mp4
2. Insert Statement.vtt
3. Inserting common errors.mp4
3. Inserting common errors.vtt
4. Update Statement.mp4
4. Update Statement.vtt
5. Delete Statement.mp4
5. Delete Statement.vtt
6. What is Database Transactions.mp4
6. What is Database Transactions.vtt
7. About Commit & Rollback.mp4
7. About Commit & Rollback.vtt
8. Practice ( Commit and rollback ).mp4
8. Practice ( Commit and rollback ).vtt
9. SAVEPOINT.mp4
9. SAVEPOINT.vtt
14. Introduction to Data Definition Language
1. DDL & Naming Rules.mp4
1. DDL & Naming Rules.vtt
1.1 chapter 14 hints.pdf.pdf
1.2 chapter 14 sql part 3.sql.sql
1.3 chapter 14 sql part 2.sql.sql
1.4 chapter 14 sql part 1.sql.sql
10. Create Table AS subquery.mp4
10. Create Table AS subquery.vtt
11. Alter Table Add Columns.mp4
11. Alter Table Add Columns.vtt
12. Alter Table Modify Columns.mp4
12. Alter Table Modify Columns.vtt
13. Alter Table Drop Columns.mp4
13. Alter Table Drop Columns.vtt
14. Alter Table Set Unused.mp4
14. Alter Table Set Unused.vtt
15. ALTER TABLE READ ONLY READ write.mp4
15. ALTER TABLE READ ONLY READ write.vtt
16. Drop Table.mp4
16. Drop Table.vtt
17. Rename Column Rename Table.mp4
17. Rename Column Rename Table.vtt
2. Data Types Part 1.mp4
2. Data Types Part 1.vtt
3. Data Types Part 2.mp4
3. Data Types Part 2.vtt
4. Creating Tables (without constraints).mp4
4. Creating Tables (without constraints).vtt
5. Types of constraints and why we use it.mp4
5. Types of constraints and why we use it.vtt
6. Creating Tables ( Column Level Constraints ).mp4
6. Creating Tables ( Column Level Constraints ).vtt
7. Creating Tables ( Table Level Constraints ).mp4
7. Creating Tables ( Table Level Constraints ).vtt
8. Constraints Guidelines.mp4
8. Constraints Guidelines.vtt
9. ON DELETE cascade ON DELETE set null.mp4
9. ON DELETE cascade ON DELETE set null.vtt
15. Tips you Should know
1. Tips you Should know Part 1.mp4
1. Tips you Should know Part 1.vtt
1.1 chapter 15 tips.sql.sql
2. Tips you Should know Part 2.mp4
2. Tips you Should know Part 2.vtt
3. Tips you Should know Part 3.mp4
3. Tips you Should know Part 3.vtt
4. Tips you Should know Part 4.mp4
4. Tips you Should know Part 4.vtt
5. Tips you Should know Part 5.mp4
5. Tips you Should know Part 5.vtt
6. Tips you Should know Part 6.mp4
6. Tips you Should know Part 6.vtt
16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals
1. About Exam 1Z0-061 Visiting Oracle Website.mp4
1. About Exam 1Z0-061 Visiting Oracle Website.vtt
2. My recommendations.mp4
2. My recommendations.vtt
17. Introduction to Data Dictionary Views
1. What is Data Dictionary Views.mp4
1. What is Data Dictionary Views.vtt
1.1 chapter 17.sql.sql
1.2 chapter 17 hints.pdf.pdf
2. What is DICTIONARY.mp4
2. What is DICTIONARY.vtt
3. USER_OBJECTS ALL_OBJECTS.mp4
3. USER_OBJECTS ALL_OBJECTS.vtt
4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.mp4
4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.vtt
5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.mp4
5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.vtt
6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.mp4
6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.vtt
7. COMMENT ON TABLE COLUMN.mp4
7. COMMENT ON TABLE COLUMN.vtt
18. Creating sequences, synonyms, and indexes
1. Sequences Part 1.mp4
1. Sequences Part 1.vtt
1.1 chapter 18 part 1.sql.sql
1.2 chapter 18 part 3.sql.sql
1.3 chapter 18 hints.pdf.pdf
1.4 chapter 18 part 2.sql.sql
2. Sequences Part 2.mp4
2. Sequences Part 2.vtt
3. Sequences Part 3.mp4
3. Sequences Part 3.vtt
4. Sequences Part 4.mp4
4. Sequences Part 4.vtt
5. Creating Synonyms.mp4
5. Creating Synonyms.vtt
6. Creating Indexes Part 1.mp4
6. Creating Indexes Part 1.vtt
7. Creating Indexes Part 2.mp4
7. Creating Indexes Part 2.vtt
19. Creating Views
1. What is a View What is the benefits of Views.mp4
1. What is a View What is the benefits of Views.vtt
1.1 chapter 19.sql.sql
1.2 chapter 19 hints.pdf.pdf
2. Creating Simple Views.mp4
2. Creating Simple Views.vtt
3. Creating Complex Views.mp4
3. Creating Complex Views.vtt
4. With READ ONLY With check option Force view.mp4
4. With READ ONLY With check option Force view.vtt
2. Live SQL & Download Install
1. Oracle Live SQL No Installation for anything.mp4
1. Oracle Live SQL No Installation for anything.vtt
2. Oracle Live SQL limitation.html
3. Downloading Oracle DB 12c.mp4
3. Downloading Oracle DB 12c.vtt
4. Installing Oracle DB 12c.mp4
4. Installing Oracle DB 12c.vtt
5. About oracle 11g express edition.html
20. Managing Schema Objects
1. Adding constraints dropping constraints.mp4
1. Adding constraints dropping constraints.vtt
1.1 chapter 20 part 1.sql.sql
1.2 chapter 20 part 3.sql.sql
1.3 chapter 20 part 2.sql.sql
2. Rename Column Rename Constraint.mp4
2. Rename Column Rename Constraint.vtt
3. Enable Disable Constraints.mp4
3. Enable Disable Constraints.vtt
4. Understanding DEFERRABLE Constraints.mp4
4. Understanding DEFERRABLE Constraints.vtt
5. DEFERRABLE Constraints Exercises.mp4
5. DEFERRABLE Constraints Exercises.vtt
6. GLOBAL TEMPORARY TABLE.mp4
6. GLOBAL TEMPORARY TABLE.vtt
7. About SQLLoader.mp4
7. About SQLLoader.vtt
7.1 emp.csv.csv
8. External Tables Part 1.mp4
8. External Tables Part 1.vtt
9. External Tables Part 2.mp4
9. External Tables Part 2.vtt
21. Retrieving Data By Using Subqueries
1. Using the subquery as a source table.mp4
1. Using the subquery as a source table.vtt
1.1 chapter 21 part 1.sql.sql
1.2 chapter 21 part 2.sql.sql
1.3 chapter 21 hints.pdf.pdf
1.4 chapter 21 part 3.sql.sql
2. Pairwise Non Pairwise Subqueries.mp4
2. Pairwise Non Pairwise Subqueries.vtt
3. Scalar Subquery Correlated Subquery.mp4
3. Scalar Subquery Correlated Subquery.vtt
4. Reminder of Exists Not Exists.mp4
4. Reminder of Exists Not Exists.vtt
5. WITH Clause.mp4
5. WITH Clause.vtt
22. Manipulating Data By Using Subqueries
1. Inserting Updating Deleting Using a subquery as a target.mp4
1. Inserting Updating Deleting Using a subquery as a target.vtt
1.1 chapter 22 hints.pdf.pdf
1.2 chapter 22.sql.sql
2. Correlated Update Correlated Delete.mp4
2. Correlated Update Correlated Delete.vtt
23. Controlling User Access
1. Database Security System Privileges & Roles.mp4
1. Database Security System Privileges & Roles.vtt
1.1 chapter 23 part 1.sql.sql
1.2 chapter 23 hints.pdf.pdf
1.3 chapter 23 part 2.sql.sql
1.4 chapter 23 part 3.sql.sql
1.5 chapter 23 part 5.sql.sql
1.6 chapter 23 part 4.sql.sql
2. Database Security Object Privileges.mp4
2. Database Security Object Privileges.vtt
3. System Privileges & Privileges Practice 1.mp4
3. System Privileges & Privileges Practice 1.vtt
4. System Privileges & Privileges Practice 2.mp4
4. System Privileges & Privileges Practice 2.vtt
5. Creating ROLE Practice.mp4
5. Creating ROLE Practice.vtt
6. With Grant Option.mp4
6. With Grant Option.vtt
7. Drop user Statement.mp4
7. Drop user Statement.vtt
24. Manipulating Data
1. What is Data Warehouse.mp4
1. What is Data Warehouse.vtt
1.1 chapter 24 part 2.sql.sql
1.2 chapter 24 part 3.sql.sql
1.3 chapter 24 hints.pdf.pdf
1.4 chapter 24 part 1.sql.sql
2. Explicit default value in insert & update statement.mp4
2. Explicit default value in insert & update statement.vtt
3. Copy rows from another table.mp4
3. Copy rows from another table.vtt
4. INSERT ALL statement INSERT FIRST.mp4
4. INSERT ALL statement INSERT FIRST.vtt
5. Another INSERT ALL Example & Notes.mp4
5. Another INSERT ALL Example & Notes.vtt
6. Creating Matrix Report Using PIVOT.mp4
6. Creating Matrix Report Using PIVOT.vtt
7. The Merge Statement.mp4
7. The Merge Statement.vtt
8. FLASHBACK Table & System change Number ( SCN).mp4
8. FLASHBACK Table & System change Number ( SCN).vtt
25. Managing Data in Different Time Zones
1. THE INTERVAL ( YEAR TO MONTH day TO second).mp4
1. THE INTERVAL ( YEAR TO MONTH day TO second).vtt
1.1 chapter 25.sql.sql
1.2 chapter 25 hints.pdf.pdf
2. to_yminterval to_dsinterval.mp4
2. to_yminterval to_dsinterval.vtt
3. Extract function.mp4
3. Extract function.vtt
4. timestamp timestamp with time zone.mp4
4. timestamp timestamp with time zone.vtt
5. V$TIMEZONE_NAMES and some functions.mp4
5. V$TIMEZONE_NAMES and some functions.vtt
6. timestamp with local time zone.mp4
6. timestamp with local time zone.vtt
7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.mp4
7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.vtt
26. Exam 1Z0-071 for SQL Certified Associate
1. About the Exam 1Z0-071.mp4
1. About the Exam 1Z0-071.vtt
2. Some helpful websites contains exams Dumps.mp4
2. Some helpful websites contains exams Dumps.vtt
3. EXAM 1z0-071 Sample Questions.html
3.1 EXAM 1z0-071 sample.pdf.pdf
27. Bonus Section
1. Using SELECT statement to create dynamic scripts.mp4
1. Using SELECT statement to create dynamic scripts.vtt
1.1 Using SELECT statement to create dynamic scripts.sql.sql
2. Installing oracle 11g express edition.mp4
2. Installing oracle 11g express edition.vtt
3. Rownum and rowid.mp4
3. Rownum and rowid.vtt
4. About PLSQL.mp4
4. About PLSQL.vtt
5. Understanding NULLS when used with ( IN NOT IN ).html
6. permanent solution for ORA-01033 oracle initialization or shutdown in progress.html
7. DML logs using package dbms_errlog.mp4
7. DML logs using package dbms_errlog.vtt
7.1 dbms_errlog.sql.sql
28. What next it is time for PLSQL
1. Move your skills to PLSQL.html
2. Move your skills to Oracle Analytic Functions In-Depth & Advanced Oracle SQL.html
3. Connecting to the Database
1. Connecting SYS using SQL plus & SQL Developer.mp4
1. Connecting SYS using SQL plus & SQL Developer.vtt
1.1 steps to unlock hr.sql.sql
2. if you do not remember the sys password.html
3. Unlock HR Account Part 1.mp4
3. Unlock HR Account Part 1.vtt
4. Unlock HR Account Part 2.mp4
4. Unlock HR Account Part 2.vtt
5. ORA-01033 oracle initialization or shutdown in progress 12c.mp4
5. ORA-01033 oracle initialization or shutdown in progress 12c.vtt
6. ORA-65054 Cannot open a pluggable database in the desired mode.html
7. Creating new pluggable database contains HR user.html
7.1 Creating new pluggable database contains HR user.pdf.pdf
4. Retrieving data using the select statement
1. Navigate HR schema.mp4
1. Navigate HR schema.vtt
1.1 Capabilities of SQL select statement .pdf.pdf
1.2 Retrieving data using the select statement.sql.sql
2. Capabilities of SQL SELECT Statements.mp4
2. Capabilities of SQL SELECT Statements.vtt
3. Arithmetic expressions and NULL values.mp4
3. Arithmetic expressions and NULL values.vtt
4. Column Alias, Concatenation , Distinct and DESCRIBE.mp4
4. Column Alias, Concatenation , Distinct and DESCRIBE.vtt
5. Important Notes in Select Statement.mp4
5. Important Notes in Select Statement.vtt
5. Restricting and Sorting Data
1. The WHERE Clause & Comparison Operators.mp4
1. The WHERE Clause & Comparison Operators.vtt
1.1 Restricting and Sorting Data.sql.sql
1.2 chapter 5 hints .pdf.pdf
2. Using Between and IN Like Operators.mp4
2. Using Between and IN Like Operators.vtt
3. Using IS NULL NOT Not equal Operators.mp4
3. Using IS NULL NOT Not equal Operators.vtt
4. Logical Operators (AND OR NOT).mp4
4. Logical Operators (AND OR NOT).vtt
5. Order by Clause.mp4
5. Order by Clause.vtt
6. The FETCH Clause.mp4
6. The FETCH Clause.vtt
6. Substitution Variables
1. What is a Substitution Variables (&).mp4
1. What is a Substitution Variables (&).vtt
1.1 Substitution Variables.sql.sql
2. DEFINE UNDEFINE.mp4
2. DEFINE UNDEFINE.vtt
2.1 Substitution Variables.sql.sql
3. ACCEPT PROMPT.mp4
3. ACCEPT PROMPT.vtt
4. Double-Ampersand SET VERIFY SET DEFINE.mp4
4. Double-Ampersand SET VERIFY SET DEFINE.vtt
7. Using Single-Row Functions to Customize Output
1. Single Row Function Introduction.mp4
1. Single Row Function Introduction.vtt
1.1 7.1-character functions.sql.sql
1.2 chapter 7 hints.pdf.pdf
1.3 7.3-date functions.sql.sql
1.4 7.2-number functions.sql.sql
10. Nesting Functions.mp4
10. Nesting Functions.vtt
2. Character functions (Upper, Lower, Initcap ).mp4
2. Character functions (Upper, Lower, Initcap ).vtt
3. Character functions (concat, substr, length ).mp4
3. Character functions (concat, substr, length ).vtt
4. Character functions ( instr ).mp4
4. Character functions ( instr ).vtt
5. Character functions ( lpad, rpad , replace, trim).mp4
5. Character functions ( lpad, rpad , replace, trim).vtt
6. Number functions ( Round, Trunc, MOD ).mp4
6. Number functions ( Round, Trunc, MOD ).vtt
7. Date Functions ( Sysdate).mp4
7. Date Functions ( Sysdate).vtt
8. Date Functions ( months_between, add_months, next_day, last_day).mp4
8. Date Functions ( months_between, add_months, next_day, last_day).vtt
9. Date Functions ( round , trunc ).mp4
9. Date Functions ( round , trunc ).vtt
8. Using Conversion Functions and Conditional Expressions
1. Implicit Data Conversion VS Explicit.mp4
1. Implicit Data Conversion VS Explicit.vtt
1.1 chapter 8 part 1.sql.sql
1.2 chapter 8 hints.pdf.pdf
1.3 chapter 8 part 2.sql.sql
2. TO_CHAR with dates.mp4
2. TO_CHAR with dates.vtt
3. TO_CHAR with numbers.mp4
3. TO_CHAR with numbers.vtt
4. TO_NUMBER , TO_DATE Functions.mp4
4. TO_NUMBER , TO_DATE Functions.vtt
5. nvl , nvl2 , nullif and coalesce Functions.mp4
5. nvl , nvl2 , nullif and coalesce Functions.vtt
6. The CASE Function.mp4
6. The CASE Function.vtt
7. The DECODE Function.mp4
7. The DECODE Function.vtt
9. Reporting Aggregated Data Using the Group Functions
1. Group functions Introduction.mp4
1. Group functions Introduction.vtt
1.1 chapter 9.sql.sql
1.2 chapter 9 hints.pdf.pdf
2. Group functions (sum, count, max, min, avg & more).mp4
2. Group functions (sum, count, max, min, avg & more).vtt
3. Group by Clause, Having Clause.mp4
3. Group by Clause, Having Clause.vtt
[FreeCourseLab.com].url
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch [FreeCourseLab com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071 Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
