Welcome to the world of SQL
  • Introduction
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
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
Oracle SQL: Inserting into a table, Commit and Rollback
  • Insert, commit and rollback (with a visual representation)
Oracle SQL: Read data from table
  • SELECT statement
  • SELECT with WHERE clause, AND condition, OR condition (Truth Tables)
  • ORDER BY clause
Oracle SQL: Read data from table (continued..) - More complex operations
  • LIKE (with variants), NOT LIKE, IN, NOT IN
  • Relational operators, Arithmetic operators, Concatenation
  • NULL Values (Scenarios where you have to be careful)
Oracle SQL: Updates, Deletes and Truncates
  • Update statement, Delete vs Truncate
Oracle SQL: Pseudocolumns and Functions
  • DUAL table (what's the need?), Rownum (why doesn't it work sometimes), Sysdate
  • Functions - Lower(), Upper(), length() - empty string?,substr(), INSTR(), trim()
  • Functions - nvl(), round(), floor(), to_date()/ to_char() -datatype, to_number()
Oracle SQL: Aggregate Functions
  • min(), max(), sum(), avg(), count(), common mistake with count(*)
  • Group by on single/multiple columns, Having clause vs whereclause
Oracle SQL: Joins
  • Join 2 tables, Inner Join (old vs new), Left Join, Right Join, Full outer join
  • Joins across multiple tables
Oracle SQL: Views, Subqueries
  • Views, Inline views, With clause, Subqueries
  • EXISTS (vs join), NOT EXISTS, IN, NOT IN revisited
Oracle SQL: Scalar Subqueries, UNIONs, INTERSECT, MINUS
  • Scalar Subqueries
  • Union, Union All, Intersect, Minus
Oracle SQL: Indexes and Constraints
  • Indexes (Are indexes always good?)
  • NOT null, Unique/Primary Key constraints, Index+constraint vs Just Constraint
  • Check conditions, Foreign Key Constraints (& types)
Oracle SQL: Other interesting concepts
  • Create table as (potential use case), Insert into commands
  • Oracle SEQUENCES
  • UPDATE from another table, MERGE from another table
  • Grants and Synonyms (why both are necessary?)
What next?
  • What next?