Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Oracle 11g Training in coimbatore

No Reviews Yet

Tatabad, Coimbatore

Course ID: 12606

Tatabad, Coimbatore

Students Interested 0 (Seats Left 0)

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

Students Interested 0 (Seats Left 0)

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

Enquire

Submit your enquiry for Oracle 11g Training in coimbatore

Please enter valid question or comment

Please select a category

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Doclick Solutions

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer