Oracle SQL 11g + Oracle Apps R12 DBA
4.0 (61 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.
772 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle SQL 11g + Oracle Apps R12 DBA to your Wishlist.

Add to Wishlist

Oracle SQL 11g + Oracle Apps R12 DBA

Learn Oracle SQL 11g,Oracle Apps R12 Architecture & Installations, Patching, Cloning,Administration and Troubleshooting
4.0 (61 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.
772 students enrolled
Last updated 2/2014
English
Current price: $10 Original price: $25 Discount: 60% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 20 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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.
View Curriculum
Requirements
  • Windows PC, Good Internet Connectivity and Basic database knowledge
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.

Who is the target audience?
  • Beginners
  • Graduates
  • Oracle DBA
  • Oracle Technical/Functional Consultants
Students Who Viewed This Course Also Viewed
Curriculum For This Course
79 Lectures
20:05:07
+
Oracle SQL 11g : Introduction to SQL
5 Lectures 23:49



Tables used in the Course
02:40

Demonstration
07:01

Quiz
4 questions
+
Oracle SQL 11g : Creating and Managing Tables
4 Lectures 01:10:45
Database Object: Table
06:24

Data Types
45:31

Creating, Altering, Renaming, Truncating, Dropping a Table
11:22

Demonstration
07:28

Quiz
5 questions
+
Oracle SQL 11g : Writing Basic SQL SELECT Statements
8 Lectures 33:00
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
+
Oracle SQL 11g : Restricting and Sorting Data
6 Lectures 45:13
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
+
Oracle SQL 11g : Single Row Functions
7 Lectures 01:55:11
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
+
Oracle SQL 11g : Aggregating Data Using Group Functions
4 Lectures 34:13
Group Functions
13:06

Creating Groups of Data
04:13

Excluding Group Results
02:52

Demonstration
14:02

Quiz
5 questions
+
Oracle SQL 11g : Constraints
4 Lectures 45:37
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
+
Oracle SQL 11g : Displaying Data from Multiple Tables
4 Lectures 55:47
Cartesian Product
06:04

Proprietary Joins
18:15

Compliant joins
14:44

Demonstration
16:44

Quiz
5 questions
+
Oracle SQL 11g : Sub-Queries
3 Lectures 34:06
Sub-query
13:55

Types of Sub queries
09:29

Demonstration
10:42

Quiz
5 questions
+
Oracle SQL 11g : Producing Readable Output with iSQL*Plus
3 Lectures 01:01:41
Substitution Variable and System Variables
21:50

Format Commands used in SQL*Plus
21:46

Demonstration
18:05

Quiz
5 questions
8 More Sections
About the Instructor
Parallel Branch Inc
3.8 Average rating
1,228 Reviews
11,247 Students
32 Courses
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.