UrbanPro
true

Oracle SQL Classes

LIVE
1 review
25 Hours

Course offered by Bhavna Philipose

10 reviews

What you will Learn
Understand SQL statements, as well as the Oracle Relational Database.
Use SQL Developer.
Write reports using SQL statements.
Manipulate data in relational tables and save the data.
Understand the concepts of relational databases and the powerful SQL programming language.
Write reports using SQL Statements
Course Objectives
Define the goals of the course
List the features of Oracle Database 10,11g,12c
Discuss the theoretical and physical aspects of a relational database
Describe Oracle serverâ??s implementation of RDBMS and object relational database management system (ORDBMS)
Identify the development environments that can be used for this course
Describe the database and schema used in this course
Required Prerequisites
Familiarity with data processing concepts and techniques
Familiarity with programming languages desired but not mandatory.

 

Set Up and Installation Details
For Online Session â?? Internet required
Oracle Training will be provided On Windows Platform
Either 32x/64x
Snapshots on How to get the Oracle Database s/w with SQL developer from the oracle website will also be shared with Snapshots, post registration process.
Registration Process Details
You need to call the Trainer, Confirm your Time Slots
Trainer will confirm availability in a mail
Post which you have to pay 100% fees ( Not refundable, unless training cannot happen)
All communication will be done on Mail.
Course Coverage Details Session Wise breakup

 

Relational Database:
- Relationships
- E R Diagrams
- Normalization
- Capabilities of SQL SELECT statements with their functionalities
- SQL statement that includes an arithmetic expression
- Assign an alias to a column heading when retrieving data from a table

Sorting and Filtering Data:
- Query that restricts rows returned by using the WHERE clause
- Comparison operators with the WHERE clause
- Use of IN, LIKE & BETWEEN Operator
- Manipulating NULL values
- Query with logical operators
- ORDER BY Clause
- Sorting Data in Ascending and Descending
- Sorting Data with multiple Columns

Single Row Function and Group Function:
- Introduction to Character, Numeric & Date Functions
- Introduction to Group Function
- Implementing GROUP BY Clause in Select Statement
- Manage NULL values in Group Functions
- Restrict groups of rows retrieved by using HAVING Clause
- Identify illegal queries involving in group functions
- Nested Group Functions

Joins:
- Introduction to Join
- Retrieving Data from more than one table
- Using Joins with Column alias
- Joining tables using JOIN operator and ON Clause
- Types of Joins
- Implementing Joins for Unmatched values SubQuery
- Requirements for using subqueries
- Single-row subquery to return one row in the WHERE clause
- Single-row subquery with HAVING clause
- Common errors that occur when using single-row subquery
- multiple-row subquery using the IN, ALL, ANY operator
- Subquery with NULL Operator
- Pairwise and Non-Pairwise subquery
Database Objects and Transactions
- DDL - Create / Alter / Drop / Rename / Truncate
- DML - Insert / Update / Delete / Select
- TCL - Commit / Rollback / Savepoint
- DCL - Grant & Revoke
Creating Tables with Constraints
- Constraints in Tables
- Usage of Constraints in Tables
- Constraints and their types
- Column level and Table level constraints

 

For Oracle Certification Course Topics See my course Title 

Database SQL 1Z0-071-Certification-Track-Course-30hrs

 

For Further Queries You can Email , Sms , Call me on the Contact Information on my profile.

I keep rolling out batches on request, so you may want to register and Join.

Gallery (7)

Intro Video

About the Trainer

Bhavna Philipose picture

4.9 Avg Rating

10 Reviews

108 Students

14 Courses

Bhavna Philipose

Microsoft Certified Professtional

15 Years of Experience

Corporate IT Trainer
More Than 19+ Years in the IT Industry.
Trained More than 10000+ Students all over India.
Currently Taking Corporate as well as Retail and personal Coaching for Students at home.
Please Check my UrbanPro Intro Video for more details on my profile

Students also enrolled in these courses

LIVE
74 reviews
24 Hours

Course offered by Umasankar Natarajan

256 reviews
LIVE
74 reviews
24 Hours

Course offered by Umasankar Natarajan

256 reviews
LIVE
74 reviews
24 Hours

Course offered by Umasankar Natarajan

256 reviews
LIVE
74 reviews
24 Hours

Course offered by Umasankar Natarajan

256 reviews

Reviews (1)

5 out of 5 1 review

Bhavna Philipose https://p.urbanpro.com/tv-prod/member/photo/448681-small.png Kalyan Nagar HRBR Layout
5.0051
Bhavna Philipose
S

SQL Programming

"To start with, the Trainer is really very knowledgeable person & having very good experience, way of making you learn is superb, will teach you from the scratch & basics. The trainer will listen to all your requirement & help you in betterment for your career. All the best for your classes & i recommend 5 out of 5 to this Trainer. "

Reply by Bhavna

Thank you Srinivas , Good Luck for your future Prospects.Appreciate the Same.

View All
Have you attended any class with Umasankar?

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

5 out of 5 1 review

Bhavna Philipose https://p.urbanpro.com/tv-prod/member/photo/448681-small.png Kalyan Nagar HRBR Layout
5.0051
Bhavna Philipose
S

SQL Programming

"To start with, the Trainer is really very knowledgeable person & having very good experience, way of making you learn is superb, will teach you from the scratch & basics. The trainer will listen to all your requirement & help you in betterment for your career. All the best for your classes & i recommend 5 out of 5 to this Trainer. "

Reply by Bhavna

Thank you Srinivas , Good Luck for your future Prospects.Appreciate the Same.

Have you attended any class with Umasankar?

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Oracle SQL Classes by Bhavna Philipose

Bhavna Philipose picture
LIVE
(1 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Oracle SQL Classes by Bhavna Philipose

Bhavna Philipose picture
LIVE
(1 reviews)

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 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 7.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