种子简介

种子名称： GetFreeCourses.Co-Udemy-The Complete Oracle SQL Bootcamp (2021)
文件类型： 视频
文件数目： 148个文件
文件大小： 13.11 GB
收录时间： 2021-12-30 20:14
已经下载： 3次
资源热度： 174
最近下载： 2024-6-26 12:00

下载BT种子文件

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

磁力链接下载

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

喜欢这个种子的人也喜欢

种子包含的文件

GetFreeCourses.Co-Udemy-The Complete Oracle SQL Bootcamp (2021).torrent

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

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

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

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

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

1. Database Concepts/5. What is a Relational Database (RDBMS).mp490.42MB

1. Database Concepts/6. Entity Relationship Logic in Databases.mp434.25MB

1. Database Concepts/7. What is Pluggable Database.mp415.6MB

1. Database Concepts/8. Introduction to Database Objects.mp4180.36MB

1. Database Concepts/9. The Sample (HR) Schema Used in This Course.mp478.28MB

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

10. Group Functions/2. AVG Function.mp448.57MB

10. Group Functions/3. COUNT Function.mp424.85MB

10. Group Functions/4. MAX Function.mp454.48MB

10. Group Functions/5. MIN Function.mp422.66MB

10. Group Functions/6. SUM Function.mp414.72MB

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

10. Group Functions/8. Overview Of Group Functions.mp419.6MB

11. Grouping Data/1. GROUP BY Clause (Part 1).mp482.72MB

11. Grouping Data/2. GROUP BY Clause (Part 2).mp4139MB

11. Grouping Data/3. HAVING Clause.mp456.92MB

11. Grouping Data/4. Nested Group Functions.mp422.85MB

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

12. Joining Multiple Tables/10. Non-Equijoins (Joining Unequal Tables).mp4149.23MB

12. Joining Multiple Tables/11. OUTER JOINS.mp452.26MB

12. Joining Multiple Tables/12. LEFT OUTER JOIN (LEFT JOIN).mp4102.26MB

12. Joining Multiple Tables/13. RIGHT OUTER JOIN (RIGHT JOIN).mp479.73MB

12. Joining Multiple Tables/14. FULL OUTER JOIN (FULL JOIN).mp426.65MB

12. Joining Multiple Tables/15. Cross Join (Cartesian Product Cross Product).mp4267.05MB

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

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

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

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

12. Joining Multiple Tables/2. Creating a Join.mp420.51MB

12. Joining Multiple Tables/20. Which Join Type Should You Use.mp415.75MB

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

12. Joining Multiple Tables/3. Natural Join.mp4114.22MB

12. Joining Multiple Tables/4. Join with the USING Clause.mp442.7MB

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

12. Joining Multiple Tables/6. Inner Join & Join with the ON Clause.mp442.71MB

12. Joining Multiple Tables/7. Multiple Join Operations.mp4197.7MB

12. Joining Multiple Tables/8. Restricting Joins.mp425.4MB

12. Joining Multiple Tables/9. Self Join.mp451.31MB

13. Using Subqueries/1. Using Subqueries.mp479.59MB

13. Using Subqueries/2. Single Row Subqueries.mp4223.28MB

13. Using Subqueries/3. Multiple Row Subqueries.mp4160.04MB

13. Using Subqueries/4. Multiple Column Subqueries.mp4107.24MB

13. Using Subqueries/5. Using Subqueries as a Table.mp4105.25MB

13. Using Subqueries/6. SCALAR Subqueries.mp494.15MB

13. Using Subqueries/7. Correlated Subqueries.mp4127.26MB

13. Using Subqueries/8. EXISTS Operator & Semijoins.mp476.94MB

13. Using Subqueries/9. NOT EXISTS Operator.mp460.17MB

14. Working with the Oracle SET Operators/1. Introduction to SET Operators in Oracle SQL.mp4180.4MB

14. Working with the Oracle SET Operators/2. UNION and UNION ALL Operators.mp4108.68MB

14. Working with the Oracle SET Operators/3. INTERSECT Operator.mp411.74MB

14. Working with the Oracle SET Operators/4. MINUS Operator.mp424.27MB

14. Working with the Oracle SET Operators/5. Matching Unmatched Queries in SET Operations.mp437.19MB

14. Working with the Oracle SET Operators/6. Using the ORDER BY Clause with SET Operators.mp450.35MB

14. Working with the Oracle SET Operators/7. Combining Multiple Queries Using the SET Operators.mp444.52MB

15. Data Definition Language (DDL) Statements/1. Data Definition Language (DDL).mp423.09MB

15. Data Definition Language (DDL) Statements/10. COMMENT Statement.mp472.6MB

15. Data Definition Language (DDL) Statements/11. RENAME Statement.mp437.97MB

15. Data Definition Language (DDL) Statements/2. Naming Rules & Naming Conventions in Oracle.mp485.05MB

15. Data Definition Language (DDL) Statements/3. CREATE TABLE Statement.mp464.67MB

15. Data Definition Language (DDL) Statements/4. CREATE TABLE AS SELECT (CTAS) Statement in Oracle.mp4103.38MB

15. Data Definition Language (DDL) Statements/5. ALTER TABLE Statement.mp4156.25MB

15. Data Definition Language (DDL) Statements/6. Marking Columns Unused (Using The SET UNUSED Clause).mp467.19MB

15. Data Definition Language (DDL) Statements/7. READ-ONLY Tables in SQL.mp446.74MB

15. Data Definition Language (DDL) Statements/8. DROP TABLE Statement.mp450.71MB

15. Data Definition Language (DDL) Statements/9. TRUNCATE TABLE Statement.mp467.21MB

16. Data Manipulation Language (DML) Statements/1. Data Manipulation Language (DML).mp441.69MB

16. Data Manipulation Language (DML) Statements/10. DELETE Statement.mp464.32MB

16. Data Manipulation Language (DML) Statements/11. MERGE Statement.mp4243.98MB

16. Data Manipulation Language (DML) Statements/12. (TCL) Transaction Control Statements.mp424.52MB

16. Data Manipulation Language (DML) Statements/13. COMMIT and ROLLBACK Statements.mp483.99MB

16. Data Manipulation Language (DML) Statements/14. SAVEPOINT Statement.mp4134.69MB

16. Data Manipulation Language (DML) Statements/15. FOR UPDATE Statement.mp468.21MB

16. Data Manipulation Language (DML) Statements/2. INSERT Statement (Part 1).mp4138.84MB

16. Data Manipulation Language (DML) Statements/3. INSERT Statement (Part 2).mp4290.63MB

16. Data Manipulation Language (DML) Statements/4. Multitable Insert Statements.mp421.8MB

16. Data Manipulation Language (DML) Statements/5. Unconditional Insert Statements (INSERT ALL Statements).mp480.86MB

16. Data Manipulation Language (DML) Statements/6. Conditional INSERT ALL Statements.mp4197.99MB

16. Data Manipulation Language (DML) Statements/7. Conditional INSERT FIRST Statements.mp449.66MB

16. Data Manipulation Language (DML) Statements/8. Pivoting Insert.mp4124.66MB

16. Data Manipulation Language (DML) Statements/9. UPDATE Statement.mp476.52MB

17. Creating Constraints/1. Creating Constraints.mp417.34MB

17. Creating Constraints/2. NOT NULL Constraint.mp429.36MB

17. Creating Constraints/3. UNIQUE Constraint.mp454.59MB

17. Creating Constraints/4. PRIMARY KEY Constraint.mp433.83MB

17. Creating Constraints/5. FOREIGN KEY Constraint.mp499.29MB

17. Creating Constraints/6. CHECK Constraint.mp420.9MB

18. Appendix/1. Appendix 1 Oracle Database 12c Installation into Your Computer.mp479.14MB

18. Appendix/2. Appendix 3 Configuring and Using Oracle SQL Developer for Oracle Database 12c.mp487.21MB

19. Conclusion + Reward!/1. Conclusion.mp41.99MB

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

2. Software Download & Installation/2. Which Option to Choose to Have a Database.mp461.66MB

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

2. Software Download & Installation/4. Option 2 Downloading And Installing Oracle Database.mp4315.47MB

2. Software Download & Installation/5. Option 2 Unlocking the HR Schema.mp427.29MB

2. Software Download & Installation/6. Option 2 Configuring and Using the SQL Developer.mp4250.19MB

2. Software Download & Installation/7. Option 3 Using Oracle Live SQL.mp430MB

2. Software Download & Installation/8. SQL Statements Used in This Course.mp462.97MB

3. Retrieving Data/1. Oracle Data Types.mp485.76MB

3. Retrieving Data/10. DISTINCT and UNIQUE Operator.mp452.77MB

3. Retrieving Data/11. Concatenation Operators.mp451.6MB

3. Retrieving Data/12. Arithmetic Expressions and NULL Values.mp4101.63MB

3. Retrieving Data/2. What is a NULL Value.mp464.42MB

3. Retrieving Data/3. DESCRIBE Command.mp449.52MB

3. Retrieving Data/4. INFORMATION Command.mp446.9MB

3. Retrieving Data/5. SQL Statement Basics.mp4126.8MB

3. Retrieving Data/6. Oracle Error Messages.mp447.46MB

3. Retrieving Data/7. Using SELECT Statements.mp437.67MB

3. Retrieving Data/8. Using Column Aliases.mp441.86MB

3. Retrieving Data/9. Quote (Q) Operator.mp459.11MB

4. Restricting Data/1. Using WHERE Clause.mp431.75MB

4. Restricting Data/2. Comparison Operators.mp499.44MB

4. Restricting Data/3. BETWEEN ... AND Operator.mp442.83MB

4. Restricting Data/4. IN Operator.mp458.11MB

4. Restricting Data/5. LIKE Operator.mp4135.4MB

4. Restricting Data/6. IS NULL Operator.mp433.12MB

4. Restricting Data/7. Logical Operators (AND, OR, NOT).mp4141.17MB

4. Restricting Data/8. Rules of Precedence.mp457.76MB

5. Sorting Data/1. ORDER BY Clause.mp4237.46MB

5. Sorting Data/2. ASC and DESC Operators.mp485.31MB

5. Sorting Data/3. NULLS FIRST and NULLS LAST Operators.mp424.31MB

5. Sorting Data/4. ROWNUM & ROWID in SQL.mp4163.67MB

5. Sorting Data/5. Oracle FETCH Clause.mp497.17MB

6. Using Substitution Variables/1. What is a Substitution Variable.mp489.58MB

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

6. Using Substitution Variables/3. ACCEPT and PROMPT Commands.mp475.46MB

6. Using Substitution Variables/4. SET VERIFY ON SET VERIFY OFF Commands.mp468.99MB

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

7. Single-Row Functions/10. Date Functions & Arithmetic Operations on Dates.mp4217.06MB

7. Single-Row Functions/11. Date Manipulation Functions in SQL.mp4135.95MB

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

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

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

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

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

7. Single-Row Functions/7. Numeric Functions.mp490.29MB

7. Single-Row Functions/8. Nested Functions.mp4133.01MB

7. Single-Row Functions/9. Date Values & Date Formats in Oracle.mp4272.91MB

8. Conversion Functions/1. Conversion Functions.mp479.15MB

8. Conversion Functions/2. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 1).mp4121.55MB

8. Conversion Functions/3. TO_CHAR, TO_DATE, TO_NUMBER Functions (Part 2).mp4177.76MB

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

9. Conditional Expressions/1. Oracle Conditional Expressions CASE Expressions.mp4211.2MB

9. Conditional Expressions/2. Oracle Conditional Expressions DECODE Function.mp479.21MB