zhongziso种子搜
首页
功能
磁力转BT
BT转磁力
使用教程
免责声明
关于
zhongziso
搜索
[Udemy] The Complete Oracle SQL Bootcamp (2021) [En]
magnet:?xt=urn:btih:837177275ad9e2e78fe6c2366221fcf42ab5b918&dn=[Udemy] The Complete Oracle SQL Bootcamp (2021) [En]
磁力链接详情
Hash值:
837177275ad9e2e78fe6c2366221fcf42ab5b918
点击数:
62
文件大小:
10.53 GB
文件数量:
138
创建日期:
2023-10-13 16:24
最后访问:
2024-5-17 10:53
访问标签:
Udemy
The
Complete
Oracle
SQL
Bootcamp
2021
En
文件列表详情
7. Single-Row Functions/9. Date Values & Date Formats in Oracle.mp4 231.13 MB
1. Database Concepts/2. Why Oracle Database.mp4 61.75 MB
1. Database Concepts/3. What is a Table.mp4 38.29 MB
1. Database Concepts/4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).mp4 50.62 MB
1. Database Concepts/6. What is a Relational Database (RDBMS).mp4 89.59 MB
1. Database Concepts/7. Entity Relationship Logic in Databases.mp4 37.09 MB
1. Database Concepts/8. What is Pluggable Database.mp4 25.11 MB
1. Database Concepts/9. Introduction to Database Objects.mp4 126.97 MB
1. Database Concepts/10. The Sample (HR) Schema Used in This Course.mp4 76.08 MB
1. Database Concepts/11. What is SQL.mp4 45.32 MB
2. Software Download & Installation/1. About the Database Installation.mp4 50.14 MB
2. Software Download & Installation/2. Which Option to Choose to Have a Database.mp4 86.46 MB
2. Software Download & Installation/3. Option 1 Having the Database with the Oracle Virtual Box.mp4 57.84 MB
2. Software Download & Installation/5. Option 2 Downloading And Installing Oracle Database.mp4 191.61 MB
2. Software Download & Installation/6. Option 2 Unlocking the HR Schema.mp4 38.26 MB
2. Software Download & Installation/7. Option 2 Configuring and Using the SQL Developer.mp4 144.42 MB
2. Software Download & Installation/8. Option 3 Using Oracle Live SQL.mp4 42.8 MB
2. Software Download & Installation/10. SQL Statements Used in This Course.mp4 43.26 MB
3. Retrieving Data/1. Oracle Data Types.mp4 60.94 MB
3. Retrieving Data/2. What is a NULL Value.mp4 59.65 MB
3. Retrieving Data/3. DESCRIBE Command.mp4 29.28 MB
3. Retrieving Data/4. INFORMATION Command.mp4 48.7 MB
3. Retrieving Data/5. SQL Statement Basics.mp4 101.38 MB
3. Retrieving Data/6. Oracle Error Messages.mp4 40.07 MB
3. Retrieving Data/7. Using SELECT Statements.mp4 43.89 MB
3. Retrieving Data/9. Using Column Aliases.mp4 50.37 MB
3. Retrieving Data/11. Quote (Q) Operator.mp4 49.04 MB
3. Retrieving Data/12. DISTINCT and UNIQUE Operator.mp4 52.78 MB
3. Retrieving Data/13. Concatenation Operators.mp4 63.21 MB
3. Retrieving Data/14. Arithmetic Expressions and NULL Values.mp4 77.74 MB
4. Restricting Data/1. Using WHERE Clause.mp4 37.59 MB
4. Restricting Data/2. Comparison Operators.mp4 58.2 MB
4. Restricting Data/3. BETWEEN … AND Operator.mp4 50.36 MB
4. Restricting Data/4. IN Operator.mp4 75.69 MB
4. Restricting Data/5. LIKE Operator.mp4 110.62 MB
4. Restricting Data/6. IS NULL Operator.mp4 46.94 MB
4. Restricting Data/7. Logical Operators (AND, OR, NOT).mp4 116.74 MB
4. Restricting Data/8. Rules of Precedence.mp4 62.86 MB
5. Sorting Data/1. ORDER BY Clause.mp4 140.05 MB
5. Sorting Data/2. ASC and DESC Operators.mp4 68.71 MB
5. Sorting Data/3. NULLS FIRST and NULLS LAST Operators.mp4 34.15 MB
5. Sorting Data/4. ROWNUM & ROWID in SQL.mp4 99.72 MB
5. Sorting Data/5. Oracle FETCH Clause.mp4 80.04 MB
6. Using Substitution Variables/1. What is a Substitution Variable.mp4 105.32 MB
6. Using Substitution Variables/2. Double Ampersand (&&) and DEFINE & UNDEFINE Commands.mp4 125.45 MB
6. Using Substitution Variables/3. ACCEPT and PROMPT Commands.mp4 57.67 MB
6. Using Substitution Variables/4. SET VERIFY ON SET VERIFY OFF Commands.mp4 51.89 MB
7. Single-Row Functions/1. Single Row Functions.mp4 110.94 MB
7. Single-Row Functions/2. Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios.mp4 117.9 MB
7. Single-Row Functions/3. Character Functions - Character Manipulation Functios (Part 1).mp4 111.99 MB
7. Single-Row Functions/4. Character Functions - Character Manipulation Functions Part 2 (INSTR Function).mp4 69.43 MB
7. Single-Row Functions/5. Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions).mp4 107.7 MB
7. Single-Row Functions/6. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions).mp4 82.76 MB
7. Single-Row Functions/7. Numeric Functions.mp4 115.12 MB
7. Single-Row Functions/8. Nested Functions.mp4 101.38 MB
1. Database Concepts/1. What is a Database.mp4 68.7 MB
7. Single-Row Functions/10. Date Functions & Arithmetic Operations on Dates.mp4 135.3 MB
7. Single-Row Functions/11. Date Manipulation Functions in SQL.mp4 147.3 MB
8. Conversion Functions/1. Conversion Functions.mp4 90.06 MB
8. Conversion Functions/2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1).mp4 132.29 MB
8. Conversion Functions/3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).mp4 120.37 MB
8. Conversion Functions/4. Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions.mp4 142.26 MB
9. Conditional Expressions/1. Oracle Conditional Expressions CASE Expressions.mp4 172.69 MB
9. Conditional Expressions/2. Oracle Conditional Expressions DECODE Function.mp4 63.2 MB
10. Group Functions/1. Group Functions.mp4 56.33 MB
10. Group Functions/2. AVG Function.mp4 59 MB
10. Group Functions/3. COUNT Function.mp4 36.41 MB
10. Group Functions/4. MAX Function.mp4 33.32 MB
10. Group Functions/5. MIN Function.mp4 28.4 MB
10. Group Functions/6. SUM Function.mp4 24.32 MB
10. Group Functions/7. LISTAGG Function.mp4 65.64 MB
10. Group Functions/8. Overview Of Group Functions.mp4 25.49 MB
11. Grouping Data/1. GROUP BY Clause (Part 1).mp4 102.23 MB
11. Grouping Data/2. GROUP BY Clause (Part 2).mp4 95.68 MB
11. Grouping Data/3. HAVING Clause.mp4 61.89 MB
11. Grouping Data/4. Nested Group Functions.mp4 30.21 MB
12. Joining Multiple Tables/1. What is a Join & Oracle SQL Join Types.mp4 63.07 MB
12. Joining Multiple Tables/2. Creating a Join.mp4 29.84 MB
12. Joining Multiple Tables/3. Natural Join.mp4 91.99 MB
12. Joining Multiple Tables/4. Join with the USING Clause.mp4 49.1 MB
12. Joining Multiple Tables/5. Handling Ambiguous Column Names.mp4 81.12 MB
12. Joining Multiple Tables/6. Inner Join & Join with the ON Clause.mp4 54.26 MB
12. Joining Multiple Tables/7. Multiple Join Operations.mp4 116.95 MB
12. Joining Multiple Tables/8. Restricting Joins.mp4 28.97 MB
12. Joining Multiple Tables/9. Self Join.mp4 61.91 MB
12. Joining Multiple Tables/10. Non-Equijoins (Joining Unequal Tables).mp4 115.53 MB
12. Joining Multiple Tables/11. OUTER JOINS.mp4 67.52 MB
12. Joining Multiple Tables/12. LEFT OUTER JOIN (LEFT JOIN).mp4 113.58 MB
12. Joining Multiple Tables/13. RIGHT OUTER JOIN (RIGHT JOIN).mp4 91.02 MB
12. Joining Multiple Tables/14. FULL OUTER JOIN (FULL JOIN).mp4 35.8 MB
12. Joining Multiple Tables/15. Cross Join (Cartesian Product Cross Product).mp4 157.37 MB
12. Joining Multiple Tables/16. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1).mp4 121.37 MB
12. Joining Multiple Tables/17. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2).mp4 161.01 MB
12. Joining Multiple Tables/18. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3).mp4 86.47 MB
12. Joining Multiple Tables/19. The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins.mp4 135.87 MB
12. Joining Multiple Tables/20. Which Join Type Should You Use.mp4 26.43 MB
12. Joining Multiple Tables/21. Entity-Relationship Models in DBMS - How to Use Them with Joins.mp4 133.09 MB
13. Using Subqueries/1. Using Subqueries.mp4 55.42 MB
13. Using Subqueries/2. Single Row Subqueries.mp4 132.23 MB
13. Using Subqueries/3. Multiple Row Subqueries.mp4 121.97 MB
13. Using Subqueries/4. Multiple Column Subqueries.mp4 128.02 MB
13. Using Subqueries/5. Using Subqueries as a Table.mp4 63.63 MB
13. Using Subqueries/6. SCALAR Subqueries.mp4 114.75 MB
13. Using Subqueries/7. Correlated Subqueries.mp4 134.92 MB
13. Using Subqueries/8. EXISTS Operator & Semijoins.mp4 88.21 MB
13. Using Subqueries/9. NOT EXISTS Operator.mp4 49.24 MB
14. Working with the Oracle SET Operators/2. Introduction to SET Operators in Oracle SQL.mp4 121.88 MB
14. Working with the Oracle SET Operators/3. UNION and UNION ALL Operators.mp4 123.73 MB
14. Working with the Oracle SET Operators/4. INTERSECT Operator.mp4 19.36 MB
14. Working with the Oracle SET Operators/5. MINUS Operator.mp4 30.11 MB
14. Working with the Oracle SET Operators/6. Matching Unmatched Queries in SET Operations.mp4 29.93 MB
14. Working with the Oracle SET Operators/7. Using the ORDER BY Clause with SET Operators.mp4 61.27 MB
15. Data Manipulation Language (DML) Statements/1. Data Manipulation Language (DML).mp4 25.35 MB
15. Data Manipulation Language (DML) Statements/2. INSERT Statement (Part 1).mp4 38.24 MB
15. Data Manipulation Language (DML) Statements/3. INSERT Statement (Part 2).mp4 124.87 MB
15. Data Manipulation Language (DML) Statements/4. UPDATE Statement.mp4 110.06 MB
15. Data Manipulation Language (DML) Statements/5. DELETE Statement.mp4 66.41 MB
15. Data Manipulation Language (DML) Statements/6. Transaction Control Statements.mp4 45.26 MB
15. Data Manipulation Language (DML) Statements/7. COMMIT and ROLLBACK Statements.mp4 89.23 MB
15. Data Manipulation Language (DML) Statements/8. SAVEPOINT Statement.mp4 30.19 MB
15. Data Manipulation Language (DML) Statements/9. FOR UPDATE Statement.mp4 84.82 MB
16. Data Definition Language (DDL) Statements/1. Data Definition Language (DDL).mp4 21.04 MB
16. Data Definition Language (DDL) Statements/2. Naming Rules.mp4 22.99 MB
16. Data Definition Language (DDL) Statements/3. CREATE TABLE Statement.mp4 160.74 MB
16. Data Definition Language (DDL) Statements/4. ALTER TABLE Statement.mp4 192.79 MB
16. Data Definition Language (DDL) Statements/5. DROP TABLE Statement.mp4 36.21 MB
16. Data Definition Language (DDL) Statements/6. TRUNCATE TABLE Statement.mp4 44.89 MB
16. Data Definition Language (DDL) Statements/7. COMMENT Statement.mp4 67.98 MB
16. Data Definition Language (DDL) Statements/8. RENAME Statement.mp4 52.32 MB
17. Creating Constraints/1. Creating Constraints.mp4 41.29 MB
17. Creating Constraints/2. NOT NULL Constraint.mp4 54.63 MB
17. Creating Constraints/3. UNIQUE Constraint.mp4 104.63 MB
17. Creating Constraints/4. PRIMARY KEY Constraint.mp4 63.47 MB
17. Creating Constraints/5. FOREIGN KEY Constraint.mp4 174.05 MB
17. Creating Constraints/6. CHECK Constraint.mp4 37.79 MB
18. Conclusion + Bonus/1. Conclusion.mp4 4.96 MB
19. Appendix/1. Appendix 1 Oracle Database 12c Installation into Your Computer.mp4 18.85 MB
19. Appendix/3. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp4 26.92 MB
其他位置