Course Details

The Course Details for SQL are as below: Session 1: Introduction to SQL  - 2 hours What is Database? Relational Database Management system Normalization Datatypes in Oracle Create table Viewing tables(Select) Eliminating Duplicate Rows Sorting Data in Table Creating table from another table Inserting data in table from another table Delete Operations Updating content of table Modifying structure of table Renaming table Truncating table Destroying table Creating synonyms Session 2: Data Constraints and computation  - 2 hours Data Constraints:   Primary key constraint Unique key constraint Foreign key constraint Check constraint Column level constraint Table level constraint Computations: Arithmetic operator Logical operator Range searching Pattern matching Use of like operator Dual table concept Session 3: Functions in SQL, Grouping and Sub Queries - 4 hours Functions: Aggregator Function Numeric Function String Function Conversion Function Scalar Function Group Function Date Conversion Function Grouping Data: Group By Clause Having Clause Rollup Operator Cube Operator Partition By function ​Sub Queries: Subquery in FROM clause Correlated Subqueries Multi column subqueries Sub-query in case expression Sub-query in ORDER BY clause Exist and Not Exist Operator Session 4: Joins - Gathering data from multiple tables - 2 hours Joins: Inner Join Outer Join (Left, Right, Full) Cross Self Join Data from multiple table Union Intersect Minus Session 5: Performance tuning and security management - 2 hours Performance Tuning Indexes Multiple Indexes Row_id Row_num Views Clusters Cluster Indexes Security Management: Granting and Revoking Permissions