Oracle SQL – A Complete Developer’s Guide (2023)

سرفصل های دوره

Certification Course for OCA (1Z0-071) | SQL Bootcamp for Database Developer, ETL Developer & Data Scientist !!

1. Introduction

1. Introduction to RDBMS

2. Introduction to SQL

1. Relationship between a database and SQL

2. SQL Select Statement to Components of an ERD

3. Introduction to SQL.html

3. Environment Setup

1.1 FAQ.txt

1.2 table data scripts.zip

1. Versions of Oracle, Live Oracle cloud account creation, demo data setup

2.1 18C Installation Guide.docx

2.2 environment setup.zip

2. Oracle 11g- XE installation

3.1 login.zip

3. Work is SQLPLUS and SQL Developer

4. Basic SQL

1. Schema, Alias, Prefix, what is

2.1 where clause script.zip

2. How to restrict data using WHERE clause, Data sorting by ORDER BY clause

3.1 substitution variables script.zip

3. Substitution variables - VERIFY, DEFINE , UNDEFINE

4.1 row limiting clause script.zip

4. Row Limiting Clause for Top-N Queries - 12C

5. Code Challenge - 01

6.1 cc 01 select query.zip

6. Solution Code Challenge - 01

7.1 cc 02 create table.zip

7.2 cc 02 insert.zip

7. Code Challenge - 02

8.1 solution code challenge 02.zip

8. Solution Code Challenge - 02

9. Code Challenge - 03

10.1 solution code challenge 03.zip

10. Solution Code Challenge - 03

11. Basic SQL (1Z0-071).html

5. Operators

1. Unary and Binary Operators

2.1 comparision operator scrips.zip

2. Comparison Operator (=,,,,=,=, BETWEEN, NOT IN, IN ,IS NULL, IS NOT NULL)

3.1 comparision operator scripts.zip

3. Comparison Operator ( Wildcard Search LIKE, NOT LIKE)

4.1 logical operator scripts.zip

4. Logical operators (NOT, AND , OR)

5.1 arithmetic operators scripts.zip

5. Arithmetic operators (+ Addition , - Minus , Multiplication , Division )

6. Arithmetic operators Precedence

7.1 character operator scripts.zip

7. Character operators ( )

8.1 set operators scripts.zip

8. Set operators ( UNION, UNION ALL, INTERSECT, INTERSECT ALL, MINUS )

9. Operators (1Z0-071).html

6. Oracle Built-in Single row functions

1.1 single row functions scripts.zip

1. Numeric Function (ABS, FLOOR, CEIL, MOD, POWER, SIGN, TRUNC ROUND, WIDTH BUCKET)

2.1 character function scripts.zip

2. Character Function (CONCAT, REPLACE, SUBSTR, INSTR, UPPER, LOWER, LAPD, RPAD)

3.1 date function scripts.zip

3. Date Functions (SYSDATE, LAST DAY, ROUND, TRUNC, ADD MONTHS, MONTHS BETWEEN)

4.1 conversion functions scripts.zip

4. Conversion Function (TO DATE, TO CHAR, TO TIMESTAMP, TO NUMBER)

5.1 nesting function scripts.zip

5. Nesting Functions

6.1 null function scripts.zip

6. NULL Functions (NVL, NVL2, COALESCE, NULLIF)

7. Oracle Built-in Single row Functions (1Z0-071).html

7. Oracle Built-Group function or Aggregate functions

1.1 group function script.zip

1. Group or Aggregate Function (MAX, MIN, AVG, COUNT, SUM)

2.1 pivot unpivot functions scripts.zip

2. Rows to Columns & vice-versa - PIVOT, UNPIVOT

3.1 group analytical function script.zip

3. Analytical Functions -1 (ROW NUMBER, RANK, DENSE RANK, FIRST, LAST, LISTAGG)

4.1 lead lag functions scripts.zip

4. Analytical Functions -2 (LEAD, LAG)

5. Oracle Built-Group Function or Aggregate Functions (1Z0-071).html

8. Hierarchical queries

1.1 hierarchical queries functions scripts.zip

1. Hierarchical queries Functions (CONNECT BY PRIOR, LEVEL, SYS CONNECT BY PATH)

2.1 hierarchical queries functions scripts.zip

2. Hierarchical queries writing

9. Query Types

1.1 subquery scripts.zip

1. Subquery, Co-related Sub query, Inline Views

2. Co-related Subquery with EXISTS clause

3. Update and Delete using Co-related Subquery

4. Query Types (1Z0-071).html

10. CASE Statement

1.1 case decode scripts.zip

1. CASE Statement

2. DECODE

3. Case and Decode (1Z0-071).html

11. Displaying Data from Multiple Tables

1.1 joins scripts.zip

1. Outer joins (Left, Right, Full)

2.1 equi nonequi join.zip

2. Self-joins , Equijoin, Non equijoins, Outer joins

3. Joins (1Z0-071).html

12. Table

1.1 table creation scripts.zip

1. Table Creation, Data Types

2.1 data dictionary for table script.zip

2. Data dictionary and comments on columns and Table

3.1 temporary table script.zip

3. Temporary Tables

4.1 external table scripts.zip

4. External Table

5. Table (1Z0-071).html

13. SQL Command

1.1 ddl statements scripts.zip

1. DDL CREATE, ALTER, MODIFY ,TRUNCATE ,Make Column UNUSED and Drop UNUSED column

2.1 dml statements scripts.zip

2. DML Insert, Update, Delete, Merge

3.1 dml multiple insert.zip

3. DML Multiple Insert

4.1 dcl statements scripts.zip

4. DCL- GRANT and REVOKE

5.1 tcl statements scripts.zip

5. Transaction - COMMIT, ROLLBACK , SAVE POINT

6. SQL Command Types (1Z0-071).html

14. Constraints

1.1 constraints scripts.zip

1. Constraints (NOT NULL, PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, CHECK)

2. Constraints (1Z0-071).html

15. Indexes

1. B-Tree (Balanced Tree)

2. Bitmap Index

3.1 index scripts.zip

3. Function based index

4. Index (1Z0-071).html

16. Other Objects

1.1 sequence scripts.zip

1. Sequence

2.1 synonyms scripts.zip

2. Synonyms

3. Other Objects (1Z0-071).html

17. View

1.1 view scripts.zip

1. View

2. Key Preserved table in view

3. Single View and Complex view

4. View (1Z0-071).html

18. Managing Objects with Data Dictionary Views

1.1 data dictionary scripts.zip

1. Managing Objects with Data Dictionary Views

2. Managing Objects with Data Dictionary Views (1Z0-071).html

19. System privileges and Object privileges

1.1 object system privs.zip

1. System privileges and Object privileges

2. Grants on a Table

3.1 rol privs.zip

3. ROLE

4. System privileges and Object privileges (1Z0-071).html

20. Flashback table and Flashback query

1.1 flashback table query.zip

1. Flashback table

2. Flashback query

3. Flashback table and Flashback query.html

21. Managing Data in Different Time Zones

1.1 time zone scripts.zip

1. Working with CURRENT DATE, CURRENT TIMESTAMP and LOCALTIMESTAMP

2. INTERVAL Data Type ( DAY TO SECOND , YEAR TO MONTH)

3. Working with NEW TIME and FROM TZ - 12c

4. Time Zone (1Z0-071).html

5. Time Zone (1Z0-071).html

22. Bonus 01 Oracle Multitenant Architecture - 21c

1. Oracle 21c - XE Installation

2. Multitenant Architecture overview

3.1 FAQ Documents.docx

3. Create PDB, Schema user, Connect to 21c from Oracle SQL Developer

45,900 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy