SQL TRAINING
SQL Class curriculum
Day 1
- Introduction to the rdbms relational database management system.
- Oracle Database as platform.
- Application of the SQL.
- Writing simple select statements
- Data types in oracle.
- Arithmetic Operators
- Set Operators
- Concatenation Operators.
- Column Alias Names
- Using Distinct or Unique Clause
- Limiting Rows
- Comparison Operators (Equality) =, !=, <>, or ^= Inequality, < less than, > more than, <= (less than or equal to), >= (greater than or equal to), any or some , all.
- Logical Operators. ( not, or and ).
- Other Operators ( IN and NOT IN, BETWEEN, EXISTS, IS NULL, IS NOT NULL, LIKE )
- Pattern matching with like command.
- Sorting rows with order by clause.
- Using Expressions.
- The Case Expression.
- Single row functions
- Aggregate Functions
Day 2
- Join and Sub-queries
- Simple Table Join
- Complex Join
- Multi-table Join
- Cartesian Join
- Outer Join
- Inner Join
- Left Join
- Right Join
- Other Multiple Table Queries
- Sub-queries
- Single-Row Subqueries
- Multiple row subqueries
- Correlated Subqueries
- Scalar Subqueries
- Multiple-Column Subqueries
- Modifying Data
- Inserting rows in the tables
- Updating rows in the table
- Deleting rows from a table
- Truncating a Table
Day 3
- Tables and Constraints
- Data types
- Creating Tables
- Naming Tables and Columns
- Specifying default values to columns
- Adding Comments
- Creating table from another table
- Modifying Tables
- Adding Columns
- Modifying Columns
- Dropping Columns
- Dropping Tables
- Renaming Tables
- Constraints
- Types of Constraints
- Dropping Constraints
- Enabling and Disabling Constraints
- Views
- Creating and modifying views
- Using views
- Using views in queries
- Inline views
- Sequences
- Indexes
- Types of indexes
- Synonyms