FreeCourseLab com Udemy Oracle Database 12c SQL Certified Associate 1Z0 071

FreeCourseLab com Udemy Oracle Database 12c SQL Certified Associate 1Z0 071

Name	[FreeCourseLab.com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	3.6 GB
Total Files	415
Last Seen	2025-04-07 00:52
Hash	9624B897B49537A52E3B9FD016F0779A63B7DD0E

/1. Introduction/
1. Course Agenda.mp4	22.1 MB
1. Course Agenda.vtt	7.1 KB
1.1 agenda - Copy.xlsx.xlsx	15.0 KB
2. System Development Life Cycle & Database Definition.mp4	15.4 MB
2. System Development Life Cycle & Database Definition.vtt	3.3 KB
2.1 chapter 1 hint.pdf.pdf	550.1 KB
3. What is a Table.mp4	7.0 MB
3. What is a Table.vtt	1.4 KB
4. Data Models & ERM.mp4	19.4 MB
4. Data Models & ERM.vtt	4.4 KB
5. About Primary key & foreign key.mp4	15.2 MB
5. About Primary key & foreign key.vtt	4.3 KB
6. SQL and Types of SQL Statements.mp4	14.1 MB
6. SQL and Types of SQL Statements.vtt	2.8 KB
7. Oracle Database 12c Architecture.mp4	16.0 MB
7. Oracle Database 12c Architecture.vtt	4.5 KB
8. HR Schema in this Course.mp4	22.3 MB
8. HR Schema in this Course.vtt	4.7 KB
/10. Displaying Data from multiple tables using joins/
1. Before You Start, important notes.mp4	40.4 MB
1. Before You Start, important notes.vtt	5.0 KB
1.1 chapter 10 part 2.sql.sql	3.8 KB
1.2 chapter 10 part 1.sql.sql	1.8 KB
1.3 chapter 10 part 3.sql.sql	6.3 KB
1.4 chapter 10 hints.pdf.pdf	1.3 MB
10. 1999 Syntax USING Clause.mp4	13.3 MB
10. 1999 Syntax USING Clause.vtt	3.4 KB
11. 1999 Syntax ON Clause.mp4	21.3 MB
11. 1999 Syntax ON Clause.vtt	7.7 KB
12. 1999 Syntax LeftRightfull Outer Join.mp4	23.6 MB
12. 1999 Syntax LeftRightfull Outer Join.vtt	8.2 KB
2. HR Tables Diagram, Joins Clarification.mp4	13.3 MB
2. HR Tables Diagram, Joins Clarification.vtt	5.9 KB
3. What is Cartesian product.mp4	19.1 MB
3. What is Cartesian product.vtt	5.0 KB
4. Old Joins Equijoin.mp4	21.4 MB
4. Old Joins Equijoin.vtt	8.1 KB
5. Old Joins nonEquijoins.mp4	25.7 MB
5. Old Joins nonEquijoins.vtt	8.4 KB
6. Old Joins outer join.mp4	21.9 MB
6. Old Joins outer join.vtt	8.2 KB
7. Old Joins Self Join and More Practices.mp4	21.0 MB
7. Old Joins Self Join and More Practices.vtt	9.8 KB
8. 1999 Syntax Cross Join (Cartesian product ).mp4	15.3 MB
8. 1999 Syntax Cross Join (Cartesian product ).vtt	3.7 KB
9. 1999 Syntax Natural Join.mp4	27.5 MB
9. 1999 Syntax Natural Join.vtt	7.0 KB
/11. Using Subqueries to Solve Queries/
1. Single row Subqueries.mp4	22.3 MB
1. Single row Subqueries.vtt	9.4 KB
1.1 chapter 11 hints.pdf.pdf	495.5 KB
1.2 chapter 11 sql.sql.sql	4.3 KB
2. Multiple rows Subqueries.mp4	18.4 MB
2. Multiple rows Subqueries.vtt	6.4 KB
3. NULL values and Subqueries.mp4	16.7 MB
3. NULL values and Subqueries.vtt	4.4 KB
4. Exists and not Exists.mp4	14.1 MB
4. Exists and not Exists.vtt	4.3 KB
/12. Using the Set Operators/
1. Overview (Union, union all, intersect, minus ).mp4	12.3 MB
1. Overview (Union, union all, intersect, minus ).vtt	4.3 KB
1.1 chapter 12 hints.pdf.pdf	480.6 KB
1.2 chapter 12.sql.sql	3.0 KB
2. Practice (Union, union all, intersect, minus ).mp4	28.1 MB
2. Practice (Union, union all, intersect, minus ).vtt	13.1 KB
/13. Managing tables using DML Statments/
1. Introduction to DML.mp4	11.5 MB
1. Introduction to DML.vtt	5.3 KB
1.1 chapter 13 hints.pdf.pdf	2.1 MB
1.2 chapter 13 part 2 update.sql.sql	2.2 KB
1.3 chapter 13 part 3 delete.sql.sql	1.1 KB
1.4 lesson 13 last part.sql.sql	6.5 KB
1.5 chapter 13 part 1 insert.sql.sql	3.7 KB
10. ROW Lock.mp4	11.1 MB
10. ROW Lock.vtt	3.9 KB
11. FOR UPDATE Clause.mp4	20.3 MB
11. FOR UPDATE Clause.vtt	8.5 KB
2. Insert Statement.mp4	34.8 MB
2. Insert Statement.vtt	14.5 KB
3. Inserting common errors.mp4	15.3 MB
3. Inserting common errors.vtt	4.6 KB
4. Update Statement.mp4	35.3 MB
4. Update Statement.vtt	14.0 KB
5. Delete Statement.mp4	34.8 MB
5. Delete Statement.vtt	11.3 KB
6. What is Database Transactions.mp4	17.6 MB
6. What is Database Transactions.vtt	4.2 KB
7. About Commit & Rollback.mp4	19.7 MB
7. About Commit & Rollback.vtt	6.0 KB
8. Practice ( Commit and rollback ).mp4	27.2 MB
8. Practice ( Commit and rollback ).vtt	10.7 KB
9. SAVEPOINT.mp4	12.6 MB
9. SAVEPOINT.vtt	5.1 KB
/14. Introduction to Data Definition Language/
1. DDL & Naming Rules.mp4	21.7 MB
1. DDL & Naming Rules.vtt	7.8 KB
1.1 chapter 14 hints.pdf.pdf	2.8 MB
1.2 chapter 14 sql part 3.sql.sql	0.4 KB
1.3 chapter 14 sql part 2.sql.sql	4.0 KB
1.4 chapter 14 sql part 1.sql.sql	6.2 KB
10. Create Table AS subquery.mp4	19.5 MB
10. Create Table AS subquery.vtt	7.2 KB
11. Alter Table Add Columns.mp4	23.5 MB
11. Alter Table Add Columns.vtt	9.6 KB
12. Alter Table Modify Columns.mp4	20.2 MB
12. Alter Table Modify Columns.vtt	9.5 KB
13. Alter Table Drop Columns.mp4	19.1 MB
13. Alter Table Drop Columns.vtt	6.4 KB
14. Alter Table Set Unused.mp4	18.6 MB
14. Alter Table Set Unused.vtt	5.9 KB
15. ALTER TABLE READ ONLY READ write.mp4	17.9 MB
15. ALTER TABLE READ ONLY READ write.vtt	4.0 KB
16. Drop Table.mp4	16.4 MB
16. Drop Table.vtt	7.3 KB
17. Rename Column Rename Table.mp4	9.7 MB
17. Rename Column Rename Table.vtt	3.3 KB
2. Data Types Part 1.mp4	16.9 MB
2. Data Types Part 1.vtt	6.5 KB
3. Data Types Part 2.mp4	14.0 MB
3. Data Types Part 2.vtt	5.3 KB
4. Creating Tables (without constraints).mp4	23.0 MB
4. Creating Tables (without constraints).vtt	9.9 KB
5. Types of constraints and why we use it.mp4	17.1 MB
5. Types of constraints and why we use it.vtt	7.2 KB
6. Creating Tables ( Column Level Constraints ).mp4	33.8 MB
6. Creating Tables ( Column Level Constraints ).vtt	12.6 KB
7. Creating Tables ( Table Level Constraints ).mp4	15.4 MB
7. Creating Tables ( Table Level Constraints ).vtt	6.2 KB
8. Constraints Guidelines.mp4	18.6 MB
8. Constraints Guidelines.vtt	5.8 KB
9. ON DELETE cascade ON DELETE set null.mp4	19.4 MB
9. ON DELETE cascade ON DELETE set null.vtt	7.5 KB
/15. Tips you Should know/
1. Tips you Should know Part 1.mp4	17.1 MB
1. Tips you Should know Part 1.vtt	6.1 KB
1.1 chapter 15 tips.sql.sql	6.7 KB
2. Tips you Should know Part 2.mp4	5.6 MB
2. Tips you Should know Part 2.vtt	2.7 KB
3. Tips you Should know Part 3.mp4	15.5 MB
3. Tips you Should know Part 3.vtt	6.8 KB
4. Tips you Should know Part 4.mp4	12.5 MB
4. Tips you Should know Part 4.vtt	5.1 KB
5. Tips you Should know Part 5.mp4	12.1 MB
5. Tips you Should know Part 5.vtt	4.8 KB
6. Tips you Should know Part 6.mp4	16.4 MB
6. Tips you Should know Part 6.vtt	6.2 KB
/16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/
1. About Exam 1Z0-061 Visiting Oracle Website.mp4	23.2 MB
1. About Exam 1Z0-061 Visiting Oracle Website.vtt	7.2 KB
2. My recommendations.mp4	16.0 MB
2. My recommendations.vtt	3.5 KB
/17. Introduction to Data Dictionary Views/
1. What is Data Dictionary Views.mp4	17.1 MB
1. What is Data Dictionary Views.vtt	6.9 KB
1.1 chapter 17.sql.sql	3.8 KB
1.2 chapter 17 hints.pdf.pdf	1.4 MB
2. What is DICTIONARY.mp4	11.0 MB
2. What is DICTIONARY.vtt	3.2 KB
3. USER_OBJECTS ALL_OBJECTS.mp4	19.2 MB
3. USER_OBJECTS ALL_OBJECTS.vtt	8.5 KB
4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.mp4	20.3 MB
4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.vtt	6.1 KB
5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.mp4	15.5 MB
5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.vtt	5.3 KB
6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.mp4	40.2 MB
6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.vtt	15.9 KB
7. COMMENT ON TABLE COLUMN.mp4	15.6 MB
7. COMMENT ON TABLE COLUMN.vtt	5.2 KB
/18. Creating sequences, synonyms, and indexes/
1. Sequences Part 1.mp4	18.5 MB
1. Sequences Part 1.vtt	5.4 KB
1.1 chapter 18 part 1.sql.sql	3.7 KB
1.2 chapter 18 part 3.sql.sql	3.3 KB
1.3 chapter 18 hints.pdf.pdf	1.2 MB
1.4 chapter 18 part 2.sql.sql	0.6 KB
2. Sequences Part 2.mp4	17.6 MB
2. Sequences Part 2.vtt	6.2 KB
3. Sequences Part 3.mp4	19.2 MB
3. Sequences Part 3.vtt	9.1 KB
4. Sequences Part 4.mp4	34.7 MB
4. Sequences Part 4.vtt	14.8 KB
5. Creating Synonyms.mp4	18.7 MB
5. Creating Synonyms.vtt	5.8 KB
6. Creating Indexes Part 1.mp4	43.9 MB
6. Creating Indexes Part 1.vtt	17.6 KB
7. Creating Indexes Part 2.mp4	26.9 MB
7. Creating Indexes Part 2.vtt	8.0 KB
/19. Creating Views/
1. What is a View What is the benefits of Views.mp4	13.8 MB
1. What is a View What is the benefits of Views.vtt	5.8 KB
1.1 chapter 19.sql.sql	4.7 KB
1.2 chapter 19 hints.pdf.pdf	791.1 KB
2. Creating Simple Views.mp4	20.2 MB
2. Creating Simple Views.vtt	8.4 KB
3. Creating Complex Views.mp4	22.9 MB
3. Creating Complex Views.vtt	8.8 KB
4. With READ ONLY With check option Force view.mp4	21.5 MB
4. With READ ONLY With check option Force view.vtt	8.2 KB
/2. Live SQL & Download Install/
1. Oracle Live SQL No Installation for anything.mp4	37.7 MB
1. Oracle Live SQL No Installation for anything.vtt	9.0 KB
2. Oracle Live SQL limitation.html	0.7 KB
3. Downloading Oracle DB 12c.mp4	18.6 MB
3. Downloading Oracle DB 12c.vtt	3.7 KB
4. Installing Oracle DB 12c.mp4	26.8 MB
4. Installing Oracle DB 12c.vtt	8.8 KB
5. About oracle 11g express edition.html	0.5 KB
/20. Managing Schema Objects/
1. Adding constraints dropping constraints.mp4	38.3 MB
1. Adding constraints dropping constraints.vtt	16.7 KB
1.1 chapter 20 part 1.sql.sql	5.0 KB
1.2 chapter 20 part 3.sql.sql	3.1 KB
1.3 chapter 20 part 2.sql.sql	2.7 KB
2. Rename Column Rename Constraint.mp4	8.8 MB
2. Rename Column Rename Constraint.vtt	3.6 KB
3. Enable Disable Constraints.mp4	22.5 MB
3. Enable Disable Constraints.vtt	7.6 KB
4. Understanding DEFERRABLE Constraints.mp4	20.8 MB
4. Understanding DEFERRABLE Constraints.vtt	3.6 KB
5. DEFERRABLE Constraints Exercises.mp4	23.0 MB
5. DEFERRABLE Constraints Exercises.vtt	11.5 KB
6. GLOBAL TEMPORARY TABLE.mp4	14.9 MB
6. GLOBAL TEMPORARY TABLE.vtt	5.1 KB
7. About SQLLoader.mp4	36.6 MB
7. About SQLLoader.vtt	11.7 KB
7.1 emp.csv.csv	510.1 KB
8. External Tables Part 1.mp4	22.9 MB
8. External Tables Part 1.vtt	9.1 KB
9. External Tables Part 2.mp4	17.9 MB
9. External Tables Part 2.vtt	7.4 KB
/21. Retrieving Data By Using Subqueries/
1. Using the subquery as a source table.mp4	24.6 MB
1. Using the subquery as a source table.vtt	9.4 KB
1.1 chapter 21 part 1.sql.sql	3.8 KB
1.2 chapter 21 part 2.sql.sql	2.3 KB
1.3 chapter 21 hints.pdf.pdf	109.3 KB
1.4 chapter 21 part 3.sql.sql	2.7 KB
2. Pairwise Non Pairwise Subqueries.mp4	18.5 MB
2. Pairwise Non Pairwise Subqueries.vtt	6.8 KB
3. Scalar Subquery Correlated Subquery.mp4	23.9 MB
3. Scalar Subquery Correlated Subquery.vtt	10.0 KB
4. Reminder of Exists Not Exists.mp4	23.2 MB
4. Reminder of Exists Not Exists.vtt	5.2 KB
5. WITH Clause.mp4	34.6 MB
5. WITH Clause.vtt	13.4 KB
/22. Manipulating Data By Using Subqueries/
1. Inserting Updating Deleting Using a subquery as a target.mp4	21.3 MB
1. Inserting Updating Deleting Using a subquery as a target.vtt	8.7 KB
1.1 chapter 22 hints.pdf.pdf	107.6 KB
1.2 chapter 22.sql.sql	3.0 KB
2. Correlated Update Correlated Delete.mp4	27.0 MB
2. Correlated Update Correlated Delete.vtt	9.6 KB
/23. Controlling User Access/
1. Database Security System Privileges & Roles.mp4	25.4 MB
1. Database Security System Privileges & Roles.vtt	11.8 KB
1.1 chapter 23 part 1.sql.sql	1.2 KB
1.2 chapter 23 hints.pdf.pdf	1.1 MB
1.3 chapter 23 part 2.sql.sql	1.4 KB
1.4 chapter 23 part 3.sql.sql	0.7 KB
1.5 chapter 23 part 5.sql.sql	0.6 KB
1.6 chapter 23 part 4.sql.sql	0.5 KB
2. Database Security Object Privileges.mp4	23.4 MB
2. Database Security Object Privileges.vtt	9.1 KB
3. System Privileges & Privileges Practice 1.mp4	24.2 MB
3. System Privileges & Privileges Practice 1.vtt	10.4 KB
4. System Privileges & Privileges Practice 2.mp4	27.0 MB
4. System Privileges & Privileges Practice 2.vtt	11.4 KB
5. Creating ROLE Practice.mp4	31.9 MB
5. Creating ROLE Practice.vtt	13.1 KB
6. With Grant Option.mp4	18.9 MB
6. With Grant Option.vtt	8.1 KB
7. Drop user Statement.mp4	14.6 MB
7. Drop user Statement.vtt	4.0 KB
/24. Manipulating Data/
1. What is Data Warehouse.mp4	9.6 MB
1. What is Data Warehouse.vtt	3.1 KB
1.1 chapter 24 part 2.sql.sql	2.4 KB
1.2 chapter 24 part 3.sql.sql	2.1 KB
1.3 chapter 24 hints.pdf.pdf	561.3 KB
1.4 chapter 24 part 1.sql.sql	3.5 KB
2. Explicit default value in insert & update statement.mp4	11.3 MB
2. Explicit default value in insert & update statement.vtt	4.6 KB
3. Copy rows from another table.mp4	9.0 MB
3. Copy rows from another table.vtt	3.3 KB
4. INSERT ALL statement INSERT FIRST.mp4	29.7 MB
4. INSERT ALL statement INSERT FIRST.vtt	11.8 KB
5. Another INSERT ALL Example & Notes.mp4	19.7 MB
5. Another INSERT ALL Example & Notes.vtt	6.3 KB
6. Creating Matrix Report Using PIVOT.mp4	17.9 MB
6. Creating Matrix Report Using PIVOT.vtt	7.4 KB
7. The Merge Statement.mp4	12.8 MB
7. The Merge Statement.vtt	6.4 KB
8. FLASHBACK Table & System change Number ( SCN).mp4	29.2 MB
8. FLASHBACK Table & System change Number ( SCN).vtt	10.8 KB
/25. Managing Data in Different Time Zones/
1. THE INTERVAL ( YEAR TO MONTH day TO second).mp4	19.5 MB
1. THE INTERVAL ( YEAR TO MONTH day TO second).vtt	6.5 KB
1.1 chapter 25.sql.sql	5.3 KB
1.2 chapter 25 hints.pdf.pdf	286.4 KB
2. to_yminterval to_dsinterval.mp4	9.8 MB
2. to_yminterval to_dsinterval.vtt	4.6 KB
3. Extract function.mp4	5.2 MB
3. Extract function.vtt	2.4 KB
4. timestamp timestamp with time zone.mp4	11.4 MB
4. timestamp timestamp with time zone.vtt	5.3 KB
5. V$TIMEZONE_NAMES and some functions.mp4	20.0 MB
5. V$TIMEZONE_NAMES and some functions.vtt	10.1 KB
6. timestamp with local time zone.mp4	12.4 MB
6. timestamp with local time zone.vtt	4.6 KB
7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.mp4	12.8 MB
7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.vtt	3.9 KB
/26. Exam 1Z0-071 for SQL Certified Associate/
1. About the Exam 1Z0-071.mp4	19.3 MB
1. About the Exam 1Z0-071.vtt	6.5 KB
2. Some helpful websites contains exams Dumps.mp4	31.3 MB
2. Some helpful websites contains exams Dumps.vtt	6.1 KB
3. EXAM 1z0-071 Sample Questions.html	0.1 KB
3.1 EXAM 1z0-071 sample.pdf.pdf	1.8 MB
/27. Bonus Section/
1. Using SELECT statement to create dynamic scripts.mp4	19.7 MB
1. Using SELECT statement to create dynamic scripts.vtt	4.4 KB
1.1 Using SELECT statement to create dynamic scripts.sql.sql	0.4 KB
2. Installing oracle 11g express edition.mp4	38.7 MB
2. Installing oracle 11g express edition.vtt	9.5 KB
3. Rownum and rowid.mp4	17.1 MB
3. Rownum and rowid.vtt	5.8 KB
4. About PLSQL.mp4	33.0 MB
4. About PLSQL.vtt	12.1 KB
5. Understanding NULLS when used with ( IN NOT IN ).html	2.0 KB
6. permanent solution for ORA-01033 oracle initialization or shutdown in progress.html	0.9 KB
7. DML logs using package dbms_errlog.mp4	94.6 MB
7. DML logs using package dbms_errlog.vtt	8.4 KB
7.1 dbms_errlog.sql.sql	0.5 KB
/28. What next it is time for PLSQL/
1. Move your skills to PLSQL.html	1.3 KB
2. Move your skills to Oracle Analytic Functions In-Depth & Advanced Oracle SQL.html	0.7 KB
/3. Connecting to the Database/
1. Connecting SYS using SQL plus & SQL Developer.mp4	33.2 MB
1. Connecting SYS using SQL plus & SQL Developer.vtt	10.6 KB
1.1 steps to unlock hr.sql.sql	0.3 KB
2. if you do not remember the sys password.html	0.1 KB
3. Unlock HR Account Part 1.mp4	16.8 MB
3. Unlock HR Account Part 1.vtt	4.2 KB
4. Unlock HR Account Part 2.mp4	40.3 MB
4. Unlock HR Account Part 2.vtt	10.0 KB
5. ORA-01033 oracle initialization or shutdown in progress 12c.mp4	21.6 MB
5. ORA-01033 oracle initialization or shutdown in progress 12c.vtt	3.4 KB
6. ORA-65054 Cannot open a pluggable database in the desired mode.html	0.6 KB
7. Creating new pluggable database contains HR user.html	0.2 KB
7.1 Creating new pluggable database contains HR user.pdf.pdf	1.0 MB
/4. Retrieving data using the select statement/
1. Navigate HR schema.mp4	31.1 MB
1. Navigate HR schema.vtt	6.6 KB
1.1 Capabilities of SQL select statement .pdf.pdf	171.5 KB
1.2 Retrieving data using the select statement.sql.sql	2.3 KB
2. Capabilities of SQL SELECT Statements.mp4	22.3 MB
2. Capabilities of SQL SELECT Statements.vtt	7.1 KB
3. Arithmetic expressions and NULL values.mp4	17.1 MB
3. Arithmetic expressions and NULL values.vtt	5.3 KB
4. Column Alias, Concatenation , Distinct and DESCRIBE.mp4	31.4 MB
4. Column Alias, Concatenation , Distinct and DESCRIBE.vtt	11.8 KB
5. Important Notes in Select Statement.mp4	25.0 MB
5. Important Notes in Select Statement.vtt	5.0 KB
/5. Restricting and Sorting Data/
1. The WHERE Clause & Comparison Operators.mp4	41.7 MB
1. The WHERE Clause & Comparison Operators.vtt	13.5 KB
1.1 Restricting and Sorting Data.sql.sql	8.2 KB
1.2 chapter 5 hints .pdf.pdf	204.2 KB
2. Using Between and IN Like Operators.mp4	29.7 MB
2. Using Between and IN Like Operators.vtt	10.9 KB
3. Using IS NULL NOT Not equal Operators.mp4	12.5 MB
3. Using IS NULL NOT Not equal Operators.vtt	4.6 KB
4. Logical Operators (AND OR NOT).mp4	26.8 MB
4. Logical Operators (AND OR NOT).vtt	8.3 KB
5. Order by Clause.mp4	29.4 MB
5. Order by Clause.vtt	8.0 KB
6. The FETCH Clause.mp4	29.1 MB
6. The FETCH Clause.vtt	7.8 KB
/6. Substitution Variables/
1. What is a Substitution Variables (&).mp4	25.6 MB
1. What is a Substitution Variables (&).vtt	7.5 KB
1.1 Substitution Variables.sql.sql	3.0 KB
2. DEFINE UNDEFINE.mp4	14.0 MB
2. DEFINE UNDEFINE.vtt	5.1 KB
2.1 Substitution Variables.sql.sql	3.0 KB
3. ACCEPT PROMPT.mp4	17.8 MB
3. ACCEPT PROMPT.vtt	4.3 KB
4. Double-Ampersand SET VERIFY SET DEFINE.mp4	14.2 MB
4. Double-Ampersand SET VERIFY SET DEFINE.vtt	7.1 KB
/7. Using Single-Row Functions to Customize Output/
1. Single Row Function Introduction.mp4	17.3 MB
1. Single Row Function Introduction.vtt	4.9 KB
1.1 7.1-character functions.sql.sql	3.3 KB
1.2 chapter 7 hints.pdf.pdf	748.0 KB
1.3 7.3-date functions.sql.sql	3.5 KB
1.4 7.2-number functions.sql.sql	1.3 KB
10. Nesting Functions.mp4	15.8 MB
10. Nesting Functions.vtt	4.7 KB
2. Character functions (Upper, Lower, Initcap ).mp4	14.4 MB
2. Character functions (Upper, Lower, Initcap ).vtt	3.8 KB
3. Character functions (concat, substr, length ).mp4	18.8 MB
3. Character functions (concat, substr, length ).vtt	6.9 KB
4. Character functions ( instr ).mp4	12.0 MB
4. Character functions ( instr ).vtt	4.6 KB
5. Character functions ( lpad, rpad , replace, trim).mp4	26.6 MB
5. Character functions ( lpad, rpad , replace, trim).vtt	10.5 KB
6. Number functions ( Round, Trunc, MOD ).mp4	30.4 MB
6. Number functions ( Round, Trunc, MOD ).vtt	10.6 KB
7. Date Functions ( Sysdate).mp4	24.4 MB
7. Date Functions ( Sysdate).vtt	7.8 KB
8. Date Functions ( months_between, add_months, next_day, last_day).mp4	20.6 MB
8. Date Functions ( months_between, add_months, next_day, last_day).vtt	7.9 KB
9. Date Functions ( round , trunc ).mp4	20.8 MB
9. Date Functions ( round , trunc ).vtt	8.4 KB
/8. Using Conversion Functions and Conditional Expressions/
1. Implicit Data Conversion VS Explicit.mp4	17.5 MB
1. Implicit Data Conversion VS Explicit.vtt	6.6 KB
1.1 chapter 8 part 1.sql.sql	3.8 KB
1.2 chapter 8 hints.pdf.pdf	592.2 KB
1.3 chapter 8 part 2.sql.sql	3.9 KB
2. TO_CHAR with dates.mp4	22.5 MB
2. TO_CHAR with dates.vtt	8.8 KB
3. TO_CHAR with numbers.mp4	30.3 MB
3. TO_CHAR with numbers.vtt	14.0 KB
4. TO_NUMBER , TO_DATE Functions.mp4	20.0 MB
4. TO_NUMBER , TO_DATE Functions.vtt	8.0 KB
5. nvl , nvl2 , nullif and coalesce Functions.mp4	29.4 MB
5. nvl , nvl2 , nullif and coalesce Functions.vtt	11.7 KB
6. The CASE Function.mp4	31.6 MB
6. The CASE Function.vtt	10.8 KB
7. The DECODE Function.mp4	21.3 MB
7. The DECODE Function.vtt	6.3 KB
/9. Reporting Aggregated Data Using the Group Functions/
1. Group functions Introduction.mp4	16.4 MB
1. Group functions Introduction.vtt	6.5 KB
1.1 chapter 9.sql.sql	4.0 KB
1.2 chapter 9 hints.pdf.pdf	579.2 KB
2. Group functions (sum, count, max, min, avg & more).mp4	18.8 MB
2. Group functions (sum, count, max, min, avg & more).vtt	9.3 KB
3. Group by Clause, Having Clause.mp4	31.6 MB
3. Group by Clause, Having Clause.vtt	11.0 KB
/
[FreeCourseLab.com].url	0.1 KB
Total files 415