Oracle Database 12c Certified Professional - SQL Foundations
4.5 (74 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.
649 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle Database 12c Certified Professional - SQL Foundations to your Wishlist.

Add to Wishlist

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.5 (74 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.
649 students enrolled
Created by Infinite Skills
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 5.5 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • work proficiently with SQL within an Oracle environment
  • approach Oracle certification with a confident understanding of SQL fundamentals
View Curriculum
Requirements
  • a functional Oracle 12c installation for hands-on practice
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.

Who is the target audience?
  • IT professionals and developers interested in approaching Oracle from a professional perspective
Students Who Viewed This Course Also Viewed
Curriculum For This Course
76 Lectures
05:32:44
+
The Oracle Relational Database
5 Lectures 27:33

The Oracle 12C RDBMS
06:23

Structured Query Language
05:02

Setting Up SQL Developer
05:11

Setting Up Oracle APEX
05:06
+
The SQL SELECT Statement
7 Lectures 30:46
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
+
Conditionals In SQL Statements
10 Lectures 44:15
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
+
Row Level Data Transformation
6 Lectures 30:43
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
+
Conversion Functions And Conditional Expressions
4 Lectures 18:58
Date To Character Conversion
05:06

Character To Date Conversion
04:20

Numeric Conversion
04:43

Conditional Expression Functions
04:49
+
Aggregate Data Transformation
4 Lectures 14:04
Group Functions
03:45

Grouping Data With GROUP BY
04:03

Row Exclusion With HAVING
03:21

Using SQL Clauses Together
02:55
+
Combining Data
10 Lectures 40:19
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
+
Subqueries And Set Operators
8 Lectures 31:51
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
+
Data Manipulation And DML
4 Lectures 18:25
Create Data With INSERT
05:02

Modify Data With UPDATE
03:58

Remove Data With DELETE And TRUNCATE
03:56

Transaction Control
05:29
3 More Sections
About the Instructor
Infinite Skills
4.4 Average rating
46,656 Reviews
734,852 Students
331 Courses
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.