loading......

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Professional Training on Oracle DBMS SQL

Please enter valid question or comment

Please select a category

No matching category found.

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 3RI Technologies

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

Share

Professional Training on Oracle DBMS SQL

Professional Training on Oracle DBMS SQL

Pimple Saudagar, Pune

1 Reviews
0 Interested

About the Course


We have designed this course specially for people who are interested to change their work domain or either they want to become a good Database Administrator in Oracle DBMS.

Topics Covered

1. Writing Basic SQL SELECT Statements
• SQL Overview
• Arithmetic Expressions
• NULL Value
• Column Alias
• Concatenation Operator
• Literals
• Eliminating Duplicate Rows
2. Restricting and Sorting Data
• WHERE clause
• Logical Operators
• SQL Operators
• LIKE Operator
• AND, OR and NOT Operators
• ORDER BY Clause
3. Row Functions
• Character Functions
• Number Functions
• Date Functions
• Conversion Functions
• General Functions
4. Displaying Data from Multiple Tables
• Types of Joins in Oracle
• SQL Joins
5. Aggregating Data Using Group Functions
• Group Functions
• Group By Clause
• HAVING Clause
6. Subqueries
• Single Row subqueries
• Multiple Row Subqueries
• Correlated Subqueries
7. Manipulating Data
• INSERT Statement
• UPDATE Statement
• DELETE Statement
• MERGE Statement
• Transaction Control
• Locks
8. Creating and Managing Tables
• Data Definition Language
• Data Types
• CREATE TABLE Statement
• ALTER TABLE Statement
• Rename an Object
• Comments
9. Including Constraints
• Primary Constraints
• FOREIGN KEY Constraint
• NOT NULL Constraint
• UNIQUE Constraint
• CHECK Constraint
• ALTER statement
• Dropping a constraint
• Disabling Constraints
• Enabling Constraints
• Cascading Constraints
• Viewing Constraints
10. Views
• Creating a View
• Retrieving Data from a View
• Modifying a View
• Destroying a View
• User?View
11. Other Database Objects
• Sequence
• Index
• Synonyms
12. Controlling User Access
• Privileges
• System Privileges
• Object Privileges
• Role
13. Using SET Operators
• UNION Operator
• UNION ALL Operator
• INTERSECT Operator
• MINUS Operator
14. Oracle Datetime Functions
• Oracle 9i Date time Support
• CURRENT_DATE
• CURRENT_TIMESTAMP
• LOCALTIMESTAMP
• DBTIMEZONE and SESSIONTIMEZONE
• EXTRACT
• FROM_TZ
• TO_TIMESTAMP and TO_TIMESTAMP_TZ
• TO_YMINTERVAL & TZ_OFFSET

Who should attend

• Freshers to make their career into IT / Software Field.
• BPO guys, people who are working in different fields and want to become a DBA.

Pre-requisites

• Computer Fundamentals
• Knowledge of programming techniques would be an advantage

What you need to bring

We will provide you all the necessary things to learn the C Programming language, you don't need to bring anything with you for this course.""

Key Takeaways

• RDMBS knowledge
• Way to proceed for the next step which is Oracle DBA.
• Way to proceed for PLSQL.
Reviews

Recommendations & reviews from previous Customers:

Tanmay

"I took training of Oracle SQL from 3ri technologies.The trainer was really helpful.Covered all the topics as they promised. Ritesh sir gave in-depth knowledge of the topics.Good job! I recommend 3ri to those who are looking for SQL training. "

attended Professional Training on Oracle DBMS SQL


Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


Recommendations & reviews from previous Customers:

Tanmay

"I took training of Oracle SQL from 3ri technologies.The trainer was really helpful.Covered all the topics as they promised. Ritesh sir gave in-depth knowledge of the topics.Good job! I recommend 3ri to those who are looking for SQL training. "

attended Professional Training on Oracle DBMS SQL


Date and Time

Not decided yet.

About the Trainer


We have almost 25 trainers with us for all different technologies, we have associated with so many people in the IT industry who actually works on the real time projects have may years of expertise experience, they share their knowledge as a KT sessions or visiting faculty.
Seats Left-

Students Interested 0

Course Id: 14444