Oracle SQL - A Complete Developer's Guide (2023)
Language: English | Size:4.22 GB
Genre:eLearning
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
Oracle SQL - A Complete Developer's Guide (2023).z01
https://rapidgator.net/file/7afab97ad4cbdb93270847dd3dbad71b/Oracle_SQL_-_A_Complete_Developers_Guide_2023.z01
Oracle SQL - A Complete Developer's Guide (2023).z02
https://rapidgator.net/file/cc78a6e892f69ef81ab2b856c2c94037/Oracle_SQL_-_A_Complete_Developers_Guide_2023.z02
Oracle SQL - A Complete Developer's Guide (2023).z03
https://rapidgator.net/file/52e70569c6e751d72870a5a2d7320a85/Oracle_SQL_-_A_Complete_Developers_Guide_2023.z03
Oracle SQL - A Complete Developer's Guide (2023).z04
https://rapidgator.net/file/9b012e2ce818174b934c1e2fb3ec5cc5/Oracle_SQL_-_A_Complete_Developers_Guide_2023.z04
Oracle SQL - A Complete Developer's Guide (2023).zip
https://rapidgator.net/file/603d3bab1aed91d0f2c7eab2920fb07b/Oracle_SQL_-_A_Complete_Developers_Guide_2023.zip
Oracle SQL - A Complete Developer's Guide (2023).z01
https://nitroflare.com/view/863EA058160D567/Oracle_SQL_-_A_Complete_Developers_Guide_2023.z01
Oracle SQL - A Complete Developer's Guide (2023).z02
https://nitroflare.com/view/AEB73D5D92E88C9/Oracle_SQL_-_A_Complete_Developers_Guide_2023.z02
Oracle SQL - A Complete Developer's Guide (2023).z03
https://nitroflare.com/view/E8F84EFE1FB8C7E/Oracle_SQL_-_A_Complete_Developers_Guide_2023.z03
Oracle SQL - A Complete Developer's Guide (2023).z04
https://nitroflare.com/view/3A410B8ED6D46E5/Oracle_SQL_-_A_Complete_Developers_Guide_2023.z04
Oracle SQL - A Complete Developer's Guide (2023).zip
https://nitroflare.com/view/57F3A731F653480/Oracle_SQL_-_A_Complete_Developers_Guide_2023.zip
