Oracle Database 12c Certified Professional - SQL Foundations

A step-by-step guide to introduce you to Oracle's unique SQL requirements and prepare you for the first official exam.
4.6 (55 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.
559 students enrolled
$19
$50
62% off
Take This Course
  • Lectures 76
  • Length 5.5 hours
  • Skill Level Beginner 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 11/2014 English

Course Description

In this multi-part video course, you'll learn the fundamentals of the SQL programming language in Oracle, and get specific guidance for the first test in the Oracle certification track. This course is designed for the beginner, meaning no experience with Oracle 12c is required.

You will start by learning about the Oracle relational database, then jump into learning about the SQL SELECT statement. From there, author Steve Ries will teach you about conditionals in SQL, conversion functions, and implicit and explicit joins. This video tutorial also covers subqueries, data manipulation, and data definition language. Finally, you will learn about the exam, and Steve will provide you with hints and strategies to help you prepare.

Once you have completed the course, you will be fully capable of working with the SQL programming language, and in doing so, you will be much better prepared for the Oracle Database 12c SQL Fundamentals exam. Project files are included, allowing you to follow along with the author throughout the lessons.

What are the requirements?

  • a functional Oracle 12c installation for hands-on practice

What am I going to get from this course?

  • work proficiently with SQL within an Oracle environment
  • approach Oracle certification with a confident understanding of SQL fundamentals

What is the target audience?

  • IT professionals and developers interested in approaching Oracle from a professional perspective

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
Important - Download These First - Working Files
Preview
Article
What You Should Expect From This Course
Preview
03:45
How To Access Your Working Files
Preview
03:22
Section 2: The Oracle Relational Database
The Relational Database
Preview
05:51
The Oracle 12C RDBMS
06:23
Structured Query Language
05:02
Setting Up SQL Developer
05:11
Setting Up Oracle APEX
05:06
Section 3: The SQL SELECT Statement
The Syntax Of SQL
04:03
Projecting Columns In A SQL Statement
04:16
Using DESCRIBE
05:33
Using Aliases In SQL
03:38
Arithmetic Operators
04:37
Displaying Unique Values With DISTINCT
04:22
Concatenating Values
04:17
Section 4: Conditionals In SQL Statements
Selectivity And WHERE Clause Syntax
03:07
Conditions Of Equality
04:23
Conditions Of Non-Equality
05:17
Range Conditions With BETWEEN
03:34
Set Conditions With IN
02:51
Pattern Matching With LIKE
05:06
Boolean Conditions
05:02
Sorting Data With ORDER BY
04:43
Sort Ordering And Secondary Sorts
05:02
Ampersand Substitution
05:10
Section 5: Row Level Data Transformation
Understanding Single-Row Functions
03:50
Case Conversion Functions
03:37
Basic String Manipulation Functions
06:23
Advanced String Manipulation Functions
07:03
Date Functions
04:46
Arithmetic Functions
05:04
Section 6: Conversion Functions And Conditional Expressions
Date To Character Conversion
05:06
Character To Date Conversion
04:20
Numeric Conversion
04:43
Conditional Expression Functions
04:49
Section 7: Aggregate Data Transformation
Group Functions
03:45
Grouping Data With GROUP BY
04:03
Row Exclusion With HAVING
03:21
Using SQL Clauses Together
02:55
Section 8: Combining Data
Explicit Versus Implicit Join Notation
04:28
Implicit Cartesian Joins
03:13
Implicit Equijoins
04:48
Implicit Outer Joins
04:46
Explicit Cross Joins
03:17
Ambiguous Explicit Joins With NATURAL JOIN
04:29
Explicit Column Joins With JOIN USING
03:07
Fully Specified Explicit Joins With JOIN ON
02:51
Self Joins And Non-Equijoins
04:04
0810 Multi-Table Joins
05:16
Section 9: Subqueries And Set Operators
Solving Problems With Subqueries
03:09
Basic Scalar Subqueries
03:13
Advanced Scalar Subqueries
03:58
Multi-Row Subqueries
06:15
Correlated Subqueries
03:39
Multi-Column Subqueries
04:29
Nested Subqueries
02:27
Using Set Operators
04:41
Section 10: Data Manipulation And DML
Create Data With INSERT
05:02
Modify Data With UPDATE
03:58
Remove Data With DELETE And TRUNCATE
03:56
Transaction Control
05:29
Section 11: Data Definition Language
The Purpose Of DDL
04:16
Oracles Schema Based Approach
04:38
Database Objects
05:57
Column Datatypes
04:35
The CREATE TABLE Statement
04:55
Avoiding Datatype Errors
06:30
Modifying Tables With ALTER TABLE
07:36
The NOT NULL Constraint
02:38
PRIMARY KEY Constraint
05:08
FOREIGN KEY Constraint
04:59
UNIQUE Constraint
03:28
CHECK Constraint
03:43
Section 12: Certification Exam Preparation
About The Exam
03:50
Hints And Strategies For Preparation
04:17
Section 13: Conclusion
Wrap Up
02:12

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