Signup as a Tutor

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

Oracle SQL 11g - Fundamentals

3 Reviews

Course type: Online Self Paced Class

Course ID: 18982

Course type: Online Self Paced Class

11 Chapters

51 Video Lectures

Students Interested 0

Students Attending 0

₹ 5,900

3 Reviews

Batch 1

Date : 13 Dec, 17 - 20 Dec, 17

Timings : 11:09 PM-11:09 PM

Seats Left : 10000

Students Interested : 0

Students Attended : 0

Register

Have a Question? Enquire Now

Parallel Branch

Experienced Trainers

About Parallel Branch

Parallel Branch
G

Gary Bacchetti

Attended Oracle SQL 11g - Fundamentals

It is very simple and easy to follow

C

Carl Picôt

Attended Oracle SQL 11g - Fundamentals

Nicely put together and great content...highly recommended for sure

S

Sue LaBelle

Attended Oracle SQL 11g - Fundamentals

This is a first for me, I haven’t studied online before. I took up the SQL course and sailed through it. It is fun and without any distractions, I was able to understand and practice the concepts really well. Time just flew.

About the Course

At the end of this course, you will get the knowledge of...

How to write SQL queries to access data stored in an Oracle Database schema. Learn to manipulate data and use various types of functions for customizing data output.

You will learn essential SQL skills that allow developers to write queries against single and multiple tables, manipulate data in tables, and create database objects.

Learn to use single row functions to customize output, use conversion functions and conditional expressions

Topics Covered

Introduction to SQL DURATION – 25 Minutes
Writing Basic SQL SELECT Statements DURATION – 30 Minutes
Restricting and Sorting Data DURATION – 45 Minutes
Single Row Functions DURATION – 110 Minutes
Aggregating Data Using Group Functions DURATION – 30 Minutes
Constraints DURATION – 45 Minutes
Displaying Data from Multiple Tables – 60 Minutes
Sub-Queries DURATION – 30 Minutes
Producing Readable Output with SQL*Plus – 60 Minutes
Manipulating Data DURATION – 75 Minutes
Creating and Managing Tables DURATION – 60 Minutes

Who should attend

Beginners.
Fresh Graduates.

Pre-requisites

Windows PC, Good Internet Connectivity and Basic database knowledge

Key Takeaways

Highly interactive self paced course contents supplemented with demonstrations.
Designed and developed by Subject Matter Experts.

Curriculum for this Course

  • Chapter 1 : Lesson5

    • Introduction to SQL 5.27
    • SQL Statements 2.28
    • Introduction to SQL *Plus 6.62
    • Tables used in the Course 2.68
    • Demonstration on how to login to SQL*Plus and Describe the tables used in the course? 7.03
  • Chapter 2 : Lesson7

    • SQL SELECT Statements 6.22
    • Expressions 8.28
    • Null Value 1.42
    • Column Alias 1.8
    • Concatenation Operator 1.92
    • Literal Character Strings 1.55
    • Duplicate Rows 0.83
  • Chapter 3 : Lesson6

    • Limiting the rows 5.85
    • Other Comparison Conditions 6.75
    • Logical Conditions 4.23
    • Precedence 3.67
    • Sorting the Data 4.85
    • Practical Demonstration on Restricting and Sorting Data 19.97
  • Chapter 4 : Lesson7

    • SQL Functions 5.27
    • Character Functions 16.93
    • Number Functions 6.03
    • Date Functions 13.27
    • Conversion Functions 25.53
    • RR Date Format and Nesting Functions 6.92
    • Practical Demo on the above lessons 41.35
  • Chapter 5 : Lesson4

    • Group Functions 13.12
    • Creating Groups of Data 4.23
    • Excluding Group Results 2.88
    • Practical Demo on the above lessons 14.05
  • Chapter 6 : Lesson4

    • Introduction to Constraints 15.9
    • Applying Constraints 7.23
    • Adding, Dropping, Viewing, Enabling, Disabling a Constraint, Cascading Constraints 9.65
    • Practical Demo on the above lessons 12.9
  • Chapter 7 : Lesson4

    • Introduction to Sub-Queries 6.08
    • Introduction to Oracle Proprietary Joins and using them 18.27
    • Understanding SQL 1999 Compliant Joins and Using them 14.75
    • Practical Demo on the above lessons 16.75
  • Chapter 8 : Lesson1

    • Types of Sub queries 9.5
    • Practical Demo on the above lessons 10.72
    • Introduction to Sub-Queries 13.93
  • Chapter 9 : Lesson3

    • Substitution Variables 21.85
    • Format Commands used in SQL*Plus 21.78
    • Practical Demo on the above lessons 18.1
  • Chapter 10 : Lesson4

    • Inserting, Deleting, Updating and Merging Data 15.55
    • Database Transactions 30.58
    • Locks 19.13
    • Practical Demo on the above lessons 15.32
  • Chapter 11 : Lesson4

    • Database Object: Table 6.42
    • Data Types 45.53
    • Creating, Altering, Renaming, Truncating, Dropping a Table and Marking Columns as UNUSED 11.38
    • Practical Demo on the above lessons 7.48

Reviews (3) See all Reviews

G

Gary Bacchetti

Attended Oracle SQL 11g - Fundamentals

It is very simple and easy to follow

C

Carl Picôt

Attended Oracle SQL 11g - Fundamentals

Nicely put together and great content...highly recommended for sure

S

Sue LaBelle

Attended Oracle SQL 11g - Fundamentals

This is a first for me, I haven t studied online before. I took up the SQL course and sailed through...

Discussions

11 Chapters

51 Video Lectures

Students Interested 0

Students Attending 0

₹ 5,900

Register

Have a Question? Enquire Now

Post your requirement and let us connect you with best possible matches for IT Courses Post your requirement now
₹ 5,900 Register

Enquire

Submit your enquiry for Oracle SQL 11g - Fundamentals

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

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