Course Details

DBMS: Oracle SQL SQL is the basic fundamentals to deal with any Database Management System, it gives the understanding of database entity, data normalization and the basic functions which is been used in any DBMS. Oracle SQL is one of the best available DBMS which further separated in to two different tracks i.e. PLSQL in development track and DBA in Administration track. It is useful for any Programmer or Tester to get a better understanding of their work and technology. Prerequisites Basic computer Fundamental skills Duration of Course : 40 Hours Training Highlights : This course will give student maximum exposure to Oracle SQL as we cover all the topics as per course contents of Oracle corporation. Best trainers having IT Industry experience and they provide knowledge by giving real time examples, specially from Banking domain. Plenty of exercise material will be provided to the student to gain maximum exposure. Assistance will be provided for Oracle certification. Flexibility in batch timing for candidates working in shifts.   Course Content 1. Writing Basic SQL SELECT Statements SQL Overview Arithmetic Expressions NULL Value Column Alias Concatenation Operator Literals Eliminating Duplicate Rows   2. Restricting and Sorting Data WHERE clause Logical Operators SQL Operators LIKE Operator AND, OR and NOT Operators ORDER BY Clause   3. Row Functions Character Functions Number Functions Date Functions Conversion Functions General Functions   4. Displaying Data from Multiple Tables Types of Joins in Oracle SQL Joins   5. Aggregating Data Using Group Functions Group Functions Group By Clause HAVING Clause   6. Subqueries Single Row subqueries Multiple Row Subqueries Correlated Subqueries   7. Manipulating Data INSERT Statement UPDATE Statement DELETE Statement MERGE Statement Transaction Control Locks   8. Creating and Managing Tables Data Definition Language Data Types CREATE TABLE Statement ALTER TABLE Statement Rename an Object Comments 9. Including Constraints Primary Constraints FOREIGN KEY Constraint NOT NULL Constraint UNIQUE Constraint CHECK Constraint ALTER statement Dropping a constraint Disabling Constraints Enabling Constraints Cascading Constraints Viewing Constraints   10. Views Creating a View Retrieving Data from a View Modifying a View Destroying a View User‐View   11. Other Database Objects Sequence Index Synonyms   12. Controlling User Access Privileges System Privileges Object Privileges Role   13. Using SET Operators UNION Operator UNION ALL Operator INTERSECT Operator MINUS Operator