Section : Welcome to the world of SQL

 

. Introduction

Section : Oracle SQL: Getting Started

 

. What is data?

. Why do we need a database and SQL?

. Install Oracle

. Install SQL developer

. Connect to DB (Why do we need Hostname, Port, SID), Users, Schemas

 

Section : Oracle SQL: Creating, Altering and Dropping the table

. Data Model for the videos

. Create table statement

. What are Data Types? (Why does Oracle expect us to provide it?)

. Create Table, Alter table, Drop Table in action

 

Section : Oracle SQL: Inserting into a table, Commit and Rollback

 

. Insert, commit and rollback (with a visual representation)

 

Section : Oracle SQL: Read data from table

 

. SELECT statement

. SELECT with WHERE clause, AND condition, OR condition (Truth Tables)

. ORDER BY clause

 

Section : Oracle SQL: Read data from table (continued..) – More

 

. LIKE (with variants), NOT LIKE, IN,NOT IN

. Relational operators, Arithmetic operators, Concatenation

. NULL Values (Scenarios where you have to be careful)

 

Section : Oracle SQL: Updates, Deletes and Truncates

 

. Update statement, Delete vs Truncate

 

Section : Oracle SQL: Pseudocolumns and Functions

 

. DUAL table (what’s the need?), Rownum 

. Functions – Lower(), Upper(), length() – empty string?,substr(), INSTR(), trim()

. Functions – nvl(), round(), floor(), to_date()/ to_char() -datatype, to_numb…

Section : Oracle SQL: Aggregate Functions

 

. (), max(), sum(), avg(), count(), common mistake with count(*)

. Group by on single/multiple columns, Having clause vs whereclause

 

Section : Oracle SQL: Joins

 

. Join  tables, Inner Join (old vs new), Left Join, Right Join, Full outer join

. Joins across multiple tables

 

Section : Oracle SQL: Views, Subqueries

 

. Views, Inline views, With clause, Subqueries

. EXISTS (vs join), NOT EXISTS, IN, NOT IN revisited

 

Section : Oracle SQL: Scalar Subqueries, UNIONs, INTERSECT

 

. Scalar Subqueries

. Union, Union All, Intersect, us

 

Section : Oracle SQL: Indexes and Constraints

 

. Indexes (Are indexes always good?

. NOT null, Unique/Primary Key constraints, Index+constraint vs Just Co…

. Check conditions, Foreign Key Constraints (& types)

 

Section : Oracle SQL: Other interesting concepts

 

. Create table as (potential use case), Insert into command

. Oracle SEQUENCES

. UPDATE from another table, MERGE from another table

. Grants and Synonyms (why both are necessary?)