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.
Course Content
Oracle Database 12c SQL Certified Associate
-
Introduction
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 -
Starting an Oracle Database
00:00 -
What is a Table
00:00 -
Data type
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 -
Accessing the Objects
00:00 -
SQL Commands Classification
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 -
Demo of a Transaction
00:00 -
Handling a Transaction through REDO
00:00 -
Handling a Transaction UNDO
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 -
DCL REVOKE
00:00 -
DCL GRANTS and REVOKES Full Demo
00:00 -
DBA Info Find the DBAs
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 -
OLTP Online Transaction Processing System
00:00 -
DSS Decision Support System
00:00 -
Data Modeling Introduction
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 -
JOIN Two Tables
00:00 -
Exam Tip PROJECTION SELECTION and JOINING
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 -
Arithmetic Operations Addition and Subtraction
00:00 -
Dual Examples
00:00 -
Arithmetic Multiplication and Division
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 -
Oracle SQL
00:00