"Oracle 11g Training in coimbatore" is no longer available

No Reviews Yet

Tatabad, Coimbatore

Course ID: 12606

Tatabad, Coimbatore

No Reviews Yet

Date and Time

Not decided yet.

Panneer Selvam picture

About Panneer Selvam

2 Years working in Web Technology
No reviews currently Be the First to Review

About the Course

DoClick Solutions is a Software Training with Development Institute. This is the place where students can experience the knowledge of software. Here we are to take through a successful IT carrier and guide the students to enhance them to apply their software skills in real time projects. We train them to bring out the knowledge to develop projects and execute them successfully. C, C++,JAVA, J2EE, PHP,Oracle 11g, ANDROID are technologies that are applied by programmers to develop high end softwares.

Topics Covered

Introduction to DataBase
? Database Terminology
? Database Models
? Advantages of the Relational Database Model
? What is a Relational Database
? The Oracle Database
? Client/Server Configuration
Introduction to RDBMS
? Characteristics of Relational Database Management System
? CODD’s Rules
? Database Basics
? Tables, Rows and Columns
? Identifying Multiple Entities
? Modeling Relationships
? Normalization
? Introduction to Normalization
? Physical and logical database design
? Enforcing Data Integrity using Constraints
? Types of Data Integrity
? Entity Integrity
? Domain Integrity
? Referential Integrity
? Creating Keys
? Data Catalog
DATA MODELING
? The Entity Relationship Model
? Entities
? Attributes
? Types of Relationships
? Handling many-to-many Relationships
? About Normalization

INTRODUCTION TO SQL
? SQL Commands
? Data Definition Language commands (DDL)
? Data Manipulation Language commands (DML)
? Transaction Control Language Commands
? Data Control Language Commands (DCL)
? Logging onto the Database

DDL COMMANDS
? Creating a Table
? Oracle's naming convention
? Datatypes
? Contraints
? The Primary Key Constraint
? The Foreign Key Constraint
? The Not Null Constraint
? The Unique Constraint
? The Check Constraint
? The Check Constraint
? Editing the scripts
? Describe Command
? Altering a table
? Adding/dropping a Constraint
? Dropping a table
? SQL Command Files
? SQL*Plus File and Set Commands

DML COMMANDS
? Select
? Insert
? Embedding a Select into an Insert
? Update
? Delete
? Difference between Drop, Truncate, Delete


DCL COMMANDS
? Granting Privilege
? Revoking Privilege
? About Roles

BASIC QUERIES
? The Select Command
? Viewing data in a table
? Displaying Unique Values Using the Distinct Command
? Order By
? Sorting Results
? The Where Clause
? Using Comparison Operators in the Where Clause
? Using the (=,<>, !=, <, <=) Operators
? USing the Like Operator
? Wildcard Operators
? Using the IN Operator
? Using the Between...And...Operator
? Using the IS NULL Operator
? Using Logical Operators in the Where Clause
? Expressions and the Select Command
? Expressions in the Select Clause
? Column Alias
? Expressions in the Where Clause
? Expressions in the Order By Clause

SINGLE ROW FUNCTIONS
? Single Row (Scalar) Functions
? Numeric Functions
? Character Functions
? Date Functions
? Valid Date Format Elements
? Conversion Functions

GROUP FUNCTIONS (MORE ABOUT SQL)
? Group Functions
? Distinct And All
? Group By Clause
? Having Clause

JOINS
? Joins
? Types of Joins
? Simple, Multiple, Outer, and Self Joins
? Sub-queries
? Co-related subqueries
? Pairwise and Non-Pairwise Subquery
? Inline view

VIEWS
? Creating a View
? Removing a View
? Advantages of views
? Read only views and updateable views
? View with checkoption
? Materialized Views

SEQUENCES
? Creating a Sequence
? Generating Sequence Values
? Using sequences when assigning values into a table PK

TRANSACTION CONTROL COMMANDS
? Transaction
? Commit
? Rollback
? Savepoint



SET OPERATORS
? Using UNION, UNION ALL, MINUS, INTERSECT

Usage of ROWID and ROWNUM
? Using ROWID - Types of ROWID
? Using Rownum

INDEX
? Creating a Index - Unique, Non-unique
? Type of Indexes - B*tree, Bitmap, function based, reverse key
? Advantages and Disadvantages using Index

CLUSTER
? Overview of Clusters
? Types of Clusters - Index and Hash
? Usage

LOCKS
? Exclusive Locks
? Default Locking Mechanism
? Locking a set of records - For Update

Who should attend

All

Pre-requisites

Basics

What you need to bring

Notes and details

Key Takeaways

DoClick Solutions mainly focuses on Practical oriented Training. And for Nowadays based on the requirements of the SOFTWARE INDUSTRIES we make the students efficient by
Ø Communication Training(Spoken English)
Ø Aptitude Training
Ø Group Discussion
Ø Seminars
Ø Personality Development
Ø Mock Interviews
Ø Resume preparation Training
Ø Week end Test
All week end classes are taken up by Real Time Faculties who guide the students as per their Experience and make Students easier to enter in to the IT Industry.

Reviews

No reviews currently Be the First to Review

Discussions

Post your requirement and let us connect you with best possible matches for MySQL Training Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more