SQL:

Duration: 30-35 classes

Regular Batch: Monday to Friday(1hr per day)

Fast-track Batch: as per student requirements

Course Highlights::

Classes are taught by expert instructors

Interactive classes with live atmosphere

One or two demo classes before batch starts

Additional assistance:

Career guidance workshop

Mock/Practice interview session conducted by industry experts

Resume preparation and corrections

Email follow ups and many more

RDBMS CONCEPTS

Introduction to DBMS

Data Information

Data Models

Codd Rules

Entity

Attribute

Relations

Normalisation

SQL * PLUS

Introduction to Oracle SQL

Basic Elements of SQL

Datatypes

Database objects

Schema

Creating & Formatting SQL *PLUS Reports

SQL STATEMENTS

DDL statements

Creating/Altering Tables

Integrity Constraints

Insert data

Views

Sequences

DML statements

Update data

Delete data

Commit

Rollback

Savepoint

TCL statements

Grant

Revoke

CONSTRAINTS

Not Null

Unique

Primary Key

Foreign Key

Check

FUNCTIONS & OPERATORS

Arithmetic

Text

Date

Group

SQL QUERIES & SUBQUERIES

1. Joins

2. Equi Join

3. Non Equi Join

4. Outer Join

5. Self Join

6. Subqueries

7. Single Row Subquery

8. Multiple Row Subquery

9. Correlated Subquery

OBJECTS

Views (Simple , Complex and Read only)

Sequences

Synonyms

Indexes

DUAL table

Data Dictionary

 

COURSE CATALOG

DATABASES
DATA WAREHOUSING
SAP
MS DYNAMICS
JAVA
OPERATING SYSTEMS
WEB DEVELOPMENT
HYPERION
DATABASE ADMINISTRATION
SAS
.NET

COURSE ENQUIRY FORM