1z0-071: Oracle Database SQL Exam – Complete Certification Training Course & Exam Dumps

Curriculum For This Course

Introduction

1Lectures

Time 00:05:10

Installation

3Lectures

Time 00:17:48

Infrastructure Architecture

2Lectures

Time 00:06:24

Oracle RDBMS Architecture

1Lectures

Time 00:05:18

Connecting to an Oracle Database

2Lectures

Time 00:04:31

Stopping and Starting an Oracle Database

2Lectures

Time 00:04:38

Table

2Lectures

Time 00:04:01

SELECT - Basic SELECT Statement

3Lectures

Time 00:05:07

DBA Info - DBA_TABLESPACES

1Lectures

Time 00:01:01

SELECT - Selecting Specific Data

2Lectures

Time 00:04:08

DBA Info - Oracle Database User Architecture

4Lectures

Time 00:08:40

Classification of SQL Commands

1Lectures

Time 00:02:54

Creating a Schema

2Lectures

Time 00:03:52

DML - Data Manipulation Language

12Lectures

Time 00:18:38

TCL - Transaction Control Language

10Lectures

Time 00:24:48

DCL - Data Control Language

7Lectures

Time 00:09:48

DDL - Data Definition Language

9Lectures

Time 00:12:45

Database Design

9Lectures

Time 00:18:08

Build a SELECT Statement

4Lectures

Time 00:04:18

Oracle Certification Exam Concepts - SELECT

3Lectures

Time 00:02:54

CASE SENSITIVITY & TERMINATORS

2Lectures

Time 00:04:42

A QUICK RECAP

3Lectures

Time 00:03:40

SELECT ANYTHING - Even the NON-EXISTENT DATA..!

3Lectures

Time 00:05:06

ARITHMETIC OPERATIONS

5Lectures

Time 00:08:10

COLUMN ALIAS AND CONCATENATION

4Lectures

Time 00:09:36

DISTINCT

1Lectures

Time 00:01:34

SQL DEVELOPER - Exploring a Schema

2Lectures

Time 00:04:48

NULL VALUES

6Lectures

Time 00:12:40

Restricting and Sorting Data

5Lectures

Time 00:14:09

COMPARISON OPERATORS

6Lectures

Time 00:13:20

PATTERN COMPARISON - LIKE OPERATOR

3Lectures

Time 00:12:13

BOOLEAN OR LOGICAL OPERATORS

5Lectures

Time 00:17:33

SUBSTITUTIONS - USING AMPERSANDS

2Lectures

Time 00:07:09

FUNCTIONS

8Lectures

Time 00:35:52

AGGREGATE FUNCTIONS

3Lectures

Time 00:12:52

CONDITIONAL FUNCTIONS

2Lectures

Time 00:07:06

DISPLAYING DATA FROM MULTIPLE TABLES - JOINS

11Lectures

Time 00:31:06

USING SUBQUERIES TO SOLVE QUERIES

4Lectures

Time 00:12:05

USING THE SET OPERATORS

4Lectures

Time 00:13:42

MANIPULATING DATA

3Lectures

Time 00:10:25

CONSTRAINTS

5Lectures

Time 00:16:17

ADDITIONAL KNOWLEDGE BASE - DATABASE OBJECTS, DBA ARTICLES, SCRIPTS etc

1Lectures

Time 00:02:24

Introduction
	1. Introduction	04:35

Installation
	1. Installing Oracle 12c in Windows 10	11:49
	2. Using SQL Developer	02:05
	3. Troubleshooting Connection Issues	03:16

Infrastructure Architecture
	1. Client Server Architecture	02:08
	2. Different types of Clients	03:53

Oracle RDBMS Architecture
	1. Quick Overview of Oracle RDBMS Architecture	05:00

Connecting to an Oracle Database
	1. Connecting to an Oracle Database	02:13
	2. Demo - Connecting as SYSDBA	01:59

Stopping and Starting an Oracle Database
	1. DEMO - Stopping an Oracle Database	01:13
	2. DEMO - Starting an Oracle Database	03:06

Table
	1. What is a Table?	01:31
	2. Data Types	01:43

SELECT - Basic SELECT Statement
	1. Basics of a SELECT Statement	02:24
	2. DESCRIBE Command - DESC	01:31
	3. SELECT COUNT - Find the total number of Rows	00:38

DBA Info - DBA_TABLESPACES
	1. DBA_TABLESPACES	00:52

SELECT - Selecting Specific Data
	1. Selecting Particular Columns	01:31
	2. WHERE Clause - Basics	02:09

DBA Info - Oracle Database User Architecture
	1. Oracle Database User Architecture	05:36
	2. Schema Vs User	00:35
	3. How objects are stored?	00:53
	4. Accessing the Objects	00:39

Classification of SQL Commands
	1. Classification of SQL Commands	02:36

Creating a Schema
	1. Create a User	02:14
	2. Create a Table	01:09

DML - Data Manipulation Language
	1. Basics of DML	01:03
	2. DML - SELECT STATEMENT	00:24
	3. DML - INSERT STATEMENT	01:22
	4. DBA Info - METADATA	00:45
	5. DBA Info - DATA DICTIONARY	00:15
	6. DBA Info - DEFAULT PERMANENT TABLESPACE	02:38
	7. DML - Fixing the Failed INSERT	00:16
	8. Demonstration of the commands to fix the INSERT	03:11
	9. DML - UPDATE STATEMENT	01:51
	10. Demo of an UPDATE STATEMENT	01:12
	11. DML - DELETE STATEMENT	00:46
	12. Demo - DELETE STATEMENT	01:00

TCL - Transaction Control Language
	1. TCL - Basics	01:02
	2. What is a Transaction?	03:33
	3. Demo of a Transaction	01:45
	4. DBA Info - Internal handling of Transaction through REDO	03:19
	5. DBA Info - Internal handling of Transaction through UNDO	02:53
	6. TCL - COMMIT STATEMENT	01:30
	7. TCL - COMMIT Demo	02:22
	8. TCL - ROLLBACK STATEMENT	01:10
	9. TCL - SAVEPOINT STATEMENT	01:33
	10. TCL - SAVEPOINT Demo	02:02

DCL - Data Control Language
	1. DCL - GRANT STATEMENT	00:29
	2. DCL - SYSTEM PRIVILEGES	00:20
	3. DCL - OBJECT PRIVILEGES	00:26
	4. DCL - ROLE PRIVILEGES	00:46
	5. DCL - REVOKE STATEMENT	00:13
	6. DCL - GRANT and REVOKE - FULL DEMO	05:29
	7. DBA Info - Find the DBAs	00:48

DDL - Data Definition Language
	1. DDL - CREATE STATEMENT	00:28
	2. DDL - ALTER STATEMENT	00:06
	3. DDL - DROP STATEMENT	00:07
	4. DDL - RENAME STATEMENT	00:11
	5. DDL - TRUNCATE STATEMENT	00:05
	6. DDL - TRUNCATE vs DELETE	00:21
	7. DDL - COMMENT STATEMENT	00:15
	8. ALL THE DDL STATEMENTS - FULL DEMO	07:46
	9. Addressing the Objects	01:03

Database Design
	1. OLTP - Online Transaction Processing System	00:40
	2. DSS - Decision Support System	00:33
	3. DATA MODELING - ENTITY RELATIONSHIP MODEL or ER MODEL	00:44
	4. ER MODEL - CREATION & NORMALIZATION	10:10
	5. ER MODEL - CONCEPTUAL MODEL	00:32
	6. ER MODEL - LOGICAL MODEL	00:39
	7. ER MODEL - PHYSICAL MODEL	00:28
	8. ER MODEL vs ER DIAGRAM	00:15
	9. ENTITY, ATTRIBUTE, TUPLE & RELATIONSHIPS	01:30

Build a SELECT Statement
	1. SELECT EVERYTHING	00:35
	2. SELECT PARTICULAR COLUMNS	00:20
	3. Filtering Data using WHERE Clause	00:18
	4. JOIN Two Tables	01:43

Oracle Certification Exam Concepts - SELECT
	1. PROJECTION, SELECTION & JOINING	00:57
	2. Mandatory and Optional Clauses of a SELECT Statement	00:22
	3. ORACLE RESERVED WORDS	00:41

CASE SENSITIVITY & TERMINATORS
	1. LOWER and UPPER CASE in SQL Statements	02:40
	2. SQL STATEMENT TERMINATORS	01:36

A QUICK RECAP
	1. STRUCTURE OF A TABLE - DESCRIBE COMMAND	01:21
	2. SELECT EVERYTHING - SELECT *	01:10
	3. FIND THE TOTAL NUMBER OF ROWS - COUNT (*)	00:40

SELECT ANYTHING - Even the NON-EXISTENT DATA..!
	1. To Quote or Not to Quote..!	02:17
	2. DUAL has a DUMMY with an X – Wait, What?	01:27
	3. Excuse me, Who am I and What is today's date please? - SYSDATE	00:45

ARITHMETIC OPERATIONS
	1. Additions and Subtractions ( + and - )	01:07
	2. Multiplication and Division ( * and / )	00:56
	3. Order of Precedence between Multiple Operators	02:44
	4. Changing the Order of Precedence using Parenthesis	01:13
	5. Arithmetic Operations on Tables	01:07

COLUMN ALIAS AND CONCATENATION
	1. Alias for Columns	02:30
	2. CONCATENATION - Creating Sentences from the Data	02:06
	3. Exception for Inner Single Quotes	01:26
	4. Replacing the Quote Delimiters	02:47

DISTINCT
	1. DISTINCT - Avoiding Duplicates in the Results	01:22

SQL DEVELOPER - Exploring a Schema
	1. Unlocking the HR Schema and Connecting	02:33
	2. Explore a Schema using SQL Developer	01:50

NULL VALUES
	1. NULL Values	02:38
	2. Retrieving NULL Values - IS NULL	01:33
	3. Retrieving NON-NULL Values - IS NOT NULL	00:55
	4. Arithmetic Operations on NULL Values	01:45
	5. Concatenation on NULL Values	02:25
	6. Substituting NULL Values in the Results	02:14

Restricting and Sorting Data
	1. Use the ORDER BY clause to sort SQL query results	02:10
	2. Sorting NULL Values and Expressions	01:59
	3. Positional and Composite Sorting	02:33
	4. Limiting the Rows with a WHERE clause	02:58
	5. Column based and Date based Conditions in WHERE clause	03:30

COMPARISON OPERATORS
	1. INEQUALITY OPERATORS - GREATER THAN & LESS THAN	02:27
	2. COMPOSITE INEQUALITY OPERATORS - GREATER/LESS THAN OR EQUAL TO	01:53
	3. COMPOSITE INEQUALITY OPERATORS -NOT EQUAL TO	01:46
	4. INEQUALITY OPERATORS ON DATE VALUES	01:39
	5. RANGE COMPARISON - BETWEEN OPERATOR	02:09
	6. SET COMPARISON - IN OPERATOR	02:03

PATTERN COMPARISON - LIKE OPERATOR
	1. LIKE OPERATOR - WITH WILDCARDS % AND _ (UNDERSCORE)	03:17
	2. LIKE OPERATOR - HANDS ON	05:03
	3. PATTERN COMPARISON - ESCAPE CHARACTER	03:12

BOOLEAN OR LOGICAL OPERATORS
	1. BOOLEAN or LOGICAL OPERATORS - CONCEPTS	02:28
	2. BOOLEAN OPERATOR - OR	04:51
	3. BOOLEAN OPERATOR - AND	02:35
	4. BOOLEAN OPERATOR - NOT	02:06
	5. BOOLEAN OPERATORS - HANDS ON DEMO	04:26

SUBSTITUTIONS - USING AMPERSANDS
	1. SUBSTITUTIONS - USING AMPERSANDS, DEFINING AND UNDEFINING THE VARIABLES	02:18
	2. SUBSTITUTIONS - DOUBLE AMPERSANDS	04:24

FUNCTIONS
	1. FUNCTIONS - INTRODUCTION	03:32
	2. NUMERICAL SINGLE ROW FUNCTIONS	05:49
	3. CHARACTER BASED SINGLE ROW FUNCTIONS	05:00
	4. CHARACTER FUNCTIONS WITH NUMERICAL RESULTS	02:14
	5. DATETIME FUNCTIONS INTRODUCTION	05:26
	6. DATE AND TIME FUNCTIONS - MORE FUNCTIONS	07:31
	7. DATE AND TIME FUNCTIONS - TO_DATE	03:05
	8. COMPARISON FUNCTIONS - GREATEST AND LEAST	01:25

AGGREGATE FUNCTIONS
	1. AGGREGATE FUNCTIONS - GROUPS and SUBGROUPS	04:03
	2. AGGREGATE FUNCTIONS - EXAMPLES	05:40
	3. FILTERING AGGREGATE FUNCTIONS - HAVING CLAUSE	02:26

CONDITIONAL FUNCTIONS
	1. CONDITIONAL FUNCTIONS - NVL, NVL2 and NULLIF	03:03
	2. CONDITIONAL FUNCTIONS - DECODE and CASE	02:17

DISPLAYING DATA FROM MULTIPLE TABLES - JOINS
	1. BASICS OF A JOIN - CARTESIAN PRODUCT OR CROSS JOIN	06:01
	2. BASICS OF A JOIN - AMBIGUOUS COLUMN NAMES	02:08
	3. DEMO - CARTESIAN PRODUCT OR CROSS JOIN	01:45
	4. DEMO - AMBIGUOUS COLUMN NAMES	02:16
	5. EQUIJOIN - OLD METHOD	02:32
	6. EQUIJOIN - NEW ANSI STANDARD - JOIN ON CLAUSE	02:02
	7. EQUIJOIN - NEW ANSI STANDARD - JOIN USING CLAUSE	04:05
	8. EQUIJOIN - NEW ANSI STANDARD - NATURAL JOIN CLAUSE	01:55
	9. NON-EQUIJOINS	01:56
	10. OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS	02:22
	11. DEMO - OUTER JOINS - LEFT, RIGHT and FULL OUTER JOINS	01:37

USING SUBQUERIES TO SOLVE QUERIES
	1. SUBQUERIES - DEFINITION AND SUBQUERY IN THE SELECT CLAUSE	02:57
	2. SUBQUERY - IN THE WHERE CLAUSE	03:23
	3. SUBQUERY - IN THE FROM CLAUSE	01:54
	4. SUBQUERY - IN DMLs - IN INSERT UPDATE DELETE	03:03

USING THE SET OPERATORS
	1. UNION - COMBINING ROWS FROM TWO QUERIES WITHOUT DUPLICATES	04:37
	2. UNION ALL - COMBINING ROWS FROM TWO QUERIES WITH DUPLICATES	02:43
	3. INTERSECT - FETCHING THE COMMON ROWS FROM THE RESULTS	01:53
	4. MINUS - FIRST RESULT SET MINUS SECOND RESULT SET	03:37

MANIPULATING DATA
	1. INSERT - VARIOUS METHODS OF INSERTING DATA	04:32
	2. UPDATE - VARIOUS METHODS OF UPDATING DATA	03:22
	3. DELETE - VARIOUS METHODS OF DELETING DATA	01:48

CONSTRAINTS
	1. NULL - DEFAULT	01:41
	2. NOT NULL CONSTRAINT	01:51
	3. UNIQUE CONSTRAINT	03:43
	4. PRIMARY KEY CONSTRAINT	02:39
	5. FOREIGN KEY CONSTRAINTS	05:18

ADDITIONAL KNOWLEDGE BASE - DATABASE OBJECTS, DBA ARTICLES, SCRIPTS etc
	1. INDEXES	02:11

About This Course

Over the years, the demand for database administrators has been growing steadily. As the demand for these professionals goes up, there is a need for relevant courses that equip the learners with knowledge and skills to carry out these very crucial tasks effectively. This Oracle training is designed to provide you with the skills related to relational databases and a programming language popular known as SQL. This course prepares you to pass the 1Z0-071 exam to obtain the Oracle certification. This is one of the tests required to receive any of the following credentials:

Oracle Database 11g Administrator Certified Associate
Oracle Database SQL Certified Associate
Oracle Database 12c Administrator Certified Associate
Oracle PL/SQL Developer Certified Associate

Description

This course is delivered by a qualified instructor through a series of videos. The topics are broken down into modules that are easy to understand. The areas covered by the training tutorial include basic concepts of relational databases, how to download and install Oracle database 12c, creating sorted and restricted data reports, managing schema objects, managing objects using data dictionary views, using set operators, and creating and querying external tables, among other things.

The course includes video lectures, scripts, practice test, and a number of other downloadable resources. The instructor also uses demos to explain points and concepts so that you can have a better understanding of what is expected. The practice tests will help you know what to expect in the actual exam. You’ll also manage to know the areas that you still need to work on. Practice with the questions as many times as you want until you are sure you have understood the concepts well.

Prerequisites

Understanding of SQL and PL/SQL would be useful
Knowledge of LINUX OS would be an added advantage

Course objectives

Understanding relational databases basic concepts
Creating sorted and restricted data reports
Running DML (Data Manipulation Statements)
Controlling database access only to specific objects
Managing schema objects
Managing objects using data dictionary views
Retrieving table row and column data
Controlling privileges at the system and object level
Creating and querying external tables

Exam details

Type of questions: multiple choice
Number of questions: 73
Duration: 100 minutes
Passing score: 63%
Certification validity: Oracle certifications do not expire, but you will be required to upgrade when the exam is retired

Target audience

Candidates preparing for the 1Z0-071 exam
Database administrators
Database designers
Support engineers
Technical administrators
Warehouse data administrators

Conclusion

This course is the best training for the 1Z0-071 exam. If you want to pass your test, then this is the right course to take. This is because it is created to ensure that you are prepared thoroughly for your exam. Passing your test qualifies you for the Oracle certification. With the credential, you can get some of the well-paid IT-based jobs.

Job titles:

Database administrator
Junior Oracle/SQL database administrator
Senior Oracle/SQL database administrator
Systems administrator
Oracle database consultant

These jobs will give you an average annual salary of up to $94,655.

Free 1z0-071 Exam Questions & Oracle 1z0-071 Dumps
Oracle.examsnap.1z0-071.v2024-10-24.by.holz.120q.ete	Downloads: 96	Size: 7.31 MB
Oracle.testking.1z0-071.v2019-05-28.by.ivan.112q.ete	Downloads: 2059	Size: 6.94 MB
Oracle.certkiller.1z0-071.v2019-03-13.by.earth.112q.ete	Downloads: 2112	Size: 6.94 MB
Oracle.certkiller.1z0-071.v2019-01-12.by.mustafa.85q.ete	Downloads: 2193	Size: 4.03 MB

Student Feedback

4.5

Good

49%

51 %

Comments * The most recent comment are at the top

Asher

South Africa

Nov 14, 2024

I liked everything about this Oracle Database SQL course. It was very detailed and precise. It covered all the concepts well. I never felt lost or bored at any point as I continued with the course. Thanks a lot.

Faith

Unknown country

Nov 04, 2024

This is a nice course. I managed to learn so many things about the SQL database administrator topics. Thanks for this course.

Kevin

India

Oct 23, 2024

Generally, the course was nice. The only challenge I got was that the instructor was a bit fast in some sections. It is good that the downloadable resources were available. I used the scripts to study and understand anything that I may have missed in the video lectures. Except for a few hitches here and there, I can say the course was good.

Hakeem

Taiwan

Oct 11, 2024

This is a great course. I’ve just finished studying, and everything was covered very well. I’m confident that I will pass my exam when the time comes.

Cooper

Vietnam

Sep 29, 2024

I appreciate all the efforts that it took to prepare this great course. It is detailed and covers all the objectives of the 1Z0-071 exam. I had gone through the objectives using a study guide. When I compare with what the course contains, I feel the course is precise and covers the laid down objectives.

Ian

Australia

Sep 20, 2024

I am half way the course and I like it so much. I hope the whole course is as good as it is at the beginning. The introduction has been done very well. I hope to prepare and pass my exam well.

Jace

Pakistan

Sep 06, 2024

I liked the course all the way from the beginning to the end. Everything flowed so well. The topics and the concepts have been explained clearly by the tutor. I appreciate everything about this course.

Chase

South Korea

Aug 26, 2024

I highly recommend this course for those who are preparing for the 1Z0-071 exam. The course is given in detail and the instructor does the explanations so well. Thanks also for the video lectures, practice test, and demos. Everything was covered so well.