Oracle SQL 11g - Fundamentals

Oracle 11g SQL Programming, SQL Statements, Functions,Constraints,Sub-Queries,Creating and Managing Tables,iSQL*Plus
4.1 (106 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.
873 students enrolled
$20
Take This Course
  • Lectures 52
  • Contents Video: 10 hours
  • Skill Level Intermediate 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 12/2013 English

Course 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

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.

What is the target audience?

  • Beginners
  • Fresh Graduates

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: Introduction to SQL
Introduction to SQL
Preview
05:16
SQL Statements
02:16
Introduction to SQL *Plus
06:36
Tables used in the Course
02:40
Demonstration
Preview
07:01
Quiz
4 questions
Section 2: Creating and Managing Tables
Database Object: Table
06:24
Datatypes
45:31
Creating, Altering, Renaming, Truncating, Dropping a Table
11:22
Demonstration
07:28
Quiz
5 questions
Section 3: 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: 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: 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: Aggregating Data Using Group Functions
Group Functions
Preview
13:06
Creating Groups of Data
04:13
Excluding Group Results
02:52
Practical Demo on the above lessons
14:02
Quiz
5 questions
Section 7: Constraints
Introduction to Constraints
15:53
Applying Constraints
07:13
Adding,Dropping,Viewing, Enabling, Disabling a Constraint, Cascading Constraints
09:38
Demonstration
Preview
12:53
Quiz
5 questions
Section 8: 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: Sub-Queries
Sub-query
13:55
Types of Sub queries
09:29
Demonstration
10:42
Quiz
5 questions
Section 10: 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: 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

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