Signup as a Tutor

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

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

No Reviews Yet

Course type: Online Instructor led Course

Platform: webex/GotoMeeting/Skype

Course ID: 14826

Course type: Online Instructor led Course

Platform: webex/GotoMeeting/Skype

Students Interested 1 (Seats Left 0)

₹ 7,000

No Reviews Yet

Date and Time

Not decided yet.

BalvantC

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

About BalvantC

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.
No reviews currently Be the First to Review

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

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 1 (Seats Left 0)

₹ 7,000

Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now
₹ 7,000 Enquire

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