Oracle Database 12c SQL Certified Associate 1Z0-071
4.5 (46 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.
358 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle Database 12c SQL Certified Associate 1Z0-071 to your Wishlist.

Add to Wishlist

Oracle Database 12c SQL Certified Associate 1Z0-071

Become Oracle SQL Certified ( OCA ) / Cover ORACLE university track 100%
Best Seller
4.5 (46 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.
358 students enrolled
Created by Khaled Alkhudari
Last updated 9/2017
English
Current price: $12 Original price: $195 Discount: 94% off
4 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 19 hours on-demand video
  • 1 Article
  • 66 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion

Training 5 or more people?

Get your team access to Udemy's top 2,000 courses anytime, anywhere.

Try Udemy for Business
What Will I 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
View Curriculum
Requirements
  • This course start from zero knowledge to expert level.
  • Windows Operating system is preferred, but this is not mandatory if you have the knowledge of downloading Oracle database 12c on other OS.
  • Downloading oracle database and this will be covered in details on Windows OS.
  • No need for any prerequisite database skills, this course designed from Zero to certified level.
Description

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….

Who is the target audience?
  • Students who wants to be expert in oracle database 12c.
  • Students who wants to be certified in oracle database from Oracle University.
  • Fresh IT students who need strong SQL and database knowledge.
  • Fresh and junior programmers who need to find better jobs by gaining oracle certification.
Compare to Other Oracle Database Courses
Curriculum For This Course
165 Lectures
19:02:45
+
Introduction
8 Lectures 31:42

System Development Life Cycle & Database Definition
03:23

What is a Table?
01:30

Data Models & ERM
04:20

About Primary key & foreign key
04:14

SQL and Types of SQL Statements
03:02


HR Schema in this Course
04:34
+
Live SQL & Download/ Install
3 Lectures 21:41
Oracle Live SQL / No Installation for anything
08:43

Downloading Oracle DB 12c
03:42

Installing Oracle DB 12c
09:16
+
Connecting to the Database
4 Lectures 30:31
Connecting SYS using SQL plus & SQL Developer
10:39

Unlock HR Account Part 1
04:30

Unlock HR Account Part 2
11:49

ORA-01033 oracle initialization or shutdown in progress 12c
03:33
+
Retrieving data using the select statement
5 Lectures 34:44
Navigate HR schema
07:05

Capabilities of SQL SELECT Statements
06:49

Arithmetic expressions and NULL values
05:33

Column Alias, Concatenation , Distinct and DESCRIBE
10:38

Important Notes in Select Statement
04:39
+
Restricting and Sorting Data
6 Lectures 54:02
The WHERE Clause & Comparison Operators
12:22

Using Between and / IN / Like Operators
10:36

Using IS NULL / NOT / Not equal Operators
04:18

Logical Operators (AND/ OR/ NOT)
09:47

Order by Clause
08:50

The FETCH Clause
08:09
+
Substitution Variables
4 Lectures 22:27
What is a Substitution Variables (&)
07:15

DEFINE / UNDEFINE
04:59

ACCEPT / PROMPT
03:52

Double-Ampersand / SET VERIFY / SET DEFINE
06:21
+
Using Single-Row Functions to Customize Output
10 Lectures 01:09:45
Single Row Function Introduction
05:05

Character functions (Upper, Lower, Initcap )
03:48

Character functions (concat, substr, length )
06:48

Character functions ( instr )
04:38


Number functions ( Round, Trunc, MOD )
10:25

Date Functions ( Sysdate)
08:00

Date Functions ( months_between, add_months, next_day, last_day)
08:38

Date Functions ( round , trunc )
08:10

Nesting Functions
04:23
+
Using Conversion Functions and Conditional Expressions
7 Lectures 01:05:55
Implicit Data Conversion VS Explicit
06:38

TO_CHAR with dates
09:20

TO_CHAR with numbers
13:00

TO_NUMBER , TO_DATE Functions
07:59

nvl , nvl2 , nullif and coalesce Functions
11:26

The CASE Function
10:59

The DECODE Function
06:33
+
Reporting Aggregated Data Using the Group Functions
3 Lectures 25:14

Group functions (sum, count, max, min, avg & more)
08:14

Group by Clause, Having Clause
11:03
+
Displaying Data from multiple tables using joins
12 Lectures 01:20:51
Before You Start, important notes
05:15

HR Tables Diagram, Joins Clarification
06:08

What is Cartesian product?
05:07

Old Joins: Equijoin
08:02

Old Joins: nonEquijoins
08:15


Old Joins: Self Join and More Practices
08:56

1999 Syntax: Cross Join (Cartesian product )
03:45

1999 Syntax: Natural Join
06:55

1999 Syntax: USING Clause
04:44

1999 Syntax: ON Clause
07:38

1999 Syntax: Left/Right/full Outer Join
07:42
17 More Sections
About the Instructor
Khaled Alkhudari
4.5 Average rating
102 Reviews
646 Students
4 Courses
Sr Oracle Developer/ Sr system analyst

My name is Khaled Al Khudari, I graduated in 2003 in computer science.

I have more than 12 years’ experience in oracle development, I worked many projects with the best companies in the world (Oracle, Microsoft, Ellucian , Etisalat  and many others )

I Have Many Certifications ( OCA, OCP, Oracle ERP certifications and many others )

I have big experience in Oracle ERP modules and data migration, and I have experience in Education system like Banner, People soft  and desire to learn .

I believe in success through hard work & dedication.

My motto in life is: ‘If you want something, work hard & you will achieve it; there are no short cuts’.