种子简介

种子名称： [FreeCourseLab.com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071
文件类型： 视频
文件数目： 167个文件
文件大小： 3.37 GB
收录时间： 2022-5-11 02:20
已经下载： 3次
资源热度： 195
最近下载： 2024-12-26 13:47

下载BT种子文件

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

磁力链接下载

magnet:?xt=urn:btih:9624b897b49537a52e3b9fd016f0779a63b7dd0e&dn=[FreeCourseLab.com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

[FreeCourseLab.com] Udemy - Oracle Database 12c SQL Certified Associate 1Z0-071.torrent

1. Introduction/1. Course Agenda.mp421.1MB

1. Introduction/2. System Development Life Cycle & Database Definition.mp414.71MB

1. Introduction/3. What is a Table.mp46.66MB

1. Introduction/4. Data Models & ERM.mp418.54MB

1. Introduction/5. About Primary key & foreign key.mp414.51MB

1. Introduction/6. SQL and Types of SQL Statements.mp413.44MB

1. Introduction/7. Oracle Database 12c Architecture.mp415.28MB

1. Introduction/8. HR Schema in this Course.mp421.27MB

10. Displaying Data from multiple tables using joins/1. Before You Start, important notes.mp438.56MB

10. Displaying Data from multiple tables using joins/10. 1999 Syntax USING Clause.mp412.68MB

10. Displaying Data from multiple tables using joins/11. 1999 Syntax ON Clause.mp420.28MB

10. Displaying Data from multiple tables using joins/12. 1999 Syntax LeftRightfull Outer Join.mp422.52MB

10. Displaying Data from multiple tables using joins/2. HR Tables Diagram, Joins Clarification.mp412.67MB

10. Displaying Data from multiple tables using joins/3. What is Cartesian product.mp418.22MB

10. Displaying Data from multiple tables using joins/4. Old Joins Equijoin.mp420.44MB

10. Displaying Data from multiple tables using joins/5. Old Joins nonEquijoins.mp424.47MB

10. Displaying Data from multiple tables using joins/6. Old Joins outer join.mp420.86MB

10. Displaying Data from multiple tables using joins/7. Old Joins Self Join and More Practices.mp420MB

10. Displaying Data from multiple tables using joins/8. 1999 Syntax Cross Join (Cartesian product ).mp414.6MB

10. Displaying Data from multiple tables using joins/9. 1999 Syntax Natural Join.mp426.24MB

11. Using Subqueries to Solve Queries/1. Single row Subqueries.mp421.26MB

11. Using Subqueries to Solve Queries/2. Multiple rows Subqueries.mp417.57MB

11. Using Subqueries to Solve Queries/3. NULL values and Subqueries.mp415.92MB

11. Using Subqueries to Solve Queries/4. Exists and not Exists.mp413.41MB

12. Using the Set Operators/1. Overview (Union, union all, intersect, minus ).mp411.69MB

12. Using the Set Operators/2. Practice (Union, union all, intersect, minus ).mp426.83MB

13. Managing tables using DML Statments/1. Introduction to DML.mp410.94MB

13. Managing tables using DML Statments/10. ROW Lock.mp410.56MB

13. Managing tables using DML Statments/11. FOR UPDATE Clause.mp419.4MB

13. Managing tables using DML Statments/2. Insert Statement.mp433.2MB

13. Managing tables using DML Statments/3. Inserting common errors.mp414.59MB

13. Managing tables using DML Statments/4. Update Statement.mp433.62MB

13. Managing tables using DML Statments/5. Delete Statement.mp433.22MB

13. Managing tables using DML Statments/6. What is Database Transactions.mp416.78MB

13. Managing tables using DML Statments/7. About Commit & Rollback.mp418.8MB

13. Managing tables using DML Statments/8. Practice ( Commit and rollback ).mp425.98MB

13. Managing tables using DML Statments/9. SAVEPOINT.mp412.05MB

14. Introduction to Data Definition Language/1. DDL & Naming Rules.mp420.69MB

14. Introduction to Data Definition Language/10. Create Table AS subquery.mp418.63MB

14. Introduction to Data Definition Language/11. Alter Table Add Columns.mp422.43MB

14. Introduction to Data Definition Language/12. Alter Table Modify Columns.mp419.3MB

14. Introduction to Data Definition Language/13. Alter Table Drop Columns.mp418.17MB

14. Introduction to Data Definition Language/14. Alter Table Set Unused.mp417.76MB

14. Introduction to Data Definition Language/15. ALTER TABLE READ ONLY READ write.mp417.06MB

14. Introduction to Data Definition Language/16. Drop Table.mp415.68MB

14. Introduction to Data Definition Language/17. Rename Column Rename Table.mp49.24MB

14. Introduction to Data Definition Language/2. Data Types Part 1.mp416.12MB

14. Introduction to Data Definition Language/3. Data Types Part 2.mp413.39MB

14. Introduction to Data Definition Language/4. Creating Tables (without constraints).mp421.97MB

14. Introduction to Data Definition Language/5. Types of constraints and why we use it.mp416.3MB

14. Introduction to Data Definition Language/6. Creating Tables ( Column Level Constraints ).mp432.22MB

14. Introduction to Data Definition Language/7. Creating Tables ( Table Level Constraints ).mp414.68MB

14. Introduction to Data Definition Language/8. Constraints Guidelines.mp417.75MB

14. Introduction to Data Definition Language/9. ON DELETE cascade ON DELETE set null.mp418.48MB

15. Tips you Should know/1. Tips you Should know Part 1.mp416.28MB

15. Tips you Should know/2. Tips you Should know Part 2.mp45.38MB

15. Tips you Should know/3. Tips you Should know Part 3.mp414.76MB

15. Tips you Should know/4. Tips you Should know Part 4.mp411.94MB

15. Tips you Should know/5. Tips you Should know Part 5.mp411.54MB

15. Tips you Should know/6. Tips you Should know Part 6.mp415.67MB

16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/1. About Exam 1Z0-061 Visiting Oracle Website.mp422.08MB

16. Exam 1Z0-061 Oracle Database 12c SQL Fundamentals/2. My recommendations.mp415.24MB

17. Introduction to Data Dictionary Views/1. What is Data Dictionary Views.mp416.32MB

17. Introduction to Data Dictionary Views/2. What is DICTIONARY.mp410.49MB

17. Introduction to Data Dictionary Views/3. USER_OBJECTS ALL_OBJECTS.mp418.28MB

17. Introduction to Data Dictionary Views/4. USER_TABLES ALL_TABLES USER_TAB_COLUMNS.mp419.31MB

17. Introduction to Data Dictionary Views/5. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1.mp414.81MB

17. Introduction to Data Dictionary Views/6. USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2.mp438.3MB

17. Introduction to Data Dictionary Views/7. COMMENT ON TABLE COLUMN.mp414.88MB

18. Creating sequences, synonyms, and indexes/1. Sequences Part 1.mp417.63MB

18. Creating sequences, synonyms, and indexes/2. Sequences Part 2.mp416.79MB

18. Creating sequences, synonyms, and indexes/3. Sequences Part 3.mp418.28MB

18. Creating sequences, synonyms, and indexes/4. Sequences Part 4.mp433.07MB

18. Creating sequences, synonyms, and indexes/5. Creating Synonyms.mp417.81MB

18. Creating sequences, synonyms, and indexes/6. Creating Indexes Part 1.mp441.88MB

18. Creating sequences, synonyms, and indexes/7. Creating Indexes Part 2.mp425.67MB

19. Creating Views/1. What is a View What is the benefits of Views.mp413.17MB

19. Creating Views/2. Creating Simple Views.mp419.24MB

19. Creating Views/3. Creating Complex Views.mp421.79MB

19. Creating Views/4. With READ ONLY With check option Force view.mp420.54MB

2. Live SQL & Download Install/1. Oracle Live SQL No Installation for anything.mp435.91MB

2. Live SQL & Download Install/3. Downloading Oracle DB 12c.mp417.77MB

2. Live SQL & Download Install/4. Installing Oracle DB 12c.mp425.61MB

20. Managing Schema Objects/1. Adding constraints dropping constraints.mp436.49MB

20. Managing Schema Objects/2. Rename Column Rename Constraint.mp48.36MB

20. Managing Schema Objects/3. Enable Disable Constraints.mp421.47MB

20. Managing Schema Objects/4. Understanding DEFERRABLE Constraints.mp419.87MB

20. Managing Schema Objects/5. DEFERRABLE Constraints Exercises.mp421.91MB

20. Managing Schema Objects/6. GLOBAL TEMPORARY TABLE.mp414.21MB

20. Managing Schema Objects/7. About SQLLoader.mp434.86MB

20. Managing Schema Objects/8. External Tables Part 1.mp421.8MB

20. Managing Schema Objects/9. External Tables Part 2.mp417.09MB

21. Retrieving Data By Using Subqueries/1. Using the subquery as a source table.mp423.48MB

21. Retrieving Data By Using Subqueries/2. Pairwise Non Pairwise Subqueries.mp417.67MB

21. Retrieving Data By Using Subqueries/3. Scalar Subquery Correlated Subquery.mp422.75MB

21. Retrieving Data By Using Subqueries/4. Reminder of Exists Not Exists.mp422.15MB

21. Retrieving Data By Using Subqueries/5. WITH Clause.mp432.95MB

22. Manipulating Data By Using Subqueries/1. Inserting Updating Deleting Using a subquery as a target.mp420.32MB

22. Manipulating Data By Using Subqueries/2. Correlated Update Correlated Delete.mp425.73MB

23. Controlling User Access/1. Database Security System Privileges & Roles.mp424.26MB

23. Controlling User Access/2. Database Security Object Privileges.mp422.36MB

23. Controlling User Access/3. System Privileges & Privileges Practice 1.mp423.09MB

23. Controlling User Access/4. System Privileges & Privileges Practice 2.mp425.75MB

23. Controlling User Access/5. Creating ROLE Practice.mp430.46MB

23. Controlling User Access/6. With Grant Option.mp418.04MB

23. Controlling User Access/7. Drop user Statement.mp413.91MB

24. Manipulating Data/1. What is Data Warehouse.mp49.2MB

24. Manipulating Data/2. Explicit default value in insert & update statement.mp410.73MB

24. Manipulating Data/3. Copy rows from another table.mp48.61MB

24. Manipulating Data/4. INSERT ALL statement INSERT FIRST.mp428.28MB

24. Manipulating Data/5. Another INSERT ALL Example & Notes.mp418.83MB

24. Manipulating Data/6. Creating Matrix Report Using PIVOT.mp417.06MB

24. Manipulating Data/7. The Merge Statement.mp412.19MB

24. Manipulating Data/8. FLASHBACK Table & System change Number ( SCN).mp427.82MB

25. Managing Data in Different Time Zones/1. THE INTERVAL ( YEAR TO MONTH day TO second).mp418.61MB

25. Managing Data in Different Time Zones/2. to_yminterval to_dsinterval.mp49.31MB

25. Managing Data in Different Time Zones/3. Extract function.mp44.93MB

25. Managing Data in Different Time Zones/4. timestamp timestamp with time zone.mp410.88MB

25. Managing Data in Different Time Zones/5. V$TIMEZONE_NAMES and some functions.mp419.07MB

25. Managing Data in Different Time Zones/6. timestamp with local time zone.mp411.81MB

25. Managing Data in Different Time Zones/7. TZ_OFFSET FROM_TZ TO_TIMESTAMP.mp412.22MB

26. Exam 1Z0-071 for SQL Certified Associate/1. About the Exam 1Z0-071.mp418.44MB

26. Exam 1Z0-071 for SQL Certified Associate/2. Some helpful websites contains exams Dumps.mp429.86MB

27. Bonus Section/1. Using SELECT statement to create dynamic scripts.mp418.78MB

27. Bonus Section/2. Installing oracle 11g express edition.mp436.9MB

27. Bonus Section/3. Rownum and rowid.mp416.32MB

27. Bonus Section/4. About PLSQL.mp431.45MB

27. Bonus Section/7. DML logs using package dbms_errlog.mp490.21MB

3. Connecting to the Database/1. Connecting SYS using SQL plus & SQL Developer.mp431.64MB

3. Connecting to the Database/3. Unlock HR Account Part 1.mp416.04MB

3. Connecting to the Database/4. Unlock HR Account Part 2.mp438.43MB

3. Connecting to the Database/5. ORA-01033 oracle initialization or shutdown in progress 12c.mp420.6MB

4. Retrieving data using the select statement/1. Navigate HR schema.mp429.63MB

4. Retrieving data using the select statement/2. Capabilities of SQL SELECT Statements.mp421.28MB

4. Retrieving data using the select statement/3. Arithmetic expressions and NULL values.mp416.27MB

4. Retrieving data using the select statement/4. Column Alias, Concatenation , Distinct and DESCRIBE.mp429.94MB

4. Retrieving data using the select statement/5. Important Notes in Select Statement.mp423.84MB

5. Restricting and Sorting Data/1. The WHERE Clause & Comparison Operators.mp439.73MB

5. Restricting and Sorting Data/2. Using Between and IN Like Operators.mp428.33MB

5. Restricting and Sorting Data/3. Using IS NULL NOT Not equal Operators.mp411.94MB

5. Restricting and Sorting Data/4. Logical Operators (AND OR NOT).mp425.57MB

5. Restricting and Sorting Data/5. Order by Clause.mp428.05MB

5. Restricting and Sorting Data/6. The FETCH Clause.mp427.75MB

6. Substitution Variables/1. What is a Substitution Variables (&).mp424.39MB

6. Substitution Variables/2. DEFINE UNDEFINE.mp413.35MB

6. Substitution Variables/3. ACCEPT PROMPT.mp416.99MB

6. Substitution Variables/4. Double-Ampersand SET VERIFY SET DEFINE.mp413.54MB

7. Using Single-Row Functions to Customize Output/1. Single Row Function Introduction.mp416.45MB

7. Using Single-Row Functions to Customize Output/10. Nesting Functions.mp415.04MB

7. Using Single-Row Functions to Customize Output/2. Character functions (Upper, Lower, Initcap ).mp413.72MB

7. Using Single-Row Functions to Customize Output/3. Character functions (concat, substr, length ).mp417.9MB

7. Using Single-Row Functions to Customize Output/4. Character functions ( instr ).mp411.47MB

7. Using Single-Row Functions to Customize Output/5. Character functions ( lpad, rpad , replace, trim).mp425.36MB

7. Using Single-Row Functions to Customize Output/6. Number functions ( Round, Trunc, MOD ).mp428.98MB

7. Using Single-Row Functions to Customize Output/7. Date Functions ( Sysdate).mp423.27MB

7. Using Single-Row Functions to Customize Output/8. Date Functions ( months_between, add_months, next_day, last_day).mp419.61MB

7. Using Single-Row Functions to Customize Output/9. Date Functions ( round , trunc ).mp419.8MB

8. Using Conversion Functions and Conditional Expressions/1. Implicit Data Conversion VS Explicit.mp416.65MB

8. Using Conversion Functions and Conditional Expressions/2. TO_CHAR with dates.mp421.41MB

8. Using Conversion Functions and Conditional Expressions/3. TO_CHAR with numbers.mp428.88MB

8. Using Conversion Functions and Conditional Expressions/4. TO_NUMBER , TO_DATE Functions.mp419.09MB

8. Using Conversion Functions and Conditional Expressions/5. nvl , nvl2 , nullif and coalesce Functions.mp428.01MB

8. Using Conversion Functions and Conditional Expressions/6. The CASE Function.mp430.1MB

8. Using Conversion Functions and Conditional Expressions/7. The DECODE Function.mp420.28MB

9. Reporting Aggregated Data Using the Group Functions/1. Group functions Introduction.mp415.61MB

9. Reporting Aggregated Data Using the Group Functions/2. Group functions (sum, count, max, min, avg & more).mp417.88MB

9. Reporting Aggregated Data Using the Group Functions/3. Group by Clause, Having Clause.mp430.15MB