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

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid 10 digit Phone Number

Note: Please enter the phone number that you want to receive a call on.

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

Share

course photo

Oracle SQL 11g - Fundamentals

Online Self Paced Class

5,900
3 Reviews
0 Interested

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

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

Recommendations & reviews from previous Customers:

Gary Bacchetti

"It is very simple and easy to follow"

attended Oracle SQL 11g - Fundamentals


Carl Picôt

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

attended Oracle SQL 11g - Fundamentals


Sue LaBelle

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

attended Oracle SQL 11g - Fundamentals


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:

Gary Bacchetti

"It is very simple and easy to follow"

attended Oracle SQL 11g - Fundamentals


Carl Picôt

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

attended Oracle SQL 11g - Fundamentals


Sue LaBelle

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

attended Oracle SQL 11g - Fundamentals


Content

11 Chapters

51 Video Lectures

digital certificate Get Digital Certificate after course completion

cash back LifeTime Access. No Limits!

cash back100% Money Back Guarentee

About the Trainer

Parallel Branch

Experienced Trainers


Parallel Branch

Students Interested 0

Students Attending 0

100% Money Back
Guarentee
Call at 080-46614806
to book on phone

Course Id: 18982