Oracle SQL - A Complete Developer's Guide (2023)

Download Now


Files Included :

1 Introduction to RDBMS.mp4 (39.19 MB)
MP4
1 CASE Statement.mp4 (29.62 MB)
MP4
2 DECODE.mp4 (28.96 MB)
MP4
1 Outer joins (Left, Right, Full).mp4 (85.84 MB)
MP4
2 Self-joins , Equijoin, Non equijoins, Outer joins.mp4 (78.1 MB)
MP4
1 Table Creation, Data Types.mp4 (94.5 MB)
MP4
2 Data dictionary and comments on columns and Table.mp4 (106.14 MB)
MP4
3 Temporary Tables.mp4 (43.72 MB)
MP4
4 External Table.mp4 (42.32 MB)
MP4
1 DDL – CREATE, ALTER, MODIFY ,TRUNCATE ,Make Column UNUSED and Drop UNUSED column.mp4 (98.26 MB)
MP4
2 DML – Insert, Update, Delete, Merge.mp4 (109.58 MB)
MP4
3 DML – Multiple Insert.mp4 (16.41 MB)
MP4
4 DCL- GRANT and REVOKE.mp4 (30.58 MB)
MP4
5 Transaction - COMMIT, ROLLBACK , SAVE POINT.mp4 (71.49 MB)
MP4
1 Constraints (NOT NULL, PRIMARY KEY, UNIQUE KEY, FOREIGN KEY, CHECK).mp4 (212.18 MB)
MP4
1 B-Tree (Balanced Tree).mp4 (44.18 MB)
MP4
2 Bitmap Index.mp4 (49.65 MB)
MP4
3 Function based index.mp4 (34.32 MB)
MP4
1 Sequence.mp4 (128.35 MB)
MP4
2 Synonyms.mp4 (59.36 MB)
MP4
1 View.mp4 (57.49 MB)
MP4
2 Key Preserved table in view.mp4 (78.32 MB)
MP4
3 Single View and Complex view.mp4 (39.77 MB)
MP4
1 Managing Objects with Data Dictionary Views.mp4 (64.34 MB)
MP4
1 System privileges and Object privileges.mp4 (41.99 MB)
MP4
2 Grants on a Table.mp4 (33.63 MB)
MP4
3 ROLE.mp4 (54.23 MB)
MP4
1 Relationship between a database and SQL.mp4 (20.37 MB)
MP4
2 SQL Select Statement to Components of an ERD.mp4 (35.39 MB)
MP4
1 Flashback table.mp4 (31.91 MB)
MP4
2 Flashback query.mp4 (34.63 MB)
MP4
1 Working with CURRENT DATE, CURRENT TIMESTAMP and LOCALTIMESTAMP.mp4 (36.9 MB)
MP4
2 INTERVAL Data Type ( DAY TO SECOND , YEAR TO MONTH).mp4 (53.61 MB)
MP4
3 Working with NEW TIME and FROM TZ - 12c.mp4 (54.59 MB)
MP4
1 Oracle 21c - XE Installation.mp4 (84.57 MB)
MP4
2 Multitenant Architecture overview.mp4 (90.32 MB)
MP4
3 Create PDB, Schema user, Connect to 21c from Oracle SQL Developer.mp4 (173.72 MB)
MP4
1 Versions of Oracle, Live Oracle cloud account creation, demo data setup.mp4 (55.45 MB)
MP4
2 Oracle 11g- XE installation.mp4 (87.21 MB)
MP4
3 Work is SQLPLUS and SQL Developer.mp4 (154.48 MB)
MP4
1 Schema, Alias, Prefix, what is ''.mp4 (47.26 MB)
MP4
10 Solution Code Challenge - 03.mp4 (11.29 MB)
MP4
2 How to restrict data using WHERE clause, Data sorting by ORDER BY clause.mp4 (52.86 MB)
MP4
3 Substitution variables - VERIFY, DEFINE , UNDEFINE.mp4 (69.8 MB)
MP4
4 Row Limiting Clause for Top-N Queries - 12C.mp4 (79.3 MB)
MP4
5 Code Challenge - 01.mp4 (8.08 MB)
MP4
6 Solution Code Challenge - 01.mp4 (26.22 MB)
MP4
7 Code Challenge - 02.mp4 (27.02 MB)
MP4
8 Solution Code Challenge - 02.mp4 (22.22 MB)
MP4
9 Code Challenge - 03.mp4 (4.5 MB)
MP4
1 Unary and Binary Operators.mp4 (16.8 MB)
MP4
2 Comparison Operator (=,,,,=,=, BETWEEN, NOT IN, IN ,IS NULL, IS NOT NULL).mp4 (91.1 MB)
MP4
3 Comparison Operator ( Wildcard Search LIKE, NOT LIKE).mp4 (61.24 MB)
MP4
4 Logical operators (NOT, AND , OR).mp4 (39.99 MB)
MP4
5 Arithmetic operators (+ Addition , - Minus , Multiplication , Division ).mp4 (28.3 MB)
MP4
6 Arithmetic operators Precedence.mp4 (9.18 MB)
MP4
7 Character operators ( ).mp4 (10.9 MB)
MP4
8 Set operators ( UNION, UNION ALL, INTERSECT, INTERSECT ALL, MINUS ).mp4 (32.9 MB)
MP4
1 Numeric Function (ABS, FLOOR, CEIL, MOD, POWER, SIGN, TRUNC ROUND, WIDTH BUCKET).mp4 (130.13 MB)
MP4
2 Character Function (CONCAT, REPLACE, SUBSTR, INSTR, UPPER, LOWER, LAPD, RPAD).mp4 (69.53 MB)
MP4
3 Date Functions (SYSDATE, LAST DAY, ROUND, TRUNC, ADD MONTHS, MONTHS BETWEEN).mp4 (196.14 MB)
MP4
4 Conversion Function (TO DATE, TO CHAR, TO TIMESTAMP, TO NUMBER).mp4 (31.24 MB)
MP4
5 Nesting Functions.mp4 (7.37 MB)
MP4
6 NULL Functions (NVL, NVL2, COALESCE, NULLIF).mp4 (37.15 MB)
MP4
1 Group or Aggregate Function (MAX, MIN, AVG, COUNT, SUM).mp4 (64.71 MB)
MP4
2 Rows to Columns & vice-versa - PIVOT, UNPIVOT.mp4 (81.93 MB)
MP4
3 Analytical Functions -1 (ROW NUMBER, RANK, DENSE RANK, FIRST, LAST, LISTAGG).mp4 (97.75 MB)
MP4
4 Analytical Functions -2 (LEAD, LAG).mp4 (63.58 MB)
MP4
1 Hierarchical queries Functions (CONNECT BY PRIOR, LEVEL, SYS CONNECT BY PATH).mp4 (89.75 MB)
MP4
2 Hierarchical queries writing.mp4 (29.72 MB)
MP4
1 Subquery, Co-related Sub query, Inline Views.mp4 (47.6 MB)
MP4
2 Co-related Subquery with EXISTS clause.mp4 (18.22 MB)
MP4
3 Update and Delete using Co-related Subquery.mp4 (31.32 MB)
MP4