Enquire

Submit your enquiry for Oracle Database 11g: SQL Fundamentals I(1Z0-051)

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

course photo

Oracle Database 11g: SQL Fundamentals I(1Z0-051)

Online Instructor led Course

Platform: webex/GotoMeeting/Skype

7,000

No Reviews Yet
1 Interested

About the Course


Online Course, this will allow you to appear for OCA certification. Exam 1Z0-051 Oracle Database 11g: SQL Fundamentals I

Topics Covered

Retrieving Data Using the SQL SELECT Statement

List the capabilities of SQL SELECT statements
Execute a basic SELECT statement

Restricting and Sorting Data

Limit the rows that are retrieved by a query
Sort the rows that are retrieved by a query
Use ampersand substitution to restrict and sort output at runtime

Using Single-Row Functions to Customize Output

Describe various types of functions available in SQL
Use character, number, and date functions in SELECT statements

Using Conversion Functions and Conditional Expressions

Describe various types of conversion functions that are available in SQL
Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
Apply conditional expressions in a SELECT statement

Reporting Aggregated Data Using the Group Functions

Identify the available group functions
Describe the use of group functions
Group data by using the GROUP BY clause
Include or exclude grouped rows by using the HAVING clause

Displaying Data from Multiple Tables

Write SELECT statements to access data from more than one table using equijoins and nonequijoins
Join a table to itself by using a self-join
View data that generally does not meet a join condition by using outer joins
Generate a Cartesian product of all rows from two or more tables

Using Subqueries to Solve Queries

Define subqueries
Describe the types of problems that the subqueries can solve
List the types of subqueries
Write single-row and multiple-row subqueries

Using the Set Operators

Describe set operators
Use a set operator to combine multiple queries into a single query
Control the order of rows returned

Manipulating Data

Describe each data manipulation language (DML) statement
Insert rows into a table
Update rows in a table
Delete rows from a table
Control transactions

Using DDL Statements to Create and Manage Tables

Categorize the main database objects
Review the table structure
List the data types that are available for columns
Create a simple table
Explain how constraints are created at the time of table creation
Describe how schema objects work

Creating Other Schema Objects

Create simple and complex views
Retrieve data from views
Create, maintain, and use sequences
Create and maintain indexes
Create private and public synonyms

Who should attend

Any one interested to explore field of Database and Development.

Pre-requisites

English,basic computer literacy.

What you need to bring

Below is per-requisite:

You need to have
=>your own desktop/Laptop at least 2GB and dual core or 3rd generation procession, at least 100GB Disk space.
=>Internet access to attend online Instructor let course using Webex/Goto meeting."

Key Takeaways

After completing this course, you would be ready to work as Oracle developer DBA and You would be able to pass exam Exam 1Z0-051 Oracle Database 11g: SQL Fundamentals I
Content
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.

cash back100% Money Back Guarentee

About the Trainer

BalvantC

MCA, BSC(Phy), Oracle Certified Professional DBA 11g,10g,9i, Oracle Certified Expert 11g RAC


Total 15+ Years of Oracle DBA experience in India and USA and worked with mostly fortune 100 clients.

Initial years of my career, I worked as Oracle developer DBA and working as core DBA for last 6 years.

I have expertise on Oracle 11g, 10g,9i, Administration, Backup Recover, ASM, GRID, RAC, Linux, Standby database, disaster recovery, Exadata, Performance tuning.
Seats Left-

Students Interested 1

Course Id: 14826