Oracle Database 12c SQL Certified Associate 1Z0-071

About Course

Oracle Database 12c SQL Certified Associate 1Z0-071. 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 begins at zero levels and progresses to expert levels. I promise that you will understand every single lesson in this course because it was designed in such a manner that you will not be bored during any of the lessons.

Simply watch the videos and do the exercises, and you can easily pass the test.

There’s no reason to waste time repeating all of the examples I used because all of the presentations and SQL scripts are attached to each segment.

Simply this course is the best….

Who this course is for:

Students who want to be an expert in oracle database 12c.
Students who want to be certified in the 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.

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

Course Content

Oracle Database 12c SQL Certified Associate

DBA Info Find the DBAs

00:00
Let us create a Data Model

00:00
Data Modeling Conceptual Model

00:00
Data Modeling Logical Model

00:00
Data Modeling Physical Model

00:00
ER Model Entity Attribute and TUPLE

00:00
ER Model vs ER Diagram

00:00
SELECT EVERYTHING

00:00
SELECT PARTICULAR COLUMNS

00:00
Filtering Data using WHERE clause

00:00
Data Modeling Introduction

00:00
DSS Decision Support System

00:00
OLTP Online Transaction Processing System

00:00
DDL CREATE

00:00
DDL ALTER

00:00
DDL DROP

00:00
DDL RENAME

00:00
DBA Info TRUNCATE vs DELETE

00:00
DDL TRUNCATE

00:00
DDL COMMENT

00:00
Demo of All the DDL STATEMENTS

00:00
Addressing the Objects

00:00
JOIN Two Tables

00:00
Exam Tip PROJECTION SELECTION and JOINING

00:00
Arithmetic Operations Order of Precedence

00:00
Changing the Order of Precedence using Parenthesis

00:00
Arithmetic Operations on Tables

00:00
Alias for Columns

00:00
Concatenation

00:00
Exception for Inner Single Quotes

00:00
Replacing the quote Delimiters

00:00
DISTINCT Avoiding Duplicates in the Results

00:00
Unlocking HR Schema and Connecting as HR

00:00
Arithmetic Multiplication and Division

00:00
Dual Examples

00:00
Arithmetic Operations Addition and Subtraction

00:00
Mandatory and Optional Clauses – SELECT

00:00
Reserved Words

00:00
Lower and Upper Case in SQL Statements

00:00
SQL Statement Terminators

00:00
Structure of a Table DESCRIBE COMMAND

00:00
SELECT EVERYTHING

00:00
Find the Total Number of Rows

00:00
To Quote or Not To Quote

00:00
Dual

00:00
Oracle SQL

00:00
DCL GRANTS and REVOKES Full Demo

00:00
Introduction

00:00
Basics of a SELECT statement

00:00
Describe

00:00
SELECT COUNT

00:00
DBA Info DBA TABLESPACES

00:00
Selecting Particular Columns

00:00
Filtering the results Basic WHERE Clause

00:00
Oracle Databae User Architecture

00:00
Schema vs User

00:00
How objects are stored

00:00
Data type

00:00
What is a Table

00:00
Starting an Oracle Database

00:00
Installing Oracle 12c in Windows 10

00:00
Using SQL Developer

00:00
Connection Troubleshooting

00:00
Client Server Architecture

00:00
Types of Clients

00:00
Quick overview of Oracle RDBMS Architecture

00:00
Connecting to an Oracle Database

00:00
Connecting as a SYSDBA – Lab

00:00
Stopping an Oracle Database

00:00
Accessing the Objects

00:00
SQL Commands Classification

00:00
TCL COMMIT

00:00
TCL COMMIT Demo

00:00
TCL ROLLBACK

00:00
TCL SAVEPOINT

00:00
TCL SAVEPOINT Demo

00:00
DCL GRANT

00:00
DCL System Privileges

00:00
DCL Object Privileges

00:00
DCL Role Privileges

00:00
Handling a Transaction UNDO

00:00
Handling a Transaction through REDO

00:00
Demo of a Transaction

00:00
Create a Table

00:00
Create an User

00:00
Basics of DML

00:00
DML SELECT

00:00
DML INSERT

00:00
DBA Info MetaData

00:00
DBA Info Data Dictionary

00:00
DBA Info Default Permanent Tablespace

00:00
DML Fixing the failed INSERT

00:00
DCL REVOKE

00:00

Student Ratings & Reviews

No Review Yet

About Course

Oracle Database 12c SQL Certified Associate 1Z0-071. ORACLE is database number one in the world.

Who this course is for:

What Will You Learn?

Course Content

Oracle Database 12c SQL Certified Associate

DBA Info Find the DBAs

Let us create a Data Model

Data Modeling Conceptual Model

Data Modeling Logical Model

Data Modeling Physical Model

ER Model Entity Attribute and TUPLE

ER Model vs ER Diagram

SELECT EVERYTHING

SELECT PARTICULAR COLUMNS

Filtering Data using WHERE clause

Data Modeling Introduction

DSS Decision Support System

OLTP Online Transaction Processing System

DDL CREATE

DDL ALTER

DDL DROP

DDL RENAME

DBA Info TRUNCATE vs DELETE

DDL TRUNCATE

DDL COMMENT

Demo of All the DDL STATEMENTS

Addressing the Objects

JOIN Two Tables

Exam Tip PROJECTION SELECTION and JOINING

Arithmetic Operations Order of Precedence

Changing the Order of Precedence using Parenthesis

Arithmetic Operations on Tables

Alias for Columns

Concatenation

Exception for Inner Single Quotes

Replacing the quote Delimiters

DISTINCT Avoiding Duplicates in the Results

Unlocking HR Schema and Connecting as HR

Arithmetic Multiplication and Division

Dual Examples

Arithmetic Operations Addition and Subtraction

Mandatory and Optional Clauses – SELECT

Reserved Words

Lower and Upper Case in SQL Statements

SQL Statement Terminators

Structure of a Table DESCRIBE COMMAND

SELECT EVERYTHING

Find the Total Number of Rows

To Quote or Not To Quote

Dual

Oracle SQL

DCL GRANTS and REVOKES Full Demo

Introduction

Basics of a SELECT statement

Describe

SELECT COUNT

DBA Info DBA TABLESPACES

Selecting Particular Columns

Filtering the results Basic WHERE Clause

Oracle Databae User Architecture

Schema vs User

How objects are stored

Data type

What is a Table

Starting an Oracle Database

Installing Oracle 12c in Windows 10

Using SQL Developer

Connection Troubleshooting

Client Server Architecture

Types of Clients

Quick overview of Oracle RDBMS Architecture

Connecting to an Oracle Database

Connecting as a SYSDBA – Lab

Stopping an Oracle Database

Accessing the Objects

SQL Commands Classification

TCL COMMIT

TCL COMMIT Demo

TCL ROLLBACK