Курс Oracle Database 12c SQL Certified Associate 1Z0-071

4.6
4 611 комментариев
Payment
Обучение платное
Certificate
Сертификация бесплатная
Duration
20 часов курса
О курсе

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 starts from zero level 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 passing 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….

Программа
Introduction
Course Agenda
System Development Life Cycle & Database Definition
What is a Table?
Data Models & ERM
About Primary key & foreign key
SQL and Types of SQL Statements
Oracle Database 12c Architecture
HR Schema in this Course
Live SQL & Download/ Install
Oracle Live SQL / No Installation for anything
Oracle Live SQL limitation
Требования
  • This course start from zero knowledge to expert level.
  • Windows Operating system is preferred, but this is not mandatory if you have the knowledge of downloading Oracle database 12c on other OS.
  • Downloading oracle database and this will be covered in details on Windows OS.
  • No need for any prerequisite database skills, this course designed from Zero to certified level.
Что Вы изучите?
  • 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
Лекторы
Khaled Alkhudari
Khaled Alkhudari
Sr Oracle Developer/ Sr system analyst

My name is Khaled Al Khudari, I graduated
in 2003 in computer science.

I have more than 12 years’
experience in oracle development, I worked many projects with the best
companies in the world (Oracle, Microsoft, Ellucian , Etisalat  and many others )


I Have
Many Certifications ( OCA, OCP, Oracle ERP certifications and many others )


I have big experience in
Oracle ERP modules and data migration, and I have experience in Education system
like Banner, People soft  and desire to
learn .


I
believe in success through hard work & dedication.


My motto in life is: ‘If you want
something, work hard & you will achieve it; there are no short cuts’.

Платформа
Udemy
Курсы Udemy подойдут для профессионального развития. Платформа устроена таким образом, что эксперты сами запускают курсы. Все материалы передаются в пожизненный доступ. На этой платформе можно найти курс, без преувеличений, на любую тему – начиная от тьюториала по какой-то камере и заканчивая теоретическим курсом по управлению финансовыми рисками. Язык и формат обучения устанавливается преподавателем, поэтому стоит внимательно изучить информацию о курсе перед покупкой.
126.99 $ 194.99 $
Рейтинг
4.6
2 684
1 459
487
73
41