Oracle Database 12c SQL Certified Associate 1Z0-071

Become Oracle SQL Certified ( OCA ) / Covers ORACLE university track 100%. All the presentations & scripts are attached

4.59 (7815 reviews)
Udemy
platform
English
language
IT Certification
category
31,694
students
20 hours
content
Jan 2020
last update
$124.99
regular price

What you will learn

The Full track of Oracle Database 12c: Introduction to SQL Ed 2.

You will be prepared 100% to pass exams Oracle Database SQL 1Z0-071 And also exam Oracle Database 12c: SQL Fundamentals 1Z0-061

Very strong introduction to make you understand the oracle database and RDBMS.

Oracle Database 12c Architecture

Downloading and installing oracle database 12c in details

Connecting to the Database

Retrieving data using the select statement / Restricting and Sorting Data

Substitution Variables

Using Single-Row Functions to Customize Output

Reporting Aggregated Data Using the Group Functions

Displaying Data from multiple tables using joins

Using Subqueries to Solve Queries

Using the Set Operators

Managing tables using DML Statments ( Insert, Update, Delete )

Data Definition Language / Creating tables

Data Dictionary Views

Creating sequences, synonyms, and indexes

Creating Views in details

Managing Schema Objects

Retrieving Data By Using Subqueries

Manipulating Data By Using Subqueries

Controlling User Access in details

Manipulating Data

Managing Data in Different Time Zones

Exam information / Exams Details / Exam Practice

many other information, you can see the full curriculum

Description

ORACLE is database number one in the world .

if you know Oracle SQL, then you can learn any SQL easily  ( mysql, sql server,PostgreSQL, ..).


This is one of the most amazing Udemy courses in Oracle SQL.  

The course covers the oracle university track 100% for :  

“Oracle Database 12c SQL Certified Associate 1Z0-071”  

The course starts from zero level to Expert Level, I guarantee for you that you will understand every single lesson in this course because it was created in a very attractive way, you will not feel bored in any lesson in this course.  

Just watch the videos and do the examples and you will be ready passing the exam.  

You will find all the presentations and all the SQL scripts attached in every chapter, so no need to waste your time repeating any example I did.  

Simply this course is the best….

Content

Introduction

Course Agenda
System Development Life Cycle & Database Definition
What is a Table?
Data Models & ERM
About Primary key & foreign key
SQL and Types of SQL Statements
Oracle Database 12c Architecture
HR Schema in this Course

Live SQL & Download/ Install

Oracle Live SQL / No Installation for anything
Oracle Live SQL limitation
before you install oracle DB
Downloading Oracle DB 12c
Installing Oracle DB 12c
About Oracle 18c express edition
About oracle 11g express edition

Connecting to the Database

Connecting SYS using SQL plus & SQL Developer
if you do not remember the sys password
Unlock HR Account Part 1
Unlock HR Account Part 2
ORA-01033 oracle initialization or shutdown in progress 12c
ORA-65054: Cannot open a pluggable database in the desired mode
Creating new pluggable database contains HR user

Retrieving data using the select statement

Navigate HR schema
Capabilities of SQL SELECT Statements
Arithmetic expressions and NULL values
Column Alias, Concatenation , Distinct and DESCRIBE
Important Notes in Select Statement

Restricting and Sorting Data

The WHERE Clause & Comparison Operators
Using Between and / IN / Like Operators
Using IS NULL / NOT / Not equal Operators
Logical Operators (AND/ OR/ NOT)
Order by Clause
The FETCH Clause

Substitution Variables

What is a Substitution Variables (&)
DEFINE / UNDEFINE
ACCEPT / PROMPT
Double-Ampersand / SET VERIFY / SET DEFINE

Using Single-Row Functions to Customize Output

Single Row Function Introduction
Character functions (Upper, Lower, Initcap )
Character functions (concat, substr, length )
Character functions ( instr )
Character functions ( lpad, rpad , replace, trim)
Number functions ( Round, Trunc, MOD )
Date Functions ( Sysdate)
Date Functions ( months_between, add_months, next_day, last_day)
Date Functions ( round , trunc )
Nesting Functions

Using Conversion Functions and Conditional Expressions

Implicit Data Conversion VS Explicit
TO_CHAR with dates
TO_CHAR with numbers
TO_NUMBER , TO_DATE Functions
nvl , nvl2 , nullif and coalesce Functions
The CASE Function
The DECODE Function

Reporting Aggregated Data Using the Group Functions

Group functions Introduction
Group functions (sum, count, max, min, avg & more)
Group by Clause, Having Clause

Displaying Data from multiple tables using joins

Before You Start, important notes
HR Tables Diagram, Joins Clarification
What is Cartesian product?
Old Joins: Equijoin
Old Joins: nonEquijoins
Old Joins: outer join
Old Joins: Self Join and More Practices
1999 Syntax: Cross Join (Cartesian product )
1999 Syntax: Natural Join
1999 Syntax: USING Clause
1999 Syntax: ON Clause
1999 Syntax: Left/Right/full Outer Join

Using Subqueries to Solve Queries

Single row Subqueries
Multiple rows Subqueries
NULL values and Subqueries
Exists and not Exists

Using the Set Operators

Overview (Union, union all, intersect, minus )
Practice (Union, union all, intersect, minus )

Managing tables using DML Statments

Introduction to DML
Insert Statement
Inserting common errors
Update Statement
Delete Statement
What is Database Transactions?
About Commit & Rollback
Practice ( Commit and rollback )
SAVEPOINT
ROW Lock
FOR UPDATE Clause

Introduction to Data Definition Language

DDL & Naming Rules
Data Types Part 1
Data Types Part 2
Creating Tables (without constraints)
Types of constraints and why we use it?
Creating Tables ( Column Level Constraints )
Creating Tables ( Table Level Constraints )
Constraints Guidelines
ON DELETE cascade / ON DELETE set null
Create Table AS subquery
Alter Table/ Add Columns
Alter Table/ Modify Columns
Alter Table/ Drop Columns
Alter Table/ Set Unused
ALTER TABLE READ ONLY / READ write
Drop Table
Rename Column / Rename Table

Tips you Should know

Tips you Should know Part 1
Tips you Should know Part 2
Tips you Should know Part 3
Tips you Should know Part 4
Tips you Should know Part 5
Tips you Should know Part 6

Exam 1Z0-061 / Oracle Database 12c: SQL Fundamentals

About Exam 1Z0-061 / Visiting Oracle Website
My recommendations
1Z0-061 retires on 30, Nov 2019

Introduction to Data Dictionary Views

What is Data Dictionary Views?
What is DICTIONARY?
USER_OBJECTS / ALL_OBJECTS
USER_TABLES / ALL_TABLES / USER_TAB_COLUMNS
USER_CONSTRAINTS & USER_CONS_COLUMNS Part 1
USER_CONSTRAINTS & USER_CONS_COLUMNS Part 2
COMMENT ON TABLE / COLUMN

Creating sequences, synonyms, and indexes

Sequences Part 1
Sequences Part 2
Sequences Part 3
Sequences Part 4
Creating Synonyms
Creating Indexes Part 1
Creating Indexes Part 2

Creating Views

What is a View? / What is the benefits of Views?
Creating Simple Views
Creating Complex Views
With READ ONLY / With check option / Force view

Managing Schema Objects

Adding constraints / dropping constraints
Rename Column / Rename Constraint
Enable / Disable Constraints
Understanding DEFERRABLE Constraints
DEFERRABLE Constraints Exercises
GLOBAL TEMPORARY TABLE
About SQL*Loader
External Tables Part 1
External Tables Part 2

Retrieving Data By Using Subqueries

Using the subquery as a source table
Pairwise/ Non Pairwise Subqueries
Scalar Subquery / Correlated Subquery
Reminder of Exists / Not Exists
WITH Clause

Manipulating Data By Using Subqueries

Inserting/ Updating /Deleting Using a subquery as a target
Correlated Update / Correlated Delete

Controlling User Access

Database Security / System Privileges & Roles
Database Security / Object Privileges
System Privileges & Privileges Practice 1
System Privileges & Privileges Practice 2
Creating ROLE Practice
With Grant Option
Drop user Statement

Manipulating Data

What is Data Warehouse?
Explicit default value in insert & update statement
Copy rows from another table
INSERT ALL statement / INSERT FIRST
Another "INSERT ALL" Example & Notes
Creating Matrix Report Using PIVOT
The Merge Statement
FLASHBACK Table & System change Number ( SCN)

Managing Data in Different Time Zones

THE INTERVAL ( YEAR TO MONTH / day TO second)
to_yminterval / to_dsinterval
Extract function
timestamp / timestamp with time zone
V$TIMEZONE_NAMES and some functions
timestamp with local time zone
TZ_OFFSET / FROM_TZ / TO_TIMESTAMP

Exam 1Z0-071 for SQL Certified Associate

About the Exam 1Z0-071
Some helpful websites contains exams Dumps
EXAM 1z0-071 Sample Questions

Bonus Section

Using SELECT statement to create dynamic scripts
Installing oracle 11g express edition
Rownum and rowid
About PL/SQL
Understanding NULLS when used with ( IN/ NOT IN )
permanent solution for ORA-01033 oracle initialization or shutdown in progress
DML logs using package dbms_errlog
oracle 18c express edition part 1 (download and install )
oracle 18c express edition part 2 (unlock hr )
oracle 18c express edition part 3 ( sql developer )

What next? it is time for PL/SQL

Move your skills to PL/SQL
Move your skills to Oracle Analytic Functions In-Depth & Advanced Oracle SQL

Screenshots

Oracle Database 12c SQL Certified Associate 1Z0-071 - Screenshot_01Oracle Database 12c SQL Certified Associate 1Z0-071 - Screenshot_02Oracle Database 12c SQL Certified Associate 1Z0-071 - Screenshot_03Oracle Database 12c SQL Certified Associate 1Z0-071 - Screenshot_04

Reviews

Ajinkya
July 14, 2023
Just passed the certification exam on 9th Nov 2023. Thank you Khaled!! This was the only course I preferred to get ready for the exam and indeed it came out to be a good decision. However, I strongly recommend doing a lot of practice and exploring concepts like views, global temporary tables, external tables in more depth on your own as I feel these topics are not covered to the proper depth. Also, try giving a bunch of practice tests instead of just going through the course again and again. I personally gave about 14 plus practice tests and according to me once you start scoring more than 80% in those tests, you are all set for the certification exam. All the best, Cheers!
V
July 13, 2023
I was hesitant at first because of the fun approach to the course preview and because of the music playing while talking but the lectures are very good and easy to follow and the music is off when teaching. There is still humor but at the correct times. I found that this course follows the 1Z0-071 exam topics the most among the other SQL courses on Udemy. Perfect course. Really recommend.
Ana
July 11, 2023
There is no chance to test yourself through quizzes like in other courses. It is also very difficult to understand the instructor.
Sorin
May 30, 2023
Used this course along with Oracle learning path and lots of tests to get my badge. Thabk you for this course Khaled.
Jamie
May 19, 2023
I'm enjoying it very much! Every time he says, "Very nice," he sounds just like Borat. LOL :) Unfortunately, livesql doesn't work for the more intricate coding. One must download Oracle. I tried different web browsers and laptops. Perhaps livesql used to allow a bit more. Now, it just seems to work for very simple commands. I'm wondering how much of the exam requires running queries - and do they provide a live environment full capable of running the queries?
Richard
May 15, 2023
Khaled is the best Oracle/SQL teacher. I really mean teacher not lecturer I have found online. Such a great guy should be uphold by oracle. After going through some of his courses I can conclude he his oracle trained (though I may be wrong) and probably have worked for oracle base on his in depth knowledge on the knowledge he passes across in his Udemy classes.
Mohamed
May 10, 2023
one of the most amazing courses from theory side and from practical side , i would recommend this course for everyone who want to learn SQL.
Aparna
May 9, 2023
yes,it was perfectly good and teaching is also excellent,concepts are clear and understandable thank you for wonderful course.
Jagat
April 27, 2023
This is very outdated program. current version is 23c while this one is 12C.. waste of time and energy as on 30th April 2023
Kwette
April 21, 2023
Merci pour cette formation, j'ai énormément appris, les explications sur les notions abordées sont tellement claires et précises qu'il n'y a qu'à avaler ce cours.
Edward
April 9, 2023
I dont know yet. I really need more query and table knowledge. Im looking at the practice exam and it appears to be all table work.
Rahul
January 31, 2023
The course content is good and covers all the topics related to IZ0-071, it would be nice if the quiz is added end of every section
Joseph
January 6, 2023
It was a good decision to finish this course, I learnt a lot of new things that I didn't know about Oracle SQL. Fully Recomended!
Dinh
November 8, 2022
Passed with 81%, the lecture covers almost secions in the exam. People should do some simulation tests to get higher score.
Willem
May 26, 2022
Very great course and the presenter is very good. This course was a great investment in my career. Thank you!

Coupons

DateDiscountStatus
1/19/202486% OFF
expired

Charts

Price

Oracle Database 12c SQL Certified Associate 1Z0-071 - Price chart

Rating

Oracle Database 12c SQL Certified Associate 1Z0-071 - Ratings chart

Enrollment distribution

Oracle Database 12c SQL Certified Associate 1Z0-071 - Distribution chart
1312042
udemy ID
8/3/2017
course created date
10/12/2019
course indexed date
Bot
course submited by