www.training.allianceit.in Alliance Softech Pvt Ltd New Delhi : Oracle SQL Training

[MariPriya]

Name Of the Institute : Alliance Softech Pvt Ltd (training.allianceit.in)
Location Of The Training Institute : Guwahati
Training Offered : Oracle SQL and PLSQL Training

http://training.allianceit.in/toc1.aspx?ID=1

Technology: Oracle SQL and PLSQL
Duration: 5 Days
Target Audience :
Engineering Graduates who are ready to join a company and work.

TOC:
Oracle: SQL and PL/SQL
Writing Basic Oracle SQL Select Statements
· List the capabilities of SQL SELECT statements
· Execute a basic SELECT statement
· Differentiate between SQL statements and iSQL*Plus commands

Restricting and Sorting Data
· Limit the rows retrieved by a query
· Sort the rows retrieved by a query

Single-Row Functions
· Describe various types of functions available in Oracle SQL
· Use character, number, and date functions in SELECT statements
· Use conversion functions in Oracle

Displaying Data from Multiple Tables
· Write SELECT statements to access data from more than one table using equality and nonequality joins
· View data that generally does not meet a join condition by using outer joins in Oracle Database
· Join a table to itself using a self-join

Aggregating Data using Group Functions
· Identify the available group functions
· Use group functions
· Group data using the GROUP BY clause
· Include or exclude grouped rows by using the HAVING clause

Using Subqueries
· Describe the types of problems that subqueries can solve
· Define subqueries
· List the types of subqueries
· Produce queries that require a substitution variable
· Produce more readable output
· Create and execute script files

Manipulating Data
· Describe each DML statement in Oracle Database
· Insert rows into a table
· Update rows in a table
· Delete rows from a table
· Merge rows in a table
· Control transactions

Creating and Managing Tables
· Describe the main database objects
· Create tables
· Describe the datatypes that can be used when specifying column definition
· Alter table definitions
· Drop, rename and truncate tables

Including Constraints
· Describe constraints
· Create and maintain constraints
Creating Views in Oracle Database
· Describe a view
· Create, alter the definition, and drop a view
· Retrieve data through a view
· Insert, update and delete data through a view
· Create and use an inline view
· Perform Top 'N' Analysis
Creating Other Oracle Database Objects
· Create, maintain and use sequences
· Create and maintain indexes
· Create private and public synonyms
Controlling User Access
· Create Oracle users
· Create Roles to ease setup and maintenance of the security model
· Use the GRANT and REVOKE statements to grant and revoke object privileges
Triggers
· Beyond Declarative Integrity
· Triggers
· Types of Triggers
· Row-Level Triggers
· Cascading Triggers and Mutating
· Tables
· Generating an Error
· Triggers on Views
· System Triggers
· Maintaining Triggers
Payment Terms:
1. 25% Advance along with the Purchase Order if the training is delivered for the first time. No Advance if it is a repeat training for the same company.
2. Full/Balance payment within 20 Days of the Successful completion of the training.
3. Successful training means a feedback of 3.5 on 5.0 or more.
4. All legal matters subject to Delhi Jurisdiction.

Contact Us
Alliance Softech Pvt Ltd
S-8,Malik Buildcon Plaza-2, Plot No-6, Sector-12, Dwarka,
New Delhi- 110075

[Guest]

I would like to do course of Oracle. Could you provide me Alliance Softech Pvt Ltd office address of Guwahati?

You can get the contact details in the below link
http://www.allianceit.in/contact.php