loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Oracle SQL 11g

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

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

Connect With Sathish

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

Oracle SQL 11g

Oracle SQL 11g

Online Instructor led Course

Platform: Skype

2,500

No Reviews Yet
4 Interested

About the Course


Oracle SQL 11g online classes.
Duration-20 hours.
Schedule-as per convenience of the student.
Fee-Rs. 2500

Topics Covered

1. Intro to Structure Query Language (SQL) for Analyst
SQL the language
Data Manipulation Language (DML)
Data Definition Language (DDL)
SQL*Plus the Environment
Scripting using Oracle's Procedural Language option (PL/SQL)
Overview of complete SQL SELECT syntax
2. Intro to Oracle's RDBMS Objects
Objects, Tables, Columns, Pseudo columns, Rows
Data domains, Duplicate values, Null values
Indexes, Views, Sequences, Synonyms
Declarative Constraints
Primary, Foreign, Unique keys
Check, Not Null, Default
3. Using SQL in Different Scenarios
SQL using SQL*Plus
Starting SQL*Plus
Entering and executing SQL commands
The SQL command buffer within SQL*Plus
Editors, Editing commands in the buffer
SQL*Plus commands
Set, Show, Column, Others
Using SQL*Plus Worksheet
SQL Developer
Starting iSQLPlus
Entering and executing SQL commands
4. More SQL SELECT
Arithmetic calculations
Character, Comparison, and Logical operators
WHERE clause, Pattern matching, Using SQL*Plus substitution variables
&, &&, &1
ORDER BY clause
How NULLS are processed
Multiple Columns
ASC vs. DESC
DISTINCT vs. UNIQUE
5. Single Row FUNCTIONS
What are Functions?
Analytic
Character
Numeric
Date
Conversion
Miscellaneous
6. GROUP BY Clause & Group
FUNCTIONS
What are GROUP Functions?
Aggregate (Group)
Analytic functions
COUNT(*) vs. COUNT(column_name)
SUM(), AVG(), MIN(), MAX()
VARIANCE(), STDDEV()
GROUP BY and HAVING clause
ROLLUP(), CUBE(), GROUPING()
7. Advanced Topics
Joining Tables
Subqueries
Correlated Subqueries
IF EXIST

Who should attend

Students or working professionals who want to learn RDBMS concepts and Oracle SQL as basics for pursuing DBA/Data warehouse/Business Intelligence career.

Pre-requisites

Computer/Laptop, Internet facility and headphone and mic.

What you need to bring

NA

Key Takeaways

Eligibility to write Oracle SQL 11g fundamentals-I certification.
Reviews
There are no Reviews yet. Be the First to Review
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


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

Sathish picture

Sathish

Project Manager


Database Management, Business Analytics, Project Management
Seats Left-

Students Interested 4

Course Id: 5670