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.20 (134 reviews)
Udemy
platform
English
language
IT Certification
category
instructor
Oracle Database 12c Certified Professional - SQL Foundations
919
students
5.5 hours
content
Jan 2017
last update
$59.99
regular price

What you will learn

work proficiently with SQL within an Oracle environment

approach Oracle certification with a confident understanding of SQL fundamentals

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.

Content

Introduction

Important - Download These First - Working Files
What You Should Expect From This Course
How To Access Your Working Files

The Oracle Relational Database

The Relational Database
The Oracle 12C RDBMS
Structured Query Language
Setting Up SQL Developer
Setting Up Oracle APEX

The SQL SELECT Statement

The Syntax Of SQL
Projecting Columns In A SQL Statement
Using DESCRIBE
Using Aliases In SQL
Arithmetic Operators
Displaying Unique Values With DISTINCT
Concatenating Values

Conditionals In SQL Statements

Selectivity And WHERE Clause Syntax
Conditions Of Equality
Conditions Of Non-Equality
Range Conditions With BETWEEN
Set Conditions With IN
Pattern Matching With LIKE
Boolean Conditions
Sorting Data With ORDER BY
Sort Ordering And Secondary Sorts
Ampersand Substitution

Row Level Data Transformation

Understanding Single-Row Functions
Case Conversion Functions
Basic String Manipulation Functions
Advanced String Manipulation Functions
Date Functions
Arithmetic Functions

Conversion Functions And Conditional Expressions

Date To Character Conversion
Character To Date Conversion
Numeric Conversion
Conditional Expression Functions

Aggregate Data Transformation

Group Functions
Grouping Data With GROUP BY
Row Exclusion With HAVING
Using SQL Clauses Together

Combining Data

Explicit Versus Implicit Join Notation
Implicit Cartesian Joins
Implicit Equijoins
Implicit Outer Joins
Explicit Cross Joins
Ambiguous Explicit Joins With NATURAL JOIN
Explicit Column Joins With JOIN USING
Fully Specified Explicit Joins With JOIN ON
Self Joins And Non-Equijoins
0810 Multi-Table Joins

Subqueries And Set Operators

Solving Problems With Subqueries
Basic Scalar Subqueries
Advanced Scalar Subqueries
Multi-Row Subqueries
Correlated Subqueries
Multi-Column Subqueries
Nested Subqueries
Using Set Operators

Data Manipulation And DML

Create Data With INSERT
Modify Data With UPDATE
Remove Data With DELETE And TRUNCATE
Transaction Control

Data Definition Language

The Purpose Of DDL
Oracles Schema Based Approach
Database Objects
Column Datatypes
The CREATE TABLE Statement
Avoiding Datatype Errors
Modifying Tables With ALTER TABLE
The NOT NULL Constraint
PRIMARY KEY Constraint
FOREIGN KEY Constraint
UNIQUE Constraint
CHECK Constraint

Certification Exam Preparation

About The Exam
Hints And Strategies For Preparation

Conclusion

Wrap Up

Reviews

Mouctar
July 5, 2018
Very nice SQL primer. They should upgrade this retired exam to 1z0-071. Very short and sweet lessons, the way it should be. Thank you to Infinite Skills.
Samuel
December 8, 2017
Fantastic lessons but I spent 4 days trying to install Oracle Database 12c on my Windows machine and even my Linux Hyper-V instance to no avail. After a ridiculous amount of Googling, I was able to find an arcane command-line switch that allowed me to install the 12c database on Windows.
Amit
January 26, 2017
Instructor uses great metaphors for the subject matter, and most of the subject info. seems to be all in one place.
Ashley
August 24, 2016
So far, the course is very detailed and easy to understand. It covers the information thoroughly and efficiently in a concise manner. The explanation on setting up your SQL work space was also very quick and easy to follow along. I am very impressed.
Bryant
July 25, 2016
This course covers all the topics in part 1 of the OCA exam. This course could be improved by the instructor being more involved with answering questions in Q&A sections. As you can see it has been over a year since instructor has responded to anything. Also needs to provide exercises/quizzes in order for us to demonstrate our understanding of material. This course can be help to supplement test prep but should not be sole source of test prep.
Mark
July 17, 2016
This information is highly usable, even though a review of much of the 11g type trainings. Interesting new join techniques I was not familiar with. Always much to learn.
Leo
April 22, 2016
have you take oca or ocp at all? contents are too superficial and far from detailed and indepth enough to pass the exam. take the test and you know what i mean.
Marc
August 17, 2015
Author does a great job of explaining and showing examples. I am only half way through it but I like it. I also bought the Oracle 12c book to study along with an exam guide so all together it makes for great learning. Marc
Smit
July 25, 2015
This course covers almost all topics and if you combined your own practice with it, you will surely clear certification and of course learn SQL. But it lacks in depth analysis o few topics but of course it's not possible to cover all topics in depth in such small span. From my personal exam experience - I think FETCH FIRST or operations on SEQUENCES,SYNONYMS,VIEWS, kind of examples are missing in this but I got that covered luckily while practicing.

Charts

Price

Oracle Database 12c Certified Professional - SQL Foundations - Price chart

Rating

Oracle Database 12c Certified Professional - SQL Foundations - Ratings chart

Enrollment distribution

Oracle Database 12c Certified Professional - SQL Foundations - Distribution chart
341400
udemy ID
11/11/2014
course created date
7/16/2019
course indexed date
Bot
course submited by