Oracle SQL : Practical Examples : Go from Beginner to Master

[LeeAndro]

MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 56 lectures (15 hour, 6 mins) | Size: 5.13 GB

IMMEDIATE vs DEFERRED constraints - Transaction level constraint validation.

What you'll learn

SQL over Oracle 19 C version on Oracle LiveSQL platform

A to Z in SQL on Oracle's latest version

Go from an absolute bner to an advanced SQL developer in less than 15 hours

RDBMS fundamentals and explanation on various teologies for interview preparation

This is a complete course which does not require the students to have local installation of Oracle yet they we use the latest version of Oracle from web

Structure of basic query statement - Projection, Predicate and Verb

Use of Logical Operators - AND, OR, IN, BETWEEN, NOT, DISTINCT, LIKE

Various important properties of ORDER BY clause with examples

Deal with NULL values - IS NULL, NVL, NVL2, COALESCE

All forms of Sub-queries / Nested Queries - Multi-valued, Returning NULL, Set Comparison, Correlated, EXISTS operator, ANY & ALL operators

All forms of JOIN operations - Inner, Equijoin, Natural, Non-equijoin, Selfjoin, Outer Join operator, OUTER JOIN clause

GROUP BY clause concept - Group Functions MAX, MIN, SUM, AVG, COUNT - Group function tricky queries

Analytical / Aggregate form of Function - ROLLUP, CUBE, RANK, DENSE_RANK, DECODE vs CASE

SQL General Functions - Conversion, Numeric, String, Date functions - Query examples

Database Transaction Concepts - DML statements and forms - Rows Locking FOR UPDATE NOWAIT clause - Transaction Consistent Read SET TRANSACTION READ ONLY

SQL commands DELETE vs TRUNCATE - Difference and similarities

CREATE TABLE from scratch and copy from existing table - ALTER TABLE - Add/drop columns - Change column datatypes/widths and limitations - RENAME columns/Table

Constraint Metadata - Enable / Disable Constraint - Data Validation

Data Integrity Concepts - Data Integrity Constraints - Column / Table level constraint definitions - Referential Integrity through FOR KEY constraint

Requirements

No prior programming knowledge is required in any language. It is learn-by-doing hands-on course, so except UG level education in any branch there is no other requirement

Description

***SQL course which gained immediate popularity with the launch on UDEMY***