种子简介

种子名称： [Udemy] The Complete Oracle SQL Bootcamp (2021) [En]
文件类型： 视频
文件数目： 138个文件
文件大小： 10.53 GB
收录时间： 2023-10-13 16:24
已经下载： 3次
资源热度： 64
最近下载： 2024-6-7 07:44

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:837177275ad9e2e78fe6c2366221fcf42ab5b918&dn=[Udemy] The Complete Oracle SQL Bootcamp (2021) [En] 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[Udemy] The Complete Oracle SQL Bootcamp (2021) [En].torrent

7. Single-Row Functions/9. Date Values & Date Formats in Oracle.mp4231.13MB

1. Database Concepts/2. Why Oracle Database.mp461.75MB

1. Database Concepts/3. What is a Table.mp438.29MB

1. Database Concepts/4. UDEMY 101 How to Use Udemy +Some Useful Tips (Do not Skip).mp450.62MB

1. Database Concepts/6. What is a Relational Database (RDBMS).mp489.59MB

1. Database Concepts/7. Entity Relationship Logic in Databases.mp437.09MB

1. Database Concepts/8. What is Pluggable Database.mp425.11MB

1. Database Concepts/9. Introduction to Database Objects.mp4126.97MB

1. Database Concepts/10. The Sample (HR) Schema Used in This Course.mp476.08MB

1. Database Concepts/11. What is SQL.mp445.32MB

2. Software Download & Installation/1. About the Database Installation.mp450.14MB

2. Software Download & Installation/2. Which Option to Choose to Have a Database.mp486.46MB

2. Software Download & Installation/3. Option 1 Having the Database with the Oracle Virtual Box.mp457.84MB

2. Software Download & Installation/5. Option 2 Downloading And Installing Oracle Database.mp4191.61MB

2. Software Download & Installation/6. Option 2 Unlocking the HR Schema.mp438.26MB

2. Software Download & Installation/7. Option 2 Configuring and Using the SQL Developer.mp4144.42MB

2. Software Download & Installation/8. Option 3 Using Oracle Live SQL.mp442.8MB

2. Software Download & Installation/10. SQL Statements Used in This Course.mp443.26MB

3. Retrieving Data/1. Oracle Data Types.mp460.94MB

3. Retrieving Data/2. What is a NULL Value.mp459.65MB

3. Retrieving Data/3. DESCRIBE Command.mp429.28MB

3. Retrieving Data/4. INFORMATION Command.mp448.7MB

3. Retrieving Data/5. SQL Statement Basics.mp4101.38MB

3. Retrieving Data/6. Oracle Error Messages.mp440.07MB

3. Retrieving Data/7. Using SELECT Statements.mp443.89MB

3. Retrieving Data/9. Using Column Aliases.mp450.37MB

3. Retrieving Data/11. Quote (Q) Operator.mp449.04MB

3. Retrieving Data/12. DISTINCT and UNIQUE Operator.mp452.78MB

3. Retrieving Data/13. Concatenation Operators.mp463.21MB

3. Retrieving Data/14. Arithmetic Expressions and NULL Values.mp477.74MB

4. Restricting Data/1. Using WHERE Clause.mp437.59MB

4. Restricting Data/2. Comparison Operators.mp458.2MB

4. Restricting Data/3. BETWEEN … AND Operator.mp450.36MB

4. Restricting Data/4. IN Operator.mp475.69MB

4. Restricting Data/5. LIKE Operator.mp4110.62MB

4. Restricting Data/6. IS NULL Operator.mp446.94MB

4. Restricting Data/7. Logical Operators (AND, OR, NOT).mp4116.74MB

4. Restricting Data/8. Rules of Precedence.mp462.86MB

5. Sorting Data/1. ORDER BY Clause.mp4140.05MB

5. Sorting Data/2. ASC and DESC Operators.mp468.71MB

5. Sorting Data/3. NULLS FIRST and NULLS LAST Operators.mp434.15MB

5. Sorting Data/4. ROWNUM & ROWID in SQL.mp499.72MB

5. Sorting Data/5. Oracle FETCH Clause.mp480.04MB

6. Using Substitution Variables/1. What is a Substitution Variable.mp4105.32MB

6. Using Substitution Variables/2. Double Ampersand (&&) and DEFINE & UNDEFINE Commands.mp4125.45MB

6. Using Substitution Variables/3. ACCEPT and PROMPT Commands.mp457.67MB

6. Using Substitution Variables/4. SET VERIFY ON SET VERIFY OFF Commands.mp451.89MB

7. Single-Row Functions/1. Single Row Functions.mp4110.94MB

7. Single-Row Functions/2. Character Functions - Case Conversion (LOWER, UPPER, INITCAP) Functios.mp4117.9MB

7. Single-Row Functions/3. Character Functions - Character Manipulation Functios (Part 1).mp4111.99MB

7. Single-Row Functions/4. Character Functions - Character Manipulation Functions Part 2 (INSTR Function).mp469.43MB

7. Single-Row Functions/5. Character Functions - Part 3 (TRIM, LTRIM, RTRIM Functions).mp4107.7MB

7. Single-Row Functions/6. Character Functions - Part 4 (REPLACE, LPAD, RPAD Functions).mp482.76MB

7. Single-Row Functions/7. Numeric Functions.mp4115.12MB

7. Single-Row Functions/8. Nested Functions.mp4101.38MB

1. Database Concepts/1. What is a Database.mp468.7MB

7. Single-Row Functions/10. Date Functions & Arithmetic Operations on Dates.mp4135.3MB

7. Single-Row Functions/11. Date Manipulation Functions in SQL.mp4147.3MB

8. Conversion Functions/1. Conversion Functions.mp490.06MB

8. Conversion Functions/2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1).mp4132.29MB

8. Conversion Functions/3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).mp4120.37MB

8. Conversion Functions/4. Null-Related (NVL, NVL2, NULLIF, COALESCE) Functions.mp4142.26MB

9. Conditional Expressions/1. Oracle Conditional Expressions CASE Expressions.mp4172.69MB

9. Conditional Expressions/2. Oracle Conditional Expressions DECODE Function.mp463.2MB

10. Group Functions/1. Group Functions.mp456.33MB

10. Group Functions/2. AVG Function.mp459MB

10. Group Functions/3. COUNT Function.mp436.41MB

10. Group Functions/4. MAX Function.mp433.32MB

10. Group Functions/5. MIN Function.mp428.4MB

10. Group Functions/6. SUM Function.mp424.32MB

10. Group Functions/7. LISTAGG Function.mp465.64MB

10. Group Functions/8. Overview Of Group Functions.mp425.49MB

11. Grouping Data/1. GROUP BY Clause (Part 1).mp4102.23MB

11. Grouping Data/2. GROUP BY Clause (Part 2).mp495.68MB

11. Grouping Data/3. HAVING Clause.mp461.89MB

11. Grouping Data/4. Nested Group Functions.mp430.21MB

12. Joining Multiple Tables/1. What is a Join & Oracle SQL Join Types.mp463.07MB

12. Joining Multiple Tables/2. Creating a Join.mp429.84MB

12. Joining Multiple Tables/3. Natural Join.mp491.99MB

12. Joining Multiple Tables/4. Join with the USING Clause.mp449.1MB

12. Joining Multiple Tables/5. Handling Ambiguous Column Names.mp481.12MB

12. Joining Multiple Tables/6. Inner Join & Join with the ON Clause.mp454.26MB

12. Joining Multiple Tables/7. Multiple Join Operations.mp4116.95MB

12. Joining Multiple Tables/8. Restricting Joins.mp428.97MB

12. Joining Multiple Tables/9. Self Join.mp461.91MB

12. Joining Multiple Tables/10. Non-Equijoins (Joining Unequal Tables).mp4115.53MB

12. Joining Multiple Tables/11. OUTER JOINS.mp467.52MB

12. Joining Multiple Tables/12. LEFT OUTER JOIN (LEFT JOIN).mp4113.58MB

12. Joining Multiple Tables/13. RIGHT OUTER JOIN (RIGHT JOIN).mp491.02MB

12. Joining Multiple Tables/14. FULL OUTER JOIN (FULL JOIN).mp435.8MB

12. Joining Multiple Tables/15. Cross Join (Cartesian Product Cross Product).mp4157.37MB

12. Joining Multiple Tables/16. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 1).mp4121.37MB

12. Joining Multiple Tables/17. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 2).mp4161.01MB

12. Joining Multiple Tables/18. Oracle's Old Style Join Syntax (ANSI vs Non-ANSI Joins) (Part 3).mp486.47MB

12. Joining Multiple Tables/19. The Differences Between The Inner Joins & Outer Joins, Equijoins & Non-Equijoins.mp4135.87MB

12. Joining Multiple Tables/20. Which Join Type Should You Use.mp426.43MB

12. Joining Multiple Tables/21. Entity-Relationship Models in DBMS - How to Use Them with Joins.mp4133.09MB

13. Using Subqueries/1. Using Subqueries.mp455.42MB

13. Using Subqueries/2. Single Row Subqueries.mp4132.23MB

13. Using Subqueries/3. Multiple Row Subqueries.mp4121.97MB

13. Using Subqueries/4. Multiple Column Subqueries.mp4128.02MB

13. Using Subqueries/5. Using Subqueries as a Table.mp463.63MB

13. Using Subqueries/6. SCALAR Subqueries.mp4114.75MB

13. Using Subqueries/7. Correlated Subqueries.mp4134.92MB

13. Using Subqueries/8. EXISTS Operator & Semijoins.mp488.21MB

13. Using Subqueries/9. NOT EXISTS Operator.mp449.24MB

14. Working with the Oracle SET Operators/2. Introduction to SET Operators in Oracle SQL.mp4121.88MB

14. Working with the Oracle SET Operators/3. UNION and UNION ALL Operators.mp4123.73MB

14. Working with the Oracle SET Operators/4. INTERSECT Operator.mp419.36MB

14. Working with the Oracle SET Operators/5. MINUS Operator.mp430.11MB

14. Working with the Oracle SET Operators/6. Matching Unmatched Queries in SET Operations.mp429.93MB

14. Working with the Oracle SET Operators/7. Using the ORDER BY Clause with SET Operators.mp461.27MB

15. Data Manipulation Language (DML) Statements/1. Data Manipulation Language (DML).mp425.35MB

15. Data Manipulation Language (DML) Statements/2. INSERT Statement (Part 1).mp438.24MB

15. Data Manipulation Language (DML) Statements/3. INSERT Statement (Part 2).mp4124.87MB

15. Data Manipulation Language (DML) Statements/4. UPDATE Statement.mp4110.06MB

15. Data Manipulation Language (DML) Statements/5. DELETE Statement.mp466.41MB

15. Data Manipulation Language (DML) Statements/6. Transaction Control Statements.mp445.26MB

15. Data Manipulation Language (DML) Statements/7. COMMIT and ROLLBACK Statements.mp489.23MB

15. Data Manipulation Language (DML) Statements/8. SAVEPOINT Statement.mp430.19MB

15. Data Manipulation Language (DML) Statements/9. FOR UPDATE Statement.mp484.82MB

16. Data Definition Language (DDL) Statements/1. Data Definition Language (DDL).mp421.04MB

16. Data Definition Language (DDL) Statements/2. Naming Rules.mp422.99MB

16. Data Definition Language (DDL) Statements/3. CREATE TABLE Statement.mp4160.74MB

16. Data Definition Language (DDL) Statements/4. ALTER TABLE Statement.mp4192.79MB

16. Data Definition Language (DDL) Statements/5. DROP TABLE Statement.mp436.21MB

16. Data Definition Language (DDL) Statements/6. TRUNCATE TABLE Statement.mp444.89MB

16. Data Definition Language (DDL) Statements/7. COMMENT Statement.mp467.98MB

16. Data Definition Language (DDL) Statements/8. RENAME Statement.mp452.32MB

17. Creating Constraints/1. Creating Constraints.mp441.29MB

17. Creating Constraints/2. NOT NULL Constraint.mp454.63MB

17. Creating Constraints/3. UNIQUE Constraint.mp4104.63MB

17. Creating Constraints/4. PRIMARY KEY Constraint.mp463.47MB

17. Creating Constraints/5. FOREIGN KEY Constraint.mp4174.05MB

17. Creating Constraints/6. CHECK Constraint.mp437.79MB

18. Conclusion + Bonus/1. Conclusion.mp44.96MB

19. Appendix/1. Appendix 1 Oracle Database 12c Installation into Your Computer.mp418.85MB

19. Appendix/3. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp426.92MB