zhongziso
搜索
zhongziso
首页
首页
功能
磁力转BT
BT转磁力
关于
使用教程
免责声明
磁力助手
[FreeCourseLab.com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071
magnet:?xt=urn:btih:9624b897b49537a52e3b9fd016f0779a63b7dd0e&dn=[FreeCourseLab.com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071
磁力链接详情
文件列表详情
9624b897b49537a52e3b9fd016f0779a63b7dd0e
infohash:
167
文件数量
3.37 GB
文件大小
2022-5-11 02:20
创建日期
2024-12-3 20:18
最后访问
相关分词
FreeCourseLab
com
Udemy
-
Oracle
Database
12c
SQL
Certified
Associate
1Z0-071
1. Introduction/1. Course Agenda.mp4 21.1 MB
1. Introduction/2. System Development Life Cycle & Database Definition.mp4 14.71 MB
1. Introduction/3. What is a Table.mp4 6.66 MB
1. Introduction/4. Data Models & ERM.mp4 18.54 MB
1. Introduction/5. About Primary key & foreign key.mp4 14.51 MB
1. Introduction/6. SQL and Types of SQL Statements.mp4 13.44 MB
1. Introduction/7. Oracle Database 12c Architecture.mp4 15.28 MB
1. Introduction/8. HR Schema in this Course.mp4 21.27 MB
10. Displaying Data from multiple tables using joins/1. Before You Start, important notes.mp4 38.56 MB
10. Displaying Data from multiple tables using joins/10. 1999 Syntax USING Clause.mp4 12.68 MB
10. Displaying Data from multiple tables using joins/11. 1999 Syntax ON Clause.mp4 20.28 MB
10. Displaying Data from multiple tables using joins/12. 1999 Syntax LeftRightfull Outer Join.mp4 22.52 MB
10. Displaying Data from multiple tables using joins/2. HR Tables Diagram, Joins Clarification.mp4 12.67 MB
10. Displaying Data from multiple tables using joins/3. What is Cartesian product.mp4 18.22 MB
10. Displaying Data from multiple tables using joins/4. Old Joins Equijoin.mp4 20.44 MB
10. Displaying Data from multiple tables using joins/5. Old Joins nonEquijoins.mp4 24.47 MB
10. Displaying Data from multiple tables using joins/6. Old Joins outer join.mp4 20.86 MB
10. Displaying Data from multiple tables using joins/7. Old Joins Self Join and More Practices.mp4 20 MB
10. Displaying Data from multiple tables using joins/8. 1999 Syntax Cross Join (Cartesian product ).mp4 14.6 MB
10. Displaying Data from multiple tables using joins/9. 1999 Syntax Natural Join.mp4 26.24 MB
11. Using Subqueries to Solve Queries/1. Single row Subqueries.mp4 21.26 MB
11. Using Subqueries to Solve Queries/2. Multiple rows Subqueries.mp4 17.57 MB
11. Using Subqueries to Solve Queries/3. NULL values and Subqueries.mp4 15.92 MB
11. Using Subqueries to Solve Queries/4. Exists and not Exists.mp4 13.41 MB
12. Using the Set Operators/1. Overview (Union, union all, intersect, minus ).mp4 11.69 MB
12. Using the Set Operators/2. Practice (Union, union all, intersect, minus ).mp4 26.83 MB
13. Managing tables using DML Statments/1. Introduction to DML.mp4 10.94 MB
13. Managing tables using DML Statments/10. ROW Lock.mp4 10.56 MB
13. Managing tables using DML Statments/11. FOR UPDATE Clause.mp4 19.4 MB
13. Managing tables using DML Statments/2. Insert Statement.mp4 33.2 MB
13. Managing tables using DML Statments/3. Inserting common errors.mp4 14.59 MB
13. Managing tables using DML Statments/4. Update Statement.mp4 33.62 MB
13. Managing tables using DML Statments/5. Delete Statement.mp4 33.22 MB
13. Managing tables using DML Statments/6. What is Database Transactions.mp4 16.78 MB
13. Managing tables using DML Statments/7. About Commit & Rollback.mp4 18.8 MB
13. Managing tables using DML Statments/8. Practice ( Commit and rollback ).mp4 25.98 MB
13. Managing tables using DML Statments/9. SAVEPOINT.mp4 12.05 MB
14. Introduction to Data Definition Language/1. DDL & Naming Rules.mp4 20.69 MB
14. Introduction to Data Definition Language/10. Create Table AS subquery.mp4 18.63 MB
14. Introduction to Data Definition Language/11. Alter Table Add Columns.mp4 22.43 MB
14. Introduction to Data Definition Language/12. Alter Table Modify Columns.mp4 19.3 MB
14. Introduction to Data Definition Language/13. Alter Table Drop Columns.mp4 18.17 MB
14. Introduction to Data Definition Language/14. Alter Table Set Unused.mp4 17.76 MB
14. Introduction to Data Definition Language/15. ALTER TABLE READ ONLY READ write.mp4 17.06 MB
14. Introduction to Data Definition Language/16. Drop Table.mp4 15.68 MB
14. Introduction to Data Definition Language/17. Rename Column Rename Table.mp4 9.24 MB
14. Introduction to Data Definition Language/2. Data Types Part 1.mp4 16.12 MB
14. Introduction to Data Definition Language/3. Data Types Part 2.mp4 13.39 MB
14. Introduction to Data Definition Language/4. Creating Tables (without constraints).mp4 21.97 MB
14. Introduction to Data Definition Language/5. Types of constraints and why we use it.mp4 16.3 MB
14. Introduction to Data Definition Language/6. Creating Tables ( Column Level Constraints ).mp4 32.22 MB
14. Introduction to Data Definition Language/7. Creating Tables ( Table Level Constraints ).mp4 14.68 MB
14. Introduction to Data Definition Language/8. Constraints Guidelines.mp4 17.75 MB
14. Introduction to Data Definition Language/9. ON DELETE cascade ON DELETE set null.mp4 18.48 MB
15. Tips you Should know/1. Tips you Should know Part 1.mp4 16.28 MB
15. Tips you Should know/2. Tips you Should know Part 2.mp4 5.38 MB
15. Tips you Should know/3. Tips you Should know Part 3.mp4 14.76 MB
15. Tips you Should know/4. Tips you Should know Part 4.mp4 11.94 MB
15. Tips you Should know/5. Tips you Should know Part 5.mp4 11.54 MB
15. Tips you Should know/6. Tips you Should know Part 6.mp4 15.67 MB
16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/1. About Exam 1Z0-061 Visiting Oracle Website.mp4 22.08 MB
16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/2. My recommendations.mp4 15.24 MB
17. Introduction to Data Dictionary Views/1. What is Data Dictionary Views.mp4 16.32 MB
17. Introduction to Data Dictionary Views/2. What is DICTIONARY.mp4 10.49 MB
17. Introduction to Data Dictionary Views/3. USER_OBJECTS ALL_OBJECTS.mp4 18.28 MB
17. Introduction to Data Dictionary Views/4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.mp4 19.31 MB
17. Introduction to Data Dictionary Views/5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.mp4 14.81 MB
17. Introduction to Data Dictionary Views/6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.mp4 38.3 MB
17. Introduction to Data Dictionary Views/7. COMMENT ON TABLE COLUMN.mp4 14.88 MB
18. Creating sequences, synonyms, and indexes/1. Sequences Part 1.mp4 17.63 MB
18. Creating sequences, synonyms, and indexes/2. Sequences Part 2.mp4 16.79 MB
18. Creating sequences, synonyms, and indexes/3. Sequences Part 3.mp4 18.28 MB
18. Creating sequences, synonyms, and indexes/4. Sequences Part 4.mp4 33.07 MB
18. Creating sequences, synonyms, and indexes/5. Creating Synonyms.mp4 17.81 MB
18. Creating sequences, synonyms, and indexes/6. Creating Indexes Part 1.mp4 41.88 MB
18. Creating sequences, synonyms, and indexes/7. Creating Indexes Part 2.mp4 25.67 MB
19. Creating Views/1. What is a View What is the benefits of Views.mp4 13.17 MB
19. Creating Views/2. Creating Simple Views.mp4 19.24 MB
19. Creating Views/3. Creating Complex Views.mp4 21.79 MB
19. Creating Views/4. With READ ONLY With check option Force view.mp4 20.54 MB
2. Live SQL & Download Install/1. Oracle Live SQL No Installation for anything.mp4 35.91 MB
2. Live SQL & Download Install/3. Downloading Oracle DB 12c.mp4 17.77 MB
2. Live SQL & Download Install/4. Installing Oracle DB 12c.mp4 25.61 MB
20. Managing Schema Objects/1. Adding constraints dropping constraints.mp4 36.49 MB
20. Managing Schema Objects/2. Rename Column Rename Constraint.mp4 8.36 MB
20. Managing Schema Objects/3. Enable Disable Constraints.mp4 21.47 MB
20. Managing Schema Objects/4. Understanding DEFERRABLE Constraints.mp4 19.87 MB
20. Managing Schema Objects/5. DEFERRABLE Constraints Exercises.mp4 21.91 MB
20. Managing Schema Objects/6. GLOBAL TEMPORARY TABLE.mp4 14.21 MB
20. Managing Schema Objects/7. About SQLLoader.mp4 34.86 MB
20. Managing Schema Objects/8. External Tables Part 1.mp4 21.8 MB
20. Managing Schema Objects/9. External Tables Part 2.mp4 17.09 MB
21. Retrieving Data By Using Subqueries/1. Using the subquery as a source table.mp4 23.48 MB
21. Retrieving Data By Using Subqueries/2. Pairwise Non Pairwise Subqueries.mp4 17.67 MB
21. Retrieving Data By Using Subqueries/3. Scalar Subquery Correlated Subquery.mp4 22.75 MB
21. Retrieving Data By Using Subqueries/4. Reminder of Exists Not Exists.mp4 22.15 MB
21. Retrieving Data By Using Subqueries/5. WITH Clause.mp4 32.95 MB
22. Manipulating Data By Using Subqueries/1. Inserting Updating Deleting Using a subquery as a target.mp4 20.32 MB
22. Manipulating Data By Using Subqueries/2. Correlated Update Correlated Delete.mp4 25.73 MB
23. Controlling User Access/1. Database Security System Privileges & Roles.mp4 24.26 MB
23. Controlling User Access/2. Database Security Object Privileges.mp4 22.36 MB
23. Controlling User Access/3. System Privileges & Privileges Practice 1.mp4 23.09 MB
23. Controlling User Access/4. System Privileges & Privileges Practice 2.mp4 25.75 MB
23. Controlling User Access/5. Creating ROLE Practice.mp4 30.46 MB
23. Controlling User Access/6. With Grant Option.mp4 18.04 MB
23. Controlling User Access/7. Drop user Statement.mp4 13.91 MB
24. Manipulating Data/1. What is Data Warehouse.mp4 9.2 MB
24. Manipulating Data/2. Explicit default value in insert & update statement.mp4 10.73 MB
24. Manipulating Data/3. Copy rows from another table.mp4 8.61 MB
24. Manipulating Data/4. INSERT ALL statement INSERT FIRST.mp4 28.28 MB
24. Manipulating Data/5. Another INSERT ALL Example & Notes.mp4 18.83 MB
24. Manipulating Data/6. Creating Matrix Report Using PIVOT.mp4 17.06 MB
24. Manipulating Data/7. The Merge Statement.mp4 12.19 MB
24. Manipulating Data/8. FLASHBACK Table & System change Number ( SCN).mp4 27.82 MB
25. Managing Data in Different Time Zones/1. THE INTERVAL ( YEAR TO MONTH day TO second).mp4 18.61 MB
25. Managing Data in Different Time Zones/2. to_yminterval to_dsinterval.mp4 9.31 MB
25. Managing Data in Different Time Zones/3. Extract function.mp4 4.93 MB
25. Managing Data in Different Time Zones/4. timestamp timestamp with time zone.mp4 10.88 MB
25. Managing Data in Different Time Zones/5. V$TIMEZONE_NAMES and some functions.mp4 19.07 MB
25. Managing Data in Different Time Zones/6. timestamp with local time zone.mp4 11.81 MB
25. Managing Data in Different Time Zones/7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.mp4 12.22 MB
26. Exam 1Z0-071 for SQL Certified Associate/1. About the Exam 1Z0-071.mp4 18.44 MB
26. Exam 1Z0-071 for SQL Certified Associate/2. Some helpful websites contains exams Dumps.mp4 29.86 MB
27. Bonus Section/1. Using SELECT statement to create dynamic scripts.mp4 18.78 MB
27. Bonus Section/2. Installing oracle 11g express edition.mp4 36.9 MB
27. Bonus Section/3. Rownum and rowid.mp4 16.32 MB
27. Bonus Section/4. About PLSQL.mp4 31.45 MB
27. Bonus Section/7. DML logs using package dbms_errlog.mp4 90.21 MB
3. Connecting to the Database/1. Connecting SYS using SQL plus & SQL Developer.mp4 31.64 MB
3. Connecting to the Database/3. Unlock HR Account Part 1.mp4 16.04 MB
3. Connecting to the Database/4. Unlock HR Account Part 2.mp4 38.43 MB
3. Connecting to the Database/5. ORA-01033 oracle initialization or shutdown in progress 12c.mp4 20.6 MB
4. Retrieving data using the select statement/1. Navigate HR schema.mp4 29.63 MB
4. Retrieving data using the select statement/2. Capabilities of SQL SELECT Statements.mp4 21.28 MB
4. Retrieving data using the select statement/3. Arithmetic expressions and NULL values.mp4 16.27 MB
4. Retrieving data using the select statement/4. Column Alias, Concatenation , Distinct and DESCRIBE.mp4 29.94 MB
4. Retrieving data using the select statement/5. Important Notes in Select Statement.mp4 23.84 MB
5. Restricting and Sorting Data/1. The WHERE Clause & Comparison Operators.mp4 39.73 MB
5. Restricting and Sorting Data/2. Using Between and IN Like Operators.mp4 28.33 MB
5. Restricting and Sorting Data/3. Using IS NULL NOT Not equal Operators.mp4 11.94 MB
5. Restricting and Sorting Data/4. Logical Operators (AND OR NOT).mp4 25.57 MB
5. Restricting and Sorting Data/5. Order by Clause.mp4 28.05 MB
5. Restricting and Sorting Data/6. The FETCH Clause.mp4 27.75 MB
6. Substitution Variables/1. What is a Substitution Variables (&).mp4 24.39 MB
6. Substitution Variables/2. DEFINE UNDEFINE.mp4 13.35 MB
6. Substitution Variables/3. ACCEPT PROMPT.mp4 16.99 MB
6. Substitution Variables/4. Double-Ampersand SET VERIFY SET DEFINE.mp4 13.54 MB
7. Using Single-Row Functions to Customize Output/1. Single Row Function Introduction.mp4 16.45 MB
7. Using Single-Row Functions to Customize Output/10. Nesting Functions.mp4 15.04 MB
7. Using Single-Row Functions to Customize Output/2. Character functions (Upper, Lower, Initcap ).mp4 13.72 MB
7. Using Single-Row Functions to Customize Output/3. Character functions (concat, substr, length ).mp4 17.9 MB
7. Using Single-Row Functions to Customize Output/4. Character functions ( instr ).mp4 11.47 MB
7. Using Single-Row Functions to Customize Output/5. Character functions ( lpad, rpad , replace, trim).mp4 25.36 MB
7. Using Single-Row Functions to Customize Output/6. Number functions ( Round, Trunc, MOD ).mp4 28.98 MB
7. Using Single-Row Functions to Customize Output/7. Date Functions ( Sysdate).mp4 23.27 MB
7. Using Single-Row Functions to Customize Output/8. Date Functions ( months_between, add_months, next_day, last_day).mp4 19.61 MB
7. Using Single-Row Functions to Customize Output/9. Date Functions ( round , trunc ).mp4 19.8 MB
8. Using Conversion Functions and Conditional Expressions/1. Implicit Data Conversion VS Explicit.mp4 16.65 MB
8. Using Conversion Functions and Conditional Expressions/2. TO_CHAR with dates.mp4 21.41 MB
8. Using Conversion Functions and Conditional Expressions/3. TO_CHAR with numbers.mp4 28.88 MB
8. Using Conversion Functions and Conditional Expressions/4. TO_NUMBER , TO_DATE Functions.mp4 19.09 MB
8. Using Conversion Functions and Conditional Expressions/5. nvl , nvl2 , nullif and coalesce Functions.mp4 28.01 MB
8. Using Conversion Functions and Conditional Expressions/6. The CASE Function.mp4 30.1 MB
8. Using Conversion Functions and Conditional Expressions/7. The DECODE Function.mp4 20.28 MB
9. Reporting Aggregated Data Using the Group Functions/1. Group functions Introduction.mp4 15.61 MB
9. Reporting Aggregated Data Using the Group Functions/2. Group functions (sum, count, max, min, avg & more).mp4 17.88 MB
9. Reporting Aggregated Data Using the Group Functions/3. Group by Clause, Having Clause.mp4 30.15 MB
其他位置