Oracle Database 12c SQL Certified Associate 1Z0-071

Wishlist Share
Share Course
Page Link
Share On Social Media

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:

  1. Students who want to be an expert in oracle database 12c.
  2. Students who want to be certified in the oracle database from Oracle University.
  3. Fresh IT students who need strong SQL and database knowledge.
  4. Fresh and junior programmers who need to find better jobs by gaining Oracle certification.
Show More

What Will You 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

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

Student Ratings & Reviews

No Review Yet
No Review Yet