SQL Training in Chennai

Career Counseling

Effective Cover Letter and Resume

Preparation for Technical Interviews

Preparation Behavioral Interviews

Techniques in Job Application

Selecting data from tables.

Selecting selective number of columns from table

table types - user table and data dictionary table

Processing Character Strings and Dates

Comparison Operators( > < >= <= = <> != ^=)

Oracle Operators

[NOT] IN

[NOT] BETWEEN .. AND

[NOT] LIKE

IS [NOT] NULL

Logical Operators

AND OR NOT

Rules of Precedence

Sorting Using ORDER BY Clause

Possition based sorting

Column Based Sorting

Sorting By Column Aliases

Sorting by Multiple Columns

NULLS FIRST and NULLS LAST

 Describe the differences between single row and multiple row functions

 Manipulate strings with character function in the SELECT and WHERE clauses

 String : UPPER( ) LOWER( ) INITCAP( )

 Character : LENGTH( ) CONCAT( ) REVERSE( )

 SUBSTR( ) INSTR( )

 LPAD( ) RPAD( ) LTRIM( ) RTRIM( )

 REPLACE( ) TRANSLATE( )

 Manipulate numbers and Dates by using

 ROUND( ) TRUNC( ) MOD( ) POWER( )

 CEIL( ) FLOOR( ) ABS( ) SIGN( )

 Date Function

 Arithmetic operation with date

 MONTHS_BETWEEN( )

 ADD_MONTHS( )

 NEXT_DAY( )

 LAST_DAY( )

 Type Conversion Function

 TO_NUMBER( )

 TO_CHAR( )

 TO_DATE( )

 General Function - To Process NULL Values

 NVL( ) NVL2( ) NULLIF( ) COALESCE( )

 Group Function / Aggregate Function

 MIN( ) MAX( ) SUM( ) AVG( ) COUNT( )

 GROUP By and HAVING Clause

 Difference Between GROUP BY and HAVING Clause

 How to use Decode and Case

 Real Time implementation

 Selecting Data from multiple tables

 Different types of Joins

 Equi Join, Outer Join (Right Outer Join, Left Outer Join, Full Outer Join),

 Slef Join, Cross Join, Natural Join

 Difference Between Equi Join and Outer Join

 Writing Join by using ANSI and Oracle Standard

 Basic Subqueries with examples

 Subquery Rules and Suggestions

 Single Row Sub Queries

 Single Row Sub Query Operators

 Multiple Row Sub Queries (IN, ANY/SOME, ALL)

 Multiple Row Sub Query operators

 Multiple Column Subqueries

 Using sub Query With all Clauses

 Scalar Sub Query

 Inline View

 Nested Sub Query

 Correlated Subqueries

 Introduction to Data Types

 Creating and Managing Tables

 CREATE , ALTER (ADD, RENAME, MODIFY and DROP), RENAME, DROP, TRUNCATE

 Creating Table by using Sub Query With Data

 Creating Table by using Sub Query Without Data

 Adding Multiple columns by using ALTER Statement

 Difference Between DROP and TRUNCATE

 INSERT, UPDATE, DELETE and MERGE

 Inserting data by using sub query

 Introduction to Constraints

 Creating constraint at the time of table creation

 Creating Constraint after Table creation

 Types of Constraints

 Adding Constraints by using ALTER Statement

 ENABLE and DISABLE Constraints

 DROPing Constraints

 GRANT and REVOKE

 Creating User

 Introduction to tablepaces

 Types of Tablespaces

 Reseting password to the schema

 Controling User Access

 Allocating space on tablespaces

 Account lock and unlock

 DROP particular user

 COMMIT, ROLLBACK and Savepoint

 TCL with DDL Statements

 Understanding the Standards of VIEWS in Oracle

 Types of VIEWS

 Relational Views

 Object Views

 Prerequisites to work with views

 Practical approach of SIMPLE VIEWS and COMPLEX VIEWS

 Column definitions in VIEWS

 Using VIEWS for DML Operations

 Creating Forced Views

 Creating view WITH CHECK OPTION and WITH READ ONLY

 Understanding Pseudo Columns in Oracle

 Types of Pseudo Columns in Oracle

 USER, UID, ROWNUM, ROWID, NEXTVAL, CURVAL, LEVEL

 NEXTVAL and CURRVAL - Sequence related Pseudocolumns

 SQL * Loader Work File

 Generating / Geting Data file (Input Datafiles)

 Creating and understanding Control file

 Bad file, Discard file and Log file

 .txt and .csv to base table

 Loading data more than one file to single table

 Understanding Partition

 Types of Partition(LIST, RANGE, and Composite)

 Sub Partition

 ADD, DROP, RENAME and EXCHANGE Partition

  Introduction to PL/SQL

  Benefits of PL/SQL

  Creating PL/SQL Blocks

  Using Variables in PL/SQL

  Recognizing PL/SQL Lexical Units

  Recognizing Data Types

  Using Scalar Data Types

  Writing PL/SQL Executable Statements

  Nested Blocks and Variable Scope

  Good Programming Practices

  Review of SQL DML

  Retrieving Data in PL/SQL

  Manipulating Data in PL/SQL

  Using Transaction Control Statements

  Conditional Control: IF Statements

  Conditional Control: CASE Statements

  Iterative Control: Basic Loops

  Iterative Control: WHILE and FOR Loops

  Iterative Control: Nested Loops

  Introduction to Explicit Cursors

  Using Explicit Cursor Attributes

  Cursor FOR Loops

  Cursors with Parameters

  Using Cursors for UPDATE

  Using Multiple Cursors

  User-Defined Records

  Indexing Tables of Records

  Handling Exceptions

  Trapping Oracle Server Exceptions

  Trapping User-Defined Exceptions

  Recognizing the Scope of Exceptions

  Creating Procedures

  Using Parameters in Procedures

  Passing Parameters

  Creating Functions

  Using Functions in SQL Statements

  Review of the Data Dictionary

  Managing Procedures and Functions

  Review of Object Privileges

  Using Invoker's Rights and Autonomous Transactions

  Creating Packages

  Managing Package Concepts

  Advanced Package Concepts

  Persistent State of Package Variables

  Using Oracle-Supplied Packages

  Using Dynamic SQL

  Improving PL/SQL Performance

  Introduction To Triggers

  Creating DML Triggers, Part I

  Creating DML Triggers, Part II

  Creating DDL and Database Event Triggers

  Managing Triggers

  Introduction to Dependencies

  Understanding Remote Dependencies

  Using PL/SQL Initialization Parameters

  Displaying Compiler Warning Messages

  Using Conditional Compilation

  Hiding Your Source Code