Signup as a Tutor

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

Oracle SQL 11g

No Reviews Yet

Course type: Online Instructor led Course

Platform: Skype

Course ID: 5670

Course type: Online Instructor led Course

Platform: Skype

Students Interested 4 (Seats Left 0)

₹ 2,500

No Reviews Yet

Date and Time

Not decided yet.

Sathish picture
Sathish

Project Manager

14 Years of Experience

About Sathish

Database Management, Business Analytics, Project Management
No reviews currently Be the First to Review

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

No reviews currently Be the First to Review

Discussions

Students Interested 4 (Seats Left 0)

₹ 2,500

Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now
₹ 2,500 Enquire

Enquire

Submit your enquiry for Oracle SQL 11g

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 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