Oracle SQL 11g + Oracle Apps R12 DBA

Learn Oracle SQL 11g,Oracle Apps R12 Architecture & Installations, Patching, Cloning,Administration and Troubleshooting
4.4 (26 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
476 students enrolled
$25
Take This Course
  • Lectures 79
  • Contents Video: 20 hours
  • Skill Level Expert Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 2/2014 English

Course Description

==============================================================

EXTREMELY USEFUL TO UNDERSTAND THE SQL AND DBA CONCEPTS

===============================================================

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

Oracle Applications R12 Overview, Oracle Applications Components, Oracle Applications Architecture & Installations, Oracle Applications Administration, Oracle Applications Patching,Cloning,Monitoring and Troubleshooting.

What are the requirements?

  • Windows PC, Good Internet Connectivity and Basic database knowledge

What am I going to get from this course?

  • In this course, you will learn fundamentals of SQL Programming Language.
  • In this course, you will learn about architecture of oracle applications.
  • In this course, you will learn about components of oracle applications.
  • In this course, you will learn about how to install oracle applications.
  • In this course, you will learn about patching and cloning of oracle applications
  • In this course, you will learn about how to administrate oracle applications
  • In this course, you will learn about how to monitor and troubleshoot oracle applications.

What is the target audience?

  • Beginners
  • Graduates
  • Oracle DBA
  • Oracle Technical/Functional Consultants

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Oracle SQL 11g : Introduction to SQL
Introduction to SQL
Preview
05:16
SQL Statements
Preview
02:16
Introduction to SQL *Plus
Preview
06:36
Tables used in the Course
02:40
Demonstration
07:01
Quiz
4 questions
Section 2: Oracle SQL 11g : Creating and Managing Tables
Database Object: Table
06:24
Data Types
45:31
Creating, Altering, Renaming, Truncating, Dropping a Table
11:22
Demonstration
07:28
Quiz
5 questions
Section 3: Oracle SQL 11g : Writing Basic SQL SELECT Statements
SQL SELECT Statements
06:12
Expressions
08:16
Null Value
01:24
Column Alias
01:47
Concatenation Operator
01:54
Literal Character Strings
01:32
Duplicate Rows
00:49
Demonstration
11:06
Quiz
5 questions
Section 4: Oracle SQL 11g : Restricting and Sorting Data
Limiting the rows
05:50
Other Comparison Conditions
06:44
Logical Conditions
04:13
Precedence
03:39
Sorting the Data
04:50
Demonstration
19:57
Quiz
4 questions
Section 5: Oracle SQL 11g : Single Row Functions
SQL Functions
05:15
Character Functions
16:55
Number Functions
06:01
Date Functions
13:15
Conversion Functions
25:31
RR Date Format and Nesting Functions
06:54
Demonstration
41:20
Quiz
6 questions
Section 6: Oracle SQL 11g : Aggregating Data Using Group Functions
Group Functions
13:06
Creating Groups of Data
04:13
Excluding Group Results
02:52
Demonstration
14:02
Quiz
5 questions
Section 7: Oracle SQL 11g : Constraints
Introduction to Constraints
15:53
Applying Constraints
07:13
Adding,Dropping,Viewing, Enabling, Disabling a Constraint, Cascading Constraints
09:38
Demonstration
12:53
Quiz
5 questions
Section 8: Oracle SQL 11g : Displaying Data from Multiple Tables
Cartesian Product
06:04
Proprietary Joins
18:15
Compliant joins
14:44
Demonstration
16:44
Quiz
5 questions
Section 9: Oracle SQL 11g : Sub-Queries
Sub-query
13:55
Types of Sub queries
09:29
Demonstration
10:42
Quiz
5 questions
Section 10: Oracle SQL 11g : Producing Readable Output with iSQL*Plus
Substitution Variable and System Variables
21:50
Format Commands used in SQL*Plus
21:46
Demonstration
18:05
Quiz
5 questions
Section 11: Oracle SQL 11g : Manipulating Data
Inserting, Deleting, Updating and Merging Data
15:32
Database Transactions and TCL Statements
30:34
Locks
19:07
Demonstration
15:18
Quiz
5 questions
Section 12: Oracle Apps DBA : Introduction to Oracle Applications ERP
Oracle Applications Overview
16:58
Oracle Applications Components
26:53
Quiz
10 questions
Section 13: Oracle Apps DBA : Oracle Applications Architecture & Installations
Oracle Applications Architecture
22:56
Oracle Applications Directory Structure
38:14
Oracle Applications Database
05:40
Oracle Applications Installations
49:16
Quiz
12 questions
Section 14: Oracle Apps DBA : Oracle Applications Administration
Concepts and Explain AD Utilities
01:01:04
AD Administration
31:06
FND Utilities
07:25
Quiz
10 questions
Section 15: Oracle Apps DBA : Patch Administration
Need of the Applications Patch
09:10
Types of Applications Patches
04:56
Pre-requisites to Apply Patch
08:59
Patch Options and Modes
18:07
Applying Patch
21:54
Post Patch Steps
03:07
Patch Tracking Utilities
19:11
Reduce Patching Downtime
05:35
Quiz
10 questions
Section 16: Oracle Apps DBA : Cloning

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Parallel Branch Inc, Academy Of Technical Courses, Grow Your Skills Today

We offer courses in specialized technology domains that are well aligned with market trends, geared towards enabling gainful careers and are affordable. Parallel Branch is an interactive approach to e-learning and a perfect way to Jump Start your career.

In today’s job market, it’s important to have the skills to match current needs and to stay on par with technological advances. The flexible, affordable and high-quality online technical courses at Parallel Branch provide the opportunity for you to learn the skills you need to move ahead and stay there.

Ready to start learning?
Take This Course