Learning SQL For Oracle

A beginners guide to learning SQL for Oracle
4.2 (32 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.
435 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 111
  • Length 9 hours
  • Skill Level All Levels
  • 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 8/2014 English

Course Description

This Oracle SQL training course from Infinite Skills teaches you everything you need to know about this graphical user interface. This course is designed for the absolute beginner, meaning no prior knowledge of Oracle SQL is required.

You will start by learning about a basic SQL select statement, including how to retrieve data from a table, use mathematical and text expressions, and sort the results using column names. This course will then show you how to restrict data, join tables, and summarize data. This video tutorial will also cover data subsets, restricting data, using subqueries, and data modeling. Other topics that are covered include creating tables and manipulating data, single-row functions, creating and using views, database management, and legacy SQL techniques.

Once you have completed this computer based training course, you will be able to use Oracle SQL as your main productivity tool for development. Working files are included, allowing you to follow along with the author throughout the lessons.

What are the requirements?

  • PC or Mac

What am I going to get from this course?

  • Learn about SQL for Oracle

What is the target audience?

  • Anyone wishing to learn about SQL for Oracle

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 Oracle SQL
Important - Download These First - Working Files
Preview
Article
0102 What Is SQL?
Preview
05:31
0103 Relational Databases Explained - Part 1
Preview
06:51
0104 Relational Databases Explained - Part 2
06:22
0105 How To Query Data From A Database
06:51
0106 The Difference Between SQL And PL/SQL
03:58
0107 Setting Up An Oracle Apex Account
09:53
0108 Running SQL Using Oracle Apex
06:49
0109 Assignment 1
00:43
0110 Assignment 1 - Solution
01:30
0111 How To Access Your Working Files
03:22
Section 2: Basic SQL Select Statement
0201 Retrieving All Data From A Table
05:30
0202 Retrieving Some Data From A Table
02:02
0203 Restricting The Retrieval Of Rows From A Table
05:29
0204 Using Mathematical And Text Expressions
06:08
0205 Sorting The Results Using Column Names
05:41
0206 Assignment 2
02:27
0207 Assignment 2 - Solution
06:37
Section 3: Restricting Data - The Basics
0301 What Is A Primary Key?
06:12
0302 Comparison Operators
04:48
0303 Logical Operators
07:35
0304 Dealing With Null Values
08:14
0305 Sorting The Results Using Column Position
03:52
0306 Assignment 3
01:28
0307 Assignment 3 - Solution
06:19
Section 4: Joining Tables - The Basics
0401 What Is A Foreign Key?
04:24
0402 Inner Joins With The Using Clause
06:48
0403 Joins With The On Clause
05:31
0404 Joins And The Order Of Processing
04:34
0405 Assignment 4
01:01
0406 Assignment 4 - Solution
04:48
Section 5: Summarizing Data
0501 Aggregate Functions
06:44
0502 The Count Functions
05:10
0503 The Min And Max Functions
04:27
0504 The Avg And Sum Functions
02:37
0505 Concatenating Data
04:27
0506 Aggregates - Order Of Processing
03:32
0507 Assignment 5
00:51
0508 Assignment 5 - Solution
01:28
Section 6: Joining Multiple Tables
0601 Many-To-Many Relationships - Part 1
07:16
0602 Many-To-Many Relationships - Part 2
04:22
0603 Join Multiple Tables With The Using Clause
07:30
0604 Join Multiple Tables With The On Clause
06:56
0605 Eliminating Duplicate Rows From The Results
05:31
0606 Sorting The Results Using Column Aliases
01:45
0607 Assignment 6
01:09
0608 Assignment 6 - Solution
03:35
Section 7: Data Subsets
0701 Using The Group By Clause
07:50
0702 Using The Having Clause
04:43
0703 Having With Compound Conditions
03:18
0704 Assignment 7
01:02
0705 Assignment 7 - Solution
04:18
Section 8: Restricting Data - Advanced Concepts
0801 Using The In Operator
04:04
0802 Using The Between Operator
06:30
0803 Using The Like Operator For Pattern Matching
09:31
0804 Outer Joins
11:48
0805 Assignment 8
00:58
0806 Assignment 8 - Solution
03:37
Section 9: Using Subqueries - The Basics
0901 How Do Subqueries Work?
06:47
0902 Subqueries With The In Operator
09:25
0903 Subqueries Using A Comparison Operator
07:21
0904 Subqueries Vs. Joins
04:12
0905 Using A Subquery Vs. A Self-Join
04:22
0906 Assignment 9
01:05
0907 Assignment 9 - Solution
04:33
Section 10: Data Modeling - The Basics
1001 How Data Is Organized In A Relational Database
04:13
1002 The Entity-Relationship Approach
08:25
1003 Normalization Guidelines - Part 1
07:14
1004 Normalization Guidelines - Part 2
07:06
1005 Assignment 10
01:46
1006 Assignment 10 - Solution
02:51
Section 11: Creating Tables And Manipulating Data
1101 Creating Tables - Part 1
06:47
1102 Creating Tables - Part 2
09:06
1103 Specifying Keys
04:32
1104 The Check Constraint
06:50
1105 Creating Indexes
06:58
1106 Modifying And Removing Tables
05:58
1107 More Constraints
04:26
1108 Adding Data To A Table
06:58
1109 Changing Data In A Table - Part 1
04:50
1110 Changing Data In A Table - Part 2
03:12
1111 Removing Data From A Table
03:22
1112 Assignment 11
01:17
1113 Assignment 11 - Solution
01:14
Section 12: Single-Row Functions
1201 String Functions - Part 1
08:02
1202 String Functions - Part 2
04:15
1203 Number Functions
05:49
1204 Date Functions
07:53

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Infinite Skills, High Quality Training

Infinite Skills is a Canadian based company who offer a huge and ever growing range of high quality eLearning solutions that teach using studio quality narrated videos backed-up with practical hands-on examples and comprehensive working files. All courses are created by trained educators and experts in video based education.

The emphasis is on teaching real life skills that are essential for progressing in today's commercial environment.

Ready to start learning?
Take This Course