Oracle Database 12c Administration

Wishlist Share
Share Course
Page Link
Share On Social Media

About Course

ORACLE  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 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 levels 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 to pass 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 this course is for:

  1. Students who want to be an expert in oracle database 12c.
  2. Students who want to be certified in 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
  • 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
  • Displaying Data from multiple tables using joins
  • Using Subqueries to Solve Queries
  • Retrieving data using the select statement / Restricting and Sorting Data
  • Substitution Variables

Course Content

Oracle Database 12c: Installation and Administration

  • Oracle 12c Database Full installation
    00:00
  • The Select Statement
    00:00
  • Using oracle flashback
    00:00
  • manipulating data-1
    00:00
  • Basics Oracle DB security
    00:00
  • Using DDL
    00:00
  • Restricting/ Sorting Data
    00:00
  • Query optim basics
    00:00
  • The data dictionary
    00:00
  • Creating other schema object-1
    00:00
  • manipulating data-2
    00:00
  • PL/SQL Basics
    00:00
  • Using Sub queries
    00:00
  • Using the set operators
    00:00
  • About SQL
    00:00
  • Creating other schema object-2
    00:00
  • Using single- row function
    00:00
  • Exam 1Z0-052 prep
    00:00
  • Referencing the oracle docs
    00:00
  • Displaying data from multi TBLS
    00:00
  • Aggregating data
    00:00

Student Ratings & Reviews

No Review Yet
No Review Yet