Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Oracle SQL 11g - Fundamentals to your Wishlist.

Add to Wishlist

Oracle SQL 11g - Fundamentals

Oracle 11g SQL Programming, SQL Statements, Functions,Constraints,Sub-Queries,Creating and Managing Tables,iSQL*Plus
4.3 (111 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.
901 students enrolled
Last updated 12/2013
English
$10 $20 50% off
5 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 10 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
Description

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

EXTREMELY USEFUL TO UNDERSTAND THE BASIC 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

Who is the target audience?
  • Beginners
  • Fresh Graduates
Students Who Viewed This Course Also Viewed
What Will I Learn?
In this course, you will learn fundamentals of SQL Programming Language.
View Curriculum
Requirements
  • Windows PC, Good Internet Connectivity and Basic database knowledge
Curriculum For This Course
Expand All 52 Lectures Collapse All 52 Lectures 09:59:53
+
Introduction to SQL
5 Lectures 23:49

SQL Statements
02:16

Introduction to SQL *Plus
06:36

Tables used in the Course
02:40


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

Datatypes
45:31

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

Demonstration
07:28

Quiz
5 questions
+
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
+
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
+
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
+
Aggregating Data Using Group Functions
4 Lectures 34:13

Creating Groups of Data
04:13

Excluding Group Results
02:52

Practical Demo on the above lessons
14:02

Quiz
5 questions
+
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


Quiz
5 questions
+
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
+
Sub-Queries
3 Lectures 34:06
Sub-query
13:55

Types of Sub queries
09:29

Demonstration
10:42

Quiz
5 questions
+
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
1 More Section
About the Instructor
3.9 Average rating
874 Reviews
9,667 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.

Report Abuse